DBA Data[Home] [Help]

APPS.GMP_APS_OUTPUT_PKG dependencies on GMP_PROCESS_UPD_ID_S

Line 87: SELECT gmp_process_upd_id_s.nextval INTO l_cons from dual;

83: BEGIN
84: gmd_p_fs_context.set_additional_attr ;
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

Line 249: gmp_process_upd_id_s.nextval, /* PENDING */

245: w.start_quantity,
246: w.first_unit_start_date,
247: w.last_unit_completion_date,
248: w.load_type,
249: gmp_process_upd_id_s.nextval, /* PENDING */
250: w.header_id,
251: w.scheduling_method,
252: -- B4664966 implement as firm only if ASCP and Profile says firm
253: DECODE(w.firm_planned_flag,1,firm_batch_profile,w.firm_planned_flag), /*B4084230*/

Line 324: gmp_process_upd_id_s.nextval, /* PENDING */

320: w.start_quantity,
321: w.first_unit_start_date,
322: w.last_unit_completion_date,
323: -1, /* Inserting -1 into action_type to identify Cancellation */
324: gmp_process_upd_id_s.nextval, /* PENDING */
325: w.header_id,
326: w.scheduling_method,
327: -- B4664966 implement as firm only if ASCP and Profile says firm
328: DECODE(w.firm_planned_flag,1,firm_batch_profile,w.firm_planned_flag), /*B4084230*/