APPS.GML_LOG dependencies on CPG_ORAGEMS_ARCH

Line 12: | also incrementally inserts into cpg_oragems_arch table |

8: | interface table which are successfully processed |
9: | or errored out and writes them into the purchasing |
10: | transaction log table. Then it deletes all those |
11: | rows from the purchasing interface table. This procedure|
12: | also incrementally inserts into cpg_oragems_arch table |
13: | rows from cpg_oragems_mapping |
14: | |
15: | MODIFICATION: Kenny Jiang 11/24/97 Created |
16: ========================================================================*/

Line 27: FROM cpg_oragems_arch;

23: v_archival_date DATE;
24:
25: CURSOR archival_date_cur IS
26: SELECT MAX(time_stamp)
27: FROM cpg_oragems_arch;
28: BEGIN
29:
30: /* INSERT INTO cpg_purchasing_arch
31: SELECT *

Line 139: /* Insert rows from cpg_oragems_mapping to cpg_oragems_arch*/

135:
136: DELETE FROM cpg_purchasing_interface
137: WHERE invalid_ind IN ('Y', 'P');
138:
139: /* Insert rows from cpg_oragems_mapping to cpg_oragems_arch*/
140:
141: OPEN archival_date_cur;
142: FETCH archival_date_cur INTO v_archival_date;
143: IF (v_archival_date IS NOT NULL) THEN

Line 145: INSERT INTO cpg_oragems_arch

141: OPEN archival_date_cur;
142: FETCH archival_date_cur INTO v_archival_date;
143: IF (v_archival_date IS NOT NULL) THEN
144: -- BEGIN - Bug 2100687 - Put explicit INSERT and SELECT clause
145: INSERT INTO cpg_oragems_arch
146: (
147: PO_HEADER_ID ,
148: PO_LINE_ID ,
149: PO_LINE_LOCATION_ID ,

Line 188: INSERT INTO cpg_oragems_arch

184: CREATION_DATE
185: FROM cpg_oragems_mapping
186: WHERE time_stamp > nvl(v_archival_date,sysdate);
187: ELSE
188: INSERT INTO cpg_oragems_arch
189: (
190: PO_HEADER_ID ,
191: PO_LINE_ID ,
192: PO_LINE_LOCATION_ID ,