APPS.EGO_IMPORT_BATCHES_PKG dependencies on EGO_IMPORT_BATCHES_TL

Line 53: INSERT into EGO_IMPORT_BATCHES_TL (

49: X_LAST_UPDATED_BY,
50: X_LAST_UPDATE_LOGIN
51: );
52:
53: INSERT into EGO_IMPORT_BATCHES_TL (
54: BATCH_ID,
55: NAME,
56: DESCRIPTION,
57: OBJECT_VERSION_NUMBER,

Line 81: FROM EGO_IMPORT_BATCHES_TL T

77: FROM FND_LANGUAGES L
78: WHERE L.INSTALLED_FLAG IN ('I', 'B')
79: AND NOT EXISTS
80: (SELECT NULL
81: FROM EGO_IMPORT_BATCHES_TL T
82: WHERE T.BATCH_ID = X_BATCH_ID
83: AND T.LANGUAGE = L.LANGUAGE_CODE);
84:
85: OPEN C;

Line 124: FROM EGO_IMPORT_BATCHES_TL

120: SELECT
121: NAME,
122: DESCRIPTION,
123: DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
124: FROM EGO_IMPORT_BATCHES_TL
125: WHERE BATCH_ID = X_BATCH_ID
126: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
127: FOR UPDATE OF BATCH_ID NOWAIT;
128: BEGIN

Line 198: UPDATE EGO_IMPORT_BATCHES_TL SET

194: IF (SQL%NOTFOUND) THEN
195: RAISE NO_DATA_FOUND;
196: END IF;
197:
198: UPDATE EGO_IMPORT_BATCHES_TL SET
199: NAME = X_NAME,
200: DESCRIPTION = X_DESCRIPTION,
201: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
202: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 217: DELETE FROM EGO_IMPORT_BATCHES_TL

213: PROCEDURE DELETE_ROW (
214: X_BATCH_ID IN NUMBER
215: ) IS
216: BEGIN
217: DELETE FROM EGO_IMPORT_BATCHES_TL
218: WHERE BATCH_ID = X_BATCH_ID;
219:
220: IF (SQL%NOTFOUND) THEN
221: RAISE NO_DATA_FOUND;

Line 236: DELETE FROM EGO_IMPORT_BATCHES_TL T

232:
233: PROCEDURE ADD_LANGUAGE
234: IS
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

Line 243: UPDATE EGO_IMPORT_BATCHES_TL T SET (

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 (
244: NAME,
245: DESCRIPTION
246: ) = (SELECT
247: B.NAME,

Line 249: FROM EGO_IMPORT_BATCHES_TL B

245: DESCRIPTION
246: ) = (SELECT
247: B.NAME,
248: B.DESCRIPTION
249: FROM EGO_IMPORT_BATCHES_TL B
250: WHERE B.BATCH_ID = T.BATCH_ID
251: AND B.LANGUAGE = T.SOURCE_LANG)
252: WHERE (
253: T.BATCH_ID,

Line 258: FROM EGO_IMPORT_BATCHES_TL SUBB, EGO_IMPORT_BATCHES_TL SUBT

254: T.LANGUAGE
255: ) IN (SELECT
256: SUBT.BATCH_ID,
257: SUBT.LANGUAGE
258: FROM EGO_IMPORT_BATCHES_TL SUBB, EGO_IMPORT_BATCHES_TL SUBT
259: WHERE SUBB.BATCH_ID = SUBT.BATCH_ID
260: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
261: AND (SUBB.NAME <> SUBT.NAME
262: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 267: INSERT INTO EGO_IMPORT_BATCHES_TL (

263: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
264: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
265: ));
266:
267: INSERT INTO EGO_IMPORT_BATCHES_TL (
268: BATCH_ID,
269: NAME,
270: DESCRIPTION,
271: OBJECT_VERSION_NUMBER,

Line 291: FROM EGO_IMPORT_BATCHES_TL B, FND_LANGUAGES L

287: B.LAST_UPDATE_DATE,
288: B.LAST_UPDATE_LOGIN,
289: L.LANGUAGE_CODE,
290: B.SOURCE_LANG
291: FROM EGO_IMPORT_BATCHES_TL B, FND_LANGUAGES L
292: WHERE L.INSTALLED_FLAG IN ('I', 'B')
293: AND B.LANGUAGE = USERENV('LANG')
294: AND NOT EXISTS
295: (SELECT NULL

Line 296: FROM EGO_IMPORT_BATCHES_TL T

292: WHERE L.INSTALLED_FLAG IN ('I', 'B')
293: AND B.LANGUAGE = USERENV('LANG')
294: AND NOT EXISTS
295: (SELECT NULL
296: FROM EGO_IMPORT_BATCHES_TL T
297: WHERE T.BATCH_ID = B.BATCH_ID
298: AND T.LANGUAGE = L.LANGUAGE_CODE);
299: END ADD_LANGUAGE;
300:

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: