APPS.WMS_CONSOLIDATION_PUB dependencies on WMS_CONSOLIDATION_PUB

Line 1: PACKAGE BODY wms_consolidation_pub AS

1: PACKAGE BODY wms_consolidation_pub AS
2: /* $Header: WMSCONSB.pls 120.13.12010000.2 2008/08/25 06:50:57 anviswan ship $ */
3:
4: /** Globals to hold Logging attributes **/
5: g_trace_on NUMBER := 0;

Line 67: IF wms_consolidation_pub.is_delivery_consolidated

63: EXIT WHEN del_csr%notfound;
64:
65: x_total_no_of_dels := x_total_no_of_dels + 1;
66:
67: IF wms_consolidation_pub.is_delivery_consolidated
68: (p_delivery_id => l_delivery_id,
69: p_org_id => p_org_id,
70: p_sub => p_sub,
71: p_loc_id => l_locator_id) = 'Y' THEN

Line 215: AND wms_consolidation_pub.is_delivery_consolidated

211: AND wda.delivery_id IS NOT NULL
212: AND ml.lookup_type = 'MTL_LOCATOR_TYPES'
213: AND ml.lookup_code = nvl(milk.inventory_location_type, 3)
214: AND wdd2.released_status = 'X' -- For LPN reuse ER : 6845650
215: AND wms_consolidation_pub.is_delivery_consolidated
216: (wda.delivery_id,
217: p_org_id,
218: p_sub,
219: mil.inventory_location_id) = 'Y'

Line 280: mydebug('get_consolidation_inq_loc: before calling wms_consolidation_pub.get_values_for_loc');

276:
277: END IF;
278:
279: IF (l_debug = 1) THEN
280: mydebug('get_consolidation_inq_loc: before calling wms_consolidation_pub.get_values_for_loc');
281: mydebug('p_sub : '||p_sub);
282: mydebug('l_loc_id : '||l_loc_id);
283: mydebug('p_org_id : '||p_org_id);
284: mydebug('p_comp_cons_dels_inq_mode : '||p_comp_cons_dels_inq_mode);

Line 287: wms_consolidation_pub.get_values_for_loc

283: mydebug('p_org_id : '||p_org_id);
284: mydebug('p_comp_cons_dels_inq_mode : '||p_comp_cons_dels_inq_mode);
285: END IF;
286:
287: wms_consolidation_pub.get_values_for_loc
288: (p_sub => p_sub,
289: p_loc_id => l_loc_id,
290: p_org_id => p_org_id,
291: p_comp_cons_dels_inq_mode => p_comp_cons_dels_inq_mode,

Line 716: AND wms_consolidation_pub.is_delivery_consolidated

712: AND wlpn.lpn_id = wdd2.lpn_id
713: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id
714: AND wda.delivery_id IS NOT NULL
715: AND wdd2.released_status = 'X' -- For LPN reuse ER : 6845650
716: AND wms_consolidation_pub.is_delivery_consolidated
717: (wda.delivery_id,
718: p_org_id,
719: p_sub,
720: mil.inventory_location_id) = 'Y'

Line 803: AND wms_consolidation_pub.is_delivery_consolidated

799: AND wlpn.organization_id = mil.organization_id
800: AND wlpn.lpn_id = wdd2.lpn_id
801: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id
802: AND wda.delivery_id IS NOT NULL
803: AND wms_consolidation_pub.is_delivery_consolidated
804: (wda.delivery_id,
805: p_org_id,
806: p_sub,
807: mil.inventory_location_id) = 'Y'

Line 1155: IF wms_consolidation_pub.is_delivery_consolidated

1151:
1152: END IF;
1153:
1154:
1155: IF wms_consolidation_pub.is_delivery_consolidated
1156: (p_delivery_id => x_delivery_id,
1157: p_org_id => p_org_id,
1158: p_sub => x_sub,
1159: p_loc_id => l_loc_id) = 'Y' THEN

Line 1365: wms_consolidation_pub.get_values_for_lpn

1361:
1362: IF (g_trace_on = 1) THEN mydebug('get_consolidation_inq_lpn : x_lpn_vector ->' || x_lpn_vector);
1363: END IF;
1364:
1365: wms_consolidation_pub.get_values_for_lpn
1366: (p_lpn_id => l_lpn1_id,
1367: p_org_id => p_org_id,
1368: x_sub => x_sub,
1369: x_loc => x_loc,

Line 1522: wms_consolidation_pub.get_values_for_lpn

1518:
1519: IF (g_trace_on = 1) THEN mydebug('get_query_by_del_lpn : x_lpn_vector ->' || x_lpn_vector);
1520: END IF;
1521:
1522: wms_consolidation_pub.get_values_for_lpn
1523: (p_lpn_id => l_lpn1_id,
1524: p_org_id => p_org_id,
1525: x_sub => x_sub,
1526: x_loc => x_loc,

Line 2937: p_module => 'wms_consolidation_pub',

2933: BEGIN
2934:
2935: inv_mobile_helper_functions.tracelog
2936: (p_err_msg => msg,
2937: p_module => 'wms_consolidation_pub',
2938: p_level => 4);
2939:
2940: --dbms_output.put_line(msg);
2941:

Line 2945: END wms_consolidation_pub;

2941:
2942: null;
2943: END;
2944:
2945: END wms_consolidation_pub;