APPS.CSD_DIAGNOSTIC_CODES_PKG dependencies on CSD_DIAGNOSTIC_CODES_TL

Line 99: insert into CSD_DIAGNOSTIC_CODES_TL (

95: P_ATTRIBUTE13,
96: P_ATTRIBUTE14,
97: P_ATTRIBUTE15 );
98:
99: insert into CSD_DIAGNOSTIC_CODES_TL (
100: DIAGNOSTIC_CODE_ID,
101: CREATED_BY,
102: CREATION_DATE,
103: LAST_UPDATED_BY,

Line 125: from CSD_DIAGNOSTIC_CODES_TL T

121: from FND_LANGUAGES L
122: where L.INSTALLED_FLAG in ('I', 'B')
123: and not exists
124: (select NULL
125: from CSD_DIAGNOSTIC_CODES_TL T
126: where T.DIAGNOSTIC_CODE_ID = PX_DIAGNOSTIC_CODE_ID
127: and T.LANGUAGE = L.LANGUAGE_CODE);
128:
129: open c;

Line 208: from CSD_DIAGNOSTIC_CODES_TL

204: cursor c1 is select
205: NAME,
206: DESCRIPTION,
207: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
208: from CSD_DIAGNOSTIC_CODES_TL
209: where DIAGNOSTIC_CODE_ID = P_DIAGNOSTIC_CODE_ID
210: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
211: for update of DIAGNOSTIC_CODE_ID nowait;
212: */

Line 365: update CSD_DIAGNOSTIC_CODES_TL set

361: if (sql%notfound) then
362: raise no_data_found;
363: end if;
364:
365: update CSD_DIAGNOSTIC_CODES_TL set
366: CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
367: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
368: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
369: ,LAST_UPDATE_DATE = decode( P_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, P_LAST_UPDATE_DATE)

Line 386: delete from CSD_DIAGNOSTIC_CODES_TL

382: procedure DELETE_ROW (
383: P_DIAGNOSTIC_CODE_ID in NUMBER
384: ) is
385: begin
386: delete from CSD_DIAGNOSTIC_CODES_TL
387: where DIAGNOSTIC_CODE_ID = P_DIAGNOSTIC_CODE_ID;
388:
389: if (sql%notfound) then
390: raise no_data_found;

Line 404: delete from CSD_DIAGNOSTIC_CODES_TL T

400:
401: procedure ADD_LANGUAGE
402: is
403: begin
404: delete from CSD_DIAGNOSTIC_CODES_TL T
405: where not exists
406: (select NULL
407: from CSD_DIAGNOSTIC_CODES_B B
408: where B.DIAGNOSTIC_CODE_ID = T.DIAGNOSTIC_CODE_ID

Line 411: update CSD_DIAGNOSTIC_CODES_TL T set (

407: from CSD_DIAGNOSTIC_CODES_B B
408: where B.DIAGNOSTIC_CODE_ID = T.DIAGNOSTIC_CODE_ID
409: );
410:
411: update CSD_DIAGNOSTIC_CODES_TL T set (
412: NAME,
413: DESCRIPTION
414: ) = (select
415: B.NAME,

Line 417: from CSD_DIAGNOSTIC_CODES_TL B

413: DESCRIPTION
414: ) = (select
415: B.NAME,
416: B.DESCRIPTION
417: from CSD_DIAGNOSTIC_CODES_TL B
418: where B.DIAGNOSTIC_CODE_ID = T.DIAGNOSTIC_CODE_ID
419: and B.LANGUAGE = T.SOURCE_LANG)
420: where (
421: T.DIAGNOSTIC_CODE_ID,

Line 426: from CSD_DIAGNOSTIC_CODES_TL SUBB, CSD_DIAGNOSTIC_CODES_TL SUBT

422: T.LANGUAGE
423: ) in (select
424: SUBT.DIAGNOSTIC_CODE_ID,
425: SUBT.LANGUAGE
426: from CSD_DIAGNOSTIC_CODES_TL SUBB, CSD_DIAGNOSTIC_CODES_TL SUBT
427: where SUBB.DIAGNOSTIC_CODE_ID = SUBT.DIAGNOSTIC_CODE_ID
428: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
429: and (SUBB.NAME <> SUBT.NAME
430: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 435: insert into CSD_DIAGNOSTIC_CODES_TL (

431: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
432: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
433: ));
434:
435: insert into CSD_DIAGNOSTIC_CODES_TL (
436: DIAGNOSTIC_CODE_ID,
437: CREATED_BY,
438: CREATION_DATE,
439: LAST_UPDATED_BY,

Line 457: from CSD_DIAGNOSTIC_CODES_TL B, FND_LANGUAGES L

453: B.NAME,
454: B.DESCRIPTION,
455: L.LANGUAGE_CODE,
456: B.SOURCE_LANG
457: from CSD_DIAGNOSTIC_CODES_TL B, FND_LANGUAGES L
458: where L.INSTALLED_FLAG in ('I', 'B')
459: and B.LANGUAGE = userenv('LANG')
460: and not exists
461: (select NULL

Line 462: from CSD_DIAGNOSTIC_CODES_TL T

458: where L.INSTALLED_FLAG in ('I', 'B')
459: and B.LANGUAGE = userenv('LANG')
460: and not exists
461: (select NULL
462: from CSD_DIAGNOSTIC_CODES_TL T
463: where T.DIAGNOSTIC_CODE_ID = B.DIAGNOSTIC_CODE_ID
464: and T.LANGUAGE = L.LANGUAGE_CODE);
465: end ADD_LANGUAGE;
466: