APPS.CS_INCIDENTS_EXT_PKG dependencies on CS_INCIDENTS_EXT_TL

Line 426: insert into CS_INCIDENTS_EXT_TL (

422: X_LAST_UPDATED_BY,
423: X_LAST_UPDATE_LOGIN
424: );
425:
426: insert into CS_INCIDENTS_EXT_TL (
427: EXTENSION_ID,
428: INCIDENT_ID,
429: CONTEXT,
430: ATTR_GROUP_ID,

Line 474: from CS_INCIDENTS_EXT_TL T

470: from FND_LANGUAGES L
471: where L.INSTALLED_FLAG in ('I', 'B')
472: and not exists
473: (select NULL
474: from CS_INCIDENTS_EXT_TL T
475: where T.EXTENSION_ID = X_EXTENSION_ID
476: and T.LANGUAGE = L.LANGUAGE_CODE);
477:
478: open c;

Line 775: from CS_INCIDENTS_EXT_TL

771: TL_EXT_ATTR8,
772: TL_EXT_ATTR9,
773: TL_EXT_ATTR10,
774: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
775: from CS_INCIDENTS_EXT_TL
776: where EXTENSION_ID = X_EXTENSION_ID
777: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
778: for update of EXTENSION_ID nowait;
779: begin

Line 1364: update CS_INCIDENTS_EXT_TL set

1360: if (sql%notfound) then
1361: raise no_data_found;
1362: end if;
1363:
1364: update CS_INCIDENTS_EXT_TL set
1365: TL_EXT_ATTR1 = X_TL_EXT_ATTR1,
1366: TL_EXT_ATTR2 = X_TL_EXT_ATTR2,
1367: TL_EXT_ATTR3 = X_TL_EXT_ATTR3,
1368: TL_EXT_ATTR4 = X_TL_EXT_ATTR4,

Line 1391: delete from CS_INCIDENTS_EXT_TL

1387: procedure DELETE_ROW (
1388: X_EXTENSION_ID in NUMBER
1389: ) is
1390: begin
1391: delete from CS_INCIDENTS_EXT_TL
1392: where EXTENSION_ID = X_EXTENSION_ID;
1393:
1394: if (sql%notfound) then
1395: raise no_data_found;

Line 1409: delete from CS_INCIDENTS_EXT_TL T

1405:
1406: procedure ADD_LANGUAGE
1407: is
1408: begin
1409: delete from CS_INCIDENTS_EXT_TL T
1410: where not exists
1411: (select NULL
1412: from CS_INCIDENTS_EXT_B B
1413: where B.EXTENSION_ID = T.EXTENSION_ID

Line 1416: update CS_INCIDENTS_EXT_TL T set (

1412: from CS_INCIDENTS_EXT_B B
1413: where B.EXTENSION_ID = T.EXTENSION_ID
1414: );
1415:
1416: update CS_INCIDENTS_EXT_TL T set (
1417: TL_EXT_ATTR1,
1418: TL_EXT_ATTR2,
1419: TL_EXT_ATTR3,
1420: TL_EXT_ATTR4,

Line 1438: from CS_INCIDENTS_EXT_TL B

1434: B.TL_EXT_ATTR7,
1435: B.TL_EXT_ATTR8,
1436: B.TL_EXT_ATTR9,
1437: B.TL_EXT_ATTR10
1438: from CS_INCIDENTS_EXT_TL B
1439: where B.EXTENSION_ID = T.EXTENSION_ID
1440: and B.LANGUAGE = T.SOURCE_LANG)
1441: where (
1442: T.EXTENSION_ID,

Line 1447: from CS_INCIDENTS_EXT_TL SUBB, CS_INCIDENTS_EXT_TL SUBT

1443: T.LANGUAGE
1444: ) in (select
1445: SUBT.EXTENSION_ID,
1446: SUBT.LANGUAGE
1447: from CS_INCIDENTS_EXT_TL SUBB, CS_INCIDENTS_EXT_TL SUBT
1448: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
1449: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1450: and (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
1451: or (SUBB.TL_EXT_ATTR1 is null and SUBT.TL_EXT_ATTR1 is not null)

Line 1482: insert into CS_INCIDENTS_EXT_TL (

1478: or (SUBB.TL_EXT_ATTR10 is null and SUBT.TL_EXT_ATTR10 is not null)
1479: or (SUBB.TL_EXT_ATTR10 is not null and SUBT.TL_EXT_ATTR10 is null)
1480: ));
1481:
1482: insert into CS_INCIDENTS_EXT_TL (
1483: EXTENSION_ID,
1484: INCIDENT_ID,
1485: CONTEXT,
1486: ATTR_GROUP_ID,

Line 1526: from CS_INCIDENTS_EXT_TL B, FND_LANGUAGES L

1522: B.TL_EXT_ATTR9,
1523: B.TL_EXT_ATTR10,
1524: L.LANGUAGE_CODE,
1525: B.SOURCE_LANG
1526: from CS_INCIDENTS_EXT_TL B, FND_LANGUAGES L
1527: where L.INSTALLED_FLAG in ('I', 'B')
1528: and B.LANGUAGE = userenv('LANG')
1529: and not exists
1530: (select NULL

Line 1531: from CS_INCIDENTS_EXT_TL T

1527: where L.INSTALLED_FLAG in ('I', 'B')
1528: and B.LANGUAGE = userenv('LANG')
1529: and not exists
1530: (select NULL
1531: from CS_INCIDENTS_EXT_TL T
1532: where T.EXTENSION_ID = B.EXTENSION_ID
1533: and T.LANGUAGE = L.LANGUAGE_CODE);
1534: end ADD_LANGUAGE;
1535: