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 622: delete from GMD_RECIPES_TL T

618: EXCEPTION
619: WHEN OTHERS THEN
620: RAISE_APPLICATION_ERROR(-20101, NULL);
621: END;
622: delete from GMD_RECIPES_TL T
623: where not exists
624: (select NULL
625: from GMD_RECIPES_B B
626: where B.RECIPE_ID = T.RECIPE_ID

Line 629: update GMD_RECIPES_TL T set (

625: from GMD_RECIPES_B B
626: where B.RECIPE_ID = T.RECIPE_ID
627: );
628:
629: update GMD_RECIPES_TL T set (
630: RECIPE_DESCRIPTION
631: ) = (select
632: B.RECIPE_DESCRIPTION
633: from GMD_RECIPES_TL B

Line 633: from GMD_RECIPES_TL B

629: update GMD_RECIPES_TL T set (
630: RECIPE_DESCRIPTION
631: ) = (select
632: B.RECIPE_DESCRIPTION
633: from GMD_RECIPES_TL B
634: where B.RECIPE_ID = T.RECIPE_ID
635: and B.LANGUAGE = T.SOURCE_LANG)
636: where (
637: T.RECIPE_ID,

Line 642: from GMD_RECIPES_TL SUBB, GMD_RECIPES_TL SUBT

638: T.LANGUAGE
639: ) in (select
640: SUBT.RECIPE_ID,
641: SUBT.LANGUAGE
642: from GMD_RECIPES_TL SUBB, GMD_RECIPES_TL SUBT
643: where SUBB.RECIPE_ID = SUBT.RECIPE_ID
644: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
645: and (SUBB.RECIPE_DESCRIPTION <> SUBT.RECIPE_DESCRIPTION
646: ));

Line 648: insert into GMD_RECIPES_TL (

644: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
645: and (SUBB.RECIPE_DESCRIPTION <> SUBT.RECIPE_DESCRIPTION
646: ));
647:
648: insert into GMD_RECIPES_TL (
649: RECIPE_ID,
650: RECIPE_DESCRIPTION,
651: SOURCE_LANG,
652: CREATED_BY,

Line 668: from GMD_RECIPES_TL B, FND_LANGUAGES L

664: B.LAST_UPDATED_BY,
665: B.LAST_UPDATE_DATE,
666: B.LAST_UPDATE_LOGIN,
667: L.LANGUAGE_CODE
668: from GMD_RECIPES_TL B, FND_LANGUAGES L
669: where L.INSTALLED_FLAG in ('I', 'B')
670: and B.LANGUAGE = userenv('LANG')
671: and not exists
672: (select NULL

Line 673: from GMD_RECIPES_TL T

669: where L.INSTALLED_FLAG in ('I', 'B')
670: and B.LANGUAGE = userenv('LANG')
671: and not exists
672: (select NULL
673: from GMD_RECIPES_TL T
674: where T.RECIPE_ID = B.RECIPE_ID
675: and T.LANGUAGE = L.LANGUAGE_CODE);
676: end ADD_LANGUAGE;
677: