APPS.GMD_RECIPE_DETAIL_PVT dependencies on GMD_RECIPE_VAL

Line 160: GMD_RECIPE_VAL.RECIPE_CUST_EXISTS (

156: /* ====================================== */
157: /* Check if this customer exists in our */
158: /* Recipe Customer table */
159: /* ====================================== */
160: GMD_RECIPE_VAL.RECIPE_CUST_EXISTS (
161: P_API_VERSION => 1.0 ,
162: P_RECIPE_ID => p_recipe_detail_rec.recipe_id ,
163: P_CUSTOMER_ID => p_recipe_detail_rec.customer_ID ,
164: X_RETURN_STATUS => l_return_status ,

Line 274: GMD_RECIPE_VAL.recipe_orgn_code(

270: /* Organization should be either a Plant/Lab type */
271: /* Can orgn_code be a null value ? */
272: /* Set the required indicator */
273: /* ============================================== */
274: GMD_RECIPE_VAL.recipe_orgn_code(
275: p_api_version => 1.0,
276: p_init_msg_list => FND_API.G_FALSE,
277: p_commit => FND_API.G_FALSE,
278: g_orgn_id => p_recipe_vr_rec.organization_id,

Line 310: SELECT gmd_recipe_validity_id_s.nextval

306: /* ======================================== */
307: /* Generate the Validity Rule Id */
308: /* Sequence number */
309: /* ======================================== */
310: SELECT gmd_recipe_validity_id_s.nextval
311: INTO l_recipe_vr_id
312: FROM sys.dual;
313:
314: --Added as part of Default Status Build 3408799

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 */