APPS.LOT_SPLIT_DATA_INSERT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 109: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

105: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
106: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
107: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
108: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
109: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
110: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
111: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
112: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
113: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

Line 708: SELECT mtl_material_transactions_s.NEXTVAL

704: END IF;
705: x_return_status := FND_API.G_RET_STS_SUCCESS;
706:
707: l_msg_data := 'select header_id from dual';
708: SELECT mtl_material_transactions_s.NEXTVAL
709: INTO l_header_id
710: FROM DUAL;
711: g_header_id := l_header_id;
712:

Line 714: SELECT mtl_material_transactions_s.NEXTVAL

710: FROM DUAL;
711: g_header_id := l_header_id;
712:
713: l_msg_data := 'select batch_id from dual';
714: SELECT mtl_material_transactions_s.NEXTVAL
715: INTO l_batch_id
716: FROM DUAL;
717:
718: l_msg_data := 'select acct_period_id from org_acct_periods';

Line 830: SELECT mtl_material_transactions_s.NEXTVAL

826: l_msg_data := 'FOR ind IN 1..tab_index';
827: FOR ind IN 1..tab_index
828: LOOP
829: l_msg_data := 'Next temp_id ';
830: SELECT mtl_material_transactions_s.NEXTVAL
831: INTO l_temp_id
832: FROM DUAL;
833:
834: tab_input(ind).transaction_temp_id := l_temp_id;

Line 958: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

954: END IF;
955:
956: IF (p_transaction_type_id = inv_globals.G_type_inv_lot_translate OR
957: p_transaction_type_id = inv_globals.G_type_inv_lot_split) THEN
958: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
959: INTO tab_input(ind).transaction_batch_seq
960: FROM DUAL;
961: END IF;
962:

Line 968: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

964:
965: IF ( p_transaction_type_id = inv_globals.G_type_inv_lot_merge) THEN
966: FOR ind IN REVERSE 1..tab_index
967: LOOP
968: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
969: INTO tab_input(ind).transaction_batch_seq
970: FROM DUAL;
971: END LOOP;
972: END IF;