APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 485: select mtl_material_Transactions_s.nextval

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

Line 2649: select mtl_material_transactions_s.nextval

2645: l_transaction_temp_id,'INV_SPLIT_DELIVERY_LINE');
2646: END IF;
2647:
2648: if( l_transaction_temp_id = l_new_transaction_temp_id) then
2649: select mtl_material_transactions_s.nextval
2650: into l_new_transaction_temp_id
2651: from dual;
2652: if( l_debug = 1 ) then
2653: debug('new transaction_temp_id is ' || l_new_transaction_temp_id, 'split_Delivery');

Line 2816: select mtl_material_transactions_s.nextval

2812: l_transaction_temp_id,'INV_SPLIT_DELIVERY_LINE');
2813: END IF;
2814:
2815: if( l_transaction_temp_id = l_new_transaction_temp_id) then
2816: select mtl_material_transactions_s.nextval
2817: into l_new_transaction_temp_id
2818: from dual;
2819: if( l_debug = 1 ) then
2820: debug('new transaction_temp_id is ' || l_new_transaction_temp_id, 'split_Delivery');