APPS.GMD_RECIPE_DETAIL_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 317: INSERT INTO GMD_RECIPE_VALIDITY_RULES(

313:
314: --Added as part of Default Status Build 3408799
315: gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id := l_recipe_vr_id;
316:
317: INSERT INTO GMD_RECIPE_VALIDITY_RULES(
318: RECIPE_VALIDITY_RULE_ID
319: ,RECIPE_ID
320: ,ORGN_CODE
321: ,ORGANIZATION_ID -- NPD Conv.

Line 736: l_vr_db_rec gmd_recipe_validity_rules%ROWTYPE;

732: ) IS
733:
734: /* Define all variables specific to this procedure */
735: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_VR';
736: l_vr_db_rec gmd_recipe_validity_rules%ROWTYPE;
737:
738: p_vr_update_tbl GMD_VALIDITY_RULES_PVT.update_tbl_type;
739: l_row_cnt NUMBER := 1;
740:

Line 746: From gmd_recipe_validity_rules

742: l_msg_list VARCHAR2(2000);
743:
744: Cursor get_db_vr_rec(pVR_id NUMBER) IS
745: Select *
746: From gmd_recipe_validity_rules
747: Where recipe_validity_rule_id = pVR_id;
748:
749: BEGIN
750: /* Initialization of all status */