DBA Data[Home] [Help]

APPS.GMP_APS_OUTPUT_PKG dependencies on GMP_APS_OUTPUT_TBL

Line 12: | The following procedure inserts into gmp_aps_output_tbl table, |

8: | TYPE |
9: | public |
10: | |
11: | DESCRIPTION |
12: | The following procedure inserts into gmp_aps_output_tbl table, |
13: | Pull out the Information from wip_job_schedule_interface. |
14: | Input Parameters |
15: | p_group_id - Group Id |
16: | |

Line 89: INSERT INTO gmp_aps_output_tbl (

85: END;
86:
87: SELECT gmp_process_upd_id_s.nextval INTO l_cons from dual;
88:
89: INSERT INTO gmp_aps_output_tbl (
90: PROCESS_ID,
91: INVENTORY_ITEM_ID, -- for R12.0
92: ORGANIZATION_CODE,
93: ORGANIZATION_ID,

Line 213: INSERT INTO gmp_aps_output_tbl (

209: (earlier 0 quantity indicated cancellation of the job
210: */
211:
212: BEGIN
213: INSERT INTO gmp_aps_output_tbl (
214: PROCESS_ID,
215: INVENTORY_ITEM_ID, -- For R12.0
216: ORGANIZATION_CODE,
217: ORGANIZATION_ID,

Line 288: INSERT INTO gmp_aps_output_tbl (

284: END;
285: COMMIT;
286:
287: BEGIN -- For Cancelled Orders
288: INSERT INTO gmp_aps_output_tbl (
289: PROCESS_ID,
290: INVENTORY_ITEM_ID, -- For R12.0
291: ORGANIZATION_CODE,
292: ORGANIZATION_ID,

Line 499: inserted in gmp_aps_output_tbl */

495: NULL ;
496: END;
497:
498: /* Following Lines delete the rows wip_job_schedule_interface after the rows are
499: inserted in gmp_aps_output_tbl */
500: BEGIN
501: IF mrp_debug_profile = 'Y' THEN
502: FND_FILE.PUT_LINE ( FND_FILE.LOG,'DO NOT DELETE DATA FROM WIP INTERFACE (Debug Mode)');
503: ELSE