APPS.ZX_REGIMES_PKG dependencies on ZX_REGIMES_TL

Line 249: insert into ZX_REGIMES_TL (

245: X_LAST_UPDATE_LOGIN,
246: X_TAX_ACCOUNT_PRECEDENCE_CODE,
247: X_OBJECT_VERSION_NUMBER
248: );
249: insert into ZX_REGIMES_TL (
250: TAX_REGIME_ID,
251: TAX_REGIME_NAME,
252: CREATED_BY,
253: CREATION_DATE,

Line 273: from ZX_REGIMES_TL T

269: from FND_LANGUAGES L
270: where L.INSTALLED_FLAG in ('I', 'B')
271: and not exists
272: (select NULL
273: from ZX_REGIMES_TL T
274: where T.TAX_REGIME_ID = X_TAX_REGIME_ID
275: and T.LANGUAGE = L.LANGUAGE_CODE);
276: open c;
277: fetch c into X_ROWID;

Line 447: from ZX_REGIMES_TL

443: recinfo c%rowtype;
444: cursor c1 is select
445: TAX_REGIME_NAME,
446: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
447: from ZX_REGIMES_TL
448: where TAX_REGIME_ID = X_TAX_REGIME_ID
449: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
450: for update of TAX_REGIME_ID nowait;
451: begin

Line 794: update ZX_REGIMES_TL set

790: where TAX_REGIME_ID = X_TAX_REGIME_ID;
791: if (sql%notfound) then
792: raise no_data_found;
793: end if;
794: update ZX_REGIMES_TL set
795: TAX_REGIME_NAME = X_TAX_REGIME_NAME,
796: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
797: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
798: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 827: delete from ZX_REGIMES_TL

823: procedure DELETE_ROW (
824: X_TAX_REGIME_ID in NUMBER
825: ) is
826: begin
827: delete from ZX_REGIMES_TL
828: where TAX_REGIME_ID = X_TAX_REGIME_ID;
829: if (sql%notfound) then
830: raise no_data_found;
831: end if;

Line 842: delete from ZX_REGIMES_TL T

838:
839: procedure ADD_LANGUAGE
840: is
841: begin
842: delete from ZX_REGIMES_TL T
843: where not exists
844: (select NULL
845: from ZX_REGIMES_B B
846: where B.TAX_REGIME_ID = T.TAX_REGIME_ID

Line 848: update ZX_REGIMES_TL T set (

844: (select NULL
845: from ZX_REGIMES_B B
846: where B.TAX_REGIME_ID = T.TAX_REGIME_ID
847: );
848: update ZX_REGIMES_TL T set (
849: TAX_REGIME_NAME
850: ) = (select
851: B.TAX_REGIME_NAME
852: from ZX_REGIMES_TL B

Line 852: from ZX_REGIMES_TL B

848: update ZX_REGIMES_TL T set (
849: TAX_REGIME_NAME
850: ) = (select
851: B.TAX_REGIME_NAME
852: from ZX_REGIMES_TL B
853: where B.TAX_REGIME_ID = T.TAX_REGIME_ID
854: and B.LANGUAGE = T.SOURCE_LANG)
855: where (
856: T.TAX_REGIME_ID,

Line 861: from ZX_REGIMES_TL SUBB, ZX_REGIMES_TL SUBT

857: T.LANGUAGE
858: ) in (select
859: SUBT.TAX_REGIME_ID,
860: SUBT.LANGUAGE
861: from ZX_REGIMES_TL SUBB, ZX_REGIMES_TL SUBT
862: where SUBB.TAX_REGIME_ID = SUBT.TAX_REGIME_ID
863: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
864: and (SUBB.TAX_REGIME_NAME <> SUBT.TAX_REGIME_NAME
865: or (SUBB.TAX_REGIME_NAME is null and SUBT.TAX_REGIME_NAME is not null)

Line 868: insert into ZX_REGIMES_TL (

864: and (SUBB.TAX_REGIME_NAME <> SUBT.TAX_REGIME_NAME
865: or (SUBB.TAX_REGIME_NAME is null and SUBT.TAX_REGIME_NAME is not null)
866: or (SUBB.TAX_REGIME_NAME is not null and SUBT.TAX_REGIME_NAME is null)
867: ));
868: insert into ZX_REGIMES_TL (
869: TAX_REGIME_ID,
870: TAX_REGIME_NAME,
871: CREATED_BY,
872: CREATION_DATE,

Line 888: from ZX_REGIMES_TL B, FND_LANGUAGES L

884: B.LAST_UPDATE_DATE,
885: B.LAST_UPDATE_LOGIN,
886: L.LANGUAGE_CODE,
887: B.SOURCE_LANG
888: from ZX_REGIMES_TL B, FND_LANGUAGES L
889: where L.INSTALLED_FLAG in ('I', 'B')
890: and B.LANGUAGE = userenv('LANG')
891: and not exists
892: (select NULL

Line 893: from ZX_REGIMES_TL T

889: where L.INSTALLED_FLAG in ('I', 'B')
890: and B.LANGUAGE = userenv('LANG')
891: and not exists
892: (select NULL
893: from ZX_REGIMES_TL T
894: where T.TAX_REGIME_ID = B.TAX_REGIME_ID
895: and T.LANGUAGE = L.LANGUAGE_CODE);
896: end ADD_LANGUAGE;
897: