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 631: delete from FM_FORM_MST_TL T

627: EXCEPTION
628: WHEN OTHERS THEN
629: RAISE_APPLICATION_ERROR(-20101, NULL);
630: END;
631: delete from FM_FORM_MST_TL T
632: where not exists
633: (select NULL
634: from FM_FORM_MST_B B
635: where B.FORMULA_ID = T.FORMULA_ID

Line 638: update FM_FORM_MST_TL T set (

634: from FM_FORM_MST_B B
635: where B.FORMULA_ID = T.FORMULA_ID
636: );
637:
638: update FM_FORM_MST_TL T set (
639: FORMULA_DESC1,
640: FORMULA_DESC2
641: ) = (select
642: B.FORMULA_DESC1,

Line 644: from FM_FORM_MST_TL B

640: FORMULA_DESC2
641: ) = (select
642: B.FORMULA_DESC1,
643: B.FORMULA_DESC2
644: from FM_FORM_MST_TL B
645: where B.FORMULA_ID = T.FORMULA_ID
646: and B.LANGUAGE = T.SOURCE_LANG)
647: where (
648: T.FORMULA_ID,

Line 653: from FM_FORM_MST_TL SUBB, FM_FORM_MST_TL SUBT

649: T.LANGUAGE
650: ) in (select
651: SUBT.FORMULA_ID,
652: SUBT.LANGUAGE
653: from FM_FORM_MST_TL SUBB, FM_FORM_MST_TL SUBT
654: where SUBB.FORMULA_ID = SUBT.FORMULA_ID
655: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
656: and (SUBB.FORMULA_DESC1 <> SUBT.FORMULA_DESC1
657: or SUBB.FORMULA_DESC2 <> SUBT.FORMULA_DESC2

Line 662: insert into FM_FORM_MST_TL (

658: or (SUBB.FORMULA_DESC2 is null and SUBT.FORMULA_DESC2 is not null)
659: or (SUBB.FORMULA_DESC2 is not null and SUBT.FORMULA_DESC2 is null)
660: ));
661:
662: insert into FM_FORM_MST_TL (
663: FORMULA_ID,
664: LAST_UPDATE_DATE,
665: LAST_UPDATE_LOGIN,
666: CREATION_DATE,

Line 684: from FM_FORM_MST_TL B, FND_LANGUAGES L

680: B.FORMULA_DESC1,
681: B.FORMULA_DESC2,
682: L.LANGUAGE_CODE,
683: B.SOURCE_LANG
684: from FM_FORM_MST_TL B, FND_LANGUAGES L
685: where L.INSTALLED_FLAG in ('I', 'B')
686: and B.LANGUAGE = userenv('LANG')
687: and not exists
688: (select NULL

Line 689: from FM_FORM_MST_TL T

685: where L.INSTALLED_FLAG in ('I', 'B')
686: and B.LANGUAGE = userenv('LANG')
687: and not exists
688: (select NULL
689: from FM_FORM_MST_TL T
690: where T.FORMULA_ID = B.FORMULA_ID
691: and T.LANGUAGE = L.LANGUAGE_CODE);
692: end ADD_LANGUAGE;
693: