APPS.LOT_SPLIT_DATA_INSERT dependencies on DUAL

Line 707: l_msg_data := 'select header_id from dual';

703: INV_TRX_UTIL_PUB.trace('in insert_mmtt',g_pkg_name,9);
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;

Line 710: FROM DUAL;

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:
713: l_msg_data := 'select batch_id from dual';
714: SELECT mtl_material_transactions_s.NEXTVAL

Line 713: l_msg_data := 'select batch_id from dual';

709: INTO l_header_id
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:

Line 716: FROM DUAL;

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';
719:
720: BEGIN

Line 832: FROM DUAL;

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;
835: tab_input(ind).transaction_header_id := l_header_id;
836: tab_input(ind).transaction_batch_id := l_batch_id;

Line 960: FROM DUAL;

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:
963: END LOOP;
964:

Line 970: FROM DUAL;

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;
973:
974: IF ( p_transaction_type_id = inv_globals.G_type_inv_lot_split OR p_transaction_type_id = inv_globals.G_type_inv_lot_translate)