APPS.GMD_RECIPE_DESIGNER_PKG dependencies on GMD_RECIPE_ORGN_ACTIVITIES

Line 3235: FROM gmd_recipe_orgn_activities

3231: WHERE recipe_id = p_copy_from_recipe_id;
3232:
3233: CURSOR Cur_get_actv IS
3234: SELECT *
3235: FROM gmd_recipe_orgn_activities
3236: WHERE recipe_id = p_copy_from_recipe_id;
3237:
3238: CURSOR Cur_get_rsrc IS
3239: SELECT *

Line 5131: DELETE gmd_recipe_orgn_activities

5127: ---
5128: --- Insert organization specific activity information
5129: ---
5130:
5131: DELETE gmd_recipe_orgn_activities
5132: WHERE recipe_id = p_copy_from_recipe_id;
5133:
5134: FOR i IN 1..l_rcp_actv_tbl.COUNT LOOP
5135:

Line 5142: l_table_lnk := 'gmd_recipe_orgn_activities' || '|' ||

5138: OPEN Get_Text_Code;
5139: FETCH Get_Text_Code INTO l_text_code;
5140: CLOSE Get_Text_Code;
5141:
5142: l_table_lnk := 'gmd_recipe_orgn_activities' || '|' ||
5143: x_recipe_id ||
5144: '|' || l_rcp_actv_tbl(i).oprn_line_id;
5145:
5146: WHILE (l_txt_ind <= l_rcp_actv_text_tbl.COUNT AND

Line 5180: INSERT INTO gmd_recipe_orgn_activities

5176: ---
5177: --- Create activity
5178: ---
5179:
5180: INSERT INTO gmd_recipe_orgn_activities
5181: ( recipe_id,
5182: routingstep_id,
5183: oprn_line_id,
5184: activity_factor,