APPS.ZX_RATES_PKG dependencies on ZX_RATES_TL

Line 257: insert into ZX_RATES_TL (

253: X_SOURCE_ID,
254: -- X_DESCRIPTION, commented as part of fix for bug# 6820043
255: X_TAXABLE_BASIS_FORMULA_CODE
256: );
257: insert into ZX_RATES_TL (
258: TAX_RATE_ID,
259: TAX_RATE_NAME,
260: CREATED_BY,
261: CREATION_DATE,

Line 283: from ZX_RATES_TL T

279: from FND_LANGUAGES L
280: where L.INSTALLED_FLAG in ('I', 'B')
281: and not exists
282: (select NULL
283: from ZX_RATES_TL T
284: where T.TAX_RATE_ID = X_TAX_RATE_ID
285: and T.LANGUAGE = L.LANGUAGE_CODE);
286: open c;
287: fetch c into X_ROWID;

Line 501: from ZX_RATES_TL

497: recinfo c%rowtype;
498: cursor c1 is select
499: TAX_RATE_NAME,
500: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
501: from ZX_RATES_TL
502: where TAX_RATE_ID = X_TAX_RATE_ID
503: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
504: for update of TAX_RATE_ID nowait;
505: begin

Line 777: update ZX_RATES_TL set

773: where TAX_RATE_ID = X_TAX_RATE_ID;
774: if (sql%notfound) then
775: raise no_data_found;
776: end if;
777: update ZX_RATES_TL set
778: TAX_RATE_NAME = X_TAX_RATE_NAME,
779: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
780: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
781: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 873: delete from ZX_RATES_TL

869: procedure DELETE_ROW (
870: X_TAX_RATE_ID in NUMBER
871: ) is
872: begin
873: delete from ZX_RATES_TL
874: where TAX_RATE_ID = X_TAX_RATE_ID;
875: if (sql%notfound) then
876: raise no_data_found;
877: end if;

Line 888: delete from ZX_RATES_TL T

884:
885: procedure ADD_LANGUAGE
886: is
887: begin
888: delete from ZX_RATES_TL T
889: where not exists
890: (select NULL
891: from ZX_RATES_B B
892: where B.TAX_RATE_ID = T.TAX_RATE_ID

Line 894: update ZX_RATES_TL T set (

890: (select NULL
891: from ZX_RATES_B B
892: where B.TAX_RATE_ID = T.TAX_RATE_ID
893: );
894: update ZX_RATES_TL T set (
895: TAX_RATE_NAME
896: ) = (select
897: B.TAX_RATE_NAME
898: from ZX_RATES_TL B

Line 898: from ZX_RATES_TL B

894: update ZX_RATES_TL T set (
895: TAX_RATE_NAME
896: ) = (select
897: B.TAX_RATE_NAME
898: from ZX_RATES_TL B
899: where B.TAX_RATE_ID = T.TAX_RATE_ID
900: and B.LANGUAGE = T.SOURCE_LANG)
901: where (
902: T.TAX_RATE_ID,

Line 907: from ZX_RATES_TL SUBB, ZX_RATES_TL SUBT

903: T.LANGUAGE
904: ) in (select
905: SUBT.TAX_RATE_ID,
906: SUBT.LANGUAGE
907: from ZX_RATES_TL SUBB, ZX_RATES_TL SUBT
908: where SUBB.TAX_RATE_ID = SUBT.TAX_RATE_ID
909: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
910: and (SUBB.TAX_RATE_NAME <> SUBT.TAX_RATE_NAME
911: or (SUBB.TAX_RATE_NAME is null and SUBT.TAX_RATE_NAME is not null)

Line 914: insert into ZX_RATES_TL (

910: and (SUBB.TAX_RATE_NAME <> SUBT.TAX_RATE_NAME
911: or (SUBB.TAX_RATE_NAME is null and SUBT.TAX_RATE_NAME is not null)
912: or (SUBB.TAX_RATE_NAME is not null and SUBT.TAX_RATE_NAME is null)
913: ));
914: insert into ZX_RATES_TL (
915: TAX_RATE_ID,
916: TAX_RATE_NAME,
917: CREATED_BY,
918: CREATION_DATE,

Line 936: from ZX_RATES_TL B, FND_LANGUAGES L

932: B.LAST_UPDATE_LOGIN,
933: L.LANGUAGE_CODE,
934: B.DESCRIPTION,/* added as part of fix for bug# 6820043 */
935: B.SOURCE_LANG
936: from ZX_RATES_TL B, FND_LANGUAGES L
937: where L.INSTALLED_FLAG in ('I', 'B')
938: and B.LANGUAGE = userenv('LANG')
939: and not exists
940: (select NULL

Line 941: from ZX_RATES_TL T

937: where L.INSTALLED_FLAG in ('I', 'B')
938: and B.LANGUAGE = userenv('LANG')
939: and not exists
940: (select NULL
941: from ZX_RATES_TL T
942: where T.TAX_RATE_ID = B.TAX_RATE_ID
943: and T.LANGUAGE = L.LANGUAGE_CODE);
944: end ADD_LANGUAGE;
945: