APPS.ZX_CONDITION_GROUPS_PKG dependencies on ZX_CONDITION_GROUPS_TL

Line 403: insert into ZX_CONDITION_GROUPS_TL (

399: X_PROGRAM_ID,
400: X_PROGRAM_LOGIN_ID,
401: X_CONSTRAINT_ID,
402: X_OBJECT_VERSION_NUMBER);
403: insert into ZX_CONDITION_GROUPS_TL (
404: CONDITION_GROUP_ID,
405: CONDITION_GROUP_NAME,
406: CONDITION_GROUP_DESC,
407: CREATION_DATE,

Line 429: from ZX_CONDITION_GROUPS_TL T

425: from FND_LANGUAGES L
426: where L.INSTALLED_FLAG in ('I', 'B')
427: and not exists
428: (select NULL
429: from ZX_CONDITION_GROUPS_TL T
430: where T.CONDITION_GROUP_ID = X_CONDITION_GROUP_ID
431: and T.LANGUAGE = L.LANGUAGE_CODE);
432: open c;
433: fetch c into X_ROWID;

Line 707: from ZX_CONDITION_GROUPS_TL

703: cursor c1 is select
704: CONDITION_GROUP_NAME,
705: CONDITION_GROUP_DESC,
706: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
707: from ZX_CONDITION_GROUPS_TL
708: where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID
709: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
710: for update of CONDITION_GROUP_ID nowait;
711: begin

Line 1349: update ZX_CONDITION_GROUPS_TL set

1345: where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
1346: if (sql%notfound) then
1347: raise no_data_found;
1348: end if;
1349: update ZX_CONDITION_GROUPS_TL set
1350: CONDITION_GROUP_NAME = X_CONDITION_GROUP_NAME,
1351: CONDITION_GROUP_DESC = X_CONDITION_GROUP_DESC,
1352: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1353: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 1371: delete from ZX_CONDITION_GROUPS_TL

1367:
1368: procedure DELETE_ROW (
1369: X_CONDITION_GROUP_ID in NUMBER) is
1370: begin
1371: delete from ZX_CONDITION_GROUPS_TL
1372: where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
1373: if (sql%notfound) then
1374: raise no_data_found;
1375: end if;

Line 1391: delete from ZX_CONDITION_GROUPS_TL T

1387:
1388: procedure ADD_LANGUAGE
1389: is
1390: begin
1391: delete from ZX_CONDITION_GROUPS_TL T
1392: where not exists
1393: (select NULL
1394: from ZX_CONDITION_GROUPS_B B
1395: where B.CONDITION_GROUP_ID = T.CONDITION_GROUP_ID);

Line 1396: update ZX_CONDITION_GROUPS_TL T set (

1392: where not exists
1393: (select NULL
1394: from ZX_CONDITION_GROUPS_B B
1395: where B.CONDITION_GROUP_ID = T.CONDITION_GROUP_ID);
1396: update ZX_CONDITION_GROUPS_TL T set (
1397: CONDITION_GROUP_NAME,
1398: CONDITION_GROUP_DESC) = (select B.CONDITION_GROUP_NAME,
1399: B.CONDITION_GROUP_DESC
1400: from ZX_CONDITION_GROUPS_TL B

Line 1400: from ZX_CONDITION_GROUPS_TL B

1396: update ZX_CONDITION_GROUPS_TL T set (
1397: CONDITION_GROUP_NAME,
1398: CONDITION_GROUP_DESC) = (select B.CONDITION_GROUP_NAME,
1399: B.CONDITION_GROUP_DESC
1400: from ZX_CONDITION_GROUPS_TL B
1401: where B.CONDITION_GROUP_ID = T.CONDITION_GROUP_ID
1402: and B.LANGUAGE = T.SOURCE_LANG)
1403: where (T.CONDITION_GROUP_ID, T.LANGUAGE) in
1404: (select SUBT.CONDITION_GROUP_ID,

Line 1406: from ZX_CONDITION_GROUPS_TL SUBB, ZX_CONDITION_GROUPS_TL SUBT

1402: and B.LANGUAGE = T.SOURCE_LANG)
1403: where (T.CONDITION_GROUP_ID, T.LANGUAGE) in
1404: (select SUBT.CONDITION_GROUP_ID,
1405: SUBT.LANGUAGE
1406: from ZX_CONDITION_GROUPS_TL SUBB, ZX_CONDITION_GROUPS_TL SUBT
1407: where SUBB.CONDITION_GROUP_ID = SUBT.CONDITION_GROUP_ID
1408: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1409: and (SUBB.CONDITION_GROUP_NAME <> SUBT.CONDITION_GROUP_NAME
1410: or SUBB.CONDITION_GROUP_DESC <> SUBT.CONDITION_GROUP_DESC

Line 1415: insert into ZX_CONDITION_GROUPS_TL (

1411: or (SUBB.CONDITION_GROUP_DESC is null
1412: and SUBT.CONDITION_GROUP_DESC is not null)
1413: or (SUBB.CONDITION_GROUP_DESC is not null
1414: and SUBT.CONDITION_GROUP_DESC is null) ));
1415: insert into ZX_CONDITION_GROUPS_TL (
1416: CONDITION_GROUP_ID,
1417: CONDITION_GROUP_NAME,
1418: CONDITION_GROUP_DESC,
1419: CREATION_DATE,

Line 1437: from ZX_CONDITION_GROUPS_TL B, FND_LANGUAGES L

1433: B.LAST_UPDATED_BY,
1434: B.LAST_UPDATE_LOGIN,
1435: L.LANGUAGE_CODE,
1436: B.SOURCE_LANG
1437: from ZX_CONDITION_GROUPS_TL B, FND_LANGUAGES L
1438: where L.INSTALLED_FLAG in ('I', 'B')
1439: and B.LANGUAGE = userenv('LANG')
1440: and not exists
1441: (select NULL

Line 1442: from ZX_CONDITION_GROUPS_TL T

1438: where L.INSTALLED_FLAG in ('I', 'B')
1439: and B.LANGUAGE = userenv('LANG')
1440: and not exists
1441: (select NULL
1442: from ZX_CONDITION_GROUPS_TL T
1443: where T.CONDITION_GROUP_ID = B.CONDITION_GROUP_ID
1444: and T.LANGUAGE = L.LANGUAGE_CODE);
1445:
1446: EXCEPTION

Line 1842: insert into ZX_CONDITION_GROUPS_TL (

1838: fnd_global.conc_login_id
1839: );
1840:
1841: forall i in x_condition_group_id.first..x_condition_group_id.last
1842: insert into ZX_CONDITION_GROUPS_TL (
1843: CONDITION_GROUP_ID,
1844: CONDITION_GROUP_NAME,
1845: CONDITION_GROUP_DESC,
1846: LANGUAGE,

Line 1867: from ZX_CONDITION_GROUPS_TL T

1863: from FND_LANGUAGES L
1864: where L.INSTALLED_FLAG in ('I', 'B')
1865: and not exists
1866: (select NULL
1867: from ZX_CONDITION_GROUPS_TL T
1868: where T.CONDITION_GROUP_ID = X_CONDITION_GROUP_ID(i)
1869: and T.LANGUAGE = L.LANGUAGE_CODE);
1870: end if;
1871: