Update Risk Score

Apply the score to previously scored or un-scored pre-existing discrepancies.

Use this API to apply the score to previously scored or unscored pre-existing discrepancies that were created by validation checks owned by the passed validation check batch or created by the passed validation check.

Name

DME_PUB_VALIDATION_CHECK.updateDiscRiskScore

Signature

PROCEDURE updateValidationCheck (
            p_api_version IN VARCHAR2   
          , p_init_msg_list IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE
          , p_commit IN VARCHAR2 default CDR_PUB_DEF_CONSTANTS.G_FALSE
          , p_validation_level IN NUMBER default CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL
          , x_return_status OUT NOCOPY VARCHAR2
          , x_msg_count OUT NOCOPY NUMBER
          , x_msg_data OUT NOCOPY VARCHAR2
          , pi_batchObjId in cdr_namings.obj_id%type
          , pi_vcObjId in cdr_namings.obj_id%type
          , pi_lifecycle IN VARCHAR2
          , pi_overrideFlag IN VARCHAR2 DEFAULT 'N' 
          );

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

• pi_batchObjId: Enter Validation Check Batch Object ID.
• pi_vcObjId: Enter Validation Check Object ID.

  Note:

  The updateValidationCheck API finds all the discrepancies that belong to the most granular level input (Validation Check Batch or Validation Check) supplied by the user, and applies the scores defined on the Validation Check that created these individual discrepancies.
• pi_lifecycle: Enter lifecycle as $LIFECYCLE$DEV', '$LIFECYCLE$QC' or '$LIFECYCLE$PRO.
• pi_overrideFlag (Optional): Enter 'Y' to score pre-existing discrepancies irrespective of being previously scored or unscored to the currently defined Risk Score of the Validation Check. Otherwise, leave blank. It defaults to 'N'.