APPS.ZX_JURISDICTIONS_PKG dependencies on ZX_JURISDICTIONS_TL

Line 147: insert into ZX_JURISDICTIONS_TL (

143: X_OBJECT_VERSION_NUMBER,
144: X_TAX_ACCT_SRC_JURISDICT_ID,
145: X_TAX_EXMPT_SRC_JURISDICT_ID
146: );
147: insert into ZX_JURISDICTIONS_TL (
148: TAX_JURISDICTION_ID,
149: TAX_JURISDICTION_NAME,
150: CREATED_BY,
151: CREATION_DATE,

Line 171: from ZX_JURISDICTIONS_TL T

167: from FND_LANGUAGES L
168: where L.INSTALLED_FLAG in ('I', 'B')
169: and not exists
170: (select NULL
171: from ZX_JURISDICTIONS_TL T
172: where T.TAX_JURISDICTION_ID = X_TAX_JURISDICTION_ID
173: and T.LANGUAGE = L.LANGUAGE_CODE);
174: open c;
175: fetch c into X_ROWID;

Line 271: from ZX_JURISDICTIONS_TL

267: recinfo c%rowtype;
268: cursor c1 is select
269: TAX_JURISDICTION_NAME,
270: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
271: from ZX_JURISDICTIONS_TL
272: where TAX_JURISDICTION_ID = X_TAX_JURISDICTION_ID
273: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
274: for update of TAX_JURISDICTION_ID nowait;
275: begin

Line 468: update ZX_JURISDICTIONS_TL set

464: where TAX_JURISDICTION_ID = X_TAX_JURISDICTION_ID;
465: if (sql%notfound) then
466: raise no_data_found;
467: end if;
468: update ZX_JURISDICTIONS_TL set
469: TAX_JURISDICTION_NAME = X_TAX_JURISDICTION_NAME,
470: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
471: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
472: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 485: delete from ZX_JURISDICTIONS_TL

481: procedure DELETE_ROW (
482: X_TAX_JURISDICTION_ID in NUMBER
483: ) is
484: begin
485: delete from ZX_JURISDICTIONS_TL
486: where TAX_JURISDICTION_ID = X_TAX_JURISDICTION_ID;
487: if (sql%notfound) then
488: raise no_data_found;
489: end if;

Line 500: delete from ZX_JURISDICTIONS_TL T

496:
497: procedure ADD_LANGUAGE
498: is
499: begin
500: delete from ZX_JURISDICTIONS_TL T
501: where not exists
502: (select NULL
503: from ZX_JURISDICTIONS_B B
504: where B.TAX_JURISDICTION_ID = T.TAX_JURISDICTION_ID

Line 506: update ZX_JURISDICTIONS_TL T set (

502: (select NULL
503: from ZX_JURISDICTIONS_B B
504: where B.TAX_JURISDICTION_ID = T.TAX_JURISDICTION_ID
505: );
506: update ZX_JURISDICTIONS_TL T set (
507: TAX_JURISDICTION_NAME
508: ) = (select
509: B.TAX_JURISDICTION_NAME
510: from ZX_JURISDICTIONS_TL B

Line 510: from ZX_JURISDICTIONS_TL B

506: update ZX_JURISDICTIONS_TL T set (
507: TAX_JURISDICTION_NAME
508: ) = (select
509: B.TAX_JURISDICTION_NAME
510: from ZX_JURISDICTIONS_TL B
511: where B.TAX_JURISDICTION_ID = T.TAX_JURISDICTION_ID
512: and B.LANGUAGE = T.SOURCE_LANG)
513: where (
514: T.TAX_JURISDICTION_ID,

Line 519: from ZX_JURISDICTIONS_TL SUBB, ZX_JURISDICTIONS_TL SUBT

515: T.LANGUAGE
516: ) in (select
517: SUBT.TAX_JURISDICTION_ID,
518: SUBT.LANGUAGE
519: from ZX_JURISDICTIONS_TL SUBB, ZX_JURISDICTIONS_TL SUBT
520: where SUBB.TAX_JURISDICTION_ID = SUBT.TAX_JURISDICTION_ID
521: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
522: and (SUBB.TAX_JURISDICTION_NAME <> SUBT.TAX_JURISDICTION_NAME
523: or (SUBB.TAX_JURISDICTION_NAME is null and SUBT.TAX_JURISDICTION_NAME is not null)

Line 526: insert into ZX_JURISDICTIONS_TL (

522: and (SUBB.TAX_JURISDICTION_NAME <> SUBT.TAX_JURISDICTION_NAME
523: or (SUBB.TAX_JURISDICTION_NAME is null and SUBT.TAX_JURISDICTION_NAME is not null)
524: or (SUBB.TAX_JURISDICTION_NAME is not null and SUBT.TAX_JURISDICTION_NAME is null)
525: ));
526: insert into ZX_JURISDICTIONS_TL (
527: TAX_JURISDICTION_ID,
528: TAX_JURISDICTION_NAME,
529: CREATED_BY,
530: CREATION_DATE,

Line 546: from ZX_JURISDICTIONS_TL B, FND_LANGUAGES L

542: B.LAST_UPDATE_DATE,
543: B.LAST_UPDATE_LOGIN,
544: L.LANGUAGE_CODE,
545: B.SOURCE_LANG
546: from ZX_JURISDICTIONS_TL B, FND_LANGUAGES L
547: where L.INSTALLED_FLAG in ('I', 'B')
548: and B.LANGUAGE = userenv('LANG')
549: and not exists
550: (select NULL

Line 551: from ZX_JURISDICTIONS_TL T

547: where L.INSTALLED_FLAG in ('I', 'B')
548: and B.LANGUAGE = userenv('LANG')
549: and not exists
550: (select NULL
551: from ZX_JURISDICTIONS_TL T
552: where T.TAX_JURISDICTION_ID = B.TAX_JURISDICTION_ID
553: and T.LANGUAGE = L.LANGUAGE_CODE);
554: end ADD_LANGUAGE;
555: