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