APPS.GMD_RECIPE_MIGRATION dependencies on GMDFMVAL_PUB

Line 279: /* function gmdfmval_pub.locked_effectivity_val gets the recipe status */

275: /* Get the recipe id from the sequence */
276: SELECT gmd_recipe_id_s.NEXTVAL
277: INTO l_recipe_id
278: FROM sys.DUAL;
279: /* function gmdfmval_pub.locked_effectivity_val gets the recipe status */
280: /* This function return non zero value when the effectivity is locked */
281:
282: l_return_val := gmdfmval_pub.locked_effectivity_val (
283: formula_rec.formula_id );

Line 282: l_return_val := gmdfmval_pub.locked_effectivity_val (

278: FROM sys.DUAL;
279: /* function gmdfmval_pub.locked_effectivity_val gets the recipe status */
280: /* This function return non zero value when the effectivity is locked */
281:
282: l_return_val := gmdfmval_pub.locked_effectivity_val (
283: formula_rec.formula_id );
284:
285: IF ( l_return_val <> 0 )
286: THEN

Line 412: /* function gmdfmval_pub.locked_effectivity_val gets the recipe status */

408:
409: SELECT gmd_recipe_id_s.NEXTVAL
410: INTO l_recipe_id
411: FROM sys.DUAL;
412: /* function gmdfmval_pub.locked_effectivity_val gets the recipe status */
413: /* This function return non zero value when the effectivity is locked */
414:
415: l_return_val := gmdfmval_pub.locked_effectivity_val (
416: product_rec.formula_id );

Line 415: l_return_val := gmdfmval_pub.locked_effectivity_val (

411: FROM sys.DUAL;
412: /* function gmdfmval_pub.locked_effectivity_val gets the recipe status */
413: /* This function return non zero value when the effectivity is locked */
414:
415: l_return_val := gmdfmval_pub.locked_effectivity_val (
416: product_rec.formula_id );
417:
418: IF ( l_return_val <> 0 )
419: THEN

Line 670: gmdfmval_pub.gmd_effectivity_locked_status ( fmeff_id )

666: last_updated_by,
667: last_update_date,
668: last_update_login,
669: delete_mark,
670: gmdfmval_pub.gmd_effectivity_locked_status ( fmeff_id )
671: FROM gmd_recipe_eff_assoc
672: WHERE NOT EXISTS ( SELECT 1
673: FROM gmd_recipe_validity_rules
674: WHERE recipe_validity_rule_id = fmeff_id );