APPS.CS_SR_CONTACTS_EXT_PKG dependencies on CS_SR_CONTACTS_EXT_TL

Line 435: insert into CS_SR_CONTACTS_EXT_TL (

431: X_LAST_UPDATED_BY,
432: X_LAST_UPDATE_LOGIN
433: );
434:
435: insert into CS_SR_CONTACTS_EXT_TL (
436: PARTY_ROLE_CODE,
437: CONTACT_TYPE,
438: PARTY_ID,
439: EXTENSION_ID,

Line 489: from CS_SR_CONTACTS_EXT_TL T

485: from FND_LANGUAGES L
486: where L.INSTALLED_FLAG in ('I', 'B')
487: and not exists
488: (select NULL
489: from CS_SR_CONTACTS_EXT_TL T
490: where T.EXTENSION_ID = X_EXTENSION_ID
491: and T.LANGUAGE = L.LANGUAGE_CODE);
492:
493: open c;

Line 796: from CS_SR_CONTACTS_EXT_TL

792: TL_EXT_ATTR8,
793: TL_EXT_ATTR9,
794: TL_EXT_ATTR10,
795: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
796: from CS_SR_CONTACTS_EXT_TL
797: where EXTENSION_ID = X_EXTENSION_ID
798: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
799: for update of EXTENSION_ID nowait;
800: begin

Line 1394: update CS_SR_CONTACTS_EXT_TL set

1390: if (sql%notfound) then
1391: raise no_data_found;
1392: end if;
1393:
1394: update CS_SR_CONTACTS_EXT_TL set
1395: TL_EXT_ATTR1 = X_TL_EXT_ATTR1,
1396: TL_EXT_ATTR2 = X_TL_EXT_ATTR2,
1397: TL_EXT_ATTR3 = X_TL_EXT_ATTR3,
1398: TL_EXT_ATTR4 = X_TL_EXT_ATTR4,

Line 1421: delete from CS_SR_CONTACTS_EXT_TL

1417: procedure DELETE_ROW (
1418: X_EXTENSION_ID in NUMBER
1419: ) is
1420: begin
1421: delete from CS_SR_CONTACTS_EXT_TL
1422: where EXTENSION_ID = X_EXTENSION_ID;
1423:
1424: if (sql%notfound) then
1425: raise no_data_found;

Line 1439: delete from CS_SR_CONTACTS_EXT_TL T

1435:
1436: procedure ADD_LANGUAGE
1437: is
1438: begin
1439: delete from CS_SR_CONTACTS_EXT_TL T
1440: where not exists
1441: (select NULL
1442: from CS_SR_CONTACTS_EXT_B B
1443: where B.EXTENSION_ID = T.EXTENSION_ID

Line 1446: update CS_SR_CONTACTS_EXT_TL T set (

1442: from CS_SR_CONTACTS_EXT_B B
1443: where B.EXTENSION_ID = T.EXTENSION_ID
1444: );
1445:
1446: update CS_SR_CONTACTS_EXT_TL T set (
1447: TL_EXT_ATTR1,
1448: TL_EXT_ATTR2,
1449: TL_EXT_ATTR3,
1450: TL_EXT_ATTR4,

Line 1468: from CS_SR_CONTACTS_EXT_TL B

1464: B.TL_EXT_ATTR7,
1465: B.TL_EXT_ATTR8,
1466: B.TL_EXT_ATTR9,
1467: B.TL_EXT_ATTR10
1468: from CS_SR_CONTACTS_EXT_TL B
1469: where B.EXTENSION_ID = T.EXTENSION_ID
1470: and B.LANGUAGE = T.SOURCE_LANG)
1471: where (
1472: T.EXTENSION_ID,

Line 1477: from CS_SR_CONTACTS_EXT_TL SUBB, CS_SR_CONTACTS_EXT_TL SUBT

1473: T.LANGUAGE
1474: ) in (select
1475: SUBT.EXTENSION_ID,
1476: SUBT.LANGUAGE
1477: from CS_SR_CONTACTS_EXT_TL SUBB, CS_SR_CONTACTS_EXT_TL SUBT
1478: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
1479: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1480: and (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
1481: or (SUBB.TL_EXT_ATTR1 is null and SUBT.TL_EXT_ATTR1 is not null)

Line 1512: insert into CS_SR_CONTACTS_EXT_TL (

1508: or (SUBB.TL_EXT_ATTR10 is null and SUBT.TL_EXT_ATTR10 is not null)
1509: or (SUBB.TL_EXT_ATTR10 is not null and SUBT.TL_EXT_ATTR10 is null)
1510: ));
1511:
1512: insert into CS_SR_CONTACTS_EXT_TL (
1513: PARTY_ROLE_CODE,
1514: CONTACT_TYPE,
1515: PARTY_ID,
1516: EXTENSION_ID,

Line 1562: from CS_SR_CONTACTS_EXT_TL B, FND_LANGUAGES L

1558: B.TL_EXT_ATTR9,
1559: B.TL_EXT_ATTR10,
1560: L.LANGUAGE_CODE,
1561: B.SOURCE_LANG
1562: from CS_SR_CONTACTS_EXT_TL B, FND_LANGUAGES L
1563: where L.INSTALLED_FLAG in ('I', 'B')
1564: and B.LANGUAGE = userenv('LANG')
1565: and not exists
1566: (select NULL

Line 1567: from CS_SR_CONTACTS_EXT_TL T

1563: where L.INSTALLED_FLAG in ('I', 'B')
1564: and B.LANGUAGE = userenv('LANG')
1565: and not exists
1566: (select NULL
1567: from CS_SR_CONTACTS_EXT_TL T
1568: where T.EXTENSION_ID = B.EXTENSION_ID
1569: and T.LANGUAGE = L.LANGUAGE_CODE);
1570: end ADD_LANGUAGE;
1571: