APPS.ZX_FORMULA_PKG dependencies on ZX_FORMULA_TL

Line 165: insert into ZX_FORMULA_TL (

161: NVL(X_ENABLED_FLAG,'N'),
162: X_CONTENT_OWNER_ID,
163: X_OBJECT_VERSION_NUMBER);
164:
165: insert into ZX_FORMULA_TL (
166: FORMULA_ID,
167: FORMULA_NAME,
168: FORMULA_DESCRIPTION,
169: CREATION_DATE,

Line 191: from ZX_FORMULA_TL T

187: from FND_LANGUAGES L
188: where L.INSTALLED_FLAG in ('I', 'B')
189: and not exists
190: (select NULL
191: from ZX_FORMULA_TL T
192: where T.FORMULA_ID = X_FORMULA_ID
193: and T.LANGUAGE = L.LANGUAGE_CODE);
194: open c;
195: fetch c into X_ROWID;

Line 311: from ZX_FORMULA_TL

307:
308: cursor c1 is select FORMULA_NAME,
309: FORMULA_DESCRIPTION,
310: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
311: from ZX_FORMULA_TL
312: where FORMULA_ID = X_FORMULA_ID
313: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
314: for update of FORMULA_ID nowait;
315: begin

Line 644: update ZX_FORMULA_TL

640: if (sql%notfound) then
641: raise no_data_found;
642: end if;
643:
644: update ZX_FORMULA_TL
645: set FORMULA_NAME = X_FORMULA_NAME,
646: FORMULA_DESCRIPTION = X_FORMULA_DESCRIPTION,
647: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
648: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 669: delete from ZX_FORMULA_TL

665: X_FORMULA_ID in NUMBER) is
666:
667: begin
668:
669: delete from ZX_FORMULA_TL
670: where FORMULA_ID = X_FORMULA_ID;
671:
672: if (sql%notfound) then
673: raise no_data_found;

Line 692: delete from ZX_FORMULA_TL T

688:
689: procedure ADD_LANGUAGE
690: is
691: begin
692: delete from ZX_FORMULA_TL T
693: where not exists (select NULL
694: from ZX_FORMULA_B B
695: where B.FORMULA_ID = T.FORMULA_ID);
696:

Line 697: update ZX_FORMULA_TL T

693: where not exists (select NULL
694: from ZX_FORMULA_B B
695: where B.FORMULA_ID = T.FORMULA_ID);
696:
697: update ZX_FORMULA_TL T
698: set (FORMULA_NAME, FORMULA_DESCRIPTION) =
699: (select B.FORMULA_NAME,
700: B.FORMULA_DESCRIPTION
701: from ZX_FORMULA_TL B

Line 701: from ZX_FORMULA_TL B

697: update ZX_FORMULA_TL T
698: set (FORMULA_NAME, FORMULA_DESCRIPTION) =
699: (select B.FORMULA_NAME,
700: B.FORMULA_DESCRIPTION
701: from ZX_FORMULA_TL B
702: where B.FORMULA_ID = T.FORMULA_ID
703: and B.LANGUAGE = T.SOURCE_LANG)
704: where (T.FORMULA_ID,T.LANGUAGE) in
705: (select SUBT.FORMULA_ID,

Line 707: from ZX_FORMULA_TL SUBB, ZX_FORMULA_TL SUBT

703: and B.LANGUAGE = T.SOURCE_LANG)
704: where (T.FORMULA_ID,T.LANGUAGE) in
705: (select SUBT.FORMULA_ID,
706: SUBT.LANGUAGE
707: from ZX_FORMULA_TL SUBB, ZX_FORMULA_TL SUBT
708: where SUBB.FORMULA_ID = SUBT.FORMULA_ID
709: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
710: and (SUBB.FORMULA_NAME <> SUBT.FORMULA_NAME
711: or SUBB.FORMULA_DESCRIPTION <> SUBT.FORMULA_DESCRIPTION

Line 717: insert into ZX_FORMULA_TL (FORMULA_ID,

713: and SUBT.FORMULA_DESCRIPTION is not null)
714: or (SUBB.FORMULA_DESCRIPTION is not null
715: and SUBT.FORMULA_DESCRIPTION is null)));
716:
717: insert into ZX_FORMULA_TL (FORMULA_ID,
718: FORMULA_NAME,
719: FORMULA_DESCRIPTION,
720: CREATION_DATE,
721: CREATED_BY,

Line 737: from ZX_FORMULA_TL B, FND_LANGUAGES L

733: B.LAST_UPDATED_BY,
734: B.LAST_UPDATE_LOGIN,
735: L.LANGUAGE_CODE,
736: B.SOURCE_LANG
737: from ZX_FORMULA_TL B, FND_LANGUAGES L
738: where L.INSTALLED_FLAG in ('I', 'B')
739: and B.LANGUAGE = userenv('LANG')
740: and not exists (select NULL
741: from ZX_FORMULA_TL T

Line 741: from ZX_FORMULA_TL T

737: from ZX_FORMULA_TL B, FND_LANGUAGES L
738: where L.INSTALLED_FLAG in ('I', 'B')
739: and B.LANGUAGE = userenv('LANG')
740: and not exists (select NULL
741: from ZX_FORMULA_TL T
742: where T.FORMULA_ID = B.FORMULA_ID
743: and T.LANGUAGE = L.LANGUAGE_CODE);
744:
745: EXCEPTION

Line 901: insert into ZX_FORMULA_TL (FORMULA_ID,

897: fnd_global.conc_login_id
898: );
899:
900: forall i in x_formula_id.first..x_formula_id.last
901: insert into ZX_FORMULA_TL (FORMULA_ID,
902: FORMULA_NAME,
903: FORMULA_DESCRIPTION,
904: LANGUAGE,
905: SOURCE_LANG,

Line 925: from ZX_FORMULA_TL T

921: from FND_LANGUAGES L
922: where L.INSTALLED_FLAG in ('I', 'B')
923: and not exists
924: (select NULL
925: from ZX_FORMULA_TL T
926: where T.FORMULA_ID = X_FORMULA_ID(i)
927: and T.LANGUAGE = L.LANGUAGE_CODE);
928: end if;
929: