APPS.GMD_RECIPE_GENERATE dependencies on GMD_RECIPE_VALIDITY_RULES

Line 293: FROM gmd_recipe_validity_rules

289: p_event_signed IN BOOLEAN) IS
290:
291: CURSOR Cur_get_validity_status (V_validity_rule_id NUMBER) IS
292: SELECT validity_rule_status
293: FROM gmd_recipe_validity_rules
294: WHERE recipe_validity_rule_id = V_validity_rule_id;
295:
296:
297: l_vr_id NUMBER;

Line 351: UPDATE gmd_recipe_validity_rules

347: IF (l_default_vr_status.entity_status <> 100) THEN
348: l_vr_id := GMD_RECIPE_DETAIL_PVT.pkg_recipe_validity_rule_id;
349: IF p_event_signed THEN
350:
351: UPDATE gmd_recipe_validity_rules
352: SET validity_rule_status = l_default_vr_status.entity_status
353: WHERE recipe_validity_rule_id = l_vr_id;
354: ELSE -- IF p_event_signed
355:

Line 612: UPDATE gmd_recipe_validity_rules

608: /* If Managing Validity Rules is set as First Preference */
609: IF p_manage_validity_rules = 1 THEN
610: /* We need to increase the preference for all the validity rules that are valid */
611: /* in the current validity rules validity dates */
612: UPDATE gmd_recipe_validity_rules
613: SET preference = preference + 1,
614: last_updated_by = g_user_id,
615: last_update_date = sysdate,
616: last_update_login = g_login_id

Line 630: UPDATE gmd_recipe_validity_rules

626: /* If Managing Validity Rules is set as End Date */
627: ELSIF p_manage_validity_rules = 2 THEN
628: /* We need to expire only those validity rules where the end date is less */
629: /* than or equal to the current validity rule */
630: UPDATE gmd_recipe_validity_rules
631: SET end_date = sysdate,
632: last_updated_by = g_user_id,
633: last_update_date = sysdate,
634: last_update_login = g_login_id