APPS.EGO_IMPORT_BATCHES_PKG dependencies on EGO_IMPORT_BATCHES_B

Line 22: SELECT ROWID FROM EGO_IMPORT_BATCHES_B

18: X_LAST_UPDATED_BY IN NUMBER,
19: X_LAST_UPDATE_LOGIN IN NUMBER)
20: IS
21: CURSOR C IS
22: SELECT ROWID FROM EGO_IMPORT_BATCHES_B
23: WHERE BATCH_ID = X_BATCH_ID;
24: BEGIN
25: INSERT into EGO_IMPORT_BATCHES_B (
26: ORGANIZATION_ID,

Line 25: INSERT into EGO_IMPORT_BATCHES_B (

21: CURSOR C IS
22: SELECT ROWID FROM EGO_IMPORT_BATCHES_B
23: WHERE BATCH_ID = X_BATCH_ID;
24: BEGIN
25: INSERT into EGO_IMPORT_BATCHES_B (
26: ORGANIZATION_ID,
27: BATCH_ID,
28: SOURCE_SYSTEM_ID,
29: BATCH_TYPE,

Line 113: FROM EGO_IMPORT_BATCHES_B

109: BATCH_TYPE,
110: ASSIGNEE,
111: BATCH_STATUS,
112: OBJECT_VERSION_NUMBER
113: FROM EGO_IMPORT_BATCHES_B
114: WHERE BATCH_ID = X_BATCH_ID
115: FOR UPDATE OF BATCH_ID NOWAIT;
116:
117: RECINFO C%ROWTYPE;

Line 182: UPDATE EGO_IMPORT_BATCHES_B SET

178: X_LAST_UPDATED_BY IN NUMBER,
179: X_LAST_UPDATE_LOGIN IN NUMBER
180: ) IS
181: BEGIN
182: UPDATE EGO_IMPORT_BATCHES_B SET
183: ORGANIZATION_ID = X_ORGANIZATION_ID,
184: SOURCE_SYSTEM_ID = X_SOURCE_SYSTEM_ID,
185: BATCH_TYPE = X_BATCH_TYPE,
186: ASSIGNEE = X_ASSIGNEE,

Line 224: DELETE FROM EGO_IMPORT_BATCHES_B

220: IF (SQL%NOTFOUND) THEN
221: RAISE NO_DATA_FOUND;
222: END IF;
223:
224: DELETE FROM EGO_IMPORT_BATCHES_B
225: WHERE BATCH_ID = X_BATCH_ID;
226:
227: IF (SQL%NOTFOUND) THEN
228: RAISE NO_DATA_FOUND;

Line 239: FROM EGO_IMPORT_BATCHES_B B

235: BEGIN
236: DELETE FROM EGO_IMPORT_BATCHES_TL T
237: WHERE NOT EXISTS
238: (SELECT NULL
239: FROM EGO_IMPORT_BATCHES_B B
240: WHERE B.BATCH_ID = T.BATCH_ID
241: );
242:
243: UPDATE EGO_IMPORT_BATCHES_TL T SET (