APPS.EAM_ASSET_MOVE_PUB dependencies on DUAL

Line 117: INTO l_header_id FROM sys.dual;

113: END LOOP;
114:
115: -- Generate an Header id from the sequence
116: SELECT APPS.mtl_material_transactions_s.NEXTVAL
117: INTO l_header_id FROM sys.dual;
118:
119: if (l_slog) then
120: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
121: 'Going to populate the temp ');

Line 287: FROM dual;

283: EXCEPTION
284: WHEN NO_DATA_FOUND THEN
285: SELECT 0
286: INTO l_parent_object_id
287: FROM dual;
288:
289: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
290: 'Exception while searching for parent object id' );
291: END IF;

Line 483: SELECT 'U' INTO l_parent_status FROM dual;

479: FROM EAM_ASSET_MOVE_TEMP
480: WHERE gen_object_id=l_parent_object_id;
481: EXCEPTION
482: WHEN NO_DATA_FOUND THEN
483: SELECT 'U' INTO l_parent_status FROM dual;
484: IF (l_slog) then
485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'No_data_found exception occured when checking for parent status');
486: END IF;
487: END;

Line 496: SELECT 'Unknown' INTO l_parent_msg FROM dual;

492: FROM EAM_ASSET_MOVE_TEMP
493: WHERE gen_object_id=l_parent_object_id;
494: EXCEPTION
495: WHEN NO_DATA_FOUND THEN
496: SELECT 'Unknown' INTO l_parent_msg FROM dual;
497: IF (l_slog) then
498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'No_data_found exception occured when checking for parent message');
499: END IF;
500: END;

Line 751: FROM dual;

747: IF(validAssets_rec.prepare_status='MR') then --Call For Misc Receipt for 7370638
748: --for 7370638
749: SELECT mtl_material_transactions_s.nextval
750: INTO l_transaction_batch_id
751: FROM dual;
752:
753: addAssetsForMiscReceipt(p_header_id,
754: l_transaction_batch_id,
755: l_serial_number,

Line 787: FROM dual;

783: END;
784: -- SELECT INVENTORY_REVISION INTO l_Item_Revision FROM CSI_ITEM_INSTANCES WHERE INVENTORY_ITEM_ID=p_inventory_item_id ;
785: SELECT mtl_material_transactions_s.nextval
786: INTO l_temp_header_id
787: FROM dual;
788: --dbms_output.put_line('l_serial_number_control_code IS'||' '||l_serial_number_control_code);
789: Begin
790: SELECT inventory_item_id INTO l_inventory_item_id
791: FROM csi_item_instances

Line 806: FROM dual;

802: WHERE CURRENT OF validAssets_cur;
803: IF(l_serial_number_control_code <> 1) THEN
804: SELECT mtl_material_transactions_s.nextval
805: INTO INV_TRANSACTIONS.G_Serial_ID
806: FROM dual;
807: END IF;
808:
809:
810: -- insert into MTI, MSNI

Line 1208: FROM sys.dual;

1204: AND PERIOD_START_DATE <= l_sysdate ;
1205:
1206: SELECT APPS.mtl_material_transactions_s.NEXTVAL
1207: INTO l_txn_if_id
1208: FROM sys.dual;
1209:
1210: INSERT INTO mtl_transactions_interface
1211: (transaction_header_id,
1212: source_code,