STS DATA VALIDATIONS

PL/SQL Triggers, Packages, and Stored Procedures

All triggers and stored procedures are stored within the database. These can be edited using the procedure editor included in the TOAD software. Each procedure is also saved to an external text file in order to make it easier to recreate the procedures. The procedures can be edited either by loading the source into the TOAD procedure editor directly from the Oracle database or by loading the script file into the editor. Care should be taken to maintain updated versions of the files at all locations. The procedure script files are located on sceolaun: C:\oracle\trap_procedures, trap_triggers, trap_functions, and trap_packages

Triggers:

OMIT_INSERT_AFT
PLACE_INSERT_AFT
TPLACE_INS_UPD_AFT
TPLACE_INS_UPD_AFT_ROW
TPLACE_UPD_BEF_ROW
INSPECT_INSERT_AFT
TINSPECT_INS_UPD_AFT
TINSPECT_INS_UPD_AFT_ROW
TINSPECT_UPD_BEF_ROW
OMIT_CTY_INSERT_AFT
PLACE_CTY_INSERT_AFT
TPLACE_CTY_INS_UPD_AFT
TPLACE_CTY_INS_UPD_AFT_ROW
TPLACE_CTY_UPD_BEF_ROW
INSPECT_CTY_INSERT_AFT
TINSPECT_CTY_INS_UPD_AFT
TINSPECT_CTY_INS_UPD_AFT_ROW
TINSPECT_CTY_UPD_BEF_ROW

Packages and Procedures Used During Data Validation Process (Alphabetical Order):

Packages:

CtyDataPkg
TdataPkg

Stored Procedures:

Triggers, Packages, and Stored Procedures Used During Data Validation Process (in order of use):

TEST_PLACEMENT TABLE

Trigger TPLACE_UPD_BEF_ROW calls the following packages and procedures:

Tdatapkg.get_gm_sequence_id
Tdatapkg (variables)

Trigger TPLACE_INS_UPD_AFT_ROW calls:

Tdatapkg (package variables only)

Trigger TPLACE_INS_UPD_AFT calls:

Tdatapkg (package variables only)
Quad_convert
Site_valid
Day_check
Formdate_later_than_scan
Trapper_convert
Traptype_valid
Quadsite_unique
Gridutms_unique
Utms_unique
Omit_why_valid
Utm_quad_check
Trap_distance
Traps_too_close (currently disabled)

OMITTED_SITES TABLE

Trigger OMIT_INSERT_AFT calls:

No procedures called 

PLACEMENT TABLE

Trigger PLACE_INSERT_AFT calls:

No procedures called

TEST_PLACEMENT_CTY TABLE

Trigger TPLACE_CTY_UPD_BEF_ROW calls:

CtyDataPkg.get_cty_gm_sequence_id

Trigger TPLACE_CTY_INS_UPD_AFT calls:

CtyDataPkg (variables only)
County_valid_cty
Site_valid_cty
Day_check_cty
Formdate_later_than_scan_cty
Traptype_valid_cty
County_block_site_unique
Gridutms_unique_cty
Utms_unique_cty
Omit_why_valid_cty
Trap_distance_cty
Traps_too_close_cty (currently disabled)

Trigger TPLACE_CTY_INS_UPD_AFT_ROW calls:

CtyDataPkg (variables only)

OMITTED_SITES_CTY TABLE

Trigger OMIT_CTY_INSERT_AFT calls:

No procedures called

PLACEMENT_CTY TABLE

Trigger PLACE_CTY_INSERT_AFT calls:

No procedures called

TEST_INSPECTION TABLE

Trigger TINSPECT_UPD_BEF_ROW calls:

Tdatapkg.get_gm_sequence_id
Tdatapkg (variables only)

Trigger TINSPECT_INS_UPD_AFT calls:

Tdatapkg (variables only)
Day_check
Formdate_later_than_scan
Quad_convert
Site_valid
Omitted_site
Placed_site
Trapper_valid
Inspect_unique
Utms_unique
Utm_quad_check
Trap_distance
Traps_too_close (currently disabled)
Qc_valid
Visit_final
Visit_valid
Trap_condition
Catch_valid

Trigger TINSPECT_INS_UPD_AFT_ROW calls:

Tdatapkg (variables only)

TEST_INSPECTION_CTY TABLE

Trigger TINSPECT_UPD_BEF_ROW calls:

CtyDataPkg.get_cty_gm_sequence_id
CtyDataPkg (variables only)

Trigger TINSPECT_CTY_INS_UPD_AFT calls:

CtyDataPkg (variables only)
Day_check_cty
Formdate_later_than_scan_cty
Site_valid_cty
Omitted_site_cty
Placed_site_cty
Trapper_valid_cty
Inspect_unique_cty
Utms_unique_cty
Trap_distance_cty
Traps_too_close_cty (currently disabled)
Qc_valid_cty
Visit_final_cty
Visit_valid_cty
Trap_condition_cty
Catch_valid_cty
Placement_upd_cty

Trigger TINSPECT_CTY_INS_UPD_AFT_ROW calls:

CtyDataPkg (variables only)