DBA Data[Home] [Help]

APPS.GMD_RECIPE_MIGRATION dependencies on GMD_RECIPES_TL

Line 337: INSERT INTO gmd_recipes_tl (recipe_id, recipe_description, source_lang, created_by, creation_date,

333: VALUES (l_recipe_id, l_recipe_no, l_recipe_version, l_owner_orgn_code, l_creation_orgn_code,
334: formula_rec.formula_id, formula_rec.routing_id, l_recipe_status, 0, l_owner_id,
335: l_delete_mark, l_creation_date, l_created_by, l_last_update_date, l_last_updated_by, l_last_update_login);
336:
337: INSERT INTO gmd_recipes_tl (recipe_id, recipe_description, source_lang, created_by, creation_date,
338: last_updated_by, last_update_date, last_update_login, language
339: )
340: SELECT l_recipe_id, formula_rec.formula_desc1, userenv('lang'), l_created_by, l_creation_date,
341: l_last_updated_by, l_last_update_date, l_last_update_login, l.language_code

Line 345: FROM gmd_recipes_tl t

341: l_last_updated_by, l_last_update_date, l_last_update_login, l.language_code
342: FROM fnd_languages l
343: WHERE l.installed_flag in ('I', 'B')
344: AND NOT EXISTS (SELECT null
345: FROM gmd_recipes_tl t
346: WHERE t.recipe_id = l_recipe_id
347: AND t.language = l.language_code);
348: END IF;
349:

Line 473: INSERT INTO gmd_recipes_tl (recipe_id, recipe_description, source_lang, created_by, creation_date,

469: VALUES (l_recipe_id, l_recipe_no, l_recipe_version, l_owner_orgn_code, l_creation_orgn_code,
470: product_rec.formula_id, product_rec.routing_id, l_recipe_status, 0, l_owner_id,
471: l_delete_mark, l_creation_date, l_created_by, l_last_update_date, l_last_updated_by, l_last_update_login);
472:
473: INSERT INTO gmd_recipes_tl (recipe_id, recipe_description, source_lang, created_by, creation_date,
474: last_updated_by, last_update_date, last_update_login, language
475: )
476: SELECT l_recipe_id, product_rec.item_desc1, userenv('lang'), l_created_by, l_creation_date,
477: l_last_updated_by, l_last_update_date, l_last_update_login, l.language_code

Line 481: FROM gmd_recipes_tl t

477: l_last_updated_by, l_last_update_date, l_last_update_login, l.language_code
478: FROM fnd_languages l
479: WHERE l.installed_flag in ('I', 'B')
480: AND NOT EXISTS (SELECT null
481: FROM gmd_recipes_tl t
482: WHERE t.recipe_id = l_recipe_id
483: AND t.language = l.language_code);
484:
485: END IF;