[Home] [Help]
PACKAGE: APPS.INV_LABEL_PVT4
Source
1 PACKAGE INV_LABEL_PVT4 AS
2 /* $Header: INVLAP4S.pls 120.1.12010000.1 2008/07/24 01:37:42 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 , item_description VARCHAR2(240)
74 , item_attribute_category VARCHAR2(30)
75 , item_attribute1 VARCHAR2(150)
76 , item_attribute2 VARCHAR2(150)
77 , item_attribute3 VARCHAR2(150)
78 , item_attribute4 VARCHAR2(150)
79 , item_attribute5 VARCHAR2(150)
80 , item_attribute6 VARCHAR2(150)
81 , item_attribute7 VARCHAR2(150)
82 , item_attribute8 VARCHAR2(150)
83 , item_attribute9 VARCHAR2(150)
84 , item_attribute10 VARCHAR2(150)
85 , item_attribute11 VARCHAR2(150)
86 , item_attribute12 VARCHAR2(150)
87 , item_attribute13 VARCHAR2(150)
88 , item_attribute14 VARCHAR2(150)
89 , item_attribute15 VARCHAR2(150)
90
91 , lot_expiration_date VARCHAR2(100) -- Changed for bug 2977490
92 , item_hazard_class VARCHAR2(40)
93 , lot_attribute_category VARCHAR2(30)
94 , lot_c_attribute1 VARCHAR2(150)
95 , lot_c_attribute2 VARCHAR2(150)
96 , lot_c_attribute3 VARCHAR2(150)
97 , lot_c_attribute4 VARCHAR2(150)
98 , lot_c_attribute5 VARCHAR2(150)
99 , lot_c_attribute6 VARCHAR2(150)
100 , lot_c_attribute7 VARCHAR2(150)
101 , lot_c_attribute8 VARCHAR2(150)
102 , lot_c_attribute9 VARCHAR2(150)
103 , lot_c_attribute10 VARCHAR2(150)
104 , lot_c_attribute11 VARCHAR2(150)
105 , lot_c_attribute12 VARCHAR2(150)
106 , lot_c_attribute13 VARCHAR2(150)
107 , lot_c_attribute14 VARCHAR2(150)
108 , lot_c_attribute15 VARCHAR2(150)
109 , lot_c_attribute16 VARCHAR2(150)
110 , lot_c_attribute17 VARCHAR2(150)
111 , lot_c_attribute18 VARCHAR2(150)
112 , lot_c_attribute19 VARCHAR2(150)
113 , lot_c_attribute20 VARCHAR2(150)
114 , lot_d_attribute1 VARCHAR2(100) -- Changed for bug 2977490
115 , lot_d_attribute2 VARCHAR2(100) -- Changed for bug 2977490
116 , lot_d_attribute3 VARCHAR2(100) -- Changed for bug 2977490
117 , lot_d_attribute4 VARCHAR2(100) -- Changed for bug 2977490
118 , lot_d_attribute5 VARCHAR2(100) -- Changed for bug 2977490
119 , lot_d_attribute6 VARCHAR2(100) -- Changed for bug 2977490
120 , lot_d_attribute7 VARCHAR2(100) -- Changed for bug 2977490
121 , lot_d_attribute8 VARCHAR2(100) -- Changed for bug 2977490
122 , lot_d_attribute9 VARCHAR2(100) -- Changed for bug 2977490
123 , lot_d_attribute10 VARCHAR2(100) -- Changed for bug 2977490
124 , lot_n_attribute1 NUMBER
125 , lot_n_attribute2 NUMBER
126 , lot_n_attribute3 NUMBER
127 , lot_n_attribute4 NUMBER
128 , lot_n_attribute5 NUMBER
129 , lot_n_attribute6 NUMBER
130 , lot_n_attribute7 NUMBER
131 , lot_n_attribute8 NUMBER
132 , lot_n_attribute9 NUMBER
133 , lot_n_attribute10 NUMBER
134 , lot_country_of_origin VARCHAR2(30)
135 , lot_grade_code VARCHAR2(150)
136 , lot_origination_date VARCHAR2(100) -- Changed for bug 2977490
137 , lot_date_code VARCHAR2(150)
138 , lot_change_date VARCHAR2(100) -- Changed for bug 2977490
139 , lot_age NUMBER
140 , lot_retest_date VARCHAR2(100) -- Changed for bug 2977490
141 , lot_maturity_date VARCHAR2(100) -- Changed for bug 2977490
142 , lot_item_size NUMBER
143 , lot_color VARCHAR2(150)
144 , lot_volume NUMBER
145 , lot_volume_uom VARCHAR2(3)
146 , lot_place_of_origin VARCHAR2(150)
147 , lot_best_by_date VARCHAR2(100) -- Changed for bug 2977490
148 , lot_length NUMBER
149 , lot_length_uom VARCHAR2(3)
150 , lot_recycled_cont NUMBER
151 , lot_thickness NUMBER
152 , lot_thickness_uom VARCHAR2(3)
153 , lot_width NUMBER
154 , lot_width_uom VARCHAR2(3)
155 , lot_curl VARCHAR2(150)
156 , lot_vendor VARCHAR2(240)
157 , lot_number_status VARCHAR2(80)
158 , parent_lot_number VARCHAR2(80) -- invcovn changes start
159 , expiration_action_date DATE
160 , origination_type NUMBER(2)
161 , hold_date DATE
162 , expiration_action_code VARCHAR2(32)
163 , supplier_lot_number VARCHAR2(150) -- invcovn changes start
164 );
165
166 -- Record type to hold LPN information for RCV flows : J-DEV
167 TYPE rcv_label_type_rec is RECORD
168 (
169 lpn_id NUMBER
170 , purchase_order VARCHAR2(20)
171 , subinventory VARCHAR2(30)
172 , locator_id NUMBER
173 , receipt_num VARCHAR2(30)
174 , po_line_num NUMBER
175 , quantity_ordered NUMBER
176 , supplier_part_number VARCHAR2(25)
177 , vendor_id NUMBER
178 , supplier_name VARCHAR2(240)
179 , vendor_site_id NUMBER
180 , supplier_site VARCHAR2(15)
181 , requestor VARCHAR2(240)
182 , deliver_to_location VARCHAR2(60)
183 , location VARCHAR2(60)
184 , note_to_receiver VARCHAR2(480)
185 -- Following fields for iSP
186 , due_date DATE
187 , truck_num VARCHAR2(35)
188 , country_of_origin VARCHAR2(2)
189 , comments VARCHAR2(240)
190 , item_id number
191 , packing_slip VARCHAR2(25)
192 , quantity number
193 );
194
195 -- Table to hold information for a group of LPNs
196 TYPE rcv_label_tbl_type IS TABLE OF rcv_label_type_rec INDEX BY BINARY_INTEGER;
197
198 -- Record type to hold LPN information specific to iSupplierPortal
199 TYPE rcv_isp_header_rec is RECORD
200 (
201 asn_num VARCHAR2(30),
202 shipment_date DATE,
203 expected_receipt_date DATE,
204 freight_terms VARCHAR2(25),
205 freight_carrier VARCHAR2(25),
206 num_of_containers NUMBER,
207 bill_of_lading VARCHAR2(25),
208 waybill_airbill_num VARCHAR2(20),
209 packing_slip VARCHAR2(25),
210 packaging_code VARCHAR2(5),
211 special_handling_code VARCHAR2(3),
212 locator_id NUMBER,
213 receipt_num VARCHAR2(30),
214 comments VARCHAR2(240)
215 );
216
217 END INV_LABEL_PVT4;