4: /**
5: -- Constants to hold the value of the revaluation statuses so that it can
6: -- be shared accross pl/sql routines
7: **/
8: gc_preview_status CONSTANT igi_iac_revaluations.status%TYPE := 'PREVIEW';
9: gc_previewed_status CONSTANT igi_iac_revaluations.status%TYPE := 'PREVIEWED';
10: gc_failedpre_status CONSTANT igi_iac_revaluations.status%TYPE := 'FAILED_PRE';
11: gc_running_status CONSTANT igi_iac_revaluations.status%TYPE := 'RUNNING';
12: gc_completed_status CONSTANT igi_iac_revaluations.status%TYPE := 'COMPLETED';
5: -- Constants to hold the value of the revaluation statuses so that it can
6: -- be shared accross pl/sql routines
7: **/
8: gc_preview_status CONSTANT igi_iac_revaluations.status%TYPE := 'PREVIEW';
9: gc_previewed_status CONSTANT igi_iac_revaluations.status%TYPE := 'PREVIEWED';
10: gc_failedpre_status CONSTANT igi_iac_revaluations.status%TYPE := 'FAILED_PRE';
11: gc_running_status CONSTANT igi_iac_revaluations.status%TYPE := 'RUNNING';
12: gc_completed_status CONSTANT igi_iac_revaluations.status%TYPE := 'COMPLETED';
13: gc_failedrun_status CONSTANT igi_iac_revaluations.status%TYPE := 'FAILED_RUN';
6: -- be shared accross pl/sql routines
7: **/
8: gc_preview_status CONSTANT igi_iac_revaluations.status%TYPE := 'PREVIEW';
9: gc_previewed_status CONSTANT igi_iac_revaluations.status%TYPE := 'PREVIEWED';
10: gc_failedpre_status CONSTANT igi_iac_revaluations.status%TYPE := 'FAILED_PRE';
11: gc_running_status CONSTANT igi_iac_revaluations.status%TYPE := 'RUNNING';
12: gc_completed_status CONSTANT igi_iac_revaluations.status%TYPE := 'COMPLETED';
13: gc_failedrun_status CONSTANT igi_iac_revaluations.status%TYPE := 'FAILED_RUN';
14: /**
7: **/
8: gc_preview_status CONSTANT igi_iac_revaluations.status%TYPE := 'PREVIEW';
9: gc_previewed_status CONSTANT igi_iac_revaluations.status%TYPE := 'PREVIEWED';
10: gc_failedpre_status CONSTANT igi_iac_revaluations.status%TYPE := 'FAILED_PRE';
11: gc_running_status CONSTANT igi_iac_revaluations.status%TYPE := 'RUNNING';
12: gc_completed_status CONSTANT igi_iac_revaluations.status%TYPE := 'COMPLETED';
13: gc_failedrun_status CONSTANT igi_iac_revaluations.status%TYPE := 'FAILED_RUN';
14: /**
15: -- Period record contains the full information about the period
8: gc_preview_status CONSTANT igi_iac_revaluations.status%TYPE := 'PREVIEW';
9: gc_previewed_status CONSTANT igi_iac_revaluations.status%TYPE := 'PREVIEWED';
10: gc_failedpre_status CONSTANT igi_iac_revaluations.status%TYPE := 'FAILED_PRE';
11: gc_running_status CONSTANT igi_iac_revaluations.status%TYPE := 'RUNNING';
12: gc_completed_status CONSTANT igi_iac_revaluations.status%TYPE := 'COMPLETED';
13: gc_failedrun_status CONSTANT igi_iac_revaluations.status%TYPE := 'FAILED_RUN';
14: /**
15: -- Period record contains the full information about the period
16: **/
9: gc_previewed_status CONSTANT igi_iac_revaluations.status%TYPE := 'PREVIEWED';
10: gc_failedpre_status CONSTANT igi_iac_revaluations.status%TYPE := 'FAILED_PRE';
11: gc_running_status CONSTANT igi_iac_revaluations.status%TYPE := 'RUNNING';
12: gc_completed_status CONSTANT igi_iac_revaluations.status%TYPE := 'COMPLETED';
13: gc_failedrun_status CONSTANT igi_iac_revaluations.status%TYPE := 'FAILED_RUN';
14: /**
15: -- Period record contains the full information about the period
16: **/
17: TYPE prd_rec IS RECORD (Period_Name VARCHAR2(30) default null,
78: type iac_reval_asset_params IS RECORD
79: (
80: asset_id fa_additions.asset_id%TYPE DEFAULT 0
81: ,book_type_code fa_book_controls.book_type_code%TYPE DEFAULT NULL
82: ,revaluation_id igi_iac_revaluations.revaluation_id%TYPE DEFAULT 0
83: ,revaluation_rate igi_iac_reval_asset_rules.revaluation_factor%TYPE DEFAULT 0
84: ,revaluation_date igi_iac_revaluations.revaluation_date%TYPE
85: ,period_counter fa_book_controls.last_period_counter%TYPE DEFAULT 0
86: ,category_id fa_additions.asset_category_id%TYPE DEFAULT 0
80: asset_id fa_additions.asset_id%TYPE DEFAULT 0
81: ,book_type_code fa_book_controls.book_type_code%TYPE DEFAULT NULL
82: ,revaluation_id igi_iac_revaluations.revaluation_id%TYPE DEFAULT 0
83: ,revaluation_rate igi_iac_reval_asset_rules.revaluation_factor%TYPE DEFAULT 0
84: ,revaluation_date igi_iac_revaluations.revaluation_date%TYPE
85: ,period_counter fa_book_controls.last_period_counter%TYPE DEFAULT 0
86: ,category_id fa_additions.asset_category_id%TYPE DEFAULT 0
87: ,first_set_adjustment_id igi_iac_adjustments.adjustment_id%TYPE default 0
88: ,second_set_adjustment_id igi_iac_adjustments.adjustment_id%TYPE default 0