[Home] [Help]
487: l_op_plan_id NUMBER;
488: l_num_sub_batches NUMBER;
489:
490: CURSOR c_opa_rule_exists (p_org_id NUMBER) IS
491: SELECT 'x' FROM dual
492: WHERE EXISTS
493: ( SELECT 'x'
494: FROM wms_rules rules
495: , wms_op_plans_b wop
666: l_ttype_id NUMBER;
667: l_num_sub_batches NUMBER;
668:
669: CURSOR c_tta_rule_exists (p_org_id NUMBER) IS
670: SELECT 'x' FROM dual
671: WHERE EXISTS
672: ( SELECT 'x'
673: FROM wms_rules rules
674: WHERE rules.organization_id IN (p_org_id,-1)
838: l_api_return_status VARCHAR2(1);
839: l_num_sub_batches NUMBER;
840:
841: CURSOR c_lbl_data_exists IS
842: SELECT 'x' FROM dual
843: WHERE EXISTS
844: ( SELECT 'x'
845: FROM mtl_material_transactions_temp mmtt1
846: WHERE mmtt1.move_order_header_id = p_mo_header_id
1800: /* -- Check for conflicts with other running programs
1801: IF l_mode IS NULL THEN --{
1802: BEGIN
1803: SELECT 'x' INTO l_dummy
1804: FROM dual
1805: WHERE EXISTS
1806: ( SELECT 'x'
1807: FROM wms_pr_workers
1808: WHERE organization_id = p_organization_id
1834: IF l_mode IS NULL THEN --{
1835: -- Verify that unreleased tasks exist
1836: BEGIN
1837: SELECT 'x' INTO l_dummy
1838: FROM dual
1839: WHERE EXISTS
1840: ( SELECT 'x'
1841: FROM mtl_material_transactions_temp
1842: WHERE move_order_header_id = l_mo_header_id
1869:
1870: -- Verify there are no released tasks
1871: BEGIN
1872: SELECT 'x' INTO l_dummy
1873: FROM dual
1874: WHERE EXISTS
1875: ( SELECT 'x'
1876: FROM mtl_material_transactions_temp
1877: WHERE move_order_header_id = l_mo_header_id
1905: --
1906: IF l_mode IS NULL AND g_consolidate_tasks THEN --{
1907: l_bulk_tasks_exist := FALSE;
1908: BEGIN
1909: SELECT 'x' INTO l_dummy FROM dual
1910: WHERE EXISTS
1911: ( SELECT 'x' FROM mtl_material_transactions_temp
1912: WHERE move_order_header_id = l_mo_header_id
1913: AND parent_line_id IS NOT NULL