APPS.QA_CHAR_UPDATE_PKG dependencies on QA_PLAN_CHAR_ACTION_TRIGGERS

Line 467: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS

463: )
464: IS
465: l_api_name CONSTANT VARCHAR2(30) := 'update_plan_char_action_trig';
466: BEGIN
467: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS
468: SET low_value_other = p_new_value
469: WHERE char_id = p_char_id
470: AND low_value_other = p_old_value
471: AND plan_id IN

Line 483: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_CHAR_ACTION_TRIGGERS.low_value_other for char_id: ' || p_char_id

479: FND_LOG.string
480: (
481: FND_LOG.level_statement,
482: g_pkg_name || '.' || l_api_name,
483: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_CHAR_ACTION_TRIGGERS.low_value_other for char_id: ' || p_char_id
484: );
485: END IF;
486:
487: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS

Line 487: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS

483: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_CHAR_ACTION_TRIGGERS.low_value_other for char_id: ' || p_char_id
484: );
485: END IF;
486:
487: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS
488: SET high_value_other = p_new_value
489: WHERE char_id = p_char_id
490: AND high_value_other = p_old_value
491: AND plan_id IN

Line 503: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_CHAR_ACTION_TRIGGERS.high_value_other for char_id: ' || p_char_id

499: FND_LOG.string
500: (
501: FND_LOG.level_statement,
502: g_pkg_name || '.' || l_api_name,
503: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_CHAR_ACTION_TRIGGERS.high_value_other for char_id: ' || p_char_id
504: );
505: END IF;
506: END update_plan_char_action_trig;
507: