APPS.MSC_ATP_DB_UTILS dependencies on DUAL

Line 1506: SELECT p_identifier FROM dual

1502: CONNECT BY PRIOR component_identifier = assembly_identifier
1503: AND assembly_identifier <> component_identifier
1504: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1505: UNION ALL
1506: SELECT p_identifier FROM dual
1507: -- rajjain 03/14/2003 Bug 2849749 End
1508: )
1509: Comment out code refering msc_bom_temp
1510: */

Line 1567: SELECT p_identifier FROM dual

1563: CONNECT BY PRIOR component_identifier = assembly_identifier
1564: AND assembly_identifier <> component_identifier
1565: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1566: UNION ALL
1567: SELECT p_identifier FROM dual
1568: )
1569: Comment out code refering msc_bom_temp
1570:
1571: -- End CTO ODR and Simplified Pegging

Line 1632: FROM dual;

1628: l_ins_date_tab(l_ins_date_tab.COUNT) := l_old_demand_date(i);
1629:
1630: SELECT msc_demands_s.nextval
1631: INTO l_copy_demand_id(l_copy_demand_id.COUNT)
1632: FROM dual;
1633: END IF;
1634: END LOOP;
1635:
1636: IF i_ins_item_id_tab IS NOT NULL and i_ins_item_id_tab.COUNT > 0 THEN

Line 1811: SELECT p_identifier FROM dual)

1807: CONNECT BY PRIOR component_identifier = assembly_identifier
1808: AND assembly_identifier <> component_identifier
1809: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1810: UNION ALL
1811: SELECT p_identifier FROM dual)
1812: Comment out code refering msc_bom_temp
1813: */
1814: -- End CTO ODR and Simplified Pegging
1815:

Line 1869: FROM dual;

1865: l_ins_demand_class_tab(l_ins_demand_class_tab.COUNT) := l_demand_class_tab(i);
1866:
1867: SELECT msc_demands_s.nextval
1868: INTO l_copy_demand_id(l_copy_demand_id.COUNT)
1869: FROM dual;
1870:
1871: END IF;
1872: END LOOP;
1873:

Line 1914: SELECT p_identifier FROM dual)

1910: CONNECT BY PRIOR component_identifier = assembly_identifier
1911: AND assembly_identifier <> component_identifier
1912: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1913: UNION ALL
1914: SELECT p_identifier FROM dual)
1915: Comment out code refering msc_bom_temp
1916: */
1917: -- End CTO ODR and Simplified Pegging
1918:

Line 1973: FROM dual;

1969: l_ins_demand_class_tab(l_ins_demand_class_tab.COUNT) := l_demand_class_tab(i);
1970:
1971: SELECT msc_demands_s.nextval
1972: INTO l_copy_demand_id(l_copy_demand_id.COUNT)
1973: FROM dual;
1974: END IF;
1975: END LOOP;
1976:
1977: END IF; --IF l_identifier_tab IS NOT NULL and l_identifier_tab.COUNT > 0 THEN

Line 4384: SELECT msc_supplies_s.nextval into p_transaction_id from dual;

4380: msc_sch_wb.atp_debug('Add_Stealing_Supply_Details: ' || 'p_ship_date = ' ||to_char(p_ship_date));
4381: msc_sch_wb.atp_debug('Add_Stealing_Supply_Details: ' || 'p_refresh_number = ' ||p_refresh_number);
4382: END IF;
4383:
4384: SELECT msc_supplies_s.nextval into p_transaction_id from dual;
4385:
4386: IF PG_DEBUG in ('Y', 'C') THEN
4387: msc_sch_wb.atp_debug('Add_Stealing_Supply_Details: ' || 'before insert into msc_alloc_supplies-Stealing Info');
4388: END IF;