[Home] [Help]
PACKAGE: APPS.INV_LABEL_PVT5
Source
1 PACKAGE INV_LABEL_PVT5 AUTHID CURRENT_USER AS
2 /* $Header: INVLAP5S.pls 120.1.12020000.1 2012/06/26 12:11:30 appldev ship $ */
3 G_PKG_NAME CONSTANT VARCHAR2(50) := 'INV_LABEL_PVT5';
4
5 TYPE lpn_data_type_rec is RECORD
6 (
7 lpn VARCHAR2(30)
8 , parent_lpn_id NUMBER
9 , parent_lpn VARCHAR2(30)
10 , outermost_lpn VARCHAR2(30)
11 , container_item_id NUMBER
12 , container_item VARCHAR2(40)
13 , volume NUMBER
14 , volume_uom VARCHAR2(3)
15 , gross_weight NUMBER
16 , gross_weight_uom VARCHAR2(3)
17 , tare_weight NUMBER
18 , tare_weight_uom VARCHAR2(3)
19 , lpn_attribute_category VARCHAR2(30)
20 , lpn_attribute1 VARCHAR2(150)
21 , lpn_attribute2 VARCHAR2(150)
22 , lpn_attribute3 VARCHAR2(150)
23 , lpn_attribute4 VARCHAR2(150)
24 , lpn_attribute5 VARCHAR2(150)
25 , lpn_attribute6 VARCHAR2(150)
26 , lpn_attribute7 VARCHAR2(150)
27 , lpn_attribute8 VARCHAR2(150)
28 , lpn_attribute9 VARCHAR2(150)
29 , lpn_attribute10 VARCHAR2(150)
30 , lpn_attribute11 VARCHAR2(150)
31 , lpn_attribute12 VARCHAR2(150)
32 , lpn_attribute13 VARCHAR2(150)
33 , lpn_attribute14 VARCHAR2(150)
34 , lpn_attribute15 VARCHAR2(150)
35 , parent_package NUMBER
36 , pack_level NUMBER
37 );
38
39 TYPE item_data_type_rec is RECORD
40 (
41 organization VARCHAR2(3)
42 , item VARCHAR2(40)
43 , client_item VARCHAR2(40) -- Added for LSP Project, bug 9087971
44 , item_description VARCHAR2(240)
45 , item_attribute_category VARCHAR2(30)
46 , item_attribute1 VARCHAR2(150)
47 , item_attribute2 VARCHAR2(150)
48 , item_attribute3 VARCHAR2(150)
49 , item_attribute4 VARCHAR2(150)
50 , item_attribute5 VARCHAR2(150)
51 , item_attribute6 VARCHAR2(150)
52 , item_attribute7 VARCHAR2(150)
53 , item_attribute8 VARCHAR2(150)
54 , item_attribute9 VARCHAR2(150)
55 , item_attribute10 VARCHAR2(150)
56 , item_attribute11 VARCHAR2(150)
57 , item_attribute12 VARCHAR2(150)
58 , item_attribute13 VARCHAR2(150)
59 , item_attribute14 VARCHAR2(150)
60 , item_attribute15 VARCHAR2(150)
61
62 , lot_expiration_date VARCHAR2(100) -- Changed for bug 2977490
63 , item_hazard_class VARCHAR2(40)
64 , lot_attribute_category VARCHAR2(30)
65 , lot_c_attribute1 VARCHAR2(150)
66 , lot_c_attribute2 VARCHAR2(150)
67 , lot_c_attribute3 VARCHAR2(150)
68 , lot_c_attribute4 VARCHAR2(150)
69 , lot_c_attribute5 VARCHAR2(150)
70 , lot_c_attribute6 VARCHAR2(150)
71 , lot_c_attribute7 VARCHAR2(150)
72 , lot_c_attribute8 VARCHAR2(150)
73 , lot_c_attribute9 VARCHAR2(150)
74 , lot_c_attribute10 VARCHAR2(150)
75 , lot_c_attribute11 VARCHAR2(150)
76 , lot_c_attribute12 VARCHAR2(150)
77 , lot_c_attribute13 VARCHAR2(150)
78 , lot_c_attribute14 VARCHAR2(150)
79 , lot_c_attribute15 VARCHAR2(150)
80 , lot_c_attribute16 VARCHAR2(150)
81 , lot_c_attribute17 VARCHAR2(150)
82 , lot_c_attribute18 VARCHAR2(150)
83 , lot_c_attribute19 VARCHAR2(150)
84 , lot_c_attribute20 VARCHAR2(150)
85 , lot_d_attribute1 VARCHAR2(100) -- Changed for bug 2977490
86 , lot_d_attribute2 VARCHAR2(100) -- Changed for bug 2977490
87 , lot_d_attribute3 VARCHAR2(100) -- Changed for bug 2977490
88 , lot_d_attribute4 VARCHAR2(100) -- Changed for bug 2977490
89 , lot_d_attribute5 VARCHAR2(100) -- Changed for bug 2977490
90 , lot_d_attribute6 VARCHAR2(100) -- Changed for bug 2977490
91 , lot_d_attribute7 VARCHAR2(100) -- Changed for bug 2977490
92 , lot_d_attribute8 VARCHAR2(100) -- Changed for bug 2977490
93 , lot_d_attribute9 VARCHAR2(100) -- Changed for bug 2977490
94 , lot_d_attribute10 VARCHAR2(100) -- Changed for bug 2977490
95 , lot_n_attribute1 NUMBER
96 , lot_n_attribute2 NUMBER
97 , lot_n_attribute3 NUMBER
98 , lot_n_attribute4 NUMBER
99 , lot_n_attribute5 NUMBER
100 , lot_n_attribute6 NUMBER
101 , lot_n_attribute7 NUMBER
102 , lot_n_attribute8 NUMBER
103 , lot_n_attribute9 NUMBER
104 , lot_n_attribute10 NUMBER
105 , lot_country_of_origin VARCHAR2(30)
106 , lot_grade_code VARCHAR2(150)
107 , lot_origination_date VARCHAR2(100) -- Changed for bug 2977490
108 , lot_date_code VARCHAR2(150)
109 , lot_change_date VARCHAR2(100) -- Changed for bug 2977490
110 , lot_age NUMBER
111 , lot_retest_date VARCHAR2(100) -- Changed for bug 2977490
112 , lot_maturity_date VARCHAR2(100) -- Changed for bug 2977490
113 , lot_item_size NUMBER
114 , lot_color VARCHAR2(150)
115 , lot_volume NUMBER
116 , lot_volume_uom VARCHAR2(3)
117 , lot_place_of_origin VARCHAR2(150)
118 , lot_best_by_date VARCHAR2(100) -- Changed for bug 2977490
119 , lot_length NUMBER
120 , lot_length_uom VARCHAR2(3)
121 , lot_recycled_cont NUMBER
122 , lot_thickness NUMBER
123 , lot_thickness_uom VARCHAR2(3)
124 , lot_width NUMBER
125 , lot_width_uom VARCHAR2(3)
126 , lot_curl VARCHAR2(150)
127 , lot_vendor VARCHAR2(240)
128 , lot_number_status VARCHAR2(80)
129 , parent_lot_number VARCHAR2(80) -- incovn changes start
130 , expiration_action_date DATE
131 , origination_type NUMBER(2)
132 , hold_date DATE
133 , expiration_action_code VARCHAR2(32)
134 , supplier_lot_number VARCHAR2(150) -- incovn changes start
135 );
136
137
138 -- Record type to hold LPN information for RCV flows : J-DEV
139 TYPE rcv_label_type_rec is RECORD
140 (
141 lpn_id NUMBER
142 , purchase_order VARCHAR2(20)
143 , subinventory VARCHAR2(30)
144 , locator_id NUMBER
145 , receipt_num VARCHAR2(30)
146 , po_line_num NUMBER
147 , quantity_ordered NUMBER
148 , supplier_part_number VARCHAR2(25)
149 , vendor_id NUMBER
150 , supplier_name VARCHAR2(240)
151 , vendor_site_id NUMBER
152 , supplier_site VARCHAR2(15)
153 , requestor VARCHAR2(240)
154 , deliver_to_location VARCHAR2(60)
155 , location VARCHAR2(60)
156 , note_to_receiver VARCHAR2(480)
157 -- Following fields for iSP
158 , due_date DATE
159 , truck_num VARCHAR2(35)
160 , country_of_origin VARCHAR2(2)
161 , comments VARCHAR2(240)
162 -- Added for Bug 3581021 by joabraha
163 , item_id NUMBER
164 --
165 , packing_slip VARCHAR2(25)
166 );
167
168 -- Table to hold information for a group of LPNs
169 TYPE rcv_label_tbl_type IS TABLE OF rcv_label_type_rec INDEX BY BINARY_INTEGER;
170
171 -- Record type to hold LPN information specific to iSupplierPortal
172 TYPE rcv_isp_header_rec is RECORD
173 (
174 asn_num VARCHAR2(30),
175 shipment_date DATE,
176 expected_receipt_date DATE,
177 freight_terms VARCHAR2(25),
178 freight_carrier VARCHAR2(25),
179 num_of_containers NUMBER,
180 bill_of_lading VARCHAR2(25),
181 waybill_airbill_num VARCHAR2(20),
182 packing_slip VARCHAR2(25),
183 packaging_code VARCHAR2(5),
184 special_handling_code VARCHAR2(3),
185 locator_id NUMBER,
186 receipt_num VARCHAR2(30),
187 comments VARCHAR2(240)
188 );
189
190
191
192 PROCEDURE get_variable_data(
193 x_variable_content OUT NOCOPY LONG
194 , x_msg_count OUT NOCOPY NUMBER
195 , x_msg_data OUT NOCOPY VARCHAR2
196 , x_return_status OUT NOCOPY VARCHAR2
197 , p_label_type_info IN INV_LABEL.label_type_rec DEFAULT NULL
198 , p_transaction_id IN NUMBER DEFAULT NULL
199 , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE DEFAULT NULL
200 , p_lpn_id IN NUMBER DEFAULT NULL
201 ,p_transaction_identifier IN NUMBER DEFAULT 0);
202
203 PROCEDURE get_variable_data(
204 x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type
205 , x_msg_count OUT NOCOPY NUMBER
206 , x_msg_data OUT NOCOPY VARCHAR2
207 , x_return_status OUT NOCOPY VARCHAR2
208 , p_label_type_info IN INV_LABEL.label_type_rec DEFAULT NULL
209 , p_transaction_id IN NUMBER DEFAULT NULL
210 , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE DEFAULT NULL
211 , p_lpn_id IN NUMBER DEFAULT NULL
212 ,p_transaction_identifier IN NUMBER DEFAULT 0);
213
214 FUNCTION get_variable_name(p_column_name IN VARCHAR2,
215 p_row_index IN NUMBER, p_format_id IN NUMBER) RETURN VARCHAR2;
216
217 ---------------------------------------------------------------------------------------------
218 -- Project: 'Custom Labels' (A 11i10+ Project) |
219 -- Author: Dinesh ([email protected]) |
220 -- Change Description: |
221 -- This function get_sql_for_variable() is newly added for the Custom Labels project to |
222 -- fetch the SQL statement from the PL/SQL table. |
223 ---------------------------------------------------------------------------------------------
224 FUNCTION get_sql_for_variable(p_column_name IN VARCHAR2,
225 p_row_index IN NUMBER, p_format_id IN NUMBER) RETURN VARCHAR2;
226
227 END INV_LABEL_PVT5;