APPS.CSI_MASS_EDIT_ENTRIES_B_PKG dependencies on CSI_MASS_EDIT_ENTRIES_TL

Line 83: INSERT INTO CSI_MASS_EDIT_ENTRIES_TL(

79: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
80: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
81: decode( p_SYSTEM_CASCADE, FND_API.G_MISS_CHAR, NULL, p_SYSTEM_CASCADE));
82:
83: INSERT INTO CSI_MASS_EDIT_ENTRIES_TL(
84: ENTRY_ID,
85: NAME,
86: DESCRIPTION,
87: LANGUAGE,

Line 108: from CSI_MASS_EDIT_ENTRIES_TL T

104: from FND_LANGUAGES L
105: where L.INSTALLED_FLAG in ('I', 'B')
106: and not exists
107: (select NULL
108: from CSI_MASS_EDIT_ENTRIES_TL T
109: where T.ENTRY_ID = px_ENTRY_ID
110: and T.LANGUAGE = L.LANGUAGE_CODE);
111:
112:

Line 220: update CSI_MASS_EDIT_ENTRIES_TL set

216: If (SQL%NOTFOUND) then
217: RAISE NO_DATA_FOUND;
218: End If;
219:
220: update CSI_MASS_EDIT_ENTRIES_TL set
221: NAME = decode( p_NAME, FND_API.G_MISS_CHAR, NAME, p_NAME),
222: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
223: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
224: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

Line 250: DELETE FROM CSI_MASS_EDIT_ENTRIES_TL

246: If (SQL%NOTFOUND) then
247: RAISE NO_DATA_FOUND;
248: End If;
249:
250: DELETE FROM CSI_MASS_EDIT_ENTRIES_TL
251: WHERE ENTRY_ID = p_ENTRY_ID;
252:
253: If (SQL%NOTFOUND) then
254: RAISE NO_DATA_FOUND;

Line 287: FROM CSI_MASS_EDIT_ENTRIES_TL

283: CURSOR C1 IS
284: SELECT ENTRY_ID,
285: NAME,
286: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
287: FROM CSI_MASS_EDIT_ENTRIES_TL
288: WHERE ENTRY_ID = p_ENTRY_ID
289: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG)
290: FOR UPDATE of ENTRY_ID NOWAIT;
291:

Line 367: DELETE FROM CSI_MASS_EDIT_ENTRIES_TL T

363: PROCEDURE ADD_LANGUAGE
364: IS
365: BEGIN
366: /********* COMMENTED FOR BUG 4238439 (Refer 3723612 for solution)
367: DELETE FROM CSI_MASS_EDIT_ENTRIES_TL T
368: WHERE NOT EXISTS
369: (SELECT NULL
370: FROM CSI_MASS_EDIT_ENTRIES_B B
371: WHERE B.ENTRY_ID = T.ENTRY_ID

Line 374: UPDATE CSI_MASS_EDIT_ENTRIES_TL T SET (

370: FROM CSI_MASS_EDIT_ENTRIES_B B
371: WHERE B.ENTRY_ID = T.ENTRY_ID
372: );
373:
374: UPDATE CSI_MASS_EDIT_ENTRIES_TL T SET (
375: NAME
376: ) = (SELECT
377: B.NAME
378: FROM CSI_MASS_EDIT_ENTRIES_TL B

Line 378: FROM CSI_MASS_EDIT_ENTRIES_TL B

374: UPDATE CSI_MASS_EDIT_ENTRIES_TL T SET (
375: NAME
376: ) = (SELECT
377: B.NAME
378: FROM CSI_MASS_EDIT_ENTRIES_TL B
379: WHERE B.ENTRY_ID = T.ENTRY_ID
380: AND B.LANGUAGE = T.SOURCE_LANG)
381: WHERE (
382: T.ENTRY_ID,

Line 387: FROM CSI_MASS_EDIT_ENTRIES_TL SUBB, CSI_MASS_EDIT_ENTRIES_TL SUBT

383: T.LANGUAGE
384: ) IN (SELECT
385: SUBT.ENTRY_ID,
386: SUBT.LANGUAGE
387: FROM CSI_MASS_EDIT_ENTRIES_TL SUBB, CSI_MASS_EDIT_ENTRIES_TL SUBT
388: WHERE SUBB.ENTRY_ID = SUBT.ENTRY_ID
389: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
390: AND (SUBB.NAME <> SUBT.NAME
391: OR (SUBB.NAME IS NULL AND SUBT.NAME IS NOT NULL)

Line 396: INSERT /*+ append parallel(tt) */ INTO CSI_MASS_EDIT_ENTRIES_TL tt (

392: OR (SUBB.NAME IS NOT NULL AND SUBT.NAME IS NULL)
393: ));
394: ********* END OF COMMENT **********/
395:
396: INSERT /*+ append parallel(tt) */ INTO CSI_MASS_EDIT_ENTRIES_TL tt (
397: ENTRY_ID,
398: NAME,
399: CREATED_BY,
400: CREATION_DATE,

Line 418: FROM CSI_MASS_EDIT_ENTRIES_TL B, FND_LANGUAGES L

414: B.LAST_UPDATE_DATE,
415: B.LAST_UPDATE_LOGIN,
416: L.LANGUAGE_CODE,
417: B.SOURCE_LANG
418: FROM CSI_MASS_EDIT_ENTRIES_TL B, FND_LANGUAGES L
419: WHERE L.INSTALLED_FLAG IN ('I', 'B')
420: AND B.LANGUAGE = userenv('LANG')
421: ) v, CSI_MASS_EDIT_ENTRIES_TL t
422: WHERE t.entry_id(+) = v.entry_id

Line 421: ) v, CSI_MASS_EDIT_ENTRIES_TL t

417: B.SOURCE_LANG
418: FROM CSI_MASS_EDIT_ENTRIES_TL B, FND_LANGUAGES L
419: WHERE L.INSTALLED_FLAG IN ('I', 'B')
420: AND B.LANGUAGE = userenv('LANG')
421: ) v, CSI_MASS_EDIT_ENTRIES_TL t
422: WHERE t.entry_id(+) = v.entry_id
423: AND t.language(+) = v.language_code
424: AND t.entry_id IS NULL;
425:

Line 429: FROM CSI_MASS_EDIT_ENTRIES_TL T

425:
426: /******* COMMENTED for Bug 4238439
427: AND NOT EXISTS
428: (SELECT NULL
429: FROM CSI_MASS_EDIT_ENTRIES_TL T
430: WHERE T.ENTRY_ID = B.ENTRY_ID
431: AND T.LANGUAGE = L.LANGUAGE_CODE); **********/
432: END ADD_LANGUAGE;
433:

Line 441: UPDATE csi_mass_edit_entries_tl

437: p_name IN VARCHAR2,
438: p_owner IN VARCHAR2
439: ) IS
440: BEGIN
441: UPDATE csi_mass_edit_entries_tl
442: SET NAME = p_name,
443: LAST_UPDATE_DATE = SYSDATE,
444: LAST_UPDATED_BY = decode(p_owner, 'SEED', 1, 0),
445: LAST_UPDATE_LOGIN = 0,