APPS.ZX_RATES_PKG dependencies on ZX_RATES_TL

Line 410: insert into ZX_RATES_TL (

406: -- X_DESCRIPTION, -- commented as part of fix for bug# 6820043
407: X_TAXABLE_BASIS_FORMULA_CODE
408: );
409:
410: insert into ZX_RATES_TL (
411: TAX_RATE_ID,
412: TAX_RATE_NAME,
413: CREATED_BY,
414: CREATION_DATE,

Line 436: from ZX_RATES_TL T

432: from FND_LANGUAGES L
433: where L.INSTALLED_FLAG in ('I', 'B')
434: and not exists
435: (select NULL
436: from ZX_RATES_TL T
437: where T.TAX_RATE_ID = X_TAX_RATE_ID
438: and T.LANGUAGE = L.LANGUAGE_CODE);
439: open c;
440: fetch c into X_ROWID;

Line 648: from ZX_RATES_TL

644: recinfo c%rowtype;
645: cursor c1 is select
646: TAX_RATE_NAME,
647: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
648: from ZX_RATES_TL
649: where TAX_RATE_ID = X_TAX_RATE_ID
650: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
651: for update of TAX_RATE_ID nowait;
652: begin

Line 928: update ZX_RATES_TL set

924: where TAX_RATE_ID = X_TAX_RATE_ID;
925: if (sql%notfound) then
926: raise no_data_found;
927: end if;
928: update ZX_RATES_TL set
929: TAX_RATE_NAME = X_TAX_RATE_NAME,
930: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
931: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
932: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 1027: delete from ZX_RATES_TL

1023: procedure DELETE_ROW (
1024: X_TAX_RATE_ID in NUMBER
1025: ) is
1026: begin
1027: delete from ZX_RATES_TL
1028: where TAX_RATE_ID = X_TAX_RATE_ID;
1029: if (sql%notfound) then
1030: raise no_data_found;
1031: end if;

Line 1045: delete from ZX_RATES_TL T

1041: ------------------------------------------------------------------------
1042: procedure ADD_LANGUAGE
1043: is
1044: begin
1045: delete from ZX_RATES_TL T
1046: where not exists
1047: (select NULL
1048: from ZX_RATES_B B
1049: where B.TAX_RATE_ID = T.TAX_RATE_ID

Line 1051: update ZX_RATES_TL T set (

1047: (select NULL
1048: from ZX_RATES_B B
1049: where B.TAX_RATE_ID = T.TAX_RATE_ID
1050: );
1051: update ZX_RATES_TL T set (
1052: TAX_RATE_NAME
1053: ) = (select
1054: B.TAX_RATE_NAME
1055: from ZX_RATES_TL B

Line 1055: from ZX_RATES_TL B

1051: update ZX_RATES_TL T set (
1052: TAX_RATE_NAME
1053: ) = (select
1054: B.TAX_RATE_NAME
1055: from ZX_RATES_TL B
1056: where B.TAX_RATE_ID = T.TAX_RATE_ID
1057: and B.LANGUAGE = T.SOURCE_LANG)
1058: where (
1059: T.TAX_RATE_ID,

Line 1064: from ZX_RATES_TL SUBB, ZX_RATES_TL SUBT

1060: T.LANGUAGE
1061: ) in (select
1062: SUBT.TAX_RATE_ID,
1063: SUBT.LANGUAGE
1064: from ZX_RATES_TL SUBB, ZX_RATES_TL SUBT
1065: where SUBB.TAX_RATE_ID = SUBT.TAX_RATE_ID
1066: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1067: and (SUBB.TAX_RATE_NAME <> SUBT.TAX_RATE_NAME
1068: or (SUBB.TAX_RATE_NAME is null and SUBT.TAX_RATE_NAME is not null)

Line 1071: insert into ZX_RATES_TL (

1067: and (SUBB.TAX_RATE_NAME <> SUBT.TAX_RATE_NAME
1068: or (SUBB.TAX_RATE_NAME is null and SUBT.TAX_RATE_NAME is not null)
1069: or (SUBB.TAX_RATE_NAME is not null and SUBT.TAX_RATE_NAME is null)
1070: ));
1071: insert into ZX_RATES_TL (
1072: TAX_RATE_ID,
1073: TAX_RATE_NAME,
1074: CREATED_BY,
1075: CREATION_DATE,

Line 1093: from ZX_RATES_TL B, FND_LANGUAGES L

1089: B.LAST_UPDATE_LOGIN,
1090: L.LANGUAGE_CODE,
1091: B.DESCRIPTION, -- added as part of fix for bug# 6820043
1092: B.SOURCE_LANG
1093: from ZX_RATES_TL B, FND_LANGUAGES L
1094: where L.INSTALLED_FLAG in ('I', 'B')
1095: and B.LANGUAGE = userenv('LANG')
1096: and not exists
1097: (select NULL

Line 1098: from ZX_RATES_TL T

1094: where L.INSTALLED_FLAG in ('I', 'B')
1095: and B.LANGUAGE = userenv('LANG')
1096: and not exists
1097: (select NULL
1098: from ZX_RATES_TL T
1099: where T.TAX_RATE_ID = B.TAX_RATE_ID
1100: and T.LANGUAGE = L.LANGUAGE_CODE);
1101: end ADD_LANGUAGE;
1102: