APPS.ZX_STATUS_PKG dependencies on ZX_STATUS_TL

Line 141: insert into ZX_STATUS_TL (

137: X_PROGRAM_LOGIN_ID,
138: X_CONTENT_OWNER_ID,
139: X_OBJECT_VERSION_NUMBER
140: );
141: insert into ZX_STATUS_TL (
142: TAX_STATUS_ID,
143: TAX_STATUS_NAME,
144: CREATED_BY,
145: CREATION_DATE,

Line 165: from ZX_STATUS_TL T

161: from FND_LANGUAGES L
162: where L.INSTALLED_FLAG in ('I', 'B')
163: and not exists
164: (select NULL
165: from ZX_STATUS_TL T
166: where T.TAX_STATUS_ID = X_TAX_STATUS_ID
167: and T.LANGUAGE = L.LANGUAGE_CODE);
168: open c;
169: fetch c into X_ROWID;

Line 261: from ZX_STATUS_TL

257: recinfo c%rowtype;
258: cursor c1 is select
259: TAX_STATUS_NAME,
260: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
261: from ZX_STATUS_TL
262: where TAX_STATUS_ID = X_TAX_STATUS_ID
263: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
264: for update of TAX_STATUS_ID nowait;
265: begin

Line 452: update ZX_STATUS_TL set

448: where TAX_STATUS_ID = X_TAX_STATUS_ID;
449: if (sql%notfound) then
450: raise no_data_found;
451: end if;
452: update ZX_STATUS_TL set
453: TAX_STATUS_NAME = X_TAX_STATUS_NAME,
454: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
455: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
456: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 469: delete from ZX_STATUS_TL

465: procedure DELETE_ROW (
466: X_TAX_STATUS_ID in NUMBER
467: ) is
468: begin
469: delete from ZX_STATUS_TL
470: where TAX_STATUS_ID = X_TAX_STATUS_ID;
471: if (sql%notfound) then
472: raise no_data_found;
473: end if;

Line 484: delete from ZX_STATUS_TL T

480:
481: procedure ADD_LANGUAGE
482: is
483: begin
484: delete from ZX_STATUS_TL T
485: where not exists
486: (select NULL
487: from ZX_STATUS_B B
488: where B.TAX_STATUS_ID = T.TAX_STATUS_ID

Line 490: update ZX_STATUS_TL T set (

486: (select NULL
487: from ZX_STATUS_B B
488: where B.TAX_STATUS_ID = T.TAX_STATUS_ID
489: );
490: update ZX_STATUS_TL T set (
491: TAX_STATUS_NAME
492: ) = (select
493: B.TAX_STATUS_NAME
494: from ZX_STATUS_TL B

Line 494: from ZX_STATUS_TL B

490: update ZX_STATUS_TL T set (
491: TAX_STATUS_NAME
492: ) = (select
493: B.TAX_STATUS_NAME
494: from ZX_STATUS_TL B
495: where B.TAX_STATUS_ID = T.TAX_STATUS_ID
496: and B.LANGUAGE = T.SOURCE_LANG)
497: where (
498: T.TAX_STATUS_ID,

Line 503: from ZX_STATUS_TL SUBB, ZX_STATUS_TL SUBT

499: T.LANGUAGE
500: ) in (select
501: SUBT.TAX_STATUS_ID,
502: SUBT.LANGUAGE
503: from ZX_STATUS_TL SUBB, ZX_STATUS_TL SUBT
504: where SUBB.TAX_STATUS_ID = SUBT.TAX_STATUS_ID
505: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
506: and (SUBB.TAX_STATUS_NAME <> SUBT.TAX_STATUS_NAME
507: or (SUBB.TAX_STATUS_NAME is null and SUBT.TAX_STATUS_NAME is not null)

Line 510: insert into ZX_STATUS_TL (

506: and (SUBB.TAX_STATUS_NAME <> SUBT.TAX_STATUS_NAME
507: or (SUBB.TAX_STATUS_NAME is null and SUBT.TAX_STATUS_NAME is not null)
508: or (SUBB.TAX_STATUS_NAME is not null and SUBT.TAX_STATUS_NAME is null)
509: ));
510: insert into ZX_STATUS_TL (
511: TAX_STATUS_ID,
512: TAX_STATUS_NAME,
513: CREATED_BY,
514: CREATION_DATE,

Line 530: from ZX_STATUS_TL B, FND_LANGUAGES L

526: B.LAST_UPDATE_DATE,
527: B.LAST_UPDATE_LOGIN,
528: L.LANGUAGE_CODE,
529: B.SOURCE_LANG
530: from ZX_STATUS_TL B, FND_LANGUAGES L
531: where L.INSTALLED_FLAG in ('I', 'B')
532: and B.LANGUAGE = userenv('LANG')
533: and not exists
534: (select NULL

Line 535: from ZX_STATUS_TL T

531: where L.INSTALLED_FLAG in ('I', 'B')
532: and B.LANGUAGE = userenv('LANG')
533: and not exists
534: (select NULL
535: from ZX_STATUS_TL T
536: where T.TAX_STATUS_ID = B.TAX_STATUS_ID
537: and T.LANGUAGE = L.LANGUAGE_CODE);
538: end ADD_LANGUAGE;
539: