eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_RECIPES_MLS dependencies on GMD_RECIPES_TL

Line 184: insert into GMD_RECIPES_TL (

180: X_FIXED_PROCESS_LOSS_UOM
181: );
182:
183:
184: insert into GMD_RECIPES_TL (
185: RECIPE_ID,
186: RECIPE_DESCRIPTION,
187: SOURCE_LANG,
188: CREATED_BY,

Line 208: from GMD_RECIPES_TL T

204: from FND_LANGUAGES L
205: where L.INSTALLED_FLAG in ('I', 'B')
206: and not exists
207: (select NULL
208: from GMD_RECIPES_TL T
209: where T.RECIPE_ID = X_RECIPE_ID
210: and T.LANGUAGE = L.LANGUAGE_CODE);
211:
212: open c;

Line 334: from GMD_RECIPES_TL

330:
331: cursor c1 is select
332: RECIPE_DESCRIPTION,
333: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
334: from GMD_RECIPES_TL
335: where RECIPE_ID = X_RECIPE_ID
336: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
337: for update of RECIPE_ID nowait;
338: begin

Line 579: update GMD_RECIPES_TL set

575: if (sql%notfound) then
576: raise no_data_found;
577: end if;
578:
579: update GMD_RECIPES_TL set
580: RECIPE_DESCRIPTION = X_RECIPE_DESCRIPTION,
581: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
582: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
583: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 597: delete from GMD_RECIPES_TL

593: procedure DELETE_ROW (
594: X_RECIPE_ID in NUMBER
595: ) is
596: begin
597: delete from GMD_RECIPES_TL
598: where RECIPE_ID = X_RECIPE_ID;
599:
600: if (sql%notfound) then
601: raise no_data_found;

Line 615: delete from GMD_RECIPES_TL T

611:
612: procedure ADD_LANGUAGE
613: is
614: begin
615: delete from GMD_RECIPES_TL T
616: where not exists
617: (select NULL
618: from GMD_RECIPES_B B
619: where B.RECIPE_ID = T.RECIPE_ID

Line 622: update GMD_RECIPES_TL T set (

618: from GMD_RECIPES_B B
619: where B.RECIPE_ID = T.RECIPE_ID
620: );
621:
622: update GMD_RECIPES_TL T set (
623: RECIPE_DESCRIPTION
624: ) = (select
625: B.RECIPE_DESCRIPTION
626: from GMD_RECIPES_TL B

Line 626: from GMD_RECIPES_TL B

622: update GMD_RECIPES_TL T set (
623: RECIPE_DESCRIPTION
624: ) = (select
625: B.RECIPE_DESCRIPTION
626: from GMD_RECIPES_TL B
627: where B.RECIPE_ID = T.RECIPE_ID
628: and B.LANGUAGE = T.SOURCE_LANG)
629: where (
630: T.RECIPE_ID,

Line 635: from GMD_RECIPES_TL SUBB, GMD_RECIPES_TL SUBT

631: T.LANGUAGE
632: ) in (select
633: SUBT.RECIPE_ID,
634: SUBT.LANGUAGE
635: from GMD_RECIPES_TL SUBB, GMD_RECIPES_TL SUBT
636: where SUBB.RECIPE_ID = SUBT.RECIPE_ID
637: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
638: and (SUBB.RECIPE_DESCRIPTION <> SUBT.RECIPE_DESCRIPTION
639: ));

Line 641: insert into GMD_RECIPES_TL (

637: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
638: and (SUBB.RECIPE_DESCRIPTION <> SUBT.RECIPE_DESCRIPTION
639: ));
640:
641: insert into GMD_RECIPES_TL (
642: RECIPE_ID,
643: RECIPE_DESCRIPTION,
644: SOURCE_LANG,
645: CREATED_BY,

Line 661: from GMD_RECIPES_TL B, FND_LANGUAGES L

657: B.LAST_UPDATED_BY,
658: B.LAST_UPDATE_DATE,
659: B.LAST_UPDATE_LOGIN,
660: L.LANGUAGE_CODE
661: from GMD_RECIPES_TL B, FND_LANGUAGES L
662: where L.INSTALLED_FLAG in ('I', 'B')
663: and B.LANGUAGE = userenv('LANG')
664: and not exists
665: (select NULL

Line 666: from GMD_RECIPES_TL T

662: where L.INSTALLED_FLAG in ('I', 'B')
663: and B.LANGUAGE = userenv('LANG')
664: and not exists
665: (select NULL
666: from GMD_RECIPES_TL T
667: where T.RECIPE_ID = B.RECIPE_ID
668: and T.LANGUAGE = L.LANGUAGE_CODE);
669: end ADD_LANGUAGE;
670: