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