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_RECIPE_DESIGNER_PKG dependencies on GMD_RECIPES

Line 736: FROM gmd_recipes_b

732: x_error_msg OUT NOCOPY VARCHAR2) IS
733:
734: CURSOR Get_RoutingId IS
735: SELECT routing_id, planned_process_loss, owner_organization_id
736: FROM gmd_recipes_b
737: WHERE recipe_id = p_recipe_id;
738:
739: l_routing_id NUMBER(10) := 0;
740: l_charge_tbl GMD_COMMON_VAL.charge_tbl;

Line 1198: gmd_recipes

1194: CURSOR Get_RoutingId IS
1195: SELECT
1196: routing_id
1197: FROM
1198: gmd_recipes
1199: WHERE
1200: recipe_id = p_recipe_id;
1201:
1202: l_charge_tbl GMD_COMMON_VAL.charge_tbl;

Line 1531: gmd_recipes

1527: CURSOR Get_RoutingId IS
1528: SELECT
1529: routing_id
1530: FROM
1531: gmd_recipes
1532: WHERE
1533: recipe_id = p_recipe_id;
1534:
1535: l_routing_id NUMBER(10) := 0;

Line 1730: | Update a row in GMD_RECIPES

Line 1788: FROM GMD_RECIPES

1784: p_recipe_type IN NUMBER) IS
1785:
1786: CURSOR Get_Recipe IS
1787: SELECT *
1788: FROM GMD_RECIPES
1789: WHERE
1790: recipe_id = p_recipe_id AND
1791: last_update_date = p_last_update_date_origin;
1792:

Line 1793: l_recipe_rec GMD_RECIPES%ROWTYPE;

1789: WHERE
1790: recipe_id = p_recipe_id AND
1791: last_update_date = p_last_update_date_origin;
1792:
1793: l_recipe_rec GMD_RECIPES%ROWTYPE;
1794: l_recipe_tbl GMD_RECIPE_HEADER.recipe_hdr;
1795: l_recipe_update_flex GMD_RECIPE_HEADER.update_flex;
1796:
1797: l_return_status VARCHAR2(2);

Line 1935: GMD_RECIPES_B

1931: IF l_recipe_rec.recipe_no <> p_recipe_no OR
1932: l_recipe_rec.recipe_version <> p_recipe_version THEN
1933:
1934: UPDATE
1935: GMD_RECIPES_B
1936: SET
1937: recipe_no = p_recipe_no,
1938: recipe_version = p_recipe_version
1939: WHERE

Line 2039: l_recipe_rec GMD_RECIPES%ROWTYPE;

2035: l_return_status VARCHAR2(5);
2036: l_owner_orgn_code VARCHAR2(4);
2037: l_timestamp DATE;
2038: l_recipe_no VARCHAR2(32);
2039: l_recipe_rec GMD_RECIPES%ROWTYPE;
2040: INSERT_RECIPE_EXCEPTION EXCEPTION;
2041:
2042: l_message_count NUMBER;
2043: l_message_list VARCHAR2(2000);

Line 2128: GMD_RECIPES_MLS.Insert_Row(

2124: l_user_id,
2125: l_login_id);
2126: -- End BUg 3843246
2127:
2128: GMD_RECIPES_MLS.Insert_Row(
2129: X_ROWID => l_rowid,
2130: X_RECIPE_ID => x_recipe_id,
2131: X_RECIPE_NO => l_recipe_no,
2132: X_RECIPE_VERSION => 1,

Line 2744: gmd_recipes

2740:
2741: CURSOR Get_Recipe IS
2742: SELECT *
2743: FROM
2744: gmd_recipes
2745: WHERE
2746: recipe_id = p_recipe_id AND
2747: last_update_date = p_last_update_date_orig;
2748:

Line 2751: l_recipe_rec GMD_RECIPES%ROWTYPE;

2747: last_update_date = p_last_update_date_orig;
2748:
2749: l_recipe_hdr GMD_RECIPE_HEADER.recipe_hdr;
2750: l_recipe_flex GMD_RECIPE_HEADER.update_flex;
2751: l_recipe_rec GMD_RECIPES%ROWTYPE;
2752:
2753: l_status VARCHAR2(30);
2754: l_msg_cnt NUMBER;
2755: l_msg_dat VARCHAR2(30);

Line 2893: gmd_recipes

2889:
2890: CURSOR Get_Recipe IS
2891: SELECT *
2892: FROM
2893: gmd_recipes
2894: WHERE
2895: recipe_id = p_recipe_id AND
2896: last_update_date = p_last_update_date_orig;
2897:

Line 2900: l_recipe_rec GMD_RECIPES%ROWTYPE;

2896: last_update_date = p_last_update_date_orig;
2897:
2898: l_recipe_hdr GMD_RECIPE_HEADER.recipe_hdr;
2899: l_recipe_flex GMD_RECIPE_HEADER.update_flex;
2900: l_recipe_rec GMD_RECIPES%ROWTYPE;
2901: l_status VARCHAR2(30);
2902: l_msg_cnt NUMBER;
2903: l_msg_dat VARCHAR2(30);
2904: l_message VARCHAR2(1000);

Line 3220: FROM gmd_recipes

3216: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
3217:
3218: CURSOR Cur_get_rcp_hdr IS
3219: SELECT *
3220: FROM gmd_recipes
3221: WHERE recipe_id = p_copy_from_recipe_id;
3222:
3223: CURSOR Cur_get_pp IS
3224: SELECT *

Line 4274: l_table_lnk := 'gmd_recipes' || '|' || x_recipe_id;

4270:
4271: FOR i IN 1..l_rcp_hdr_text_tbl.COUNT LOOP
4272:
4273: l_txt_ind := l_txt_ind + 1;
4274: l_table_lnk := 'gmd_recipes' || '|' || x_recipe_id;
4275:
4276: ---
4277: --- Create recipe header text
4278: ---

Line 4305: DELETE gmd_recipes_b WHERE recipe_id = p_copy_from_recipe_id;

4301: --- Create recipe header record
4302: ---
4303:
4304: IF NOT l_copy_recipe THEN
4305: DELETE gmd_recipes_b WHERE recipe_id = p_copy_from_recipe_id;
4306: END IF;
4307:
4308: IF x_routing_id <= 0 THEN
4309: l_recipe_tbl.ROUTING_ID := NULL;

Line 5450: FROM gmd_recipes_b

5446: x_return_code OUT NOCOPY VARCHAR2) IS
5447:
5448: CURSOR Cur_get_recp_orgn IS
5449: SELECT owner_organization_id
5450: FROM gmd_recipes_b
5451: WHERE recipe_id = p_recipe_id;
5452:
5453: l_orgn_id NUMBER;
5454: l_return_status VARCHAR2(10);

Line 5483: FROM gmd_recipes_b

5479: x_return_code OUT NOCOPY VARCHAR2) IS
5480:
5481: CURSOR get_recipe_details (l_recipe_id NUMBER) IS
5482: SELECT formula_id, owner_organization_id
5483: FROM gmd_recipes_b
5484: WHERE recipe_id = l_recipe_id;
5485:
5486: l_orgn_id NUMBER;
5487: l_formula_id NUMBER;

Line 5546: FROM gmd_recipes_b

5542: WHERE formula_id = vFormula_id;
5543:
5544: CURSOR get_recipe_details(vRecipe_id NUMBER) IS
5545: SELECT owner_organization_id
5546: FROM gmd_recipes_b
5547: WHERE recipe_id = vRecipe_id;
5548:
5549: CURSOR get_routing_details(vRouting_id NUMBER) IS
5550: SELECT owner_organization_id