APPS.EAM_ASSET_MOVE_PUB dependencies on DUAL

Line 123: INTO l_header_id FROM sys.dual;

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,
127: 'Going to populate the temp ');

Line 300: FROM dual;

296: EXCEPTION
297: WHEN NO_DATA_FOUND THEN
298: SELECT 0
299: INTO l_parent_object_id
300: FROM dual;
301:
302: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
303: 'Exception while searching for parent object id' );
304: END IF;

Line 496: SELECT 'U' INTO l_parent_status 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 'U' INTO l_parent_status 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 status');
499: END IF;
500: END;

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

505: FROM EAM_ASSET_MOVE_TEMP
506: WHERE gen_object_id=l_parent_object_id;
507: EXCEPTION
508: WHEN NO_DATA_FOUND THEN
509: SELECT 'Unknown' INTO l_parent_msg FROM dual;
510: IF (l_slog) then
511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'No_data_found exception occured when checking for parent message');
512: END IF;
513: END;

Line 765: FROM dual;

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,
768: l_transaction_batch_id,
769: l_serial_number,

Line 805: FROM dual;

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
808: SELECT inventory_item_id INTO l_inventory_item_id
809: FROM csi_item_instances

Line 824: FROM dual;

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:
827:
828: -- insert into MTI, MSNI

Line 1348: FROM sys.dual;

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
1351: (transaction_header_id,
1352: source_code,

Line 1496: FROM sys.dual;

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: */
1499:
1500: