APPS.MSC_ATP_DB_UTILS dependencies on DUAL

Line 1659: SELECT p_identifier FROM dual

1655: CONNECT BY PRIOR component_identifier = assembly_identifier
1656: AND assembly_identifier <> component_identifier
1657: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1658: UNION ALL
1659: SELECT p_identifier FROM dual
1660: -- rajjain 03/14/2003 Bug 2849749 End
1661: )
1662: Comment out code refering msc_bom_temp
1663: */

Line 1720: SELECT p_identifier FROM dual

1716: CONNECT BY PRIOR component_identifier = assembly_identifier
1717: AND assembly_identifier <> component_identifier
1718: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1719: UNION ALL
1720: SELECT p_identifier FROM dual
1721: )
1722: Comment out code refering msc_bom_temp
1723:
1724: -- End CTO ODR and Simplified Pegging

Line 1785: FROM dual;

1781: l_ins_date_tab(l_ins_date_tab.COUNT) := l_old_demand_date(i);
1782:
1783: SELECT msc_demands_s.nextval
1784: INTO l_copy_demand_id(l_copy_demand_id.COUNT)
1785: FROM dual;
1786: END IF;
1787: END LOOP;
1788:
1789: IF i_ins_item_id_tab IS NOT NULL and i_ins_item_id_tab.COUNT > 0 THEN

Line 1964: SELECT p_identifier FROM dual)

1960: CONNECT BY PRIOR component_identifier = assembly_identifier
1961: AND assembly_identifier <> component_identifier
1962: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1963: UNION ALL
1964: SELECT p_identifier FROM dual)
1965: Comment out code refering msc_bom_temp
1966: */
1967: -- End CTO ODR and Simplified Pegging
1968:

Line 2022: FROM dual;

2018: l_ins_demand_class_tab(l_ins_demand_class_tab.COUNT) := l_demand_class_tab(i);
2019:
2020: SELECT msc_demands_s.nextval
2021: INTO l_copy_demand_id(l_copy_demand_id.COUNT)
2022: FROM dual;
2023:
2024: END IF;
2025: END LOOP;
2026:

Line 2067: SELECT p_identifier FROM dual)

2063: CONNECT BY PRIOR component_identifier = assembly_identifier
2064: AND assembly_identifier <> component_identifier
2065: AND session_id = MSC_ATP_PVT.G_SESSION_ID
2066: UNION ALL
2067: SELECT p_identifier FROM dual)
2068: Comment out code refering msc_bom_temp
2069: */
2070: -- End CTO ODR and Simplified Pegging
2071:

Line 2126: FROM dual;

2122: l_ins_demand_class_tab(l_ins_demand_class_tab.COUNT) := l_demand_class_tab(i);
2123:
2124: SELECT msc_demands_s.nextval
2125: INTO l_copy_demand_id(l_copy_demand_id.COUNT)
2126: FROM dual;
2127: END IF;
2128: END LOOP;
2129:
2130: END IF; --IF l_identifier_tab IS NOT NULL and l_identifier_tab.COUNT > 0 THEN

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

4562: msc_sch_wb.atp_debug('Add_Stealing_Supply_Details: ' || 'p_ship_date = ' ||to_char(p_ship_date));
4563: msc_sch_wb.atp_debug('Add_Stealing_Supply_Details: ' || 'p_refresh_number = ' ||p_refresh_number);
4564: END IF;
4565:
4566: SELECT msc_supplies_s.nextval into p_transaction_id from dual;
4567:
4568: IF PG_DEBUG in ('Y', 'C') THEN
4569: msc_sch_wb.atp_debug('Add_Stealing_Supply_Details: ' || 'before insert into msc_alloc_supplies-Stealing Info');
4570: END IF;