APPS.WMS_ZONES_PVT dependencies on WMS_ZONES_B

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

1321: DEBUG ('l_query_count ' || l_query_count, 'add_locators_grid', 9);
1322: END add_locators_to_grid;
1323:
1324: /**
1325: * Contains code to insert records into wms_zones_b and
1326: * wms_zones_tl
1327:
1328: * @param x_return_status Return Status - Success, Error, Unexpected Error
1329: * @param x_msg_data Contains any error messages added to the stack

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

1516:
1517: END insert_wms_zones;
1518:
1519: /**
1520: * Contains code to update records in wms_zones_b and
1521: * wms_zones_tl
1522:
1523: * @param x_return_status Return Status - Success, Error, Unexpected Error
1524: * @param x_msg_data Contains any error messages added to the stack

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

1678: );
1679:
1680: IF l_debug > 0 THEN
1681:
1682: DEBUG (' After updating wms_zones_b/tl' ,
1683: l_module_name,
1684: 9
1685: );
1686:

Line 2275: FROM wms_zones_b

2271: l_id NUMBER;
2272:
2273: CURSOR c_zone_id IS
2274: SELECT 1
2275: FROM wms_zones_b
2276: WHERE zone_id = p_zone_id;
2277:
2278: CURSOR c_org_id IS
2279: SELECT 1

Line 2586: FROM wms_zones_b

2582: WHERE organization_id = p_organization_id;
2583:
2584: CURSOR c_zone_id IS
2585: SELECT 1
2586: FROM wms_zones_b
2587: WHERE zone_id = p_zone_id;
2588:
2589: CURSOR c_subinventory_code IS
2590: SELECT 1

Line 2670: * p_zone_id must exist in WMS_ZONES_B

2666:
2667: l_progress_indicator := '40';
2668:
2669: /**
2670: * p_zone_id must exist in WMS_ZONES_B
2671: */
2672: OPEN c_zone_id;
2673: FETCH c_zone_id INTO l_id;
2674: IF c_zone_id%NOTFOUND THEN