APPS.WMS_LMS_LABOR_PRODUCTIVITY dependencies on WMS_LMS_UTILS

Line 156: IF WMS_LMS_UTILS.ORG_LABOR_MGMT_ENABLED(p_org_id) THEN

152: IF g_debug=1 THEN
153: debug('The value of p_org_id '|| p_org_id,'MATCH_RATE_TRX_RECORDS');
154: END IF;
155:
156: IF WMS_LMS_UTILS.ORG_LABOR_MGMT_ENABLED(p_org_id) THEN
157:
158: IF g_debug=1 THEN
159: debug('Org is Labor Enabled','MATCH_RATE_TRX_RECORDS');
160: END IF;

Line 204: IF WMS_LMS_UTILS.UNPROCESSED_ROWS_REMAINING (p_org_id,l_max_id) =2 THEN

200: IF g_debug=1 THEN
201: debug('Check if we have some more rows to process if no exit','MATCH_RATE_TRX_RECORDS');
202: END IF;
203:
204: IF WMS_LMS_UTILS.UNPROCESSED_ROWS_REMAINING (p_org_id,l_max_id) =2 THEN
205: EXIT;
206: END IF;
207:
208: IF g_debug=1 THEN

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

245: || ' IN (select inventory_location_id'
246: || ' from WMS_ZONE_LOCATORS'
247: || ' where zone_id= :source_zone_id AND organization_id = :org_id'
248: || ' AND '
249: || ' WMS_LMS_UTILS. ZONE_LABOR_MGMT_ENABLED(:org_id,:source_zone_id)=''Y'''
250: || ')'
251: || ' )) ';
252: END IF;
253:

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

267: || ' IN (select inventory_location_id '
268: || ' from WMS_ZONE_LOCATORS '
269: || ' where zone_id= :destination_zone_id AND organization_id = :org_id'
270: || ' AND '
271: || ' WMS_LMS_UTILS. ZONE_LABOR_MGMT_ENABLED(:org_id,:destination_zone_id)=''Y'''
272: || ')'
273: || ')) ';
274: END IF;
275: