DBA Data[Home] [Help]

APPS.MSC_ATP_SUBST dependencies on MSC_FULL_PEGGING_S

Line 1571: SELECT msc_full_pegging_s.nextval

1567: END IF;
1568:
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

Line 1581: SELECT msc_full_pegging_s.nextval

1577: END IF;
1578: org_availability_info.demand_pegging_id(l_process_org_cntr) := l_pegging_id;
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;

Line 2179: SELECT msc_full_pegging_s.nextval

2175: -- dsting diagnostic atp
2176: org_availability_info.ptf_date(l_count) := l_ptf_date;
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);

Line 4171: SELECT msc_full_pegging_s.nextval

4167: l_sd_begin_idx := l_sd_begin_idx + 1;
4168: END IF;
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');

Line 5633: --NVL(MSC_ATP_PVT.G_DEMAND_PEGGING_ID, msc_full_pegging_s.currval),

5629: p_pegging_rec.supply_demand_source_type,
5630: p_pegging_rec.supply_demand_quantity,
5631: p_pegging_rec.supply_demand_type,
5632: p_pegging_rec.supply_demand_date,
5633: --NVL(MSC_ATP_PVT.G_DEMAND_PEGGING_ID, msc_full_pegging_s.currval),
5634: p_pegging_rec.end_pegging_id,
5635: p_pegging_rec.constraint_flag,
5636: p_pegging_rec.allocated_quantity, -- 1527660
5637: p_pegging_rec.number1,