19: , x_msg_data OUT NOCOPY VARCHAR2
20: , x_return_status OUT NOCOPY VARCHAR2
21: , p_label_type_info IN inv_label.label_type_rec
22: , p_transaction_id IN NUMBER
23: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
24: , p_transaction_identifier IN NUMBER
25: ) IS
26:
27:
86: l_lot_quantity NUMBER;
87: l_quantity2 NUMBER;
88: l_lot_quantity2 NUMBER;
89:
90: l_revision mtl_material_transactions.revision%TYPE;
91: l_inventory_item_id NUMBER;
92: l_item_description VARCHAR2(240) := NULL;
93: l_organization_id NUMBER;
94: l_lot_number VARCHAR2(80);
229: FROM gme_batch_header_vw bh,
230: mtl_parameters mp,
231: gme_material_details bl,
232: mtl_system_items_vl msi,
233: mtl_material_transactions mmt,
234: mtl_transaction_lot_numbers mtln,
235: mtl_item_locations_kfv milk,
236: mtl_transaction_reasons mtr,
237: po_hazard_classes hzc
1226: , x_msg_data OUT NOCOPY VARCHAR2
1227: , x_return_status OUT NOCOPY VARCHAR2
1228: , p_label_type_info IN inv_label.label_type_rec
1229: , p_transaction_id IN NUMBER
1230: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
1231: , p_transaction_identifier IN NUMBER
1232: ) IS
1233: l_variable_data_tbl inv_label.label_tbl_type;
1234: BEGIN