7PHDA7Mw

1
2			Openbravo 		Viewing file: 20100508155914-apply.log 	
3		
4	
5	
6	
7	
8		
9	
10		
11		
12
13apply.modules:
14
15set.code.rev:
16
17code.rev:
18
19init:
20
21core.lib:
22
23init:
24
25compile:
26
27build.jar:
28[jar] Building jar: /opt/OpenbravoERP-2.50/openbravo-erp/src-core/lib/openbravo-core.jar
29
30build:
31
32copy.core.lib:
33[copy] Copying 1 file to /opt/OpenbravoERP-2.50/openbravo-erp/lib/runtime
34
35database.lib:
36
37init:
38
39compile:
40
41build.jar:
42[jar] Building jar: /opt/OpenbravoERP-2.50/openbravo-erp/src-db/build/lib/dbmanager.jar
43
44jar:
45[copy] Copying 1 file to /opt/OpenbravoERP-2.50/openbravo-erp/src-db/database/lib
46
47update.database.mod:
48
49update.database.mod.java:
50[java] 0 INFO - Database connection: jdbc:oracle:thin:@localhost:1521:oraerp. User: tad
51[java] 5917 INFO - Creating submodel for application dictionary
52[java] 16459 INFO - Loading data from XML files
53[java] 21788 INFO - Loading and applying configuration scripts
54[java] Checking if database structure was modified locally.
55[java] Checking if data has changed in the application dictionary.
56[java] 25891 INFO - Updating module: rwt.erp.soya
57[java] 25899 INFO - Loading submodel from database...
58[java] 25909 INFO - Reading tables...
59[java] 30499 INFO - Reading views...
60[java] 30539 INFO - Reading sequences...
61[java] 30551 INFO - Reading triggers...
62[java] 30843 INFO - Reading functions...
63[java] 30923 INFO - Sorting foreign keys, indexes and checks...
64[java] 30927 INFO - Submodel loaded
65[java] 52187 INFO - Updating database model...
66[java] 295008 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
67[java]
68[java] 295054 WARN - -- END
69[java] -- -----------------------------------------------------------------------
70[java] -- TRIGGER RWT_AGENT_BILL_LINE_TRG2
71[java] -- -----------------------------------------------------------------------
72[java] CREATE TRIGGER RWT_AGENT_BILL_LINE_TRG2
73[java] AFTER INSERT OR UPDATE OR DELETE
74[java] ON RWT_AGENT_BILL_LINE FOR EACH ROW
75[java] DECLAREBEGIN IF (inserting) THEN
76[java] UPDATE
77[java] rwt_Agent_Bill
78[java] SET
79[java] rwt_recstatus='0'
80[java] WHERE
81[java] rwt_Agent_Bill_id=:new.rwt_Agent_Bill_id;
82[java] END IF;
83[java] IF (updating) THEN
84[java] UPDATE
85[java] rwt_Agent_Bill
86[java] SET
87[java] rwt_recstatus='0'
88[java] WHERE
89[java] rwt_Agent_Bill_id=:new.rwt_Agent_Bill_id;
90[java] END IF;
91[java] END;
92[java] 295104 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
93[java]
94[java] 295109 WARN - -- END
95[java] -- -----------------------------------------------------------------------
96[java] -- TRIGGER RWT_AGENT_BILL_TAX_TRG2
97[java] -- -----------------------------------------------------------------------
98[java] CREATE TRIGGER RWT_AGENT_BILL_TAX_TRG2
99[java] AFTER INSERT OR UPDATE OR DELETE
100[java] ON RWT_AGENT_BILL_TAX FOR EACH ROW
101[java] DECLAREBEGIN IF (inserting) THEN
102[java] UPDATE
103[java] rwt_Agent_Bill
104[java] SET
105[java] rwt_recstatus='0'
106[java] WHERE
107[java] rwt_Agent_Bill_id=:new.rwt_Agent_Bill_id;
108[java] END IF;
109[java] IF (updating) THEN
110[java] UPDATE
111[java] rwt_Agent_Bill
112[java] SET
113[java] rwt_recstatus='0'
114[java] WHERE
115[java] rwt_Agent_Bill_id=:new.rwt_Agent_Bill_id;
116[java] END IF;
117[java] END;
118[java] 295649 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
119[java]
120[java] 295654 WARN - -- END
121[java] -- -----------------------------------------------------------------------
122[java] -- TRIGGER RWT_BANKRECON_LINE_TRG2
123[java] -- -----------------------------------------------------------------------
124[java] CREATE TRIGGER RWT_BANKRECON_LINE_TRG2
125[java] AFTER INSERT OR UPDATE OR DELETE
126[java] ON RWT_BANKRECON_LINE FOR EACH ROW
127[java] DECLAREBEGIN
128[java] IF (INSERTING) THEN
129[java] UPDATE RWT_BANKRECON SET RWT_RECSTATUS='0' WHERE RWT_BANKRECON_ID=:NEW.RWT_BANKRECON_ID;
130[java] END IF;
131[java] IF (UPDATING) THEN
132[java] UPDATE RWT_BANKRECON SET RWT_RECSTATUS='0' WHERE RWT_BANKRECON_ID=:NEW.RWT_BANKRECON_ID;
133[java] END IF;
134[java] END;
135[java] 295704 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
136[java]
137[java] 295721 WARN - -- END
138[java] -- -----------------------------------------------------------------------
139[java] -- TRIGGER RWT_BANKRECON_NONINSTR_TRG2
140[java] -- -----------------------------------------------------------------------
141[java] CREATE TRIGGER RWT_BANKRECON_NONINSTR_TRG2
142[java] AFTER INSERT OR UPDATE OR DELETE
143[java] ON RWT_BANKRECON_NONINSTR FOR EACH ROW
144[java] DECLAREBEGIN
145[java] IF (INSERTING) THEN
146[java] UPDATE RWT_BANKRECON SET RWT_RECSTATUS='0' WHERE RWT_BANKRECON_ID=:NEW.RWT_BANKRECON_ID;
147[java] END IF;
148[java] IF (UPDATING) THEN
149[java] UPDATE RWT_BANKRECON SET RWT_RECSTATUS='0' WHERE RWT_BANKRECON_ID=:NEW.RWT_BANKRECON_ID;
150[java] END IF;
151[java] END;
152[java] 296151 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
153[java]
154[java] 296156 WARN - -- END
155[java] -- -----------------------------------------------------------------------
156[java] -- TRIGGER RWT_BPARTNER_TRG2
157[java] -- -----------------------------------------------------------------------
158[java] CREATE TRIGGER RWT_BPARTNER_TRG2
159[java] AFTER DELETE
160[java] ON RWT_BPARTNER FOR EACH ROW
161[java] DECLAREdeclare v_retval integer;
162[java] --pragma autonomous_transaction;
163[java] BEGIN
164[java] v_retval := 0;
165[java] /*
166[java] IF (DELETING) THEN
167[java] select count(*) into v_retval from rwt_gl_head where glcode = :old.partycode and rwt_recstatus='2';
168[java] IF v_retval > 0 THEN
169[java] RAISE_APPLICATION_ERROR (-20558, 'The Ledger Head For The Selected Party Need To Be In Unlocked Status Before Deleting The Party''s Record');
170[java] END IF;
171[java] delete from rwt_gl_head where rwt_gl_head_id = :new.rwt_gl_head_id;
172[java] END IF;
173[java] */
174[java] END;
175[java] 297192 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
176[java]
177[java] 297200 WARN - -- END
178[java] -- -----------------------------------------------------------------------
179[java] -- TRIGGER RWT_CHACONTRACTBILL_LINE_TRG2
180[java] -- -----------------------------------------------------------------------
181[java] CREATE TRIGGER RWT_CHACONTRACTBILL_LINE_TRG2
182[java] AFTER INSERT OR UPDATE OR DELETE
183[java] ON RWT_CHA_CONTRACT_BILL_LINE FOR EACH ROW
184[java] DECLAREBEGIN IF (inserting) THEN
185[java] UPDATE
186[java] RWT_cha_contract_bill
187[java] SET
188[java] rwt_recstatus='0'
189[java] WHERE
190[java] RWT_cha_contract_bill_id=:new.RWT_cha_contract_bill_id;
191[java] END IF;
192[java] IF (updating) THEN
193[java] UPDATE
194[java] RWT_cha_contract_bill
195[java] SET
196[java] rwt_recstatus='0'
197[java] WHERE
198[java] RWT_cha_contract_bill_id=:new.RWT_cha_contract_bill_id;
199[java] END IF;
200[java] END;
201[java] 297265 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
202[java]
203[java] 297273 WARN - -- END
204[java] -- -----------------------------------------------------------------------
205[java] -- TRIGGER RWT_CHACONTRACT_LINE_TRG2
206[java] -- -----------------------------------------------------------------------
207[java] CREATE TRIGGER RWT_CHACONTRACT_LINE_TRG2
208[java] AFTER INSERT OR UPDATE OR DELETE
209[java] ON RWT_CHACONTRACT_LINE FOR EACH ROW
210[java] DECLAREBEGIN IF (inserting) THEN
211[java] UPDATE
212[java] RWT_Chacontract
213[java] SET
214[java] rwt_recstatus='0'
215[java] WHERE
216[java] RWT_Chacontract_id=:new.RWT_Chacontract_id;
217[java] END IF;
218[java] IF (updating) THEN
219[java] UPDATE
220[java] RWT_Chacontract
221[java] SET
222[java] rwt_recstatus='0'
223[java] WHERE
224[java] RWT_Chacontract_id=:new.RWT_Chacontract_id;
225[java] END IF;
226[java] END;
227[java] 297412 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
228[java]
229[java] 297416 WARN - -- END
230[java] -- -----------------------------------------------------------------------
231[java] -- TRIGGER RWT_CHA_BPA_TAX_TRG2
232[java] -- -----------------------------------------------------------------------
233[java] CREATE TRIGGER RWT_CHA_BPA_TAX_TRG2
234[java] AFTER INSERT OR UPDATE OR DELETE
235[java] ON RWT_CHA_BPA_TAX FOR EACH ROW
236[java] DECLAREBEGIN IF (inserting) THEN
237[java] UPDATE
238[java] RWT_cha_contract_bill
239[java] SET
240[java] rwt_recstatus='0'
241[java] WHERE
242[java] RWT_cha_contract_bill_id=:new.RWT_cha_contract_bill_id;
243[java] END IF;
244[java] IF (updating) THEN
245[java] UPDATE
246[java] RWT_cha_contract_bill
247[java] SET
248[java] rwt_recstatus='0'
249[java] WHERE
250[java] RWT_cha_contract_bill_id=:new.RWT_cha_contract_bill_id;
251[java] END IF;
252[java] END;
253[java] 297535 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
254[java]
255[java] 297543 WARN - -- END
256[java] -- -----------------------------------------------------------------------
257[java] -- TRIGGER RWT_COEP_QLTY_SPEC_TRG2
258[java] -- -----------------------------------------------------------------------
259[java] CREATE TRIGGER RWT_COEP_QLTY_SPEC_TRG2
260[java] AFTER INSERT OR UPDATE OR DELETE
261[java] ON RWT_COEP_QLTY_SPEC FOR EACH ROW
262[java] DECLAREBEGIN IF (inserting) THEN
263[java] UPDATE RWT_Coep SET rwt_recstatus='0' WHERE RWT_Coep_id=:new.RWT_Coep_id;
264[java] END IF;
265[java] IF (updating) THEN
266[java] UPDATE RWT_Coep SET rwt_recstatus='0' WHERE RWT_Coep_id=:new.RWT_Coep_id;
267[java] END IF;
268[java] END;
269[java] 297602 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
270[java]
271[java] 297616 WARN - -- END
272[java] -- -----------------------------------------------------------------------
273[java] -- TRIGGER RWT_COEP_SALES_CONT_REL_TRG2
274[java] -- -----------------------------------------------------------------------
275[java] CREATE TRIGGER RWT_COEP_SALES_CONT_REL_TRG2
276[java] AFTER INSERT OR UPDATE OR DELETE
277[java] ON RWT_COEP_SALES_CONT_REL FOR EACH ROW
278[java] DECLAREBEGIN IF (inserting) THEN
279[java] UPDATE RWT_Coep SET rwt_recstatus='0' WHERE RWT_Coep_id=:new.RWT_Coep_id;
280[java] END IF;
281[java] IF (updating) THEN
282[java] UPDATE RWT_Coep SET rwt_recstatus='0' WHERE RWT_Coep_id=:new.RWT_Coep_id;
283[java] END IF;
284[java] END;
285[java] 297979 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
286[java]
287[java] 297986 WARN - -- END
288[java] -- -----------------------------------------------------------------------
289[java] -- TRIGGER RWT_CREDIT_NOTE_ACCT_TRG2
290[java] -- -----------------------------------------------------------------------
291[java] CREATE TRIGGER RWT_CREDIT_NOTE_ACCT_TRG2
292[java] AFTER INSERT OR UPDATE OR DELETE
293[java] ON RWT_CREDIT_NOTE_ACCT FOR EACH ROW
294[java] DECLAREBEGIN
295[java] IF (INSERTING) THEN
296[java] UPDATE RWT_CREDIT_NOTE SET RWT_RECSTATUS='0' WHERE RWT_CREDIT_NOTE_ID=:NEW.RWT_CREDIT_NOTE_ID;
297[java] END IF;
298[java] IF (UPDATING) THEN
299[java] UPDATE RWT_CREDIT_NOTE SET RWT_RECSTATUS='0' WHERE RWT_CREDIT_NOTE_ID=:NEW.RWT_CREDIT_NOTE_ID;
300[java] END IF;
301[java] END;
302[java] 297993 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
303[java]
304[java] 297998 WARN - -- END
305[java] -- -----------------------------------------------------------------------
306[java] -- TRIGGER RWT_CREDIT_NOTE_LINES_TRG2
307[java] -- -----------------------------------------------------------------------
308[java] CREATE TRIGGER RWT_CREDIT_NOTE_LINES_TRG2
309[java] AFTER INSERT OR UPDATE OR DELETE
310[java] ON RWT_CREDIT_NOTE_LINES FOR EACH ROW
311[java] DECLAREBEGIN
312[java] IF (INSERTING) THEN
313[java] UPDATE RWT_CREDIT_NOTE SET RWT_RECSTATUS='0' WHERE RWT_CREDIT_NOTE_ID=:NEW.RWT_CREDIT_NOTE_ID;
314[java] END IF;
315[java] IF (UPDATING) THEN
316[java] UPDATE RWT_CREDIT_NOTE SET RWT_RECSTATUS='0' WHERE RWT_CREDIT_NOTE_ID=:NEW.RWT_CREDIT_NOTE_ID;
317[java] END IF;
318[java] END;
319[java] 298005 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
320[java]
321[java] 298010 WARN - -- END
322[java] -- -----------------------------------------------------------------------
323[java] -- TRIGGER RWT_CREDIT_NOTE_MAT_LINES_TRG2
324[java] -- -----------------------------------------------------------------------
325[java] CREATE TRIGGER RWT_CREDIT_NOTE_MAT_LINES_TRG2
326[java] AFTER INSERT OR UPDATE OR DELETE
327[java] ON RWT_CREDIT_NOTE_MAT_LINES FOR EACH ROW
328[java] DECLAREBEGIN
329[java] IF (INSERTING) THEN
330[java] UPDATE RWT_CREDIT_NOTE SET RWT_RECSTATUS='0' WHERE RWT_CREDIT_NOTE_ID=:NEW.RWT_CREDIT_NOTE_ID;
331[java] END IF;
332[java] IF (UPDATING) THEN
333[java] UPDATE RWT_CREDIT_NOTE SET RWT_RECSTATUS='0' WHERE RWT_CREDIT_NOTE_ID=:NEW.RWT_CREDIT_NOTE_ID;
334[java] END IF;
335[java] END;
336[java] 298303 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
337[java]
338[java] 298310 WARN - -- END
339[java] -- -----------------------------------------------------------------------
340[java] -- TRIGGER RWT_DEBIT_NOTE_ACCT_TRG2
341[java] -- -----------------------------------------------------------------------
342[java] CREATE TRIGGER RWT_DEBIT_NOTE_ACCT_TRG2
343[java] AFTER INSERT OR UPDATE OR DELETE
344[java] ON RWT_DEBIT_NOTE_ACCT FOR EACH ROW
345[java] DECLAREBEGIN
346[java] IF (INSERTING) THEN
347[java] UPDATE RWT_DEBIT_NOTE SET RWT_RECSTATUS='0' WHERE RWT_DEBIT_NOTE_ID=:NEW.RWT_DEBIT_NOTE_ID;
348[java] END IF;
349[java] IF (UPDATING) THEN
350[java] UPDATE RWT_DEBIT_NOTE SET RWT_RECSTATUS='0' WHERE RWT_DEBIT_NOTE_ID=:NEW.RWT_DEBIT_NOTE_ID;
351[java] END IF;
352[java] END;
353[java] 298323 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
354[java]
355[java] 298331 WARN - -- END
356[java] -- -----------------------------------------------------------------------
357[java] -- TRIGGER RWT_DEBIT_NOTE_LINES_TRG2
358[java] -- -----------------------------------------------------------------------
359[java] CREATE TRIGGER RWT_DEBIT_NOTE_LINES_TRG2
360[java] AFTER INSERT OR UPDATE OR DELETE
361[java] ON RWT_DEBIT_NOTE_LINES FOR EACH ROW
362[java] DECLAREBEGIN
363[java] IF (INSERTING) THEN
364[java] UPDATE RWT_DEBIT_NOTE SET RWT_RECSTATUS='0' WHERE RWT_DEBIT_NOTE_ID=:NEW.RWT_DEBIT_NOTE_ID;
365[java] END IF;
366[java] IF (UPDATING) THEN
367[java] UPDATE RWT_DEBIT_NOTE SET RWT_RECSTATUS='0' WHERE RWT_DEBIT_NOTE_ID=:NEW.RWT_DEBIT_NOTE_ID;
368[java] END IF;
369[java] END;
370[java] 298339 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
371[java]
372[java] 298354 WARN - -- END
373[java] -- -----------------------------------------------------------------------
374[java] -- TRIGGER RWT_DEBIT_NOTE_MAT_LINES_TRG2
375[java] -- -----------------------------------------------------------------------
376[java] CREATE TRIGGER RWT_DEBIT_NOTE_MAT_LINES_TRG2
377[java] AFTER INSERT OR UPDATE OR DELETE
378[java] ON RWT_DEBIT_NOTE_MAT_LINES FOR EACH ROW
379[java] DECLAREBEGIN
380[java] IF (INSERTING) THEN
381[java] UPDATE RWT_DEBIT_NOTE SET RWT_RECSTATUS='0' WHERE RWT_DEBIT_NOTE_ID=:NEW.RWT_DEBIT_NOTE_ID;
382[java] END IF;
383[java] IF (UPDATING) THEN
384[java] UPDATE RWT_DEBIT_NOTE SET RWT_RECSTATUS='0' WHERE RWT_DEBIT_NOTE_ID=:NEW.RWT_DEBIT_NOTE_ID;
385[java] END IF;
386[java] END;
387[java] 298448 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
388[java]
389[java] 298453 WARN - -- END
390[java] -- -----------------------------------------------------------------------
391[java] -- TRIGGER RWT_DELIVERY_ORDER_DETAIL_TRG2
392[java] -- -----------------------------------------------------------------------
393[java] CREATE TRIGGER RWT_DELIVERY_ORDER_DETAIL_TRG2
394[java] AFTER INSERT OR UPDATE OR DELETE
395[java] ON RWT_DELIVERY_ORDER_DETAIL FOR EACH ROW
396[java] DECLAREBEGIN IF (inserting) THEN
397[java] UPDATE
398[java] RWT_Delivery_Order
399[java] SET
400[java] rwt_recstatus='0'
401[java] WHERE
402[java] RWT_Delivery_Order_id=:new.RWT_Delivery_Order_id;
403[java] END IF;
404[java] IF (updating) THEN
405[java] UPDATE
406[java] RWT_Delivery_Order
407[java] SET
408[java] rwt_recstatus='0'
409[java] WHERE
410[java] RWT_Delivery_Order_id=:new.RWT_Delivery_Order_id;
411[java] END IF;
412[java] END;
413[java] 298865 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
414[java]
415[java] 298873 WARN - -- END
416[java] -- -----------------------------------------------------------------------
417[java] -- TRIGGER RWT_DEPRECIATION_LINE_TRG2
418[java] -- -----------------------------------------------------------------------
419[java] CREATE TRIGGER RWT_DEPRECIATION_LINE_TRG2
420[java] AFTER INSERT OR UPDATE OR DELETE
421[java] ON RWT_DEPRECIATION_LINE FOR EACH ROW
422[java] DECLAREBEGIN IF (inserting) THEN
423[java] UPDATE
424[java] RWT_Depreciation
425[java] SET
426[java] rwt_recstatus='0'
427[java] WHERE
428[java] RWT_Depreciation_id=:new.RWT_Depreciation_id;
429[java] END IF;
430[java] IF (updating) THEN
431[java] UPDATE
432[java] RWT_Depreciation
433[java] SET
434[java] rwt_recstatus='0'
435[java] WHERE
436[java] RWT_Depreciation_id=:new.RWT_Depreciation_id;
437[java] END IF;
438[java] END;
439[java] 299369 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
440[java]
441[java] 299374 WARN - -- END
442[java] -- -----------------------------------------------------------------------
443[java] -- TRIGGER RWT_EMP_DETAILS_TRG2
444[java] -- -----------------------------------------------------------------------
445[java] CREATE TRIGGER RWT_EMP_DETAILS_TRG2
446[java] AFTER INSERT OR UPDATE OR DELETE
447[java] ON RWT_EMP_DETAILS FOR EACH ROW
448[java] DECLAREBEGIN IF (inserting) THEN
449[java] UPDATE
450[java] RWT_Bp_Emp
451[java] SET
452[java] rwt_recstatus='0'
453[java] WHERE
454[java] RWT_Bp_Emp_id=:new.RWT_Bp_Emp_id;
455[java] END IF;
456[java] IF (updating) THEN
457[java] UPDATE
458[java] RWT_Bp_Emp
459[java] SET
460[java] rwt_recstatus='0'
461[java] WHERE
462[java] RWT_Bp_Emp_id=:new.RWT_Bp_Emp_id;
463[java] END IF;
464[java] END;
465[java] 300736 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
466[java]
467[java] 300741 WARN - -- END
468[java] -- -----------------------------------------------------------------------
469[java] -- TRIGGER RWT_GL_TYPE_REL_TRG2
470[java] -- -----------------------------------------------------------------------
471[java] CREATE TRIGGER RWT_GL_TYPE_REL_TRG2
472[java] AFTER INSERT OR UPDATE OR DELETE
473[java] ON RWT_GL_TYPE_REL FOR EACH ROW
474[java] DECLAREBEGIN
475[java] IF (INSERTING) THEN
476[java] UPDATE RWT_GL_HEAD SET RWT_RECSTATUS='0' WHERE RWT_GL_HEAD_ID=:NEW.RWT_GL_HEAD_ID;
477[java] END IF;
478[java] IF (UPDATING) THEN
479[java] UPDATE RWT_GL_HEAD SET RWT_RECSTATUS='0' WHERE RWT_GL_HEAD_ID=:NEW.RWT_GL_HEAD_ID;
480[java] END IF;
481[java] END;
482[java] 301049 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
483[java]
484[java] 301054 WARN - -- END
485[java] -- -----------------------------------------------------------------------
486[java] -- TRIGGER RWT_HANDLING_CONTRACT_MAT_TRG2
487[java] -- -----------------------------------------------------------------------
488[java] CREATE TRIGGER RWT_HANDLING_CONTRACT_MAT_TRG2
489[java] AFTER INSERT OR UPDATE OR DELETE
490[java] ON RWT_HANDLING_CONTRACT_MAT FOR EACH ROW
491[java] DECLAREBEGIN IF (inserting) THEN
492[java] UPDATE
493[java] RWT_HANDLING_CONtract
494[java] SET
495[java] rwt_recstatus='0'
496[java] WHERE
497[java] RWT_HANDLING_CONtract_id=:new.RWT_HANDLING_CONtract_id;
498[java] END IF;
499[java] IF (updating) THEN
500[java] UPDATE
501[java] RWT_HANDLING_CONtract
502[java] SET
503[java] rwt_recstatus='0'
504[java] WHERE
505[java] RWT_HANDLING_CONtract_id=:new.RWT_HANDLING_CONtract_id;
506[java] END IF;
507[java] END;
508[java] 301128 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
509[java]
510[java] 301133 WARN - -- END
511[java] -- -----------------------------------------------------------------------
512[java] -- TRIGGER RWT_HAND_CONT_BILL_LINE_TRG2
513[java] -- -----------------------------------------------------------------------
514[java] CREATE TRIGGER RWT_HAND_CONT_BILL_LINE_TRG2
515[java] AFTER INSERT OR UPDATE OR DELETE
516[java] ON RWT_HAND_CONT_BILL_LINE FOR EACH ROW
517[java] DECLAREBEGIN
518[java] IF (INSERTING) THEN
519[java] UPDATE RWT_HANDLING_CONT_BILL SET RWT_RECSTATUS='0' WHERE RWT_HANDLING_CONT_BILL_ID=:NEW.RWT_HANDLING_CONT_BILL_ID;
520[java] END IF;
521[java] IF (UPDATING) THEN
522[java] UPDATE RWT_HANDLING_CONT_BILL SET RWT_RECSTATUS='0' WHERE RWT_HANDLING_CONT_BILL_ID=:NEW.RWT_HANDLING_CONT_BILL_ID;
523[java] END IF;
524[java] END;
525[java] 301577 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
526[java]
527[java] 301581 WARN - -- END
528[java] -- -----------------------------------------------------------------------
529[java] -- TRIGGER RWT_INS_DECL_LINE_TRG2
530[java] -- -----------------------------------------------------------------------
531[java] CREATE TRIGGER RWT_INS_DECL_LINE_TRG2
532[java] AFTER INSERT OR UPDATE OR DELETE
533[java] ON RWT_INS_DECL_LINE FOR EACH ROW
534[java] DECLAREBEGIN IF (inserting) THEN
535[java] UPDATE
536[java] RWT_INS_DECLARATION
537[java] SET
538[java] RWT_RECSTATUS='0'
539[java] WHERE
540[java] RWT_INS_DECLARATION_id=:NEW.RWT_INS_DECLARATION_id;
541[java] END IF;
542[java] IF (updating) THEN
543[java] UPDATE
544[java] RWT_INS_DECLARATION
545[java] SET
546[java] RWT_RECSTATUS='0'
547[java] WHERE
548[java] RWT_INS_DECLARATION_id=:NEW.RWT_INS_DECLARATION_id;
549[java] END IF;
550[java] END;
551[java] 301633 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
552[java]
553[java] 301638 WARN - -- END
554[java] -- -----------------------------------------------------------------------
555[java] -- TRIGGER RWT_INS_POL_COVERAGE_TRG2
556[java] -- -----------------------------------------------------------------------
557[java] CREATE TRIGGER RWT_INS_POL_COVERAGE_TRG2
558[java] AFTER INSERT OR UPDATE OR DELETE
559[java] ON RWT_INS_POL_COVERAGE FOR EACH ROW
560[java] DECLAREBEGIN IF (inserting) THEN
561[java] UPDATE
562[java] RWT_Insurance_Policy
563[java] SET
564[java] RWT_RECSTATUS='0'
565[java] WHERE
566[java] RWT_Insurance_Policy_id=:NEW.RWT_Insurance_Policy_id;
567[java] END IF;
568[java] IF (updating) THEN
569[java] UPDATE
570[java] RWT_Insurance_Policy
571[java] SET
572[java] RWT_RECSTATUS='0'
573[java] WHERE
574[java] RWT_Insurance_Policy_id=:NEW.RWT_Insurance_Policy_id;
575[java] END IF;
576[java] END;
577[java] 301865 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
578[java]
579[java] 301870 WARN - -- END
580[java] -- -----------------------------------------------------------------------
581[java] -- TRIGGER RWT_INS_REQ_LINE_TRG2
582[java] -- -----------------------------------------------------------------------
583[java] CREATE TRIGGER RWT_INS_REQ_LINE_TRG2
584[java] AFTER INSERT OR UPDATE OR DELETE
585[java] ON RWT_INS_REQ_LINE FOR EACH ROW
586[java] DECLAREBEGIN IF (inserting) THEN
587[java] UPDATE
588[java] RWT_INS_REQUISITION
589[java] SET
590[java] RWT_RECSTATUS='0'
591[java] WHERE
592[java] RWT_INS_REQUISITION_id=:NEW.RWT_INS_REQUISITION_id;
593[java] END IF;
594[java] IF (updating) THEN
595[java] UPDATE
596[java] RWT_INS_REQUISITION
597[java] SET
598[java] RWT_RECSTATUS='0'
599[java] WHERE
600[java] RWT_INS_REQUISITION_id=:NEW.RWT_INS_REQUISITION_id;
601[java] END IF;
602[java] END;
603[java] 301922 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
604[java]
605[java] 301926 WARN - -- END
606[java] -- -----------------------------------------------------------------------
607[java] -- TRIGGER RWT_INS_TYPE_WISE_HEAD_TRG2
608[java] -- -----------------------------------------------------------------------
609[java] CREATE TRIGGER RWT_INS_TYPE_WISE_HEAD_TRG2
610[java] AFTER INSERT OR UPDATE OR DELETE
611[java] ON RWT_INS_TYPE_WISE_HEAD FOR EACH ROW
612[java] DECLAREBEGIN IF (inserting) THEN
613[java] UPDATE
614[java] RWT_INSURANCE_TYPE
615[java] SET
616[java] RWT_RECSTATUS='0'
617[java] WHERE
618[java] RWT_INSURANCE_TYPE_id=:NEW.RWT_INSURANCE_TYPE_id;
619[java] END IF;
620[java] IF (updating) THEN
621[java] UPDATE
622[java] RWT_INSURANCE_TYPE
623[java] SET
624[java] RWT_RECSTATUS='0'
625[java] WHERE
626[java] RWT_INSURANCE_TYPE_id=:NEW.RWT_INSURANCE_TYPE_id;
627[java] END IF;
628[java] END;
629[java] 302212 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
630[java]
631[java] 302216 WARN - -- END
632[java] -- -----------------------------------------------------------------------
633[java] -- TRIGGER RWT_LOGISTICS_BILL_LINE_TRG2
634[java] -- -----------------------------------------------------------------------
635[java] CREATE TRIGGER RWT_LOGISTICS_BILL_LINE_TRG2
636[java] AFTER INSERT OR UPDATE OR DELETE
637[java] ON RWT_LOGISTICS_BILL_LINE FOR EACH ROW
638[java] DECLAREBEGIN IF (inserting) THEN
639[java] UPDATE
640[java] RWT_Logistics_Bill
641[java] SET
642[java] rwt_recstatus='0'
643[java] WHERE
644[java] RWT_Logistics_Bill_id=:new.RWT_Logistics_Bill_id
645[java] AND rwt_recstatus NOT IN ('2');
646[java] END IF;
647[java] IF (updating) THEN
648[java] UPDATE
649[java] RWT_Logistics_Bill
650[java] SET
651[java] rwt_recstatus='0'
652[java] WHERE
653[java] RWT_Logistics_Bill_id=:new.RWT_Logistics_Bill_id
654[java] AND rwt_recstatus NOT IN ('2');
655[java] END IF;
656[java] END;
657[java] 302260 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
658[java]
659[java] 302265 WARN - -- END
660[java] -- -----------------------------------------------------------------------
661[java] -- TRIGGER RWT_LOGISTICS_BILL_TAX_TRG2
662[java] -- -----------------------------------------------------------------------
663[java] CREATE TRIGGER RWT_LOGISTICS_BILL_TAX_TRG2
664[java] AFTER INSERT OR UPDATE OR DELETE
665[java] ON RWT_LOGISTICS_BILL_TAX FOR EACH ROW
666[java] DECLAREBEGIN IF (inserting) THEN
667[java] UPDATE
668[java] RWT_Logistics_Bill
669[java] SET
670[java] rwt_recstatus='0'
671[java] WHERE
672[java] RWT_Logistics_Bill_id=:new.RWT_Logistics_Bill_id
673[java] AND rwt_recstatus = '1';
674[java] END IF;
675[java] IF (updating) THEN
676[java] UPDATE
677[java] RWT_Logistics_Bill
678[java] SET
679[java] rwt_recstatus='0'
680[java] WHERE
681[java] RWT_Logistics_Bill_id=:new.RWT_Logistics_Bill_id
682[java] AND rwt_recstatus = '1';
683[java] END IF;
684[java] END;
685[java] 302377 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
686[java]
687[java] 302381 WARN - -- END
688[java] -- -----------------------------------------------------------------------
689[java] -- TRIGGER RWT_LOGISTICS_CONT_MAT_TRG2
690[java] -- -----------------------------------------------------------------------
691[java] CREATE TRIGGER RWT_LOGISTICS_CONT_MAT_TRG2
692[java] AFTER INSERT OR UPDATE OR DELETE
693[java] ON RWT_LOGISTICS_CONT_MAT FOR EACH ROW
694[java] DECLAREBEGIN
695[java] IF (inserting) THEN
696[java] UPDATE RWT_Logistics_Cont SET rwt_recstatus ='0' WHERE RWT_Logistics_Cont_id=:new.RWT_Logistics_Cont_id;
697[java] END IF;
698[java] IF (updating) THEN
699[java] IF (:new.EXECUTEDQUANTITYWT <> :OLD.EXECUTEDQUANTITYWT) THEN
700[java] UPDATE RWT_Logistics_Cont SET rwt_recstatus ='10' WHERE RWT_Logistics_Cont_id=:new.RWT_Logistics_Cont_id;
701[java] ELSE
702[java] UPDATE RWT_Logistics_Cont SET rwt_recstatus ='0' WHERE RWT_Logistics_Cont_id=:new.RWT_Logistics_Cont_id;
703[java] END IF;
704[java] END IF;
705[java] END;
706[java] 302432 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
707[java]
708[java] 302436 WARN - -- END
709[java] -- -----------------------------------------------------------------------
710[java] -- TRIGGER RWT_LOGISTICS_CONT_TAX_TRG2
711[java] -- -----------------------------------------------------------------------
712[java] CREATE TRIGGER RWT_LOGISTICS_CONT_TAX_TRG2
713[java] AFTER INSERT OR UPDATE OR DELETE
714[java] ON RWT_LOGISTICS_CONT_TAX FOR EACH ROW
715[java] DECLAREBEGIN IF (inserting) THEN
716[java] UPDATE
717[java] RWT_Logistics_Cont
718[java] SET
719[java] rwt_recstatus='0'
720[java] WHERE
721[java] RWT_Logistics_Cont_id=:new.RWT_Logistics_Cont_id;
722[java] END IF;
723[java] IF (updating) THEN
724[java] UPDATE
725[java] RWT_Logistics_Cont
726[java] SET
727[java] rwt_recstatus='0'
728[java] WHERE
729[java] RWT_Logistics_Cont_id=:new.RWT_Logistics_Cont_id;
730[java] END IF;
731[java] END;
732[java] 302654 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
733[java]
734[java] 302664 WARN - -- END
735[java] -- -----------------------------------------------------------------------
736[java] -- TRIGGER RWT_LOG_BILL_LINE_EXP_TRG2
737[java] -- -----------------------------------------------------------------------
738[java] CREATE TRIGGER RWT_LOG_BILL_LINE_EXP_TRG2
739[java] AFTER INSERT OR UPDATE
740[java] ON RWT_LOG_BILL_LINE_EXP FOR EACH ROW
741[java] DECLAREBEGIN IF (INSERTING) THEN RWT_LOGBILL_UPDTEXP(:NEW.RWT_LOGISTICS_BILL_LINE_ID,:NEW.EXPAMTTOCREDIT,:NEW.RWT_LOG_BILL_LINE_EXP_ID);
742[java] DELETE
743[java] FROM
744[java] rwt_logistics_bill_tax
745[java] WHERE
746[java] rwt_logistics_bill_id IN
747[java] (
748[java] SELECT
749[java] rwt_logistics_bill_id
750[java] FROM
751[java] rwt_logistics_bill_line
752[java] WHERE
753[java] rwt_logistics_bill_line_id = :new.rwt_logistics_bill_line_id
754[java] );
755[java] END IF;
756[java] IF (UPDATING) THEN
757[java] RWT_LOGBILL_UPDTEXP(:NEW.RWT_LOGISTICS_BILL_LINE_ID,:NEW.EXPAMTTOCREDIT,:NEW.RWT_LOG_BILL_LINE_EXP_ID);
758[java] DELETE
759[java] FROM
760[java] rwt_logistics_bill_tax
761[java] WHERE
762[java] rwt_logistics_bill_id IN
763[java] (
764[java] SELECT
765[java] rwt_logistics_bill_id
766[java] FROM
767[java] rwt_logistics_bill_line
768[java] WHERE
769[java] rwt_logistics_bill_line_id = :old.rwt_logistics_bill_line_id
770[java] );
771[java] END IF;
772[java] /*
773[java] IF (DELETING) THEN
774[java] RWT_LOGBILL_UPDTEXP(:OLD.RWT_LOGISTICS_BILL_LINE_ID);
775[java] END IF;
776[java] */
777[java] END;
778[java] 302954 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
779[java]
780[java] 302958 WARN - -- END
781[java] -- -----------------------------------------------------------------------
782[java] -- TRIGGER RWT_MAT_PROD_RM_CONS_TRG2
783[java] -- -----------------------------------------------------------------------
784[java] CREATE TRIGGER RWT_MAT_PROD_RM_CONS_TRG2
785[java] AFTER INSERT OR UPDATE OR DELETE
786[java] ON RWT_MAT_PROD_RM_CONS FOR EACH ROW
787[java] DECLAREBEGIN IF (inserting) THEN
788[java] UPDATE
789[java] RWT_Production_Confirm
790[java] SET
791[java] RWT_RECSTATUS='0'
792[java] WHERE
793[java] RWT_PRODUCTION_CONFIRM_ID=:NEW.RWT_PRODUCTION_CONFIRM_ID;
794[java] END IF;
795[java] IF (updating) THEN
796[java] UPDATE
797[java] RWT_Production_Confirm
798[java] SET
799[java] RWT_RECSTATUS='0'
800[java] WHERE
801[java] RWT_PRODUCTION_CONFIRM_ID=:NEW.RWT_PRODUCTION_CONFIRM_ID;
802[java] END IF;
803[java] END;
804[java] 303008 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
805[java]
806[java] 303013 WARN - -- END
807[java] -- -----------------------------------------------------------------------
808[java] -- TRIGGER RWT_MAT_PROD_RM_STD_REQ_TRG2
809[java] -- -----------------------------------------------------------------------
810[java] CREATE TRIGGER RWT_MAT_PROD_RM_STD_REQ_TRG2
811[java] AFTER INSERT OR UPDATE OR DELETE
812[java] ON RWT_MAT_PROD_RM_STD_REQ FOR EACH ROW
813[java] DECLAREBEGIN IF (inserting) THEN
814[java] UPDATE
815[java] RWT_Mat_Prod_Std_Req
816[java] SET
817[java] rwt_recstatus='0'
818[java] WHERE
819[java] RWT_Mat_Prod_Std_Req_id=:new.RWT_Mat_Prod_Std_Req_id;
820[java] END IF;
821[java] IF (updating) THEN
822[java] UPDATE
823[java] RWT_Mat_Prod_Std_Req
824[java] SET
825[java] rwt_recstatus='0'
826[java] WHERE
827[java] RWT_Mat_Prod_Std_Req_id=:new.RWT_Mat_Prod_Std_Req_id;
828[java] END IF;
829[java] END;
830[java] 303143 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
831[java]
832[java] 303147 WARN - -- END
833[java] -- -----------------------------------------------------------------------
834[java] -- TRIGGER RWT_MIITR_INWARD_TRG2
835[java] -- -----------------------------------------------------------------------
836[java] CREATE TRIGGER RWT_MIITR_INWARD_TRG2
837[java] AFTER INSERT OR UPDATE OR DELETE
838[java] ON RWT_MIITR_INWARD FOR EACH ROW
839[java] DECLAREBEGIN IF (inserting) THEN
840[java] UPDATE RWT_MIITR SET rwt_recstatus='0' WHERE RWT_MIITR_id=:new.RWT_MIITR_id;
841[java] END IF;
842[java] IF (updating) THEN
843[java] UPDATE RWT_MIITR SET rwt_recstatus='0' WHERE RWT_MIITR_id=:new.RWT_MIITR_id;
844[java] END IF;
845[java] END;
846[java] 303286 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
847[java]
848[java] 303291 WARN - -- END
849[java] -- -----------------------------------------------------------------------
850[java] -- TRIGGER RWT_MIITR_MAT_QLTY_TRG2
851[java] -- -----------------------------------------------------------------------
852[java] CREATE TRIGGER RWT_MIITR_MAT_QLTY_TRG2
853[java] AFTER INSERT OR UPDATE OR DELETE
854[java] ON RWT_MIITR_MAT_QLTY FOR EACH ROW
855[java] DECLAREBEGIN IF (inserting) THEN
856[java] UPDATE
857[java] RWT_Miitr miitr
858[java] SET
859[java] RWT_RECSTATUS='0'
860[java] WHERE
861[java] EXISTS
862[java] (
863[java] SELECT
864[java] 1
865[java] FROM
866[java] RWT_miitr_Mat
867[java] WHERE
868[java] rwt_miitr_mat.rwt_miitr_id= miitr.rwt_miitr_id
869[java] AND rwt_miitr_mat.rwt_miitr_mat_id=:NEW.rwt_miitr_mat_id
870[java] );
871[java] END IF;
872[java] IF (updating) THEN
873[java] UPDATE
874[java] RWT_Miitr miitr
875[java] SET
876[java] RWT_RECSTATUS='0'
877[java] WHERE
878[java] EXISTS
879[java] (
880[java] SELECT
881[java] 1
882[java] FROM
883[java] RWT_miitr_Mat
884[java] WHERE
885[java] rwt_miitr_mat.rwt_miitr_id= miitr.rwt_miitr_id
886[java] AND rwt_miitr_mat.rwt_miitr_mat_id=:NEW.rwt_miitr_mat_id
887[java] );
888[java] END IF;
889[java] END;
890[java] 303346 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
891[java]
892[java] 303352 WARN - -- END
893[java] -- -----------------------------------------------------------------------
894[java] -- TRIGGER RWT_MIITR_MAT_TRG2
895[java] -- -----------------------------------------------------------------------
896[java] CREATE TRIGGER RWT_MIITR_MAT_TRG2
897[java] AFTER INSERT OR UPDATE OR DELETE
898[java] ON RWT_MIITR_MAT FOR EACH ROW
899[java] DECLAREBEGIN IF (inserting) THEN
900[java] UPDATE RWT_MIITR SET rwt_recstatus='0' WHERE RWT_MIITR_id=:new.RWT_MIITR_id;
901[java] END IF;
902[java] IF (updating) THEN
903[java] UPDATE RWT_MIITR SET rwt_recstatus='0' WHERE RWT_MIITR_id=:new.RWT_MIITR_id;
904[java] END IF;
905[java] END;
906[java] 303513 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
907[java]
908[java] 303521 WARN - -- END
909[java] -- -----------------------------------------------------------------------
910[java] -- TRIGGER RWT_NONFACTBPA_QLTY_DED_TRG2
911[java] -- -----------------------------------------------------------------------
912[java] CREATE TRIGGER RWT_NONFACTBPA_QLTY_DED_TRG2
913[java] AFTER INSERT OR UPDATE OR DELETE
914[java] ON RWT_NONFACTBPA_QLTYDEDUCT FOR EACH ROW
915[java] DECLAREBEGIN IF (inserting) THEN
916[java] UPDATE
917[java] RWT_NONFACTORY_BPA
918[java] SET
919[java] rwt_recstatus='0'
920[java] WHERE
921[java] RWT_NONFACTORY_BPA_id=:new.RWT_NONFACTORY_BPA_id;
922[java] END IF;
923[java] IF (updating) THEN
924[java] UPDATE
925[java] RWT_NONFACTORY_BPA
926[java] SET
927[java] rwt_recstatus='0'
928[java] WHERE
929[java] RWT_NONFACTORY_BPA_id=:new.RWT_NONFACTORY_BPA_id;
930[java] END IF;
931[java] END;
932[java] 303574 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
933[java]
934[java] 303582 WARN - -- END
935[java] -- -----------------------------------------------------------------------
936[java] -- TRIGGER RWT_NONFACTORY_BPA_TAX_TRG2
937[java] -- -----------------------------------------------------------------------
938[java] CREATE TRIGGER RWT_NONFACTORY_BPA_TAX_TRG2
939[java] AFTER INSERT OR UPDATE OR DELETE
940[java] ON RWT_NONFACTORY_BPA_TAX FOR EACH ROW
941[java] DECLAREBEGIN IF (inserting) THEN
942[java] UPDATE
943[java] RWT_NONFACTORY_BPA
944[java] SET
945[java] rwt_recstatus='0'
946[java] WHERE
947[java] RWT_NONFACTORY_BPA_id=:new.RWT_NONFACTORY_BPA_id;
948[java] END IF;
949[java] IF (updating) THEN
950[java] UPDATE
951[java] RWT_NONFACTORY_BPA
952[java] SET
953[java] rwt_recstatus='0'
954[java] WHERE
955[java] RWT_NONFACTORY_BPA_id=:new.RWT_NONFACTORY_BPA_id;
956[java] END IF;
957[java] END;
958[java] 303676 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
959[java]
960[java] 303688 WARN - -- END
961[java] -- -----------------------------------------------------------------------
962[java] -- TRIGGER RWT_NON_FACT_PRC_MAT_QLTY_TRG2
963[java] -- -----------------------------------------------------------------------
964[java] CREATE TRIGGER RWT_NON_FACT_PRC_MAT_QLTY_TRG2
965[java] AFTER INSERT OR UPDATE OR DELETE
966[java] ON RWT_NON_FACT_PRC_MAT_QLTY FOR EACH ROW
967[java] DECLAREBEGIN
968[java] IF (inserting) THEN
969[java] UPDATE rwt_non_fact_proc nonfactproc SET RWT_RECSTATUS='0' WHERE EXISTS (SELECT 1 FROM rwt_non_fact_proc_mat WHERE rwt_non_fact_proc_id=nonfactproc.rwt_non_fact_proc_id AND rwt_non_fact_proc_mat.rwt_non_fact_proc_mat_id=:NEW.rwt_non_fact_proc_mat_id);
970[java] END IF;
971[java] IF (updating) THEN
972[java] UPDATE rwt_non_fact_proc nonfactproc SET RWT_RECSTATUS='0' WHERE EXISTS (SELECT 1 FROM rwt_non_fact_proc_mat WHERE rwt_non_fact_proc_id=nonfactproc.rwt_non_fact_proc_id AND rwt_non_fact_proc_mat.rwt_non_fact_proc_mat_id=:NEW.rwt_non_fact_proc_mat_id);
973[java] END IF;
974[java] END;
975[java] 303905 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
976[java]
977[java] 303913 WARN - -- END
978[java] -- -----------------------------------------------------------------------
979[java] -- TRIGGER RWT_NON_FACT_SALE_MAT_TRG2
980[java] -- -----------------------------------------------------------------------
981[java] CREATE TRIGGER RWT_NON_FACT_SALE_MAT_TRG2
982[java] AFTER INSERT OR UPDATE OR DELETE
983[java] ON RWT_NON_FACT_SALE_MAT FOR EACH ROW
984[java] DECLAREBEGIN IF (inserting) THEN
985[java] UPDATE
986[java] RWT_NON_FACT_SALE
987[java] SET
988[java] rwt_recstatus='0'
989[java] WHERE
990[java] RWT_NON_FACT_SALE_id=:new.RWT_NON_FACT_SALE_id;
991[java] END IF;
992[java] IF (updating) THEN
993[java] UPDATE
994[java] RWT_NON_FACT_SALE
995[java] SET
996[java] rwt_recstatus='0'
997[java] WHERE
998[java] RWT_NON_FACT_SALE_id=:new.RWT_NON_FACT_SALE_id;
999[java] END IF;
1000[java] END;
1001[java] 304040 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1002[java]
1003[java] 304051 WARN - -- END
1004[java] -- -----------------------------------------------------------------------
1005[java] -- TRIGGER RWT_NON_FACT_SAL_MAT_QLTY_TRG2
1006[java] -- -----------------------------------------------------------------------
1007[java] CREATE TRIGGER RWT_NON_FACT_SAL_MAT_QLTY_TRG2
1008[java] AFTER INSERT OR UPDATE OR DELETE
1009[java] ON RWT_NON_FACT_SAL_MAT_QLTY FOR EACH ROW
1010[java] DECLAREBEGIN IF (inserting) THEN
1011[java] UPDATE
1012[java] rwt_non_fact_sale nonfactsale
1013[java] SET
1014[java] RWT_RECSTATUS='0'
1015[java] WHERE
1016[java] EXISTS
1017[java] (
1018[java] SELECT
1019[java] 1
1020[java] FROM
1021[java] rwt_non_fact_sale_mat
1022[java] WHERE
1023[java] rwt_non_fact_sale_id=nonfactsale.rwt_non_fact_sale_id
1024[java] AND rwt_non_fact_sale_mat.rwt_non_fact_sale_mat_id=:NEW.rwt_non_fact_sale_mat_id
1025[java] );
1026[java] END IF;
1027[java] IF (updating) THEN
1028[java] UPDATE
1029[java] rwt_non_fact_sale nonfactsale
1030[java] SET
1031[java] RWT_RECSTATUS='0'
1032[java] WHERE
1033[java] EXISTS
1034[java] (
1035[java] SELECT
1036[java] 1
1037[java] FROM
1038[java] rwt_non_fact_sale_mat
1039[java] WHERE
1040[java] rwt_non_fact_sale_id=nonfactsale.rwt_non_fact_sale_id
1041[java] AND rwt_non_fact_sale_mat.rwt_non_fact_sale_mat_id=:NEW.rwt_non_fact_sale_mat_id
1042[java] );
1043[java] END IF;
1044[java] END;
1045[java] 304383 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1046[java]
1047[java] 304389 WARN - -- END
1048[java] -- -----------------------------------------------------------------------
1049[java] -- TRIGGER RWT_PACK_MAT_ISSUE_LINE_TRG2
1050[java] -- -----------------------------------------------------------------------
1051[java] CREATE TRIGGER RWT_PACK_MAT_ISSUE_LINE_TRG2
1052[java] AFTER INSERT OR UPDATE OR DELETE
1053[java] ON RWT_PACK_MAT_ISSUE_LINE FOR EACH ROW
1054[java] DECLAREBEGIN IF (INSERTING) THEN
1055[java] --v_temp := RWT_GetPackMatIssueFreight(:new.ad_client_id, :new.rwt_pack_mat_issue_id, :new.rwt_pack_mat_issue_line_id, :new.quantity);
1056[java] UPDATE
1057[java] RWT_Pack_Mat_Issue
1058[java] SET
1059[java] RWT_RECSTATUS='0'
1060[java] WHERE
1061[java] RWT_Pack_Mat_Issue_ID=:NEW.RWT_Pack_Mat_Issue_ID;
1062[java] END IF;
1063[java] IF (UPDATING) THEN
1064[java] UPDATE
1065[java] RWT_Pack_Mat_Issue
1066[java] SET
1067[java] RWT_RECSTATUS='0'
1068[java] WHERE
1069[java] RWT_Pack_Mat_Issue_ID=:NEW.RWT_Pack_Mat_Issue_ID;
1070[java] END IF;
1071[java] END;
1072[java] 304508 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1073[java]
1074[java] 304515 WARN - -- END
1075[java] -- -----------------------------------------------------------------------
1076[java] -- TRIGGER RWT_PACK_MAT_RECVD_LINE_TRG2
1077[java] -- -----------------------------------------------------------------------
1078[java] CREATE TRIGGER RWT_PACK_MAT_RECVD_LINE_TRG2
1079[java] AFTER INSERT OR UPDATE OR DELETE
1080[java] ON RWT_PACK_MAT_RECVD_LINE FOR EACH ROW
1081[java] DECLAREBEGIN IF (INSERTING) THEN
1082[java] UPDATE
1083[java] RWT_Pack_Mat_Recvd
1084[java] SET
1085[java] RWT_RECSTATUS='0'
1086[java] WHERE
1087[java] RWT_Pack_Mat_Recvd_ID=:NEW.RWT_Pack_Mat_Recvd_ID;
1088[java] END IF;
1089[java] IF (UPDATING) THEN
1090[java] UPDATE
1091[java] RWT_Pack_Mat_Recvd
1092[java] SET
1093[java] RWT_RECSTATUS='0'
1094[java] WHERE
1095[java] RWT_Pack_Mat_Recvd_ID=:NEW.RWT_Pack_Mat_Recvd_ID;
1096[java] END IF;
1097[java] END;
1098[java] 304667 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1099[java]
1100[java] 304677 WARN - -- END
1101[java] -- -----------------------------------------------------------------------
1102[java] -- TRIGGER RWT_PARTY_QLTY_PARA_TRG2
1103[java] -- -----------------------------------------------------------------------
1104[java] CREATE TRIGGER RWT_PARTY_QLTY_PARA_TRG2
1105[java] AFTER INSERT OR UPDATE OR DELETE
1106[java] ON RWT_PARTY_QLTY_PARA FOR EACH ROW
1107[java] DECLAREBEGIN
1108[java] IF (INSERTING) THEN
1109[java] UPDATE RWT_BP_QLTY_SPECS SET RWT_RECSTATUS='0' WHERE RWT_BP_QLTY_SPECS_ID=:NEW.RWT_BP_QLTY_SPECS_ID;
1110[java] END IF;
1111[java] IF (UPDATING) THEN
1112[java] UPDATE RWT_BP_QLTY_SPECS SET RWT_RECSTATUS='0' WHERE RWT_BP_QLTY_SPECS_ID=:NEW.RWT_BP_QLTY_SPECS_ID;
1113[java] END IF;
1114[java] END;
1115[java] 305143 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1116[java]
1117[java] 305151 WARN - -- END
1118[java] -- -----------------------------------------------------------------------
1119[java] -- TRIGGER RWT_PER_INQ_MAT_SPEC_TRG2
1120[java] -- -----------------------------------------------------------------------
1121[java] CREATE TRIGGER RWT_PER_INQ_MAT_SPEC_TRG2
1122[java] AFTER INSERT OR UPDATE OR DELETE
1123[java] ON RWT_PER_INQ_MAT_SPEC FOR EACH ROW
1124[java] DECLAREBEGIN IF (inserting) THEN
1125[java] UPDATE
1126[java] RWT_Per_Inq perinq
1127[java] SET
1128[java] RWT_RECSTATUS='0'
1129[java] WHERE
1130[java] EXISTS
1131[java] (
1132[java] SELECT
1133[java] 1
1134[java] FROM
1135[java] RWT_per_inq_Mat
1136[java] WHERE
1137[java] rwt_per_inq_mat.rwt_per_inq_mat_id= perinq.rwt_per_inq_id
1138[java] AND RWT_PER_INQ_MAT_ID=:NEW.RWT_PER_INQ_MAT_ID
1139[java] );
1140[java] END IF;
1141[java] IF (updating) THEN
1142[java] UPDATE
1143[java] RWT_Per_Inq perinq
1144[java] SET
1145[java] RWT_RECSTATUS='0'
1146[java] WHERE
1147[java] EXISTS
1148[java] (
1149[java] SELECT
1150[java] 1
1151[java] FROM
1152[java] RWT_per_inq_Mat
1153[java] WHERE
1154[java] rwt_per_inq_mat.rwt_per_inq_mat_id= perinq.rwt_per_inq_id
1155[java] AND RWT_PER_INQ_MAT_ID=:NEW.RWT_PER_INQ_MAT_ID
1156[java] );
1157[java] END IF;
1158[java] END;
1159[java] 305203 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1160[java]
1161[java] 305208 WARN - -- END
1162[java] -- -----------------------------------------------------------------------
1163[java] -- TRIGGER RWT_PER_INQ_MAT_TRG2
1164[java] -- -----------------------------------------------------------------------
1165[java] CREATE TRIGGER RWT_PER_INQ_MAT_TRG2
1166[java] AFTER INSERT OR UPDATE OR DELETE
1167[java] ON RWT_PER_INQ_MAT FOR EACH ROW
1168[java] DECLAREBEGIN IF (inserting) THEN
1169[java] UPDATE
1170[java] RWT_Per_Inq
1171[java] SET
1172[java] rwt_recstatus='0'
1173[java] WHERE
1174[java] RWT_Per_Inq_id=:new.RWT_Per_Inq_id;
1175[java] END IF;
1176[java] IF (updating) THEN
1177[java] UPDATE
1178[java] RWT_Per_Inq
1179[java] SET
1180[java] rwt_recstatus='0'
1181[java] WHERE
1182[java] RWT_Per_Inq_id=:new.RWT_Per_Inq_id;
1183[java] END IF;
1184[java] END;
1185[java] 305588 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1186[java]
1187[java] 305593 WARN - -- END
1188[java] -- -----------------------------------------------------------------------
1189[java] -- TRIGGER RWT_PROCCONT_TAX_TRG2
1190[java] -- -----------------------------------------------------------------------
1191[java] CREATE TRIGGER RWT_PROCCONT_TAX_TRG2
1192[java] AFTER INSERT OR UPDATE OR DELETE
1193[java] ON RWT_PROCCONT_TAX FOR EACH ROW
1194[java] DECLAREBEGIN
1195[java] IF (INSERTING) THEN
1196[java] UPDATE RWT_PROC_CONTRACT SET RWT_RECSTATUS='0' WHERE RWT_PROC_CONTRACT_ID=:NEW.RWT_PROC_CONTRACT_ID;
1197[java] END IF;
1198[java] IF (UPDATING) THEN
1199[java] UPDATE RWT_PROC_CONTRACT SET RWT_RECSTATUS='0' WHERE RWT_PROC_CONTRACT_ID=:NEW.RWT_PROC_CONTRACT_ID;
1200[java] END IF;
1201[java] END;
1202[java] 305643 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1203[java]
1204[java] 305648 WARN - -- END
1205[java] -- -----------------------------------------------------------------------
1206[java] -- TRIGGER RWT_PROCINWARD_DETEN_TRG2
1207[java] -- -----------------------------------------------------------------------
1208[java] CREATE TRIGGER RWT_PROCINWARD_DETEN_TRG2
1209[java] AFTER INSERT OR UPDATE OR DELETE
1210[java] ON RWT_PROCINWARD_DETEN FOR EACH ROW
1211[java] DECLAREBEGIN
1212[java] IF (INSERTING) THEN
1213[java] UPDATE RWT_PROC_UNLOAD SET RWT_RECSTATUS='0' WHERE RWT_PROC_UNLOAD_ID=:NEW.RWT_PROC_UNLOAD_ID;
1214[java] END IF;
1215[java] IF (UPDATING) THEN
1216[java] UPDATE RWT_PROC_UNLOAD SET RWT_RECSTATUS='0' WHERE RWT_PROC_UNLOAD_ID=:NEW.RWT_PROC_UNLOAD_ID;
1217[java] END IF;
1218[java] END;
1219[java] 305966 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1220[java]
1221[java] 305973 WARN - -- END
1222[java] -- -----------------------------------------------------------------------
1223[java] -- TRIGGER RWT_PROC_CONT_DELV_SCH_TRG2
1224[java] -- -----------------------------------------------------------------------
1225[java] CREATE TRIGGER RWT_PROC_CONT_DELV_SCH_TRG2
1226[java] AFTER INSERT OR UPDATE OR DELETE
1227[java] ON RWT_PROC_CONT_DELV_SCH FOR EACH ROW
1228[java] DECLAREBEGIN IF (inserting) THEN
1229[java] UPDATE
1230[java] rwt_Proc_Contract
1231[java] SET
1232[java] rwt_recstatus='0'
1233[java] WHERE
1234[java] rwt_Proc_Contract_id=:new.rwt_Proc_Contract_id;
1235[java] END IF;
1236[java] IF (updating) THEN
1237[java] UPDATE
1238[java] rwt_Proc_Contract
1239[java] SET
1240[java] rwt_recstatus='0'
1241[java] WHERE
1242[java] rwt_Proc_Contract_id=:new.rwt_Proc_Contract_id;
1243[java] END IF;
1244[java] END;
1245[java] 306020 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1246[java]
1247[java] 306026 WARN - -- END
1248[java] -- -----------------------------------------------------------------------
1249[java] -- TRIGGER RWT_PROC_CONT_DES_DOC_TRG2
1250[java] -- -----------------------------------------------------------------------
1251[java] CREATE TRIGGER RWT_PROC_CONT_DES_DOC_TRG2
1252[java] AFTER INSERT OR UPDATE OR DELETE
1253[java] ON RWT_PROC_CONT_DES_DOC FOR EACH ROW
1254[java] DECLAREBEGIN IF (inserting) THEN
1255[java] UPDATE
1256[java] rwt_Proc_Contract
1257[java] SET
1258[java] rwt_recstatus='0'
1259[java] WHERE
1260[java] rwt_Proc_Contract_id=:new.rwt_Proc_Contract_id;
1261[java] END IF;
1262[java] IF (updating) THEN
1263[java] UPDATE
1264[java] rwt_Proc_Contract
1265[java] SET
1266[java] rwt_recstatus='0'
1267[java] WHERE
1268[java] rwt_Proc_Contract_id=:new.rwt_Proc_Contract_id;
1269[java] END IF;
1270[java] END;
1271[java] 306105 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1272[java]
1273[java] 306117 WARN - -- END
1274[java] -- -----------------------------------------------------------------------
1275[java] -- TRIGGER RWT_PROC_CONT_QLTY_PARA_TRG2
1276[java] -- -----------------------------------------------------------------------
1277[java] CREATE TRIGGER RWT_PROC_CONT_QLTY_PARA_TRG2
1278[java] AFTER INSERT OR UPDATE OR DELETE
1279[java] ON RWT_PROC_CONT_QLTY_PARA FOR EACH ROW
1280[java] DECLAREBEGIN IF (inserting) THEN
1281[java] UPDATE
1282[java] rwt_Proc_Contract
1283[java] SET
1284[java] rwt_recstatus='0'
1285[java] WHERE
1286[java] rwt_Proc_Contract_id=:new.rwt_Proc_Contract_id;
1287[java] END IF;
1288[java] IF (updating) THEN
1289[java] UPDATE
1290[java] rwt_Proc_Contract
1291[java] SET
1292[java] rwt_recstatus='0'
1293[java] WHERE
1294[java] rwt_Proc_Contract_id=:new.rwt_Proc_Contract_id;
1295[java] END IF;
1296[java] END;
1297[java] 306328 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1298[java]
1299[java] 306334 WARN - -- END
1300[java] -- -----------------------------------------------------------------------
1301[java] -- TRIGGER RWT_PROC_INWARD_DES_DOC_TRG2
1302[java] -- -----------------------------------------------------------------------
1303[java] CREATE TRIGGER RWT_PROC_INWARD_DES_DOC_TRG2
1304[java] AFTER INSERT OR UPDATE OR DELETE
1305[java] ON RWT_PROC_INWARD_DES_DOC FOR EACH ROW
1306[java] DECLAREBEGIN IF (inserting) THEN
1307[java] UPDATE
1308[java] rwt_proc_inward
1309[java] SET
1310[java] rwt_recstatus='0'
1311[java] WHERE
1312[java] rwt_proc_inward_id=:new.rwt_proc_inward_id;
1313[java] END IF;
1314[java] IF (updating) THEN
1315[java] UPDATE
1316[java] rwt_proc_inward
1317[java] SET
1318[java] rwt_recstatus='0'
1319[java] WHERE
1320[java] rwt_proc_inward_id=:new.rwt_proc_inward_id;
1321[java] END IF;
1322[java] END;
1323[java] 306588 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1324[java]
1325[java] 306593 WARN - -- END
1326[java] -- -----------------------------------------------------------------------
1327[java] -- TRIGGER RWT_PROC_OFFER_EST_EXP_TRG2
1328[java] -- -----------------------------------------------------------------------
1329[java] CREATE TRIGGER RWT_PROC_OFFER_EST_EXP_TRG2
1330[java] AFTER INSERT OR UPDATE OR DELETE
1331[java] ON RWT_PROC_OFFER_EST_EXP FOR EACH ROW
1332[java] DECLAREBEGIN IF (inserting) THEN
1333[java] UPDATE
1334[java] RWT_Proc_Offer
1335[java] SET
1336[java] rwt_recstatus='0'
1337[java] WHERE
1338[java] RWT_Proc_Offer_id=:new.RWT_Proc_Offer_id;
1339[java] END IF;
1340[java] IF (updating) THEN
1341[java] UPDATE
1342[java] RWT_Proc_Offer
1343[java] SET
1344[java] rwt_recstatus='0'
1345[java] WHERE
1346[java] RWT_Proc_Offer_id=:new.RWT_Proc_Offer_id;
1347[java] END IF;
1348[java] END;
1349[java] 306878 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1350[java]
1351[java] 306882 WARN - -- END
1352[java] -- -----------------------------------------------------------------------
1353[java] -- TRIGGER RWT_PROC_UNLOAD_MAT_TRG2
1354[java] -- -----------------------------------------------------------------------
1355[java] CREATE TRIGGER RWT_PROC_UNLOAD_MAT_TRG2
1356[java] AFTER INSERT OR UPDATE OR DELETE
1357[java] ON RWT_PROC_UNLOAD_MAT FOR EACH ROW
1358[java] DECLAREBEGIN IF (inserting) THEN
1359[java] UPDATE
1360[java] RWT_proc_unload
1361[java] SET
1362[java] RWT_RECSTATUS='0'
1363[java] WHERE
1364[java] rwt_proc_unload_id=:NEW.rwt_proc_unload_id;
1365[java] END IF;
1366[java] IF (updating) THEN
1367[java] UPDATE
1368[java] RWT_proc_unload
1369[java] SET
1370[java] RWT_RECSTATUS='0'
1371[java] WHERE
1372[java] rwt_proc_unload_id=:NEW.rwt_proc_unload_id;
1373[java] END IF;
1374[java] END;
1375[java] 306938 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1376[java]
1377[java] 306949 WARN - -- END
1378[java] -- -----------------------------------------------------------------------
1379[java] -- TRIGGER RWT_PROC_UNLOAD_PACK_MAT_TRG2
1380[java] -- -----------------------------------------------------------------------
1381[java] CREATE TRIGGER RWT_PROC_UNLOAD_PACK_MAT_TRG2
1382[java] AFTER INSERT OR UPDATE OR DELETE
1383[java] ON RWT_PROC_UNLOAD_PACK_MAT FOR EACH ROW
1384[java] DECLAREBEGIN IF (inserting) THEN
1385[java] UPDATE
1386[java] RWT_proc_unload procunload
1387[java] SET
1388[java] RWT_RECSTATUS='0'
1389[java] WHERE
1390[java] EXISTS
1391[java] (
1392[java] SELECT
1393[java] 1
1394[java] FROM
1395[java] rwt_proc_unload_mat
1396[java] WHERE
1397[java] rwt_proc_unload_id=procunload.rwt_proc_unload_id
1398[java] AND rwt_proc_unload_mat.rwt_proc_unload_mat_id=:NEW.rwt_proc_unload_mat_id
1399[java] );
1400[java] END IF;
1401[java] IF (updating) THEN
1402[java] UPDATE
1403[java] RWT_proc_unload procunload
1404[java] SET
1405[java] RWT_RECSTATUS='0'
1406[java] WHERE
1407[java] EXISTS
1408[java] (
1409[java] SELECT
1410[java] 1
1411[java] FROM
1412[java] rwt_proc_unload_mat
1413[java] WHERE
1414[java] rwt_proc_unload_id=procunload.rwt_proc_unload_id
1415[java] AND rwt_proc_unload_mat.rwt_proc_unload_mat_id=:NEW.rwt_proc_unload_mat_id
1416[java] );
1417[java] END IF;
1418[java] END;
1419[java] 307005 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1420[java]
1421[java] 307015 WARN - -- END
1422[java] -- -----------------------------------------------------------------------
1423[java] -- TRIGGER RWT_PROC_UNLOAD_QUALITY_TRG2
1424[java] -- -----------------------------------------------------------------------
1425[java] CREATE TRIGGER RWT_PROC_UNLOAD_QUALITY_TRG2
1426[java] AFTER INSERT OR UPDATE OR DELETE
1427[java] ON RWT_PROC_UNLOAD_QUALITY FOR EACH ROW
1428[java] DECLAREBEGIN IF (inserting) THEN
1429[java] UPDATE
1430[java] RWT_proc_unload procunload
1431[java] SET
1432[java] RWT_RECSTATUS='0'
1433[java] WHERE
1434[java] EXISTS
1435[java] (
1436[java] SELECT
1437[java] 1
1438[java] FROM
1439[java] rwt_proc_unload_mat
1440[java] WHERE
1441[java] rwt_proc_unload_id=procunload.rwt_proc_unload_id
1442[java] AND rwt_proc_unload_mat.rwt_proc_unload_mat_id=:NEW.rwt_proc_unload_mat_id
1443[java] );
1444[java] END IF;
1445[java] IF (updating) THEN
1446[java] UPDATE
1447[java] RWT_proc_unload procunload
1448[java] SET
1449[java] RWT_RECSTATUS='0'
1450[java] WHERE
1451[java] EXISTS
1452[java] (
1453[java] SELECT
1454[java] 1
1455[java] FROM
1456[java] rwt_proc_unload_mat
1457[java] WHERE
1458[java] rwt_proc_unload_id=procunload.rwt_proc_unload_id
1459[java] AND rwt_proc_unload_mat.rwt_proc_unload_mat_id=:NEW.rwt_proc_unload_mat_id
1460[java] );
1461[java] END IF;
1462[java] END;
1463[java] 307078 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1464[java]
1465[java] 307083 WARN - -- END
1466[java] -- -----------------------------------------------------------------------
1467[java] -- TRIGGER RWT_PROC_UNLOAD_STACKINFO_TRG2
1468[java] -- -----------------------------------------------------------------------
1469[java] CREATE TRIGGER RWT_PROC_UNLOAD_STACKINFO_TRG2
1470[java] AFTER INSERT OR UPDATE OR DELETE
1471[java] ON RWT_PROC_UNLOAD_STACKINFO FOR EACH ROW
1472[java] DECLAREBEGIN IF (inserting) THEN
1473[java] UPDATE
1474[java] RWT_proc_unload
1475[java] SET
1476[java] RWT_RECSTATUS='0'
1477[java] WHERE
1478[java] rwt_proc_unload_id=:NEW.rwt_proc_unload_id;
1479[java] END IF;
1480[java] IF (updating) THEN
1481[java] UPDATE
1482[java] RWT_proc_unload
1483[java] SET
1484[java] RWT_RECSTATUS='0'
1485[java] WHERE
1486[java] rwt_proc_unload_id=:NEW.rwt_proc_unload_id;
1487[java] END IF;
1488[java] END;
1489[java] 307416 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1490[java]
1491[java] 307420 WARN - -- END
1492[java] -- -----------------------------------------------------------------------
1493[java] -- TRIGGER RWT_PRODUCT_PURCHASE_EXP_TRG2
1494[java] -- -----------------------------------------------------------------------
1495[java] CREATE TRIGGER RWT_PRODUCT_PURCHASE_EXP_TRG2
1496[java] AFTER INSERT OR UPDATE OR DELETE
1497[java] ON RWT_PRODUCT_PURCHASE_EXP FOR EACH ROW
1498[java] DECLAREBEGIN IF (inserting) THEN
1499[java] UPDATE
1500[java] RWT_Product_Purchase
1501[java] SET
1502[java] rwt_recstatus='0'
1503[java] WHERE
1504[java] RWT_Product_Purchase_id=:new.RWT_Product_Purchase_id;
1505[java] END IF;
1506[java] IF (updating) THEN
1507[java] UPDATE
1508[java] RWT_Product_Purchase
1509[java] SET
1510[java] rwt_recstatus='0'
1511[java] WHERE
1512[java] RWT_Product_Purchase_id=:new.RWT_Product_Purchase_id;
1513[java] END IF;
1514[java] END;
1515[java] 307490 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1516[java]
1517[java] 307499 WARN - -- END
1518[java] -- -----------------------------------------------------------------------
1519[java] -- TRIGGER RWT_PRODUCT_PURCHASE_TAX_TRG2
1520[java] -- -----------------------------------------------------------------------
1521[java] CREATE TRIGGER RWT_PRODUCT_PURCHASE_TAX_TRG2
1522[java] AFTER INSERT OR UPDATE OR DELETE
1523[java] ON RWT_PRODUCT_PURCHASE_TAX FOR EACH ROW
1524[java] DECLAREBEGIN IF (inserting) THEN
1525[java] UPDATE
1526[java] RWT_Product_Purchase
1527[java] SET
1528[java] rwt_recstatus='0'
1529[java] WHERE
1530[java] RWT_Product_Purchase_id=:new.RWT_Product_Purchase_id;
1531[java] END IF;
1532[java] IF (updating) THEN
1533[java] UPDATE
1534[java] RWT_Product_Purchase
1535[java] SET
1536[java] rwt_recstatus='0'
1537[java] WHERE
1538[java] RWT_Product_Purchase_id=:new.RWT_Product_Purchase_id;
1539[java] END IF;
1540[java] END;
1541[java] 307587 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1542[java]
1543[java] 307591 WARN - -- END
1544[java] -- -----------------------------------------------------------------------
1545[java] -- TRIGGER RWT_PRODUCT_SALE_EXP_TRG2
1546[java] -- -----------------------------------------------------------------------
1547[java] CREATE TRIGGER RWT_PRODUCT_SALE_EXP_TRG2
1548[java] AFTER INSERT OR UPDATE OR DELETE
1549[java] ON RWT_PRODUCT_SALE_EXP FOR EACH ROW
1550[java] DECLAREBEGIN IF (inserting) THEN
1551[java] UPDATE
1552[java] RWT_PRODUCT_SALE
1553[java] SET
1554[java] rwt_recstatus='0'
1555[java] WHERE
1556[java] RWT_PRODUCT_SALE_ID=:new.RWT_PRODUCT_SALE_ID;
1557[java] END IF;
1558[java] IF (updating) THEN
1559[java] UPDATE
1560[java] RWT_PRODUCT_SALE
1561[java] SET
1562[java] rwt_recstatus='0'
1563[java] WHERE
1564[java] RWT_PRODUCT_SALE_ID=:new.RWT_PRODUCT_SALE_ID;
1565[java] END IF;
1566[java] END;
1567[java] 307647 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1568[java]
1569[java] 307652 WARN - -- END
1570[java] -- -----------------------------------------------------------------------
1571[java] -- TRIGGER RWT_PRODUCT_SALE_TAX_TRG2
1572[java] -- -----------------------------------------------------------------------
1573[java] CREATE TRIGGER RWT_PRODUCT_SALE_TAX_TRG2
1574[java] AFTER INSERT OR UPDATE OR DELETE
1575[java] ON RWT_PRODUCT_SALE_TAX FOR EACH ROW
1576[java] DECLAREBEGIN IF (inserting) THEN
1577[java] UPDATE
1578[java] RWT_PRODUCT_SALE
1579[java] SET
1580[java] rwt_recstatus='0'
1581[java] WHERE
1582[java] RWT_PRODUCT_SALE_ID=:new.RWT_PRODUCT_SALE_ID;
1583[java] END IF;
1584[java] IF (updating) THEN
1585[java] UPDATE
1586[java] RWT_PRODUCT_SALE
1587[java] SET
1588[java] rwt_recstatus='0'
1589[java] WHERE
1590[java] RWT_PRODUCT_SALE_ID=:new.RWT_PRODUCT_SALE_ID;
1591[java] END IF;
1592[java] END;
1593[java] 307843 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1594[java]
1595[java] 307847 WARN - -- END
1596[java] -- -----------------------------------------------------------------------
1597[java] -- TRIGGER RWT_PROD_CONFIRM_MAT_OP_TRG2
1598[java] -- -----------------------------------------------------------------------
1599[java] CREATE TRIGGER RWT_PROD_CONFIRM_MAT_OP_TRG2
1600[java] AFTER INSERT OR UPDATE OR DELETE
1601[java] ON RWT_PROD_CONFIRM_MAT_OP FOR EACH ROW
1602[java] DECLAREBEGIN IF (inserting) THEN
1603[java] UPDATE
1604[java] RWT_Production_Confirm
1605[java] SET
1606[java] RWT_RECSTATUS='0'
1607[java] WHERE
1608[java] RWT_Production_Confirm_id=:NEW.RWT_Production_Confirm_id;
1609[java] END IF;
1610[java] IF (updating) THEN
1611[java] UPDATE
1612[java] RWT_Production_Confirm
1613[java] SET
1614[java] RWT_RECSTATUS='0'
1615[java] WHERE
1616[java] RWT_Production_Confirm_id=:NEW.RWT_Production_Confirm_id;
1617[java] END IF;
1618[java] END;
1619[java] 307905 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1620[java]
1621[java] 307916 WARN - -- END
1622[java] -- -----------------------------------------------------------------------
1623[java] -- TRIGGER RWT_PROD_CONF_QLTY_SPEC_TRG2
1624[java] -- -----------------------------------------------------------------------
1625[java] CREATE TRIGGER RWT_PROD_CONF_QLTY_SPEC_TRG2
1626[java] AFTER INSERT OR UPDATE OR DELETE
1627[java] ON RWT_PROD_CONF_QLTY_SPEC FOR EACH ROW
1628[java] DECLAREBEGIN IF (inserting) THEN
1629[java] UPDATE
1630[java] RWT_Production_Confirm prodconf
1631[java] SET
1632[java] RWT_RECSTATUS='0'
1633[java] WHERE
1634[java] EXISTS
1635[java] (
1636[java] SELECT
1637[java] 1
1638[java] FROM
1639[java] RWT_Prod_Confirm_Mat_Op
1640[java] WHERE
1641[java] RWT_Production_Confirm_id=prodconf.RWT_Production_Confirm_id
1642[java] AND RWT_Prod_Confirm_Mat_Op.RWT_Prod_Confirm_Mat_Op_id=:NEW.RWT_Prod_Confirm_Mat_Op_id
1643[java] );
1644[java] END IF;
1645[java] IF (updating) THEN
1646[java] UPDATE
1647[java] RWT_Production_Confirm prodconf
1648[java] SET
1649[java] RWT_RECSTATUS='0'
1650[java] WHERE
1651[java] EXISTS
1652[java] (
1653[java] SELECT
1654[java] 1
1655[java] FROM
1656[java] RWT_Prod_Confirm_Mat_Op
1657[java] WHERE
1658[java] RWT_Production_Confirm_id=prodconf.RWT_Production_Confirm_id
1659[java] AND RWT_Prod_Confirm_Mat_Op.RWT_Prod_Confirm_Mat_Op_id=:NEW.RWT_Prod_Confirm_Mat_Op_id
1660[java] );
1661[java] END IF;
1662[java] END;
1663[java] 308072 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1664[java]
1665[java] 308094 WARN - -- END
1666[java] -- -----------------------------------------------------------------------
1667[java] -- TRIGGER RWT_PROD_CONF_WAREHOUSE_TRG2
1668[java] -- -----------------------------------------------------------------------
1669[java] CREATE TRIGGER RWT_PROD_CONF_WAREHOUSE_TRG2
1670[java] AFTER INSERT OR UPDATE OR DELETE
1671[java] ON RWT_PROD_CONF_WAREHOUSE FOR EACH ROW
1672[java] DECLAREBEGIN IF (inserting) THEN
1673[java] UPDATE
1674[java] RWT_Production_Confirm prodconf
1675[java] SET
1676[java] RWT_RECSTATUS='0'
1677[java] WHERE
1678[java] EXISTS
1679[java] (
1680[java] SELECT
1681[java] 1
1682[java] FROM
1683[java] RWT_Prod_Confirm_Mat_Op
1684[java] WHERE
1685[java] RWT_Production_Confirm_id=prodconf.RWT_Production_Confirm_id
1686[java] AND RWT_Prod_Confirm_Mat_Op.RWT_Prod_Confirm_Mat_Op_id=:NEW.RWT_Prod_Confirm_Mat_Op_id
1687[java] );
1688[java] END IF;
1689[java] IF (updating) THEN
1690[java] UPDATE
1691[java] RWT_Production_Confirm prodconf
1692[java] SET
1693[java] RWT_RECSTATUS='0'
1694[java] WHERE
1695[java] EXISTS
1696[java] (
1697[java] SELECT
1698[java] 1
1699[java] FROM
1700[java] RWT_Prod_Confirm_Mat_Op
1701[java] WHERE
1702[java] RWT_Production_Confirm_id=prodconf.RWT_Production_Confirm_id
1703[java] AND RWT_Prod_Confirm_Mat_Op.RWT_Prod_Confirm_Mat_Op_id=:NEW.RWT_Prod_Confirm_Mat_Op_id
1704[java] );
1705[java] END IF;
1706[java] END;
1707[java] 308803 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1708[java]
1709[java] 308820 WARN - -- END
1710[java] -- -----------------------------------------------------------------------
1711[java] -- TRIGGER RWT_PROD_WISE_QUALITY_TRG2
1712[java] -- -----------------------------------------------------------------------
1713[java] CREATE TRIGGER RWT_PROD_WISE_QUALITY_TRG2
1714[java] AFTER INSERT OR UPDATE OR DELETE
1715[java] ON RWT_PROD_WISE_QUALITY FOR EACH ROW
1716[java] DECLAREBEGIN IF (inserting) THEN
1717[java] UPDATE
1718[java] RWT_Product
1719[java] SET
1720[java] rwt_recstatus='0'
1721[java] WHERE
1722[java] rwt_product_id=:new.rwt_product_id;
1723[java] END IF;
1724[java] IF (updating) THEN
1725[java] UPDATE
1726[java] rwt_product
1727[java] SET
1728[java] rwt_recstatus='0'
1729[java] WHERE
1730[java] rwt_product_id=:new.rwt_product_id;
1731[java] END IF;
1732[java] END;
1733[java] 309385 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1734[java]
1735[java] 309462 WARN - -- END
1736[java] -- -----------------------------------------------------------------------
1737[java] -- TRIGGER RWT_QUOTCOMP_DETAILS_TRG2
1738[java] -- -----------------------------------------------------------------------
1739[java] CREATE TRIGGER RWT_QUOTCOMP_DETAILS_TRG2
1740[java] AFTER INSERT OR UPDATE OR DELETE
1741[java] ON RWT_QUOTCOMP_DETAILS FOR EACH ROW
1742[java] DECLAREBEGIN IF (inserting) THEN
1743[java] UPDATE
1744[java] RWT_Quotcomp
1745[java] SET
1746[java] rwt_recstatus='0'
1747[java] WHERE
1748[java] RWT_Quotcomp_id=:new.RWT_Quotcomp_id;
1749[java] END IF;
1750[java] IF (updating) THEN
1751[java] UPDATE
1752[java] RWT_Quotcomp
1753[java] SET
1754[java] rwt_recstatus='0'
1755[java] WHERE
1756[java] RWT_Quotcomp_id=:new.RWT_Quotcomp_id;
1757[java] END IF;
1758[java] END;
1759[java] 309808 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1760[java]
1761[java] 309872 WARN - -- END
1762[java] -- -----------------------------------------------------------------------
1763[java] -- TRIGGER RWT_RECEIPT_ADVICE_LINE_TRG2
1764[java] -- -----------------------------------------------------------------------
1765[java] CREATE TRIGGER RWT_RECEIPT_ADVICE_LINE_TRG2
1766[java] AFTER INSERT OR UPDATE OR DELETE
1767[java] ON RWT_RECEIPT_ADVICE_LINE FOR EACH ROW
1768[java] DECLAREBEGIN
1769[java] IF (INSERTING) THEN
1770[java] UPDATE RWT_RECEIPT_ADVICE SET RWT_RECSTATUS='0' WHERE RWT_RECEIPT_ADVICE_ID=:NEW.RWT_RECEIPT_ADVICE_ID;
1771[java] END IF;
1772[java] IF (UPDATING) THEN
1773[java] UPDATE RWT_RECEIPT_ADVICE SET RWT_RECSTATUS='0' WHERE RWT_RECEIPT_ADVICE_ID=:NEW.RWT_RECEIPT_ADVICE_ID;
1774[java] END IF;
1775[java] END;
1776[java] 310189 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1777[java]
1778[java] 310247 WARN - -- END
1779[java] -- -----------------------------------------------------------------------
1780[java] -- TRIGGER RWT_REGION_DETAILS_TRG2
1781[java] -- -----------------------------------------------------------------------
1782[java] CREATE TRIGGER RWT_REGION_DETAILS_TRG2
1783[java] AFTER INSERT OR UPDATE OR DELETE
1784[java] ON RWT_REGION_DETAILS FOR EACH ROW
1785[java] DECLAREBEGIN IF (inserting) THEN
1786[java] UPDATE
1787[java] RWT_Region
1788[java] SET
1789[java] rwt_recstatus='0'
1790[java] WHERE
1791[java] RWT_Region_id=:new.RWT_Region_id;
1792[java] END IF;
1793[java] IF (updating) THEN
1794[java] UPDATE
1795[java] RWT_Region
1796[java] SET
1797[java] rwt_recstatus='0'
1798[java] WHERE
1799[java] RWT_Region_id=:new.RWT_Region_id;
1800[java] END IF;
1801[java] END;
1802[java] 310552 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1803[java]
1804[java] 310574 WARN - -- END
1805[java] -- -----------------------------------------------------------------------
1806[java] -- TRIGGER RWT_RM_BPA_EXP_TRG2
1807[java] -- -----------------------------------------------------------------------
1808[java] CREATE TRIGGER RWT_RM_BPA_EXP_TRG2
1809[java] AFTER INSERT OR UPDATE OR DELETE
1810[java] ON RWT_RM_BPA_EXP FOR EACH ROW
1811[java] DECLAREBEGIN IF (inserting) THEN
1812[java] UPDATE
1813[java] RWT_rm_bpa
1814[java] SET
1815[java] rwt_recstatus='0'
1816[java] WHERE
1817[java] RWT_rm_bpa_id=:new.RWT_rm_bpa_id;
1818[java] END IF;
1819[java] IF (updating) THEN
1820[java] UPDATE
1821[java] RWT_rm_bpa
1822[java] SET
1823[java] rwt_recstatus='0'
1824[java] WHERE
1825[java] RWT_rm_bpa_id=:new.RWT_rm_bpa_id;
1826[java] END IF;
1827[java] END;
1828[java] 310696 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1829[java]
1830[java] 310737 WARN - -- END
1831[java] -- -----------------------------------------------------------------------
1832[java] -- TRIGGER RWT_RM_BPA_QLTY_DEDUCT_TRG2
1833[java] -- -----------------------------------------------------------------------
1834[java] CREATE TRIGGER RWT_RM_BPA_QLTY_DEDUCT_TRG2
1835[java] AFTER INSERT OR UPDATE OR DELETE
1836[java] ON RWT_RM_BPA_QLTY_DEDUCT FOR EACH ROW
1837[java] DECLAREBEGIN IF (inserting) THEN
1838[java] UPDATE
1839[java] RWT_rm_bpa
1840[java] SET
1841[java] rwt_recstatus='0'
1842[java] WHERE
1843[java] RWT_rm_bpa_id=:new.RWT_rm_bpa_id;
1844[java] END IF;
1845[java] IF (updating) THEN
1846[java] UPDATE
1847[java] RWT_rm_bpa
1848[java] SET
1849[java] rwt_recstatus='0'
1850[java] WHERE
1851[java] RWT_rm_bpa_id=:new.RWT_rm_bpa_id;
1852[java] END IF;
1853[java] END;
1854[java] 310913 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1855[java]
1856[java] 310971 WARN - -- END
1857[java] -- -----------------------------------------------------------------------
1858[java] -- TRIGGER RWT_RM_BPA_TAX_TRG2
1859[java] -- -----------------------------------------------------------------------
1860[java] CREATE TRIGGER RWT_RM_BPA_TAX_TRG2
1861[java] AFTER INSERT OR UPDATE OR DELETE
1862[java] ON RWT_RM_BPA_TAX FOR EACH ROW
1863[java] DECLAREBEGIN IF (inserting) THEN
1864[java] UPDATE
1865[java] RWT_rm_bpa
1866[java] SET
1867[java] rwt_recstatus='0'
1868[java] WHERE
1869[java] RWT_rm_bpa_id=:new.RWT_rm_bpa_id;
1870[java] END IF;
1871[java] IF (updating) THEN
1872[java] UPDATE
1873[java] RWT_rm_bpa
1874[java] SET
1875[java] rwt_recstatus='0'
1876[java] WHERE
1877[java] RWT_rm_bpa_id=:new.RWT_rm_bpa_id;
1878[java] END IF;
1879[java] END;
1880[java] 311300 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1881[java]
1882[java] 311334 WARN - -- END
1883[java] -- -----------------------------------------------------------------------
1884[java] -- TRIGGER RWT_SALEOUTWARD_DETEN_TRG2
1885[java] -- -----------------------------------------------------------------------
1886[java] CREATE TRIGGER RWT_SALEOUTWARD_DETEN_TRG2
1887[java] AFTER INSERT OR UPDATE OR DELETE
1888[java] ON RWT_SALEOUTWARD_DETEN FOR EACH ROW
1889[java] DECLAREBEGIN
1890[java] IF (INSERTING) THEN
1891[java] UPDATE RWT_SALES_LOAD SET RWT_RECSTATUS='0' WHERE RWT_SALES_LOAD_ID=:NEW.RWT_SALES_LOAD_ID;
1892[java] END IF;
1893[java] IF (UPDATING) THEN
1894[java] UPDATE RWT_SALES_LOAD SET RWT_RECSTATUS='0' WHERE RWT_SALES_LOAD_ID=:NEW.RWT_SALES_LOAD_ID;
1895[java] END IF;
1896[java] END;
1897[java] 311711 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1898[java]
1899[java] 311763 WARN - -- END
1900[java] -- -----------------------------------------------------------------------
1901[java] -- TRIGGER RWT_SALESCONT_DELV_SCH_TRG2
1902[java] -- -----------------------------------------------------------------------
1903[java] CREATE TRIGGER RWT_SALESCONT_DELV_SCH_TRG2
1904[java] AFTER INSERT OR UPDATE OR DELETE
1905[java] ON RWT_SALESCONT_DELV_SCH FOR EACH ROW
1906[java] DECLAREBEGIN IF (inserting) THEN
1907[java] UPDATE
1908[java] RWT_SALES_CONTRACT
1909[java] SET
1910[java] rwt_recstatus='0'
1911[java] WHERE
1912[java] RWT_SALES_CONTRACT_ID=:new.RWT_SALES_CONTRACT_ID;
1913[java] END IF;
1914[java] IF (updating) THEN
1915[java] UPDATE
1916[java] RWT_SALES_CONTRACT
1917[java] SET
1918[java] rwt_recstatus='0'
1919[java] WHERE
1920[java] RWT_SALES_CONTRACT_ID=:new.RWT_SALES_CONTRACT_ID;
1921[java] END IF;
1922[java] END;
1923[java] 311795 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1924[java]
1925[java] 311823 WARN - -- END
1926[java] -- -----------------------------------------------------------------------
1927[java] -- TRIGGER RWT_SALESCONT_QLTYPARA_TRG2
1928[java] -- -----------------------------------------------------------------------
1929[java] CREATE TRIGGER RWT_SALESCONT_QLTYPARA_TRG2
1930[java] AFTER INSERT OR UPDATE OR DELETE
1931[java] ON RWT_SALESCONTRACT_QLTYPARA FOR EACH ROW
1932[java] DECLAREBEGIN IF (inserting) THEN
1933[java] UPDATE
1934[java] RWT_SALES_CONTRACT
1935[java] SET
1936[java] rwt_recstatus='0'
1937[java] WHERE
1938[java] RWT_SALES_CONTRACT_ID=:new.RWT_SALES_CONTRACT_ID;
1939[java] END IF;
1940[java] IF (updating) THEN
1941[java] UPDATE
1942[java] RWT_SALES_CONTRACT
1943[java] SET
1944[java] rwt_recstatus='0'
1945[java] WHERE
1946[java] RWT_SALES_CONTRACT_ID=:new.RWT_SALES_CONTRACT_ID;
1947[java] END IF;
1948[java] END;
1949[java] 312284 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1950[java]
1951[java] 312326 WARN - -- END
1952[java] -- -----------------------------------------------------------------------
1953[java] -- TRIGGER RWT_SALESINVOICE_QLTY_TRG2
1954[java] -- -----------------------------------------------------------------------
1955[java] CREATE TRIGGER RWT_SALESINVOICE_QLTY_TRG2
1956[java] AFTER INSERT OR UPDATE OR DELETE
1957[java] ON RWT_SALESINVOICE_QLTY FOR EACH ROW
1958[java] DECLAREBEGIN IF (inserting) THEN
1959[java] UPDATE
1960[java] RWT_SALESINVOICE
1961[java] SET
1962[java] RWT_RECSTATUS='0'
1963[java] WHERE
1964[java] RWT_SALESINVOICE_id=:NEW.RWT_SALESINVOICE_id;
1965[java] END IF;
1966[java] IF (updating) THEN
1967[java] UPDATE
1968[java] RWT_SALESINVOICE
1969[java] SET
1970[java] RWT_RECSTATUS='0'
1971[java] WHERE
1972[java] RWT_SALESINVOICE_id=:NEW.RWT_SALESINVOICE_id;
1973[java] END IF;
1974[java] END;
1975[java] 312453 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1976[java]
1977[java] 312495 WARN - -- END
1978[java] -- -----------------------------------------------------------------------
1979[java] -- TRIGGER RWT_SALESINVOICE_SURVEY_TRG2
1980[java] -- -----------------------------------------------------------------------
1981[java] CREATE TRIGGER RWT_SALESINVOICE_SURVEY_TRG2
1982[java] AFTER INSERT OR UPDATE OR DELETE
1983[java] ON RWT_SALESINVOICE_SURVEY FOR EACH ROW
1984[java] DECLAREBEGIN
1985[java] if (inserting) then
1986[java] UPDATE RWT_SALESINVOICE SET RWT_RECSTATUS='0' WHERE RWT_SALESINVOICE_ID=:NEW.RWT_SALESINVOICE_ID;
1987[java] end if;
1988[java] if (updating) then
1989[java] UPDATE RWT_SALESINVOICE SET RWT_RECSTATUS='0' WHERE RWT_SALESINVOICE_ID=:NEW.RWT_SALESINVOICE_ID;
1990[java] end if;
1991[java] END;
1992[java] 312851 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
1993[java]
1994[java] 312892 WARN - -- END
1995[java] -- -----------------------------------------------------------------------
1996[java] -- TRIGGER RWT_SALESOFFER_QLTYPARA_TRG2
1997[java] -- -----------------------------------------------------------------------
1998[java] CREATE TRIGGER RWT_SALESOFFER_QLTYPARA_TRG2
1999[java] AFTER INSERT OR UPDATE OR DELETE
2000[java] ON RWT_SALESOFFER_QLTYPARA FOR EACH ROW
2001[java] DECLAREBEGIN IF (inserting) THEN
2002[java] UPDATE
2003[java] RWT_Sales_Offer
2004[java] SET
2005[java] rwt_recstatus='0'
2006[java] WHERE
2007[java] RWT_Sales_Offer_id=:new.RWT_Sales_Offer_id;
2008[java] END IF;
2009[java] IF (updating) THEN
2010[java] UPDATE
2011[java] RWT_Sales_Offer
2012[java] SET
2013[java] rwt_recstatus='0'
2014[java] WHERE
2015[java] RWT_Sales_Offer_id=:new.RWT_Sales_Offer_id;
2016[java] END IF;
2017[java] END;
2018[java] 313349 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2019[java]
2020[java] 313396 WARN - -- END
2021[java] -- -----------------------------------------------------------------------
2022[java] -- TRIGGER RWT_SALES_CONT_DES_DOC_TRG2
2023[java] -- -----------------------------------------------------------------------
2024[java] CREATE TRIGGER RWT_SALES_CONT_DES_DOC_TRG2
2025[java] AFTER INSERT OR UPDATE OR DELETE
2026[java] ON RWT_SALES_CONT_DES_DOC FOR EACH ROW
2027[java] DECLAREBEGIN IF (inserting) THEN
2028[java] UPDATE
2029[java] RWT_SALES_CONTRACT
2030[java] SET
2031[java] rwt_recstatus='0'
2032[java] WHERE
2033[java] RWT_SALES_CONTRACT_ID=:new.RWT_SALES_CONTRACT_ID;
2034[java] END IF;
2035[java] IF (updating) THEN
2036[java] UPDATE
2037[java] RWT_SALES_CONTRACT
2038[java] SET
2039[java] rwt_recstatus='0'
2040[java] WHERE
2041[java] RWT_SALES_CONTRACT_ID=:new.RWT_SALES_CONTRACT_ID;
2042[java] END IF;
2043[java] END;
2044[java] 313670 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2045[java]
2046[java] 313710 WARN - -- END
2047[java] -- -----------------------------------------------------------------------
2048[java] -- TRIGGER RWT_SALES_CONT_PRICE_TRG2
2049[java] -- -----------------------------------------------------------------------
2050[java] CREATE TRIGGER RWT_SALES_CONT_PRICE_TRG2
2051[java] AFTER INSERT OR UPDATE OR DELETE
2052[java] ON RWT_SALES_CONT_PRICE FOR EACH ROW
2053[java] DECLAREBEGIN
2054[java] /*
2055[java] if (inserting) then
2056[java] update RWT_SALES_CONTRACT set rwt_recstatus='0' where RWT_SALES_CONTRACT_ID=:new.RWT_SALES_CONTRACT_ID;
2057[java] end if;
2058[java] */
2059[java] IF (updating) THEN
2060[java] UPDATE
2061[java] RWT_SALES_CONTRACT
2062[java] SET
2063[java] rwt_recstatus='0'
2064[java] WHERE
2065[java] RWT_SALES_CONTRACT_ID=:new.RWT_SALES_CONTRACT_ID;
2066[java] END IF;
2067[java] END;
2068[java] 314070 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2069[java]
2070[java] 314107 WARN - -- END
2071[java] -- -----------------------------------------------------------------------
2072[java] -- TRIGGER RWT_SALES_LOAD_QUALITY_TRG2
2073[java] -- -----------------------------------------------------------------------
2074[java] CREATE TRIGGER RWT_SALES_LOAD_QUALITY_TRG2
2075[java] AFTER INSERT OR UPDATE OR DELETE
2076[java] ON RWT_SALES_LOAD_QUALITY FOR EACH ROW
2077[java] DECLAREBEGIN IF (INSERTING) THEN
2078[java] UPDATE
2079[java] RWT_SALES_LOAD slld
2080[java] SET
2081[java] RWT_RECSTATUS='0'
2082[java] WHERE
2083[java] EXISTS
2084[java] (
2085[java] SELECT
2086[java] 1
2087[java] FROM
2088[java] RWT_SALES_LOAD_prod
2089[java] WHERE
2090[java] RWT_SALES_LOAD_ID=slld.RWT_SALES_LOAD_ID
2091[java] AND RWT_SALES_LOAD_PROD_ID=:NEW.RWT_SALES_LOAD_PROD_ID
2092[java] );
2093[java] END IF;
2094[java] IF (UPDATING) THEN
2095[java] UPDATE
2096[java] RWT_SALES_LOAD slld
2097[java] SET
2098[java] RWT_RECSTATUS='0'
2099[java] WHERE
2100[java] EXISTS
2101[java] (
2102[java] SELECT
2103[java] 1
2104[java] FROM
2105[java] RWT_SALES_LOAD_prod
2106[java] WHERE
2107[java] RWT_SALES_LOAD_ID=slld.RWT_SALES_LOAD_ID
2108[java] AND RWT_SALES_LOAD_PROD_ID=:NEW.RWT_SALES_LOAD_PROD_ID
2109[java] );
2110[java] END IF;
2111[java] END;
2112[java] 314526 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2113[java]
2114[java] 314566 WARN - -- END
2115[java] -- -----------------------------------------------------------------------
2116[java] -- TRIGGER RWT_SALES_OFFER_EST_EXP_TRG2
2117[java] -- -----------------------------------------------------------------------
2118[java] CREATE TRIGGER RWT_SALES_OFFER_EST_EXP_TRG2
2119[java] AFTER INSERT OR UPDATE OR DELETE
2120[java] ON RWT_SALES_OFFER_EST_EXP FOR EACH ROW
2121[java] DECLAREBEGIN IF (inserting) THEN
2122[java] UPDATE
2123[java] RWT_Sales_Offer
2124[java] SET
2125[java] rwt_recstatus='0'
2126[java] WHERE
2127[java] RWT_Sales_Offer_id=:new.RWT_Sales_Offer_id;
2128[java] END IF;
2129[java] IF (updating) THEN
2130[java] UPDATE
2131[java] RWT_Sales_Offer
2132[java] SET
2133[java] rwt_recstatus='0'
2134[java] WHERE
2135[java] RWT_Sales_Offer_id=:new.RWT_Sales_Offer_id;
2136[java] END IF;
2137[java] END;
2138[java] 315346 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2139[java]
2140[java] 315356 WARN - -- END
2141[java] -- -----------------------------------------------------------------------
2142[java] -- TRIGGER RWT_SALE_LOAD_PROD_WH_TRG2
2143[java] -- -----------------------------------------------------------------------
2144[java] CREATE TRIGGER RWT_SALE_LOAD_PROD_WH_TRG2
2145[java] AFTER INSERT OR UPDATE OR DELETE
2146[java] ON RWT_SALE_LOAD_PROD_WH FOR EACH ROW
2147[java] DECLAREBEGIN IF (INSERTING) THEN
2148[java] UPDATE
2149[java] RWT_Sales_Load slld
2150[java] SET
2151[java] RWT_RECSTATUS='0'
2152[java] WHERE
2153[java] EXISTS
2154[java] (
2155[java] SELECT
2156[java] 1
2157[java] FROM
2158[java] RWT_Sales_Load_prod
2159[java] WHERE
2160[java] RWT_Sales_Load_ID=slld.RWT_Sales_Load_ID
2161[java] AND RWT_Sales_Load_PROD_ID=:NEW.RWT_Sales_Load_PROD_ID
2162[java] );
2163[java] END IF;
2164[java] IF (UPDATING) THEN
2165[java] UPDATE
2166[java] RWT_Sales_Load slld
2167[java] SET
2168[java] RWT_RECSTATUS='0'
2169[java] WHERE
2170[java] EXISTS
2171[java] (
2172[java] SELECT
2173[java] 1
2174[java] FROM
2175[java] RWT_Sales_Load_prod
2176[java] WHERE
2177[java] RWT_Sales_Load_ID=slld.RWT_Sales_Load_ID
2178[java] AND RWT_Sales_Load_PROD_ID=:NEW.RWT_Sales_Load_PROD_ID
2179[java] );
2180[java] END IF;
2181[java] END;
2182[java] 315412 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2183[java]
2184[java] 315423 WARN - -- END
2185[java] -- -----------------------------------------------------------------------
2186[java] -- TRIGGER RWT_SALE_LOAD_SAMPLES_TRG2
2187[java] -- -----------------------------------------------------------------------
2188[java] CREATE TRIGGER RWT_SALE_LOAD_SAMPLES_TRG2
2189[java] AFTER INSERT OR UPDATE OR DELETE
2190[java] ON RWT_SALE_LOAD_SAMPLES FOR EACH ROW
2191[java] DECLAREBEGIN IF (inserting) THEN
2192[java] UPDATE
2193[java] RWT_SALEs_LOAD
2194[java] SET
2195[java] rwt_recstatus='0'
2196[java] WHERE
2197[java] RWT_SALEs_LOAD_ID=:new.RWT_SALEs_LOAD_id;
2198[java] END IF;
2199[java] IF (updating) THEN
2200[java] UPDATE
2201[java] RWT_SALEs_LOAD
2202[java] SET
2203[java] rwt_recstatus='0'
2204[java] WHERE
2205[java] RWT_SALEs_LOAD_ID=:new.RWT_SALEs_LOAD_id;
2206[java] END IF;
2207[java] END;
2208[java] 315475 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2209[java]
2210[java] 315491 WARN - -- END
2211[java] -- -----------------------------------------------------------------------
2212[java] -- TRIGGER RWT_SALE_OUTWARD_DES_DOC_TRG2
2213[java] -- -----------------------------------------------------------------------
2214[java] CREATE TRIGGER RWT_SALE_OUTWARD_DES_DOC_TRG2
2215[java] AFTER INSERT OR UPDATE OR DELETE
2216[java] ON RWT_SALE_OUTWARD_DES_DOC FOR EACH ROW
2217[java] DECLAREBEGIN IF (INSERTING) THEN
2218[java] UPDATE
2219[java] RWT_SALE_OUTWARD slotwd
2220[java] SET
2221[java] RWT_RECSTATUS='0'
2222[java] WHERE
2223[java] EXISTS
2224[java] (
2225[java] SELECT
2226[java] 1
2227[java] FROM
2228[java] RWT_SALE_OUTWARD_prod
2229[java] WHERE
2230[java] RWT_SALE_OUTWARD_ID=slotwd.RWT_SALE_OUTWARD_ID
2231[java] AND RWT_SALE_OUTWARD_PROD_ID=:NEW.RWT_SALE_OUTWARD_PROD_ID
2232[java] );
2233[java] END IF;
2234[java] IF (UPDATING) THEN
2235[java] UPDATE
2236[java] RWT_SALE_OUTWARD slotwd
2237[java] SET
2238[java] RWT_RECSTATUS='0'
2239[java] WHERE
2240[java] EXISTS
2241[java] (
2242[java] SELECT
2243[java] 1
2244[java] FROM
2245[java] RWT_SALE_OUTWARD_prod
2246[java] WHERE
2247[java] RWT_SALE_OUTWARD_ID=slotwd.RWT_SALE_OUTWARD_ID
2248[java] AND RWT_SALE_OUTWARD_PROD_ID=:NEW.RWT_SALE_OUTWARD_PROD_ID
2249[java] );
2250[java] END IF;
2251[java] END;
2252[java] 315850 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2253[java]
2254[java] 315864 WARN - -- END
2255[java] -- -----------------------------------------------------------------------
2256[java] -- TRIGGER RWT_SALE_RET_INWARD_WH_TRG2
2257[java] -- -----------------------------------------------------------------------
2258[java] CREATE TRIGGER RWT_SALE_RET_INWARD_WH_TRG2
2259[java] AFTER INSERT OR UPDATE OR DELETE
2260[java] ON RWT_SALE_RET_INWARD_WH FOR EACH ROW
2261[java] DECLAREBEGIN IF (inserting) THEN
2262[java] UPDATE
2263[java] rwt_sale_ret_inward
2264[java] SET
2265[java] rwt_recstatus='0'
2266[java] WHERE
2267[java] rwt_sale_ret_inward_id=:new.rwt_sale_ret_inward_id;
2268[java] END IF;
2269[java] IF (updating) THEN
2270[java] UPDATE
2271[java] rwt_sale_ret_inward
2272[java] SET
2273[java] rwt_recstatus='0'
2274[java] WHERE
2275[java] rwt_sale_ret_inward_id=:new.rwt_sale_ret_inward_id;
2276[java] END IF;
2277[java] END;
2278[java] 316099 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2279[java]
2280[java] 316110 WARN - -- END
2281[java] -- -----------------------------------------------------------------------
2282[java] -- TRIGGER RWT_SCRAP_DELV_SCH_TRG2
2283[java] -- -----------------------------------------------------------------------
2284[java] CREATE TRIGGER RWT_SCRAP_DELV_SCH_TRG2
2285[java] AFTER INSERT OR UPDATE OR DELETE
2286[java] ON RWT_SCRAP_DELV_SCH FOR EACH ROW
2287[java] DECLAREBEGIN IF (inserting) THEN
2288[java] UPDATE
2289[java] RWT_Scrap_Sale_Cont
2290[java] SET
2291[java] rwt_recstatus='0'
2292[java] WHERE
2293[java] RWT_Scrap_Sale_Cont_ID=:new.RWT_Scrap_Sale_Cont_ID;
2294[java] END IF;
2295[java] IF (updating) THEN
2296[java] UPDATE
2297[java] RWT_Scrap_Sale_Cont
2298[java] SET
2299[java] rwt_recstatus='0'
2300[java] WHERE
2301[java] RWT_Scrap_Sale_Cont_ID=:new.RWT_Scrap_Sale_Cont_ID;
2302[java] END IF;
2303[java] END;
2304[java] 316167 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2305[java]
2306[java] 316184 WARN - -- END
2307[java] -- -----------------------------------------------------------------------
2308[java] -- TRIGGER RWT_SCRAP_SALE_CONT_MAT_TRG2
2309[java] -- -----------------------------------------------------------------------
2310[java] CREATE TRIGGER RWT_SCRAP_SALE_CONT_MAT_TRG2
2311[java] AFTER INSERT OR UPDATE OR DELETE
2312[java] ON RWT_SCRAP_SALE_CONT_MAT FOR EACH ROW
2313[java] DECLAREBEGIN
2314[java] IF (INSERTING) THEN
2315[java] UPDATE RWT_SCRAP_SALE_CONT SET RWT_RECSTATUS='0' WHERE RWT_SCRAP_SALE_CONT_ID=:NEW.RWT_SCRAP_SALE_CONT_ID;
2316[java] END IF;
2317[java] IF (UPDATING) THEN
2318[java] UPDATE RWT_SCRAP_SALE_CONT SET RWT_RECSTATUS='0' WHERE RWT_SCRAP_SALE_CONT_ID=:NEW.RWT_SCRAP_SALE_CONT_ID;
2319[java] END IF;
2320[java] END;
2321[java] 316253 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2322[java]
2323[java] 316263 WARN - -- END
2324[java] -- -----------------------------------------------------------------------
2325[java] -- TRIGGER RWT_SCRAP_SALE_CONT_TAX_TRG2
2326[java] -- -----------------------------------------------------------------------
2327[java] CREATE TRIGGER RWT_SCRAP_SALE_CONT_TAX_TRG2
2328[java] AFTER INSERT OR UPDATE OR DELETE
2329[java] ON RWT_SCRAP_SALE_CONT_TAX FOR EACH ROW
2330[java] DECLAREBEGIN IF (inserting) THEN
2331[java] UPDATE
2332[java] RWT_Scrap_Sale_Cont
2333[java] SET
2334[java] rwt_recstatus='0'
2335[java] WHERE
2336[java] RWT_Scrap_Sale_Cont_ID=:new.RWT_Scrap_Sale_Cont_ID;
2337[java] END IF;
2338[java] IF (updating) THEN
2339[java] UPDATE
2340[java] RWT_Scrap_Sale_Cont
2341[java] SET
2342[java] rwt_recstatus='0'
2343[java] WHERE
2344[java] RWT_Scrap_Sale_Cont_ID=:new.RWT_Scrap_Sale_Cont_ID;
2345[java] END IF;
2346[java] END;
2347[java] 316651 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2348[java]
2349[java] 316757 WARN - -- END
2350[java] -- -----------------------------------------------------------------------
2351[java] -- TRIGGER RWT_STLOAN_RETN_BACK_TRG2
2352[java] -- -----------------------------------------------------------------------
2353[java] CREATE TRIGGER RWT_STLOAN_RETN_BACK_TRG2
2354[java] AFTER INSERT OR UPDATE OR DELETE
2355[java] ON RWT_STLOAN_RETN_BACK FOR EACH ROW
2356[java] DECLAREdeclare
2357[java] v_counter number(10,0);
2358[java] begin
2359[java] IF (inserting) THEN
2360[java] /* UPDATE RWT_Storeloan_Taken stlntk SET RWT_RECSTATUS='0' WHERE
2361[java] EXISTS
2362[java] (
2363[java] SELECT
2364[java] 1
2365[java] FROM
2366[java] RWT_Storeloan_Taken_Mat
2367[java] WHERE
2368[java] RWT_Storeloan_Taken_ID=stlntk.RWT_Storeloan_Taken_ID
2369[java] AND RWT_Storeloan_Taken_Mat_ID=:NEW.RWT_Storeloan_Taken_Mat_ID
2370[java] );*/
2371[java] IF (:new.rwt_recstatus='1') THEN
2372[java] v_counter := RWT_WHStockEntry('RWT_STLOAN_RETN_BACK_ID', :new.RWT_STLOAN_RETN_BACK_ID, :new.Ad_Client_ID, :new.Ad_Org_ID);
2373[java] END IF;
2374[java] END IF;
2375[java] IF (updating) THEN
2376[java] /* UPDATE
2377[java] RWT_Storeloan_Taken stlntk
2378[java] SET
2379[java] RWT_RECSTATUS='0'
2380[java] WHERE
2381[java] EXISTS
2382[java] (
2383[java] SELECT
2384[java] 1
2385[java] FROM
2386[java] RWT_Storeloan_Taken_Mat
2387[java] WHERE
2388[java] RWT_Storeloan_Taken_ID=stlntk.RWT_Storeloan_Taken_ID
2389[java] AND RWT_Storeloan_Taken_Mat_ID=:NEW.RWT_Storeloan_Taken_Mat_ID
2390[java] );
2391[java] */
2392[java] IF (:new.rwt_recstatus='1') THEN
2393[java] v_counter := RWT_WHStockEntry('RWT_STLOAN_RETN_BACK_ID', :new.RWT_STLOAN_RETN_BACK_ID, :new.Ad_Client_ID, :new.Ad_Org_ID);
2394[java] END IF;
2395[java] END IF;
2396[java] END;
2397[java] 316917 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2398[java]
2399[java] 316921 WARN - -- END
2400[java] -- -----------------------------------------------------------------------
2401[java] -- TRIGGER RWT_STORBPATAX_TRG2
2402[java] -- -----------------------------------------------------------------------
2403[java] CREATE TRIGGER RWT_STORBPATAX_TRG2
2404[java] AFTER INSERT OR UPDATE OR DELETE
2405[java] ON RWT_STORES_BPA_TAX FOR EACH ROW
2406[java] DECLAREBEGIN IF (inserting) THEN
2407[java] UPDATE
2408[java] RWT_STORES_bpa stbpa
2409[java] SET
2410[java] RWT_RECSTATUS='0'
2411[java] WHERE
2412[java] EXISTS
2413[java] (
2414[java] SELECT
2415[java] 1
2416[java] FROM
2417[java] RWT_STORES_BPA_MAT
2418[java] WHERE
2419[java] RWT_STORES_BPA_MAT.RWT_STORES_BPA_ID= stbpa.rwt_stores_bpa_id
2420[java] AND RWT_STORES_BPA_MAT.RWT_STORES_BPA_MAT_ID=:NEW.RWT_STORES_BPA_MAT_ID
2421[java] );
2422[java] END IF;
2423[java] IF (updating) THEN
2424[java] UPDATE
2425[java] RWT_STORES_bpa stbpa
2426[java] SET
2427[java] RWT_RECSTATUS='0'
2428[java] WHERE
2429[java] EXISTS
2430[java] (
2431[java] SELECT
2432[java] 1
2433[java] FROM
2434[java] RWT_STORES_BPA_MAT
2435[java] WHERE
2436[java] RWT_STORES_BPA_MAT.RWT_STORES_BPA_ID= stbpa.rwt_stores_bpa_id
2437[java] AND RWT_STORES_BPA_MAT.RWT_STORES_BPA_MAT_ID=:NEW.RWT_STORES_BPA_MAT_ID
2438[java] );
2439[java] END IF;
2440[java] END;
2441[java] 316973 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2442[java]
2443[java] 316984 WARN - -- END
2444[java] -- -----------------------------------------------------------------------
2445[java] -- TRIGGER RWT_STORELOAN_GIVEN_MAT_TRG2
2446[java] -- -----------------------------------------------------------------------
2447[java] CREATE TRIGGER RWT_STORELOAN_GIVEN_MAT_TRG2
2448[java] AFTER INSERT OR UPDATE OR DELETE
2449[java] ON RWT_STORELOAN_GIVEN_MAT FOR EACH ROW
2450[java] DECLAREBEGIN IF (inserting) THEN
2451[java] UPDATE
2452[java] RWT_Storeloan_Given
2453[java] SET
2454[java] rwt_recstatus='0'
2455[java] WHERE
2456[java] RWT_Storeloan_Given_id=:new.RWT_Storeloan_Given_id;
2457[java] END IF;
2458[java] IF (updating) THEN
2459[java] UPDATE
2460[java] RWT_Storeloan_Given
2461[java] SET
2462[java] rwt_recstatus='0'
2463[java] WHERE
2464[java] RWT_Storeloan_Given_id=:new.RWT_Storeloan_Given_id;
2465[java] END IF;
2466[java] END;
2467[java] 317102 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2468[java]
2469[java] 317106 WARN - -- END
2470[java] -- -----------------------------------------------------------------------
2471[java] -- TRIGGER RWT_STORELOAN_TAKEN_MAT_TRG2
2472[java] -- -----------------------------------------------------------------------
2473[java] CREATE TRIGGER RWT_STORELOAN_TAKEN_MAT_TRG2
2474[java] AFTER INSERT OR UPDATE OR DELETE
2475[java] ON RWT_STORELOAN_TAKEN_MAT FOR EACH ROW
2476[java] DECLAREBEGIN IF (inserting) THEN
2477[java] UPDATE
2478[java] RWT_Storeloan_Taken
2479[java] SET
2480[java] rwt_recstatus='0'
2481[java] WHERE
2482[java] RWT_Storeloan_Taken_id=:new.RWT_Storeloan_Taken_id;
2483[java] END IF;
2484[java] IF (updating) THEN
2485[java] UPDATE
2486[java] RWT_Storeloan_Taken
2487[java] SET
2488[java] rwt_recstatus='0'
2489[java] WHERE
2490[java] RWT_Storeloan_Taken_id=:new.RWT_Storeloan_Taken_id;
2491[java] END IF;
2492[java] END;
2493[java] 317223 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2494[java]
2495[java] 317228 WARN - -- END
2496[java] -- -----------------------------------------------------------------------
2497[java] -- TRIGGER RWT_STORESINWARD_DETEN_TRG2
2498[java] -- -----------------------------------------------------------------------
2499[java] CREATE TRIGGER RWT_STORESINWARD_DETEN_TRG2
2500[java] AFTER INSERT OR UPDATE OR DELETE
2501[java] ON RWT_STORESINWARD_DETEN FOR EACH ROW
2502[java] DECLAREBEGIN IF (INSERTING) THEN
2503[java] UPDATE
2504[java] RWT_STORES_INWARD
2505[java] SET
2506[java] RWT_RECSTATUS='0'
2507[java] WHERE
2508[java] RWT_STORES_INWARD_ID=:NEW.RWT_STORES_INWARD_ID;
2509[java] END IF;
2510[java] IF (UPDATING) THEN
2511[java] UPDATE
2512[java] RWT_STORES_INWARD
2513[java] SET
2514[java] RWT_RECSTATUS='0'
2515[java] WHERE
2516[java] RWT_STORES_INWARD_ID=:NEW.RWT_STORES_INWARD_ID;
2517[java] END IF;
2518[java] END;
2519[java] 317278 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2520[java]
2521[java] 317283 WARN - -- END
2522[java] -- -----------------------------------------------------------------------
2523[java] -- TRIGGER RWT_STORESPO_CANCEL_MAT_TRG2
2524[java] -- -----------------------------------------------------------------------
2525[java] CREATE TRIGGER RWT_STORESPO_CANCEL_MAT_TRG2
2526[java] AFTER INSERT OR UPDATE OR DELETE
2527[java] ON RWT_STORESPO_CANCEL_MAT FOR EACH ROW
2528[java] DECLAREBEGIN
2529[java] IF (inserting) THEN
2530[java] UPDATE RWT_Storespo_Cancel SET rwt_recstatus='0' WHERE RWT_Storespo_Cancel_id=:new.RWT_Storespo_Cancel_id AND rwt_recstatus<>'0';
2531[java] END IF;
2532[java] IF (updating) THEN
2533[java] UPDATE RWT_Storespo_Cancel SET rwt_recstatus='0' WHERE RWT_Storespo_Cancel_id=:new.RWT_Storespo_Cancel_id AND rwt_recstatus<>'0';
2534[java] END IF;
2535[java] END;
2536[java] 317378 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2537[java]
2538[java] 317382 WARN - -- END
2539[java] -- -----------------------------------------------------------------------
2540[java] -- TRIGGER RWT_STORESPO_COLLIERY_TRG2
2541[java] -- -----------------------------------------------------------------------
2542[java] CREATE TRIGGER RWT_STORESPO_COLLIERY_TRG2
2543[java] AFTER INSERT OR UPDATE OR DELETE
2544[java] ON RWT_STORESPO_COLLIERY FOR EACH ROW
2545[java] DECLAREBEGIN IF (inserting) THEN
2546[java] UPDATE
2547[java] RWT_STORES_po stpo
2548[java] SET
2549[java] RWT_RECSTATUS='0'
2550[java] WHERE
2551[java] rwt_stores_po_id= :NEW.rwt_stores_po_id;
2552[java] END IF;
2553[java] IF (updating) THEN
2554[java] UPDATE
2555[java] RWT_STORES_po stpo
2556[java] SET
2557[java] RWT_RECSTATUS='0'
2558[java] WHERE
2559[java] rwt_stores_po_id= :NEW.rwt_stores_po_id;
2560[java] END IF;
2561[java] END;
2562[java] 317445 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2563[java]
2564[java] 317449 WARN - -- END
2565[java] -- -----------------------------------------------------------------------
2566[java] -- TRIGGER RWT_STORESPO_DELV_SCH_TRG2
2567[java] -- -----------------------------------------------------------------------
2568[java] CREATE TRIGGER RWT_STORESPO_DELV_SCH_TRG2
2569[java] AFTER INSERT OR UPDATE OR DELETE
2570[java] ON RWT_STORESPO_DELV_SCH FOR EACH ROW
2571[java] DECLAREBEGIN IF (inserting) THEN
2572[java] UPDATE
2573[java] RWT_STORES_PO
2574[java] SET
2575[java] rwt_recstatus='0'
2576[java] WHERE
2577[java] RWT_STORES_PO_ID=:new.RWT_STORES_PO_ID;
2578[java] END IF;
2579[java] IF (updating) THEN
2580[java] UPDATE
2581[java] RWT_STORES_PO
2582[java] SET
2583[java] rwt_recstatus='0'
2584[java] WHERE
2585[java] RWT_STORES_PO_ID=:new.RWT_STORES_PO_ID;
2586[java] END IF;
2587[java] END;
2588[java] 317500 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2589[java]
2590[java] 317504 WARN - -- END
2591[java] -- -----------------------------------------------------------------------
2592[java] -- TRIGGER RWT_STORESPO_INDENT_REL_TRG2
2593[java] -- -----------------------------------------------------------------------
2594[java] CREATE TRIGGER RWT_STORESPO_INDENT_REL_TRG2
2595[java] AFTER INSERT OR UPDATE OR DELETE
2596[java] ON RWT_STORESPO_INDENT_REL FOR EACH ROW
2597[java] DECLAREBEGIN IF (inserting) THEN
2598[java] UPDATE
2599[java] RWT_STORES_PO
2600[java] SET
2601[java] rwt_recstatus='0'
2602[java] WHERE
2603[java] RWT_STORES_PO_ID=:new.RWT_STORES_PO_ID;
2604[java] END IF;
2605[java] IF (updating) THEN
2606[java] UPDATE
2607[java] RWT_STORES_PO
2608[java] SET
2609[java] rwt_recstatus='0'
2610[java] WHERE
2611[java] RWT_STORES_PO_ID=:new.RWT_STORES_PO_ID;
2612[java] END IF;
2613[java] END;
2614[java] 317555 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2615[java]
2616[java] 317560 WARN - -- END
2617[java] -- -----------------------------------------------------------------------
2618[java] -- TRIGGER RWT_STORESPO_MAT_EXP_TAX_TRG2
2619[java] -- -----------------------------------------------------------------------
2620[java] CREATE TRIGGER RWT_STORESPO_MAT_EXP_TAX_TRG2
2621[java] AFTER INSERT OR UPDATE OR DELETE
2622[java] ON RWT_STORESPO_MAT_EXP_TAX FOR EACH ROW
2623[java] DECLAREBEGIN IF (inserting) THEN
2624[java] UPDATE
2625[java] RWT_STORES_po stpo
2626[java] SET
2627[java] RWT_RECSTATUS='0'
2628[java] WHERE
2629[java] EXISTS
2630[java] (
2631[java] SELECT
2632[java] 1
2633[java] FROM
2634[java] RWT_Storespo_Mat
2635[java] WHERE
2636[java] rwt_storespo_mat.rwt_stores_po_id= stpo.rwt_stores_po_id
2637[java] AND rwt_storespo_mat.rwt_storespo_mat_id=:NEW.rwt_storespo_mat_id
2638[java] );
2639[java] END IF;
2640[java] IF (updating) THEN
2641[java] UPDATE
2642[java] RWT_STORES_po stpo
2643[java] SET
2644[java] RWT_RECSTATUS='0'
2645[java] WHERE
2646[java] EXISTS
2647[java] (
2648[java] SELECT
2649[java] 1
2650[java] FROM
2651[java] RWT_Storespo_Mat
2652[java] WHERE
2653[java] rwt_storespo_mat.rwt_stores_po_id= stpo.rwt_stores_po_id
2654[java] AND rwt_storespo_mat.rwt_storespo_mat_id=:NEW.rwt_storespo_mat_id
2655[java] );
2656[java] END IF;
2657[java] END;
2658[java] 317702 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2659[java]
2660[java] 317708 WARN - -- END
2661[java] -- -----------------------------------------------------------------------
2662[java] -- TRIGGER RWT_STORESPO_MAT_TRG2
2663[java] -- -----------------------------------------------------------------------
2664[java] CREATE TRIGGER RWT_STORESPO_MAT_TRG2
2665[java] AFTER INSERT OR UPDATE OR DELETE
2666[java] ON RWT_STORESPO_MAT FOR EACH ROW
2667[java] DECLAREBEGIN IF (inserting) THEN
2668[java] UPDATE
2669[java] RWT_Stores_po
2670[java] SET
2671[java] rwt_recstatus='0'
2672[java] WHERE
2673[java] RWT_Stores_po_id=:new.RWT_Stores_po_id;
2674[java] END IF;
2675[java] IF (updating) THEN
2676[java] UPDATE
2677[java] RWT_Stores_po
2678[java] SET
2679[java] rwt_recstatus='0'
2680[java] WHERE
2681[java] RWT_Stores_po_id=:new.RWT_Stores_po_id;
2682[java] END IF;
2683[java] END;
2684[java] 317801 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2685[java]
2686[java] 317806 WARN - -- END
2687[java] -- -----------------------------------------------------------------------
2688[java] -- TRIGGER RWT_STORESPO_SETTLE_MAT_TRG2
2689[java] -- -----------------------------------------------------------------------
2690[java] CREATE TRIGGER RWT_STORESPO_SETTLE_MAT_TRG2
2691[java] AFTER INSERT OR UPDATE OR DELETE
2692[java] ON RWT_STORESPO_SETTLE_MAT FOR EACH ROW
2693[java] DECLAREBEGIN IF (inserting) THEN
2694[java] UPDATE
2695[java] RWT_Storespo_Settlement
2696[java] SET
2697[java] rwt_recstatus='0'
2698[java] WHERE
2699[java] RWT_Storespo_Settlement_id=:new.RWT_Storespo_Settlement_id;
2700[java] END IF;
2701[java] IF (updating) THEN
2702[java] UPDATE
2703[java] RWT_Storespo_Settlement
2704[java] SET
2705[java] rwt_recstatus='0'
2706[java] WHERE
2707[java] RWT_Storespo_Settlement_id=:new.RWT_Storespo_Settlement_id;
2708[java] END IF;
2709[java] END;
2710[java] 317880 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2711[java]
2712[java] 317885 WARN - -- END
2713[java] -- -----------------------------------------------------------------------
2714[java] -- TRIGGER RWT_STORESREQUISITION_MAT_TRG2
2715[java] -- -----------------------------------------------------------------------
2716[java] CREATE TRIGGER RWT_STORESREQUISITION_MAT_TRG2
2717[java] AFTER INSERT OR UPDATE OR DELETE
2718[java] ON RWT_STORESREQUISITION_MAT FOR EACH ROW
2719[java] DECLAREBEGIN IF (inserting) THEN
2720[java] UPDATE
2721[java] RWT_STORESREQUISITION
2722[java] SET
2723[java] rwt_recstatus='0'
2724[java] WHERE
2725[java] RWT_STORESREQUISITION_id=:new.RWT_STORESREQUISITION_id;
2726[java] END IF;
2727[java] IF (updating) THEN
2728[java] UPDATE
2729[java] RWT_STORESREQUISITION
2730[java] SET
2731[java] rwt_recstatus='0'
2732[java] WHERE
2733[java] RWT_STORESREQUISITION_id=:new.RWT_STORESREQUISITION_id;
2734[java] END IF;
2735[java] END;
2736[java] 318012 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2737[java]
2738[java] 318021 WARN - -- END
2739[java] -- -----------------------------------------------------------------------
2740[java] -- TRIGGER RWT_STORESRETBYDEPT_MAT_TRG2
2741[java] -- -----------------------------------------------------------------------
2742[java] CREATE TRIGGER RWT_STORESRETBYDEPT_MAT_TRG2
2743[java] AFTER INSERT OR UPDATE OR DELETE
2744[java] ON RWT_STORESRETBYDEPT_MAT FOR EACH ROW
2745[java] DECLAREBEGIN IF (inserting) THEN
2746[java] UPDATE
2747[java] RWT_Stores_Retbydept
2748[java] SET
2749[java] rwt_recstatus='0'
2750[java] WHERE
2751[java] RWT_Stores_Retbydept_ID=:new.RWT_Stores_Retbydept_ID;
2752[java] END IF;
2753[java] IF (updating) THEN
2754[java] UPDATE
2755[java] RWT_Stores_Retbydept
2756[java] SET
2757[java] rwt_recstatus='0'
2758[java] WHERE
2759[java] RWT_Stores_Retbydept_ID=:new.RWT_Stores_Retbydept_ID;
2760[java] END IF;
2761[java] END;
2762[java] 318070 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2763[java]
2764[java] 318075 WARN - -- END
2765[java] -- -----------------------------------------------------------------------
2766[java] -- TRIGGER RWT_STORES_BPA_EXP_TRG2
2767[java] -- -----------------------------------------------------------------------
2768[java] CREATE TRIGGER RWT_STORES_BPA_EXP_TRG2
2769[java] AFTER INSERT OR UPDATE OR DELETE
2770[java] ON RWT_STORES_BPA_EXP FOR EACH ROW
2771[java] DECLAREBEGIN IF (inserting) THEN
2772[java] UPDATE
2773[java] RWT_STORES_BPA stbpa
2774[java] SET
2775[java] RWT_RECSTATUS='0'
2776[java] WHERE
2777[java] EXISTS
2778[java] (
2779[java] SELECT
2780[java] 1
2781[java] FROM
2782[java] rwt_stores_bpa_mat
2783[java] WHERE
2784[java] rwt_stores_bpa_mat.rwt_stores_bpa_id= stbpa.rwt_stores_bpa_id
2785[java] AND rwt_stores_bpa_mat_id=:NEW.rwt_stores_bpa_mat_id
2786[java] );
2787[java] END IF;
2788[java] IF (updating) THEN
2789[java] UPDATE
2790[java] RWT_STORES_BPA stbpa
2791[java] SET
2792[java] RWT_RECSTATUS='0'
2793[java] WHERE
2794[java] EXISTS
2795[java] (
2796[java] SELECT
2797[java] 1
2798[java] FROM
2799[java] rwt_stores_bpa_mat
2800[java] WHERE
2801[java] rwt_stores_bpa_mat.rwt_stores_bpa_id= stbpa.rwt_stores_bpa_id
2802[java] AND rwt_stores_bpa_mat_id=:NEW.rwt_stores_bpa_mat_id
2803[java] );
2804[java] END IF;
2805[java] END;
2806[java] 318123 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2807[java]
2808[java] 318130 WARN - -- END
2809[java] -- -----------------------------------------------------------------------
2810[java] -- TRIGGER RWT_STORES_BPA_MAT_TRG2
2811[java] -- -----------------------------------------------------------------------
2812[java] CREATE TRIGGER RWT_STORES_BPA_MAT_TRG2
2813[java] AFTER INSERT OR UPDATE OR DELETE
2814[java] ON RWT_STORES_BPA_MAT FOR EACH ROW
2815[java] DECLAREBEGIN IF (inserting) THEN
2816[java] UPDATE
2817[java] RWT_Stores_Bpa
2818[java] SET
2819[java] rwt_recstatus='0'
2820[java] WHERE
2821[java] RWT_Stores_Bpa_id=:new.RWT_Stores_Bpa_id;
2822[java] END IF;
2823[java] IF (updating) THEN
2824[java] UPDATE
2825[java] RWT_Stores_Bpa
2826[java] SET
2827[java] rwt_recstatus='0'
2828[java] WHERE
2829[java] RWT_Stores_Bpa_id=:new.RWT_Stores_Bpa_id;
2830[java] END IF;
2831[java] END;
2832[java] 318277 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2833[java]
2834[java] 318282 WARN - -- END
2835[java] -- -----------------------------------------------------------------------
2836[java] -- TRIGGER RWT_STORES_INDENT_APPROV_TRG2
2837[java] -- -----------------------------------------------------------------------
2838[java] CREATE TRIGGER RWT_STORES_INDENT_APPROV_TRG2
2839[java] AFTER INSERT OR UPDATE OR DELETE
2840[java] ON RWT_STORES_INDENT_APPROV FOR EACH ROW
2841[java] DECLAREBEGIN IF (inserting) THEN
2842[java] UPDATE
2843[java] rwt_STORES_INDENT
2844[java] SET
2845[java] rwt_recstatus='0'
2846[java] WHERE
2847[java] rwt_STORES_INDENT_id=:new.rwt_STORES_INDENT_id;
2848[java] END IF;
2849[java] IF (updating) THEN
2850[java] UPDATE
2851[java] rwt_STORES_INDENT
2852[java] SET
2853[java] rwt_recstatus='0'
2854[java] WHERE
2855[java] rwt_STORES_INDENT_id=:new.rwt_STORES_INDENT_id;
2856[java] END IF;
2857[java] END;
2858[java] 318332 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2859[java]
2860[java] 318337 WARN - -- END
2861[java] -- -----------------------------------------------------------------------
2862[java] -- TRIGGER RWT_STORES_INDENT_MAT_TRG2
2863[java] -- -----------------------------------------------------------------------
2864[java] CREATE TRIGGER RWT_STORES_INDENT_MAT_TRG2
2865[java] AFTER INSERT OR UPDATE OR DELETE
2866[java] ON RWT_STORES_INDENT_MAT FOR EACH ROW
2867[java] DECLAREBEGIN IF (inserting) THEN
2868[java] UPDATE
2869[java] rwt_STORES_INDENT
2870[java] SET
2871[java] rwt_recstatus='0'
2872[java] WHERE
2873[java] rwt_STORES_INDENT_id=:new.rwt_STORES_INDENT_id;
2874[java] END IF;
2875[java] IF (updating) THEN
2876[java] UPDATE
2877[java] rwt_STORES_INDENT
2878[java] SET
2879[java] rwt_recstatus='0'
2880[java] WHERE
2881[java] rwt_STORES_INDENT_id=:new.rwt_STORES_INDENT_id;
2882[java] END IF;
2883[java] END;
2884[java] 318505 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2885[java]
2886[java] 318510 WARN - -- END
2887[java] -- -----------------------------------------------------------------------
2888[java] -- TRIGGER RWT_STORES_INQ_INDENT_REL_TRG2
2889[java] -- -----------------------------------------------------------------------
2890[java] CREATE TRIGGER RWT_STORES_INQ_INDENT_REL_TRG2
2891[java] AFTER INSERT OR UPDATE OR DELETE
2892[java] ON RWT_STORES_INQ_INDENT_REL FOR EACH ROW
2893[java] DECLAREBEGIN IF (inserting) THEN
2894[java] UPDATE
2895[java] rwt_STORES_INQ
2896[java] SET
2897[java] rwt_recstatus='0'
2898[java] WHERE
2899[java] rwt_STORES_INQ_id=:new.rwt_STORES_INQ_id;
2900[java] END IF;
2901[java] IF (updating) THEN
2902[java] UPDATE
2903[java] rwt_STORES_INQ
2904[java] SET
2905[java] rwt_recstatus='0'
2906[java] WHERE
2907[java] rwt_STORES_INQ_id=:new.rwt_STORES_INQ_id;
2908[java] END IF;
2909[java] END;
2910[java] 318553 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2911[java]
2912[java] 318558 WARN - -- END
2913[java] -- -----------------------------------------------------------------------
2914[java] -- TRIGGER RWT_STORES_INQ_MAT_TRG2
2915[java] -- -----------------------------------------------------------------------
2916[java] CREATE TRIGGER RWT_STORES_INQ_MAT_TRG2
2917[java] AFTER INSERT OR UPDATE OR DELETE
2918[java] ON RWT_STORES_INQ_MAT FOR EACH ROW
2919[java] DECLAREBEGIN IF (inserting) THEN
2920[java] UPDATE
2921[java] rwt_STORES_INQ
2922[java] SET
2923[java] rwt_recstatus='0'
2924[java] WHERE
2925[java] rwt_STORES_INQ_id=:new.rwt_STORES_INQ_id;
2926[java] END IF;
2927[java] IF (updating) THEN
2928[java] UPDATE
2929[java] rwt_STORES_INQ
2930[java] SET
2931[java] rwt_recstatus='0'
2932[java] WHERE
2933[java] rwt_STORES_INQ_id=:new.rwt_STORES_INQ_id;
2934[java] END IF;
2935[java] END;
2936[java] 318652 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2937[java]
2938[java] 318656 WARN - -- END
2939[java] -- -----------------------------------------------------------------------
2940[java] -- TRIGGER RWT_STORES_INQ_VENDORS_TRG2
2941[java] -- -----------------------------------------------------------------------
2942[java] CREATE TRIGGER RWT_STORES_INQ_VENDORS_TRG2
2943[java] AFTER INSERT OR UPDATE OR DELETE
2944[java] ON RWT_STORES_INQ_VENDORS FOR EACH ROW
2945[java] DECLAREBEGIN IF (inserting) THEN
2946[java] UPDATE
2947[java] rwt_STORES_INQ
2948[java] SET
2949[java] rwt_recstatus='0'
2950[java] WHERE
2951[java] rwt_STORES_INQ_id=:new.rwt_STORES_INQ_id;
2952[java] END IF;
2953[java] IF (updating) THEN
2954[java] UPDATE
2955[java] rwt_STORES_INQ
2956[java] SET
2957[java] rwt_recstatus='0'
2958[java] WHERE
2959[java] rwt_STORES_INQ_id=:new.rwt_STORES_INQ_id;
2960[java] END IF;
2961[java] END;
2962[java] 318721 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
2963[java]
2964[java] 318729 WARN - -- END
2965[java] -- -----------------------------------------------------------------------
2966[java] -- TRIGGER RWT_STORES_INWARD_CASHDTL_TRG2
2967[java] -- -----------------------------------------------------------------------
2968[java] CREATE TRIGGER RWT_STORES_INWARD_CASHDTL_TRG2
2969[java] AFTER INSERT OR UPDATE OR DELETE
2970[java] ON RWT_STORES_INWARD_CASHDTL FOR EACH ROW
2971[java] DECLAREBEGIN IF (INSERTING) THEN
2972[java] UPDATE
2973[java] RWT_STORES_INWARD stinwd
2974[java] SET
2975[java] RWT_RECSTATUS='0'
2976[java] WHERE
2977[java] EXISTS
2978[java] (
2979[java] SELECT
2980[java] 1
2981[java] FROM
2982[java] rwt_stores_inward_prod
2983[java] WHERE
2984[java] RWT_STORES_INWARD_ID=stinwd.RWT_STORES_INWARD_ID
2985[java] AND RWT_STORES_INWARD_PROD_ID=:NEW.RWT_STORES_INWARD_PROD_ID
2986[java] );
2987[java] END IF;
2988[java] IF (UPDATING) THEN
2989[java] UPDATE
2990[java] RWT_STORES_INWARD stinwd
2991[java] SET
2992[java] RWT_RECSTATUS='0'
2993[java] WHERE
2994[java] EXISTS
2995[java] (
2996[java] SELECT
2997[java] 1
2998[java] FROM
2999[java] rwt_stores_inward_prod
3000[java] WHERE
3001[java] RWT_STORES_INWARD_ID=stinwd.RWT_STORES_INWARD_ID
3002[java] AND RWT_STORES_INWARD_PROD_ID=:NEW.RWT_STORES_INWARD_PROD_ID
3003[java] );
3004[java] END IF;
3005[java] END;
3006[java] 318787 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3007[java]
3008[java] 318792 WARN - -- END
3009[java] -- -----------------------------------------------------------------------
3010[java] -- TRIGGER RWT_STORES_INWARD_DES_DOC_TRG2
3011[java] -- -----------------------------------------------------------------------
3012[java] CREATE TRIGGER RWT_STORES_INWARD_DES_DOC_TRG2
3013[java] AFTER INSERT OR UPDATE OR DELETE
3014[java] ON RWT_STORES_INWARD_DES_DOC FOR EACH ROW
3015[java] DECLAREBEGIN IF (INSERTING) THEN
3016[java] UPDATE
3017[java] RWT_STORES_INWARD
3018[java] SET
3019[java] RWT_RECSTATUS='0'
3020[java] WHERE
3021[java] RWT_STORES_INWARD_ID=:NEW.RWT_STORES_INWARD_ID;
3022[java] END IF;
3023[java] IF (UPDATING) THEN
3024[java] UPDATE
3025[java] RWT_STORES_INWARD
3026[java] SET
3027[java] RWT_RECSTATUS='0'
3028[java] WHERE
3029[java] RWT_STORES_INWARD_ID=:NEW.RWT_STORES_INWARD_ID;
3030[java] END IF;
3031[java] END;
3032[java] 319059 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3033[java]
3034[java] 319068 WARN - -- END
3035[java] -- -----------------------------------------------------------------------
3036[java] -- TRIGGER RWT_STORES_NRGP_MAT_TRG2
3037[java] -- -----------------------------------------------------------------------
3038[java] CREATE TRIGGER RWT_STORES_NRGP_MAT_TRG2
3039[java] AFTER INSERT OR UPDATE OR DELETE
3040[java] ON RWT_STORES_NRGP_MAT FOR EACH ROW
3041[java] DECLAREBEGIN IF (INSERTING) THEN
3042[java] UPDATE
3043[java] RWT_stores_nrgp
3044[java] SET
3045[java] RWT_RECSTATUS='0'
3046[java] WHERE
3047[java] RWT_stores_nrgp_ID=:NEW.RWT_stores_nrgp_ID;
3048[java] END IF;
3049[java] IF (UPDATING) THEN
3050[java] UPDATE
3051[java] RWT_stores_nrgp
3052[java] SET
3053[java] RWT_RECSTATUS='0'
3054[java] WHERE
3055[java] RWT_stores_nrgp_ID=:NEW.RWT_stores_nrgp_ID;
3056[java] END IF;
3057[java] END;
3058[java] 319199 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3059[java]
3060[java] 319204 WARN - -- END
3061[java] -- -----------------------------------------------------------------------
3062[java] -- TRIGGER RWT_STORES_QUOT_MAT_EXP_TRG2
3063[java] -- -----------------------------------------------------------------------
3064[java] CREATE TRIGGER RWT_STORES_QUOT_MAT_EXP_TRG2
3065[java] AFTER INSERT OR UPDATE OR DELETE
3066[java] ON RWT_STORES_QUOT_MAT_EXP FOR EACH ROW
3067[java] DECLAREBEGIN IF (inserting) THEN
3068[java] UPDATE
3069[java] RWT_STORES_QUOT stquot
3070[java] SET
3071[java] RWT_RECSTATUS='0'
3072[java] WHERE
3073[java] EXISTS
3074[java] (
3075[java] SELECT
3076[java] 1
3077[java] FROM
3078[java] RWT_Stores_quot_Mat
3079[java] WHERE
3080[java] rwt_stores_quot_mat.rwt_stores_quot_id= stquot.rwt_stores_quot_id
3081[java] AND rwt_stores_quot_mat.rwt_stores_quot_mat_id=:NEW.rwt_stores_quot_mat_id
3082[java] );
3083[java] END IF;
3084[java] IF (updating) THEN
3085[java] UPDATE
3086[java] RWT_STORES_QUOT stquot
3087[java] SET
3088[java] RWT_RECSTATUS='0'
3089[java] WHERE
3090[java] EXISTS
3091[java] (
3092[java] SELECT
3093[java] 1
3094[java] FROM
3095[java] RWT_Stores_quot_Mat
3096[java] WHERE
3097[java] rwt_stores_quot_mat.rwt_stores_quot_id= stquot.rwt_stores_quot_id
3098[java] AND rwt_stores_quot_mat.rwt_stores_quot_mat_id=:NEW.rwt_stores_quot_mat_id
3099[java] );
3100[java] END IF;
3101[java] END;
3102[java] 319248 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3103[java]
3104[java] 319252 WARN - -- END
3105[java] -- -----------------------------------------------------------------------
3106[java] -- TRIGGER RWT_STORES_QUOT_MAT_TAX_TRG2
3107[java] -- -----------------------------------------------------------------------
3108[java] CREATE TRIGGER RWT_STORES_QUOT_MAT_TAX_TRG2
3109[java] AFTER INSERT OR UPDATE OR DELETE
3110[java] ON RWT_STORES_QUOT_MAT_TAX FOR EACH ROW
3111[java] DECLAREBEGIN IF (inserting) THEN
3112[java] UPDATE
3113[java] RWT_STORES_QUOT stquot
3114[java] SET
3115[java] RWT_RECSTATUS='0'
3116[java] WHERE
3117[java] EXISTS
3118[java] (
3119[java] SELECT
3120[java] 1
3121[java] FROM
3122[java] RWT_Stores_quot_Mat
3123[java] WHERE
3124[java] rwt_stores_quot_mat.rwt_stores_quot_id= stquot.rwt_stores_quot_id
3125[java] AND rwt_stores_quot_mat.rwt_stores_quot_mat_id=:NEW.rwt_stores_quot_mat_id
3126[java] );
3127[java] END IF;
3128[java] IF (updating) THEN
3129[java] UPDATE
3130[java] RWT_STORES_QUOT stquot
3131[java] SET
3132[java] RWT_RECSTATUS='0'
3133[java] WHERE
3134[java] EXISTS
3135[java] (
3136[java] SELECT
3137[java] 1
3138[java] FROM
3139[java] RWT_Stores_quot_Mat
3140[java] WHERE
3141[java] rwt_stores_quot_mat.rwt_stores_quot_id= stquot.rwt_stores_quot_id
3142[java] AND rwt_stores_quot_mat.rwt_stores_quot_mat_id=:NEW.rwt_stores_quot_mat_id
3143[java] );
3144[java] END IF;
3145[java] END;
3146[java] 319315 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3147[java]
3148[java] 319321 WARN - -- END
3149[java] -- -----------------------------------------------------------------------
3150[java] -- TRIGGER RWT_STORES_QUOT_MAT_TRG2
3151[java] -- -----------------------------------------------------------------------
3152[java] CREATE TRIGGER RWT_STORES_QUOT_MAT_TRG2
3153[java] AFTER INSERT OR UPDATE OR DELETE
3154[java] ON RWT_STORES_QUOT_MAT FOR EACH ROW
3155[java] DECLAREBEGIN IF (INSERTING) THEN
3156[java] UPDATE
3157[java] RWT_STORES_quot
3158[java] SET
3159[java] RWT_RECSTATUS='0'
3160[java] WHERE
3161[java] RWT_STORES_quot_ID=:NEW.RWT_STORES_quot_ID;
3162[java] END IF;
3163[java] IF (UPDATING) THEN
3164[java] UPDATE
3165[java] RWT_STORES_quot
3166[java] SET
3167[java] RWT_RECSTATUS='0'
3168[java] WHERE
3169[java] RWT_STORES_quot_ID=:NEW.RWT_STORES_quot_id;
3170[java] END IF;
3171[java] END;
3172[java] 319481 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3173[java]
3174[java] 319486 WARN - -- END
3175[java] -- -----------------------------------------------------------------------
3176[java] -- TRIGGER RWT_STORES_RGP_MAT_TRG2
3177[java] -- -----------------------------------------------------------------------
3178[java] CREATE TRIGGER RWT_STORES_RGP_MAT_TRG2
3179[java] AFTER INSERT OR UPDATE OR DELETE
3180[java] ON RWT_STORES_RGP_MAT FOR EACH ROW
3181[java] DECLAREBEGIN IF (INSERTING) THEN
3182[java] UPDATE
3183[java] RWT_Stores_RGP
3184[java] SET
3185[java] RWT_RECSTATUS='0'
3186[java] WHERE
3187[java] RWT_Stores_RGP_ID=:NEW.RWT_Stores_RGP_ID;
3188[java] END IF;
3189[java] IF (UPDATING) THEN
3190[java] UPDATE
3191[java] RWT_Stores_RGP
3192[java] SET
3193[java] RWT_RECSTATUS='0'
3194[java] WHERE
3195[java] RWT_Stores_RGP_ID=:NEW.RWT_Stores_RGP_ID;
3196[java] END IF;
3197[java] END;
3198[java] 320052 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3199[java]
3200[java] 320056 WARN - -- END
3201[java] -- -----------------------------------------------------------------------
3202[java] -- TRIGGER RWT_TDS_PAYABLE_LINE_TRG2
3203[java] -- -----------------------------------------------------------------------
3204[java] CREATE TRIGGER RWT_TDS_PAYABLE_LINE_TRG2
3205[java] AFTER INSERT OR UPDATE OR DELETE
3206[java] ON RWT_TDS_PAYABLE_LINE FOR EACH ROW
3207[java] DECLAREBEGIN IF (inserting) THEN
3208[java] UPDATE
3209[java] RWT_TDS_PAYABLE
3210[java] SET
3211[java] rwt_recstatus='0'
3212[java] WHERE
3213[java] RWT_TDS_PAYABLE_ID=:new.RWT_TDS_PAYABLE_ID;
3214[java] END IF;
3215[java] IF (updating) THEN
3216[java] UPDATE
3217[java] RWT_TDS_PAYABLE
3218[java] SET
3219[java] rwt_recstatus='0'
3220[java] WHERE
3221[java] RWT_TDS_PAYABLE_ID=:new.RWT_TDS_PAYABLE_ID;
3222[java] END IF;
3223[java] END;
3224[java] 320146 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3225[java]
3226[java] 320153 WARN - -- END
3227[java] -- -----------------------------------------------------------------------
3228[java] -- TRIGGER RWT_TEMPTABACCESS_TRG
3229[java] -- -----------------------------------------------------------------------
3230[java] CREATE TRIGGER RWT_TEMPTABACCESS_TRG
3231[java] BEFORE INSERT OR UPDATE OR DELETE
3232[java] ON RWT_TABACCESS FOR EACH ROW
3233[java] DECLAREBEGIN rwt_pack1.v_id:= :NEW.rwt_tabaccess_id;
3234[java]
3235[java] rwt_pack1.v_idBKP:= :OLD.rwt_tabaccess_id;
3236[java] rwt_pack1.v_user_id:= :NEW.AD_user_ID;
3237[java] rwt_pack1.v_userBKP_id:=:old.ad_user_id;
3238[java] rwt_pack1.v_grp_id:= :NEW.RWT_TABLEGROUP_ID;
3239[java] rwt_pack1.v_grpBKP_id:=:old.RWT_TABLEGROUP_ID;
3240[java] rwt_pack1.v_accessselectedBKP:=:old.accessselected;
3241[java] rwt_pack1.v_accessselected:=:NEW.accessselected;
3242[java] rwt_pack1.v_client_id:=:old.ad_client_id;
3243[java] rwt_pack1.v_org_id:=:new.ad_org_id;
3244[java] rwt_pack1.v_createdby:=:new.createdby;
3245[java] rwt_pack1.v_updatedby:=:new.updatedby;
3246[java] END;
3247[java] 320160 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3248[java]
3249[java] 320165 WARN - -- END
3250[java] -- -----------------------------------------------------------------------
3251[java] -- TRIGGER RWT_TEMP_CASHBOOK_ACCT_TRG
3252[java] -- -----------------------------------------------------------------------
3253[java] CREATE TRIGGER RWT_TEMP_CASHBOOK_ACCT_TRG
3254[java] AFTER INSERT
3255[java] ON RWT_CASHBOOK_ACCT FOR EACH ROW
3256[java] DECLAREBEGIN RWT_CASHBOOK.v_ad_client_id :=:new.ad_client_id;
3257[java]
3258[java] RWT_CASHBOOK.v_ad_org_id :=:new.ad_org_id;
3259[java] RWT_CASHBOOK.v_createdby :=:new.createdby;
3260[java] RWT_CASHBOOK.v_updatedby :=:new.updatedby;
3261[java] RWT_CASHBOOK.V_RWT_CASHBOOK_ACCT_ID:=:NEW.RWT_CASHBOOK_ACCT_ID;
3262[java] RWT_CASHBOOK.V_rwt_payment_advice_id:=:NEW.rwt_payment_advice_id;
3263[java] END;
3264[java] 320178 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3265[java]
3266[java] 320183 WARN - -- END
3267[java] -- -----------------------------------------------------------------------
3268[java] -- TRIGGER RWT_TEMP_PROC_CONTRACT_TRG
3269[java] -- -----------------------------------------------------------------------
3270[java] CREATE TRIGGER RWT_TEMP_PROC_CONTRACT_TRG
3271[java] AFTER INSERT
3272[java] ON RWT_PROC_CONTRACT FOR EACH ROW
3273[java] DECLAREBEGIN RWT_PROC_CONT_PCK.V_RWT_PRODUCT_ID:=:new.RWT_PRODUCT_ID;
3274[java] RWT_PROC_CONT_PCK.v_rwt_bpartner_id:=:new.rwt_bpartner_id;
3275[java] RWT_PROC_CONT_PCK.v_ad_client_id :=:new.ad_client_id;
3276[java] RWT_PROC_CONT_PCK.v_ad_org_id :=:new.ad_org_id;
3277[java] RWT_PROC_CONT_PCK.v_createdby :=:new.createdby;
3278[java] RWT_PROC_CONT_PCK.v_updatedby :=:new.updatedby;
3279[java] RWT_PROC_CONT_PCK.V_RWT_Proc_contract_ID :=:new.RWT_Proc_contract_ID;
3280[java] RWT_PROC_CONT_PCK.V_CONTRACTDATE :=:new.CONTRACTDATE;
3281[java] RWT_PROC_CONT_PCK.V_RWT_Pack_Type_Qty_ID := :new.RWT_Pack_Type_Qty_ID;
3282[java] RWT_PROC_CONT_PCK.V_EMPTYPACKINGMATWT := :new.EMPTYPACKINGMATWT;
3283[java] RWT_PROC_CONT_PCK.V_BUSSPROC := :new.RWT_BUSINESS_PROCESS_ID;
3284[java] END;
3285[java] 320227 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3286[java]
3287[java] 320232 WARN - -- END
3288[java] -- -----------------------------------------------------------------------
3289[java] -- TRIGGER RWT_TEMP_PRODUCTION_IN_TRG2
3290[java] -- -----------------------------------------------------------------------
3291[java] CREATE TRIGGER RWT_TEMP_PRODUCTION_IN_TRG2
3292[java] AFTER INSERT OR UPDATE OR DELETE
3293[java] ON RWT_TEMP_PRODUCTION_IN FOR EACH ROW
3294[java] DECLAREBEGIN
3295[java] IF (inserting) THEN
3296[java] UPDATE RWT_TEMP_PRODUCTION SET RWT_RECSTATUS='0' WHERE RWT_TEMP_PRODUCTION_ID=:NEW.RWT_TEMP_PRODUCTION_ID;
3297[java] END IF;
3298[java] IF (updating) THEN
3299[java] UPDATE RWT_TEMP_PRODUCTION SET RWT_RECSTATUS='0' WHERE RWT_TEMP_PRODUCTION_ID=:NEW.RWT_TEMP_PRODUCTION_ID;
3300[java] END IF;
3301[java] END;
3302[java] 320282 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3303[java]
3304[java] 320287 WARN - -- END
3305[java] -- -----------------------------------------------------------------------
3306[java] -- TRIGGER RWT_TEMP_PRODUCTION_OUT_TRG2
3307[java] -- -----------------------------------------------------------------------
3308[java] CREATE TRIGGER RWT_TEMP_PRODUCTION_OUT_TRG2
3309[java] AFTER INSERT OR UPDATE OR DELETE
3310[java] ON RWT_TEMP_PRODUCTION_OUT FOR EACH ROW
3311[java] DECLAREBEGIN
3312[java] IF (inserting) THEN
3313[java] UPDATE RWT_TEMP_PRODUCTION SET RWT_RECSTATUS='0' WHERE RWT_TEMP_PRODUCTION_ID=:NEW.RWT_TEMP_PRODUCTION_ID;
3314[java] END IF;
3315[java] IF (updating) THEN
3316[java] UPDATE RWT_TEMP_PRODUCTION SET RWT_RECSTATUS='0' WHERE RWT_TEMP_PRODUCTION_ID=:NEW.RWT_TEMP_PRODUCTION_ID;
3317[java] END IF;
3318[java] END;
3319[java] 320331 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3320[java]
3321[java] 320335 WARN - -- END
3322[java] -- -----------------------------------------------------------------------
3323[java] -- TRIGGER RWT_TEMP_PRODUCTION_QLTY_TRG2
3324[java] -- -----------------------------------------------------------------------
3325[java] CREATE TRIGGER RWT_TEMP_PRODUCTION_QLTY_TRG2
3326[java] AFTER INSERT OR UPDATE OR DELETE
3327[java] ON RWT_TEMP_PRODUCTION_QLTY FOR EACH ROW
3328[java] DECLAREBEGIN
3329[java] IF (inserting) THEN
3330[java] UPDATE RWT_TEMP_PRODUCTION prodconf SET RWT_RECSTATUS='0' WHERE EXISTS (SELECT 1 FROM RWT_TEMP_PRODUCTION_OUT WHERE RWT_TEMP_PRODUCTION_id=prodconf.RWT_TEMP_PRODUCTION_id AND RWT_TEMP_PRODUCTION_OUT.RWT_TEMP_PRODUCTION_OUT_id=:NEW.RWT_TEMP_PRODUCTION_OUT_id);
3331[java] END IF;
3332[java] IF (updating) THEN
3333[java] UPDATE RWT_TEMP_PRODUCTION prodconf SET RWT_RECSTATUS='0' WHERE EXISTS (SELECT 1 FROM RWT_TEMP_PRODUCTION_OUT WHERE RWT_TEMP_PRODUCTION_id=prodconf.RWT_TEMP_PRODUCTION_id AND RWT_TEMP_PRODUCTION_OUT.RWT_TEMP_PRODUCTION_OUT_id=:NEW.RWT_TEMP_PRODUCTION_OUT_id);
3334[java] END IF;
3335[java] END;
3336[java] 320415 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3337[java]
3338[java] 320420 WARN - -- END
3339[java] -- -----------------------------------------------------------------------
3340[java] -- TRIGGER RWT_TEMP_SALES_CONTRACT_TRG
3341[java] -- -----------------------------------------------------------------------
3342[java] CREATE TRIGGER RWT_TEMP_SALES_CONTRACT_TRG
3343[java] AFTER INSERT
3344[java] ON RWT_SALES_CONTRACT FOR EACH ROW
3345[java] DECLAREBEGIN RWT_sales_CONT_PCK.V_RWT_PRODUCT_ID:=:new.RWT_PRODUCT_ID;
3346[java]
3347[java] RWT_sales_CONT_PCK.v_rwt_bpartner_id:=:new.rwt_bpartner_id;
3348[java] RWT_sales_CONT_PCK.v_ad_client_id :=:new.ad_client_id;
3349[java] RWT_sales_CONT_PCK.v_ad_org_id :=:new.ad_org_id;
3350[java] RWT_sales_CONT_PCK.v_createdby :=:new.createdby;
3351[java] RWT_sales_CONT_PCK.v_updatedby :=:new.updatedby;
3352[java] RWT_sales_CONT_PCK.V_RWT_sales_contract_ID :=:new.RWT_sales_contract_ID;
3353[java] RWT_sales_CONT_PCK.v_contractdate := :new.CONTRACTDATE;
3354[java] RWT_sales_CONT_PCK.V_RWT_SALES_offer_ID := :new.RWT_SALES_offer_ID;
3355[java] END;
3356[java] 320471 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3357[java]
3358[java] 320475 WARN - -- END
3359[java] -- -----------------------------------------------------------------------
3360[java] -- TRIGGER RWT_TFR_CHALLAN_INPASS_TRG2
3361[java] -- -----------------------------------------------------------------------
3362[java] CREATE TRIGGER RWT_TFR_CHALLAN_INPASS_TRG2
3363[java] AFTER INSERT OR UPDATE OR DELETE
3364[java] ON RWT_TFR_CHALLAN_INPASS FOR EACH ROW
3365[java] DECLAREBEGIN
3366[java] IF (inserting) THEN
3367[java] UPDATE RWT_Tfr_Challan SET RWT_RECSTATUS='0' WHERE RWT_Tfr_Challan_id=:NEW.RWT_Tfr_Challan_id;
3368[java] END IF;
3369[java] IF (updating) THEN
3370[java] UPDATE RWT_Tfr_Challan SET RWT_RECSTATUS='0' WHERE RWT_Tfr_Challan_id=:NEW.RWT_Tfr_Challan_id;
3371[java] END IF;
3372[java] END;
3373[java] 320667 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3374[java]
3375[java] 320672 WARN - -- END
3376[java] -- -----------------------------------------------------------------------
3377[java] -- TRIGGER RWT_TFR_INPASS_WH_TRG2
3378[java] -- -----------------------------------------------------------------------
3379[java] CREATE TRIGGER RWT_TFR_INPASS_WH_TRG2
3380[java] AFTER INSERT OR UPDATE OR DELETE
3381[java] ON RWT_TFR_INPASS_WH FOR EACH ROW
3382[java] DECLAREBEGIN IF (inserting) THEN
3383[java] UPDATE
3384[java] RWT_Tfr_Unload
3385[java] SET
3386[java] RWT_RECSTATUS='0'
3387[java] WHERE
3388[java] RWT_Tfr_Unload_ID=:new.RWT_Tfr_Unload_ID;
3389[java] END IF;
3390[java] IF (updating) THEN
3391[java] UPDATE
3392[java] RWT_Tfr_Unload
3393[java] SET
3394[java] RWT_RECSTATUS='0'
3395[java] WHERE
3396[java] RWT_Tfr_Unload_ID=:new.RWT_Tfr_Unload_ID;
3397[java] END IF;
3398[java] END;
3399[java] 320851 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3400[java]
3401[java] 320858 WARN - -- END
3402[java] -- -----------------------------------------------------------------------
3403[java] -- TRIGGER RWT_TFR_OUTPASS_WH_TRG2
3404[java] -- -----------------------------------------------------------------------
3405[java] CREATE TRIGGER RWT_TFR_OUTPASS_WH_TRG2
3406[java] AFTER INSERT OR UPDATE OR DELETE
3407[java] ON RWT_TFR_OUTPASS_WH FOR EACH ROW
3408[java] DECLAREBEGIN IF (inserting) THEN
3409[java] UPDATE
3410[java] RWT_Tfr_Load
3411[java] SET
3412[java] RWT_RECSTATUS='0'
3413[java] WHERE
3414[java] RWT_Tfr_Load_id=:NEW.RWT_Tfr_Load_id;
3415[java] END IF;
3416[java] IF (updating) THEN
3417[java] UPDATE
3418[java] RWT_Tfr_Load
3419[java] SET
3420[java] RWT_RECSTATUS='0'
3421[java] WHERE
3422[java] RWT_Tfr_Load_id=:NEW.RWT_Tfr_Load_id;
3423[java] END IF;
3424[java] END;
3425[java] 321208 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3426[java]
3427[java] 321217 WARN - -- END
3428[java] -- -----------------------------------------------------------------------
3429[java] -- TRIGGER RWT_VOUCHERENTRY_LINE_TRG2
3430[java] -- -----------------------------------------------------------------------
3431[java] CREATE TRIGGER RWT_VOUCHERENTRY_LINE_TRG2
3432[java] AFTER INSERT OR UPDATE OR DELETE
3433[java] ON RWT_VOUCHERENTRY_LINE FOR EACH ROW
3434[java] DECLAREBEGIN
3435[java] IF (INSERTING) THEN
3436[java] UPDATE RWT_VOUCHERENTRY SET RWT_RECSTATUS='0' WHERE RWT_VOUCHERENTRY_ID=:NEW.RWT_VOUCHERENTRY_ID;
3437[java] END IF;
3438[java] IF (UPDATING) THEN
3439[java] UPDATE RWT_VOUCHERENTRY SET RWT_RECSTATUS='0' WHERE RWT_VOUCHERENTRY_ID=:NEW.RWT_VOUCHERENTRY_ID;
3440[java] END IF;
3441[java] END;
3442[java] 321300 WARN - SQL Command failed with: ORA-04079: invalid trigger specification
3443[java]
3444[java] 321308 WARN - -- END
3445[java] -- -----------------------------------------------------------------------
3446[java] -- TRIGGER RWT_WAREHOUSE_SECTIONS_TRG2
3447[java] -- -----------------------------------------------------------------------
3448[java] CREATE TRIGGER RWT_WAREHOUSE_SECTIONS_TRG2
3449[java] AFTER INSERT OR UPDATE OR DELETE
3450[java] ON RWT_WAREHOUSE_SECTIONS FOR EACH ROW
3451[java] DECLAREBEGIN IF (inserting) THEN
3452[java] UPDATE
3453[java] RWT_WAREHOUSE
3454[java] SET
3455[java] rwt_recstatus='0'
3456[java] WHERE
3457[java] RWT_WAREHOUSE_ID=:new.RWT_WAREHOUSE_ID;
3458[java] END IF;
3459[java] IF (updating) THEN
3460[java] UPDATE
3461[java] RWT_WAREHOUSE
3462[java] SET
3463[java] rwt_recstatus='0'
3464[java] WHERE
3465[java] RWT_WAREHOUSE_ID=:new.RWT_WAREHOUSE_ID;
3466[java] END IF;
3467[java] END;
3468[java] 321475 INFO - Executed 10927 SQL command(s) with 129 error(s)
3469[java] 321481 INFO - Model update complete.
3470[java] 321487 INFO - Loading data from XML files
3471[java] 324087 INFO - Comparing databases to find data differences
3472[java] 324103 INFO - Updating database data...
3473[java] 324109 INFO - Disabling foreign keys
3474[java] 406297 INFO - Disabling triggers
3475[java] 602440 INFO - Executed 4877 SQL command(s) with 0 error(s)
3476[java] 602464 INFO - Updating database data for module RareworldERP
3477[java] 811805 INFO - Recreating Primary Keys
3478[java] 811830 INFO - Executed 0 SQL command(s) with 0 error(s)
3479[java] 811841 INFO - Removing invalid rows.
3480[java] 813009 INFO - Executed 164 SQL command(s) with 0 error(s)
3481[java] 813029 INFO - Executing update final script (NOT NULLs and dropping temporary tables)
3482[java] 895972 INFO - Executed 2428 SQL command(s) with 0 error(s)
3483[java] 897150 INFO - Executed 139 SQL command(s) with 0 error(s)
3484[java] 897166 INFO - Enabling Foreign Keys and Triggers
3485[java] 1074009 INFO - Executed 4877 SQL command(s) with 0 error(s)
3486[java] SQL command failed with ORA-02298: cannot validate (TAD.AD_WINDOW_AD_IMAGE) - parent keys not found
3487[java]
3488[java] ALTER TABLE AD_WINDOW ENABLE CONSTRAINT AD_WINDOW_AD_IMAGE
3489[java] 1181258 ERROR - Error while enabling foreign key
3490[java] java.sql.SQLIntegrityConstraintViolationException: ORA-02298: cannot validate (TAD.AD_WINDOW_AD_IMAGE) - parent keys not found
3491[java]
3492[java] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)
3493[java] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
3494[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
3495[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
3496[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
3497[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
3498[java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
3499[java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
3500[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
3501[java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
3502[java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468)
3503[java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
3504[java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
3505[java] at org.apache.ddlutils.platform.oracle.Oracle8Platform.enableAllFK(Oracle8Platform.java:167)
3506[java] at org.openbravo.ddlutils.task.AlterDatabaseDataMod.doExecute(AlterDatabaseDataMod.java:317)
3507[java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:87)
3508[java] at org.openbravo.ddlutils.task.AlterDatabaseModJava.main(AlterDatabaseModJava.java:36)
3509[java] Exception in thread "main" org.apache.ddlutils.DatabaseOperationException: Error while enabling foreign key
3510[java] at org.apache.ddlutils.platform.oracle.Oracle8Platform.enableAllFK(Oracle8Platform.java:175)
3511[java] at org.openbravo.ddlutils.task.AlterDatabaseDataMod.doExecute(AlterDatabaseDataMod.java:317)
3512[java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:87)
3513[java] at org.openbravo.ddlutils.task.AlterDatabaseModJava.main(AlterDatabaseModJava.java:36)
3514[java] Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02298: cannot validate (TAD.AD_WINDOW_AD_IMAGE) - parent keys not found
3515[java]
3516[java] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)
3517[java] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
3518[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
3519[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
3520[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
3521[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
3522[java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
3523[java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
3524[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
3525[java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
3526[java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468)
3527[java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
3528[java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
3529[java] at org.apache.ddlutils.platform.oracle.Oracle8Platform.enableAllFK(Oracle8Platform.java:167)
3530[java] ... 3 more