[Home] [Help]
PACKAGE: APPS.FA_RX_GROUP
Source
1 PACKAGE FA_RX_GROUP AUTHID CURRENT_USER AS
2 /* $Header: farxgas.pls 120.8 2010/09/19 10:10:14 glchen ship $ */
3
4
5
6 FA_RXGA_POSITIVE_REDUCTION CONSTANT VARCHAR2(80) :=
7 'YEAR END BALANCE WITH POSITIVE REDUCTION AMOUNT';
8 FA_RXGA_HALF_YEAR_RULE CONSTANT VARCHAR2(80) :=
9 'YEAR END BALANCE WITH HALF YEAR RULE';
10
11
12 TYPE group_rec_type IS RECORD (
13 -- columns of fa_group_rep_itf (GRP_xxx, MEM_xxx)
14 asset_number fa_group_rep_itf.grp_asset_number%TYPE,
15 description fa_group_rep_itf.grp_description%TYPE,
16 asset_type fa_group_rep_itf.grp_asset_type%TYPE,
17 major_category fa_group_rep_itf.grp_major_category%TYPE,
18 minor_category fa_group_rep_itf.grp_minor_category%TYPE,
19 other_category fa_group_rep_itf.grp_other_category%TYPE,
20 date_placed_in_service fa_group_rep_itf.grp_date_placed_in_service%TYPE,
21 deprn_method_code fa_group_rep_itf.grp_deprn_method_code%TYPE,
22 rule_name fa_group_rep_itf.grp_rule_name%TYPE,
23 tracking_method fa_group_rep_itf.grp_tracking_method%TYPE,
24 -- group only
25 adjusted_rate fa_group_rep_itf.grp_adjusted_rate%TYPE,
26 life_year_month fa_group_rep_itf.grp_life_year_month%TYPE,
27 cost fa_group_rep_itf.grp_cost%TYPE,
28 salvage_value fa_group_rep_itf.grp_salvage_value%TYPE,
29 adjusted_recoverable_cost fa_group_rep_itf.grp_adjusted_recoverable_cost%TYPE,
30 beginning_nbv fa_group_rep_itf.grp_beginning_nbv%TYPE,
31 first_half_addition fa_group_rep_itf.grp_first_half_addition%TYPE,
32 second_half_addition fa_group_rep_itf.grp_second_half_addition%TYPE,
33 addition_amount fa_group_rep_itf.grp_addition_amount%TYPE,
34 adjustment_amount fa_group_rep_itf.grp_adjustment_amount%TYPE,
35 net_proceeds fa_group_rep_itf.grp_net_proceeds%TYPE,
36 proceeds_of_sale fa_group_rep_itf.grp_proceeds_of_sale%TYPE,
37 cost_of_removal fa_group_rep_itf.grp_cost_of_removal%TYPE,
38 cost_retired fa_group_rep_itf.grp_cost_retired%TYPE,
39 reserve_retired fa_group_rep_itf.grp_reserve_retired%TYPE,
40 recapture_amount fa_group_rep_itf.grp_recapture_amount%TYPE,
41 -- group only
42 terminal_gain_loss_amount fa_group_rep_itf.grp_terminal_gain_loss_amount%TYPE,
43 -- group only
44 nbv_before_deprn fa_group_rep_itf.grp_nbv_before_deprn%TYPE,
45 deprn_basis_adjustment fa_group_rep_itf.grp_deprn_basis_adjustment%TYPE,
46 reduced_nbv fa_group_rep_itf.grp_reduced_nbv%TYPE,
47 regular_deprn_amount fa_group_rep_itf.grp_regular_deprn_amount%TYPE,
48 -- group only
49 reduced_deprn_amount fa_group_rep_itf.grp_reduced_deprn_amount%TYPE,
50 -- group only
51 annual_deprn_amount fa_group_rep_itf.grp_annual_deprn_amount%TYPE,
52 deprn_reserve fa_group_rep_itf.grp_deprn_reserve%TYPE,
53 ending_nbv fa_group_rep_itf.grp_ending_nbv%TYPE,
54 status fa_group_rep_itf.mem_status%TYPE,
55 -- member only
56 -- necessities for query and calculation
57 asset_id fa_additions.asset_id%TYPE,
58 pre_group_asset_id fa_books.group_asset_id%TYPE,
59 life_year_month_string VARCHAR2(10),
60 deprn_basis_rule fa_methods.deprn_basis_rule%TYPE,
61 exclude_salvage_value_flag fa_methods.exclude_salvage_value_flag%TYPE,
62 reduction_rate fa_books.reduction_rate%TYPE,
63 depreciation_option fa_books.depreciation_option%TYPE,
64 recognize_gain_loss fa_books.recognize_gain_loss%TYPE,
65 exclude_proceeds_from_basis fa_books.exclude_proceeds_from_basis%TYPE,
66 period_counter_fully_retired fa_books.period_counter_fully_retired%TYPE,
67 period_counter_fully_reserved fa_books.period_counter_fully_reserved%TYPE,
68 max_period_counter fa_deprn_summary.period_counter%TYPE
69 );
70
71
72 TYPE info_rec_type IS RECORD (
73 book_type_code fa_books.book_type_code%TYPE,
74 request_id fa_group_rep_itf.request_id%TYPE,
75 user_id fa_group_rep_itf.created_by%TYPE,
76 organization_name fa_group_rep_itf.organization_name%TYPE,
77 functional_currency_code fa_group_rep_itf.functional_currency_code%TYPE,
78 set_of_books_id fa_group_rep_itf.set_of_books_id%TYPE,
79 deprn_calendar fa_group_rep_itf.deprn_calendar%TYPE,
80 fiscal_year fa_group_rep_itf.fiscal_year%TYPE,
81 max_period_counter fa_deprn_periods.period_counter%TYPE,
82 min_period_counter fa_deprn_periods.period_counter%TYPE,
83 major_cat_select_stmt VARCHAR2(100),
84 minor_cat_select_stmt VARCHAR2(100),
85 other_cat_select_stmt VARCHAR2(100),
86 member_query_mode VARCHAR2(20)
87 );
88
89
90 PROCEDURE get_group_asset_info (
91 p_book_type_code IN VARCHAR2,
92 p_sob_id IN VARCHAR2 default NULL, -- MRC: Set of books id
93 p_start_fiscal_year IN VARCHAR2,
94 p_end_fiscal_year IN VARCHAR2,
95 p_major_category_low IN VARCHAR2,
96 p_major_category_high IN VARCHAR2,
97 p_minor_category_low IN VARCHAR2,
98 p_minor_category_high IN VARCHAR2,
99 p_category_segment_name IN VARCHAR2,
100 p_category_segment_low IN VARCHAR2,
101 p_category_segment_high IN VARCHAR2,
102 p_asset_number_low IN VARCHAR2,
103 p_asset_number_high IN VARCHAR2,
104 p_drill_down IN VARCHAR2,
105 p_request_id IN NUMBER,
106 p_user_id IN NUMBER,
107 x_retcode OUT NOCOPY NUMBER,
108 x_errbuf OUT NOCOPY VARCHAR2
109 );
110
111
112 PROCEDURE get_category_sql (
113 p_application_id IN NUMBER,
114 p_category_flex_structure IN NUMBER,
115 p_qualifier IN VARCHAR2,
116 p_category_low IN VARCHAR2,
117 p_category_high IN VARCHAR2,
118 x_select_stmt OUT NOCOPY VARCHAR2,
119 x_where_stmt OUT NOCOPY VARCHAR2
120 );
121
122 PROCEDURE get_from_sql_stmt (
123 p_info_rec IN info_rec_type,
124 p_group_asset_id IN NUMBER,
125 p_mrcsobtype IN VARCHAR2 default NULL, -- MRC: SOB Type
126 x_sql_stmt OUT NOCOPY VARCHAR2
127 );
128
129 PROCEDURE get_where_sql_stmt (
130 p_info_rec IN info_rec_type,
131 p_group_asset_id IN NUMBER,
132 p_mrcsobtype IN VARCHAR2 default NULL, -- MRC: SOB Type
133 x_sql_stmt OUT NOCOPY VARCHAR2
134 );
135
136 PROCEDURE get_trx_amount_sql (
137 p_group_rec IN group_rec_type,
138 p_info_rec IN info_rec_type,
139 p_group_asset_id IN NUMBER,
140 p_mrcsobtype IN VARCHAR2 default NULL, -- MRC: SOB Type
141 x_sql_stmt OUT NOCOPY VARCHAR2
142 );
143
144 PROCEDURE get_retirement_sql (
145 p_info_rec IN info_rec_type,
146 p_group_asset_id IN NUMBER,
147 p_mrcsobtype IN VARCHAR2 default NULL, -- MRC: SOB Type
148 x_sql_stmt OUT NOCOPY VARCHAR2
149 );
150
151 PROCEDURE insert_data (
152 p_info_rec IN info_rec_type,
153 p_group_rec IN group_rec_type,
154 p_member_rec IN group_rec_type
155 );
156
157 PROCEDURE query_member_assets (
158 p_info_rec IN info_rec_type,
159 p_group_rec IN group_rec_type,
160 p_mrcsobtype IN VARCHAR2 default NULL -- MRC: SOB Type
161 );
162
163 END FA_RX_GROUP;