APPS.GML_LOG dependencies on CPG_ORAGEMS_MAPPING

Line 13: | rows from cpg_oragems_mapping |

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: ========================================================================*/
17:

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 185: FROM cpg_oragems_mapping

181: LAST_UPDATE_DATE ,
182: LAST_UPDATED_BY ,
183: CREATED_BY ,
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: (

Line 228: FROM cpg_oragems_mapping;

224: LAST_UPDATE_DATE ,
225: LAST_UPDATED_BY ,
226: CREATED_BY ,
227: CREATION_DATE
228: FROM cpg_oragems_mapping;
229: -- END - Bug 2100687
230: END IF;
231:
232: CLOSE archival_date_cur;