APPS.FM_FORM_MST_MLS dependencies on FM_FORM_MST_TL

Line 184: insert into FM_FORM_MST_TL (

180: X_LAST_UPDATE_LOGIN,
181: X_AUTO_PRODUCT_CALC
182: );
183:
184: insert into FM_FORM_MST_TL (
185: FORMULA_ID,
186: LAST_UPDATE_DATE,
187: LAST_UPDATE_LOGIN,
188: CREATION_DATE,

Line 210: from FM_FORM_MST_TL T

206: from FND_LANGUAGES L
207: where L.INSTALLED_FLAG in ('I', 'B')
208: and not exists
209: (select NULL
210: from FM_FORM_MST_TL T
211: where T.FORMULA_ID = X_FORMULA_ID
212: and T.LANGUAGE = L.LANGUAGE_CODE);
213:
214: open c;

Line 339: from FM_FORM_MST_TL

335: cursor c1 is select
336: FORMULA_DESC1,
337: FORMULA_DESC2,
338: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
339: from FM_FORM_MST_TL
340: where FORMULA_ID = X_FORMULA_ID
341: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
342: for update of FORMULA_ID nowait;
343: begin

Line 587: update FM_FORM_MST_TL set

583: if (sql%notfound) then
584: raise no_data_found;
585: end if;
586:
587: update FM_FORM_MST_TL set
588: FORMULA_DESC1 = X_FORMULA_DESC1,
589: FORMULA_DESC2 = X_FORMULA_DESC2,
590: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
591: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 606: delete from FM_FORM_MST_TL

602: procedure DELETE_ROW (
603: X_FORMULA_ID in NUMBER
604: ) is
605: begin
606: delete from FM_FORM_MST_TL
607: where FORMULA_ID = X_FORMULA_ID;
608:
609: if (sql%notfound) then
610: raise no_data_found;

Line 624: delete from FM_FORM_MST_TL T

620:
621: procedure ADD_LANGUAGE
622: is
623: begin
624: delete from FM_FORM_MST_TL T
625: where not exists
626: (select NULL
627: from FM_FORM_MST_B B
628: where B.FORMULA_ID = T.FORMULA_ID

Line 631: update FM_FORM_MST_TL T set (

627: from FM_FORM_MST_B B
628: where B.FORMULA_ID = T.FORMULA_ID
629: );
630:
631: update FM_FORM_MST_TL T set (
632: FORMULA_DESC1,
633: FORMULA_DESC2
634: ) = (select
635: B.FORMULA_DESC1,

Line 637: from FM_FORM_MST_TL B

633: FORMULA_DESC2
634: ) = (select
635: B.FORMULA_DESC1,
636: B.FORMULA_DESC2
637: from FM_FORM_MST_TL B
638: where B.FORMULA_ID = T.FORMULA_ID
639: and B.LANGUAGE = T.SOURCE_LANG)
640: where (
641: T.FORMULA_ID,

Line 646: from FM_FORM_MST_TL SUBB, FM_FORM_MST_TL SUBT

642: T.LANGUAGE
643: ) in (select
644: SUBT.FORMULA_ID,
645: SUBT.LANGUAGE
646: from FM_FORM_MST_TL SUBB, FM_FORM_MST_TL SUBT
647: where SUBB.FORMULA_ID = SUBT.FORMULA_ID
648: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
649: and (SUBB.FORMULA_DESC1 <> SUBT.FORMULA_DESC1
650: or SUBB.FORMULA_DESC2 <> SUBT.FORMULA_DESC2

Line 655: insert into FM_FORM_MST_TL (

651: or (SUBB.FORMULA_DESC2 is null and SUBT.FORMULA_DESC2 is not null)
652: or (SUBB.FORMULA_DESC2 is not null and SUBT.FORMULA_DESC2 is null)
653: ));
654:
655: insert into FM_FORM_MST_TL (
656: FORMULA_ID,
657: LAST_UPDATE_DATE,
658: LAST_UPDATE_LOGIN,
659: CREATION_DATE,

Line 677: from FM_FORM_MST_TL B, FND_LANGUAGES L

673: B.FORMULA_DESC1,
674: B.FORMULA_DESC2,
675: L.LANGUAGE_CODE,
676: B.SOURCE_LANG
677: from FM_FORM_MST_TL B, FND_LANGUAGES L
678: where L.INSTALLED_FLAG in ('I', 'B')
679: and B.LANGUAGE = userenv('LANG')
680: and not exists
681: (select NULL

Line 682: from FM_FORM_MST_TL T

678: where L.INSTALLED_FLAG in ('I', 'B')
679: and B.LANGUAGE = userenv('LANG')
680: and not exists
681: (select NULL
682: from FM_FORM_MST_TL T
683: where T.FORMULA_ID = B.FORMULA_ID
684: and T.LANGUAGE = L.LANGUAGE_CODE);
685: end ADD_LANGUAGE;
686: