APPS.ENG_CHANGE_IMPORT_UTIL dependencies on EGO_IMPORT_BATCH_CHANGES

Line 5228: from EGO_IMPORT_BATCH_CHANGES

5224:
5225: CURSOR check_existence_c (c_batch_id NUMBER, c_change_id NUMBER)
5226: IS
5227: select 'N'
5228: from EGO_IMPORT_BATCH_CHANGES
5229: where BATCH_ID = c_batch_id
5230: and CHANGE_ID = c_change_id
5231: ;
5232:

Line 5405: cursor C is select ROWID from EGO_IMPORT_BATCH_CHANGES

5401: X_LAST_UPDATED_BY in NUMBER,
5402: X_LAST_UPDATE_LOGIN in NUMBER
5403: ) is
5404:
5405: cursor C is select ROWID from EGO_IMPORT_BATCH_CHANGES
5406: where BATCH_ID = X_BATCH_ID
5407: and CHANGE_ID = X_CHANGE_ID
5408: ;
5409:

Line 5412: insert into EGO_IMPORT_BATCH_CHANGES (

5408: ;
5409:
5410: begin
5411:
5412: insert into EGO_IMPORT_BATCH_CHANGES (
5413: BATCH_ID,
5414: CHANGE_ID,
5415: OBJECT_VERSION_NUMBER,
5416: CREATION_DATE,

Line 5451: from EGO_IMPORT_BATCH_CHANGES

5447: ) is
5448:
5449: cursor c is select
5450: -- OBJECT_VERSION_NUMBER
5451: from EGO_IMPORT_BATCH_CHANGES
5452: where OBJECT_ID = X_BATCH_ID
5453: and CHANGE_ID = X_CHANGE_ID
5454: for update of OBJECT_ID nowait;
5455: recinfo c%rowtype;

Line 5490: update EGO_IMPORT_BATCH_CHANGES

5486: X_LAST_UPDATE_LOGIN in NUMBER
5487: ) is
5488:
5489: begin
5490: update EGO_IMPORT_BATCH_CHANGES
5491: set -- XXXX
5492: where OBJECT_ID = X_BATCH_ID
5493: and CHANGE_ID = X_CHANGE_ID ;
5494:

Line 5509: delete from EGO_IMPORT_BATCH_CHANGES

5505: X_CHANGE_ID in NUMBER
5506: ) is
5507: begin
5508:
5509: delete from EGO_IMPORT_BATCH_CHANGES
5510: where BATCH_ID = X_BATCH_ID
5511: and CHANGE_ID = X_CHANGE_ID ;
5512:
5513: if (sql%notfound) then