APPS.MSC_ATP_SUBST dependencies on DUAL

Line 1573: FROM dual;

1569:
1570: ---- get pegging id for demand
1571: SELECT msc_full_pegging_s.nextval
1572: INTO l_pegging_id
1573: FROM dual;
1574:
1575: IF PG_DEBUG in ('Y', 'C') THEN
1576: msc_sch_wb.atp_debug('ATP_Check_Subst: ' || 'demand pegging id := ' || l_pegging_id);
1577: END IF;

Line 1583: FROM dual;

1579:
1580: --- supply pegging id
1581: SELECT msc_full_pegging_s.nextval
1582: INTO l_pegging_id
1583: FROM dual;
1584:
1585: org_availability_info.supply_pegging_id(l_process_org_cntr) := l_pegging_id;
1586:
1587: FOR i in 1..l_atp_period.Level.COUNT LOOP

Line 2181: FROM dual;

2177:
2178: --- get pegging ID for planned order in parent Org
2179: SELECT msc_full_pegging_s.nextval
2180: INTO l_pegging_id
2181: FROM dual;
2182: IF PG_DEBUG in ('Y', 'C') THEN
2183: msc_sch_wb.atp_debug('ATP_Check_Subst: ' || 'PO Pegging id := ' || l_pegging_id);
2184: msc_sch_wb.atp_debug('ATP_Check_Subst: ' || 'Src Organization_id := ' || l_sources.organization_id(i));
2185: END IF;

Line 4173: FROM dual;

4169:
4170: ---- get pegging id for demand
4171: SELECT msc_full_pegging_s.nextval
4172: INTO l_pegging_id
4173: FROM dual;
4174: IF PG_DEBUG in ('Y', 'C') THEN
4175: msc_sch_wb.atp_debug('ATP_Check_Subst: ' || 'Update with pegging info');
4176: END IF;
4177: item_availability_info.future_supply_peg_id(i) := l_pegging_id;