[Home] [Help]
PACKAGE: APPS.LOT_SPLIT_DATA_INSERT
Source
1 PACKAGE lot_split_data_insert AUTHID CURRENT_USER AS
2 /* $Header: INVLSPLS.pls 120.0 2005/05/25 05:31:08 appldev noship $ */
3 TYPE inputrec IS RECORD (
4 transaction_type_id MTL_TRANSACTION_TYPES.transaction_type_id%TYPE,
5 transaction_lot VARCHAR2(1),
6 inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
7 revision MTL_ITEM_REVISIONS.revision%TYPE,
8 organization_id MTL_PARAMETERS.organization_id%TYPE,
9 subinventory_code MTL_SECONDARY_INVENTORIES.secondary_inventory_name%TYPE,
10 locator_id MTL_ITEM_LOCATIONS.inventory_location_id%TYPE,
11 transaction_quantity MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
12 secondary_transaction_quantity MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE, -- Bug #4093379 INVCONV
13 primary_quantity MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,
14 transaction_uom MTL_UNITS_OF_MEASURE.uom_code%TYPE,
15 item_description MTL_SYSTEM_ITEMS_KFV.description%TYPE,
16 item_location_control_code MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
17 item_restrict_subinv_code MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
18 item_restrict_locators_code MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
19 item_revision_qty_control_code MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
20 item_primary_uom_code MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
21 item_secondary_uom_code MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE, -- Bug #4093379 INVCONV
22 item_shelf_life_code MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
23 item_shelf_life_days MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
24 allowed_units_lookup_code MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
25 lot_number MTL_LOT_NUMBERS.lot_number%TYPE,
26 parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE, -- Bug #4093379 INVCONV
27 origination_type MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE, -- Bug #4093379 INVCONV
28 lot_expiration_date MTL_LOT_NUMBERS.expiration_date%TYPE,
29 expiration_action_date MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE, -- Bug #4093379 INVCONV
30 expiration_action_code MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE, -- Bug #4093379 INVCONV
31 hold_date MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE, -- Bug #4093379 INVCONV
32 reason_id MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE, -- Bug #4093379 INVCONV
33 lpn_id WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
34 lpn_number WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,
35 xfr_lpn_id WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
36 cost_group_id MTL_MATERIAL_TRANSACTIONS_TEMP.cost_group_id%TYPE,
37 project_id NUMBER,
38 task_id NUMBER,
39 transaction_temp_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_temp_id%TYPE,
40 transaction_header_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_header_id%TYPE,
41 transaction_batch_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_id%TYPE,
42 transaction_batch_seq MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_seq%TYPE,
43 description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
44 vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
45 supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
46 territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
47 grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
48 origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
49 date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
50 status_id MTL_LOT_NUMBERS.STATUS_ID%TYPE,
51 change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
52 age MTL_LOT_NUMBERS.AGE%TYPE,
53 retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
54 maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
55 lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
56 item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
57 color MTL_LOT_NUMBERS.COLOR%TYPE,
58 volume MTL_LOT_NUMBERS.VOLUME%TYPE,
59 volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
60 place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
61 best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
62 length MTL_LOT_NUMBERS.LENGTH%TYPE,
63 length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
64 recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
65 thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
66 thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
67 width MTL_LOT_NUMBERS.WIDTH%TYPE,
68 width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
69 curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
70 c_attribute1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
71 c_attribute2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
72 c_attribute3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
73 c_attribute4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
74 c_attribute5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
75 c_attribute6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
76 c_attribute7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
77 c_attribute8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
78 c_attribute9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
79 c_attribute10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
80 c_attribute11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
81 c_attribute12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
82 c_attribute13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
83 c_attribute14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
84 c_attribute15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
85 c_attribute16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
86 c_attribute17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
87 c_attribute18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
88 c_attribute19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
89 c_attribute20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
90 d_attribute1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
91 d_attribute2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
92 d_attribute3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
93 d_attribute4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
94 d_attribute5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
95 d_attribute6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
96 d_attribute7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
97 d_attribute8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
98 d_attribute9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
99 d_attribute10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
100 n_attribute1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
101 n_attribute2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
102 n_attribute3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
103 n_attribute4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
104 n_attribute5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
105 n_attribute6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
106 n_attribute7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
107 n_attribute8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
108 n_attribute9 MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
109 n_attribute10 MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE
110 );
111 TYPE input_table IS TABLE OF inputrec
112 INDEX BY BINARY_INTEGER;
113 tab_index INTEGER ;
114 tab_input input_table;
115
116 /* In case of Lot split transaction
117 1st record will be the starting lot record
118 for 1 start lot insert into mmtt , mtlt
119 for each mmtt create an mmt record
120 for each mtlt create an mtln record
121 and rest of the records will be the resulting lot record
122 for each result lot insert into mmtt , mtlt
123 for each mmtt create an mmt record and populate transfer_transaction_id = start lot's id
124 for each mtlt create an mtln record and
125 create an mln record
126 Lot Merge transaction
127 The last record will be the resulting lot record
128 and all others will be the starting lot records
129 */
130 --
131 PROCEDURE set_table (
132 p_transaction_type_id IN MTL_TRANSACTION_TYPES.transaction_type_id%TYPE,
133 p_transaction_lot IN VARCHAR2,
134 p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
135 p_revision IN MTL_ITEM_REVISIONS.revision%TYPE,
136 p_organization_id IN MTL_PARAMETERS.organization_id%TYPE,
137 p_subinventory_code IN MTL_SECONDARY_INVENTORIES.secondary_inventory_name%TYPE,
138 p_locator_id IN MTL_ITEM_LOCATIONS.inventory_location_id%TYPE,
139 p_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
140 p_primary_quantity IN MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,
141 p_transaction_uom IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
142 p_item_description IN MTL_SYSTEM_ITEMS_KFV.description%TYPE,
143 p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
144 p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
145 p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
146 p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
147 p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
148 p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
149 p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
150 p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
151 p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,
152 p_lot_expiration_date IN MTL_LOT_NUMBERS.expiration_date%TYPE,
153 p_total_qty IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
154 p_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
155 p_lpn_number IN WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,
156 p_xfr_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
157 p_userid IN NUMBER,
158 p_costgroup_id IN WMS_LPN_CONTENTS.cost_group_id%TYPE,
159 p_project_id IN NUMBER,
160 p_task_id IN NUMBER,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_header_id OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 p_description IN MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
166 p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
167 p_supplier_lot_number IN MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
168 p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
169 p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
170 p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
171 p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
172 p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
173 p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
174 p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
175 p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
176 p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
177 p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
178 p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
179 p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
180 p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
181 p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
182 p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
183 p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
184 p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
185 p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
186 p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
187 p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
188 p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
189 p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
190 p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
191 p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
192 p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
193 p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
194 p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
195 p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
196 p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
197 p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
198 p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
199 p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
200 p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
201 p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
202 p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
203 p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
204 p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
205 p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
206 p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
207 p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
208 p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
209 p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
210 p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
211 p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
212 p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
213 p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
214 p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
215 p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
216 p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
217 p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
218 p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
222 p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
219 p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
220 p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
221 p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
223 p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
224 p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
225 p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
226 p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
227 p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
228 p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
229 p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
230 p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
231 p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
232 p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
233 p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
234 p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
235 p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
236 p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
240 );
237 p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
238 p_hold_date IN MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
239 p_reason_id IN MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE DEFAULT NULL -- Bug #4093379 INVCONV
241 --
242 PROCEDURE insert_mmtt(p_total_qty IN NUMBER,
243 p_transaction_type_id IN NUMBER,
244 p_userid IN NUMBER,
245 x_return_status OUT NOCOPY VARCHAR2);
246 --
247 /* This procedure is called from the lotsplitmergepage (parent page) to get the initial values */
248 PROCEDURE select_init_parameters(
249 p_organization_id IN MTL_ORGANIZATIONS.organization_id%TYPE,
250 x_stock_locator_code OUT NOCOPY MTL_parameters.stock_locator_control_code%TYPE,
251 x_wmsinstall OUT NOCOPY VARCHAR2,
252 x_wmsorg OUT NOCOPY VARCHAR2,
253 x_split_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,
254 x_merge_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,
255 x_translate_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,
256 x_cost_group_id OUT NOCOPY CST_COST_GROUPS.cost_group_id%TYPE,
257 x_primary_cost_method OUT NOCOPY MTL_PARAMETERS.primary_cost_method%TYPE,
258 x_wsm_enabled_flag OUT NOCOPY VARCHAR2,
259 x_return_status OUT NOCOPY VARCHAR2,
260 x_msg_data OUT NOCOPY VARCHAR2,
261 x_msg_count OUT NOCOPY NUMBER,
262 x_dist_account_id OUT NOCOPY mtl_parameters.distribution_account_id%TYPE
263 );
264 END lot_split_data_insert;