APPS.GMD_RECIPE_DESIGNER_PKG dependencies on GMD_RECIPE_ORGN_RESOURCES

Line 3240: FROM gmd_recipe_orgn_resources

3236: WHERE recipe_id = p_copy_from_recipe_id;
3237:
3238: CURSOR Cur_get_rsrc IS
3239: SELECT *
3240: FROM gmd_recipe_orgn_resources
3241: WHERE recipe_id = p_copy_from_recipe_id;
3242:
3243: CURSOR Cur_get_rcp_stp IS
3244: SELECT *

Line 4968: DELETE gmd_recipe_orgn_resources WHERE recipe_id = p_copy_from_recipe_id;

4964: ---
4965: --- Insert organization specific resource information
4966: ---
4967:
4968: DELETE gmd_recipe_orgn_resources WHERE recipe_id = p_copy_from_recipe_id;
4969:
4970: FOR i IN 1..l_rcp_rsrc_tbl.COUNT LOOP
4971:
4972: IF (l_rcp_rsrc_tbl(i).text_code > 0) THEN

Line 4978: l_table_lnk := 'gmd_recipe_orgn_resources' || '|' ||

4974: OPEN Get_Text_Code;
4975: FETCH Get_Text_Code INTO l_text_code;
4976: CLOSE Get_Text_Code;
4977:
4978: l_table_lnk := 'gmd_recipe_orgn_resources' || '|' ||
4979: x_recipe_id ||
4980: '|' || l_rcp_rsrc_tbl(i).routingstep_id;
4981:
4982: WHILE (l_txt_ind <= l_rcp_rsrc_text_tbl.COUNT AND

Line 5016: INSERT INTO gmd_recipe_orgn_resources

5012: ---
5013: --- Create resource
5014: ---
5015:
5016: INSERT INTO gmd_recipe_orgn_resources
5017: ( recipe_id,
5018: organization_id,
5019: routingstep_id,
5020: oprn_line_id,