APPS.QA_CHAR_UPDATE_PKG dependencies on QA_CHAR_ACTION_TRIGGERS

Line 428: UPDATE QA_CHAR_ACTION_TRIGGERS

424: )
425: IS
426: l_api_name CONSTANT VARCHAR2(30) := 'update_char_action_trig';
427: BEGIN
428: UPDATE QA_CHAR_ACTION_TRIGGERS
429: SET low_value_other = p_new_value
430: WHERE char_id = p_char_id
431: AND low_value_other = p_old_value;
432:

Line 438: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_CHAR_ACTION_TRIGGERS.low_value_other for char_id: ' || p_char_id

434: FND_LOG.string
435: (
436: FND_LOG.level_statement,
437: g_pkg_name || '.' || l_api_name,
438: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_CHAR_ACTION_TRIGGERS.low_value_other for char_id: ' || p_char_id
439: );
440: END IF;
441:
442: UPDATE QA_CHAR_ACTION_TRIGGERS

Line 442: UPDATE QA_CHAR_ACTION_TRIGGERS

438: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_CHAR_ACTION_TRIGGERS.low_value_other for char_id: ' || p_char_id
439: );
440: END IF;
441:
442: UPDATE QA_CHAR_ACTION_TRIGGERS
443: SET high_value_other = p_new_value
444: WHERE char_id = p_char_id
445: AND high_value_other = p_old_value;
446:

Line 452: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_CHAR_ACTION_TRIGGERS.high_value_other for char_id: ' || p_char_id

448: FND_LOG.string
449: (
450: FND_LOG.level_statement,
451: g_pkg_name || '.' || l_api_name,
452: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_CHAR_ACTION_TRIGGERS.high_value_other for char_id: ' || p_char_id
453: );
454: END IF;
455: END update_char_action_trig;
456: