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 726: l_vr_db_rec gmd_recipe_validity_rules%ROWTYPE;

722: ) IS
723:
724: /* Define all variables specific to this procedure */
725: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_VR';
726: l_vr_db_rec gmd_recipe_validity_rules%ROWTYPE;
727:
728: p_vr_update_tbl GMD_VALIDITY_RULES_PVT.update_tbl_type;
729: l_row_cnt NUMBER := 1;
730:

Line 736: From gmd_recipe_validity_rules

732: l_msg_list VARCHAR2(2000);
733:
734: Cursor get_db_vr_rec(pVR_id NUMBER) IS
735: Select *
736: From gmd_recipe_validity_rules
737: Where recipe_validity_rule_id = pVR_id;
738:
739: BEGIN
740: /* Initialization of all status */