DBA Data[Home] [Help]

APPS.IGI_IAC_TYPES dependencies on IGI_IAC_REVALUATIONS

Line 8: gc_preview_status CONSTANT igi_iac_revaluations.status%TYPE := 'PREVIEW';

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';

Line 9: gc_previewed_status CONSTANT igi_iac_revaluations.status%TYPE := 'PREVIEWED';

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';

Line 10: gc_failedpre_status CONSTANT igi_iac_revaluations.status%TYPE := 'FAILED_PRE';

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: /**

Line 11: gc_running_status CONSTANT igi_iac_revaluations.status%TYPE := 'RUNNING';

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

Line 12: gc_completed_status CONSTANT igi_iac_revaluations.status%TYPE := 'COMPLETED';

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: **/

Line 13: gc_failedrun_status CONSTANT igi_iac_revaluations.status%TYPE := 'FAILED_RUN';

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,

Line 82: ,revaluation_id igi_iac_revaluations.revaluation_id%TYPE DEFAULT 0

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

Line 84: ,revaluation_date igi_iac_revaluations.revaluation_date%TYPE

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