APPS.CS_INCIDENT_URGENCIES_PKG dependencies on CS_INCIDENT_URGENCIES_TL

Line 103: insert into CS_INCIDENT_URGENCIES_TL (

99: X_LAST_UPDATED_BY,
100: X_LAST_UPDATE_LOGIN
101: );
102:
103: insert into CS_INCIDENT_URGENCIES_TL (
104: INCIDENT_URGENCY_ID,
105: CREATION_DATE,
106: CREATED_BY,
107: LAST_UPDATE_LOGIN,

Line 129: from CS_INCIDENT_URGENCIES_TL T

125: from FND_LANGUAGES L
126: where L.INSTALLED_FLAG in ('I', 'B')
127: and not exists
128: (select NULL
129: from CS_INCIDENT_URGENCIES_TL T
130: where T.INCIDENT_URGENCY_ID = X_INCIDENT_URGENCY_ID
131: and T.LANGUAGE = L.LANGUAGE_CODE);
132:
133: open c;

Line 204: from CS_INCIDENT_URGENCIES_TL

200: cursor c1 is select
201: NAME,
202: DESCRIPTION,
203: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
204: from CS_INCIDENT_URGENCIES_TL
205: where INCIDENT_URGENCY_ID = X_INCIDENT_URGENCY_ID
206: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
207: for update of INCIDENT_URGENCY_ID nowait;
208: begin

Line 349: update CS_INCIDENT_URGENCIES_TL set

345: if (sql%notfound) then
346: raise no_data_found;
347: end if;
348:
349: update CS_INCIDENT_URGENCIES_TL set
350: NAME = X_NAME,
351: DESCRIPTION = X_DESCRIPTION,
352: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
353: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 368: delete from CS_INCIDENT_URGENCIES_TL

364: procedure DELETE_ROW (
365: X_INCIDENT_URGENCY_ID in NUMBER
366: ) is
367: begin
368: delete from CS_INCIDENT_URGENCIES_TL
369: where INCIDENT_URGENCY_ID = X_INCIDENT_URGENCY_ID;
370:
371: if (sql%notfound) then
372: raise no_data_found;

Line 386: delete from CS_INCIDENT_URGENCIES_TL T

382:
383: procedure ADD_LANGUAGE
384: is
385: begin
386: delete from CS_INCIDENT_URGENCIES_TL T
387: where not exists
388: (select NULL
389: from CS_INCIDENT_URGENCIES_B B
390: where B.INCIDENT_URGENCY_ID = T.INCIDENT_URGENCY_ID

Line 393: update CS_INCIDENT_URGENCIES_TL T set (

389: from CS_INCIDENT_URGENCIES_B B
390: where B.INCIDENT_URGENCY_ID = T.INCIDENT_URGENCY_ID
391: );
392:
393: update CS_INCIDENT_URGENCIES_TL T set (
394: NAME,
395: DESCRIPTION
396: ) = (select
397: B.NAME,

Line 399: from CS_INCIDENT_URGENCIES_TL B

395: DESCRIPTION
396: ) = (select
397: B.NAME,
398: B.DESCRIPTION
399: from CS_INCIDENT_URGENCIES_TL B
400: where B.INCIDENT_URGENCY_ID = T.INCIDENT_URGENCY_ID
401: and B.LANGUAGE = T.SOURCE_LANG)
402: where (
403: T.INCIDENT_URGENCY_ID,

Line 408: from CS_INCIDENT_URGENCIES_TL SUBB, CS_INCIDENT_URGENCIES_TL SUBT

404: T.LANGUAGE
405: ) in (select
406: SUBT.INCIDENT_URGENCY_ID,
407: SUBT.LANGUAGE
408: from CS_INCIDENT_URGENCIES_TL SUBB, CS_INCIDENT_URGENCIES_TL SUBT
409: where SUBB.INCIDENT_URGENCY_ID = SUBT.INCIDENT_URGENCY_ID
410: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
411: and (SUBB.NAME <> SUBT.NAME
412: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 417: insert into CS_INCIDENT_URGENCIES_TL (

413: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
414: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
415: ));
416:
417: insert into CS_INCIDENT_URGENCIES_TL (
418: INCIDENT_URGENCY_ID,
419: CREATION_DATE,
420: CREATED_BY,
421: LAST_UPDATE_LOGIN,

Line 439: from CS_INCIDENT_URGENCIES_TL B, FND_LANGUAGES L

435: B.LAST_UPDATE_DATE,
436: B.LAST_UPDATED_BY,
437: L.LANGUAGE_CODE,
438: B.SOURCE_LANG
439: from CS_INCIDENT_URGENCIES_TL B, FND_LANGUAGES L
440: where L.INSTALLED_FLAG in ('I', 'B')
441: and B.LANGUAGE = userenv('LANG')
442: and not exists
443: (select NULL

Line 444: from CS_INCIDENT_URGENCIES_TL T

440: where L.INSTALLED_FLAG in ('I', 'B')
441: and B.LANGUAGE = userenv('LANG')
442: and not exists
443: (select NULL
444: from CS_INCIDENT_URGENCIES_TL T
445: where T.INCIDENT_URGENCY_ID = B.INCIDENT_URGENCY_ID
446: and T.LANGUAGE = L.LANGUAGE_CODE);
447: end ADD_LANGUAGE;
448: