APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 486: select mtl_material_Transactions_s.nextval

482: where delivery_detail_id = p_delivery_detail_id;
483:
484: IF ( l_serial_number IS NULL ) THEN
485: IF ( l_transaction_temp_id IS NULL ) THEN
486: select mtl_material_Transactions_s.nextval
487: into l_InvPCInRecType.transaction_temp_id
488: from dual;
489:
490: l_transaction_temp_id := l_InvPCInRecType.transaction_temp_id;

Line 2803: select mtl_material_transactions_s.nextval

2799: l_transaction_temp_id,'INV_SPLIT_DELIVERY_LINE');
2800: END IF;
2801:
2802: if( l_transaction_temp_id = l_new_transaction_temp_id) then
2803: select mtl_material_transactions_s.nextval
2804: into l_new_transaction_temp_id
2805: from dual;
2806: if( l_debug = 1 ) then
2807: debug('new transaction_temp_id is ' || l_new_transaction_temp_id, 'split_Delivery');

Line 2971: select mtl_material_transactions_s.nextval

2967: l_transaction_temp_id,'INV_SPLIT_DELIVERY_LINE');
2968: END IF;
2969:
2970: if( l_transaction_temp_id = l_new_transaction_temp_id) then
2971: select mtl_material_transactions_s.nextval
2972: into l_new_transaction_temp_id
2973: from dual;
2974: if( l_debug = 1 ) then
2975: debug('new transaction_temp_id is ' || l_new_transaction_temp_id, 'split_Delivery');