[Home] [Help]
PACKAGE: APPS.INV_MWB_GLOBALS
Source
1 PACKAGE inv_mwb_globals AS
2 /* $Header: INVMWGLS.pls 120.16.12010000.3 2008/11/14 12:51:35 vijrajen 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_inventory_item_id NUMBER;
30 g_revision VARCHAR2(3);
31 g_status_id NUMBER;
32 g_cost_group_id NUMBER;
33 g_lpn_from VARCHAR2(30);
34 g_lpn_to VARCHAR2(30);
35 g_lpn_from_id NUMBER;
36 g_lpn_to_id NUMBER;
37 g_lot_from VARCHAR2(80);
38 g_lot_to VARCHAR2(80);
39 g_serial_from VARCHAR2(30);
40 g_serial_to VARCHAR2(30);
41 g_workbench_vb NUMBER;
42 g_prepacked VARCHAR2(30);
43 g_project_id NUMBER;
44 g_task_id NUMBER;
45 g_unit_number VARCHAR2(30);
46 g_planning_org VARCHAR2(30);
47 g_owning_org VARCHAR2(30);
48 g_po_header_id NUMBER;
49 g_po_release_id NUMBER;
50 g_shipment_header_id_asn VARCHAR2(30);
51 g_shipment_header_id_interorg VARCHAR2(30);
52 g_req_header_id NUMBER;
53 g_vendor_id NUMBER;
54 g_vendor_site_id NUMBER;
55 g_source_org_id NUMBER;
56 g_chk_inbound NUMBER;
57 g_chk_receiving NUMBER;
58 g_chk_onhand NUMBER;
59 g_include_po_without_asn NUMBER;
60 g_expected_from_date DATE;
61 g_expected_to_date DATE;
62 g_internal_order_id NUMBER;
63 g_vendor_item VARCHAR2(250);
64 g_grade_from_code VARCHAR2(150);
65 g_planning_query_mode NUMBER;
66 g_owning_qry_mode NUMBER;
67 g_wms_enabled_flag NUMBER;
68 g_sub_type NUMBER;
69 g_rcv_query_mode NUMBER;
70 g_detailed NUMBER;
71 g_item_description VARCHAR2(240);
72 g_qty_from NUMBER;
73 g_qty_to NUMBER;
74 g_locator_control_code NUMBER;
75 g_wms_installed_flag NUMBER;
76 g_check NUMBER;
77 g_responsibility_id NUMBER;
78 g_resp_application_id NUMBER;
79 g_mln_context_code VARCHAR2(30);
80 g_msn_context_code VARCHAR2(30);
81 g_grade_controlled NUMBER;
82 g_serial_controlled NUMBER;
83 g_lot_controlled NUMBER;
84 g_only_locator_status NUMBER;
85 g_only_subinventory_status NUMBER;
86 g_containerized NUMBER;
87 g_locator_controlled NUMBER;
88 g_inserted_under_org VARCHAR2(10);
89 g_revision_controlled NUMBER;
90 g_only_lot_status NUMBER;
91 g_only_serial_status NUMBER;
92 g_view_by VARCHAR2(30);
93 g_multiple_loc_selected VARCHAR2(30);
94 g_tree_organization_id NUMBER;
95 g_tree_loc_id NUMBER;
96 g_tree_item_id NUMBER;
97 g_tree_subinventory_code VARCHAR2(30);
98 g_tree_parent_lpn_id NUMBER;
99 g_tree_mat_loc_id NUMBER;
100 g_tree_doc_type_id NUMBER;
101 g_tree_doc_num VARCHAR2(30);
102 g_tree_doc_header_id NUMBER;
103 g_tree_st_id NUMBER;
104 g_tree_rev VARCHAR2(3);
105 g_tree_cg_id NUMBER;
106 g_tree_grade_code VARCHAR2(150);
107 g_tree_serial_number VARCHAR2(30);
108 g_tree_lot_number VARCHAR2(80);
109 g_tree_node_type VARCHAR2(50);
110 g_tree_node_value VARCHAR2(300);
111 g_tree_node_state NUMBER;
112 g_tree_node_high_value NUMBER;
113 g_tree_node_low_value NUMBER;
114 g_tree_serial_attr_query VARCHAR2(300);
115 g_tree_attribute_qf_lot VARCHAR2(300);
116 g_tree_attribute_qf_serial VARCHAR2(300);
117 g_tree_query_lot_attr VARCHAR2(300);
118 g_tree_query_serial_attr VARCHAR2(300);
119 g_tree_lot_attr_query VARCHAR2(300);
120 g_tree_event VARCHAR2(50);
121 g_lot_context VARCHAR2(30);
122 g_serial_context VARCHAR2(30);
123 g_is_projects_enabled_org NUMBER;
124 g_is_nested_lpn VARCHAR2(10) := 'NO';
125
126 --KMOTUPAL ME # 3922793
127 g_expired_lots VARCHAR2(1);
128 g_expiration_date DATE;
129 g_shipment_header_id NUMBER; -- BUG 6633612
130 g_parent_lot VARCHAR2(80); -- BUG 7556505
131
132 PROCEDURE print_parameters;
133 PROCEDURE dump_parameters;
134
135 PROCEDURE print_msg(
136 p_package IN VARCHAR2
137 , p_procedure IN VARCHAR2
138 , p_msg IN VARCHAR2
139 );
140
141 SUBTYPE very_long_str IS VARCHAR2(30000);
142 SUBTYPE long_str IS VARCHAR2(5000);
143 SUBTYPE short_str IS VARCHAR2(1000);
144
145 END inv_mwb_globals;