Pre-Validation Procedures
All pre-validation script packages (*_pkg.sql) contain the following procedures.
Table 1–1 Common Procedures|
Procedure |
Purpose |
|---|---|
|
Initialize_Profile |
Initializes the table for sharing to avoid running multiple instances by different users. |
|
TidyUp |
Updates sb_pass_or_fail columns in the staging table from INTERMEDIATE to PASS for records that were not marked as failed by the pre-validation rules. |
|
Validate |
The main validation procedure which calls the procedures that perform the pre-validations for the Interface Table. |
- © 2010, Oracle Corporation and/or its affiliates