APPS.CS_INCIDENT_SEVERITIES_PKG dependencies on CS_INCIDENT_SEVERITIES_TL

Line 112: insert into CS_INCIDENT_SEVERITIES_TL (

108: -- Added priority code --anmukher --09/01/03
109: X_PRIORITY_CODE
110: );
111:
112: insert into CS_INCIDENT_SEVERITIES_TL (
113: INCIDENT_SEVERITY_ID,
114: NAME,
115: DESCRIPTION,
116: CREATED_BY,

Line 138: from CS_INCIDENT_SEVERITIES_TL T

134: from FND_LANGUAGES L
135: where L.INSTALLED_FLAG in ('I', 'B')
136: and not exists
137: (select NULL
138: from CS_INCIDENT_SEVERITIES_TL T
139: where T.INCIDENT_SEVERITY_ID = X_INCIDENT_SEVERITY_ID
140: and T.LANGUAGE = L.LANGUAGE_CODE);
141:
142: open c;

Line 220: from CS_INCIDENT_SEVERITIES_TL

216: cursor c1 is select
217: NAME,
218: DESCRIPTION,
219: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
220: from CS_INCIDENT_SEVERITIES_TL
221: where INCIDENT_SEVERITY_ID = X_INCIDENT_SEVERITY_ID
222: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
223: for update of INCIDENT_SEVERITY_ID nowait;
224: begin

Line 376: update CS_INCIDENT_SEVERITIES_TL set

372: if (sql%notfound) then
373: raise no_data_found;
374: end if;
375:
376: update CS_INCIDENT_SEVERITIES_TL set
377: NAME = X_NAME,
378: DESCRIPTION = X_DESCRIPTION,
379: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
380: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 395: delete from CS_INCIDENT_SEVERITIES_TL

391: procedure DELETE_ROW (
392: X_INCIDENT_SEVERITY_ID in NUMBER
393: ) is
394: begin
395: delete from CS_INCIDENT_SEVERITIES_TL
396: where INCIDENT_SEVERITY_ID = X_INCIDENT_SEVERITY_ID;
397:
398: if (sql%notfound) then
399: raise no_data_found;

Line 413: delete from CS_INCIDENT_SEVERITIES_TL T

409:
410: procedure ADD_LANGUAGE
411: is
412: begin
413: delete from CS_INCIDENT_SEVERITIES_TL T
414: where not exists
415: (select NULL
416: from CS_INCIDENT_SEVERITIES_B B
417: where B.INCIDENT_SEVERITY_ID = T.INCIDENT_SEVERITY_ID

Line 420: update CS_INCIDENT_SEVERITIES_TL T set (

416: from CS_INCIDENT_SEVERITIES_B B
417: where B.INCIDENT_SEVERITY_ID = T.INCIDENT_SEVERITY_ID
418: );
419:
420: update CS_INCIDENT_SEVERITIES_TL T set (
421: NAME,
422: DESCRIPTION
423: ) = (select
424: B.NAME,

Line 426: from CS_INCIDENT_SEVERITIES_TL B

422: DESCRIPTION
423: ) = (select
424: B.NAME,
425: B.DESCRIPTION
426: from CS_INCIDENT_SEVERITIES_TL B
427: where B.INCIDENT_SEVERITY_ID = T.INCIDENT_SEVERITY_ID
428: and B.LANGUAGE = T.SOURCE_LANG)
429: where (
430: T.INCIDENT_SEVERITY_ID,

Line 435: from CS_INCIDENT_SEVERITIES_TL SUBB, CS_INCIDENT_SEVERITIES_TL SUBT

431: T.LANGUAGE
432: ) in (select
433: SUBT.INCIDENT_SEVERITY_ID,
434: SUBT.LANGUAGE
435: from CS_INCIDENT_SEVERITIES_TL SUBB, CS_INCIDENT_SEVERITIES_TL SUBT
436: where SUBB.INCIDENT_SEVERITY_ID = SUBT.INCIDENT_SEVERITY_ID
437: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
438: and (SUBB.NAME <> SUBT.NAME
439: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 444: insert into CS_INCIDENT_SEVERITIES_TL (

440: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
441: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
442: ));
443:
444: insert into CS_INCIDENT_SEVERITIES_TL (
445: INCIDENT_SEVERITY_ID,
446: CREATED_BY,
447: CREATION_DATE,
448: LAST_UPDATED_BY,

Line 466: from CS_INCIDENT_SEVERITIES_TL B, FND_LANGUAGES L

462: B.NAME,
463: B.DESCRIPTION,
464: L.LANGUAGE_CODE,
465: B.SOURCE_LANG
466: from CS_INCIDENT_SEVERITIES_TL B, FND_LANGUAGES L
467: where L.INSTALLED_FLAG in ('I', 'B')
468: and B.LANGUAGE = userenv('LANG')
469: and not exists
470: (select NULL

Line 471: from CS_INCIDENT_SEVERITIES_TL T

467: where L.INSTALLED_FLAG in ('I', 'B')
468: and B.LANGUAGE = userenv('LANG')
469: and not exists
470: (select NULL
471: from CS_INCIDENT_SEVERITIES_TL T
472: where T.INCIDENT_SEVERITY_ID = B.INCIDENT_SEVERITY_ID
473: and T.LANGUAGE = L.LANGUAGE_CODE);
474: end ADD_LANGUAGE;
475: