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