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 87: INSERT INTO gmp_aps_output_tbl (

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

Line 211: INSERT INTO gmp_aps_output_tbl (

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

Line 286: INSERT INTO gmp_aps_output_tbl (

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

Line 497: inserted in gmp_aps_output_tbl */

493: NULL ;
494: END;
495:
496: /* Following Lines delete the rows wip_job_schedule_interface after the rows are
497: inserted in gmp_aps_output_tbl */
498: BEGIN
499:
500: IF delete_new_flag = 1 THEN
501: DELETE wip_job_schedule_interface