DBA Data[Home] [Help]

APPS.QA_CHAR_UPDATE_PKG dependencies on QA_PC_CRITERIA

Line 632: UPDATE QA_PC_CRITERIA

628: )
629: IS
630: l_api_name CONSTANT VARCHAR2(30) := 'update_pc_criteria';
631: BEGIN
632: UPDATE QA_PC_CRITERIA
633: SET low_value = p_new_value
634: WHERE char_id = p_char_id
635: AND low_value = p_old_value
636: AND plan_relationship_id IN

Line 650: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PC_CRITERIA.low_value for char_id: ' || p_char_id

646: FND_LOG.string
647: (
648: FND_LOG.level_statement,
649: g_pkg_name || '.' || l_api_name,
650: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PC_CRITERIA.low_value for char_id: ' || p_char_id
651: );
652: END IF;
653:
654: UPDATE QA_PC_CRITERIA

Line 654: UPDATE QA_PC_CRITERIA

650: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PC_CRITERIA.low_value for char_id: ' || p_char_id
651: );
652: END IF;
653:
654: UPDATE QA_PC_CRITERIA
655: SET high_value = p_new_value
656: WHERE char_id = p_char_id
657: AND high_value = p_old_value
658: AND plan_relationship_id IN

Line 672: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PC_CRITERIA.high_value for char_id: ' || p_char_id

668: FND_LOG.string
669: (
670: FND_LOG.level_statement,
671: g_pkg_name || '.' || l_api_name,
672: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PC_CRITERIA.high_value for char_id: ' || p_char_id
673: );
674: END IF;
675: END update_pc_criteria;
676: