APPS.WMS_TASK_DISPATCH_LOV dependencies on WMS_TASK_DISPATCH_LOV

Line 1: PACKAGE BODY WMS_Task_Dispatch_LOV AS

1: PACKAGE BODY WMS_Task_Dispatch_LOV AS
2: /* $Header: WMSTSKLB.pls 120.19.12020000.4 2013/01/24 10:53:02 pramadur ship $ */
3:
4:
5: -- Global constant holding the package name

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_Task_Dispatch_LOV';

3:
4:
5: -- Global constant holding the package name
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_Task_Dispatch_LOV';
8: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
9: g_gtin_code_length NUMBER := 14;
10:
11:

Line 24: p_module => 'WMS_Task_Dispatch_LOV',

20: l_msg := msg;
21:
22: inv_mobile_helper_functions.tracelog
23: (p_err_msg => l_msg,
24: p_module => 'WMS_Task_Dispatch_LOV',
25: p_level => 4);
26:
27: --dbms_output.put_line(l_msg);
28:

Line 52: inv_trx_util_pub.trace( 'WMS_Task_Dispatch_LOV - GET_TASk_LOV Unload ER Changes - p_page_type type' || p_page_type || 'p_unload Receiving -' || p_unload_receiving , '~~~~ ', 1);

48: l_wms_po_j_or_higher := 1;
49: END IF;
50:
51: --Unload ER
52: inv_trx_util_pub.trace( 'WMS_Task_Dispatch_LOV - GET_TASk_LOV Unload ER Changes - p_page_type type' || p_page_type || 'p_unload Receiving -' || p_unload_receiving , '~~~~ ', 1);
53:
54:
55:
56: IF p_page_type = 'SYSTEM_DROP'

Line 962: inv_trx_util_pub.trace( 'WMS_Task_Dispatch_LOV - GET_REASONS_LOV - p_reason type' || p_reason_type || 'p_concat_segments -' || p_concat_segments , '~~~~ ', 1); --/* Bug 9448490 Lot Substitution Project */

958: p_concat_segments IN VARCHAR2) IS
959:
960:
961: BEGIN
962: inv_trx_util_pub.trace( 'WMS_Task_Dispatch_LOV - GET_REASONS_LOV - p_reason type' || p_reason_type || 'p_concat_segments -' || p_concat_segments , '~~~~ ', 1); --/* Bug 9448490 Lot Substitution Project */
963:
964: OPEN x_reasons FOR
965: SELECT reason_name,description, reason_id
966: FROM mtl_transaction_reasons

Line 1718: END wms_task_dispatch_LOV;

1714: ORDER BY reason_name;
1715:
1716: END get_reasons_lov;
1717:
1718: END wms_task_dispatch_LOV;
1719: