APPS.MSC_ATP_SUBST dependencies on DUAL

Line 1550: FROM dual;

1546:
1547: ---- get pegging id for demand
1548: SELECT msc_full_pegging_s.nextval
1549: INTO l_pegging_id
1550: FROM dual;
1551:
1552: IF PG_DEBUG in ('Y', 'C') THEN
1553: msc_sch_wb.atp_debug('ATP_Check_Subst: ' || 'demand pegging id := ' || l_pegging_id);
1554: END IF;

Line 1560: FROM dual;

1556:
1557: --- supply pegging id
1558: SELECT msc_full_pegging_s.nextval
1559: INTO l_pegging_id
1560: FROM dual;
1561:
1562: org_availability_info.supply_pegging_id(l_process_org_cntr) := l_pegging_id;
1563:
1564: FOR i in 1..l_atp_period.Level.COUNT LOOP

Line 2158: FROM dual;

2154:
2155: --- get pegging ID for planned order in parent Org
2156: SELECT msc_full_pegging_s.nextval
2157: INTO l_pegging_id
2158: FROM dual;
2159: IF PG_DEBUG in ('Y', 'C') THEN
2160: msc_sch_wb.atp_debug('ATP_Check_Subst: ' || 'PO Pegging id := ' || l_pegging_id);
2161: msc_sch_wb.atp_debug('ATP_Check_Subst: ' || 'Src Organization_id := ' || l_sources.organization_id(i));
2162: END IF;

Line 4098: FROM dual;

4094:
4095: ---- get pegging id for demand
4096: SELECT msc_full_pegging_s.nextval
4097: INTO l_pegging_id
4098: FROM dual;
4099: IF PG_DEBUG in ('Y', 'C') THEN
4100: msc_sch_wb.atp_debug('ATP_Check_Subst: ' || 'Update with pegging info');
4101: END IF;
4102: item_availability_info.future_supply_peg_id(i) := l_pegging_id;