APPS.GMD_RECIPE_GENERATE dependencies on GMD_RECIPE_VALIDITY_RULES

Line 351: FROM gmd_recipe_validity_rules

347: p_event_signed IN BOOLEAN) IS
348:
349: CURSOR Cur_get_validity_status (V_validity_rule_id NUMBER) IS
350: SELECT validity_rule_status
351: FROM gmd_recipe_validity_rules
352: WHERE recipe_validity_rule_id = V_validity_rule_id;
353:
354:
355: l_vr_id NUMBER;

Line 413: UPDATE gmd_recipe_validity_rules

409: IF (l_default_vr_status.entity_status <> 100) THEN
410: l_vr_id := GMD_RECIPE_DETAIL_PVT.pkg_recipe_validity_rule_id;
411: IF p_event_signed THEN
412:
413: UPDATE gmd_recipe_validity_rules
414: SET validity_rule_status = l_default_vr_status.entity_status
415: WHERE recipe_validity_rule_id = l_vr_id;
416: ELSE -- IF p_event_signed
417:

Line 676: UPDATE gmd_recipe_validity_rules

672: /* If Managing Validity Rules is set as First Preference */
673: IF p_manage_validity_rules = 1 THEN
674: /* We need to increase the preference for all the validity rules that are valid */
675: /* in the current validity rules validity dates */
676: UPDATE gmd_recipe_validity_rules
677: SET preference = preference + 1,
678: last_updated_by = g_user_id,
679: last_update_date = sysdate,
680: last_update_login = g_login_id

Line 694: UPDATE gmd_recipe_validity_rules

690: /* If Managing Validity Rules is set as End Date */
691: ELSIF p_manage_validity_rules = 2 THEN
692: /* We need to expire only those validity rules where the end date is less */
693: /* than or equal to the current validity rule */
694: UPDATE gmd_recipe_validity_rules
695: SET end_date = sysdate,
696: last_updated_by = g_user_id,
697: last_update_date = sysdate,
698: last_update_login = g_login_id