This packaged stored procedure is used to perform the pre-validation of data in the Staging Table.
If it is located at the OTD root level, the data in all Staging Tables is validated.
If it is located at the Staging Table level, only the data in that specific Staging Table is validated.
Depends upon specific implementation. By default, it contains three input VARCHAR parameters corresponding to:
sb_eway_id
sb_group_id
sb_object_id
sb_pass_or_fail
Inside the script package, this stored procedure must have the name VALIDATE.