APPS.QA_CHAR_UPDATE_PKG dependencies on QA_CRITERIA

Line 573: UPDATE QA_CRITERIA

569: )
570: IS
571: l_api_name CONSTANT VARCHAR2(30) := 'update_criteria';
572: BEGIN
573: UPDATE QA_CRITERIA
574: SET low_value = p_new_value
575: WHERE char_id = p_char_id
576: AND low_value = p_old_value
577: AND criteria_id IN

Line 580: FROM QA_CRITERIA_HEADERS qch,

576: AND low_value = p_old_value
577: AND criteria_id IN
578: (
579: SELECT qch.criteria_id
580: FROM QA_CRITERIA_HEADERS qch,
581: QA_PLANS qp,
582: QA_PLAN_CHARS qpc
583: WHERE qch.organization_id = qp.organization_id
584: AND qp.plan_id = qpc.plan_id

Line 593: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_CRITERIA.low_value for char_id: ' || p_char_id

589: FND_LOG.string
590: (
591: FND_LOG.level_statement,
592: g_pkg_name || '.' || l_api_name,
593: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_CRITERIA.low_value for char_id: ' || p_char_id
594: );
595: END IF;
596:
597: UPDATE QA_CRITERIA

Line 597: UPDATE QA_CRITERIA

593: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_CRITERIA.low_value for char_id: ' || p_char_id
594: );
595: END IF;
596:
597: UPDATE QA_CRITERIA
598: SET high_value = p_new_value
599: WHERE char_id = p_char_id
600: AND high_value = p_old_value
601: AND criteria_id IN

Line 604: FROM QA_CRITERIA_HEADERS qch,

600: AND high_value = p_old_value
601: AND criteria_id IN
602: (
603: SELECT qch.criteria_id
604: FROM QA_CRITERIA_HEADERS qch,
605: QA_PLANS qp,
606: QA_PLAN_CHARS qpc
607: WHERE qch.organization_id = qp.organization_id
608: AND qp.plan_id = qpc.plan_id

Line 617: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_CRITERIA.high_value for char_id: ' || p_char_id

613: FND_LOG.string
614: (
615: FND_LOG.level_statement,
616: g_pkg_name || '.' || l_api_name,
617: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_CRITERIA.high_value for char_id: ' || p_char_id
618: );
619: END IF;
620: END update_criteria;
621: