DBA Data[Home] [Help]

APPS.GMP_APS_OUTPUT_PKG dependencies on GMP_PROCESS_UPD_ID_S

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

81: BEGIN
82: gmd_p_fs_context.set_additional_attr ;
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

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

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

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

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