eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on EGO_IMPORT_BATCH_CHANGES

Line 5334: from EGO_IMPORT_BATCH_CHANGES

5330:
5331: CURSOR check_existence_c (c_batch_id NUMBER, c_change_id NUMBER)
5332: IS
5333: select 'N'
5334: from EGO_IMPORT_BATCH_CHANGES
5335: where BATCH_ID = c_batch_id
5336: and CHANGE_ID = c_change_id
5337: ;
5338:

Line 5536: cursor C is select ROWID from EGO_IMPORT_BATCH_CHANGES

5532: X_LAST_UPDATED_BY in NUMBER,
5533: X_LAST_UPDATE_LOGIN in NUMBER
5534: ) is
5535:
5536: cursor C is select ROWID from EGO_IMPORT_BATCH_CHANGES
5537: where BATCH_ID = X_BATCH_ID
5538: and CHANGE_ID = X_CHANGE_ID
5539: ;
5540:

Line 5543: insert into EGO_IMPORT_BATCH_CHANGES (

5539: ;
5540:
5541: begin
5542:
5543: insert into EGO_IMPORT_BATCH_CHANGES (
5544: BATCH_ID,
5545: CHANGE_ID,
5546: OBJECT_VERSION_NUMBER,
5547: CREATION_DATE,

Line 5582: from EGO_IMPORT_BATCH_CHANGES

5578: ) is
5579:
5580: cursor c is select
5581: -- OBJECT_VERSION_NUMBER
5582: from EGO_IMPORT_BATCH_CHANGES
5583: where OBJECT_ID = X_BATCH_ID
5584: and CHANGE_ID = X_CHANGE_ID
5585: for update of OBJECT_ID nowait;
5586: recinfo c%rowtype;

Line 5621: update EGO_IMPORT_BATCH_CHANGES

5617: X_LAST_UPDATE_LOGIN in NUMBER
5618: ) is
5619:
5620: begin
5621: update EGO_IMPORT_BATCH_CHANGES
5622: set -- XXXX
5623: where OBJECT_ID = X_BATCH_ID
5624: and CHANGE_ID = X_CHANGE_ID ;
5625:

Line 5640: delete from EGO_IMPORT_BATCH_CHANGES

5636: X_CHANGE_ID in NUMBER
5637: ) is
5638: begin
5639:
5640: delete from EGO_IMPORT_BATCH_CHANGES
5641: where BATCH_ID = X_BATCH_ID
5642: and CHANGE_ID = X_CHANGE_ID ;
5643:
5644: if (sql%notfound) then