API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 23rd, 2017
54
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 124.86 KB | None | 0 0
raw download clone embed print report
  1.  
  2. Openbravo Viewing file: 20100508155914-apply.log
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9.  
  10.  
  11.  
  12.  
  13. apply.modules:
  14.  
  15. set.code.rev:
  16.  
  17. code.rev:
  18.  
  19. init:
  20.  
  21. core.lib:
  22.  
  23. init:
  24.  
  25. compile:
  26.  
  27. build.jar:
  28. [jar] Building jar: /opt/OpenbravoERP-2.50/openbravo-erp/src-core/lib/openbravo-core.jar
  29.  
  30. build:
  31.  
  32. copy.core.lib:
  33. [copy] Copying 1 file to /opt/OpenbravoERP-2.50/openbravo-erp/lib/runtime
  34.  
  35. database.lib:
  36.  
  37. init:
  38.  
  39. compile:
  40.  
  41. build.jar:
  42. [jar] Building jar: /opt/OpenbravoERP-2.50/openbravo-erp/src-db/build/lib/dbmanager.jar
  43.  
  44. jar:
  45. [copy] Copying 1 file to /opt/OpenbravoERP-2.50/openbravo-erp/src-db/database/lib
  46.  
  47. update.database.mod:
  48.  
  49. update.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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!