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 (

Line 602: --l_tmp_import_batch_rec EGO_IMPORT_BATCHES_B%ROWTYPE;

598:
599: l_nir_option VARCHAR2(1) := p_nir_option;
600: l_enabled_for_data_pool VARCHAR2(1) := p_enabled_for_data_pool;
601:
602: --l_tmp_import_batch_rec EGO_IMPORT_BATCHES_B%ROWTYPE;
603: l_tmp_batch_type_name VARCHAR2(30);
604: l_tmp_ssm_options_rec EGO_IMPORT_OPTION_SETS%ROWTYPE;
605: l_def_match_rule_rec Ego_Def_Match_Rule_Csr%ROWTYPE;
606:

Line 1097: FROM EGO_IMPORT_BATCHES_B B, EGO_IMPORT_BATCHES_TL TL

1093: x_return_status OUT NOCOPY VARCHAR2,
1094: x_error_msg OUT NOCOPY VARCHAR2) IS
1095: Cursor Ego_Import_Batch_Csr(v_batch_id NUMBER) IS
1096: SELECT B.BATCH_ID, TL.NAME
1097: FROM EGO_IMPORT_BATCHES_B B, EGO_IMPORT_BATCHES_TL TL
1098: WHERE B.BATCH_ID = TL.BATCH_ID
1099: AND B.BATCH_ID = v_batch_id
1100: AND TL.LANGUAGE = USERENV('LANG');
1101:

Line 1142: --Update table EGO_IMPORT_BATCHES_B

1138: RAISE INVALID_BATCH_STATUS;
1139: END IF;
1140: CLOSE Ego_Batch_Status_Csr;
1141:
1142: --Update table EGO_IMPORT_BATCHES_B
1143: UPDATE EGO_IMPORT_BATCHES_B
1144: SET BATCH_STATUS = p_batch_status
1145: WHERE BATCH_ID = p_batch_id;
1146:

Line 1143: UPDATE EGO_IMPORT_BATCHES_B

1139: END IF;
1140: CLOSE Ego_Batch_Status_Csr;
1141:
1142: --Update table EGO_IMPORT_BATCHES_B
1143: UPDATE EGO_IMPORT_BATCHES_B
1144: SET BATCH_STATUS = p_batch_status
1145: WHERE BATCH_ID = p_batch_id;
1146:
1147: EXCEPTION