[Home] [Help]
PACKAGE: APPS.INV_MWB_GLOBALS
Source
1 PACKAGE inv_mwb_globals AUTHID CURRENT_USER AS
2 /* $Header: INVMWGLS.pls 120.16.12010000.5 2009/11/30 14:43:26 ksaripal ship $ */
3
4 /*
5 * Query Find Parameters
6 */
7
8 /* Newly added columns*/
9 g_organization_code VARCHAR2(3);
10 g_locator_name VARCHAR2(200);
11 g_item_name VARCHAR2(300);
12 g_cost_group VARCHAR2(100);
13 g_project_number VARCHAR2(25);
14 g_task_number VARCHAR2(25);
15 g_owning_party VARCHAR2(300);
16 g_planning_party VARCHAR2(300);
17 g_lpn_state VARCHAR2(30);
18 g_status VARCHAR2(300);
19 /* Newly added columns end*/
20
21 g_serial_attr_query VARCHAR2(300); -- Bug 6429880
22 g_lot_attr_query VARCHAR2(300); -- Bug 7566588
23
24 g_last_query LONG;
25
26 g_organization_id NUMBER;
27 g_locator_id NUMBER;
28 g_subinventory_code VARCHAR2(30);
29 g_client_code VARCHAR2(25); -- ER(9158529 client)
30 g_inventory_item_id NUMBER;
31 g_revision VARCHAR2(3);
32 g_status_id NUMBER;
33 g_cost_group_id NUMBER;
34 g_category_set_id NUMBER; -- ER(9158529)
35 g_category_id NUMBER; -- ER(9158529)
36 g_lpn_from VARCHAR2(30);
37 g_lpn_to VARCHAR2(30);
38 g_lpn_from_id NUMBER;
39 g_lpn_to_id NUMBER;
40 g_lot_from VARCHAR2(80);
41 g_lot_to VARCHAR2(80);
42 g_supplier_lot_from VARCHAR2(80); -- Bug 8396954
43 g_supplier_lot_to VARCHAR2(80); -- Bug 8396954
44 g_serial_from VARCHAR2(30);
45 g_serial_to VARCHAR2(30);
46 g_workbench_vb NUMBER;
47 g_prepacked VARCHAR2(30);
48 g_project_id NUMBER;
49 g_task_id NUMBER;
50 g_unit_number VARCHAR2(30);
51 g_planning_org VARCHAR2(30);
52 g_owning_org VARCHAR2(30);
53 g_po_header_id NUMBER;
54 g_po_release_id NUMBER;
55 g_shipment_header_id_asn VARCHAR2(30);
56 g_shipment_header_id_interorg VARCHAR2(30);
57 g_req_header_id NUMBER;
58 g_vendor_id NUMBER;
59 g_vendor_site_id NUMBER;
60 g_source_org_id NUMBER;
61 g_chk_inbound NUMBER;
62 g_chk_receiving NUMBER;
63 g_chk_onhand NUMBER;
64 g_include_po_without_asn NUMBER;
65 g_expected_from_date DATE;
66 g_expected_to_date DATE;
67 g_internal_order_id NUMBER;
68 g_vendor_item VARCHAR2(250);
69 g_grade_from_code VARCHAR2(150);
70 g_planning_query_mode NUMBER;
71 g_owning_qry_mode NUMBER;
72 g_wms_enabled_flag NUMBER;
73 g_sub_type NUMBER;
74 g_rcv_query_mode NUMBER;
75 g_detailed NUMBER;
76 g_item_description VARCHAR2(240);
77 g_qty_from NUMBER;
78 g_qty_to NUMBER;
79 g_locator_control_code NUMBER;
80 g_wms_installed_flag NUMBER;
81 g_check NUMBER;
82 g_responsibility_id NUMBER;
83 g_resp_application_id NUMBER;
84 g_mln_context_code VARCHAR2(30);
85 g_msn_context_code VARCHAR2(30);
86 g_grade_controlled NUMBER;
87 g_serial_controlled NUMBER;
88 g_lot_controlled NUMBER;
89 g_only_locator_status NUMBER;
90 g_only_subinventory_status NUMBER;
91 g_containerized NUMBER;
92 g_locator_controlled NUMBER;
93 g_inserted_under_org VARCHAR2(10);
94 g_revision_controlled NUMBER;
95 g_only_lot_status NUMBER;
96 g_only_serial_status NUMBER;
97 g_view_by VARCHAR2(30);
98 g_multiple_loc_selected VARCHAR2(30);
99 g_tree_organization_id NUMBER;
100 g_tree_loc_id NUMBER;
101 g_tree_item_id NUMBER;
102 g_tree_subinventory_code VARCHAR2(30);
103 g_tree_parent_lpn_id NUMBER;
104 g_tree_mat_loc_id NUMBER;
105 g_tree_doc_type_id NUMBER;
106 g_tree_doc_num VARCHAR2(30);
107 g_tree_doc_header_id NUMBER;
108 g_tree_st_id NUMBER;
109 g_tree_rev VARCHAR2(3);
110 g_tree_cg_id NUMBER;
111 g_tree_grade_code VARCHAR2(150);
112 g_tree_serial_number VARCHAR2(30);
113 g_tree_lot_number VARCHAR2(80);
114 g_tree_node_type VARCHAR2(50);
115 g_tree_node_value VARCHAR2(300);
116 g_tree_node_state NUMBER;
117 g_tree_node_high_value NUMBER;
118 g_tree_node_low_value NUMBER;
119 g_tree_serial_attr_query VARCHAR2(300);
120 g_tree_attribute_qf_lot VARCHAR2(300);
121 g_tree_attribute_qf_serial VARCHAR2(300);
122 g_tree_query_lot_attr VARCHAR2(300);
123 g_tree_query_serial_attr VARCHAR2(300);
124 g_tree_lot_attr_query VARCHAR2(300);
125 g_tree_event VARCHAR2(50);
126 g_lot_context VARCHAR2(30);
127 g_serial_context VARCHAR2(30);
128 g_is_projects_enabled_org NUMBER;
129 g_is_nested_lpn VARCHAR2(10) := 'NO';
130
131 --KMOTUPAL ME # 3922793
132 g_expired_lots VARCHAR2(1);
133 g_expiration_date DATE;
134 g_shipment_header_id NUMBER; -- BUG 6633612
135 g_parent_lot VARCHAR2(80); -- BUG 7556505
136
137 PROCEDURE print_parameters;
138 PROCEDURE dump_parameters;
139
140 PROCEDURE print_msg(
141 p_package IN VARCHAR2
142 , p_procedure IN VARCHAR2
143 , p_msg IN VARCHAR2
144 );
145
146 SUBTYPE very_long_str IS VARCHAR2(30000);
147 SUBTYPE long_str IS VARCHAR2(5000);
148 SUBTYPE short_str IS VARCHAR2(1000);
149
150 END inv_mwb_globals;