DBA Data[Home] [Help]

APPS.MSC_ATP_PEG dependencies on DUAL

Line 3725: -- Individual Item's lead times are used.

3721: atp_peg_det.plan_id(k) := atp_peg_det.plan_id(i);
3722: atp_peg_det.sr_instance_id(k) := atp_peg_det.sr_instance_id(i);
3723: atp_peg_det.organization_id(k) := atp_peg_det.organization_id(i);
3724: atp_peg_det.bom_item_type(k) := fcst_data_tab.bom_item_type(j);
3725: -- Individual Item's lead times are used.
3726: atp_peg_det.fixed_lt(k) := fcst_data_tab.fixed_lt(j);
3727: atp_peg_det.variable_lt(k) := fcst_data_tab.variable_lt(j);
3728: atp_peg_det.sales_order_qty(k) := fcst_data_tab.sales_order_qty(j);
3729: -- Note that the sales_order_qty gets factored in during forecast consumption

Line 4625: FROM dual;

4621: ELSE
4622: BEGIN
4623: SELECT mrp_atp_schedule_temp_s.currval
4624: INTO l_session_id
4625: FROM dual;
4626: EXCEPTION
4627: WHEN OTHERS THEN
4628: SELECT mrp_atp_schedule_temp_s.nextval
4629: INTO l_session_id

Line 4630: FROM dual;

4626: EXCEPTION
4627: WHEN OTHERS THEN
4628: SELECT mrp_atp_schedule_temp_s.nextval
4629: INTO l_session_id
4630: FROM dual;
4631: order_sch_wb.debug_session_id := l_session_id;
4632: END;
4633:
4634: msc_util.msc_log('Setting ATP Session ID : ' || l_session_id);