[Home] [Help]
118: l_counter_for_validation:=l_counter_for_validation+1;
119: END LOOP;
120:
121: -- Generate an Header id from the sequence
122: SELECT APPS.mtl_material_transactions_s.NEXTVAL
123: INTO l_header_id FROM sys.dual;
124:
125: if (l_slog) then
126: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
759: END;
760:
761: IF(validAssets_rec.prepare_status='MR') then --Call For Misc Receipt for 7370638
762: --for 7370638
763: SELECT mtl_material_transactions_s.nextval
764: INTO l_transaction_batch_id
765: FROM dual;
766:
767: addAssetsForMiscReceipt(p_header_id,
799: -- l_Transaction_UOM:='Ea';
800: --Dbms_Output.put_line('ecxeption occured while selecting');
801: END;
802: -- SELECT INVENTORY_REVISION INTO l_Item_Revision FROM CSI_ITEM_INSTANCES WHERE INVENTORY_ITEM_ID=p_inventory_item_id ;
803: SELECT mtl_material_transactions_s.nextval
804: INTO l_temp_header_id
805: FROM dual;
806: --dbms_output.put_line('l_serial_number_control_code IS'||' '||l_serial_number_control_code);
807: Begin
818: UPDATE EAM_ASSET_MOVE_TEMP
819: SET TRANSACTION_INTERFACE_ID = l_temp_header_id
820: WHERE CURRENT OF validAssets_cur;
821: IF(l_serial_number_control_code <> 1) THEN
822: SELECT mtl_material_transactions_s.nextval
823: INTO INV_TRANSACTIONS.G_Serial_ID
824: FROM dual;
825: END IF;
826:
1342: AND ORGANIZATION_ID = l_org_id
1343: AND (SCHEDULE_CLOSE_DATE + 1) > l_sysdate
1344: AND PERIOD_START_DATE <= l_sysdate ;
1345:
1346: SELECT APPS.mtl_material_transactions_s.NEXTVAL
1347: INTO l_txn_if_id
1348: FROM sys.dual;
1349:
1350: INSERT INTO mtl_transactions_interface
1490: AND ORGANIZATION_ID = p_ORGANIZATION_ID
1491: AND (SCHEDULE_CLOSE_DATE + 1) > l_sysdate
1492: AND PERIOD_START_DATE <= l_sysdate ;
1493:
1494: SELECT APPS.mtl_material_transactions_s.NEXTVAL
1495: INTO l_txn_if_id
1496: FROM sys.dual;
1497:
1498: */