APPS.WMS_LMS_EXPECTED_RES dependencies on WMS_LMS_UTILS

Line 2132: IF WMS_LMS_UTILS. ORG_LABOR_MGMT_ENABLED(p_org_id) THEN

2128: END IF;
2129:
2130: -- proceed to any processing only is organization is labor enabled.
2131:
2132: IF WMS_LMS_UTILS. ORG_LABOR_MGMT_ENABLED(p_org_id) THEN
2133:
2134: -- Insering the data into Global temporary table for the selected organization
2135: -- Added for the bug # 5169490
2136:

Line 2258: IF WMS_LMS_UTILS.UNPROCESSED_ROWS_REMAINING (p_org_id) = 2 THEN

2254: -- setup data. It will return FALSE when no more rows are left to process. This fucntion will be
2255: -- used to exit the processing once all rows in wms_els_trx_src are exhaused even before
2256: -- all the rows in setup are exhausted.
2257:
2258: IF WMS_LMS_UTILS.UNPROCESSED_ROWS_REMAINING (p_org_id) = 2 THEN
2259: IF g_debug=1 THEN
2260: debug('No More rows to process so exit','MATCH_RATE_EXP_RESOURCE');
2261: END IF;
2262: EXIT;

Line 2300: ||' WMS_LMS_UTILS. ZONE_LABOR_MGMT_ENABLED(:org_id,:source_zone_id)=''Y'''

2296: || ' IN (select inventory_location_id'
2297: || ' from WMS_ZONE_LOCATORS'
2298: || ' where zone_id= :source_zone_id AND organization_id = :org_id'
2299: || ' AND '
2300: ||' WMS_LMS_UTILS. ZONE_LABOR_MGMT_ENABLED(:org_id,:source_zone_id)=''Y'''
2301: || ')'
2302: || ')) ';
2303: END IF;
2304:

Line 2320: || ' WMS_LMS_UTILS. ZONE_LABOR_MGMT_ENABLED(:org_id,:destination_zone_id)=''Y'''

2316: || ' IN (select inventory_location_id '
2317: || ' from WMS_ZONE_LOCATORS '
2318: || ' where zone_id= :destination_zone_id AND organization_id = :org_id'
2319: || ' AND '
2320: || ' WMS_LMS_UTILS. ZONE_LABOR_MGMT_ENABLED(:org_id,:destination_zone_id)=''Y'''
2321: || ')'
2322: || ')) ';
2323: END IF;
2324: