APPS.ZX_TAXES_PKG dependencies on ZX_TAXES_TL

Line 537: insert into ZX_TAXES_TL (

533: X_LIVE_FOR_APPLICABILITY_FLAG,
534: X_APPLICABLE_BY_DEFAULT_FLAG,
535: X_LEGAL_REPORTING_STATUS_DEF_V
536: );
537: insert into ZX_TAXES_TL (
538: TAX_ID,
539: TAX_FULL_NAME,
540: CREATED_BY,
541: CREATION_DATE,

Line 561: from ZX_TAXES_TL T

557: from FND_LANGUAGES L
558: where L.INSTALLED_FLAG in ('I', 'B')
559: and not exists
560: (select NULL
561: from ZX_TAXES_TL T
562: where T.TAX_ID = X_TAX_ID
563: and T.LANGUAGE = L.LANGUAGE_CODE);
564: /* if(X_PRIMARY_RECOVERY_TYPE_CODE is not null) then
565: insert_recovery(

Line 814: from ZX_TAXES_TL

810: recinfo c%rowtype;
811: cursor c1 is select
812: TAX_FULL_NAME,
813: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
814: from ZX_TAXES_TL
815: where TAX_ID = X_TAX_ID
816: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
817: for update of TAX_ID nowait;
818: begin

Line 1399: update ZX_TAXES_TL set

1395: where TAX_ID = X_TAX_ID;
1396: if (sql%notfound) then
1397: raise no_data_found;
1398: end if;
1399: update ZX_TAXES_TL set
1400: TAX_FULL_NAME = X_TAX_FULL_NAME,
1401: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1402: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1403: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 1415: delete from ZX_TAXES_TL

1411: procedure DELETE_ROW (
1412: X_TAX_ID in NUMBER
1413: ) is
1414: begin
1415: delete from ZX_TAXES_TL
1416: where TAX_ID = X_TAX_ID;
1417: if (sql%notfound) then
1418: raise no_data_found;
1419: end if;

Line 1429: delete from ZX_TAXES_TL T

1425: end DELETE_ROW;
1426: procedure ADD_LANGUAGE
1427: is
1428: begin
1429: delete from ZX_TAXES_TL T
1430: where not exists
1431: (select NULL
1432: from ZX_TAXES_B B
1433: where B.TAX_ID = T.TAX_ID

Line 1435: update ZX_TAXES_TL T set (

1431: (select NULL
1432: from ZX_TAXES_B B
1433: where B.TAX_ID = T.TAX_ID
1434: );
1435: update ZX_TAXES_TL T set (
1436: TAX_FULL_NAME
1437: ) = (select
1438: B.TAX_FULL_NAME
1439: from ZX_TAXES_TL B

Line 1439: from ZX_TAXES_TL B

1435: update ZX_TAXES_TL T set (
1436: TAX_FULL_NAME
1437: ) = (select
1438: B.TAX_FULL_NAME
1439: from ZX_TAXES_TL B
1440: where B.TAX_ID = T.TAX_ID
1441: and B.LANGUAGE = T.SOURCE_LANG)
1442: where (
1443: T.TAX_ID,

Line 1448: from ZX_TAXES_TL SUBB, ZX_TAXES_TL SUBT

1444: T.LANGUAGE
1445: ) in (select
1446: SUBT.TAX_ID,
1447: SUBT.LANGUAGE
1448: from ZX_TAXES_TL SUBB, ZX_TAXES_TL SUBT
1449: where SUBB.TAX_ID = SUBT.TAX_ID
1450: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1451: and (SUBB.TAX_FULL_NAME <> SUBT.TAX_FULL_NAME
1452: or (SUBB.TAX_FULL_NAME is null and SUBT.TAX_FULL_NAME is not null)

Line 1454: insert into ZX_TAXES_TL (

1450: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1451: and (SUBB.TAX_FULL_NAME <> SUBT.TAX_FULL_NAME
1452: or (SUBB.TAX_FULL_NAME is null and SUBT.TAX_FULL_NAME is not null)
1453: or (SUBB.TAX_FULL_NAME is not null and SUBT.TAX_FULL_NAME is null)));
1454: insert into ZX_TAXES_TL (
1455: TAX_ID,
1456: TAX_FULL_NAME,
1457: CREATED_BY,
1458: CREATION_DATE,

Line 1474: from ZX_TAXES_TL B, FND_LANGUAGES L

1470: B.LAST_UPDATE_DATE,
1471: B.LAST_UPDATE_LOGIN,
1472: L.LANGUAGE_CODE,
1473: B.SOURCE_LANG
1474: from ZX_TAXES_TL B, FND_LANGUAGES L
1475: where L.INSTALLED_FLAG in ('I', 'B')
1476: and B.LANGUAGE = userenv('LANG')
1477: and not exists
1478: (select NULL

Line 1479: from ZX_TAXES_TL T

1475: where L.INSTALLED_FLAG in ('I', 'B')
1476: and B.LANGUAGE = userenv('LANG')
1477: and not exists
1478: (select NULL
1479: from ZX_TAXES_TL T
1480: where T.TAX_ID = B.TAX_ID
1481: and T.LANGUAGE = L.LANGUAGE_CODE);
1482: end ADD_LANGUAGE;
1483: end ZX_TAXES_PKG;