[Home] [Help]
80: X_bind := 'JG_RX_FAREG.fa_' || p_type || '_bind' || '(:CURSOR_SELECT);';
81: X_after_fetch := 'JG_RX_FAREG.fa_' || p_type || '_after_fetch'|| ';';
82: X_after_report := 'JG_RX_FAREG.fa_' || p_type || '_after_report'|| ';';
83:
84: FA_RX_UTIL_PKG.debug(X_calling_proc || '()+');
85: FA_RX_UTIL_PKG.debug(X_calling_proc || '(amar)+');
86:
87: FA_RX_UTIL_PKG.init_request(X_calling_proc, request_id);
88:
81: X_after_fetch := 'JG_RX_FAREG.fa_' || p_type || '_after_fetch'|| ';';
82: X_after_report := 'JG_RX_FAREG.fa_' || p_type || '_after_report'|| ';';
83:
84: FA_RX_UTIL_PKG.debug(X_calling_proc || '()+');
85: FA_RX_UTIL_PKG.debug(X_calling_proc || '(amar)+');
86:
87: FA_RX_UTIL_PKG.init_request(X_calling_proc, request_id);
88:
89: -- Store the parameters in a variable which can be accesed globally accross all procedures
83:
84: FA_RX_UTIL_PKG.debug(X_calling_proc || '()+');
85: FA_RX_UTIL_PKG.debug(X_calling_proc || '(amar)+');
86:
87: FA_RX_UTIL_PKG.init_request(X_calling_proc, request_id);
88:
89: -- Store the parameters in a variable which can be accesed globally accross all procedures
90: PARM.p_book_type_code := p_book_type_code;
91: PARM.p_period_from := p_period_from;
112: -- Call the core report.This executes the core report and the SELECT statement of the core
113: -- is built.
114: -- No data is inserted into the interface table.
115:
116: FA_RX_UTIL_PKG.debug('FA_RX_UTIL_PKG.assign_report(' || X_section_name);
117: FA_RX_UTIL_PKG.debug(' TRUE');
118: FA_RX_UTIL_PKG.debug(' ' || X_before_report);
119: FA_RX_UTIL_PKG.debug(' ' || X_bind);
120: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);
113: -- is built.
114: -- No data is inserted into the interface table.
115:
116: FA_RX_UTIL_PKG.debug('FA_RX_UTIL_PKG.assign_report(' || X_section_name);
117: FA_RX_UTIL_PKG.debug(' TRUE');
118: FA_RX_UTIL_PKG.debug(' ' || X_before_report);
119: FA_RX_UTIL_PKG.debug(' ' || X_bind);
120: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);
121: FA_RX_UTIL_PKG.debug(' ' || X_after_report);
114: -- No data is inserted into the interface table.
115:
116: FA_RX_UTIL_PKG.debug('FA_RX_UTIL_PKG.assign_report(' || X_section_name);
117: FA_RX_UTIL_PKG.debug(' TRUE');
118: FA_RX_UTIL_PKG.debug(' ' || X_before_report);
119: FA_RX_UTIL_PKG.debug(' ' || X_bind);
120: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);
121: FA_RX_UTIL_PKG.debug(' ' || X_after_report);
122: FA_RX_UTIL_PKG.debug(' )');
115:
116: FA_RX_UTIL_PKG.debug('FA_RX_UTIL_PKG.assign_report(' || X_section_name);
117: FA_RX_UTIL_PKG.debug(' TRUE');
118: FA_RX_UTIL_PKG.debug(' ' || X_before_report);
119: FA_RX_UTIL_PKG.debug(' ' || X_bind);
120: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);
121: FA_RX_UTIL_PKG.debug(' ' || X_after_report);
122: FA_RX_UTIL_PKG.debug(' )');
123:
116: FA_RX_UTIL_PKG.debug('FA_RX_UTIL_PKG.assign_report(' || X_section_name);
117: FA_RX_UTIL_PKG.debug(' TRUE');
118: FA_RX_UTIL_PKG.debug(' ' || X_before_report);
119: FA_RX_UTIL_PKG.debug(' ' || X_bind);
120: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);
121: FA_RX_UTIL_PKG.debug(' ' || X_after_report);
122: FA_RX_UTIL_PKG.debug(' )');
123:
124: FA_RX_UTIL_PKG.assign_report(X_section_name,
117: FA_RX_UTIL_PKG.debug(' TRUE');
118: FA_RX_UTIL_PKG.debug(' ' || X_before_report);
119: FA_RX_UTIL_PKG.debug(' ' || X_bind);
120: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);
121: FA_RX_UTIL_PKG.debug(' ' || X_after_report);
122: FA_RX_UTIL_PKG.debug(' )');
123:
124: FA_RX_UTIL_PKG.assign_report(X_section_name,
125: TRUE,
118: FA_RX_UTIL_PKG.debug(' ' || X_before_report);
119: FA_RX_UTIL_PKG.debug(' ' || X_bind);
120: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);
121: FA_RX_UTIL_PKG.debug(' ' || X_after_report);
122: FA_RX_UTIL_PKG.debug(' )');
123:
124: FA_RX_UTIL_PKG.assign_report(X_section_name,
125: TRUE,
126: X_before_report,
120: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);
121: FA_RX_UTIL_PKG.debug(' ' || X_after_report);
122: FA_RX_UTIL_PKG.debug(' )');
123:
124: FA_RX_UTIL_PKG.assign_report(X_section_name,
125: TRUE,
126: X_before_report,
127: X_bind,
128: X_after_fetch,
127: X_bind,
128: X_after_fetch,
129: X_after_report);
130:
131: FA_RX_UTIL_PKG.run_report(X_calling_proc, retcode, errbuf);
132:
133: FA_RX_UTIL_PKG.debug(X_calling_proc || '()-');
134:
135: END fa_get_report;
129: X_after_report);
130:
131: FA_RX_UTIL_PKG.run_report(X_calling_proc, retcode, errbuf);
132:
133: FA_RX_UTIL_PKG.debug(X_calling_proc || '()-');
134:
135: END fa_get_report;
136:
137:
152: IS
153:
154:
155: BEGIN
156: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_ASSET_before_report()+');
157:
158:
159: -- It takes the segment condition, Company name, currency code and store in placeholder variable
160: Startup;
164:
165: -- Assign SELECT list
166: -- the Select statement is build over here
167:
168: -- FA_RX_UTIL_PKG.assign_column(#, select, insert, place, type, len);
169: fa_rx_util_pkg.debug(' checking if value is available'||to_char(X_fiscal_year_start_date));
170:
171: -->>SELECT_START<<--
172:
165: -- Assign SELECT list
166: -- the Select statement is build over here
167:
168: -- FA_RX_UTIL_PKG.assign_column(#, select, insert, place, type, len);
169: fa_rx_util_pkg.debug(' checking if value is available'||to_char(X_fiscal_year_start_date));
170:
171: -->>SELECT_START<<--
172:
173: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JG_RX_FAREG.var.organization_name','VARCHAR2',60);
169: fa_rx_util_pkg.debug(' checking if value is available'||to_char(X_fiscal_year_start_date));
170:
171: -->>SELECT_START<<--
172:
173: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JG_RX_FAREG.var.organization_name','VARCHAR2',60);
174: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JG_RX_FAREG.var.functional_currency_code', 'VARCHAR2',15);
175:
176: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JG_RX_FAREG.var.major_category','VARCHAR2', 30);
177: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JG_RX_FAREG.var.minor_category','VARCHAR2', 30);
170:
171: -->>SELECT_START<<--
172:
173: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JG_RX_FAREG.var.organization_name','VARCHAR2',60);
174: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JG_RX_FAREG.var.functional_currency_code', 'VARCHAR2',15);
175:
176: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JG_RX_FAREG.var.major_category','VARCHAR2', 30);
177: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JG_RX_FAREG.var.minor_category','VARCHAR2', 30);
178:
172:
173: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JG_RX_FAREG.var.organization_name','VARCHAR2',60);
174: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JG_RX_FAREG.var.functional_currency_code', 'VARCHAR2',15);
175:
176: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JG_RX_FAREG.var.major_category','VARCHAR2', 30);
177: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JG_RX_FAREG.var.minor_category','VARCHAR2', 30);
178:
179: FA_RX_UTIL_PKG.assign_column('5', NULL, 'deprn_rate','JG_RX_FAREG.var.deprn_rate','NUMBER');
180:
173: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JG_RX_FAREG.var.organization_name','VARCHAR2',60);
174: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JG_RX_FAREG.var.functional_currency_code', 'VARCHAR2',15);
175:
176: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JG_RX_FAREG.var.major_category','VARCHAR2', 30);
177: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JG_RX_FAREG.var.minor_category','VARCHAR2', 30);
178:
179: FA_RX_UTIL_PKG.assign_column('5', NULL, 'deprn_rate','JG_RX_FAREG.var.deprn_rate','NUMBER');
180:
181: FA_RX_UTIL_PKG.assign_column('6', NULL,'starting_deprn_year','JG_RX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
175:
176: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JG_RX_FAREG.var.major_category','VARCHAR2', 30);
177: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JG_RX_FAREG.var.minor_category','VARCHAR2', 30);
178:
179: FA_RX_UTIL_PKG.assign_column('5', NULL, 'deprn_rate','JG_RX_FAREG.var.deprn_rate','NUMBER');
180:
181: FA_RX_UTIL_PKG.assign_column('6', NULL,'starting_deprn_year','JG_RX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
182:
183: /* FA_RX_UTIL_PKG.assign_column('7', 'TO_CHAR(BO.date_placed_in_service,"YYYY")','starting_deprn_year','JG_RX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
177: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JG_RX_FAREG.var.minor_category','VARCHAR2', 30);
178:
179: FA_RX_UTIL_PKG.assign_column('5', NULL, 'deprn_rate','JG_RX_FAREG.var.deprn_rate','NUMBER');
180:
181: FA_RX_UTIL_PKG.assign_column('6', NULL,'starting_deprn_year','JG_RX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
182:
183: /* FA_RX_UTIL_PKG.assign_column('7', 'TO_CHAR(BO.date_placed_in_service,"YYYY")','starting_deprn_year','JG_RX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
184: */
185: FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JG_RX_FAREG.var.date_placed_in_service','DATE');
179: FA_RX_UTIL_PKG.assign_column('5', NULL, 'deprn_rate','JG_RX_FAREG.var.deprn_rate','NUMBER');
180:
181: FA_RX_UTIL_PKG.assign_column('6', NULL,'starting_deprn_year','JG_RX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
182:
183: /* FA_RX_UTIL_PKG.assign_column('7', 'TO_CHAR(BO.date_placed_in_service,"YYYY")','starting_deprn_year','JG_RX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
184: */
185: FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JG_RX_FAREG.var.date_placed_in_service','DATE');
186:
187: FA_RX_UTIL_PKG.assign_column('8', 'BO.asset_id', NULL,'JG_RX_FAREG.var.asset_id','NUMBER');
181: FA_RX_UTIL_PKG.assign_column('6', NULL,'starting_deprn_year','JG_RX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
182:
183: /* FA_RX_UTIL_PKG.assign_column('7', 'TO_CHAR(BO.date_placed_in_service,"YYYY")','starting_deprn_year','JG_RX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
184: */
185: FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JG_RX_FAREG.var.date_placed_in_service','DATE');
186:
187: FA_RX_UTIL_PKG.assign_column('8', 'BO.asset_id', NULL,'JG_RX_FAREG.var.asset_id','NUMBER');
188: FA_RX_UTIL_PKG.assign_column('9', 'AD.asset_number', 'asset_number','JG_RX_FAREG.var.asset_number','VARCHAR2', 25);
189: FA_RX_UTIL_PKG.assign_column('10', 'AD.description', 'description','JG_RX_FAREG.var.description','VARCHAR2', 80);
183: /* FA_RX_UTIL_PKG.assign_column('7', 'TO_CHAR(BO.date_placed_in_service,"YYYY")','starting_deprn_year','JG_RX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
184: */
185: FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JG_RX_FAREG.var.date_placed_in_service','DATE');
186:
187: FA_RX_UTIL_PKG.assign_column('8', 'BO.asset_id', NULL,'JG_RX_FAREG.var.asset_id','NUMBER');
188: FA_RX_UTIL_PKG.assign_column('9', 'AD.asset_number', 'asset_number','JG_RX_FAREG.var.asset_number','VARCHAR2', 25);
189: FA_RX_UTIL_PKG.assign_column('10', 'AD.description', 'description','JG_RX_FAREG.var.description','VARCHAR2', 80);
190:
191: FA_RX_UTIL_PKG.assign_column('11', 'AD.parent_asset_id', NULL,'JG_RX_FAREG.var.parent_asset_id','NUMBER');
184: */
185: FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JG_RX_FAREG.var.date_placed_in_service','DATE');
186:
187: FA_RX_UTIL_PKG.assign_column('8', 'BO.asset_id', NULL,'JG_RX_FAREG.var.asset_id','NUMBER');
188: FA_RX_UTIL_PKG.assign_column('9', 'AD.asset_number', 'asset_number','JG_RX_FAREG.var.asset_number','VARCHAR2', 25);
189: FA_RX_UTIL_PKG.assign_column('10', 'AD.description', 'description','JG_RX_FAREG.var.description','VARCHAR2', 80);
190:
191: FA_RX_UTIL_PKG.assign_column('11', 'AD.parent_asset_id', NULL,'JG_RX_FAREG.var.parent_asset_id','NUMBER');
192: FA_RX_UTIL_PKG.assign_column('12', NULL, 'parent_asset_number','JG_RX_FAREG.var.parent_asset_number','VARCHAR2', 15);
185: FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JG_RX_FAREG.var.date_placed_in_service','DATE');
186:
187: FA_RX_UTIL_PKG.assign_column('8', 'BO.asset_id', NULL,'JG_RX_FAREG.var.asset_id','NUMBER');
188: FA_RX_UTIL_PKG.assign_column('9', 'AD.asset_number', 'asset_number','JG_RX_FAREG.var.asset_number','VARCHAR2', 25);
189: FA_RX_UTIL_PKG.assign_column('10', 'AD.description', 'description','JG_RX_FAREG.var.description','VARCHAR2', 80);
190:
191: FA_RX_UTIL_PKG.assign_column('11', 'AD.parent_asset_id', NULL,'JG_RX_FAREG.var.parent_asset_id','NUMBER');
192: FA_RX_UTIL_PKG.assign_column('12', NULL, 'parent_asset_number','JG_RX_FAREG.var.parent_asset_number','VARCHAR2', 15);
193:
187: FA_RX_UTIL_PKG.assign_column('8', 'BO.asset_id', NULL,'JG_RX_FAREG.var.asset_id','NUMBER');
188: FA_RX_UTIL_PKG.assign_column('9', 'AD.asset_number', 'asset_number','JG_RX_FAREG.var.asset_number','VARCHAR2', 25);
189: FA_RX_UTIL_PKG.assign_column('10', 'AD.description', 'description','JG_RX_FAREG.var.description','VARCHAR2', 80);
190:
191: FA_RX_UTIL_PKG.assign_column('11', 'AD.parent_asset_id', NULL,'JG_RX_FAREG.var.parent_asset_id','NUMBER');
192: FA_RX_UTIL_PKG.assign_column('12', NULL, 'parent_asset_number','JG_RX_FAREG.var.parent_asset_number','VARCHAR2', 15);
193:
194: FA_RX_UTIL_PKG.assign_column('13', 'BO.original_cost', 'asset_cost_orig','JG_RX_FAREG.var.asset_cost_orig','NUMBER');
195:
188: FA_RX_UTIL_PKG.assign_column('9', 'AD.asset_number', 'asset_number','JG_RX_FAREG.var.asset_number','VARCHAR2', 25);
189: FA_RX_UTIL_PKG.assign_column('10', 'AD.description', 'description','JG_RX_FAREG.var.description','VARCHAR2', 80);
190:
191: FA_RX_UTIL_PKG.assign_column('11', 'AD.parent_asset_id', NULL,'JG_RX_FAREG.var.parent_asset_id','NUMBER');
192: FA_RX_UTIL_PKG.assign_column('12', NULL, 'parent_asset_number','JG_RX_FAREG.var.parent_asset_number','VARCHAR2', 15);
193:
194: FA_RX_UTIL_PKG.assign_column('13', 'BO.original_cost', 'asset_cost_orig','JG_RX_FAREG.var.asset_cost_orig','NUMBER');
195:
196: FA_RX_UTIL_PKG.assign_column('14', NULL, 'bonus_rate','JG_RX_FAREG.var.bonus_rate','NUMBER');
190:
191: FA_RX_UTIL_PKG.assign_column('11', 'AD.parent_asset_id', NULL,'JG_RX_FAREG.var.parent_asset_id','NUMBER');
192: FA_RX_UTIL_PKG.assign_column('12', NULL, 'parent_asset_number','JG_RX_FAREG.var.parent_asset_number','VARCHAR2', 15);
193:
194: FA_RX_UTIL_PKG.assign_column('13', 'BO.original_cost', 'asset_cost_orig','JG_RX_FAREG.var.asset_cost_orig','NUMBER');
195:
196: FA_RX_UTIL_PKG.assign_column('14', NULL, 'bonus_rate','JG_RX_FAREG.var.bonus_rate','NUMBER');
197:
198: FA_RX_UTIL_PKG.assign_column('15', NULL, 'invoice_number','JG_RX_FAREG.var.invoice_number','VARCHAR2', 50);
192: FA_RX_UTIL_PKG.assign_column('12', NULL, 'parent_asset_number','JG_RX_FAREG.var.parent_asset_number','VARCHAR2', 15);
193:
194: FA_RX_UTIL_PKG.assign_column('13', 'BO.original_cost', 'asset_cost_orig','JG_RX_FAREG.var.asset_cost_orig','NUMBER');
195:
196: FA_RX_UTIL_PKG.assign_column('14', NULL, 'bonus_rate','JG_RX_FAREG.var.bonus_rate','NUMBER');
197:
198: FA_RX_UTIL_PKG.assign_column('15', NULL, 'invoice_number','JG_RX_FAREG.var.invoice_number','VARCHAR2', 50);
199: FA_RX_UTIL_PKG.assign_column('16', NULL, 'supplier_name','JG_RX_FAREG.var.supplier_name','VARCHAR2', 360);
200:
194: FA_RX_UTIL_PKG.assign_column('13', 'BO.original_cost', 'asset_cost_orig','JG_RX_FAREG.var.asset_cost_orig','NUMBER');
195:
196: FA_RX_UTIL_PKG.assign_column('14', NULL, 'bonus_rate','JG_RX_FAREG.var.bonus_rate','NUMBER');
197:
198: FA_RX_UTIL_PKG.assign_column('15', NULL, 'invoice_number','JG_RX_FAREG.var.invoice_number','VARCHAR2', 50);
199: FA_RX_UTIL_PKG.assign_column('16', NULL, 'supplier_name','JG_RX_FAREG.var.supplier_name','VARCHAR2', 360);
200:
201: FA_RX_UTIL_PKG.assign_column('17', 'CB.asset_cost_acct', 'cost_account','JG_RX_FAREG.var.cost_account','VARCHAR2', 25);
202:
195:
196: FA_RX_UTIL_PKG.assign_column('14', NULL, 'bonus_rate','JG_RX_FAREG.var.bonus_rate','NUMBER');
197:
198: FA_RX_UTIL_PKG.assign_column('15', NULL, 'invoice_number','JG_RX_FAREG.var.invoice_number','VARCHAR2', 50);
199: FA_RX_UTIL_PKG.assign_column('16', NULL, 'supplier_name','JG_RX_FAREG.var.supplier_name','VARCHAR2', 360);
200:
201: FA_RX_UTIL_PKG.assign_column('17', 'CB.asset_cost_acct', 'cost_account','JG_RX_FAREG.var.cost_account','VARCHAR2', 25);
202:
203: FA_RX_UTIL_PKG.assign_column('18', NULL, 'expense_account','JG_RX_FAREG.var.expense_account','VARCHAR2', 25);
197:
198: FA_RX_UTIL_PKG.assign_column('15', NULL, 'invoice_number','JG_RX_FAREG.var.invoice_number','VARCHAR2', 50);
199: FA_RX_UTIL_PKG.assign_column('16', NULL, 'supplier_name','JG_RX_FAREG.var.supplier_name','VARCHAR2', 360);
200:
201: FA_RX_UTIL_PKG.assign_column('17', 'CB.asset_cost_acct', 'cost_account','JG_RX_FAREG.var.cost_account','VARCHAR2', 25);
202:
203: FA_RX_UTIL_PKG.assign_column('18', NULL, 'expense_account','JG_RX_FAREG.var.expense_account','VARCHAR2', 25);
204: FA_RX_UTIL_PKG.assign_column('19', 'CB.deprn_reserve_acct', 'reserve_account','JG_RX_FAREG.var.reserve_account','VARCHAR2', 25);
205:
199: FA_RX_UTIL_PKG.assign_column('16', NULL, 'supplier_name','JG_RX_FAREG.var.supplier_name','VARCHAR2', 360);
200:
201: FA_RX_UTIL_PKG.assign_column('17', 'CB.asset_cost_acct', 'cost_account','JG_RX_FAREG.var.cost_account','VARCHAR2', 25);
202:
203: FA_RX_UTIL_PKG.assign_column('18', NULL, 'expense_account','JG_RX_FAREG.var.expense_account','VARCHAR2', 25);
204: FA_RX_UTIL_PKG.assign_column('19', 'CB.deprn_reserve_acct', 'reserve_account','JG_RX_FAREG.var.reserve_account','VARCHAR2', 25);
205:
206: FA_RX_UTIL_PKG.assign_column('20', 'CB.bonus_deprn_expense_acct', 'bonus_deprn_account','JG_RX_FAREG.var.bonus_deprn_account','VARCHAR2', 25);
207: FA_RX_UTIL_PKG.assign_column('21', 'CB.bonus_deprn_reserve_acct', 'bonus_reserve_account','JG_RX_FAREG.var.bonus_reserve_account','VARCHAR2', 25);
200:
201: FA_RX_UTIL_PKG.assign_column('17', 'CB.asset_cost_acct', 'cost_account','JG_RX_FAREG.var.cost_account','VARCHAR2', 25);
202:
203: FA_RX_UTIL_PKG.assign_column('18', NULL, 'expense_account','JG_RX_FAREG.var.expense_account','VARCHAR2', 25);
204: FA_RX_UTIL_PKG.assign_column('19', 'CB.deprn_reserve_acct', 'reserve_account','JG_RX_FAREG.var.reserve_account','VARCHAR2', 25);
205:
206: FA_RX_UTIL_PKG.assign_column('20', 'CB.bonus_deprn_expense_acct', 'bonus_deprn_account','JG_RX_FAREG.var.bonus_deprn_account','VARCHAR2', 25);
207: FA_RX_UTIL_PKG.assign_column('21', 'CB.bonus_deprn_reserve_acct', 'bonus_reserve_account','JG_RX_FAREG.var.bonus_reserve_account','VARCHAR2', 25);
208:
202:
203: FA_RX_UTIL_PKG.assign_column('18', NULL, 'expense_account','JG_RX_FAREG.var.expense_account','VARCHAR2', 25);
204: FA_RX_UTIL_PKG.assign_column('19', 'CB.deprn_reserve_acct', 'reserve_account','JG_RX_FAREG.var.reserve_account','VARCHAR2', 25);
205:
206: FA_RX_UTIL_PKG.assign_column('20', 'CB.bonus_deprn_expense_acct', 'bonus_deprn_account','JG_RX_FAREG.var.bonus_deprn_account','VARCHAR2', 25);
207: FA_RX_UTIL_PKG.assign_column('21', 'CB.bonus_deprn_reserve_acct', 'bonus_reserve_account','JG_RX_FAREG.var.bonus_reserve_account','VARCHAR2', 25);
208:
209: FA_RX_UTIL_PKG.assign_column('22', NULL, 'asset_cost_initial','JG_RX_FAREG.var.asset_cost_initial', 'NUMBER');
210: FA_RX_UTIL_PKG.assign_column('23', NULL, 'asset_cost_increase','JG_RX_FAREG.var.asset_cost_increase', 'NUMBER');
203: FA_RX_UTIL_PKG.assign_column('18', NULL, 'expense_account','JG_RX_FAREG.var.expense_account','VARCHAR2', 25);
204: FA_RX_UTIL_PKG.assign_column('19', 'CB.deprn_reserve_acct', 'reserve_account','JG_RX_FAREG.var.reserve_account','VARCHAR2', 25);
205:
206: FA_RX_UTIL_PKG.assign_column('20', 'CB.bonus_deprn_expense_acct', 'bonus_deprn_account','JG_RX_FAREG.var.bonus_deprn_account','VARCHAR2', 25);
207: FA_RX_UTIL_PKG.assign_column('21', 'CB.bonus_deprn_reserve_acct', 'bonus_reserve_account','JG_RX_FAREG.var.bonus_reserve_account','VARCHAR2', 25);
208:
209: FA_RX_UTIL_PKG.assign_column('22', NULL, 'asset_cost_initial','JG_RX_FAREG.var.asset_cost_initial', 'NUMBER');
210: FA_RX_UTIL_PKG.assign_column('23', NULL, 'asset_cost_increase','JG_RX_FAREG.var.asset_cost_increase', 'NUMBER');
211: FA_RX_UTIL_PKG.assign_column('24', NULL, 'asset_cost_decrease','JG_RX_FAREG.var.asset_cost_decrease', 'NUMBER');
205:
206: FA_RX_UTIL_PKG.assign_column('20', 'CB.bonus_deprn_expense_acct', 'bonus_deprn_account','JG_RX_FAREG.var.bonus_deprn_account','VARCHAR2', 25);
207: FA_RX_UTIL_PKG.assign_column('21', 'CB.bonus_deprn_reserve_acct', 'bonus_reserve_account','JG_RX_FAREG.var.bonus_reserve_account','VARCHAR2', 25);
208:
209: FA_RX_UTIL_PKG.assign_column('22', NULL, 'asset_cost_initial','JG_RX_FAREG.var.asset_cost_initial', 'NUMBER');
210: FA_RX_UTIL_PKG.assign_column('23', NULL, 'asset_cost_increase','JG_RX_FAREG.var.asset_cost_increase', 'NUMBER');
211: FA_RX_UTIL_PKG.assign_column('24', NULL, 'asset_cost_decrease','JG_RX_FAREG.var.asset_cost_decrease', 'NUMBER');
212: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_cost_final','JG_RX_FAREG.var.asset_cost_final', 'NUMBER');
213:
206: FA_RX_UTIL_PKG.assign_column('20', 'CB.bonus_deprn_expense_acct', 'bonus_deprn_account','JG_RX_FAREG.var.bonus_deprn_account','VARCHAR2', 25);
207: FA_RX_UTIL_PKG.assign_column('21', 'CB.bonus_deprn_reserve_acct', 'bonus_reserve_account','JG_RX_FAREG.var.bonus_reserve_account','VARCHAR2', 25);
208:
209: FA_RX_UTIL_PKG.assign_column('22', NULL, 'asset_cost_initial','JG_RX_FAREG.var.asset_cost_initial', 'NUMBER');
210: FA_RX_UTIL_PKG.assign_column('23', NULL, 'asset_cost_increase','JG_RX_FAREG.var.asset_cost_increase', 'NUMBER');
211: FA_RX_UTIL_PKG.assign_column('24', NULL, 'asset_cost_decrease','JG_RX_FAREG.var.asset_cost_decrease', 'NUMBER');
212: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_cost_final','JG_RX_FAREG.var.asset_cost_final', 'NUMBER');
213:
214: FA_RX_UTIL_PKG.assign_column('26', NULL, 'revaluation_initial','JG_RX_FAREG.var.revaluation_initial', 'NUMBER');
207: FA_RX_UTIL_PKG.assign_column('21', 'CB.bonus_deprn_reserve_acct', 'bonus_reserve_account','JG_RX_FAREG.var.bonus_reserve_account','VARCHAR2', 25);
208:
209: FA_RX_UTIL_PKG.assign_column('22', NULL, 'asset_cost_initial','JG_RX_FAREG.var.asset_cost_initial', 'NUMBER');
210: FA_RX_UTIL_PKG.assign_column('23', NULL, 'asset_cost_increase','JG_RX_FAREG.var.asset_cost_increase', 'NUMBER');
211: FA_RX_UTIL_PKG.assign_column('24', NULL, 'asset_cost_decrease','JG_RX_FAREG.var.asset_cost_decrease', 'NUMBER');
212: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_cost_final','JG_RX_FAREG.var.asset_cost_final', 'NUMBER');
213:
214: FA_RX_UTIL_PKG.assign_column('26', NULL, 'revaluation_initial','JG_RX_FAREG.var.revaluation_initial', 'NUMBER');
215: FA_RX_UTIL_PKG.assign_column('27', NULL, 'revaluation_increase','JG_RX_FAREG.var.revaluation_increase', 'NUMBER');
208:
209: FA_RX_UTIL_PKG.assign_column('22', NULL, 'asset_cost_initial','JG_RX_FAREG.var.asset_cost_initial', 'NUMBER');
210: FA_RX_UTIL_PKG.assign_column('23', NULL, 'asset_cost_increase','JG_RX_FAREG.var.asset_cost_increase', 'NUMBER');
211: FA_RX_UTIL_PKG.assign_column('24', NULL, 'asset_cost_decrease','JG_RX_FAREG.var.asset_cost_decrease', 'NUMBER');
212: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_cost_final','JG_RX_FAREG.var.asset_cost_final', 'NUMBER');
213:
214: FA_RX_UTIL_PKG.assign_column('26', NULL, 'revaluation_initial','JG_RX_FAREG.var.revaluation_initial', 'NUMBER');
215: FA_RX_UTIL_PKG.assign_column('27', NULL, 'revaluation_increase','JG_RX_FAREG.var.revaluation_increase', 'NUMBER');
216: FA_RX_UTIL_PKG.assign_column('28', NULL, 'revaluation_decrease','JG_RX_FAREG.var.revaluation_decrease', 'NUMBER');
210: FA_RX_UTIL_PKG.assign_column('23', NULL, 'asset_cost_increase','JG_RX_FAREG.var.asset_cost_increase', 'NUMBER');
211: FA_RX_UTIL_PKG.assign_column('24', NULL, 'asset_cost_decrease','JG_RX_FAREG.var.asset_cost_decrease', 'NUMBER');
212: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_cost_final','JG_RX_FAREG.var.asset_cost_final', 'NUMBER');
213:
214: FA_RX_UTIL_PKG.assign_column('26', NULL, 'revaluation_initial','JG_RX_FAREG.var.revaluation_initial', 'NUMBER');
215: FA_RX_UTIL_PKG.assign_column('27', NULL, 'revaluation_increase','JG_RX_FAREG.var.revaluation_increase', 'NUMBER');
216: FA_RX_UTIL_PKG.assign_column('28', NULL, 'revaluation_decrease','JG_RX_FAREG.var.revaluation_decrease', 'NUMBER');
217: FA_RX_UTIL_PKG.assign_column('29', NULL, 'revaluation_final','JG_RX_FAREG.var.revaluation_final', 'NUMBER');
218:
211: FA_RX_UTIL_PKG.assign_column('24', NULL, 'asset_cost_decrease','JG_RX_FAREG.var.asset_cost_decrease', 'NUMBER');
212: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_cost_final','JG_RX_FAREG.var.asset_cost_final', 'NUMBER');
213:
214: FA_RX_UTIL_PKG.assign_column('26', NULL, 'revaluation_initial','JG_RX_FAREG.var.revaluation_initial', 'NUMBER');
215: FA_RX_UTIL_PKG.assign_column('27', NULL, 'revaluation_increase','JG_RX_FAREG.var.revaluation_increase', 'NUMBER');
216: FA_RX_UTIL_PKG.assign_column('28', NULL, 'revaluation_decrease','JG_RX_FAREG.var.revaluation_decrease', 'NUMBER');
217: FA_RX_UTIL_PKG.assign_column('29', NULL, 'revaluation_final','JG_RX_FAREG.var.revaluation_final', 'NUMBER');
218:
219: FA_RX_UTIL_PKG.assign_column('30', NULL, 'deprn_reserve_initial','JG_RX_FAREG.var.deprn_reserve_initial', 'NUMBER');
212: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_cost_final','JG_RX_FAREG.var.asset_cost_final', 'NUMBER');
213:
214: FA_RX_UTIL_PKG.assign_column('26', NULL, 'revaluation_initial','JG_RX_FAREG.var.revaluation_initial', 'NUMBER');
215: FA_RX_UTIL_PKG.assign_column('27', NULL, 'revaluation_increase','JG_RX_FAREG.var.revaluation_increase', 'NUMBER');
216: FA_RX_UTIL_PKG.assign_column('28', NULL, 'revaluation_decrease','JG_RX_FAREG.var.revaluation_decrease', 'NUMBER');
217: FA_RX_UTIL_PKG.assign_column('29', NULL, 'revaluation_final','JG_RX_FAREG.var.revaluation_final', 'NUMBER');
218:
219: FA_RX_UTIL_PKG.assign_column('30', NULL, 'deprn_reserve_initial','JG_RX_FAREG.var.deprn_reserve_initial', 'NUMBER');
220: FA_RX_UTIL_PKG.assign_column('31', NULL, 'deprn_reserve_increase','JG_RX_FAREG.var.deprn_reserve_increase', 'NUMBER');
213:
214: FA_RX_UTIL_PKG.assign_column('26', NULL, 'revaluation_initial','JG_RX_FAREG.var.revaluation_initial', 'NUMBER');
215: FA_RX_UTIL_PKG.assign_column('27', NULL, 'revaluation_increase','JG_RX_FAREG.var.revaluation_increase', 'NUMBER');
216: FA_RX_UTIL_PKG.assign_column('28', NULL, 'revaluation_decrease','JG_RX_FAREG.var.revaluation_decrease', 'NUMBER');
217: FA_RX_UTIL_PKG.assign_column('29', NULL, 'revaluation_final','JG_RX_FAREG.var.revaluation_final', 'NUMBER');
218:
219: FA_RX_UTIL_PKG.assign_column('30', NULL, 'deprn_reserve_initial','JG_RX_FAREG.var.deprn_reserve_initial', 'NUMBER');
220: FA_RX_UTIL_PKG.assign_column('31', NULL, 'deprn_reserve_increase','JG_RX_FAREG.var.deprn_reserve_increase', 'NUMBER');
221: FA_RX_UTIL_PKG.assign_column('32', NULL, 'deprn_reserve_decrease','JG_RX_FAREG.var.deprn_reserve_decrease', 'NUMBER');
215: FA_RX_UTIL_PKG.assign_column('27', NULL, 'revaluation_increase','JG_RX_FAREG.var.revaluation_increase', 'NUMBER');
216: FA_RX_UTIL_PKG.assign_column('28', NULL, 'revaluation_decrease','JG_RX_FAREG.var.revaluation_decrease', 'NUMBER');
217: FA_RX_UTIL_PKG.assign_column('29', NULL, 'revaluation_final','JG_RX_FAREG.var.revaluation_final', 'NUMBER');
218:
219: FA_RX_UTIL_PKG.assign_column('30', NULL, 'deprn_reserve_initial','JG_RX_FAREG.var.deprn_reserve_initial', 'NUMBER');
220: FA_RX_UTIL_PKG.assign_column('31', NULL, 'deprn_reserve_increase','JG_RX_FAREG.var.deprn_reserve_increase', 'NUMBER');
221: FA_RX_UTIL_PKG.assign_column('32', NULL, 'deprn_reserve_decrease','JG_RX_FAREG.var.deprn_reserve_decrease', 'NUMBER');
222: FA_RX_UTIL_PKG.assign_column('33', NULL, 'deprn_reserve_final','JG_RX_FAREG.var.deprn_reserve_final', 'NUMBER');
223:
216: FA_RX_UTIL_PKG.assign_column('28', NULL, 'revaluation_decrease','JG_RX_FAREG.var.revaluation_decrease', 'NUMBER');
217: FA_RX_UTIL_PKG.assign_column('29', NULL, 'revaluation_final','JG_RX_FAREG.var.revaluation_final', 'NUMBER');
218:
219: FA_RX_UTIL_PKG.assign_column('30', NULL, 'deprn_reserve_initial','JG_RX_FAREG.var.deprn_reserve_initial', 'NUMBER');
220: FA_RX_UTIL_PKG.assign_column('31', NULL, 'deprn_reserve_increase','JG_RX_FAREG.var.deprn_reserve_increase', 'NUMBER');
221: FA_RX_UTIL_PKG.assign_column('32', NULL, 'deprn_reserve_decrease','JG_RX_FAREG.var.deprn_reserve_decrease', 'NUMBER');
222: FA_RX_UTIL_PKG.assign_column('33', NULL, 'deprn_reserve_final','JG_RX_FAREG.var.deprn_reserve_final', 'NUMBER');
223:
224: FA_RX_UTIL_PKG.assign_column('34', NULL, 'bonus_reserve_initial','JG_RX_FAREG.var.bonus_reserve_initial', 'NUMBER');
217: FA_RX_UTIL_PKG.assign_column('29', NULL, 'revaluation_final','JG_RX_FAREG.var.revaluation_final', 'NUMBER');
218:
219: FA_RX_UTIL_PKG.assign_column('30', NULL, 'deprn_reserve_initial','JG_RX_FAREG.var.deprn_reserve_initial', 'NUMBER');
220: FA_RX_UTIL_PKG.assign_column('31', NULL, 'deprn_reserve_increase','JG_RX_FAREG.var.deprn_reserve_increase', 'NUMBER');
221: FA_RX_UTIL_PKG.assign_column('32', NULL, 'deprn_reserve_decrease','JG_RX_FAREG.var.deprn_reserve_decrease', 'NUMBER');
222: FA_RX_UTIL_PKG.assign_column('33', NULL, 'deprn_reserve_final','JG_RX_FAREG.var.deprn_reserve_final', 'NUMBER');
223:
224: FA_RX_UTIL_PKG.assign_column('34', NULL, 'bonus_reserve_initial','JG_RX_FAREG.var.bonus_reserve_initial', 'NUMBER');
225: FA_RX_UTIL_PKG.assign_column('35', NULL, 'bonus_reserve_increase','JG_RX_FAREG.var.bonus_reserve_increase', 'NUMBER');
218:
219: FA_RX_UTIL_PKG.assign_column('30', NULL, 'deprn_reserve_initial','JG_RX_FAREG.var.deprn_reserve_initial', 'NUMBER');
220: FA_RX_UTIL_PKG.assign_column('31', NULL, 'deprn_reserve_increase','JG_RX_FAREG.var.deprn_reserve_increase', 'NUMBER');
221: FA_RX_UTIL_PKG.assign_column('32', NULL, 'deprn_reserve_decrease','JG_RX_FAREG.var.deprn_reserve_decrease', 'NUMBER');
222: FA_RX_UTIL_PKG.assign_column('33', NULL, 'deprn_reserve_final','JG_RX_FAREG.var.deprn_reserve_final', 'NUMBER');
223:
224: FA_RX_UTIL_PKG.assign_column('34', NULL, 'bonus_reserve_initial','JG_RX_FAREG.var.bonus_reserve_initial', 'NUMBER');
225: FA_RX_UTIL_PKG.assign_column('35', NULL, 'bonus_reserve_increase','JG_RX_FAREG.var.bonus_reserve_increase', 'NUMBER');
226: FA_RX_UTIL_PKG.assign_column('36', NULL, 'bonus_reserve_decrease','JG_RX_FAREG.var.bonus_reserve_decrease', 'NUMBER');
220: FA_RX_UTIL_PKG.assign_column('31', NULL, 'deprn_reserve_increase','JG_RX_FAREG.var.deprn_reserve_increase', 'NUMBER');
221: FA_RX_UTIL_PKG.assign_column('32', NULL, 'deprn_reserve_decrease','JG_RX_FAREG.var.deprn_reserve_decrease', 'NUMBER');
222: FA_RX_UTIL_PKG.assign_column('33', NULL, 'deprn_reserve_final','JG_RX_FAREG.var.deprn_reserve_final', 'NUMBER');
223:
224: FA_RX_UTIL_PKG.assign_column('34', NULL, 'bonus_reserve_initial','JG_RX_FAREG.var.bonus_reserve_initial', 'NUMBER');
225: FA_RX_UTIL_PKG.assign_column('35', NULL, 'bonus_reserve_increase','JG_RX_FAREG.var.bonus_reserve_increase', 'NUMBER');
226: FA_RX_UTIL_PKG.assign_column('36', NULL, 'bonus_reserve_decrease','JG_RX_FAREG.var.bonus_reserve_decrease', 'NUMBER');
227: FA_RX_UTIL_PKG.assign_column('37', NULL, 'bonus_reserve_final','JG_RX_FAREG.var.bonus_reserve_final', 'NUMBER');
228:
221: FA_RX_UTIL_PKG.assign_column('32', NULL, 'deprn_reserve_decrease','JG_RX_FAREG.var.deprn_reserve_decrease', 'NUMBER');
222: FA_RX_UTIL_PKG.assign_column('33', NULL, 'deprn_reserve_final','JG_RX_FAREG.var.deprn_reserve_final', 'NUMBER');
223:
224: FA_RX_UTIL_PKG.assign_column('34', NULL, 'bonus_reserve_initial','JG_RX_FAREG.var.bonus_reserve_initial', 'NUMBER');
225: FA_RX_UTIL_PKG.assign_column('35', NULL, 'bonus_reserve_increase','JG_RX_FAREG.var.bonus_reserve_increase', 'NUMBER');
226: FA_RX_UTIL_PKG.assign_column('36', NULL, 'bonus_reserve_decrease','JG_RX_FAREG.var.bonus_reserve_decrease', 'NUMBER');
227: FA_RX_UTIL_PKG.assign_column('37', NULL, 'bonus_reserve_final','JG_RX_FAREG.var.bonus_reserve_final', 'NUMBER');
228:
229: FA_RX_UTIL_PKG.assign_column('38', NULL, 'net_book_value_initial','JG_RX_FAREG.var.net_book_value_initial', 'NUMBER');
222: FA_RX_UTIL_PKG.assign_column('33', NULL, 'deprn_reserve_final','JG_RX_FAREG.var.deprn_reserve_final', 'NUMBER');
223:
224: FA_RX_UTIL_PKG.assign_column('34', NULL, 'bonus_reserve_initial','JG_RX_FAREG.var.bonus_reserve_initial', 'NUMBER');
225: FA_RX_UTIL_PKG.assign_column('35', NULL, 'bonus_reserve_increase','JG_RX_FAREG.var.bonus_reserve_increase', 'NUMBER');
226: FA_RX_UTIL_PKG.assign_column('36', NULL, 'bonus_reserve_decrease','JG_RX_FAREG.var.bonus_reserve_decrease', 'NUMBER');
227: FA_RX_UTIL_PKG.assign_column('37', NULL, 'bonus_reserve_final','JG_RX_FAREG.var.bonus_reserve_final', 'NUMBER');
228:
229: FA_RX_UTIL_PKG.assign_column('38', NULL, 'net_book_value_initial','JG_RX_FAREG.var.net_book_value_initial', 'NUMBER');
230: FA_RX_UTIL_PKG.assign_column('39', NULL, 'net_book_value_increase','JG_RX_FAREG.var.net_book_value_increase', 'NUMBER');
223:
224: FA_RX_UTIL_PKG.assign_column('34', NULL, 'bonus_reserve_initial','JG_RX_FAREG.var.bonus_reserve_initial', 'NUMBER');
225: FA_RX_UTIL_PKG.assign_column('35', NULL, 'bonus_reserve_increase','JG_RX_FAREG.var.bonus_reserve_increase', 'NUMBER');
226: FA_RX_UTIL_PKG.assign_column('36', NULL, 'bonus_reserve_decrease','JG_RX_FAREG.var.bonus_reserve_decrease', 'NUMBER');
227: FA_RX_UTIL_PKG.assign_column('37', NULL, 'bonus_reserve_final','JG_RX_FAREG.var.bonus_reserve_final', 'NUMBER');
228:
229: FA_RX_UTIL_PKG.assign_column('38', NULL, 'net_book_value_initial','JG_RX_FAREG.var.net_book_value_initial', 'NUMBER');
230: FA_RX_UTIL_PKG.assign_column('39', NULL, 'net_book_value_increase','JG_RX_FAREG.var.net_book_value_increase', 'NUMBER');
231: FA_RX_UTIL_PKG.assign_column('40', NULL, 'net_book_value_decrease','JG_RX_FAREG.var.net_book_value_decrease', 'NUMBER');
225: FA_RX_UTIL_PKG.assign_column('35', NULL, 'bonus_reserve_increase','JG_RX_FAREG.var.bonus_reserve_increase', 'NUMBER');
226: FA_RX_UTIL_PKG.assign_column('36', NULL, 'bonus_reserve_decrease','JG_RX_FAREG.var.bonus_reserve_decrease', 'NUMBER');
227: FA_RX_UTIL_PKG.assign_column('37', NULL, 'bonus_reserve_final','JG_RX_FAREG.var.bonus_reserve_final', 'NUMBER');
228:
229: FA_RX_UTIL_PKG.assign_column('38', NULL, 'net_book_value_initial','JG_RX_FAREG.var.net_book_value_initial', 'NUMBER');
230: FA_RX_UTIL_PKG.assign_column('39', NULL, 'net_book_value_increase','JG_RX_FAREG.var.net_book_value_increase', 'NUMBER');
231: FA_RX_UTIL_PKG.assign_column('40', NULL, 'net_book_value_decrease','JG_RX_FAREG.var.net_book_value_decrease', 'NUMBER');
232: FA_RX_UTIL_PKG.assign_column('41', NULL, 'net_book_value_final','JG_RX_FAREG.var.net_book_value_final', 'NUMBER');
233: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JG_RX_FAREG.var.transaction_date', 'DATE');
226: FA_RX_UTIL_PKG.assign_column('36', NULL, 'bonus_reserve_decrease','JG_RX_FAREG.var.bonus_reserve_decrease', 'NUMBER');
227: FA_RX_UTIL_PKG.assign_column('37', NULL, 'bonus_reserve_final','JG_RX_FAREG.var.bonus_reserve_final', 'NUMBER');
228:
229: FA_RX_UTIL_PKG.assign_column('38', NULL, 'net_book_value_initial','JG_RX_FAREG.var.net_book_value_initial', 'NUMBER');
230: FA_RX_UTIL_PKG.assign_column('39', NULL, 'net_book_value_increase','JG_RX_FAREG.var.net_book_value_increase', 'NUMBER');
231: FA_RX_UTIL_PKG.assign_column('40', NULL, 'net_book_value_decrease','JG_RX_FAREG.var.net_book_value_decrease', 'NUMBER');
232: FA_RX_UTIL_PKG.assign_column('41', NULL, 'net_book_value_final','JG_RX_FAREG.var.net_book_value_final', 'NUMBER');
233: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JG_RX_FAREG.var.transaction_date', 'DATE');
234: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JG_RX_FAREG.var.transaction_number', 'NUMBER');
227: FA_RX_UTIL_PKG.assign_column('37', NULL, 'bonus_reserve_final','JG_RX_FAREG.var.bonus_reserve_final', 'NUMBER');
228:
229: FA_RX_UTIL_PKG.assign_column('38', NULL, 'net_book_value_initial','JG_RX_FAREG.var.net_book_value_initial', 'NUMBER');
230: FA_RX_UTIL_PKG.assign_column('39', NULL, 'net_book_value_increase','JG_RX_FAREG.var.net_book_value_increase', 'NUMBER');
231: FA_RX_UTIL_PKG.assign_column('40', NULL, 'net_book_value_decrease','JG_RX_FAREG.var.net_book_value_decrease', 'NUMBER');
232: FA_RX_UTIL_PKG.assign_column('41', NULL, 'net_book_value_final','JG_RX_FAREG.var.net_book_value_final', 'NUMBER');
233: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JG_RX_FAREG.var.transaction_date', 'DATE');
234: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JG_RX_FAREG.var.transaction_number', 'NUMBER');
235: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JG_RX_FAREG.var.transaction_code', 'VARCHAR2', 20);
228:
229: FA_RX_UTIL_PKG.assign_column('38', NULL, 'net_book_value_initial','JG_RX_FAREG.var.net_book_value_initial', 'NUMBER');
230: FA_RX_UTIL_PKG.assign_column('39', NULL, 'net_book_value_increase','JG_RX_FAREG.var.net_book_value_increase', 'NUMBER');
231: FA_RX_UTIL_PKG.assign_column('40', NULL, 'net_book_value_decrease','JG_RX_FAREG.var.net_book_value_decrease', 'NUMBER');
232: FA_RX_UTIL_PKG.assign_column('41', NULL, 'net_book_value_final','JG_RX_FAREG.var.net_book_value_final', 'NUMBER');
233: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JG_RX_FAREG.var.transaction_date', 'DATE');
234: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JG_RX_FAREG.var.transaction_number', 'NUMBER');
235: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JG_RX_FAREG.var.transaction_code', 'VARCHAR2', 20);
236: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JG_RX_FAREG.var.transaction_amount', 'NUMBER');
229: FA_RX_UTIL_PKG.assign_column('38', NULL, 'net_book_value_initial','JG_RX_FAREG.var.net_book_value_initial', 'NUMBER');
230: FA_RX_UTIL_PKG.assign_column('39', NULL, 'net_book_value_increase','JG_RX_FAREG.var.net_book_value_increase', 'NUMBER');
231: FA_RX_UTIL_PKG.assign_column('40', NULL, 'net_book_value_decrease','JG_RX_FAREG.var.net_book_value_decrease', 'NUMBER');
232: FA_RX_UTIL_PKG.assign_column('41', NULL, 'net_book_value_final','JG_RX_FAREG.var.net_book_value_final', 'NUMBER');
233: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JG_RX_FAREG.var.transaction_date', 'DATE');
234: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JG_RX_FAREG.var.transaction_number', 'NUMBER');
235: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JG_RX_FAREG.var.transaction_code', 'VARCHAR2', 20);
236: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JG_RX_FAREG.var.transaction_amount', 'NUMBER');
237: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JG_RX_FAREG.var.date_placed_in_service','DATE');
230: FA_RX_UTIL_PKG.assign_column('39', NULL, 'net_book_value_increase','JG_RX_FAREG.var.net_book_value_increase', 'NUMBER');
231: FA_RX_UTIL_PKG.assign_column('40', NULL, 'net_book_value_decrease','JG_RX_FAREG.var.net_book_value_decrease', 'NUMBER');
232: FA_RX_UTIL_PKG.assign_column('41', NULL, 'net_book_value_final','JG_RX_FAREG.var.net_book_value_final', 'NUMBER');
233: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JG_RX_FAREG.var.transaction_date', 'DATE');
234: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JG_RX_FAREG.var.transaction_number', 'NUMBER');
235: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JG_RX_FAREG.var.transaction_code', 'VARCHAR2', 20);
236: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JG_RX_FAREG.var.transaction_amount', 'NUMBER');
237: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JG_RX_FAREG.var.date_placed_in_service','DATE');
238: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JG_RX_FAREG.var.prorate_date','DATE');
231: FA_RX_UTIL_PKG.assign_column('40', NULL, 'net_book_value_decrease','JG_RX_FAREG.var.net_book_value_decrease', 'NUMBER');
232: FA_RX_UTIL_PKG.assign_column('41', NULL, 'net_book_value_final','JG_RX_FAREG.var.net_book_value_final', 'NUMBER');
233: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JG_RX_FAREG.var.transaction_date', 'DATE');
234: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JG_RX_FAREG.var.transaction_number', 'NUMBER');
235: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JG_RX_FAREG.var.transaction_code', 'VARCHAR2', 20);
236: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JG_RX_FAREG.var.transaction_amount', 'NUMBER');
237: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JG_RX_FAREG.var.date_placed_in_service','DATE');
238: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JG_RX_FAREG.var.prorate_date','DATE');
239: FA_RX_UTIL_PKG.assign_column('48', 'METH.method_id', NULL,'JG_RX_FAREG.var.method_id','NUMBER');
232: FA_RX_UTIL_PKG.assign_column('41', NULL, 'net_book_value_final','JG_RX_FAREG.var.net_book_value_final', 'NUMBER');
233: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JG_RX_FAREG.var.transaction_date', 'DATE');
234: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JG_RX_FAREG.var.transaction_number', 'NUMBER');
235: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JG_RX_FAREG.var.transaction_code', 'VARCHAR2', 20);
236: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JG_RX_FAREG.var.transaction_amount', 'NUMBER');
237: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JG_RX_FAREG.var.date_placed_in_service','DATE');
238: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JG_RX_FAREG.var.prorate_date','DATE');
239: FA_RX_UTIL_PKG.assign_column('48', 'METH.method_id', NULL,'JG_RX_FAREG.var.method_id','NUMBER');
240: FA_RX_UTIL_PKG.assign_column('49', 'METH.rate_source_rule', NULL,'JG_RX_FAREG.var.rate_source_rule','VARCHAR2', 10);
233: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JG_RX_FAREG.var.transaction_date', 'DATE');
234: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JG_RX_FAREG.var.transaction_number', 'NUMBER');
235: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JG_RX_FAREG.var.transaction_code', 'VARCHAR2', 20);
236: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JG_RX_FAREG.var.transaction_amount', 'NUMBER');
237: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JG_RX_FAREG.var.date_placed_in_service','DATE');
238: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JG_RX_FAREG.var.prorate_date','DATE');
239: FA_RX_UTIL_PKG.assign_column('48', 'METH.method_id', NULL,'JG_RX_FAREG.var.method_id','NUMBER');
240: FA_RX_UTIL_PKG.assign_column('49', 'METH.rate_source_rule', NULL,'JG_RX_FAREG.var.rate_source_rule','VARCHAR2', 10);
241: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JG_RX_FAREG.var.adjusted_rate','NUMBER');
234: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JG_RX_FAREG.var.transaction_number', 'NUMBER');
235: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JG_RX_FAREG.var.transaction_code', 'VARCHAR2', 20);
236: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JG_RX_FAREG.var.transaction_amount', 'NUMBER');
237: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JG_RX_FAREG.var.date_placed_in_service','DATE');
238: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JG_RX_FAREG.var.prorate_date','DATE');
239: FA_RX_UTIL_PKG.assign_column('48', 'METH.method_id', NULL,'JG_RX_FAREG.var.method_id','NUMBER');
240: FA_RX_UTIL_PKG.assign_column('49', 'METH.rate_source_rule', NULL,'JG_RX_FAREG.var.rate_source_rule','VARCHAR2', 10);
241: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JG_RX_FAREG.var.adjusted_rate','NUMBER');
242: --Modified for ECE Project
235: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JG_RX_FAREG.var.transaction_code', 'VARCHAR2', 20);
236: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JG_RX_FAREG.var.transaction_amount', 'NUMBER');
237: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JG_RX_FAREG.var.date_placed_in_service','DATE');
238: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JG_RX_FAREG.var.prorate_date','DATE');
239: FA_RX_UTIL_PKG.assign_column('48', 'METH.method_id', NULL,'JG_RX_FAREG.var.method_id','NUMBER');
240: FA_RX_UTIL_PKG.assign_column('49', 'METH.rate_source_rule', NULL,'JG_RX_FAREG.var.rate_source_rule','VARCHAR2', 10);
241: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JG_RX_FAREG.var.adjusted_rate','NUMBER');
242: --Modified for ECE Project
243: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', 'life_in_months','JG_RX_FAREG.var.life_in_months','NUMBER');
236: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JG_RX_FAREG.var.transaction_amount', 'NUMBER');
237: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JG_RX_FAREG.var.date_placed_in_service','DATE');
238: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JG_RX_FAREG.var.prorate_date','DATE');
239: FA_RX_UTIL_PKG.assign_column('48', 'METH.method_id', NULL,'JG_RX_FAREG.var.method_id','NUMBER');
240: FA_RX_UTIL_PKG.assign_column('49', 'METH.rate_source_rule', NULL,'JG_RX_FAREG.var.rate_source_rule','VARCHAR2', 10);
241: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JG_RX_FAREG.var.adjusted_rate','NUMBER');
242: --Modified for ECE Project
243: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', 'life_in_months','JG_RX_FAREG.var.life_in_months','NUMBER');
244: --
237: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JG_RX_FAREG.var.date_placed_in_service','DATE');
238: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JG_RX_FAREG.var.prorate_date','DATE');
239: FA_RX_UTIL_PKG.assign_column('48', 'METH.method_id', NULL,'JG_RX_FAREG.var.method_id','NUMBER');
240: FA_RX_UTIL_PKG.assign_column('49', 'METH.rate_source_rule', NULL,'JG_RX_FAREG.var.rate_source_rule','VARCHAR2', 10);
241: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JG_RX_FAREG.var.adjusted_rate','NUMBER');
242: --Modified for ECE Project
243: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', 'life_in_months','JG_RX_FAREG.var.life_in_months','NUMBER');
244: --
245: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JG_RX_FAREG.var.bonus_rule','VARCHAR2', 30);
239: FA_RX_UTIL_PKG.assign_column('48', 'METH.method_id', NULL,'JG_RX_FAREG.var.method_id','NUMBER');
240: FA_RX_UTIL_PKG.assign_column('49', 'METH.rate_source_rule', NULL,'JG_RX_FAREG.var.rate_source_rule','VARCHAR2', 10);
241: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JG_RX_FAREG.var.adjusted_rate','NUMBER');
242: --Modified for ECE Project
243: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', 'life_in_months','JG_RX_FAREG.var.life_in_months','NUMBER');
244: --
245: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JG_RX_FAREG.var.bonus_rule','VARCHAR2', 30);
246: FA_RX_UTIL_PKG.assign_column('53', NULL,'asset_heading','JG_RX_FAREG.var.asset_heading','VARCHAR2', 15);
247: FA_RX_UTIL_PKG.assign_column('54', NULL,'initial_heading','JG_RX_FAREG.var.initial_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
241: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JG_RX_FAREG.var.adjusted_rate','NUMBER');
242: --Modified for ECE Project
243: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', 'life_in_months','JG_RX_FAREG.var.life_in_months','NUMBER');
244: --
245: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JG_RX_FAREG.var.bonus_rule','VARCHAR2', 30);
246: FA_RX_UTIL_PKG.assign_column('53', NULL,'asset_heading','JG_RX_FAREG.var.asset_heading','VARCHAR2', 15);
247: FA_RX_UTIL_PKG.assign_column('54', NULL,'initial_heading','JG_RX_FAREG.var.initial_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
248: FA_RX_UTIL_PKG.assign_column('55', '''Variation''','variation_heading','JG_RX_FAREG.var.variation_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
249: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',
242: --Modified for ECE Project
243: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', 'life_in_months','JG_RX_FAREG.var.life_in_months','NUMBER');
244: --
245: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JG_RX_FAREG.var.bonus_rule','VARCHAR2', 30);
246: FA_RX_UTIL_PKG.assign_column('53', NULL,'asset_heading','JG_RX_FAREG.var.asset_heading','VARCHAR2', 15);
247: FA_RX_UTIL_PKG.assign_column('54', NULL,'initial_heading','JG_RX_FAREG.var.initial_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
248: FA_RX_UTIL_PKG.assign_column('55', '''Variation''','variation_heading','JG_RX_FAREG.var.variation_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
249: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',
250: 'JG_RX_FAREG.var.final_heading','VARCHAR2', 132); -- 09/08/00 AFERRARA
243: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', 'life_in_months','JG_RX_FAREG.var.life_in_months','NUMBER');
244: --
245: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JG_RX_FAREG.var.bonus_rule','VARCHAR2', 30);
246: FA_RX_UTIL_PKG.assign_column('53', NULL,'asset_heading','JG_RX_FAREG.var.asset_heading','VARCHAR2', 15);
247: FA_RX_UTIL_PKG.assign_column('54', NULL,'initial_heading','JG_RX_FAREG.var.initial_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
248: FA_RX_UTIL_PKG.assign_column('55', '''Variation''','variation_heading','JG_RX_FAREG.var.variation_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
249: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',
250: 'JG_RX_FAREG.var.final_heading','VARCHAR2', 132); -- 09/08/00 AFERRARA
251: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JG_RX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA
244: --
245: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JG_RX_FAREG.var.bonus_rule','VARCHAR2', 30);
246: FA_RX_UTIL_PKG.assign_column('53', NULL,'asset_heading','JG_RX_FAREG.var.asset_heading','VARCHAR2', 15);
247: FA_RX_UTIL_PKG.assign_column('54', NULL,'initial_heading','JG_RX_FAREG.var.initial_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
248: FA_RX_UTIL_PKG.assign_column('55', '''Variation''','variation_heading','JG_RX_FAREG.var.variation_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
249: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',
250: 'JG_RX_FAREG.var.final_heading','VARCHAR2', 132); -- 09/08/00 AFERRARA
251: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JG_RX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA
252: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JG_RX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA
245: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JG_RX_FAREG.var.bonus_rule','VARCHAR2', 30);
246: FA_RX_UTIL_PKG.assign_column('53', NULL,'asset_heading','JG_RX_FAREG.var.asset_heading','VARCHAR2', 15);
247: FA_RX_UTIL_PKG.assign_column('54', NULL,'initial_heading','JG_RX_FAREG.var.initial_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
248: FA_RX_UTIL_PKG.assign_column('55', '''Variation''','variation_heading','JG_RX_FAREG.var.variation_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
249: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',
250: 'JG_RX_FAREG.var.final_heading','VARCHAR2', 132); -- 09/08/00 AFERRARA
251: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JG_RX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA
252: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JG_RX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA
253: FA_RX_UTIL_PKG.assign_column('59', NULL, 'deprn_variation','JG_RX_FAREG.var.deprn_variation', 'NUMBER'); -- 09/08/00 AFERRARA
247: FA_RX_UTIL_PKG.assign_column('54', NULL,'initial_heading','JG_RX_FAREG.var.initial_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
248: FA_RX_UTIL_PKG.assign_column('55', '''Variation''','variation_heading','JG_RX_FAREG.var.variation_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
249: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',
250: 'JG_RX_FAREG.var.final_heading','VARCHAR2', 132); -- 09/08/00 AFERRARA
251: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JG_RX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA
252: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JG_RX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA
253: FA_RX_UTIL_PKG.assign_column('59', NULL, 'deprn_variation','JG_RX_FAREG.var.deprn_variation', 'NUMBER'); -- 09/08/00 AFERRARA
254: FA_RX_UTIL_PKG.assign_column('60', NULL, 'bonus_variation','JG_RX_FAREG.var.bonus_variation', 'NUMBER'); -- 09/08/00 AFERRARA
255: FA_RX_UTIL_PKG.assign_column('61', NULL, 'netbo_variation','JG_RX_FAREG.var.netbo_variation', 'NUMBER'); -- 09/08/00 AFERRARA
248: FA_RX_UTIL_PKG.assign_column('55', '''Variation''','variation_heading','JG_RX_FAREG.var.variation_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
249: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',
250: 'JG_RX_FAREG.var.final_heading','VARCHAR2', 132); -- 09/08/00 AFERRARA
251: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JG_RX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA
252: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JG_RX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA
253: FA_RX_UTIL_PKG.assign_column('59', NULL, 'deprn_variation','JG_RX_FAREG.var.deprn_variation', 'NUMBER'); -- 09/08/00 AFERRARA
254: FA_RX_UTIL_PKG.assign_column('60', NULL, 'bonus_variation','JG_RX_FAREG.var.bonus_variation', 'NUMBER'); -- 09/08/00 AFERRARA
255: FA_RX_UTIL_PKG.assign_column('61', NULL, 'netbo_variation','JG_RX_FAREG.var.netbo_variation', 'NUMBER'); -- 09/08/00 AFERRARA
256: FA_RX_UTIL_PKG.assign_column('62', NULL, 'revaluation_total','JG_RX_FAREG.var.revaluation_total', 'NUMBER'); -- 09/08/00 AFERRARA
249: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',
250: 'JG_RX_FAREG.var.final_heading','VARCHAR2', 132); -- 09/08/00 AFERRARA
251: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JG_RX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA
252: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JG_RX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA
253: FA_RX_UTIL_PKG.assign_column('59', NULL, 'deprn_variation','JG_RX_FAREG.var.deprn_variation', 'NUMBER'); -- 09/08/00 AFERRARA
254: FA_RX_UTIL_PKG.assign_column('60', NULL, 'bonus_variation','JG_RX_FAREG.var.bonus_variation', 'NUMBER'); -- 09/08/00 AFERRARA
255: FA_RX_UTIL_PKG.assign_column('61', NULL, 'netbo_variation','JG_RX_FAREG.var.netbo_variation', 'NUMBER'); -- 09/08/00 AFERRARA
256: FA_RX_UTIL_PKG.assign_column('62', NULL, 'revaluation_total','JG_RX_FAREG.var.revaluation_total', 'NUMBER'); -- 09/08/00 AFERRARA
257: --- Added for ECE Project
250: 'JG_RX_FAREG.var.final_heading','VARCHAR2', 132); -- 09/08/00 AFERRARA
251: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JG_RX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA
252: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JG_RX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA
253: FA_RX_UTIL_PKG.assign_column('59', NULL, 'deprn_variation','JG_RX_FAREG.var.deprn_variation', 'NUMBER'); -- 09/08/00 AFERRARA
254: FA_RX_UTIL_PKG.assign_column('60', NULL, 'bonus_variation','JG_RX_FAREG.var.bonus_variation', 'NUMBER'); -- 09/08/00 AFERRARA
255: FA_RX_UTIL_PKG.assign_column('61', NULL, 'netbo_variation','JG_RX_FAREG.var.netbo_variation', 'NUMBER'); -- 09/08/00 AFERRARA
256: FA_RX_UTIL_PKG.assign_column('62', NULL, 'revaluation_total','JG_RX_FAREG.var.revaluation_total', 'NUMBER'); -- 09/08/00 AFERRARA
257: --- Added for ECE Project
258: FA_RX_UTIL_PKG.assign_column('63', 'METH.method_code', 'depreciation_method','JG_RX_FAREG.var.depriciation_method', 'VARCHAR2', 12);
251: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JG_RX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA
252: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JG_RX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA
253: FA_RX_UTIL_PKG.assign_column('59', NULL, 'deprn_variation','JG_RX_FAREG.var.deprn_variation', 'NUMBER'); -- 09/08/00 AFERRARA
254: FA_RX_UTIL_PKG.assign_column('60', NULL, 'bonus_variation','JG_RX_FAREG.var.bonus_variation', 'NUMBER'); -- 09/08/00 AFERRARA
255: FA_RX_UTIL_PKG.assign_column('61', NULL, 'netbo_variation','JG_RX_FAREG.var.netbo_variation', 'NUMBER'); -- 09/08/00 AFERRARA
256: FA_RX_UTIL_PKG.assign_column('62', NULL, 'revaluation_total','JG_RX_FAREG.var.revaluation_total', 'NUMBER'); -- 09/08/00 AFERRARA
257: --- Added for ECE Project
258: FA_RX_UTIL_PKG.assign_column('63', 'METH.method_code', 'depreciation_method','JG_RX_FAREG.var.depriciation_method', 'VARCHAR2', 12);
259: FA_RX_UTIL_PKG.assign_column('64', 'BO.prorate_convention_code','prorate_convention','JG_RX_FAREG.var.prorate_convention', 'VARCHAR2',10);
252: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JG_RX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA
253: FA_RX_UTIL_PKG.assign_column('59', NULL, 'deprn_variation','JG_RX_FAREG.var.deprn_variation', 'NUMBER'); -- 09/08/00 AFERRARA
254: FA_RX_UTIL_PKG.assign_column('60', NULL, 'bonus_variation','JG_RX_FAREG.var.bonus_variation', 'NUMBER'); -- 09/08/00 AFERRARA
255: FA_RX_UTIL_PKG.assign_column('61', NULL, 'netbo_variation','JG_RX_FAREG.var.netbo_variation', 'NUMBER'); -- 09/08/00 AFERRARA
256: FA_RX_UTIL_PKG.assign_column('62', NULL, 'revaluation_total','JG_RX_FAREG.var.revaluation_total', 'NUMBER'); -- 09/08/00 AFERRARA
257: --- Added for ECE Project
258: FA_RX_UTIL_PKG.assign_column('63', 'METH.method_code', 'depreciation_method','JG_RX_FAREG.var.depriciation_method', 'VARCHAR2', 12);
259: FA_RX_UTIL_PKG.assign_column('64', 'BO.prorate_convention_code','prorate_convention','JG_RX_FAREG.var.prorate_convention', 'VARCHAR2',10);
260: FA_RX_UTIL_PKG.assign_column('65', 'AD.tag_number', 'tag_number','JG_RX_FAREG.var.tag_number', 'VARCHAR2',15);
254: FA_RX_UTIL_PKG.assign_column('60', NULL, 'bonus_variation','JG_RX_FAREG.var.bonus_variation', 'NUMBER'); -- 09/08/00 AFERRARA
255: FA_RX_UTIL_PKG.assign_column('61', NULL, 'netbo_variation','JG_RX_FAREG.var.netbo_variation', 'NUMBER'); -- 09/08/00 AFERRARA
256: FA_RX_UTIL_PKG.assign_column('62', NULL, 'revaluation_total','JG_RX_FAREG.var.revaluation_total', 'NUMBER'); -- 09/08/00 AFERRARA
257: --- Added for ECE Project
258: FA_RX_UTIL_PKG.assign_column('63', 'METH.method_code', 'depreciation_method','JG_RX_FAREG.var.depriciation_method', 'VARCHAR2', 12);
259: FA_RX_UTIL_PKG.assign_column('64', 'BO.prorate_convention_code','prorate_convention','JG_RX_FAREG.var.prorate_convention', 'VARCHAR2',10);
260: FA_RX_UTIL_PKG.assign_column('65', 'AD.tag_number', 'tag_number','JG_RX_FAREG.var.tag_number', 'VARCHAR2',15);
261: FA_RX_UTIL_PKG.assign_column('66', 'AD.serial_number', 'serial_number','JG_RX_FAREG.var.serial_number', 'VARCHAR2',35);
262: FA_RX_UTIL_PKG.assign_column('67', 'AD.asset_key_ccid', NULL,'JG_RX_FAREG.var.asset_key_ccid', 'NUMBER');
255: FA_RX_UTIL_PKG.assign_column('61', NULL, 'netbo_variation','JG_RX_FAREG.var.netbo_variation', 'NUMBER'); -- 09/08/00 AFERRARA
256: FA_RX_UTIL_PKG.assign_column('62', NULL, 'revaluation_total','JG_RX_FAREG.var.revaluation_total', 'NUMBER'); -- 09/08/00 AFERRARA
257: --- Added for ECE Project
258: FA_RX_UTIL_PKG.assign_column('63', 'METH.method_code', 'depreciation_method','JG_RX_FAREG.var.depriciation_method', 'VARCHAR2', 12);
259: FA_RX_UTIL_PKG.assign_column('64', 'BO.prorate_convention_code','prorate_convention','JG_RX_FAREG.var.prorate_convention', 'VARCHAR2',10);
260: FA_RX_UTIL_PKG.assign_column('65', 'AD.tag_number', 'tag_number','JG_RX_FAREG.var.tag_number', 'VARCHAR2',15);
261: FA_RX_UTIL_PKG.assign_column('66', 'AD.serial_number', 'serial_number','JG_RX_FAREG.var.serial_number', 'VARCHAR2',35);
262: FA_RX_UTIL_PKG.assign_column('67', 'AD.asset_key_ccid', NULL,'JG_RX_FAREG.var.asset_key_ccid', 'NUMBER');
263: FA_RX_UTIL_PKG.assign_column('68', NULL, 'asset_key_flexfield','JG_RX_FAREG.var.asset_key_flexfield', 'VARCHAR2',320); -- bug 4969343
256: FA_RX_UTIL_PKG.assign_column('62', NULL, 'revaluation_total','JG_RX_FAREG.var.revaluation_total', 'NUMBER'); -- 09/08/00 AFERRARA
257: --- Added for ECE Project
258: FA_RX_UTIL_PKG.assign_column('63', 'METH.method_code', 'depreciation_method','JG_RX_FAREG.var.depriciation_method', 'VARCHAR2', 12);
259: FA_RX_UTIL_PKG.assign_column('64', 'BO.prorate_convention_code','prorate_convention','JG_RX_FAREG.var.prorate_convention', 'VARCHAR2',10);
260: FA_RX_UTIL_PKG.assign_column('65', 'AD.tag_number', 'tag_number','JG_RX_FAREG.var.tag_number', 'VARCHAR2',15);
261: FA_RX_UTIL_PKG.assign_column('66', 'AD.serial_number', 'serial_number','JG_RX_FAREG.var.serial_number', 'VARCHAR2',35);
262: FA_RX_UTIL_PKG.assign_column('67', 'AD.asset_key_ccid', NULL,'JG_RX_FAREG.var.asset_key_ccid', 'NUMBER');
263: FA_RX_UTIL_PKG.assign_column('68', NULL, 'asset_key_flexfield','JG_RX_FAREG.var.asset_key_flexfield', 'VARCHAR2',320); -- bug 4969343
264: FA_RX_UTIL_PKG.assign_column('69', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_years','NUMBER');
257: --- Added for ECE Project
258: FA_RX_UTIL_PKG.assign_column('63', 'METH.method_code', 'depreciation_method','JG_RX_FAREG.var.depriciation_method', 'VARCHAR2', 12);
259: FA_RX_UTIL_PKG.assign_column('64', 'BO.prorate_convention_code','prorate_convention','JG_RX_FAREG.var.prorate_convention', 'VARCHAR2',10);
260: FA_RX_UTIL_PKG.assign_column('65', 'AD.tag_number', 'tag_number','JG_RX_FAREG.var.tag_number', 'VARCHAR2',15);
261: FA_RX_UTIL_PKG.assign_column('66', 'AD.serial_number', 'serial_number','JG_RX_FAREG.var.serial_number', 'VARCHAR2',35);
262: FA_RX_UTIL_PKG.assign_column('67', 'AD.asset_key_ccid', NULL,'JG_RX_FAREG.var.asset_key_ccid', 'NUMBER');
263: FA_RX_UTIL_PKG.assign_column('68', NULL, 'asset_key_flexfield','JG_RX_FAREG.var.asset_key_flexfield', 'VARCHAR2',320); -- bug 4969343
264: FA_RX_UTIL_PKG.assign_column('69', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_years','NUMBER');
265: ---
258: FA_RX_UTIL_PKG.assign_column('63', 'METH.method_code', 'depreciation_method','JG_RX_FAREG.var.depriciation_method', 'VARCHAR2', 12);
259: FA_RX_UTIL_PKG.assign_column('64', 'BO.prorate_convention_code','prorate_convention','JG_RX_FAREG.var.prorate_convention', 'VARCHAR2',10);
260: FA_RX_UTIL_PKG.assign_column('65', 'AD.tag_number', 'tag_number','JG_RX_FAREG.var.tag_number', 'VARCHAR2',15);
261: FA_RX_UTIL_PKG.assign_column('66', 'AD.serial_number', 'serial_number','JG_RX_FAREG.var.serial_number', 'VARCHAR2',35);
262: FA_RX_UTIL_PKG.assign_column('67', 'AD.asset_key_ccid', NULL,'JG_RX_FAREG.var.asset_key_ccid', 'NUMBER');
263: FA_RX_UTIL_PKG.assign_column('68', NULL, 'asset_key_flexfield','JG_RX_FAREG.var.asset_key_flexfield', 'VARCHAR2',320); -- bug 4969343
264: FA_RX_UTIL_PKG.assign_column('69', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_years','NUMBER');
265: ---
266: --Added the following column as part of the fix for bug 3240485
259: FA_RX_UTIL_PKG.assign_column('64', 'BO.prorate_convention_code','prorate_convention','JG_RX_FAREG.var.prorate_convention', 'VARCHAR2',10);
260: FA_RX_UTIL_PKG.assign_column('65', 'AD.tag_number', 'tag_number','JG_RX_FAREG.var.tag_number', 'VARCHAR2',15);
261: FA_RX_UTIL_PKG.assign_column('66', 'AD.serial_number', 'serial_number','JG_RX_FAREG.var.serial_number', 'VARCHAR2',35);
262: FA_RX_UTIL_PKG.assign_column('67', 'AD.asset_key_ccid', NULL,'JG_RX_FAREG.var.asset_key_ccid', 'NUMBER');
263: FA_RX_UTIL_PKG.assign_column('68', NULL, 'asset_key_flexfield','JG_RX_FAREG.var.asset_key_flexfield', 'VARCHAR2',320); -- bug 4969343
264: FA_RX_UTIL_PKG.assign_column('69', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_years','NUMBER');
265: ---
266: --Added the following column as part of the fix for bug 3240485
267: FA_RX_UTIL_PKG.assign_column('70', NULL, 'ytd_deprn','JG_RX_FAREG.var.ytd_deprn', 'NUMBER');
260: FA_RX_UTIL_PKG.assign_column('65', 'AD.tag_number', 'tag_number','JG_RX_FAREG.var.tag_number', 'VARCHAR2',15);
261: FA_RX_UTIL_PKG.assign_column('66', 'AD.serial_number', 'serial_number','JG_RX_FAREG.var.serial_number', 'VARCHAR2',35);
262: FA_RX_UTIL_PKG.assign_column('67', 'AD.asset_key_ccid', NULL,'JG_RX_FAREG.var.asset_key_ccid', 'NUMBER');
263: FA_RX_UTIL_PKG.assign_column('68', NULL, 'asset_key_flexfield','JG_RX_FAREG.var.asset_key_flexfield', 'VARCHAR2',320); -- bug 4969343
264: FA_RX_UTIL_PKG.assign_column('69', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_years','NUMBER');
265: ---
266: --Added the following column as part of the fix for bug 3240485
267: FA_RX_UTIL_PKG.assign_column('70', NULL, 'ytd_deprn','JG_RX_FAREG.var.ytd_deprn', 'NUMBER');
268: FA_RX_UTIL_PKG.assign_column('69', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_months','NUMBER');
263: FA_RX_UTIL_PKG.assign_column('68', NULL, 'asset_key_flexfield','JG_RX_FAREG.var.asset_key_flexfield', 'VARCHAR2',320); -- bug 4969343
264: FA_RX_UTIL_PKG.assign_column('69', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_years','NUMBER');
265: ---
266: --Added the following column as part of the fix for bug 3240485
267: FA_RX_UTIL_PKG.assign_column('70', NULL, 'ytd_deprn','JG_RX_FAREG.var.ytd_deprn', 'NUMBER');
268: FA_RX_UTIL_PKG.assign_column('69', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_months','NUMBER');
269: --Added the above part to fix bug 3240485
270:
271: /* FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JG_RX_FAREG.var.date_placed_in_service','DATE');
264: FA_RX_UTIL_PKG.assign_column('69', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_years','NUMBER');
265: ---
266: --Added the following column as part of the fix for bug 3240485
267: FA_RX_UTIL_PKG.assign_column('70', NULL, 'ytd_deprn','JG_RX_FAREG.var.ytd_deprn', 'NUMBER');
268: FA_RX_UTIL_PKG.assign_column('69', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_months','NUMBER');
269: --Added the above part to fix bug 3240485
270:
271: /* FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JG_RX_FAREG.var.date_placed_in_service','DATE');
272: FA_RX_UTIL_PKG.assign_column('63','BO.flag' , 'short_fiscal_year_flag','JG_RX_FAREG.short_fiscal_year_flag', 'VARCHAR2', 3); --07/11/03 APRABHUN
267: FA_RX_UTIL_PKG.assign_column('70', NULL, 'ytd_deprn','JG_RX_FAREG.var.ytd_deprn', 'NUMBER');
268: FA_RX_UTIL_PKG.assign_column('69', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_months','NUMBER');
269: --Added the above part to fix bug 3240485
270:
271: /* FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JG_RX_FAREG.var.date_placed_in_service','DATE');
272: FA_RX_UTIL_PKG.assign_column('63','BO.flag' , 'short_fiscal_year_flag','JG_RX_FAREG.short_fiscal_year_flag', 'VARCHAR2', 3); --07/11/03 APRABHUN
273: */
274: -->>SELECT_END<<--
275:
268: FA_RX_UTIL_PKG.assign_column('69', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_months','NUMBER');
269: --Added the above part to fix bug 3240485
270:
271: /* FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JG_RX_FAREG.var.date_placed_in_service','DATE');
272: FA_RX_UTIL_PKG.assign_column('63','BO.flag' , 'short_fiscal_year_flag','JG_RX_FAREG.short_fiscal_year_flag', 'VARCHAR2', 3); --07/11/03 APRABHUN
273: */
274: -->>SELECT_END<<--
275:
276:
276:
277: --
278: -- Assign From Clause
279: --
280: FA_RX_UTIL_PKG.From_Clause :=
281: 'fa_books BO,
282: fa_additions AD,
283: fa_categories CA,
284: fa_category_books CB,
288: --
289: -- Assign Where Clause
290: --
291:
292: FA_RX_UTIL_PKG.Where_clause:=
293: ' AD.asset_id = BO.asset_id' ||
294: ' AND AD.in_use_flag = ''YES''' ||
295: ' AND AD.asset_category_id = CA.category_id' ||
296: ' AND (BO.date_effective,transaction_header_id_in) = (SELECT MAX(date_effective),'||
317:
318:
319: -- It takes the segment condition
320: IF X_where_clause_tmp IS NOT NULL THEN
321: FA_RX_UTIL_PKG.Where_Clause := FA_RX_UTIL_PKG.Where_clause || X_where_clause_tmp;
322: END IF;
323:
324: IF PARM.p_book_type_code IS NOT NULL THEN
325: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause ||
321: FA_RX_UTIL_PKG.Where_Clause := FA_RX_UTIL_PKG.Where_clause || X_where_clause_tmp;
322: END IF;
323:
324: IF PARM.p_book_type_code IS NOT NULL THEN
325: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause ||
326: ' AND BO.book_type_code = :b_book_type_code ';
327: END IF;
328:
329: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_ASSET_before_report()-');
325: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause ||
326: ' AND BO.book_type_code = :b_book_type_code ';
327: END IF;
328:
329: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_ASSET_before_report()-');
330:
331: END fa_ASSET_before_report;
332:
333:
345: b_book_type_code VARCHAR2(15);
346: b_fiscal_year_start_date DATE;
347:
348: BEGIN
349: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_ASSET_bind()+');
350:
351: IF PARM.p_end_period_to_date IS NOT NULL THEN
352: FA_RX_UTIL_PKG.debug('Binding b_period_to_date');
353: DBMS_SQL.bind_variable(c, 'b_period_to_date', PARM.p_end_period_to_date);
348: BEGIN
349: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_ASSET_bind()+');
350:
351: IF PARM.p_end_period_to_date IS NOT NULL THEN
352: FA_RX_UTIL_PKG.debug('Binding b_period_to_date');
353: DBMS_SQL.bind_variable(c, 'b_period_to_date', PARM.p_end_period_to_date);
354: END IF;
355:
356: IF PARM.p_major_category IS NOT NULL THEN
353: DBMS_SQL.bind_variable(c, 'b_period_to_date', PARM.p_end_period_to_date);
354: END IF;
355:
356: IF PARM.p_major_category IS NOT NULL THEN
357: FA_RX_UTIL_PKG.debug('Binding major_category');
358: DBMS_SQL.bind_variable(c, 'b_major_category', PARM.p_major_category);
359: END IF;
360:
361: IF PARM.p_minor_category IS NOT NULL THEN
358: DBMS_SQL.bind_variable(c, 'b_major_category', PARM.p_major_category);
359: END IF;
360:
361: IF PARM.p_minor_category IS NOT NULL THEN
362: FA_RX_UTIL_PKG.debug('Binding b_minor_category');
363: DBMS_SQL.bind_variable(c, 'b_minor_category', PARM.p_minor_category);
364: END IF;
365:
366: IF PARM.p_book_type_code IS NOT NULL THEN
363: DBMS_SQL.bind_variable(c, 'b_minor_category', PARM.p_minor_category);
364: END IF;
365:
366: IF PARM.p_book_type_code IS NOT NULL THEN
367: FA_RX_UTIL_PKG.debug('Binding b_book_type_code '|| PARM.p_book_type_code);
368: DBMS_SQL.bind_variable(c, 'b_book_type_code', PARM.p_book_type_code);
369: END IF;
370:
371: IF PARM.p_fiscal_year_start_date IS NOT NULL THEN
368: DBMS_SQL.bind_variable(c, 'b_book_type_code', PARM.p_book_type_code);
369: END IF;
370:
371: IF PARM.p_fiscal_year_start_date IS NOT NULL THEN
372: FA_RX_UTIL_PKG.debug('Binding b_fiscal_year_start_date'|| to_char( PARM.p_fiscal_year_start_date ,'DD/MM/YY'));
373: DBMS_SQL.bind_variable(c, 'b_fiscal_year_start_date', PARM.p_fiscal_year_start_date);
374: END IF;
375:
376:
373: DBMS_SQL.bind_variable(c, 'b_fiscal_year_start_date', PARM.p_fiscal_year_start_date);
374: END IF;
375:
376:
377: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_ASSET_bind()-');
378:
379: END fa_ASSET_bind;
380:
381:
385: -- The after fetch trigger fires after the Select statement has executed
386: PROCEDURE fa_ASSET_after_fetch IS
387: X_msg VARCHAR2(100);
388: BEGIN
389: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_ASSET_after_fetch()+');
390:
391: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_id =' || TO_CHAR(JG_RX_FAREG.var.asset_id));
392:
393: -- Added for ECE Project
387: X_msg VARCHAR2(100);
388: BEGIN
389: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_ASSET_after_fetch()+');
390:
391: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_id =' || TO_CHAR(JG_RX_FAREG.var.asset_id));
392:
393: -- Added for ECE Project
394: -- This code is added to get the Asset Flexfield
395: -- concatenated segment value
404: EXCEPTION
405: WHEN NO_DATA_FOUND THEN
406: X_msg := 'JG_RX_FAREG.fa_ASSET_after_fetch: NO_DATA_FOUND';
407: x_msg := x_msg || ' - Error in getting number_per_fiscal_year';
408: FA_RX_UTIL_PKG.debug(X_msg);
409: RAISE_APPLICATION_ERROR(-20010,X_msg);
410:
411: WHEN TOO_MANY_ROWS THEN
412: X_msg := 'JG_RX_FAREG.fa_ASSET_after_fetch: TOO_MANY_ROWS';
410:
411: WHEN TOO_MANY_ROWS THEN
412: X_msg := 'JG_RX_FAREG.fa_ASSET_after_fetch: TOO_MANY_ROWS';
413: x_msg := x_msg || ' - Error in getting number_per_fiscal_year';
414: FA_RX_UTIL_PKG.debug(X_msg);
415: RAISE_APPLICATION_ERROR(-20010,X_msg);
416: END;
417:
418: BEGIN
427: EXCEPTION
428: WHEN NO_DATA_FOUND THEN
429: X_msg := 'JG_RX_FAREG.fa_ASSET_after_fetch: NO_DATA_FOUND';
430: x_msg := x_msg || ' - Error in getting Asset Flexfield Value ';
431: FA_RX_UTIL_PKG.debug(X_msg);
432: RAISE_APPLICATION_ERROR(-20010,X_msg);
433:
434: WHEN TOO_MANY_ROWS THEN
435: X_msg := 'JG_RX_FAREG.fa_ASSET_after_fetch: TOO_MANY_ROWS';
433:
434: WHEN TOO_MANY_ROWS THEN
435: X_msg := 'JG_RX_FAREG.fa_ASSET_after_fetch: TOO_MANY_ROWS';
436: x_msg := x_msg || ' - Error in getting Asset Flexfield Value ';
437: FA_RX_UTIL_PKG.debug(X_msg);
438: RAISE_APPLICATION_ERROR(-20010,X_msg);
439:
440:
441: END;
448: JG_RX_FAREG.var.parent_asset_number := Get_parent_asset_number;
449: END IF;
450: JG_RX_FAREG.var.asset_heading := 'ASSET NUMBER ';
451: JG_RX_FAREG.var.starting_deprn_year := to_char(JG_RX_FAREG.var.date_placed_in_service,'YYYY');
452: FA_RX_UTIL_PKG.debug('date_placed_in_service'||to_char(JG_RX_FAREG.var.date_placed_in_service));
453: FA_RX_UTIL_PKG.debug('Starting deprn Year' || JG_RX_FAREG.var.starting_deprn_year);
454: -- It takes the cost values
455:
456:
449: END IF;
450: JG_RX_FAREG.var.asset_heading := 'ASSET NUMBER ';
451: JG_RX_FAREG.var.starting_deprn_year := to_char(JG_RX_FAREG.var.date_placed_in_service,'YYYY');
452: FA_RX_UTIL_PKG.debug('date_placed_in_service'||to_char(JG_RX_FAREG.var.date_placed_in_service));
453: FA_RX_UTIL_PKG.debug('Starting deprn Year' || JG_RX_FAREG.var.starting_deprn_year);
454: -- It takes the cost values
455:
456:
457: FA_RX_UTIL_PKG.debug('PARM.p_period_from'||PARM.p_period_from);
453: FA_RX_UTIL_PKG.debug('Starting deprn Year' || JG_RX_FAREG.var.starting_deprn_year);
454: -- It takes the cost values
455:
456:
457: FA_RX_UTIL_PKG.debug('PARM.p_period_from'||PARM.p_period_from);
458: FA_RX_UTIL_PKG.debug('PARM.p_period_to'||PARM.p_period_to);
459:
460: JG_RX_FAREG.var.expense_account := null;
461: if X_Account_segment <> 'NONE'then
454: -- It takes the cost values
455:
456:
457: FA_RX_UTIL_PKG.debug('PARM.p_period_from'||PARM.p_period_from);
458: FA_RX_UTIL_PKG.debug('PARM.p_period_to'||PARM.p_period_to);
459:
460: JG_RX_FAREG.var.expense_account := null;
461: if X_Account_segment <> 'NONE'then
462: Get_Deprn_Accounts;
496: JG_RX_FAREG.var.transaction_code := NULL;
497: JG_RX_FAREG.var.transaction_amount := NULL;
498: Get_Transactions;
499:
500: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_ASSET_after_fetch()-');
501: END fa_ASSET_after_fetch;
502:
503:
504: /*===================================================================+
505: | fa_ASSET_after_report |
506: +====================================================================*/
507: PROCEDURE fa_ASSET_after_report IS
508: BEGIN
509: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_ASSET_after_report()+');
510:
511: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_ASSET_after_report()-');
512: END fa_ASSET_after_report;
513:
507: PROCEDURE fa_ASSET_after_report IS
508: BEGIN
509: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_ASSET_after_report()+');
510:
511: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_ASSET_after_report()-');
512: END fa_ASSET_after_report;
513:
514:
515: /*****************************************************************************************************
529: IS
530:
531:
532: BEGIN
533: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_RTRMNT_before_report()+');
534:
535:
536: -- It takes the segment condition, Company name, currency code and store in placeholder variable
537: Startup;
538:
539: --Assign SELECT list
540: -- the Select statement is build over here
541:
542: -- FA_RX_UTIL_PKG.assign_column(#, select, insert, place, type, len);
543:
544:
545: -->>SELECT_START<<--
546:
543:
544:
545: -->>SELECT_START<<--
546:
547: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JG_RX_FAREG.var.organization_name','VARCHAR2',60);
548: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JG_RX_FAREG.var.functional_currency_code', 'VARCHAR2',15);
549:
550: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JG_RX_FAREG.var.major_category','VARCHAR2', 30);
551: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JG_RX_FAREG.var.minor_category','VARCHAR2', 30);
544:
545: -->>SELECT_START<<--
546:
547: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JG_RX_FAREG.var.organization_name','VARCHAR2',60);
548: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JG_RX_FAREG.var.functional_currency_code', 'VARCHAR2',15);
549:
550: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JG_RX_FAREG.var.major_category','VARCHAR2', 30);
551: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JG_RX_FAREG.var.minor_category','VARCHAR2', 30);
552:
546:
547: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JG_RX_FAREG.var.organization_name','VARCHAR2',60);
548: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JG_RX_FAREG.var.functional_currency_code', 'VARCHAR2',15);
549:
550: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JG_RX_FAREG.var.major_category','VARCHAR2', 30);
551: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JG_RX_FAREG.var.minor_category','VARCHAR2', 30);
552:
553: FA_RX_UTIL_PKG.assign_column('5', 'AD.asset_number', 'asset_number','JG_RX_FAREG.var.asset_number','VARCHAR2', 15);
554: FA_RX_UTIL_PKG.assign_column('6', 'AD.description', 'description','JG_RX_FAREG.var.description','VARCHAR2', 80);
547: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JG_RX_FAREG.var.organization_name','VARCHAR2',60);
548: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JG_RX_FAREG.var.functional_currency_code', 'VARCHAR2',15);
549:
550: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JG_RX_FAREG.var.major_category','VARCHAR2', 30);
551: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JG_RX_FAREG.var.minor_category','VARCHAR2', 30);
552:
553: FA_RX_UTIL_PKG.assign_column('5', 'AD.asset_number', 'asset_number','JG_RX_FAREG.var.asset_number','VARCHAR2', 15);
554: FA_RX_UTIL_PKG.assign_column('6', 'AD.description', 'description','JG_RX_FAREG.var.description','VARCHAR2', 80);
555:
549:
550: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JG_RX_FAREG.var.major_category','VARCHAR2', 30);
551: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JG_RX_FAREG.var.minor_category','VARCHAR2', 30);
552:
553: FA_RX_UTIL_PKG.assign_column('5', 'AD.asset_number', 'asset_number','JG_RX_FAREG.var.asset_number','VARCHAR2', 15);
554: FA_RX_UTIL_PKG.assign_column('6', 'AD.description', 'description','JG_RX_FAREG.var.description','VARCHAR2', 80);
555:
556: FA_RX_UTIL_PKG.assign_column('7', 'AD.parent_asset_id', NULL,'JG_RX_FAREG.var.parent_asset_id','NUMBER');
557: FA_RX_UTIL_PKG.assign_column('8', NULL, 'parent_asset_number','JG_RX_FAREG.var.parent_asset_number','VARCHAR2', 15);
550: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JG_RX_FAREG.var.major_category','VARCHAR2', 30);
551: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JG_RX_FAREG.var.minor_category','VARCHAR2', 30);
552:
553: FA_RX_UTIL_PKG.assign_column('5', 'AD.asset_number', 'asset_number','JG_RX_FAREG.var.asset_number','VARCHAR2', 15);
554: FA_RX_UTIL_PKG.assign_column('6', 'AD.description', 'description','JG_RX_FAREG.var.description','VARCHAR2', 80);
555:
556: FA_RX_UTIL_PKG.assign_column('7', 'AD.parent_asset_id', NULL,'JG_RX_FAREG.var.parent_asset_id','NUMBER');
557: FA_RX_UTIL_PKG.assign_column('8', NULL, 'parent_asset_number','JG_RX_FAREG.var.parent_asset_number','VARCHAR2', 15);
558:
552:
553: FA_RX_UTIL_PKG.assign_column('5', 'AD.asset_number', 'asset_number','JG_RX_FAREG.var.asset_number','VARCHAR2', 15);
554: FA_RX_UTIL_PKG.assign_column('6', 'AD.description', 'description','JG_RX_FAREG.var.description','VARCHAR2', 80);
555:
556: FA_RX_UTIL_PKG.assign_column('7', 'AD.parent_asset_id', NULL,'JG_RX_FAREG.var.parent_asset_id','NUMBER');
557: FA_RX_UTIL_PKG.assign_column('8', NULL, 'parent_asset_number','JG_RX_FAREG.var.parent_asset_number','VARCHAR2', 15);
558:
559: FA_RX_UTIL_PKG.assign_column('9', 'BO.original_cost', 'asset_cost_orig','JG_RX_FAREG.var.asset_cost_orig','NUMBER');
560: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JG_RX_FAREG.var.sales_amount','NUMBER');
553: FA_RX_UTIL_PKG.assign_column('5', 'AD.asset_number', 'asset_number','JG_RX_FAREG.var.asset_number','VARCHAR2', 15);
554: FA_RX_UTIL_PKG.assign_column('6', 'AD.description', 'description','JG_RX_FAREG.var.description','VARCHAR2', 80);
555:
556: FA_RX_UTIL_PKG.assign_column('7', 'AD.parent_asset_id', NULL,'JG_RX_FAREG.var.parent_asset_id','NUMBER');
557: FA_RX_UTIL_PKG.assign_column('8', NULL, 'parent_asset_number','JG_RX_FAREG.var.parent_asset_number','VARCHAR2', 15);
558:
559: FA_RX_UTIL_PKG.assign_column('9', 'BO.original_cost', 'asset_cost_orig','JG_RX_FAREG.var.asset_cost_orig','NUMBER');
560: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JG_RX_FAREG.var.sales_amount','NUMBER');
561: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JG_RX_FAREG.var.cost_retired','NUMBER');
555:
556: FA_RX_UTIL_PKG.assign_column('7', 'AD.parent_asset_id', NULL,'JG_RX_FAREG.var.parent_asset_id','NUMBER');
557: FA_RX_UTIL_PKG.assign_column('8', NULL, 'parent_asset_number','JG_RX_FAREG.var.parent_asset_number','VARCHAR2', 15);
558:
559: FA_RX_UTIL_PKG.assign_column('9', 'BO.original_cost', 'asset_cost_orig','JG_RX_FAREG.var.asset_cost_orig','NUMBER');
560: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JG_RX_FAREG.var.sales_amount','NUMBER');
561: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JG_RX_FAREG.var.cost_retired','NUMBER');
562: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JG_RX_FAREG.var.deprn_reserve','NUMBER');
563: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JG_RX_FAREG.var.bonus_reserve','NUMBER');
556: FA_RX_UTIL_PKG.assign_column('7', 'AD.parent_asset_id', NULL,'JG_RX_FAREG.var.parent_asset_id','NUMBER');
557: FA_RX_UTIL_PKG.assign_column('8', NULL, 'parent_asset_number','JG_RX_FAREG.var.parent_asset_number','VARCHAR2', 15);
558:
559: FA_RX_UTIL_PKG.assign_column('9', 'BO.original_cost', 'asset_cost_orig','JG_RX_FAREG.var.asset_cost_orig','NUMBER');
560: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JG_RX_FAREG.var.sales_amount','NUMBER');
561: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JG_RX_FAREG.var.cost_retired','NUMBER');
562: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JG_RX_FAREG.var.deprn_reserve','NUMBER');
563: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JG_RX_FAREG.var.bonus_reserve','NUMBER');
564: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JG_RX_FAREG.var.net_book_value','NUMBER');
557: FA_RX_UTIL_PKG.assign_column('8', NULL, 'parent_asset_number','JG_RX_FAREG.var.parent_asset_number','VARCHAR2', 15);
558:
559: FA_RX_UTIL_PKG.assign_column('9', 'BO.original_cost', 'asset_cost_orig','JG_RX_FAREG.var.asset_cost_orig','NUMBER');
560: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JG_RX_FAREG.var.sales_amount','NUMBER');
561: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JG_RX_FAREG.var.cost_retired','NUMBER');
562: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JG_RX_FAREG.var.deprn_reserve','NUMBER');
563: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JG_RX_FAREG.var.bonus_reserve','NUMBER');
564: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JG_RX_FAREG.var.net_book_value','NUMBER');
565: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JG_RX_FAREG.var.gain_loss','NUMBER');
558:
559: FA_RX_UTIL_PKG.assign_column('9', 'BO.original_cost', 'asset_cost_orig','JG_RX_FAREG.var.asset_cost_orig','NUMBER');
560: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JG_RX_FAREG.var.sales_amount','NUMBER');
561: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JG_RX_FAREG.var.cost_retired','NUMBER');
562: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JG_RX_FAREG.var.deprn_reserve','NUMBER');
563: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JG_RX_FAREG.var.bonus_reserve','NUMBER');
564: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JG_RX_FAREG.var.net_book_value','NUMBER');
565: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JG_RX_FAREG.var.gain_loss','NUMBER');
566: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JG_RX_FAREG.var.invoice_number','VARCHAR2', 50);
559: FA_RX_UTIL_PKG.assign_column('9', 'BO.original_cost', 'asset_cost_orig','JG_RX_FAREG.var.asset_cost_orig','NUMBER');
560: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JG_RX_FAREG.var.sales_amount','NUMBER');
561: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JG_RX_FAREG.var.cost_retired','NUMBER');
562: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JG_RX_FAREG.var.deprn_reserve','NUMBER');
563: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JG_RX_FAREG.var.bonus_reserve','NUMBER');
564: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JG_RX_FAREG.var.net_book_value','NUMBER');
565: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JG_RX_FAREG.var.gain_loss','NUMBER');
566: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JG_RX_FAREG.var.invoice_number','VARCHAR2', 50);
567: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JG_RX_FAREG.var.asset_id','NUMBER');
560: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JG_RX_FAREG.var.sales_amount','NUMBER');
561: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JG_RX_FAREG.var.cost_retired','NUMBER');
562: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JG_RX_FAREG.var.deprn_reserve','NUMBER');
563: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JG_RX_FAREG.var.bonus_reserve','NUMBER');
564: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JG_RX_FAREG.var.net_book_value','NUMBER');
565: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JG_RX_FAREG.var.gain_loss','NUMBER');
566: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JG_RX_FAREG.var.invoice_number','VARCHAR2', 50);
567: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JG_RX_FAREG.var.asset_id','NUMBER');
568: FA_RX_UTIL_PKG.assign_column('18', 'RE.date_retired', 'date_retired','JG_RX_FAREG.var.date_retired','DATE');
561: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JG_RX_FAREG.var.cost_retired','NUMBER');
562: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JG_RX_FAREG.var.deprn_reserve','NUMBER');
563: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JG_RX_FAREG.var.bonus_reserve','NUMBER');
564: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JG_RX_FAREG.var.net_book_value','NUMBER');
565: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JG_RX_FAREG.var.gain_loss','NUMBER');
566: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JG_RX_FAREG.var.invoice_number','VARCHAR2', 50);
567: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JG_RX_FAREG.var.asset_id','NUMBER');
568: FA_RX_UTIL_PKG.assign_column('18', 'RE.date_retired', 'date_retired','JG_RX_FAREG.var.date_retired','DATE');
569: FA_RX_UTIL_PKG.assign_column('19', 'RE.transaction_header_id_in', NULL,'JG_RX_FAREG.var.transaction_header_id','NUMBER');
562: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JG_RX_FAREG.var.deprn_reserve','NUMBER');
563: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JG_RX_FAREG.var.bonus_reserve','NUMBER');
564: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JG_RX_FAREG.var.net_book_value','NUMBER');
565: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JG_RX_FAREG.var.gain_loss','NUMBER');
566: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JG_RX_FAREG.var.invoice_number','VARCHAR2', 50);
567: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JG_RX_FAREG.var.asset_id','NUMBER');
568: FA_RX_UTIL_PKG.assign_column('18', 'RE.date_retired', 'date_retired','JG_RX_FAREG.var.date_retired','DATE');
569: FA_RX_UTIL_PKG.assign_column('19', 'RE.transaction_header_id_in', NULL,'JG_RX_FAREG.var.transaction_header_id','NUMBER');
570: FA_RX_UTIL_PKG.assign_column('20', NULL,'asset_heading','JG_RX_FAREG.var.asset_heading','VARCHAR2', 15);
563: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JG_RX_FAREG.var.bonus_reserve','NUMBER');
564: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JG_RX_FAREG.var.net_book_value','NUMBER');
565: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JG_RX_FAREG.var.gain_loss','NUMBER');
566: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JG_RX_FAREG.var.invoice_number','VARCHAR2', 50);
567: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JG_RX_FAREG.var.asset_id','NUMBER');
568: FA_RX_UTIL_PKG.assign_column('18', 'RE.date_retired', 'date_retired','JG_RX_FAREG.var.date_retired','DATE');
569: FA_RX_UTIL_PKG.assign_column('19', 'RE.transaction_header_id_in', NULL,'JG_RX_FAREG.var.transaction_header_id','NUMBER');
570: FA_RX_UTIL_PKG.assign_column('20', NULL,'asset_heading','JG_RX_FAREG.var.asset_heading','VARCHAR2', 15);
571:
564: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JG_RX_FAREG.var.net_book_value','NUMBER');
565: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JG_RX_FAREG.var.gain_loss','NUMBER');
566: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JG_RX_FAREG.var.invoice_number','VARCHAR2', 50);
567: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JG_RX_FAREG.var.asset_id','NUMBER');
568: FA_RX_UTIL_PKG.assign_column('18', 'RE.date_retired', 'date_retired','JG_RX_FAREG.var.date_retired','DATE');
569: FA_RX_UTIL_PKG.assign_column('19', 'RE.transaction_header_id_in', NULL,'JG_RX_FAREG.var.transaction_header_id','NUMBER');
570: FA_RX_UTIL_PKG.assign_column('20', NULL,'asset_heading','JG_RX_FAREG.var.asset_heading','VARCHAR2', 15);
571:
572: --- Added for ECE Project
565: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JG_RX_FAREG.var.gain_loss','NUMBER');
566: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JG_RX_FAREG.var.invoice_number','VARCHAR2', 50);
567: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JG_RX_FAREG.var.asset_id','NUMBER');
568: FA_RX_UTIL_PKG.assign_column('18', 'RE.date_retired', 'date_retired','JG_RX_FAREG.var.date_retired','DATE');
569: FA_RX_UTIL_PKG.assign_column('19', 'RE.transaction_header_id_in', NULL,'JG_RX_FAREG.var.transaction_header_id','NUMBER');
570: FA_RX_UTIL_PKG.assign_column('20', NULL,'asset_heading','JG_RX_FAREG.var.asset_heading','VARCHAR2', 15);
571:
572: --- Added for ECE Project
573: FA_RX_UTIL_PKG.assign_column('21', 'BO.prorate_convention_code','prorate_convention','JG_RX_FAREG.var.prorate_convention', 'VARCHAR2',10);
566: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JG_RX_FAREG.var.invoice_number','VARCHAR2', 50);
567: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JG_RX_FAREG.var.asset_id','NUMBER');
568: FA_RX_UTIL_PKG.assign_column('18', 'RE.date_retired', 'date_retired','JG_RX_FAREG.var.date_retired','DATE');
569: FA_RX_UTIL_PKG.assign_column('19', 'RE.transaction_header_id_in', NULL,'JG_RX_FAREG.var.transaction_header_id','NUMBER');
570: FA_RX_UTIL_PKG.assign_column('20', NULL,'asset_heading','JG_RX_FAREG.var.asset_heading','VARCHAR2', 15);
571:
572: --- Added for ECE Project
573: FA_RX_UTIL_PKG.assign_column('21', 'BO.prorate_convention_code','prorate_convention','JG_RX_FAREG.var.prorate_convention', 'VARCHAR2',10);
574: FA_RX_UTIL_PKG.assign_column('22', 'AD.tag_number', 'tag_number','JG_RX_FAREG.var.tag_number', 'VARCHAR2',15);
569: FA_RX_UTIL_PKG.assign_column('19', 'RE.transaction_header_id_in', NULL,'JG_RX_FAREG.var.transaction_header_id','NUMBER');
570: FA_RX_UTIL_PKG.assign_column('20', NULL,'asset_heading','JG_RX_FAREG.var.asset_heading','VARCHAR2', 15);
571:
572: --- Added for ECE Project
573: FA_RX_UTIL_PKG.assign_column('21', 'BO.prorate_convention_code','prorate_convention','JG_RX_FAREG.var.prorate_convention', 'VARCHAR2',10);
574: FA_RX_UTIL_PKG.assign_column('22', 'AD.tag_number', 'tag_number','JG_RX_FAREG.var.tag_number', 'VARCHAR2',15);
575: FA_RX_UTIL_PKG.assign_column('23', 'AD.serial_number', 'serial_number','JG_RX_FAREG.var.serial_number', 'VARCHAR2',35);
576: FA_RX_UTIL_PKG.assign_column('24', 'AD.asset_key_ccid', NULL,'JG_RX_FAREG.var.asset_key_ccid', 'NUMBER');
577: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_key_flexfield','JG_RX_FAREG.var.asset_key_flexfield', 'VARCHAR2',320); -- Bug 4969343
570: FA_RX_UTIL_PKG.assign_column('20', NULL,'asset_heading','JG_RX_FAREG.var.asset_heading','VARCHAR2', 15);
571:
572: --- Added for ECE Project
573: FA_RX_UTIL_PKG.assign_column('21', 'BO.prorate_convention_code','prorate_convention','JG_RX_FAREG.var.prorate_convention', 'VARCHAR2',10);
574: FA_RX_UTIL_PKG.assign_column('22', 'AD.tag_number', 'tag_number','JG_RX_FAREG.var.tag_number', 'VARCHAR2',15);
575: FA_RX_UTIL_PKG.assign_column('23', 'AD.serial_number', 'serial_number','JG_RX_FAREG.var.serial_number', 'VARCHAR2',35);
576: FA_RX_UTIL_PKG.assign_column('24', 'AD.asset_key_ccid', NULL,'JG_RX_FAREG.var.asset_key_ccid', 'NUMBER');
577: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_key_flexfield','JG_RX_FAREG.var.asset_key_flexfield', 'VARCHAR2',320); -- Bug 4969343
578: FA_RX_UTIL_PKG.assign_column('26', 'BO.life_in_months', 'life_in_months','JG_RX_FAREG.var.life_in_months','NUMBER');
571:
572: --- Added for ECE Project
573: FA_RX_UTIL_PKG.assign_column('21', 'BO.prorate_convention_code','prorate_convention','JG_RX_FAREG.var.prorate_convention', 'VARCHAR2',10);
574: FA_RX_UTIL_PKG.assign_column('22', 'AD.tag_number', 'tag_number','JG_RX_FAREG.var.tag_number', 'VARCHAR2',15);
575: FA_RX_UTIL_PKG.assign_column('23', 'AD.serial_number', 'serial_number','JG_RX_FAREG.var.serial_number', 'VARCHAR2',35);
576: FA_RX_UTIL_PKG.assign_column('24', 'AD.asset_key_ccid', NULL,'JG_RX_FAREG.var.asset_key_ccid', 'NUMBER');
577: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_key_flexfield','JG_RX_FAREG.var.asset_key_flexfield', 'VARCHAR2',320); -- Bug 4969343
578: FA_RX_UTIL_PKG.assign_column('26', 'BO.life_in_months', 'life_in_months','JG_RX_FAREG.var.life_in_months','NUMBER');
579: FA_RX_UTIL_PKG.assign_column('27', 'METH.method_code', 'depreciation_method','JG_RX_FAREG.var.depriciation_method', 'VARCHAR2', 12);
572: --- Added for ECE Project
573: FA_RX_UTIL_PKG.assign_column('21', 'BO.prorate_convention_code','prorate_convention','JG_RX_FAREG.var.prorate_convention', 'VARCHAR2',10);
574: FA_RX_UTIL_PKG.assign_column('22', 'AD.tag_number', 'tag_number','JG_RX_FAREG.var.tag_number', 'VARCHAR2',15);
575: FA_RX_UTIL_PKG.assign_column('23', 'AD.serial_number', 'serial_number','JG_RX_FAREG.var.serial_number', 'VARCHAR2',35);
576: FA_RX_UTIL_PKG.assign_column('24', 'AD.asset_key_ccid', NULL,'JG_RX_FAREG.var.asset_key_ccid', 'NUMBER');
577: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_key_flexfield','JG_RX_FAREG.var.asset_key_flexfield', 'VARCHAR2',320); -- Bug 4969343
578: FA_RX_UTIL_PKG.assign_column('26', 'BO.life_in_months', 'life_in_months','JG_RX_FAREG.var.life_in_months','NUMBER');
579: FA_RX_UTIL_PKG.assign_column('27', 'METH.method_code', 'depreciation_method','JG_RX_FAREG.var.depriciation_method', 'VARCHAR2', 12);
580: FA_RX_UTIL_PKG.assign_column('28', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_years','NUMBER');
573: FA_RX_UTIL_PKG.assign_column('21', 'BO.prorate_convention_code','prorate_convention','JG_RX_FAREG.var.prorate_convention', 'VARCHAR2',10);
574: FA_RX_UTIL_PKG.assign_column('22', 'AD.tag_number', 'tag_number','JG_RX_FAREG.var.tag_number', 'VARCHAR2',15);
575: FA_RX_UTIL_PKG.assign_column('23', 'AD.serial_number', 'serial_number','JG_RX_FAREG.var.serial_number', 'VARCHAR2',35);
576: FA_RX_UTIL_PKG.assign_column('24', 'AD.asset_key_ccid', NULL,'JG_RX_FAREG.var.asset_key_ccid', 'NUMBER');
577: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_key_flexfield','JG_RX_FAREG.var.asset_key_flexfield', 'VARCHAR2',320); -- Bug 4969343
578: FA_RX_UTIL_PKG.assign_column('26', 'BO.life_in_months', 'life_in_months','JG_RX_FAREG.var.life_in_months','NUMBER');
579: FA_RX_UTIL_PKG.assign_column('27', 'METH.method_code', 'depreciation_method','JG_RX_FAREG.var.depriciation_method', 'VARCHAR2', 12);
580: FA_RX_UTIL_PKG.assign_column('28', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_years','NUMBER');
581: ---
574: FA_RX_UTIL_PKG.assign_column('22', 'AD.tag_number', 'tag_number','JG_RX_FAREG.var.tag_number', 'VARCHAR2',15);
575: FA_RX_UTIL_PKG.assign_column('23', 'AD.serial_number', 'serial_number','JG_RX_FAREG.var.serial_number', 'VARCHAR2',35);
576: FA_RX_UTIL_PKG.assign_column('24', 'AD.asset_key_ccid', NULL,'JG_RX_FAREG.var.asset_key_ccid', 'NUMBER');
577: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_key_flexfield','JG_RX_FAREG.var.asset_key_flexfield', 'VARCHAR2',320); -- Bug 4969343
578: FA_RX_UTIL_PKG.assign_column('26', 'BO.life_in_months', 'life_in_months','JG_RX_FAREG.var.life_in_months','NUMBER');
579: FA_RX_UTIL_PKG.assign_column('27', 'METH.method_code', 'depreciation_method','JG_RX_FAREG.var.depriciation_method', 'VARCHAR2', 12);
580: FA_RX_UTIL_PKG.assign_column('28', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_years','NUMBER');
581: ---
582: -->>SELECT_END<<--
575: FA_RX_UTIL_PKG.assign_column('23', 'AD.serial_number', 'serial_number','JG_RX_FAREG.var.serial_number', 'VARCHAR2',35);
576: FA_RX_UTIL_PKG.assign_column('24', 'AD.asset_key_ccid', NULL,'JG_RX_FAREG.var.asset_key_ccid', 'NUMBER');
577: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_key_flexfield','JG_RX_FAREG.var.asset_key_flexfield', 'VARCHAR2',320); -- Bug 4969343
578: FA_RX_UTIL_PKG.assign_column('26', 'BO.life_in_months', 'life_in_months','JG_RX_FAREG.var.life_in_months','NUMBER');
579: FA_RX_UTIL_PKG.assign_column('27', 'METH.method_code', 'depreciation_method','JG_RX_FAREG.var.depriciation_method', 'VARCHAR2', 12);
580: FA_RX_UTIL_PKG.assign_column('28', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_years','NUMBER');
581: ---
582: -->>SELECT_END<<--
583:
576: FA_RX_UTIL_PKG.assign_column('24', 'AD.asset_key_ccid', NULL,'JG_RX_FAREG.var.asset_key_ccid', 'NUMBER');
577: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_key_flexfield','JG_RX_FAREG.var.asset_key_flexfield', 'VARCHAR2',320); -- Bug 4969343
578: FA_RX_UTIL_PKG.assign_column('26', 'BO.life_in_months', 'life_in_months','JG_RX_FAREG.var.life_in_months','NUMBER');
579: FA_RX_UTIL_PKG.assign_column('27', 'METH.method_code', 'depreciation_method','JG_RX_FAREG.var.depriciation_method', 'VARCHAR2', 12);
580: FA_RX_UTIL_PKG.assign_column('28', NULL, 'life_in_years','JG_RX_FAREG.var.life_in_years','NUMBER');
581: ---
582: -->>SELECT_END<<--
583:
584:
584:
585: --
586: -- Assign From Clause
587: --
588: FA_RX_UTIL_PKG.From_Clause :=
589: 'fa_retirements re,
590: fa_additions ad,
591: fa_categories ca,
592: fa_books bo,
597: -- Assign Where Clause
598: --
599: -- ECE Project Added a where condition to add table fa_methods METH
600:
601: FA_RX_UTIL_PKG.Where_clause:=
602: ' AD.asset_id = RE.ASSET_ID' ||
603: ' AND RE.STATUS = ''PROCESSED'''||
604: ' AND AD.asset_category_id = CA.category_id' ||
605: ' AND BO.deprn_method_code = METH.method_code' ||
619: ' AND asset_id = BO.asset_id)';
620:
621: -- It takes the segment condition
622: IF X_where_clause_tmp IS NOT NULL THEN
623: FA_RX_UTIL_PKG.Where_Clause := FA_RX_UTIL_PKG.Where_clause || X_where_clause_tmp;
624: END IF;
625:
626: IF PARM.p_book_type_code IS NOT NULL THEN
627: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause ||
623: FA_RX_UTIL_PKG.Where_Clause := FA_RX_UTIL_PKG.Where_clause || X_where_clause_tmp;
624: END IF;
625:
626: IF PARM.p_book_type_code IS NOT NULL THEN
627: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause ||
628: ' AND BO.book_type_code = :b_book_type_code ';
629: END IF;
630: -- Both parameters are not null...anyway
631: IF PARM.p_begin_period_from_date IS NOT NULL AND PARM.p_end_period_to_date IS NOT NULL THEN
628: ' AND BO.book_type_code = :b_book_type_code ';
629: END IF;
630: -- Both parameters are not null...anyway
631: IF PARM.p_begin_period_from_date IS NOT NULL AND PARM.p_end_period_to_date IS NOT NULL THEN
632: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause || ' AND RE.date_retired ' ||
633: 'BETWEEN :b_period_from_date AND :b_period_to_date ';
634: END IF;
635:
636: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_RTRMNT_before_report()-');
632: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause || ' AND RE.date_retired ' ||
633: 'BETWEEN :b_period_from_date AND :b_period_to_date ';
634: END IF;
635:
636: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_RTRMNT_before_report()-');
637:
638: END fa_RTRMNT_before_report;
639:
640:
651: b_period_to_date VARCHAR2(20);
652: b_book_type_code VARCHAR2(15);
653:
654: BEGIN
655: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_RTRMNT_bind()+');
656:
657: IF PARM.p_begin_period_from_date IS NOT NULL THEN
658: FA_RX_UTIL_PKG.debug('Binding b_period_from_date');
659: DBMS_SQL.bind_variable(c, 'b_period_from_date', PARM.p_begin_period_from_date);
654: BEGIN
655: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_RTRMNT_bind()+');
656:
657: IF PARM.p_begin_period_from_date IS NOT NULL THEN
658: FA_RX_UTIL_PKG.debug('Binding b_period_from_date');
659: DBMS_SQL.bind_variable(c, 'b_period_from_date', PARM.p_begin_period_from_date);
660: END IF;
661:
662: IF PARM.p_end_period_to_date IS NOT NULL THEN
659: DBMS_SQL.bind_variable(c, 'b_period_from_date', PARM.p_begin_period_from_date);
660: END IF;
661:
662: IF PARM.p_end_period_to_date IS NOT NULL THEN
663: FA_RX_UTIL_PKG.debug('Binding b_period_to_date');
664: DBMS_SQL.bind_variable(c, 'b_period_to_date', PARM.p_end_period_to_date);
665: END IF;
666:
667: IF PARM.p_major_category IS NOT NULL THEN
664: DBMS_SQL.bind_variable(c, 'b_period_to_date', PARM.p_end_period_to_date);
665: END IF;
666:
667: IF PARM.p_major_category IS NOT NULL THEN
668: FA_RX_UTIL_PKG.debug('Binding major_category');
669: DBMS_SQL.bind_variable(c, 'b_major_category', PARM.p_major_category);
670: END IF;
671:
672: IF PARM.p_minor_category IS NOT NULL THEN
669: DBMS_SQL.bind_variable(c, 'b_major_category', PARM.p_major_category);
670: END IF;
671:
672: IF PARM.p_minor_category IS NOT NULL THEN
673: FA_RX_UTIL_PKG.debug('Binding b_minor_category');
674: DBMS_SQL.bind_variable(c, 'b_minor_category', PARM.p_minor_category);
675: END IF;
676:
677: IF PARM.p_book_type_code IS NOT NULL THEN
674: DBMS_SQL.bind_variable(c, 'b_minor_category', PARM.p_minor_category);
675: END IF;
676:
677: IF PARM.p_book_type_code IS NOT NULL THEN
678: FA_RX_UTIL_PKG.debug('Binding b_book_type_code');
679: DBMS_SQL.bind_variable(c, 'b_book_type_code', PARM.p_book_type_code);
680: END IF;
681:
682: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_RTRMNT_bind()-');
678: FA_RX_UTIL_PKG.debug('Binding b_book_type_code');
679: DBMS_SQL.bind_variable(c, 'b_book_type_code', PARM.p_book_type_code);
680: END IF;
681:
682: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_RTRMNT_bind()-');
683:
684: END fa_RTRMNT_bind;
685:
686:
691: PROCEDURE fa_RTRMNT_after_fetch IS
692:
693: X_msg VARCHAR2(100);
694: BEGIN
695: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_RTRMNT_after_fetch()+');
696:
697: -- Added for ECE Project
698: -- This code is added to get the Asset Flexfield
699: -- concatenated segment value
708: EXCEPTION
709: WHEN NO_DATA_FOUND THEN
710: X_msg := 'JG_RX_FAREG.fa_RTRMNT_after_fetch: NO_DATA_FOUND';
711: x_msg := x_msg || ' - Error in getting number_per_fiscal_year';
712: FA_RX_UTIL_PKG.debug(X_msg);
713: RAISE_APPLICATION_ERROR(-20010,X_msg);
714:
715: WHEN TOO_MANY_ROWS THEN
716: X_msg := 'JG_RX_FAREG.fa_RTRMNT_after_fetch: TOO_MANY_ROWS';
714:
715: WHEN TOO_MANY_ROWS THEN
716: X_msg := 'JG_RX_FAREG.fa_RTRMNT_after_fetch: TOO_MANY_ROWS';
717: x_msg := x_msg || ' - Error in getting number_per_fiscal_year';
718: FA_RX_UTIL_PKG.debug(X_msg);
719: RAISE_APPLICATION_ERROR(-20010,X_msg);
720: END;
721:
722: BEGIN
731: EXCEPTION
732: WHEN NO_DATA_FOUND THEN
733: X_msg := 'JG_RX_FAREG.fa_RTRMNT_after_fetch: NO_DATA_FOUND';
734: x_msg := x_msg || ' - Error in getting Asset Flexfield Value ';
735: FA_RX_UTIL_PKG.debug(X_msg);
736: RAISE_APPLICATION_ERROR(-20010,X_msg);
737:
738: WHEN TOO_MANY_ROWS THEN
739: X_msg := 'JG_RX_FAREG.fa_RTRMNT_after_fetch: TOO_MANY_ROWS';
737:
738: WHEN TOO_MANY_ROWS THEN
739: X_msg := 'JG_RX_FAREG.fa_RTRMNT_after_fetch: TOO_MANY_ROWS';
740: x_msg := x_msg || ' - Error in getting Asset Flexfield Value ';
741: FA_RX_UTIL_PKG.debug(X_msg);
742: RAISE_APPLICATION_ERROR(-20010,X_msg);
743:
744: END;
745:
757:
758: -- It takes the reserve values
759: Get_RTRMNT_reserve;
760:
761: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_RTRMNT_after_fetch()-');
762:
763: END fa_RTRMNT_after_fetch;
764:
765:
767: | fa_RTRMNT_after_report |
768: +====================================================================*/
769: PROCEDURE fa_RTRMNT_after_report IS
770: BEGIN
771: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_RTRMNT_after_report()+');
772:
773:
774: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_RTRMNT_after_report()-');
775: END fa_RTRMNT_after_report;
770: BEGIN
771: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_RTRMNT_after_report()+');
772:
773:
774: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_RTRMNT_after_report()-');
775: END fa_RTRMNT_after_report;
776:
777:
778: /*===================================================================+
783: X_Account_Segment Varchar2(50);
784: X_ret BOOLEAN := TRUE;
785: X_id_flex_num Number(15);
786: Begin
787: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_Account_segment()+');
788:
789: select sob.chart_of_accounts_id
790: into X_id_flex_num
791: from gl_sets_of_books sob,
799: X_id_flex_Num, -- x_id_flex_num in
800: 'GL_ACCOUNT', -- x_seg_attr_type
801: X_Account_segment); -- x_app_column_name
802: If X_ret = TRUE then
803: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Account_segment'||X_account_segment);
804: return (X_Account_Segment);
805: else
806: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Account_segment'||'NONE');
807: return ('NONE');
802: If X_ret = TRUE then
803: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Account_segment'||X_account_segment);
804: return (X_Account_Segment);
805: else
806: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Account_segment'||'NONE');
807: return ('NONE');
808: end if;
809: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_Account_segment()-');
810:
805: else
806: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Account_segment'||'NONE');
807: return ('NONE');
808: end if;
809: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_Account_segment()-');
810:
811: end Get_Account_Segment;
812:
813: /*===================================================================+
820: X_ret BOOLEAN := TRUE;
821: X_msg VARCHAR2(100);
822:
823: BEGIN
824: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_category_segment()+');
825:
826: -- Takes major segment
827: X_ret := FND_FLEX_APIS.get_segment_column(
828: 140, -- x_application_id
832: X_major_segment); -- x_app_column_name
833:
834: IF X_ret = FALSE THEN
835: X_msg := 'JG_RX_FAREG.Get_category_segment: error retrieving MAJOR SEGMENT';
836: FA_RX_UTIL_PKG.debug(X_msg);
837: RAISE_APPLICATION_ERROR(-20010,X_msg);
838: ELSIF PARM.p_major_category IS NOT NULL THEN
839: -- Building major segment condition
840: FA_RX_UTIL_PKG.debug('Major Category');
836: FA_RX_UTIL_PKG.debug(X_msg);
837: RAISE_APPLICATION_ERROR(-20010,X_msg);
838: ELSIF PARM.p_major_category IS NOT NULL THEN
839: -- Building major segment condition
840: FA_RX_UTIL_PKG.debug('Major Category');
841: X_where_clause := ' AND CA.' || X_major_segment || ' = :b_major_category ';
842: END IF;
843:
844: -- Takes minor segment
850: X_minor_segment); -- x_app_column_name
851:
852: IF X_ret = FALSE THEN
853: X_msg := 'JG_RX_FAREG.Get_category_segment: error retrieving MINOR SEGMENT';
854: FA_RX_UTIL_PKG.debug(X_msg);
855: X_minor_segment_sel := 'NULL';
856: -- RAISE_APPLICATION_ERROR(-20010,X_msg);
857: ELSIF PARM.p_minor_category IS NOT NULL THEN
858: -- Building minor segment condition
863: IF X_ret <> FALSE and PARM.p_minor_category IS NULL THEN
864: X_minor_segment_sel := 'CA.'||X_minor_segment;
865: END IF;
866:
867: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_category_segment()-');
868:
869: RETURN X_where_clause;
870:
871: END Get_category_segment;
881: IS
882:
883: X_msg VARCHAR2(100);
884: BEGIN
885: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_period_date()+');
886:
887: PARM.p_period_from := p_period_from;
888: PARM.p_period_to := p_period_to;
889:
888: PARM.p_period_to := p_period_to;
889:
890: -- Both period are required by anyway...
891: IF PARM.p_period_from IS NOT NULL THEN
892: FA_RX_UTIL_PKG.debug('Get period date from');
893:
894: SELECT calendar_period_open_date,
895: calendar_period_close_date,
896: period_counter,
907: AND period_name = PARM.p_period_from;
908: END IF;
909:
910: IF PARM.p_period_to IS NOT NULL THEN
911: FA_RX_UTIL_PKG.debug('Get period date to');
912:
913: SELECT calendar_period_open_date,
914: calendar_period_close_date,
915: period_counter
924: AND period_name = PARM.p_period_to;
925: END IF;
926:
927:
928: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_from_date ' || to_char(PARM.p_begin_period_from_date));
929: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_to_date ' || to_char(PARM.p_begin_period_to_date));
930: FA_RX_UTIL_PKG.debug('PARM.p_end_period_from_date ' || to_char(PARM.p_end_period_from_date));
931: FA_RX_UTIL_PKG.debug('PARM.p_end_period_to_date ' || to_char(PARM.p_end_period_to_date));
932: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_counter ' || to_char(PARM.p_begin_period_counter));
925: END IF;
926:
927:
928: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_from_date ' || to_char(PARM.p_begin_period_from_date));
929: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_to_date ' || to_char(PARM.p_begin_period_to_date));
930: FA_RX_UTIL_PKG.debug('PARM.p_end_period_from_date ' || to_char(PARM.p_end_period_from_date));
931: FA_RX_UTIL_PKG.debug('PARM.p_end_period_to_date ' || to_char(PARM.p_end_period_to_date));
932: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_counter ' || to_char(PARM.p_begin_period_counter));
933: FA_RX_UTIL_PKG.debug('PARM.p_end_period_counter'|| to_char(PARM.p_end_period_counter));
926:
927:
928: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_from_date ' || to_char(PARM.p_begin_period_from_date));
929: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_to_date ' || to_char(PARM.p_begin_period_to_date));
930: FA_RX_UTIL_PKG.debug('PARM.p_end_period_from_date ' || to_char(PARM.p_end_period_from_date));
931: FA_RX_UTIL_PKG.debug('PARM.p_end_period_to_date ' || to_char(PARM.p_end_period_to_date));
932: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_counter ' || to_char(PARM.p_begin_period_counter));
933: FA_RX_UTIL_PKG.debug('PARM.p_end_period_counter'|| to_char(PARM.p_end_period_counter));
934:
927:
928: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_from_date ' || to_char(PARM.p_begin_period_from_date));
929: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_to_date ' || to_char(PARM.p_begin_period_to_date));
930: FA_RX_UTIL_PKG.debug('PARM.p_end_period_from_date ' || to_char(PARM.p_end_period_from_date));
931: FA_RX_UTIL_PKG.debug('PARM.p_end_period_to_date ' || to_char(PARM.p_end_period_to_date));
932: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_counter ' || to_char(PARM.p_begin_period_counter));
933: FA_RX_UTIL_PKG.debug('PARM.p_end_period_counter'|| to_char(PARM.p_end_period_counter));
934:
935: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_period_date()-');
928: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_from_date ' || to_char(PARM.p_begin_period_from_date));
929: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_to_date ' || to_char(PARM.p_begin_period_to_date));
930: FA_RX_UTIL_PKG.debug('PARM.p_end_period_from_date ' || to_char(PARM.p_end_period_from_date));
931: FA_RX_UTIL_PKG.debug('PARM.p_end_period_to_date ' || to_char(PARM.p_end_period_to_date));
932: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_counter ' || to_char(PARM.p_begin_period_counter));
933: FA_RX_UTIL_PKG.debug('PARM.p_end_period_counter'|| to_char(PARM.p_end_period_counter));
934:
935: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_period_date()-');
936:
929: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_to_date ' || to_char(PARM.p_begin_period_to_date));
930: FA_RX_UTIL_PKG.debug('PARM.p_end_period_from_date ' || to_char(PARM.p_end_period_from_date));
931: FA_RX_UTIL_PKG.debug('PARM.p_end_period_to_date ' || to_char(PARM.p_end_period_to_date));
932: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_counter ' || to_char(PARM.p_begin_period_counter));
933: FA_RX_UTIL_PKG.debug('PARM.p_end_period_counter'|| to_char(PARM.p_end_period_counter));
934:
935: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_period_date()-');
936:
937: EXCEPTION
931: FA_RX_UTIL_PKG.debug('PARM.p_end_period_to_date ' || to_char(PARM.p_end_period_to_date));
932: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_counter ' || to_char(PARM.p_begin_period_counter));
933: FA_RX_UTIL_PKG.debug('PARM.p_end_period_counter'|| to_char(PARM.p_end_period_counter));
934:
935: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_period_date()-');
936:
937: EXCEPTION
938: WHEN NO_DATA_FOUND THEN
939: X_msg := 'JG_RX_FAREG.Get_period_date: NO_DATA_FOUND';
936:
937: EXCEPTION
938: WHEN NO_DATA_FOUND THEN
939: X_msg := 'JG_RX_FAREG.Get_period_date: NO_DATA_FOUND';
940: FA_RX_UTIL_PKG.debug(X_msg);
941: RAISE_APPLICATION_ERROR(-20010,X_msg);
942:
943: WHEN TOO_MANY_ROWS THEN
944: X_msg := 'JG_RX_FAREG.Get_period_date: TOO_MANY_ROWS';
941: RAISE_APPLICATION_ERROR(-20010,X_msg);
942:
943: WHEN TOO_MANY_ROWS THEN
944: X_msg := 'JG_RX_FAREG.Get_period_date: TOO_MANY_ROWS';
945: FA_RX_UTIL_PKG.debug(X_msg);
946: RAISE_APPLICATION_ERROR(-20010,X_msg);
947:
948: END Get_period_date;
949:
984: X_ret NUMBER(4);
985: X_msg VARCHAR2(100);
986:
987: BEGIN
988: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_starting_depreciation_year()+');
989:
990: SELECT FY.fiscal_year
991: INTO X_ret
992: FROM fa_fiscal_year FY,
999: AND FY.end_date
1000: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1001: AND BO.book_type_code = PARM.p_book_type_code;
1002:
1003: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_starting_depreciation_year()-');
1004:
1005: RETURN X_ret;
1006:
1007: EXCEPTION
1006:
1007: EXCEPTION
1008: WHEN NO_DATA_FOUND THEN
1009: X_msg := 'JG_RX_FAREG.Get_starting_depreciation_year: NO_DATA_FOUND';
1010: FA_RX_UTIL_PKG.debug(X_msg);
1011: RAISE_APPLICATION_ERROR(-20010,X_msg);
1012:
1013: WHEN TOO_MANY_ROWS THEN
1014: X_msg := 'JG_RX_FAREG.Get_starting_depreciation_year: TOO_MANY_ROWS';
1011: RAISE_APPLICATION_ERROR(-20010,X_msg);
1012:
1013: WHEN TOO_MANY_ROWS THEN
1014: X_msg := 'JG_RX_FAREG.Get_starting_depreciation_year: TOO_MANY_ROWS';
1015: FA_RX_UTIL_PKG.debug(X_msg);
1016: RAISE_APPLICATION_ERROR(-20010,X_msg);
1017:
1018: END Get_starting_depreciation_year;
1019:
1031: X_current_fiscal_year NUMBER;
1032: X_prorate_fiscal_year NUMBER;
1033:
1034: BEGIN
1035: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_depreciation_rate()+');
1036:
1037: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.rate_source_rule = ' || JG_RX_FAREG.var.rate_source_rule);
1038:
1039: -- FLAT
1033:
1034: BEGIN
1035: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_depreciation_rate()+');
1036:
1037: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.rate_source_rule = ' || JG_RX_FAREG.var.rate_source_rule);
1038:
1039: -- FLAT
1040: IF JG_RX_FAREG.var.rate_source_rule = 'FLAT' THEN
1041: JG_RX_FAREG.var.deprn_rate := JG_RX_FAREG.var.adjusted_rate;
1049: FROM fa_calendar_types
1050: WHERE calendar_type = X_deprn_calendar; -- X_deprn_calendar is retrieved in Get_fiscal_year_date()
1051: IF JG_RX_FAREG.var.rate_source_rule = 'CALCULATED' THEN
1052: X_life_in_years := JG_RX_FAREG.var.life_in_months / 12; -- Bug 4066022
1053: FA_RX_UTIL_PKG.debug('Life in years ='||to_char(X_life_in_years));
1054: JG_RX_FAREG.var.deprn_rate := round(1 / (X_life_in_years * X_number_per_fiscal_year),4);-- Bug 4066022 ,5081410
1055: FA_RX_UTIL_PKG.debug('Method Type Calculate..'||JG_RX_FAREG.var.rate_source_rule);
1056: FA_RX_UTIL_PKG.debug('deprn rate'||to_char(JG_RX_FAREG.var.deprn_rate));
1057: END IF;
1051: IF JG_RX_FAREG.var.rate_source_rule = 'CALCULATED' THEN
1052: X_life_in_years := JG_RX_FAREG.var.life_in_months / 12; -- Bug 4066022
1053: FA_RX_UTIL_PKG.debug('Life in years ='||to_char(X_life_in_years));
1054: JG_RX_FAREG.var.deprn_rate := round(1 / (X_life_in_years * X_number_per_fiscal_year),4);-- Bug 4066022 ,5081410
1055: FA_RX_UTIL_PKG.debug('Method Type Calculate..'||JG_RX_FAREG.var.rate_source_rule);
1056: FA_RX_UTIL_PKG.debug('deprn rate'||to_char(JG_RX_FAREG.var.deprn_rate));
1057: END IF;
1058: --Added this part for Formula Column for bug 2906455
1059: IF JG_RX_FAREG.var.rate_source_rule = 'FORMULA' THEN
1052: X_life_in_years := JG_RX_FAREG.var.life_in_months / 12; -- Bug 4066022
1053: FA_RX_UTIL_PKG.debug('Life in years ='||to_char(X_life_in_years));
1054: JG_RX_FAREG.var.deprn_rate := round(1 / (X_life_in_years * X_number_per_fiscal_year),4);-- Bug 4066022 ,5081410
1055: FA_RX_UTIL_PKG.debug('Method Type Calculate..'||JG_RX_FAREG.var.rate_source_rule);
1056: FA_RX_UTIL_PKG.debug('deprn rate'||to_char(JG_RX_FAREG.var.deprn_rate));
1057: END IF;
1058: --Added this part for Formula Column for bug 2906455
1059: IF JG_RX_FAREG.var.rate_source_rule = 'FORMULA' THEN
1060: X_life_in_years := JG_RX_FAREG.var.life_in_months / X_number_per_fiscal_year;
1057: END IF;
1058: --Added this part for Formula Column for bug 2906455
1059: IF JG_RX_FAREG.var.rate_source_rule = 'FORMULA' THEN
1060: X_life_in_years := JG_RX_FAREG.var.life_in_months / X_number_per_fiscal_year;
1061: FA_RX_UTIL_PKG.debug('Life in years ='||to_char(X_life_in_years));
1062: JG_RX_FAREG.var.deprn_rate := 1 / X_life_in_years;
1063: FA_RX_UTIL_PKG.debug('Method Type Formula is....'||JG_RX_FAREG.var.rate_source_rule);
1064: FA_RX_UTIL_PKG.debug('deprn rate'||to_char(JG_RX_FAREG.var.deprn_rate));
1065: END IF;
1059: IF JG_RX_FAREG.var.rate_source_rule = 'FORMULA' THEN
1060: X_life_in_years := JG_RX_FAREG.var.life_in_months / X_number_per_fiscal_year;
1061: FA_RX_UTIL_PKG.debug('Life in years ='||to_char(X_life_in_years));
1062: JG_RX_FAREG.var.deprn_rate := 1 / X_life_in_years;
1063: FA_RX_UTIL_PKG.debug('Method Type Formula is....'||JG_RX_FAREG.var.rate_source_rule);
1064: FA_RX_UTIL_PKG.debug('deprn rate'||to_char(JG_RX_FAREG.var.deprn_rate));
1065: END IF;
1066: --Changes finished for bug 2906455
1067: END IF;
1060: X_life_in_years := JG_RX_FAREG.var.life_in_months / X_number_per_fiscal_year;
1061: FA_RX_UTIL_PKG.debug('Life in years ='||to_char(X_life_in_years));
1062: JG_RX_FAREG.var.deprn_rate := 1 / X_life_in_years;
1063: FA_RX_UTIL_PKG.debug('Method Type Formula is....'||JG_RX_FAREG.var.rate_source_rule);
1064: FA_RX_UTIL_PKG.debug('deprn rate'||to_char(JG_RX_FAREG.var.deprn_rate));
1065: END IF;
1066: --Changes finished for bug 2906455
1067: END IF;
1068:
1076: from fa_methods
1077: where method_code = JG_RX_FAREG.var.deprn_method_code
1078: and nvl (life_in_months, -999) = nvl (JG_RX_FAREG.var.Life_In_Months, -999);
1079:
1080: FA_RX_UTIL_PKG.debug('Asset Id '||to_char(JG_RX_FAREG.var.asset_id));
1081: FA_RX_UTIL_PKG.debug('life in months'||to_char(JG_RX_FAREG.var.life_in_months));
1082: FA_RX_UTIL_PKG.debug('Fiscal Year '||to_char(JG_RX_FAREG.var.x_fiscal_year1));
1083: FA_RX_UTIL_PKG.debug('Short Fiscal Year'||JG_RX_FAREG.var.short_fiscal_year_flag);
1084: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1077: where method_code = JG_RX_FAREG.var.deprn_method_code
1078: and nvl (life_in_months, -999) = nvl (JG_RX_FAREG.var.Life_In_Months, -999);
1079:
1080: FA_RX_UTIL_PKG.debug('Asset Id '||to_char(JG_RX_FAREG.var.asset_id));
1081: FA_RX_UTIL_PKG.debug('life in months'||to_char(JG_RX_FAREG.var.life_in_months));
1082: FA_RX_UTIL_PKG.debug('Fiscal Year '||to_char(JG_RX_FAREG.var.x_fiscal_year1));
1083: FA_RX_UTIL_PKG.debug('Short Fiscal Year'||JG_RX_FAREG.var.short_fiscal_year_flag);
1084: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1085: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1078: and nvl (life_in_months, -999) = nvl (JG_RX_FAREG.var.Life_In_Months, -999);
1079:
1080: FA_RX_UTIL_PKG.debug('Asset Id '||to_char(JG_RX_FAREG.var.asset_id));
1081: FA_RX_UTIL_PKG.debug('life in months'||to_char(JG_RX_FAREG.var.life_in_months));
1082: FA_RX_UTIL_PKG.debug('Fiscal Year '||to_char(JG_RX_FAREG.var.x_fiscal_year1));
1083: FA_RX_UTIL_PKG.debug('Short Fiscal Year'||JG_RX_FAREG.var.short_fiscal_year_flag);
1084: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1085: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1086: FA_RX_UTIL_PKG.debug('Prorate DAte is..'||to_char(JG_RX_FAREG.var.prorate_Date, 'DD/MM/YYYY'));
1079:
1080: FA_RX_UTIL_PKG.debug('Asset Id '||to_char(JG_RX_FAREG.var.asset_id));
1081: FA_RX_UTIL_PKG.debug('life in months'||to_char(JG_RX_FAREG.var.life_in_months));
1082: FA_RX_UTIL_PKG.debug('Fiscal Year '||to_char(JG_RX_FAREG.var.x_fiscal_year1));
1083: FA_RX_UTIL_PKG.debug('Short Fiscal Year'||JG_RX_FAREG.var.short_fiscal_year_flag);
1084: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1085: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1086: FA_RX_UTIL_PKG.debug('Prorate DAte is..'||to_char(JG_RX_FAREG.var.prorate_Date, 'DD/MM/YYYY'));
1087: FA_RX_UTIL_PKG.debug('Conversion DAte is..'||to_char(JG_RX_FAREG.var.conversion_date, 'DD/MM/YYYY'));
1080: FA_RX_UTIL_PKG.debug('Asset Id '||to_char(JG_RX_FAREG.var.asset_id));
1081: FA_RX_UTIL_PKG.debug('life in months'||to_char(JG_RX_FAREG.var.life_in_months));
1082: FA_RX_UTIL_PKG.debug('Fiscal Year '||to_char(JG_RX_FAREG.var.x_fiscal_year1));
1083: FA_RX_UTIL_PKG.debug('Short Fiscal Year'||JG_RX_FAREG.var.short_fiscal_year_flag);
1084: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1085: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1086: FA_RX_UTIL_PKG.debug('Prorate DAte is..'||to_char(JG_RX_FAREG.var.prorate_Date, 'DD/MM/YYYY'));
1087: FA_RX_UTIL_PKG.debug('Conversion DAte is..'||to_char(JG_RX_FAREG.var.conversion_date, 'DD/MM/YYYY'));
1088: FA_RX_UTIL_PKG.debug('Orginal Deprn DAte is..'||to_char(JG_RX_FAREG.var.original_deprn_start_date, 'DD/MM/YYYY'));
1081: FA_RX_UTIL_PKG.debug('life in months'||to_char(JG_RX_FAREG.var.life_in_months));
1082: FA_RX_UTIL_PKG.debug('Fiscal Year '||to_char(JG_RX_FAREG.var.x_fiscal_year1));
1083: FA_RX_UTIL_PKG.debug('Short Fiscal Year'||JG_RX_FAREG.var.short_fiscal_year_flag);
1084: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1085: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1086: FA_RX_UTIL_PKG.debug('Prorate DAte is..'||to_char(JG_RX_FAREG.var.prorate_Date, 'DD/MM/YYYY'));
1087: FA_RX_UTIL_PKG.debug('Conversion DAte is..'||to_char(JG_RX_FAREG.var.conversion_date, 'DD/MM/YYYY'));
1088: FA_RX_UTIL_PKG.debug('Orginal Deprn DAte is..'||to_char(JG_RX_FAREG.var.original_deprn_start_date, 'DD/MM/YYYY'));
1089: FA_RX_UTIL_PKG.debug('deprn rate for Formula before is ..'||to_char(JG_RX_FAREG.var.deprn_rate));
1082: FA_RX_UTIL_PKG.debug('Fiscal Year '||to_char(JG_RX_FAREG.var.x_fiscal_year1));
1083: FA_RX_UTIL_PKG.debug('Short Fiscal Year'||JG_RX_FAREG.var.short_fiscal_year_flag);
1084: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1085: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1086: FA_RX_UTIL_PKG.debug('Prorate DAte is..'||to_char(JG_RX_FAREG.var.prorate_Date, 'DD/MM/YYYY'));
1087: FA_RX_UTIL_PKG.debug('Conversion DAte is..'||to_char(JG_RX_FAREG.var.conversion_date, 'DD/MM/YYYY'));
1088: FA_RX_UTIL_PKG.debug('Orginal Deprn DAte is..'||to_char(JG_RX_FAREG.var.original_deprn_start_date, 'DD/MM/YYYY'));
1089: FA_RX_UTIL_PKG.debug('deprn rate for Formula before is ..'||to_char(JG_RX_FAREG.var.deprn_rate));
1090:
1083: FA_RX_UTIL_PKG.debug('Short Fiscal Year'||JG_RX_FAREG.var.short_fiscal_year_flag);
1084: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1085: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1086: FA_RX_UTIL_PKG.debug('Prorate DAte is..'||to_char(JG_RX_FAREG.var.prorate_Date, 'DD/MM/YYYY'));
1087: FA_RX_UTIL_PKG.debug('Conversion DAte is..'||to_char(JG_RX_FAREG.var.conversion_date, 'DD/MM/YYYY'));
1088: FA_RX_UTIL_PKG.debug('Orginal Deprn DAte is..'||to_char(JG_RX_FAREG.var.original_deprn_start_date, 'DD/MM/YYYY'));
1089: FA_RX_UTIL_PKG.debug('deprn rate for Formula before is ..'||to_char(JG_RX_FAREG.var.deprn_rate));
1090:
1091: FA_CDE_PKG.faxgfr(X_Book_Type_Code => PARM.p_book_type_code,
1084: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1085: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1086: FA_RX_UTIL_PKG.debug('Prorate DAte is..'||to_char(JG_RX_FAREG.var.prorate_Date, 'DD/MM/YYYY'));
1087: FA_RX_UTIL_PKG.debug('Conversion DAte is..'||to_char(JG_RX_FAREG.var.conversion_date, 'DD/MM/YYYY'));
1088: FA_RX_UTIL_PKG.debug('Orginal Deprn DAte is..'||to_char(JG_RX_FAREG.var.original_deprn_start_date, 'DD/MM/YYYY'));
1089: FA_RX_UTIL_PKG.debug('deprn rate for Formula before is ..'||to_char(JG_RX_FAREG.var.deprn_rate));
1090:
1091: FA_CDE_PKG.faxgfr(X_Book_Type_Code => PARM.p_book_type_code,
1092: X_Asset_Id => JG_RX_FAREG.var.asset_id,
1085: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1086: FA_RX_UTIL_PKG.debug('Prorate DAte is..'||to_char(JG_RX_FAREG.var.prorate_Date, 'DD/MM/YYYY'));
1087: FA_RX_UTIL_PKG.debug('Conversion DAte is..'||to_char(JG_RX_FAREG.var.conversion_date, 'DD/MM/YYYY'));
1088: FA_RX_UTIL_PKG.debug('Orginal Deprn DAte is..'||to_char(JG_RX_FAREG.var.original_deprn_start_date, 'DD/MM/YYYY'));
1089: FA_RX_UTIL_PKG.debug('deprn rate for Formula before is ..'||to_char(JG_RX_FAREG.var.deprn_rate));
1090:
1091: FA_CDE_PKG.faxgfr(X_Book_Type_Code => PARM.p_book_type_code,
1092: X_Asset_Id => JG_RX_FAREG.var.asset_id,
1093: X_Short_Fiscal_Year_Flag => JG_RX_FAREG.var.short_fiscal_year_flag,
1124: X_Success => success
1125: );
1126:
1127: JG_RX_FAREG.var.deprn_rate := X_rate1;
1128: FA_RX_UTIL_PKG.debug('deprn rate for Formula is ..'||to_char(JG_RX_FAREG.var.deprn_rate));
1129: FA_RX_UTIL_PKG.debug('Success Code for Formula is ..'||to_char(success));
1130:
1131: END IF;*/
1132: -- Amar added above part to fix bug 2906455.
1125: );
1126:
1127: JG_RX_FAREG.var.deprn_rate := X_rate1;
1128: FA_RX_UTIL_PKG.debug('deprn rate for Formula is ..'||to_char(JG_RX_FAREG.var.deprn_rate));
1129: FA_RX_UTIL_PKG.debug('Success Code for Formula is ..'||to_char(success));
1130:
1131: END IF;*/
1132: -- Amar added above part to fix bug 2906455.
1133: -- TABLE
1139: SELECT ROUND(JG_RX_FAREG.var.life_in_months/12)
1140: INTO X_life_of_asset
1141: FROM dual;
1142:
1143: FA_RX_UTIL_PKG.debug('Life of the asset= ' || to_char(x_life_of_asset));
1144: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
1145: FA_RX_UTIL_PKG.debug('start date = ' || JG_RX_FAREG.var.prorate_date);
1146: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JG_RX_FAREG.var.date_placed_in_service);
1147: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
1140: INTO X_life_of_asset
1141: FROM dual;
1142:
1143: FA_RX_UTIL_PKG.debug('Life of the asset= ' || to_char(x_life_of_asset));
1144: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
1145: FA_RX_UTIL_PKG.debug('start date = ' || JG_RX_FAREG.var.prorate_date);
1146: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JG_RX_FAREG.var.date_placed_in_service);
1147: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
1148: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JG_RX_FAREG.var.method_id));
1141: FROM dual;
1142:
1143: FA_RX_UTIL_PKG.debug('Life of the asset= ' || to_char(x_life_of_asset));
1144: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
1145: FA_RX_UTIL_PKG.debug('start date = ' || JG_RX_FAREG.var.prorate_date);
1146: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JG_RX_FAREG.var.date_placed_in_service);
1147: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
1148: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JG_RX_FAREG.var.method_id));
1149:
1142:
1143: FA_RX_UTIL_PKG.debug('Life of the asset= ' || to_char(x_life_of_asset));
1144: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
1145: FA_RX_UTIL_PKG.debug('start date = ' || JG_RX_FAREG.var.prorate_date);
1146: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JG_RX_FAREG.var.date_placed_in_service);
1147: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
1148: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JG_RX_FAREG.var.method_id));
1149:
1150: -- Fix for Bug #5384045. To find the correct rate, we need to use
1143: FA_RX_UTIL_PKG.debug('Life of the asset= ' || to_char(x_life_of_asset));
1144: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
1145: FA_RX_UTIL_PKG.debug('start date = ' || JG_RX_FAREG.var.prorate_date);
1146: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JG_RX_FAREG.var.date_placed_in_service);
1147: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
1148: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JG_RX_FAREG.var.method_id));
1149:
1150: -- Fix for Bug #5384045. To find the correct rate, we need to use
1151: -- the current year of the asset's life rather than the entire life
1144: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
1145: FA_RX_UTIL_PKG.debug('start date = ' || JG_RX_FAREG.var.prorate_date);
1146: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JG_RX_FAREG.var.date_placed_in_service);
1147: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
1148: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JG_RX_FAREG.var.method_id));
1149:
1150: -- Fix for Bug #5384045. To find the correct rate, we need to use
1151: -- the current year of the asset's life rather than the entire life
1152: -- of the asset (X_life_of_asset) when joining to fa_rates.
1189:
1190: JG_RX_FAREG.var.deprn_rate := JG_RX_FAREG.var.deprn_rate *100;
1191: END IF;
1192:
1193: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_rate =' || TO_CHAR(JG_RX_FAREG.var.deprn_rate));
1194:
1195: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_depreciation_rate()-');
1196:
1197: EXCEPTION
1191: END IF;
1192:
1193: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_rate =' || TO_CHAR(JG_RX_FAREG.var.deprn_rate));
1194:
1195: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_depreciation_rate()-');
1196:
1197: EXCEPTION
1198: WHEN NO_DATA_FOUND THEN
1199: X_msg := 'JG_RX_FAREG.Get_depreciation_rate: NO_DATA_FOUND';
1196:
1197: EXCEPTION
1198: WHEN NO_DATA_FOUND THEN
1199: X_msg := 'JG_RX_FAREG.Get_depreciation_rate: NO_DATA_FOUND';
1200: FA_RX_UTIL_PKG.debug(X_msg);
1201: RAISE_APPLICATION_ERROR(-20010,X_msg);
1202:
1203: WHEN TOO_MANY_ROWS THEN
1204: X_msg := 'JG_RX_FAREG.Get_depreciation_rate: TOO_MANY_ROWS';
1201: RAISE_APPLICATION_ERROR(-20010,X_msg);
1202:
1203: WHEN TOO_MANY_ROWS THEN
1204: X_msg := 'JG_RX_FAREG.Get_depreciation_rate: TOO_MANY_ROWS';
1205: FA_RX_UTIL_PKG.debug(X_msg);
1206: RAISE_APPLICATION_ERROR(-20010,X_msg);
1207:
1208: END Get_depreciation_rate;
1209:
1222: v_selectstmnt3 varchar2(10000);
1223: V_expense_account varchar2(100);
1224: v_dummy integer ;
1225: BEGIN
1226: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_Deprn_Account()+');
1227: JG_RX_FAREG.var.expense_account := NULL;
1228: v_cursorId := DBMS_SQL.OPEN_CURSOR;
1229: v_Selectstmnt1 :=
1230: 'select distinct '||X_account_segment||' from '||
1252: DBMS_SQL.COLUMN_VALUE(V_cursorId,1,V_expense_account);
1253: JG_RX_FAREG.var.expense_account:= JG_RX_FAREG.var.expense_account||V_expense_account;
1254: END LOOP;
1255: dbms_sql.close_cursor(v_cursorId);
1256: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.expense_account = ' || JG_RX_FAREG.var.expense_account);
1257: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_depr_account()-');
1258: END Get_deprn_accounts;
1259:
1260:
1253: JG_RX_FAREG.var.expense_account:= JG_RX_FAREG.var.expense_account||V_expense_account;
1254: END LOOP;
1255: dbms_sql.close_cursor(v_cursorId);
1256: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.expense_account = ' || JG_RX_FAREG.var.expense_account);
1257: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_depr_account()-');
1258: END Get_deprn_accounts;
1259:
1260:
1261:
1268: IS
1269: X_msg VARCHAR2(100);
1270:
1271: BEGIN
1272: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_inv_number()+');
1273: select distinct invoice_number,
1274: vendor_name
1275: into JG_RX_FAREG.var.invoice_number,
1276: JG_RX_FAREG.var.supplier_name
1282: -- IT.book_type_code = PARM.p_book_type_code;
1283: IT.book_type_code = fabc.DISTRIBUTION_SOURCE_BOOK and
1284: fabc.book_type_code = PARM.p_book_type_code;
1285:
1286: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.invoice_number = ' || JG_RX_FAREG.var.invoice_number);
1287: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.supplier_name = ' || JG_RX_FAREG.var.supplier_name);
1288: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_inv_number() - ');
1289: EXCEPTION
1290: WHEN NO_DATA_FOUND THEN
1283: IT.book_type_code = fabc.DISTRIBUTION_SOURCE_BOOK and
1284: fabc.book_type_code = PARM.p_book_type_code;
1285:
1286: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.invoice_number = ' || JG_RX_FAREG.var.invoice_number);
1287: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.supplier_name = ' || JG_RX_FAREG.var.supplier_name);
1288: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_inv_number() - ');
1289: EXCEPTION
1290: WHEN NO_DATA_FOUND THEN
1291: X_msg := 'JG_RX_FAREG.Get_inv_number: NO_DATA_FOUND';
1284: fabc.book_type_code = PARM.p_book_type_code;
1285:
1286: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.invoice_number = ' || JG_RX_FAREG.var.invoice_number);
1287: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.supplier_name = ' || JG_RX_FAREG.var.supplier_name);
1288: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_inv_number() - ');
1289: EXCEPTION
1290: WHEN NO_DATA_FOUND THEN
1291: X_msg := 'JG_RX_FAREG.Get_inv_number: NO_DATA_FOUND';
1292: FA_RX_UTIL_PKG.debug(X_msg);
1288: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_inv_number() - ');
1289: EXCEPTION
1290: WHEN NO_DATA_FOUND THEN
1291: X_msg := 'JG_RX_FAREG.Get_inv_number: NO_DATA_FOUND';
1292: FA_RX_UTIL_PKG.debug(X_msg);
1293: JG_RX_FAREG.var.invoice_number := null;
1294: JG_RX_FAREG.var.supplier_name := null;
1295: END Get_invoice_number;
1296:
1306: X_msg VARCHAR2(100);
1307: X_parent_asset_number VARCHAR2(15);
1308:
1309: BEGIN
1310: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_parent_asset_number()+');
1311:
1312: SELECT asset_number
1313: INTO X_parent_asset_number
1314: FROM fa_additions
1313: INTO X_parent_asset_number
1314: FROM fa_additions
1315: WHERE asset_id = JG_RX_FAREG.var.parent_asset_id;
1316:
1317: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_parent_asset_number()-');
1318:
1319: RETURN X_parent_asset_number;
1320:
1321: EXCEPTION
1320:
1321: EXCEPTION
1322: WHEN NO_DATA_FOUND THEN
1323: X_msg := 'JG_RX_FAREG.Get_parent_asset_number: NO_DATA_FOUND';
1324: FA_RX_UTIL_PKG.debug(X_msg);
1325: RAISE_APPLICATION_ERROR(-20010,X_msg);
1326:
1327: END Get_parent_asset_number;
1328:
1335:
1336: X_msg VARCHAR2(100);
1337:
1338: BEGIN
1339: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Startup()+');
1340:
1341: -- It takes the segment condition
1342: X_where_clause_tmp := Get_category_segment;
1343:
1340:
1341: -- It takes the segment condition
1342: X_where_clause_tmp := Get_category_segment;
1343:
1344: FA_RX_UTIL_PKG.debug('Get Company name');
1345: -- Get Company name and store in placeholder variable
1346: SELECT company_name
1347: INTO JG_RX_FAREG.var.organization_name
1348: FROM fa_system_controls;
1347: INTO JG_RX_FAREG.var.organization_name
1348: FROM fa_system_controls;
1349:
1350:
1351: FA_RX_UTIL_PKG.debug('Get currency code');
1352: -- Get currency code and store in placeholder variable
1353: SELECT currency_code
1354: INTO JG_RX_FAREG.var.functional_currency_code
1355: FROM gl_sets_of_books
1354: INTO JG_RX_FAREG.var.functional_currency_code
1355: FROM gl_sets_of_books
1356: WHERE set_of_books_id = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
1357:
1358: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Startup()-');
1359:
1360: EXCEPTION
1361: WHEN NO_DATA_FOUND THEN
1362: X_msg := 'JG_RX_FAREG.Startup: NO_DATA_FOUND';
1359:
1360: EXCEPTION
1361: WHEN NO_DATA_FOUND THEN
1362: X_msg := 'JG_RX_FAREG.Startup: NO_DATA_FOUND';
1363: FA_RX_UTIL_PKG.debug(X_msg);
1364: RAISE_APPLICATION_ERROR(-20010,X_msg);
1365:
1366: WHEN TOO_MANY_ROWS THEN
1367: X_msg := 'JG_RX_FAREG.Startup: TOO_MANY_ROWS';
1364: RAISE_APPLICATION_ERROR(-20010,X_msg);
1365:
1366: WHEN TOO_MANY_ROWS THEN
1367: X_msg := 'JG_RX_FAREG.Startup: TOO_MANY_ROWS';
1368: FA_RX_UTIL_PKG.debug(X_msg);
1369: RAISE_APPLICATION_ERROR(-20010,X_msg);
1370:
1371: END Startup;
1372:
1380: X_msg VARCHAR2(100);
1381: X_capitalized NUMBER(10);
1382:
1383: BEGIN
1384: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_value()+');
1385:
1386: BEGIN
1387: FA_RX_UTIL_PKG.debug('Get cost initial value');
1388: -- Get initial value
1383: BEGIN
1384: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_value()+');
1385:
1386: BEGIN
1387: FA_RX_UTIL_PKG.debug('Get cost initial value');
1388: -- Get initial value
1389: SELECT count(*)
1390: INTO X_capitalized
1391: FROM fa_books BO
1412: AND BO1.asset_id = BO.asset_id
1413: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1414: AND TRH.transaction_date_entered < PARM.p_begin_period_from_date);
1415: END IF;
1416: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_initial =' || TO_CHAR(JG_RX_FAREG.var.asset_cost_initial));
1417:
1418: EXCEPTION
1419: WHEN NO_DATA_FOUND THEN
1420: JG_RX_FAREG.var.asset_cost_initial := 0;
1419: WHEN NO_DATA_FOUND THEN
1420: JG_RX_FAREG.var.asset_cost_initial := 0;
1421: END;
1422:
1423: FA_RX_UTIL_PKG.debug('Get cost final value');
1424: -- Get final value
1425: BEGIN
1426: SELECT cost,
1427: transaction_header_id_in
1437: WHERE BO1.book_type_code = BO.book_type_code
1438: AND BO1.asset_id = BO.asset_id
1439: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1440: AND TRH.transaction_date_entered <= PARM.p_end_period_to_date);
1441: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_final =' || TO_CHAR(JG_RX_FAREG.var.asset_cost_final));
1442: EXCEPTION
1443: WHEN NO_DATA_FOUND THEN
1444: JG_RX_FAREG.var.asset_cost_final := 0;
1445: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_final =' ||'no data found');
1441: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_final =' || TO_CHAR(JG_RX_FAREG.var.asset_cost_final));
1442: EXCEPTION
1443: WHEN NO_DATA_FOUND THEN
1444: JG_RX_FAREG.var.asset_cost_final := 0;
1445: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_final =' ||'no data found');
1446:
1447: END;
1448:
1449: -- It takes the asset cost increase
1453: Get_cost_decrease;
1454: -- 09/08/00 AFERRARA
1455: JG_RX_FAREG.var.asset_variation := JG_RX_FAREG.var.asset_cost_increase -
1456: JG_RX_FAREG.var.asset_cost_decrease;
1457: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_total(before) =' || JG_RX_FAREG.var.revaluation_total);
1458: JG_RX_FAREG.var.revaluation_total := JG_RX_FAREG.var.revaluation_final;
1459: -- JG_RX_FAREG.var.asset_cost_final -
1460: -- JG_RX_FAREG.var.asset_cost_orig;
1461: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_variation =' || JG_RX_FAREG.var.asset_variation);
1457: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_total(before) =' || JG_RX_FAREG.var.revaluation_total);
1458: JG_RX_FAREG.var.revaluation_total := JG_RX_FAREG.var.revaluation_final;
1459: -- JG_RX_FAREG.var.asset_cost_final -
1460: -- JG_RX_FAREG.var.asset_cost_orig;
1461: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_variation =' || JG_RX_FAREG.var.asset_variation);
1462: -- 09/08/00 AFERRARA
1463:
1464: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_value()-');
1465:
1460: -- JG_RX_FAREG.var.asset_cost_orig;
1461: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_variation =' || JG_RX_FAREG.var.asset_variation);
1462: -- 09/08/00 AFERRARA
1463:
1464: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_value()-');
1465:
1466: EXCEPTION
1467: WHEN NO_DATA_FOUND THEN
1468: X_msg := 'JG_RX_FAREG.Get_cost_value: NO_DATA_FOUND';
1465:
1466: EXCEPTION
1467: WHEN NO_DATA_FOUND THEN
1468: X_msg := 'JG_RX_FAREG.Get_cost_value: NO_DATA_FOUND';
1469: FA_RX_UTIL_PKG.debug(X_msg);
1470: RAISE_APPLICATION_ERROR(-20010,X_msg);
1471:
1472: WHEN TOO_MANY_ROWS THEN
1473: X_msg := 'JG_RX_FAREG.Get_cost_value: TOO_MANY_ROWS';
1470: RAISE_APPLICATION_ERROR(-20010,X_msg);
1471:
1472: WHEN TOO_MANY_ROWS THEN
1473: X_msg := 'JG_RX_FAREG.Get_cost_value: TOO_MANY_ROWS';
1474: FA_RX_UTIL_PKG.debug(X_msg);
1475: RAISE_APPLICATION_ERROR(-20010,X_msg);
1476:
1477: END Get_cost_value;
1478:
1488: X_revaluation_plus NUMBER := 0;
1489: X_reinstatements NUMBER := 0;
1490:
1491: BEGIN
1492: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_increase()+');
1493:
1494: -------------------------------------------------------------------------------
1495: FA_RX_UTIL_PKG.debug('Get partial addition ');
1496: fa_rx_util_pkg.debug('transaction id'||X_transaction_id_initial);
1491: BEGIN
1492: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_increase()+');
1493:
1494: -------------------------------------------------------------------------------
1495: FA_RX_UTIL_PKG.debug('Get partial addition ');
1496: fa_rx_util_pkg.debug('transaction id'||X_transaction_id_initial);
1497: fa_rx_util_pkg.debug('PARM.p_begin_period_to_date'||to_char(PARM.p_begin_period_to_date));
1498: fa_rx_util_pkg.debug('PARM.p_end_period_from_date'||to_char(PARM.p_end_period_from_date));
1499:
1492: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_increase()+');
1493:
1494: -------------------------------------------------------------------------------
1495: FA_RX_UTIL_PKG.debug('Get partial addition ');
1496: fa_rx_util_pkg.debug('transaction id'||X_transaction_id_initial);
1497: fa_rx_util_pkg.debug('PARM.p_begin_period_to_date'||to_char(PARM.p_begin_period_to_date));
1498: fa_rx_util_pkg.debug('PARM.p_end_period_from_date'||to_char(PARM.p_end_period_from_date));
1499:
1500: SELECT SUM(AD.adjustment_amount)
1493:
1494: -------------------------------------------------------------------------------
1495: FA_RX_UTIL_PKG.debug('Get partial addition ');
1496: fa_rx_util_pkg.debug('transaction id'||X_transaction_id_initial);
1497: fa_rx_util_pkg.debug('PARM.p_begin_period_to_date'||to_char(PARM.p_begin_period_to_date));
1498: fa_rx_util_pkg.debug('PARM.p_end_period_from_date'||to_char(PARM.p_end_period_from_date));
1499:
1500: SELECT SUM(AD.adjustment_amount)
1501: INTO X_partial_addition
1494: -------------------------------------------------------------------------------
1495: FA_RX_UTIL_PKG.debug('Get partial addition ');
1496: fa_rx_util_pkg.debug('transaction id'||X_transaction_id_initial);
1497: fa_rx_util_pkg.debug('PARM.p_begin_period_to_date'||to_char(PARM.p_begin_period_to_date));
1498: fa_rx_util_pkg.debug('PARM.p_end_period_from_date'||to_char(PARM.p_end_period_from_date));
1499:
1500: SELECT SUM(AD.adjustment_amount)
1501: INTO X_partial_addition
1502: FROM fa_books BO,
1519: AND TH.transaction_date_entered BETWEEN (PARM.p_begin_period_from_date)
1520: AND (PARM.p_end_period_to_date);
1521: -- changed bo.date_effective to TH.transaction_date_entered
1522:
1523: FA_RX_UTIL_PKG.debug('partial addition =' || TO_CHAR(X_partial_addition));
1524:
1525:
1526: -------------------------------------------------------------------------------
1527: FA_RX_UTIL_PKG.debug('Get manual adjustment upwards');
1523: FA_RX_UTIL_PKG.debug('partial addition =' || TO_CHAR(X_partial_addition));
1524:
1525:
1526: -------------------------------------------------------------------------------
1527: FA_RX_UTIL_PKG.debug('Get manual adjustment upwards');
1528:
1529: SELECT SUM(AD.adjustment_amount)
1530: INTO X_manual_adjustment_plus
1531: FROM fa_transaction_headers TH,
1540: AND AD.debit_credit_flag = 'DR'
1541: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1542: AND PARM.p_end_period_to_date;
1543:
1544: FA_RX_UTIL_PKG.debug('Get manual adjustment upwards =' || TO_CHAR(X_manual_adjustment_plus));
1545:
1546:
1547: -------------------------------------------------------------------------------
1548: FA_RX_UTIL_PKG.debug('Get revaluations upward ');
1544: FA_RX_UTIL_PKG.debug('Get manual adjustment upwards =' || TO_CHAR(X_manual_adjustment_plus));
1545:
1546:
1547: -------------------------------------------------------------------------------
1548: FA_RX_UTIL_PKG.debug('Get revaluations upward ');
1549:
1550: SELECT SUM(AD.adjustment_amount)
1551: INTO X_revaluation_plus
1552: FROM fa_transaction_headers TH,
1562: AND AD.adjustment_amount > 0
1563: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1564: AND PARM.p_end_period_to_date;
1565:
1566: FA_RX_UTIL_PKG.debug('Revaluations Upward =' || TO_CHAR(X_revaluation_plus));
1567:
1568:
1569: -------------------------------------------------------------------------------
1570: FA_RX_UTIL_PKG.debug('Get reinstatements ');
1566: FA_RX_UTIL_PKG.debug('Revaluations Upward =' || TO_CHAR(X_revaluation_plus));
1567:
1568:
1569: -------------------------------------------------------------------------------
1570: FA_RX_UTIL_PKG.debug('Get reinstatements ');
1571:
1572: SELECT SUM(RE.cost_retired)
1573: INTO X_reinstatements
1574: FROM fa_transaction_headers TH,
1581: AND TH.asset_id = JG_RX_FAREG.var.asset_id
1582: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1583: AND PARM.p_end_period_to_date;
1584: -- jmary changing date_retired to transaction_date
1585: FA_RX_UTIL_PKG.debug('Reinstatements =' || TO_CHAR(X_reinstatements));
1586:
1587:
1588:
1589: JG_RX_FAREG.var.asset_cost_increase := NVL(X_partial_addition,0) +
1590: NVL(X_manual_adjustment_plus,0) +
1591: NVL(X_revaluation_plus,0) +
1592: NVL(X_reinstatements,0);
1593:
1594: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_increase =' || JG_RX_FAREG.var.asset_cost_increase);
1595:
1596: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_increase()-');
1597:
1598:
1592: NVL(X_reinstatements,0);
1593:
1594: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_increase =' || JG_RX_FAREG.var.asset_cost_increase);
1595:
1596: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_increase()-');
1597:
1598:
1599: END Get_cost_increase;
1600:
1611: X_revaluation_minus NUMBER := 0;
1612: X_retirements NUMBER := 0;
1613:
1614: BEGIN
1615: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_decrease()+');
1616:
1617:
1618: -------------------------------------------------------------------------------
1619: FA_RX_UTIL_PKG.debug('Get credit memos ');
1615: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_decrease()+');
1616:
1617:
1618: -------------------------------------------------------------------------------
1619: FA_RX_UTIL_PKG.debug('Get credit memos ');
1620:
1621: SELECT SUM(AD.adjustment_amount)
1622: INTO X_credit_memos
1623: FROM fa_books BO,
1640: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1641: AND PARM.p_end_period_to_date;
1642: -- changed date_effective to transaction_date_entered
1643:
1644: FA_RX_UTIL_PKG.debug('credit memos =' || TO_CHAR(X_credit_memos));
1645:
1646:
1647: -------------------------------------------------------------------------------
1648: FA_RX_UTIL_PKG.debug('Get manual adjustment downwards');
1644: FA_RX_UTIL_PKG.debug('credit memos =' || TO_CHAR(X_credit_memos));
1645:
1646:
1647: -------------------------------------------------------------------------------
1648: FA_RX_UTIL_PKG.debug('Get manual adjustment downwards');
1649:
1650: SELECT SUM(AD.adjustment_amount)
1651: INTO X_manual_adjustment_minus
1652: FROM fa_transaction_headers TH,
1661: AND AD.debit_credit_flag = 'CR'
1662: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1663: AND PARM.p_end_period_to_date;
1664:
1665: FA_RX_UTIL_PKG.debug('Get manual adjustment downwards =' || TO_CHAR(X_manual_adjustment_minus));
1666:
1667:
1668: -------------------------------------------------------------------------------
1669: FA_RX_UTIL_PKG.debug('Get revaluations downward ');
1665: FA_RX_UTIL_PKG.debug('Get manual adjustment downwards =' || TO_CHAR(X_manual_adjustment_minus));
1666:
1667:
1668: -------------------------------------------------------------------------------
1669: FA_RX_UTIL_PKG.debug('Get revaluations downward ');
1670:
1671: SELECT SUM(AD.adjustment_amount)
1672: INTO X_revaluation_minus
1673: FROM fa_transaction_headers TH,
1682: AND AD.debit_credit_flag = 'CR'
1683: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1684: AND PARM.p_end_period_to_date;
1685:
1686: FA_RX_UTIL_PKG.debug('Revaluations downward =' || TO_CHAR(X_revaluation_minus));
1687:
1688:
1689: -------------------------------------------------------------------------------
1690: FA_RX_UTIL_PKG.debug('Get retirements ');
1686: FA_RX_UTIL_PKG.debug('Revaluations downward =' || TO_CHAR(X_revaluation_minus));
1687:
1688:
1689: -------------------------------------------------------------------------------
1690: FA_RX_UTIL_PKG.debug('Get retirements ');
1691:
1692: SELECT SUM(RE.cost_retired)
1693: INTO X_retirements
1694: FROM fa_transaction_headers TH,
1702: AND TH.asset_id = JG_RX_FAREG.var.asset_id
1703: AND RE.date_retired BETWEEN PARM.p_begin_period_from_date /* changed Transaction Date to Retirement Date */
1704: AND PARM.p_end_period_to_date;
1705:
1706: FA_RX_UTIL_PKG.debug('Retirements =' || TO_CHAR(X_retirements));
1707:
1708:
1709:
1710: JG_RX_FAREG.var.asset_cost_decrease := NVL(X_credit_memos,0) +
1711: NVL(X_manual_adjustment_minus,0) +
1712: NVL(X_revaluation_minus,0) +
1713: NVL(X_retirements,0);
1714:
1715: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_decrease =' || JG_RX_FAREG.var.asset_cost_decrease);
1716:
1717: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_decrease()-');
1718:
1719:
1713: NVL(X_retirements,0);
1714:
1715: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_decrease =' || JG_RX_FAREG.var.asset_cost_decrease);
1716:
1717: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_decrease()-');
1718:
1719:
1720: END Get_cost_decrease;
1721:
1726: PROCEDURE Get_revaluation
1727: IS
1728:
1729: BEGIN
1730: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation()+');
1731:
1732: BEGIN
1733: FA_RX_UTIL_PKG.debug('Get_revaluation initial value');
1734: -- Get initial value
1729: BEGIN
1730: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation()+');
1731:
1732: BEGIN
1733: FA_RX_UTIL_PKG.debug('Get_revaluation initial value');
1734: -- Get initial value
1735: SELECT SUM(DECODE(debit_credit_flag, 'DR', adjustment_amount, 0)) -
1736: SUM(DECODE(debit_credit_flag, 'CR', adjustment_amount, 0))
1737: INTO JG_RX_FAREG.var.revaluation_initial
1745: IF JG_RX_FAREG.var.revaluation_initial IS NULL THEN
1746: JG_RX_FAREG.var.revaluation_initial := 0;
1747: END IF;
1748:
1749: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_initial =' || TO_CHAR(JG_RX_FAREG.var.revaluation_initial));
1750: END;
1751:
1752:
1753: BEGIN
1750: END;
1751:
1752:
1753: BEGIN
1754: FA_RX_UTIL_PKG.debug('Get_revaluation final value');
1755: -- Get final value
1756: SELECT SUM(DECODE(debit_credit_flag, 'DR', adjustment_amount, 0)) -
1757: SUM(DECODE(debit_credit_flag, 'CR', adjustment_amount, 0))
1758: INTO JG_RX_FAREG.var.revaluation_final
1767: JG_RX_FAREG.var.revaluation_final := 0;
1768: END IF;
1769:
1770:
1771: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_final =' || TO_CHAR(JG_RX_FAREG.var.revaluation_final));
1772: END;
1773:
1774: -- It takes the asset revaluation increase
1775: Get_revaluation_change;
1777: -- 09/08/00 AFERRARA
1778: JG_RX_FAREG.var.reval_variation := JG_RX_FAREG.var.revaluation_increase -
1779: JG_RX_FAREG.var.revaluation_decrease;
1780:
1781: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.reval_variation =' || JG_RX_FAREG.var.reval_variation);
1782: -- 09/08/00 AFERRARA
1783:
1784: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation()-');
1785:
1780:
1781: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.reval_variation =' || JG_RX_FAREG.var.reval_variation);
1782: -- 09/08/00 AFERRARA
1783:
1784: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation()-');
1785:
1786: END Get_revaluation;
1787:
1788: /*===================================================================+
1791: PROCEDURE Get_revaluation_change
1792: IS
1793:
1794: BEGIN
1795: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_change()+');
1796:
1797: SELECT SUM(DECODE(DEBIT_CREDIT_FLAG,'DR',AD.adjustment_amount,0)),
1798: SUM(DECODE(DEBIT_CREDIT_FLAG,'CR',AD.adjustment_amount,0))
1799: INTO JG_RX_FAREG.var.revaluation_increase,JG_RX_FAREG.var.revaluation_decrease
1810: IF JG_RX_FAREG.var.revaluation_decrease IS NULL THEN
1811: JG_RX_FAREG.var.revaluation_decrease := 0;
1812: END IF;
1813:
1814: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_increase =' || JG_RX_FAREG.var.revaluation_increase);
1815: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_decrease =' || JG_RX_FAREG.var.revaluation_decrease);
1816:
1817: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_change()-');
1818:
1811: JG_RX_FAREG.var.revaluation_decrease := 0;
1812: END IF;
1813:
1814: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_increase =' || JG_RX_FAREG.var.revaluation_increase);
1815: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_decrease =' || JG_RX_FAREG.var.revaluation_decrease);
1816:
1817: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_change()-');
1818:
1819:
1813:
1814: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_increase =' || JG_RX_FAREG.var.revaluation_increase);
1815: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_decrease =' || JG_RX_FAREG.var.revaluation_decrease);
1816:
1817: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_change()-');
1818:
1819:
1820: END Get_revaluation_change;
1821:
1827:
1828: X_msg VARCHAR2(100);
1829:
1830: BEGIN
1831: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_value()+');
1832:
1833: -------------------------------------------------------------------------------
1834: BEGIN
1835: FA_RX_UTIL_PKG.debug('Get deprn reserve initial value');
1831: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_value()+');
1832:
1833: -------------------------------------------------------------------------------
1834: BEGIN
1835: FA_RX_UTIL_PKG.debug('Get deprn reserve initial value');
1836: -- Get initial value
1837:
1838: SELECT (NVL(deprn_reserve,0) - NVL(bonus_deprn_reserve,0))
1839: INTO JG_RX_FAREG.var.deprn_reserve_initial
1846: and asset_id= JG_RX_FAREG.var.asset_id
1847: and book_type_code = PARM.p_book_type_code );
1848:
1849:
1850: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_reserve_initial =' || TO_CHAR(JG_RX_FAREG.var.deprn_reserve_initial));
1851: EXCEPTION
1852: WHEN NO_DATA_FOUND THEN
1853: JG_RX_FAREG.var.deprn_reserve_initial := 0;
1854: END;
1855:
1856:
1857: -------------------------------------------------------------------------------
1858: BEGIN
1859: FA_RX_UTIL_PKG.debug('Get deprn reserve final value');
1860: -- Get final value
1861: SELECT (NVL(deprn_reserve,0) - NVL(bonus_deprn_reserve,0)),
1862: ytd_deprn
1863: INTO JG_RX_FAREG.var.deprn_reserve_final
1872: and asset_id= JG_RX_FAREG.var.asset_id
1873: and book_type_code = PARM.p_book_type_code );
1874:
1875:
1876: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_reserve_final =' || TO_CHAR(JG_RX_FAREG.var.deprn_reserve_final));
1877: --Added this part to fix bug 3240485
1878: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.ytd_deprn=' || TO_CHAR(JG_RX_FAREG.var.ytd_deprn));
1879: --Added the above part to fix bug 3240485
1880: EXCEPTION
1874:
1875:
1876: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_reserve_final =' || TO_CHAR(JG_RX_FAREG.var.deprn_reserve_final));
1877: --Added this part to fix bug 3240485
1878: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.ytd_deprn=' || TO_CHAR(JG_RX_FAREG.var.ytd_deprn));
1879: --Added the above part to fix bug 3240485
1880: EXCEPTION
1881: WHEN NO_DATA_FOUND THEN
1882: JG_RX_FAREG.var.deprn_reserve_final := 0;
1892: -- 09/08/00 AFERRARA
1893: JG_RX_FAREG.var.deprn_variation := JG_RX_FAREG.var.deprn_reserve_increase -
1894: JG_RX_FAREG.var.deprn_reserve_decrease;
1895:
1896: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_variation =' || JG_RX_FAREG.var.deprn_variation);
1897: -- 09/08/00 AFERRARA
1898:
1899:
1900: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_value()-');
1896: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_variation =' || JG_RX_FAREG.var.deprn_variation);
1897: -- 09/08/00 AFERRARA
1898:
1899:
1900: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_value()-');
1901:
1902: EXCEPTION
1903: WHEN TOO_MANY_ROWS THEN
1904: X_msg := 'JG_RX_FAREG.Get_deprn_reserve_value: TOO_MANY_ROWS';
1901:
1902: EXCEPTION
1903: WHEN TOO_MANY_ROWS THEN
1904: X_msg := 'JG_RX_FAREG.Get_deprn_reserve_value: TOO_MANY_ROWS';
1905: FA_RX_UTIL_PKG.debug(X_msg);
1906: RAISE_APPLICATION_ERROR(-20010,X_msg);
1907:
1908:
1909: END Get_deprn_reserve_value;
1921: X_tax_re_adjustment_plus NUMBER := 0;
1922: X_revaluation_cr NUMBER := 0;
1923:
1924: BEGIN
1925: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_increase()+');
1926:
1927: -------------------------------------------------------------------------------
1928: FA_RX_UTIL_PKG.debug('Get ordinary depreciation ');
1929:
1924: BEGIN
1925: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_increase()+');
1926:
1927: -------------------------------------------------------------------------------
1928: FA_RX_UTIL_PKG.debug('Get ordinary depreciation ');
1929:
1930: SELECT SUM((NVL(deprn_amount,0) - NVL(bonus_deprn_amount,0)))
1931: INTO X_ord_deprn
1932: FROM fa_deprn_summary
1934: AND asset_id = JG_RX_FAREG.var.asset_id
1935: AND period_counter BETWEEN PARM.p_begin_period_counter
1936: AND PARM.p_end_period_counter;
1937:
1938: FA_RX_UTIL_PKG.debug('Ordinary depreciation =' || TO_CHAR(X_ord_deprn));
1939:
1940:
1941: -------------------------------------------------------------------------------
1942: FA_RX_UTIL_PKG.debug('Get increase due to reinstatements and Revaluations ');
1938: FA_RX_UTIL_PKG.debug('Ordinary depreciation =' || TO_CHAR(X_ord_deprn));
1939:
1940:
1941: -------------------------------------------------------------------------------
1942: FA_RX_UTIL_PKG.debug('Get increase due to reinstatements and Revaluations ');
1943:
1944: SELECT nvl(abs(SUM(DECODE(adjustment_type,'RESERVE',adjustment_amount,0)) -
1945: SUM(DECODE(adjustment_type,'BONUS RESERVE',adjustment_amount,0))),0)
1946: INTO X_revaluation_cr
1971:
1972: X_reinstatements := X_reinstatements+X_revaluation_cr;
1973:
1974:
1975: FA_RX_UTIL_PKG.debug('Reinstatements =' || TO_CHAR(X_reinstatements));
1976:
1977: -------------------------------------------------------------------------------
1978: FA_RX_UTIL_PKG.debug('Get positive tax reserve adjustment ');
1979:
1974:
1975: FA_RX_UTIL_PKG.debug('Reinstatements =' || TO_CHAR(X_reinstatements));
1976:
1977: -------------------------------------------------------------------------------
1978: FA_RX_UTIL_PKG.debug('Get positive tax reserve adjustment ');
1979:
1980: SELECT SUM(adjustment_amount)
1981: INTO X_tax_re_adjustment_plus
1982: FROM fa_adjustments AD
1987: AND AD.asset_id = JG_RX_FAREG.var.asset_id
1988: AND AD.period_counter_created BETWEEN PARM.p_begin_period_counter
1989: AND PARM.p_end_period_counter;
1990: -- changed period_counter_adjusted to period_counter_created
1991: FA_RX_UTIL_PKG.debug('Positive tax reserve adjustment =' || TO_CHAR(X_tax_re_adjustment_plus));
1992:
1993:
1994: JG_RX_FAREG.var.deprn_reserve_increase := NVL(X_ord_deprn,0) +
1995: NVL(X_reinstatements,0) +
1994: JG_RX_FAREG.var.deprn_reserve_increase := NVL(X_ord_deprn,0) +
1995: NVL(X_reinstatements,0) +
1996: NVL(X_tax_re_adjustment_plus,0);
1997:
1998: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_reserve_increase =' || JG_RX_FAREG.var.deprn_reserve_increase);
1999:
2000:
2001: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_increase()-');
2002:
1997:
1998: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_reserve_increase =' || JG_RX_FAREG.var.deprn_reserve_increase);
1999:
2000:
2001: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_increase()-');
2002:
2003:
2004: END Get_deprn_reserve_increase;
2005:
2015: X_tax_re_adjustment_minus NUMBER := 0;
2016: X_revaluation_dr NUMBER := 0;
2017:
2018: BEGIN
2019: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_decrease()+');
2020:
2021:
2022: -------------------------------------------------------------------------------
2023: FA_RX_UTIL_PKG.debug('Get deprn reserve decrease due to retirements and revaluations');
2019: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_decrease()+');
2020:
2021:
2022: -------------------------------------------------------------------------------
2023: FA_RX_UTIL_PKG.debug('Get deprn reserve decrease due to retirements and revaluations');
2024:
2025: SELECT nvl(abs(SUM(DECODE(adjustment_type,'RESERVE',adjustment_amount,0)) -
2026: SUM(DECODE(adjustment_type,'BONUS RESERVE',adjustment_amount,0))),0)
2027: INTO X_revaluation_dr
2050: AND PARM.p_end_period_counter;
2051:
2052: X_retirements := X_retirements+X_revaluation_dr;
2053:
2054: FA_RX_UTIL_PKG.debug('Retirements =' || TO_CHAR(X_retirements));
2055:
2056:
2057:
2058: -------------------------------------------------------------------------------
2055:
2056:
2057:
2058: -------------------------------------------------------------------------------
2059: FA_RX_UTIL_PKG.debug('Get negative financial adjustment ');
2060:
2061: SELECT abs(SUM(DECODE(adjustment_type,'EXPENSE',adjustment_amount,0)) -
2062: SUM(DECODE(adjustment_type,'BONUS EXPENSE',adjustment_amount,0)))
2063: INTO X_financ_adjustment_minus
2068: AND AD.asset_id = JG_RX_FAREG.var.asset_id
2069: AND AD.period_counter_adjusted BETWEEN PARM.p_begin_period_counter
2070: AND PARM.p_end_period_counter;
2071:
2072: FA_RX_UTIL_PKG.debug('Negative financial adjustment =' || TO_CHAR(X_financ_adjustment_minus));
2073:
2074: JG_RX_FAREG.var.deprn_reserve_increase := JG_RX_FAREG.var.deprn_reserve_increase +nvl(X_financ_adjustment_minus,0);
2075:
2076: /* to show the increase and then minus it */
2075:
2076: /* to show the increase and then minus it */
2077:
2078: -------------------------------------------------------------------------------
2079: FA_RX_UTIL_PKG.debug('Get negative tax reserve adjustment ');
2080:
2081: SELECT SUM(adjustment_amount)
2082: INTO X_tax_re_adjustment_minus
2083: FROM fa_adjustments AD
2088: AND AD.asset_id = JG_RX_FAREG.var.asset_id
2089: AND AD.period_counter_created BETWEEN PARM.p_begin_period_counter
2090: AND PARM.p_end_period_counter;
2091: -- jmary changed period_counter_adjusted to period_counter_created
2092: FA_RX_UTIL_PKG.debug('Negative tax reserve adjustment =' || TO_CHAR(X_tax_re_adjustment_minus));
2093:
2094:
2095: JG_RX_FAREG.var.deprn_reserve_decrease := NVL(X_retirements,0) +
2096: NVL(X_financ_adjustment_minus,0) +
2095: JG_RX_FAREG.var.deprn_reserve_decrease := NVL(X_retirements,0) +
2096: NVL(X_financ_adjustment_minus,0) +
2097: NVL(X_tax_re_adjustment_minus,0);
2098:
2099: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_reserve_decrease =' || JG_RX_FAREG.var.deprn_reserve_decrease);
2100:
2101:
2102: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_decrease()-');
2103:
2098:
2099: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_reserve_decrease =' || JG_RX_FAREG.var.deprn_reserve_decrease);
2100:
2101:
2102: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_decrease()-');
2103:
2104:
2105: END Get_deprn_reserve_decrease;
2106:
2114:
2115: X_msg VARCHAR2(100);
2116:
2117: BEGIN
2118: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_value()+');
2119:
2120: -------------------------------------------------------------------------------
2121: BEGIN
2122: FA_RX_UTIL_PKG.debug('Get bonus reserve initial value');
2118: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_value()+');
2119:
2120: -------------------------------------------------------------------------------
2121: BEGIN
2122: FA_RX_UTIL_PKG.debug('Get bonus reserve initial value');
2123: -- Get initial value
2124:
2125: SELECT NVL(bonus_deprn_reserve,0)
2126: INTO JG_RX_FAREG.var.bonus_reserve_initial
2134: AND asset_id= JG_RX_FAREG.var.asset_id
2135: AND book_type_code = PARM.p_book_type_code );
2136:
2137:
2138: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.bonus_reserve_initial =' || TO_CHAR(JG_RX_FAREG.var.bonus_reserve_initial));
2139: EXCEPTION
2140: WHEN NO_DATA_FOUND THEN
2141: JG_RX_FAREG.var.bonus_reserve_initial := 0;
2142: END;
2143:
2144:
2145: -------------------------------------------------------------------------------
2146: BEGIN
2147: FA_RX_UTIL_PKG.debug('Get bonus reserve final value');
2148: -- Get final value
2149: SELECT NVL(bonus_deprn_reserve,0)
2150: INTO JG_RX_FAREG.var.bonus_reserve_final
2151: FROM fa_deprn_summary
2158: AND asset_id= JG_RX_FAREG.var.asset_id
2159: AND book_type_code = PARM.p_book_type_code );
2160:
2161:
2162: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.bonus_reserve_final =' || TO_CHAR(JG_RX_FAREG.var.bonus_reserve_final));
2163: EXCEPTION
2164: WHEN NO_DATA_FOUND THEN
2165: JG_RX_FAREG.var.bonus_reserve_final := 0;
2166: END;
2174: -- 09/08/00 AFERRARA
2175: JG_RX_FAREG.var.bonus_variation := JG_RX_FAREG.var.bonus_reserve_increase -
2176: JG_RX_FAREG.var.bonus_reserve_decrease;
2177:
2178: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.bonus_variation =' || JG_RX_FAREG.var.bonus_variation);
2179: -- 09/08/00 AFERRARA
2180:
2181:
2182:
2179: -- 09/08/00 AFERRARA
2180:
2181:
2182:
2183: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_value()-');
2184:
2185: EXCEPTION
2186: WHEN TOO_MANY_ROWS THEN
2187: X_msg := 'JG_RX_FAREG.Get_bonus_reserve_value: TOO_MANY_ROWS';
2184:
2185: EXCEPTION
2186: WHEN TOO_MANY_ROWS THEN
2187: X_msg := 'JG_RX_FAREG.Get_bonus_reserve_value: TOO_MANY_ROWS';
2188: FA_RX_UTIL_PKG.debug(X_msg);
2189: RAISE_APPLICATION_ERROR(-20010,X_msg);
2190:
2191:
2192: END Get_bonus_reserve_value;
2204: X_financ_adjustment_plus NUMBER := 0;
2205: X_tax_re_adjustment_plus NUMBER := 0;
2206:
2207: BEGIN
2208: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_increase()+');
2209:
2210: -------------------------------------------------------------------------------
2211: FA_RX_UTIL_PKG.debug('Get bonus depreciation ');
2212:
2207: BEGIN
2208: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_increase()+');
2209:
2210: -------------------------------------------------------------------------------
2211: FA_RX_UTIL_PKG.debug('Get bonus depreciation ');
2212:
2213: SELECT sum(bonus_deprn_amount)
2214: INTO X_bonus_deprn
2215: FROM fa_deprn_summary
2217: AND asset_id = JG_RX_FAREG.var.asset_id
2218: AND period_counter BETWEEN PARM.p_begin_period_counter
2219: AND PARM.p_end_period_counter;
2220:
2221: FA_RX_UTIL_PKG.debug('Bonus depreciation =' || TO_CHAR(X_bonus_deprn));
2222:
2223:
2224: -------------------------------------------------------------------------------
2225: FA_RX_UTIL_PKG.debug('Get reinstatements ');
2221: FA_RX_UTIL_PKG.debug('Bonus depreciation =' || TO_CHAR(X_bonus_deprn));
2222:
2223:
2224: -------------------------------------------------------------------------------
2225: FA_RX_UTIL_PKG.debug('Get reinstatements ');
2226:
2227: SELECT SUM(adjustment_amount)
2228: INTO X_reinstatements
2229: FROM fa_adjustments AD
2233: AND AD.adjustment_type = 'BONUS RESERVE'
2234: AND AD.debit_credit_flag = 'CR'
2235: AND AD.period_counter_adjusted BETWEEN PARM.p_begin_period_counter
2236: AND PARM.p_end_period_counter;
2237: FA_RX_UTIL_PKG.debug('Reinstatements =' || TO_CHAR(X_reinstatements));
2238:
2239:
2240: JG_RX_FAREG.var.bonus_reserve_increase := NVL(X_bonus_deprn,0) +
2241: NVL(X_reinstatements,0) ;
2239:
2240: JG_RX_FAREG.var.bonus_reserve_increase := NVL(X_bonus_deprn,0) +
2241: NVL(X_reinstatements,0) ;
2242:
2243: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.bonus_reserve_increase =' || JG_RX_FAREG.var.bonus_reserve_increase);
2244:
2245:
2246: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_increase()-');
2247:
2242:
2243: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.bonus_reserve_increase =' || JG_RX_FAREG.var.bonus_reserve_increase);
2244:
2245:
2246: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_increase()-');
2247:
2248:
2249: END Get_bonus_reserve_increase;
2250:
2258: X_retirements NUMBER := 0;
2259: X_financ_adjustment_minus NUMBER := 0;
2260:
2261: BEGIN
2262: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_decrease()+');
2263:
2264:
2265: -------------------------------------------------------------------------------
2266: FA_RX_UTIL_PKG.debug('Get retirements and revaluations ');
2262: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_decrease()+');
2263:
2264:
2265: -------------------------------------------------------------------------------
2266: FA_RX_UTIL_PKG.debug('Get retirements and revaluations ');
2267: SELECT ABS(SUM(adjustment_amount))
2268: INTO X_retirements
2269: FROM fa_adjustments AD
2270: WHERE AD.source_type_code in ('RETIREMENT','REVALUATION')
2275: AND AD.period_counter_adjusted BETWEEN PARM.p_begin_period_counter
2276: AND PARM.p_end_period_counter;
2277:
2278:
2279: FA_RX_UTIL_PKG.debug('Retirements =' || TO_CHAR(X_retirements));
2280:
2281:
2282:
2283: -------------------------------------------------------------------------------
2280:
2281:
2282:
2283: -------------------------------------------------------------------------------
2284: FA_RX_UTIL_PKG.debug('Get Negative financial adjustment ');
2285: SELECT ABS(SUM(adjustment_amount))
2286: INTO X_financ_adjustment_minus
2287: FROM fa_adjustments AD
2288: WHERE AD.source_type_code = 'DEPRECIATION'
2293: AND AD.period_counter_adjusted BETWEEN PARM.p_begin_period_counter
2294: AND PARM.p_end_period_counter;
2295: JG_RX_FAREG.var.bonus_reserve_increase := JG_RX_FAREG.var.bonus_reserve_increase +nvl(X_financ_adjustment_minus,0);
2296:
2297: FA_RX_UTIL_PKG.debug('Negative financial adjustment =' || TO_CHAR(X_financ_adjustment_minus));
2298:
2299:
2300: JG_RX_FAREG.var.bonus_reserve_decrease := NVL(X_retirements,0) +
2301: NVL(X_financ_adjustment_minus,0);
2299:
2300: JG_RX_FAREG.var.bonus_reserve_decrease := NVL(X_retirements,0) +
2301: NVL(X_financ_adjustment_minus,0);
2302:
2303: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.bonus_reserve_decrease =' || JG_RX_FAREG.var.bonus_reserve_decrease);
2304:
2305:
2306: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_decrease()-');
2307:
2302:
2303: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.bonus_reserve_decrease =' || JG_RX_FAREG.var.bonus_reserve_decrease);
2304:
2305:
2306: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_decrease()-');
2307:
2308:
2309: END Get_bonus_reserve_decrease;
2310:
2317:
2318: X_msg VARCHAR2(100);
2319:
2320: BEGIN
2321: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_fiscal_year_date()+');
2322:
2323: SELECT start_date,
2324: end_date,
2325: deprn_calendar,
2334: AND FY.fiscal_year_name = BC.fiscal_year_name
2335: AND BC.book_type_code = PARM.p_book_type_code;
2336:
2337:
2338: FA_RX_UTIL_PKG.debug('X_fiscal_year_start_date =' || TO_CHAR(X_fiscal_year_start_date));
2339: FA_RX_UTIL_PKG.debug('X_fiscal_year_end_date =' || TO_CHAR(X_fiscal_year_end_date));
2340:
2341:
2342: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_fiscal_year_date()-');
2335: AND BC.book_type_code = PARM.p_book_type_code;
2336:
2337:
2338: FA_RX_UTIL_PKG.debug('X_fiscal_year_start_date =' || TO_CHAR(X_fiscal_year_start_date));
2339: FA_RX_UTIL_PKG.debug('X_fiscal_year_end_date =' || TO_CHAR(X_fiscal_year_end_date));
2340:
2341:
2342: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_fiscal_year_date()-');
2343:
2338: FA_RX_UTIL_PKG.debug('X_fiscal_year_start_date =' || TO_CHAR(X_fiscal_year_start_date));
2339: FA_RX_UTIL_PKG.debug('X_fiscal_year_end_date =' || TO_CHAR(X_fiscal_year_end_date));
2340:
2341:
2342: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_fiscal_year_date()-');
2343:
2344: -- Added for ECE Project
2345: BEGIN
2346: SELECT number_per_fiscal_year
2354:
2355: EXCEPTION
2356: WHEN NO_DATA_FOUND THEN
2357: X_msg := 'JG_RX_FAREG.Get_fiscal_year_date: NO_DATA_FOUND';
2358: FA_RX_UTIL_PKG.debug(X_msg);
2359: RAISE_APPLICATION_ERROR(-20010,X_msg);
2360:
2361: WHEN TOO_MANY_ROWS THEN
2362: X_msg := 'JG_RX_FAREG.Get_fiscal_year_date: TOO_MANY_ROWS';
2359: RAISE_APPLICATION_ERROR(-20010,X_msg);
2360:
2361: WHEN TOO_MANY_ROWS THEN
2362: X_msg := 'JG_RX_FAREG.Get_fiscal_year_date: TOO_MANY_ROWS';
2363: FA_RX_UTIL_PKG.debug(X_msg);
2364: RAISE_APPLICATION_ERROR(-20010,X_msg);
2365:
2366: END Get_fiscal_year_date;
2367:
2375: X_year NUMBER;
2376: X_starting_depreciation_year NUMBER(4);
2377:
2378: BEGIN
2379: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_rate()+');
2380:
2381: JG_RX_FAREG.var.bonus_rate := 0; -- To print 0 instead of NULL
2382:
2383: IF JG_RX_FAREG.var.bonus_rule IS NOT NULL THEN
2380:
2381: JG_RX_FAREG.var.bonus_rate := 0; -- To print 0 instead of NULL
2382:
2383: IF JG_RX_FAREG.var.bonus_rule IS NOT NULL THEN
2384: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_rate: JG_RX_FAREG.var.bonus_rule IS NOT NULL');
2385:
2386: X_starting_depreciation_year := Get_starting_depreciation_year;
2387:
2388: X_year := TO_NUMBER(X_fiscal_year) - X_starting_depreciation_year + 1;
2411:
2412: X_msg VARCHAR2(100);
2413:
2414: BEGIN
2415: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_transactions()+');
2416:
2417: Get_addition_transactions;
2418:
2419: Get_adjustment_transactions;
2421: Get_retirement_transactions;
2422:
2423: Get_revaluation_transactions;
2424:
2425: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_transactions()-');
2426:
2427: END Get_transactions;
2428:
2429:
2449: AND TH.transaction_date_entered BETWEEN X_fiscal_year_start_date
2450: AND PARM.p_end_period_to_date;
2451: -- changing X_fiscal_year_end_date to PARM.p_end_period_to_date
2452: BEGIN
2453: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_addition_transactions()+');
2454: FOR c_addition IN c_additon_trans LOOP
2455: IF (X_first_row = FALSE and c_additon_trans%ROWCOUNT=0) then
2456: exit ;
2457: end if;
2468: p_transaction_amount => c_addition.cost);
2469: END IF;
2470:
2471: END LOOP;
2472: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_addition_transactions()-');
2473:
2474: END Get_addition_transactions;
2475:
2476:
2500:
2501: -- changing X_fiscal_year_end_date to PARM.p_end_period_to_date
2502:
2503: BEGIN
2504: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_adjustment_transactions()+');
2505: FOR c_adjustment IN c_adjustment_trans LOOP
2506: IF (X_first_row = FALSE and c_adjustment_trans%ROWCOUNT=0) then
2507: exit ;
2508: end if;
2520: END IF;
2521:
2522: END LOOP;
2523:
2524: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_adjustment_transactions()-');
2525:
2526: END Get_adjustment_transactions;
2527:
2528:
2552:
2553: -- changing X_fiscal_year_end_date to PARM.p_end_period_to_date
2554:
2555: BEGIN
2556: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_retirement_transactions()+');
2557:
2558: FOR c_retirement IN c_retirement_trans LOOP
2559: IF (X_first_row = FALSE and c_retirement_trans%ROWCOUNT=0) then
2560: exit ;
2573: END IF;
2574:
2575: END LOOP;
2576:
2577: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_retirement_transactions()-');
2578:
2579: END Get_retirement_transactions;
2580:
2581: /*===================================================================+
2607:
2608: -- changing X_fiscal_year_end_date to PARM.p_end_period_to_date
2609:
2610: BEGIN
2611: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_transactions()+');
2612: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_transactions()+');
2613: FOR c_revaluation IN c_revaluation_trans LOOP
2614: IF X_first_row = FALSE THEN -- It is the first time...
2615: JG_RX_FAREG.var.transaction_date := c_revaluation.transaction_date_entered;
2608: -- changing X_fiscal_year_end_date to PARM.p_end_period_to_date
2609:
2610: BEGIN
2611: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_transactions()+');
2612: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_transactions()+');
2613: FOR c_revaluation IN c_revaluation_trans LOOP
2614: IF X_first_row = FALSE THEN -- It is the first time...
2615: JG_RX_FAREG.var.transaction_date := c_revaluation.transaction_date_entered;
2616: JG_RX_FAREG.var.transaction_number := c_revaluation.transaction_header_id;
2617: JG_RX_FAREG.var.transaction_code := c_revaluation.transaction_type_code;
2618: JG_RX_FAREG.var.transaction_amount := c_revaluation.adjustment_amount;
2619: X_first_row := TRUE;
2620: ELSE -- The current row is alredy used
2621: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.rowcount'||to_char(c_revaluation_trans%ROWCOUNT));
2622: Insert_transaction(p_transaction_date => c_revaluation.transaction_date_entered,
2623: p_transaction_number => c_revaluation.transaction_header_id,
2624: p_transaction_code => c_revaluation.transaction_type_code,
2625: p_transaction_amount => c_revaluation.adjustment_amount);
2626: END IF;
2627:
2628: END LOOP;
2629:
2630: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_transactions()-');
2631:
2632: END Get_revaluation_transactions;
2633:
2634:
2641: p_transaction_amount NUMBER)
2642: IS
2643:
2644: BEGIN
2645: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Insert_transaction()+');
2646:
2647: INSERT INTO jg_zz_fa_reg_itf(
2648: request_id,
2649: organization_name,
2805: -- Added above to fix bug 3240485
2806: );
2807:
2808:
2809: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Insert_transaction()-');
2810:
2811: END Insert_transaction;
2812:
2813:
2817: PROCEDURE Get_Net_Book_Value
2818: IS
2819:
2820: BEGIN
2821: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_Net_Book_Value()+');
2822:
2823: JG_RX_FAREG.var.net_book_value_initial := NVL(JG_RX_FAREG.var.asset_cost_initial,0) -
2824: NVL(JG_RX_FAREG.var.deprn_reserve_initial,0) -
2825: NVL(JG_RX_FAREG.var.bonus_reserve_initial,0) ;
2837: -- + 09/08/00 AFERRARA
2838: JG_RX_FAREG.var.netbo_variation := JG_RX_FAREG.var.net_book_value_increase -
2839: JG_RX_FAREG.var.net_book_value_decrease;
2840:
2841: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.netbo_variation =' || JG_RX_FAREG.var.netbo_variation);
2842: -- - 09/08/00 AFERRARA
2843:
2844: JG_RX_FAREG.var.net_book_value_final := NVL(JG_RX_FAREG.var.asset_cost_final,0) -
2845: NVL(JG_RX_FAREG.var.deprn_reserve_final,0) -
2844: JG_RX_FAREG.var.net_book_value_final := NVL(JG_RX_FAREG.var.asset_cost_final,0) -
2845: NVL(JG_RX_FAREG.var.deprn_reserve_final,0) -
2846: NVL(JG_RX_FAREG.var.bonus_reserve_final,0) ;
2847:
2848: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_Net_Book_Value()-');
2849:
2850: END Get_Net_Book_Value;
2851:
2852: