APPS.WMS_ZONES_PVT dependencies on WMS_ZONES_B

Line 1342: * Contains code to insert records into wms_zones_b and

1338: DEBUG ('l_query_count ' || l_query_count, 'add_locators_grid', 9);
1339: END add_locators_to_grid;
1340:
1341: /**
1342: * Contains code to insert records into wms_zones_b and
1343: * wms_zones_tl
1344:
1345: * @param x_return_status Return Status - Success, Error, Unexpected Error
1346: * @param x_msg_data Contains any error messages added to the stack

Line 1542: * Contains code to update records in wms_zones_b and

1538:
1539: END insert_wms_zones;
1540:
1541: /**
1542: * Contains code to update records in wms_zones_b and
1543: * wms_zones_tl
1544:
1545: * @param x_return_status Return Status - Success, Error, Unexpected Error
1546: * @param x_msg_data Contains any error messages added to the stack

Line 1706: DEBUG (' After updating wms_zones_b/tl' ,

1702: );
1703:
1704: IF l_debug > 0 THEN
1705:
1706: DEBUG (' After updating wms_zones_b/tl' ,
1707: l_module_name,
1708: 9
1709: );
1710:

Line 2302: FROM wms_zones_b

2298: l_id NUMBER;
2299:
2300: CURSOR c_zone_id IS
2301: SELECT 1
2302: FROM wms_zones_b
2303: WHERE zone_id = p_zone_id;
2304:
2305: CURSOR c_org_id IS
2306: SELECT 1

Line 2613: FROM wms_zones_b

2609: WHERE organization_id = p_organization_id;
2610:
2611: CURSOR c_zone_id IS
2612: SELECT 1
2613: FROM wms_zones_b
2614: WHERE zone_id = p_zone_id;
2615:
2616: CURSOR c_subinventory_code IS
2617: SELECT 1

Line 2697: * p_zone_id must exist in WMS_ZONES_B

2693:
2694: l_progress_indicator := '40';
2695:
2696: /**
2697: * p_zone_id must exist in WMS_ZONES_B
2698: */
2699: OPEN c_zone_id;
2700: FETCH c_zone_id INTO l_id;
2701: IF c_zone_id%NOTFOUND THEN