[Home] [Help]
PACKAGE: APPS.INV_CACHE
Source
1 PACKAGE inv_cache AUTHID CURRENT_USER AS
2 /* $Header: INVCACHS.pls 120.6 2010/06/22 16:09:10 mporecha ship $ */
3
4 org_rec mtl_parameters%ROWTYPE;
5 tosub_rec mtl_secondary_inventories%ROWTYPE;
6 fromsub_rec mtl_secondary_inventories%ROWTYPE;
7 item_rec mtl_system_items%ROWTYPE;
8 mmtt_rec mtl_material_transactions_temp%ROWTYPE;
9 mol_rec mtl_txn_request_lines%ROWTYPE;
10 mtrh_rec mtl_txn_request_headers%ROWTYPE;
11 wdd_rec wsh_delivery_details%ROWTYPE;
12 mtt_rec mtl_transaction_types%ROWTYPE;
13 mso_rec mtl_sales_orders%ROWTYPE;
14
15 --Bug 4171297
16 oola_rec oe_order_lines_all%ROWTYPE;
17
18 -- Bug# 4258360: Added the following for R12 Crossdock Pegging Project
19 wpb_rec wsh_picking_batches%ROWTYPE;
20
21 -- Onhand Material Status Support
22 loc_rec mtl_item_locations%ROWTYPE;
23 moqd_rec mtl_onhand_quantities_detail%ROWTYPE;
24 -- Onhand Material Status Support
25
26 -- 8809951 High Volume Project Phase-2
27 pjm_org_parms_rec pjm_org_parameters%ROWTYPE;
28
29
30 /* Added for LSP Project */
31
32 TYPE ct_rec_type IS RECORD ( client_rec MTL_CLIENT_PARAMETERS%ROWTYPE ) ;
33 TYPE ct_rec_table IS TABLE OF ct_rec_type INDEX BY BINARY_INTEGER;
34 ct_table ct_rec_table;
35
36 /* End of changes for LSP Project */
37
38 -- Serial Tagging
39
40 TYPE serial_tag_rec_table IS TABLE OF NUMBER
41 INDEX BY BINARY_INTEGER;
42 serial_tag_table serial_tag_rec_table;
43
44 -- Bug# 4951639: Added to set move order transaction date during pick release
45 mo_transaction_date DATE;
46
47 wms_installed BOOLEAN;
48 is_pickrelease BOOLEAN;
49 oe_header_id NUMBER;
50 tolocator_id NUMBER;
51 tosubinventory_code VARCHAR2(10);
52
53 FUNCTION set_org_rec
54 (
55 p_organization_id IN NUMBER
56 ) RETURN BOOLEAN;
57
58 FUNCTION set_org_rec
59 (
60 p_organization_code IN VARCHAR2
61 ) RETURN BOOLEAN;
62
63 FUNCTION set_item_rec
64 (
65 p_organization_id IN NUMBER,
66 p_item_id IN NUMBER
67 ) RETURN BOOLEAN;
68
69 FUNCTION set_tosub_rec
70 (
71 p_organization_id IN NUMBER,
72 p_subinventory_code IN VARCHAR2
73 ) RETURN BOOLEAN;
74
75 FUNCTION set_fromsub_rec
76 (
77 p_organization_id IN NUMBER,
78 p_subinventory_code IN VARCHAR2
79 ) RETURN BOOLEAN;
80
81 FUNCTION set_mmtt_rec
82 (
83 p_transaction_temp_id IN NUMBER
84 ) RETURN BOOLEAN;
85
86 FUNCTION set_mol_rec
87 (
88 p_line_id IN NUMBER
89 ) RETURN BOOLEAN;
90
91 FUNCTION set_mtrh_rec
92 (
93 p_header_id IN NUMBER
94 ) RETURN BOOLEAN;
95
96 FUNCTION set_wdd_rec
97 (
98 p_move_order_line_id IN NUMBER
99 ) RETURN BOOLEAN;
100
101 FUNCTION set_mso_rec
102 (
103 p_oe_header_id IN NUMBER
104 ) RETURN BOOLEAN;
105
106 FUNCTION set_oeh_id
107 (
108 p_salesorder_id IN NUMBER
109 ) RETURN BOOLEAN;
110
111 FUNCTION set_mtt_rec
112 (
113 p_transaction_type_id IN NUMBER
114 ) RETURN BOOLEAN;
115
116 FUNCTION set_wms_installed
117 (
118 p_organization_id IN NUMBER
119 ) RETURN BOOLEAN;
120
121 FUNCTION set_pick_release
122 (
123 p_value IN BOOLEAN
124 ) RETURN BOOLEAN;
125
126 FUNCTION set_to_locator
127 (
128 p_locator_id IN NUMBER
129 ) RETURN BOOLEAN;
130
131 FUNCTION set_to_subinventory
132 (
133 p_subinventory_code IN NUMBER
134 ) RETURN BOOLEAN;
135
136 --4171297
137 FUNCTION set_oola_rec
138 (
139 p_order_line_id IN NUMBER
140 ) RETURN BOOLEAN;
141
142 -- Bug# 4258360: Added for R12 Crossdock Pegging Project
143 FUNCTION set_wpb_rec
144 (
145 p_batch_id IN NUMBER,
146 p_request_number IN VARCHAR2
147 ) RETURN BOOLEAN;
148
149 -- Onhand Material Status Support
150 FUNCTION set_loc_rec
151 (
152 p_organization_id IN NUMBER,
153 p_locator_id IN VARCHAR2
154 ) RETURN BOOLEAN;
155
156 -- Onhand Material Status Support
157 FUNCTION set_moqd_status_rec
158 (
159 p_organization_id IN NUMBER,
160 p_inventory_item_id IN NUMBER,
161 p_sub_code IN VARCHAR2,
162 p_loc_id IN NUMBER,
163 p_lot_number IN VARCHAR2,
164 p_lpn_id IN NUMBER
165 ) RETURN BOOLEAN;
166
167 -- 8809951 High Volume Project Phase-2
168 FUNCTION set_pjm_org_parms_rec
169 (
170 p_organization_id IN NUMBER
171 ) RETURN BOOLEAN;
172
173 /* Added for LSP Project */
174
175 PROCEDURE get_client_default_parameters
176 (
177 p_client_id IN MTL_CLIENT_PARAMETERS.CLIENT_ID%TYPE
178 , x_return_status OUT NOCOPY VARCHAR2
179 , x_client_parameters_rec OUT NOCOPY ct_rec_type
180 );
181
182 /* End of changes for LSP Project */
183
184 --Serial Tagged
185 FUNCTION get_serial_tagged
186 (
187 p_organization_id IN NUMBER
188 , p_inventory_item_id IN NUMBER
189 , p_transaction_type_id IN NUMBER
190 ) RETURN NUMBER;
191
192 END inv_cache;