[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:
991: X_ret NUMBER(4);
992: X_msg VARCHAR2(100);
993:
994: BEGIN
995: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_starting_depreciation_year()+');
996:
997: SELECT FY.fiscal_year
998: INTO X_ret
999: FROM fa_fiscal_year FY,
1006: AND FY.end_date
1007: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1008: AND BO.book_type_code = PARM.p_book_type_code;
1009:
1010: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_starting_depreciation_year()-');
1011:
1012: RETURN X_ret;
1013:
1014: EXCEPTION
1013:
1014: EXCEPTION
1015: WHEN NO_DATA_FOUND THEN
1016: X_msg := 'JG_RX_FAREG.Get_starting_depreciation_year: NO_DATA_FOUND';
1017: FA_RX_UTIL_PKG.debug(X_msg);
1018: RAISE_APPLICATION_ERROR(-20010,X_msg);
1019:
1020: WHEN TOO_MANY_ROWS THEN
1021: X_msg := 'JG_RX_FAREG.Get_starting_depreciation_year: TOO_MANY_ROWS';
1018: RAISE_APPLICATION_ERROR(-20010,X_msg);
1019:
1020: WHEN TOO_MANY_ROWS THEN
1021: X_msg := 'JG_RX_FAREG.Get_starting_depreciation_year: TOO_MANY_ROWS';
1022: FA_RX_UTIL_PKG.debug(X_msg);
1023: RAISE_APPLICATION_ERROR(-20010,X_msg);
1024:
1025: END Get_starting_depreciation_year;
1026:
1038: X_current_fiscal_year NUMBER;
1039: X_prorate_fiscal_year NUMBER;
1040:
1041: BEGIN
1042: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_depreciation_rate()+');
1043:
1044: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.rate_source_rule = ' || JG_RX_FAREG.var.rate_source_rule);
1045:
1046: -- FLAT
1040:
1041: BEGIN
1042: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_depreciation_rate()+');
1043:
1044: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.rate_source_rule = ' || JG_RX_FAREG.var.rate_source_rule);
1045:
1046: -- FLAT
1047: IF JG_RX_FAREG.var.rate_source_rule = 'FLAT' THEN
1048: JG_RX_FAREG.var.deprn_rate := JG_RX_FAREG.var.adjusted_rate;
1056: FROM fa_calendar_types
1057: WHERE calendar_type = X_deprn_calendar; -- X_deprn_calendar is retrieved in Get_fiscal_year_date()
1058: IF JG_RX_FAREG.var.rate_source_rule = 'CALCULATED' THEN
1059: X_life_in_years := JG_RX_FAREG.var.life_in_months / 12; -- Bug 4066022
1060: FA_RX_UTIL_PKG.debug('Life in years ='||to_char(X_life_in_years));
1061: JG_RX_FAREG.var.deprn_rate := round(1 / (X_life_in_years * X_number_per_fiscal_year),4);-- Bug 4066022 ,5081410
1062: FA_RX_UTIL_PKG.debug('Method Type Calculate..'||JG_RX_FAREG.var.rate_source_rule);
1063: FA_RX_UTIL_PKG.debug('deprn rate'||to_char(JG_RX_FAREG.var.deprn_rate));
1064: END IF;
1058: IF JG_RX_FAREG.var.rate_source_rule = 'CALCULATED' THEN
1059: X_life_in_years := JG_RX_FAREG.var.life_in_months / 12; -- Bug 4066022
1060: FA_RX_UTIL_PKG.debug('Life in years ='||to_char(X_life_in_years));
1061: JG_RX_FAREG.var.deprn_rate := round(1 / (X_life_in_years * X_number_per_fiscal_year),4);-- Bug 4066022 ,5081410
1062: FA_RX_UTIL_PKG.debug('Method Type Calculate..'||JG_RX_FAREG.var.rate_source_rule);
1063: FA_RX_UTIL_PKG.debug('deprn rate'||to_char(JG_RX_FAREG.var.deprn_rate));
1064: END IF;
1065: --Added this part for Formula Column for bug 2906455
1066: IF JG_RX_FAREG.var.rate_source_rule = 'FORMULA' THEN
1059: X_life_in_years := JG_RX_FAREG.var.life_in_months / 12; -- Bug 4066022
1060: FA_RX_UTIL_PKG.debug('Life in years ='||to_char(X_life_in_years));
1061: JG_RX_FAREG.var.deprn_rate := round(1 / (X_life_in_years * X_number_per_fiscal_year),4);-- Bug 4066022 ,5081410
1062: FA_RX_UTIL_PKG.debug('Method Type Calculate..'||JG_RX_FAREG.var.rate_source_rule);
1063: FA_RX_UTIL_PKG.debug('deprn rate'||to_char(JG_RX_FAREG.var.deprn_rate));
1064: END IF;
1065: --Added this part for Formula Column for bug 2906455
1066: IF JG_RX_FAREG.var.rate_source_rule = 'FORMULA' THEN
1067: X_life_in_years := JG_RX_FAREG.var.life_in_months / X_number_per_fiscal_year;
1064: END IF;
1065: --Added this part for Formula Column for bug 2906455
1066: IF JG_RX_FAREG.var.rate_source_rule = 'FORMULA' THEN
1067: X_life_in_years := JG_RX_FAREG.var.life_in_months / X_number_per_fiscal_year;
1068: FA_RX_UTIL_PKG.debug('Life in years ='||to_char(X_life_in_years));
1069: JG_RX_FAREG.var.deprn_rate := 1 / X_life_in_years;
1070: FA_RX_UTIL_PKG.debug('Method Type Formula is....'||JG_RX_FAREG.var.rate_source_rule);
1071: FA_RX_UTIL_PKG.debug('deprn rate'||to_char(JG_RX_FAREG.var.deprn_rate));
1072: END IF;
1066: IF JG_RX_FAREG.var.rate_source_rule = 'FORMULA' THEN
1067: X_life_in_years := JG_RX_FAREG.var.life_in_months / X_number_per_fiscal_year;
1068: FA_RX_UTIL_PKG.debug('Life in years ='||to_char(X_life_in_years));
1069: JG_RX_FAREG.var.deprn_rate := 1 / X_life_in_years;
1070: FA_RX_UTIL_PKG.debug('Method Type Formula is....'||JG_RX_FAREG.var.rate_source_rule);
1071: FA_RX_UTIL_PKG.debug('deprn rate'||to_char(JG_RX_FAREG.var.deprn_rate));
1072: END IF;
1073: --Changes finished for bug 2906455
1074: END IF;
1067: X_life_in_years := JG_RX_FAREG.var.life_in_months / X_number_per_fiscal_year;
1068: FA_RX_UTIL_PKG.debug('Life in years ='||to_char(X_life_in_years));
1069: JG_RX_FAREG.var.deprn_rate := 1 / X_life_in_years;
1070: FA_RX_UTIL_PKG.debug('Method Type Formula is....'||JG_RX_FAREG.var.rate_source_rule);
1071: FA_RX_UTIL_PKG.debug('deprn rate'||to_char(JG_RX_FAREG.var.deprn_rate));
1072: END IF;
1073: --Changes finished for bug 2906455
1074: END IF;
1075:
1083: from fa_methods
1084: where method_code = JG_RX_FAREG.var.deprn_method_code
1085: and nvl (life_in_months, -999) = nvl (JG_RX_FAREG.var.Life_In_Months, -999);
1086:
1087: FA_RX_UTIL_PKG.debug('Asset Id '||to_char(JG_RX_FAREG.var.asset_id));
1088: FA_RX_UTIL_PKG.debug('life in months'||to_char(JG_RX_FAREG.var.life_in_months));
1089: FA_RX_UTIL_PKG.debug('Fiscal Year '||to_char(JG_RX_FAREG.var.x_fiscal_year1));
1090: FA_RX_UTIL_PKG.debug('Short Fiscal Year'||JG_RX_FAREG.var.short_fiscal_year_flag);
1091: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1084: where method_code = JG_RX_FAREG.var.deprn_method_code
1085: and nvl (life_in_months, -999) = nvl (JG_RX_FAREG.var.Life_In_Months, -999);
1086:
1087: FA_RX_UTIL_PKG.debug('Asset Id '||to_char(JG_RX_FAREG.var.asset_id));
1088: FA_RX_UTIL_PKG.debug('life in months'||to_char(JG_RX_FAREG.var.life_in_months));
1089: FA_RX_UTIL_PKG.debug('Fiscal Year '||to_char(JG_RX_FAREG.var.x_fiscal_year1));
1090: FA_RX_UTIL_PKG.debug('Short Fiscal Year'||JG_RX_FAREG.var.short_fiscal_year_flag);
1091: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1092: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1085: and nvl (life_in_months, -999) = nvl (JG_RX_FAREG.var.Life_In_Months, -999);
1086:
1087: FA_RX_UTIL_PKG.debug('Asset Id '||to_char(JG_RX_FAREG.var.asset_id));
1088: FA_RX_UTIL_PKG.debug('life in months'||to_char(JG_RX_FAREG.var.life_in_months));
1089: FA_RX_UTIL_PKG.debug('Fiscal Year '||to_char(JG_RX_FAREG.var.x_fiscal_year1));
1090: FA_RX_UTIL_PKG.debug('Short Fiscal Year'||JG_RX_FAREG.var.short_fiscal_year_flag);
1091: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1092: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1093: FA_RX_UTIL_PKG.debug('Prorate DAte is..'||to_char(JG_RX_FAREG.var.prorate_Date, 'DD/MM/YYYY'));
1086:
1087: FA_RX_UTIL_PKG.debug('Asset Id '||to_char(JG_RX_FAREG.var.asset_id));
1088: FA_RX_UTIL_PKG.debug('life in months'||to_char(JG_RX_FAREG.var.life_in_months));
1089: FA_RX_UTIL_PKG.debug('Fiscal Year '||to_char(JG_RX_FAREG.var.x_fiscal_year1));
1090: FA_RX_UTIL_PKG.debug('Short Fiscal Year'||JG_RX_FAREG.var.short_fiscal_year_flag);
1091: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1092: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1093: FA_RX_UTIL_PKG.debug('Prorate DAte is..'||to_char(JG_RX_FAREG.var.prorate_Date, 'DD/MM/YYYY'));
1094: FA_RX_UTIL_PKG.debug('Conversion DAte is..'||to_char(JG_RX_FAREG.var.conversion_date, 'DD/MM/YYYY'));
1087: FA_RX_UTIL_PKG.debug('Asset Id '||to_char(JG_RX_FAREG.var.asset_id));
1088: FA_RX_UTIL_PKG.debug('life in months'||to_char(JG_RX_FAREG.var.life_in_months));
1089: FA_RX_UTIL_PKG.debug('Fiscal Year '||to_char(JG_RX_FAREG.var.x_fiscal_year1));
1090: FA_RX_UTIL_PKG.debug('Short Fiscal Year'||JG_RX_FAREG.var.short_fiscal_year_flag);
1091: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1092: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1093: FA_RX_UTIL_PKG.debug('Prorate DAte is..'||to_char(JG_RX_FAREG.var.prorate_Date, 'DD/MM/YYYY'));
1094: FA_RX_UTIL_PKG.debug('Conversion DAte is..'||to_char(JG_RX_FAREG.var.conversion_date, 'DD/MM/YYYY'));
1095: FA_RX_UTIL_PKG.debug('Orginal Deprn DAte is..'||to_char(JG_RX_FAREG.var.original_deprn_start_date, 'DD/MM/YYYY'));
1088: FA_RX_UTIL_PKG.debug('life in months'||to_char(JG_RX_FAREG.var.life_in_months));
1089: FA_RX_UTIL_PKG.debug('Fiscal Year '||to_char(JG_RX_FAREG.var.x_fiscal_year1));
1090: FA_RX_UTIL_PKG.debug('Short Fiscal Year'||JG_RX_FAREG.var.short_fiscal_year_flag);
1091: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1092: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1093: FA_RX_UTIL_PKG.debug('Prorate DAte is..'||to_char(JG_RX_FAREG.var.prorate_Date, 'DD/MM/YYYY'));
1094: FA_RX_UTIL_PKG.debug('Conversion DAte is..'||to_char(JG_RX_FAREG.var.conversion_date, 'DD/MM/YYYY'));
1095: FA_RX_UTIL_PKG.debug('Orginal Deprn DAte is..'||to_char(JG_RX_FAREG.var.original_deprn_start_date, 'DD/MM/YYYY'));
1096: FA_RX_UTIL_PKG.debug('deprn rate for Formula before is ..'||to_char(JG_RX_FAREG.var.deprn_rate));
1089: FA_RX_UTIL_PKG.debug('Fiscal Year '||to_char(JG_RX_FAREG.var.x_fiscal_year1));
1090: FA_RX_UTIL_PKG.debug('Short Fiscal Year'||JG_RX_FAREG.var.short_fiscal_year_flag);
1091: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1092: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1093: FA_RX_UTIL_PKG.debug('Prorate DAte is..'||to_char(JG_RX_FAREG.var.prorate_Date, 'DD/MM/YYYY'));
1094: FA_RX_UTIL_PKG.debug('Conversion DAte is..'||to_char(JG_RX_FAREG.var.conversion_date, 'DD/MM/YYYY'));
1095: FA_RX_UTIL_PKG.debug('Orginal Deprn DAte is..'||to_char(JG_RX_FAREG.var.original_deprn_start_date, 'DD/MM/YYYY'));
1096: FA_RX_UTIL_PKG.debug('deprn rate for Formula before is ..'||to_char(JG_RX_FAREG.var.deprn_rate));
1097:
1090: FA_RX_UTIL_PKG.debug('Short Fiscal Year'||JG_RX_FAREG.var.short_fiscal_year_flag);
1091: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1092: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1093: FA_RX_UTIL_PKG.debug('Prorate DAte is..'||to_char(JG_RX_FAREG.var.prorate_Date, 'DD/MM/YYYY'));
1094: FA_RX_UTIL_PKG.debug('Conversion DAte is..'||to_char(JG_RX_FAREG.var.conversion_date, 'DD/MM/YYYY'));
1095: FA_RX_UTIL_PKG.debug('Orginal Deprn DAte is..'||to_char(JG_RX_FAREG.var.original_deprn_start_date, 'DD/MM/YYYY'));
1096: FA_RX_UTIL_PKG.debug('deprn rate for Formula before is ..'||to_char(JG_RX_FAREG.var.deprn_rate));
1097:
1098: FA_CDE_PKG.faxgfr(X_Book_Type_Code => PARM.p_book_type_code,
1091: FA_RX_UTIL_PKG.debug('Method Code'||JG_RX_FAREG.var.deprn_method_code);
1092: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1093: FA_RX_UTIL_PKG.debug('Prorate DAte is..'||to_char(JG_RX_FAREG.var.prorate_Date, 'DD/MM/YYYY'));
1094: FA_RX_UTIL_PKG.debug('Conversion DAte is..'||to_char(JG_RX_FAREG.var.conversion_date, 'DD/MM/YYYY'));
1095: FA_RX_UTIL_PKG.debug('Orginal Deprn DAte is..'||to_char(JG_RX_FAREG.var.original_deprn_start_date, 'DD/MM/YYYY'));
1096: FA_RX_UTIL_PKG.debug('deprn rate for Formula before is ..'||to_char(JG_RX_FAREG.var.deprn_rate));
1097:
1098: FA_CDE_PKG.faxgfr(X_Book_Type_Code => PARM.p_book_type_code,
1099: X_Asset_Id => JG_RX_FAREG.var.asset_id,
1092: FA_RX_UTIL_PKG.debug('Current Period '||to_char(JG_RX_FAREG.var.begin_period_counter1));
1093: FA_RX_UTIL_PKG.debug('Prorate DAte is..'||to_char(JG_RX_FAREG.var.prorate_Date, 'DD/MM/YYYY'));
1094: FA_RX_UTIL_PKG.debug('Conversion DAte is..'||to_char(JG_RX_FAREG.var.conversion_date, 'DD/MM/YYYY'));
1095: FA_RX_UTIL_PKG.debug('Orginal Deprn DAte is..'||to_char(JG_RX_FAREG.var.original_deprn_start_date, 'DD/MM/YYYY'));
1096: FA_RX_UTIL_PKG.debug('deprn rate for Formula before is ..'||to_char(JG_RX_FAREG.var.deprn_rate));
1097:
1098: FA_CDE_PKG.faxgfr(X_Book_Type_Code => PARM.p_book_type_code,
1099: X_Asset_Id => JG_RX_FAREG.var.asset_id,
1100: X_Short_Fiscal_Year_Flag => JG_RX_FAREG.var.short_fiscal_year_flag,
1131: X_Success => success
1132: );
1133:
1134: JG_RX_FAREG.var.deprn_rate := X_rate1;
1135: FA_RX_UTIL_PKG.debug('deprn rate for Formula is ..'||to_char(JG_RX_FAREG.var.deprn_rate));
1136: FA_RX_UTIL_PKG.debug('Success Code for Formula is ..'||to_char(success));
1137:
1138: END IF;*/
1139: -- Amar added above part to fix bug 2906455.
1132: );
1133:
1134: JG_RX_FAREG.var.deprn_rate := X_rate1;
1135: FA_RX_UTIL_PKG.debug('deprn rate for Formula is ..'||to_char(JG_RX_FAREG.var.deprn_rate));
1136: FA_RX_UTIL_PKG.debug('Success Code for Formula is ..'||to_char(success));
1137:
1138: END IF;*/
1139: -- Amar added above part to fix bug 2906455.
1140: -- TABLE
1146: SELECT ROUND(JG_RX_FAREG.var.life_in_months/12)
1147: INTO X_life_of_asset
1148: FROM dual;
1149:
1150: FA_RX_UTIL_PKG.debug('Life of the asset= ' || to_char(x_life_of_asset));
1151: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
1152: FA_RX_UTIL_PKG.debug('start date = ' || JG_RX_FAREG.var.prorate_date);
1153: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JG_RX_FAREG.var.date_placed_in_service);
1154: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
1147: INTO X_life_of_asset
1148: FROM dual;
1149:
1150: FA_RX_UTIL_PKG.debug('Life of the asset= ' || to_char(x_life_of_asset));
1151: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
1152: FA_RX_UTIL_PKG.debug('start date = ' || JG_RX_FAREG.var.prorate_date);
1153: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JG_RX_FAREG.var.date_placed_in_service);
1154: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
1155: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JG_RX_FAREG.var.method_id));
1148: FROM dual;
1149:
1150: FA_RX_UTIL_PKG.debug('Life of the asset= ' || to_char(x_life_of_asset));
1151: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
1152: FA_RX_UTIL_PKG.debug('start date = ' || JG_RX_FAREG.var.prorate_date);
1153: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JG_RX_FAREG.var.date_placed_in_service);
1154: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
1155: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JG_RX_FAREG.var.method_id));
1156:
1149:
1150: FA_RX_UTIL_PKG.debug('Life of the asset= ' || to_char(x_life_of_asset));
1151: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
1152: FA_RX_UTIL_PKG.debug('start date = ' || JG_RX_FAREG.var.prorate_date);
1153: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JG_RX_FAREG.var.date_placed_in_service);
1154: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
1155: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JG_RX_FAREG.var.method_id));
1156:
1157: -- Fix for Bug #5384045. To find the correct rate, we need to use
1150: FA_RX_UTIL_PKG.debug('Life of the asset= ' || to_char(x_life_of_asset));
1151: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
1152: FA_RX_UTIL_PKG.debug('start date = ' || JG_RX_FAREG.var.prorate_date);
1153: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JG_RX_FAREG.var.date_placed_in_service);
1154: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
1155: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JG_RX_FAREG.var.method_id));
1156:
1157: -- Fix for Bug #5384045. To find the correct rate, we need to use
1158: -- the current year of the asset's life rather than the entire life
1151: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
1152: FA_RX_UTIL_PKG.debug('start date = ' || JG_RX_FAREG.var.prorate_date);
1153: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JG_RX_FAREG.var.date_placed_in_service);
1154: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
1155: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JG_RX_FAREG.var.method_id));
1156:
1157: -- Fix for Bug #5384045. To find the correct rate, we need to use
1158: -- the current year of the asset's life rather than the entire life
1159: -- of the asset (X_life_of_asset) when joining to fa_rates.
1201:
1202: JG_RX_FAREG.var.deprn_rate := JG_RX_FAREG.var.deprn_rate *100;
1203: END IF;
1204:
1205: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_rate =' || TO_CHAR(JG_RX_FAREG.var.deprn_rate));
1206:
1207: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_depreciation_rate()-');
1208:
1209: EXCEPTION
1203: END IF;
1204:
1205: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_rate =' || TO_CHAR(JG_RX_FAREG.var.deprn_rate));
1206:
1207: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_depreciation_rate()-');
1208:
1209: EXCEPTION
1210: WHEN NO_DATA_FOUND THEN
1211: X_msg := 'JG_RX_FAREG.Get_depreciation_rate: NO_DATA_FOUND';
1208:
1209: EXCEPTION
1210: WHEN NO_DATA_FOUND THEN
1211: X_msg := 'JG_RX_FAREG.Get_depreciation_rate: NO_DATA_FOUND';
1212: FA_RX_UTIL_PKG.debug(X_msg);
1213: RAISE_APPLICATION_ERROR(-20010,X_msg);
1214:
1215: WHEN TOO_MANY_ROWS THEN
1216: X_msg := 'JG_RX_FAREG.Get_depreciation_rate: TOO_MANY_ROWS';
1213: RAISE_APPLICATION_ERROR(-20010,X_msg);
1214:
1215: WHEN TOO_MANY_ROWS THEN
1216: X_msg := 'JG_RX_FAREG.Get_depreciation_rate: TOO_MANY_ROWS';
1217: FA_RX_UTIL_PKG.debug(X_msg);
1218: RAISE_APPLICATION_ERROR(-20010,X_msg);
1219:
1220: END Get_depreciation_rate;
1221:
1234: v_selectstmnt3 varchar2(10000);
1235: V_expense_account varchar2(100);
1236: v_dummy integer ;
1237: BEGIN
1238: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_Deprn_Account()+');
1239: JG_RX_FAREG.var.expense_account := NULL;
1240: v_cursorId := DBMS_SQL.OPEN_CURSOR;
1241: v_Selectstmnt1 :=
1242: 'select distinct '||X_account_segment||' from '||
1264: DBMS_SQL.COLUMN_VALUE(V_cursorId,1,V_expense_account);
1265: JG_RX_FAREG.var.expense_account:= JG_RX_FAREG.var.expense_account||V_expense_account;
1266: END LOOP;
1267: dbms_sql.close_cursor(v_cursorId);
1268: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.expense_account = ' || JG_RX_FAREG.var.expense_account);
1269: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_depr_account()-');
1270: END Get_deprn_accounts;
1271:
1272:
1265: JG_RX_FAREG.var.expense_account:= JG_RX_FAREG.var.expense_account||V_expense_account;
1266: END LOOP;
1267: dbms_sql.close_cursor(v_cursorId);
1268: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.expense_account = ' || JG_RX_FAREG.var.expense_account);
1269: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_depr_account()-');
1270: END Get_deprn_accounts;
1271:
1272:
1273:
1290: -- IT.book_type_code = PARM.p_book_type_code;
1291: IT.book_type_code = fabc.DISTRIBUTION_SOURCE_BOOK and
1292: fabc.book_type_code = PARM.p_book_type_code;
1293: BEGIN
1294: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_inv_number()+');
1295: JG_RX_FAREG.var.invoice_number := null;
1296: JG_RX_FAREG.var.supplier_name := null;
1297: FOR c_inv in c_invoice_supplier LOOP
1298: IF c_invoice_supplier%ROWCOUNT=0 then
1304: JG_RX_FAREG.var.invoice_number := JG_RX_FAREG.var.invoice_number||
1305: substr(c_inv.invoice_number,1,50-nvl(length(JG_RX_FAREG.var.invoice_number),0));
1306:
1307: END LOOP;
1308: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.invoice_number = ' || JG_RX_FAREG.var.invoice_number);
1309: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.supplier_name = ' || JG_RX_FAREG.var.supplier_name);
1310: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_inv_number()-');
1311: END Get_invoice_number;
1312:
1305: substr(c_inv.invoice_number,1,50-nvl(length(JG_RX_FAREG.var.invoice_number),0));
1306:
1307: END LOOP;
1308: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.invoice_number = ' || JG_RX_FAREG.var.invoice_number);
1309: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.supplier_name = ' || JG_RX_FAREG.var.supplier_name);
1310: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_inv_number()-');
1311: END Get_invoice_number;
1312:
1313:
1306:
1307: END LOOP;
1308: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.invoice_number = ' || JG_RX_FAREG.var.invoice_number);
1309: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.supplier_name = ' || JG_RX_FAREG.var.supplier_name);
1310: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_inv_number()-');
1311: END Get_invoice_number;
1312:
1313:
1314:
1322: X_msg VARCHAR2(100);
1323: X_parent_asset_number VARCHAR2(15);
1324:
1325: BEGIN
1326: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_parent_asset_number()+');
1327:
1328: SELECT asset_number
1329: INTO X_parent_asset_number
1330: FROM fa_additions
1329: INTO X_parent_asset_number
1330: FROM fa_additions
1331: WHERE asset_id = JG_RX_FAREG.var.parent_asset_id;
1332:
1333: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_parent_asset_number()-');
1334:
1335: RETURN X_parent_asset_number;
1336:
1337: EXCEPTION
1336:
1337: EXCEPTION
1338: WHEN NO_DATA_FOUND THEN
1339: X_msg := 'JG_RX_FAREG.Get_parent_asset_number: NO_DATA_FOUND';
1340: FA_RX_UTIL_PKG.debug(X_msg);
1341: RAISE_APPLICATION_ERROR(-20010,X_msg);
1342:
1343: END Get_parent_asset_number;
1344:
1351:
1352: X_msg VARCHAR2(100);
1353:
1354: BEGIN
1355: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Startup()+');
1356:
1357: -- It takes the segment condition
1358: X_where_clause_tmp := Get_category_segment;
1359:
1356:
1357: -- It takes the segment condition
1358: X_where_clause_tmp := Get_category_segment;
1359:
1360: FA_RX_UTIL_PKG.debug('Get Company name');
1361: -- Get Company name and store in placeholder variable
1362: SELECT company_name
1363: INTO JG_RX_FAREG.var.organization_name
1364: FROM fa_system_controls;
1363: INTO JG_RX_FAREG.var.organization_name
1364: FROM fa_system_controls;
1365:
1366:
1367: FA_RX_UTIL_PKG.debug('Get currency code');
1368: -- Get currency code and store in placeholder variable
1369: SELECT currency_code
1370: INTO JG_RX_FAREG.var.functional_currency_code
1371: FROM gl_sets_of_books
1370: INTO JG_RX_FAREG.var.functional_currency_code
1371: FROM gl_sets_of_books
1372: WHERE set_of_books_id = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
1373:
1374: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Startup()-');
1375:
1376: EXCEPTION
1377: WHEN NO_DATA_FOUND THEN
1378: X_msg := 'JG_RX_FAREG.Startup: NO_DATA_FOUND';
1375:
1376: EXCEPTION
1377: WHEN NO_DATA_FOUND THEN
1378: X_msg := 'JG_RX_FAREG.Startup: NO_DATA_FOUND';
1379: FA_RX_UTIL_PKG.debug(X_msg);
1380: RAISE_APPLICATION_ERROR(-20010,X_msg);
1381:
1382: WHEN TOO_MANY_ROWS THEN
1383: X_msg := 'JG_RX_FAREG.Startup: TOO_MANY_ROWS';
1380: RAISE_APPLICATION_ERROR(-20010,X_msg);
1381:
1382: WHEN TOO_MANY_ROWS THEN
1383: X_msg := 'JG_RX_FAREG.Startup: TOO_MANY_ROWS';
1384: FA_RX_UTIL_PKG.debug(X_msg);
1385: RAISE_APPLICATION_ERROR(-20010,X_msg);
1386:
1387: END Startup;
1388:
1396: X_msg VARCHAR2(100);
1397: X_capitalized NUMBER(10);
1398:
1399: BEGIN
1400: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_value()+');
1401:
1402: BEGIN
1403: FA_RX_UTIL_PKG.debug('Get cost initial value');
1404: -- Get initial value
1399: BEGIN
1400: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_value()+');
1401:
1402: BEGIN
1403: FA_RX_UTIL_PKG.debug('Get cost initial value');
1404: -- Get initial value
1405: SELECT count(*)
1406: INTO X_capitalized
1407: FROM fa_books BO
1428: AND BO1.asset_id = BO.asset_id
1429: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1430: AND TRH.transaction_date_entered < PARM.p_begin_period_from_date);
1431: END IF;
1432: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_initial =' || TO_CHAR(JG_RX_FAREG.var.asset_cost_initial));
1433:
1434: EXCEPTION
1435: WHEN NO_DATA_FOUND THEN
1436: JG_RX_FAREG.var.asset_cost_initial := 0;
1435: WHEN NO_DATA_FOUND THEN
1436: JG_RX_FAREG.var.asset_cost_initial := 0;
1437: END;
1438:
1439: FA_RX_UTIL_PKG.debug('Get cost final value');
1440: -- Get final value
1441: BEGIN
1442: SELECT cost,
1443: transaction_header_id_in
1453: WHERE BO1.book_type_code = BO.book_type_code
1454: AND BO1.asset_id = BO.asset_id
1455: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1456: AND TRH.transaction_date_entered <= PARM.p_end_period_to_date);
1457: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_final =' || TO_CHAR(JG_RX_FAREG.var.asset_cost_final));
1458: EXCEPTION
1459: WHEN NO_DATA_FOUND THEN
1460: JG_RX_FAREG.var.asset_cost_final := 0;
1461: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_final =' ||'no data found');
1457: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_final =' || TO_CHAR(JG_RX_FAREG.var.asset_cost_final));
1458: EXCEPTION
1459: WHEN NO_DATA_FOUND THEN
1460: JG_RX_FAREG.var.asset_cost_final := 0;
1461: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_final =' ||'no data found');
1462:
1463: END;
1464:
1465: -- It takes the asset cost increase
1469: Get_cost_decrease;
1470: -- 09/08/00 AFERRARA
1471: JG_RX_FAREG.var.asset_variation := JG_RX_FAREG.var.asset_cost_increase -
1472: JG_RX_FAREG.var.asset_cost_decrease;
1473: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_total(before) =' || JG_RX_FAREG.var.revaluation_total);
1474: JG_RX_FAREG.var.revaluation_total := JG_RX_FAREG.var.revaluation_final;
1475: -- JG_RX_FAREG.var.asset_cost_final -
1476: -- JG_RX_FAREG.var.asset_cost_orig;
1477: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_variation =' || JG_RX_FAREG.var.asset_variation);
1473: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_total(before) =' || JG_RX_FAREG.var.revaluation_total);
1474: JG_RX_FAREG.var.revaluation_total := JG_RX_FAREG.var.revaluation_final;
1475: -- JG_RX_FAREG.var.asset_cost_final -
1476: -- JG_RX_FAREG.var.asset_cost_orig;
1477: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_variation =' || JG_RX_FAREG.var.asset_variation);
1478: -- 09/08/00 AFERRARA
1479:
1480: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_value()-');
1481:
1476: -- JG_RX_FAREG.var.asset_cost_orig;
1477: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_variation =' || JG_RX_FAREG.var.asset_variation);
1478: -- 09/08/00 AFERRARA
1479:
1480: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_value()-');
1481:
1482: EXCEPTION
1483: WHEN NO_DATA_FOUND THEN
1484: X_msg := 'JG_RX_FAREG.Get_cost_value: NO_DATA_FOUND';
1481:
1482: EXCEPTION
1483: WHEN NO_DATA_FOUND THEN
1484: X_msg := 'JG_RX_FAREG.Get_cost_value: NO_DATA_FOUND';
1485: FA_RX_UTIL_PKG.debug(X_msg);
1486: RAISE_APPLICATION_ERROR(-20010,X_msg);
1487:
1488: WHEN TOO_MANY_ROWS THEN
1489: X_msg := 'JG_RX_FAREG.Get_cost_value: TOO_MANY_ROWS';
1486: RAISE_APPLICATION_ERROR(-20010,X_msg);
1487:
1488: WHEN TOO_MANY_ROWS THEN
1489: X_msg := 'JG_RX_FAREG.Get_cost_value: TOO_MANY_ROWS';
1490: FA_RX_UTIL_PKG.debug(X_msg);
1491: RAISE_APPLICATION_ERROR(-20010,X_msg);
1492:
1493: END Get_cost_value;
1494:
1504: X_revaluation_plus NUMBER := 0;
1505: X_reinstatements NUMBER := 0;
1506:
1507: BEGIN
1508: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_increase()+');
1509:
1510: -------------------------------------------------------------------------------
1511: FA_RX_UTIL_PKG.debug('Get partial addition ');
1512: fa_rx_util_pkg.debug('transaction id'||X_transaction_id_initial);
1507: BEGIN
1508: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_increase()+');
1509:
1510: -------------------------------------------------------------------------------
1511: FA_RX_UTIL_PKG.debug('Get partial addition ');
1512: fa_rx_util_pkg.debug('transaction id'||X_transaction_id_initial);
1513: fa_rx_util_pkg.debug('PARM.p_begin_period_to_date'||to_char(PARM.p_begin_period_to_date));
1514: fa_rx_util_pkg.debug('PARM.p_end_period_from_date'||to_char(PARM.p_end_period_from_date));
1515:
1508: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_increase()+');
1509:
1510: -------------------------------------------------------------------------------
1511: FA_RX_UTIL_PKG.debug('Get partial addition ');
1512: fa_rx_util_pkg.debug('transaction id'||X_transaction_id_initial);
1513: fa_rx_util_pkg.debug('PARM.p_begin_period_to_date'||to_char(PARM.p_begin_period_to_date));
1514: fa_rx_util_pkg.debug('PARM.p_end_period_from_date'||to_char(PARM.p_end_period_from_date));
1515:
1516: SELECT SUM(AD.adjustment_amount)
1509:
1510: -------------------------------------------------------------------------------
1511: FA_RX_UTIL_PKG.debug('Get partial addition ');
1512: fa_rx_util_pkg.debug('transaction id'||X_transaction_id_initial);
1513: fa_rx_util_pkg.debug('PARM.p_begin_period_to_date'||to_char(PARM.p_begin_period_to_date));
1514: fa_rx_util_pkg.debug('PARM.p_end_period_from_date'||to_char(PARM.p_end_period_from_date));
1515:
1516: SELECT SUM(AD.adjustment_amount)
1517: INTO X_partial_addition
1510: -------------------------------------------------------------------------------
1511: FA_RX_UTIL_PKG.debug('Get partial addition ');
1512: fa_rx_util_pkg.debug('transaction id'||X_transaction_id_initial);
1513: fa_rx_util_pkg.debug('PARM.p_begin_period_to_date'||to_char(PARM.p_begin_period_to_date));
1514: fa_rx_util_pkg.debug('PARM.p_end_period_from_date'||to_char(PARM.p_end_period_from_date));
1515:
1516: SELECT SUM(AD.adjustment_amount)
1517: INTO X_partial_addition
1518: FROM fa_books BO,
1535: AND TH.transaction_date_entered BETWEEN (PARM.p_begin_period_from_date)
1536: AND (PARM.p_end_period_to_date);
1537: -- changed bo.date_effective to TH.transaction_date_entered
1538:
1539: FA_RX_UTIL_PKG.debug('partial addition =' || TO_CHAR(X_partial_addition));
1540:
1541:
1542: -------------------------------------------------------------------------------
1543: FA_RX_UTIL_PKG.debug('Get manual adjustment upwards');
1539: FA_RX_UTIL_PKG.debug('partial addition =' || TO_CHAR(X_partial_addition));
1540:
1541:
1542: -------------------------------------------------------------------------------
1543: FA_RX_UTIL_PKG.debug('Get manual adjustment upwards');
1544:
1545: SELECT SUM(AD.adjustment_amount)
1546: INTO X_manual_adjustment_plus
1547: FROM fa_transaction_headers TH,
1556: AND AD.debit_credit_flag = 'DR'
1557: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1558: AND PARM.p_end_period_to_date;
1559:
1560: FA_RX_UTIL_PKG.debug('Get manual adjustment upwards =' || TO_CHAR(X_manual_adjustment_plus));
1561:
1562:
1563: -------------------------------------------------------------------------------
1564: FA_RX_UTIL_PKG.debug('Get revaluations upward ');
1560: FA_RX_UTIL_PKG.debug('Get manual adjustment upwards =' || TO_CHAR(X_manual_adjustment_plus));
1561:
1562:
1563: -------------------------------------------------------------------------------
1564: FA_RX_UTIL_PKG.debug('Get revaluations upward ');
1565:
1566: SELECT SUM(AD.adjustment_amount)
1567: INTO X_revaluation_plus
1568: FROM fa_transaction_headers TH,
1578: AND AD.adjustment_amount > 0
1579: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1580: AND PARM.p_end_period_to_date;
1581:
1582: FA_RX_UTIL_PKG.debug('Revaluations Upward =' || TO_CHAR(X_revaluation_plus));
1583:
1584:
1585: -------------------------------------------------------------------------------
1586: FA_RX_UTIL_PKG.debug('Get reinstatements ');
1582: FA_RX_UTIL_PKG.debug('Revaluations Upward =' || TO_CHAR(X_revaluation_plus));
1583:
1584:
1585: -------------------------------------------------------------------------------
1586: FA_RX_UTIL_PKG.debug('Get reinstatements ');
1587:
1588: SELECT SUM(RE.cost_retired)
1589: INTO X_reinstatements
1590: FROM fa_transaction_headers TH,
1597: AND TH.asset_id = JG_RX_FAREG.var.asset_id
1598: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1599: AND PARM.p_end_period_to_date;
1600: -- jmary changing date_retired to transaction_date
1601: FA_RX_UTIL_PKG.debug('Reinstatements =' || TO_CHAR(X_reinstatements));
1602:
1603:
1604:
1605: JG_RX_FAREG.var.asset_cost_increase := NVL(X_partial_addition,0) +
1606: NVL(X_manual_adjustment_plus,0) +
1607: NVL(X_revaluation_plus,0) +
1608: NVL(X_reinstatements,0);
1609:
1610: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_increase =' || JG_RX_FAREG.var.asset_cost_increase);
1611:
1612: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_increase()-');
1613:
1614:
1608: NVL(X_reinstatements,0);
1609:
1610: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_increase =' || JG_RX_FAREG.var.asset_cost_increase);
1611:
1612: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_increase()-');
1613:
1614:
1615: END Get_cost_increase;
1616:
1627: X_revaluation_minus NUMBER := 0;
1628: X_retirements NUMBER := 0;
1629:
1630: BEGIN
1631: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_decrease()+');
1632:
1633:
1634: -------------------------------------------------------------------------------
1635: FA_RX_UTIL_PKG.debug('Get credit memos ');
1631: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_decrease()+');
1632:
1633:
1634: -------------------------------------------------------------------------------
1635: FA_RX_UTIL_PKG.debug('Get credit memos ');
1636:
1637: SELECT SUM(AD.adjustment_amount)
1638: INTO X_credit_memos
1639: FROM fa_books BO,
1656: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1657: AND PARM.p_end_period_to_date;
1658: -- changed date_effective to transaction_date_entered
1659:
1660: FA_RX_UTIL_PKG.debug('credit memos =' || TO_CHAR(X_credit_memos));
1661:
1662:
1663: -------------------------------------------------------------------------------
1664: FA_RX_UTIL_PKG.debug('Get manual adjustment downwards');
1660: FA_RX_UTIL_PKG.debug('credit memos =' || TO_CHAR(X_credit_memos));
1661:
1662:
1663: -------------------------------------------------------------------------------
1664: FA_RX_UTIL_PKG.debug('Get manual adjustment downwards');
1665:
1666: SELECT SUM(AD.adjustment_amount)
1667: INTO X_manual_adjustment_minus
1668: FROM fa_transaction_headers TH,
1677: AND AD.debit_credit_flag = 'CR'
1678: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1679: AND PARM.p_end_period_to_date;
1680:
1681: FA_RX_UTIL_PKG.debug('Get manual adjustment downwards =' || TO_CHAR(X_manual_adjustment_minus));
1682:
1683:
1684: -------------------------------------------------------------------------------
1685: FA_RX_UTIL_PKG.debug('Get revaluations downward ');
1681: FA_RX_UTIL_PKG.debug('Get manual adjustment downwards =' || TO_CHAR(X_manual_adjustment_minus));
1682:
1683:
1684: -------------------------------------------------------------------------------
1685: FA_RX_UTIL_PKG.debug('Get revaluations downward ');
1686:
1687: SELECT SUM(AD.adjustment_amount)
1688: INTO X_revaluation_minus
1689: FROM fa_transaction_headers TH,
1698: AND AD.debit_credit_flag = 'CR'
1699: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1700: AND PARM.p_end_period_to_date;
1701:
1702: FA_RX_UTIL_PKG.debug('Revaluations downward =' || TO_CHAR(X_revaluation_minus));
1703:
1704:
1705: -------------------------------------------------------------------------------
1706: FA_RX_UTIL_PKG.debug('Get retirements ');
1702: FA_RX_UTIL_PKG.debug('Revaluations downward =' || TO_CHAR(X_revaluation_minus));
1703:
1704:
1705: -------------------------------------------------------------------------------
1706: FA_RX_UTIL_PKG.debug('Get retirements ');
1707:
1708: SELECT SUM(RE.cost_retired)
1709: INTO X_retirements
1710: FROM fa_transaction_headers TH,
1718: AND TH.asset_id = JG_RX_FAREG.var.asset_id
1719: AND RE.date_retired BETWEEN PARM.p_begin_period_from_date /* changed Transaction Date to Retirement Date */
1720: AND PARM.p_end_period_to_date;
1721:
1722: FA_RX_UTIL_PKG.debug('Retirements =' || TO_CHAR(X_retirements));
1723:
1724:
1725:
1726: JG_RX_FAREG.var.asset_cost_decrease := NVL(X_credit_memos,0) +
1727: NVL(X_manual_adjustment_minus,0) +
1728: NVL(X_revaluation_minus,0) +
1729: NVL(X_retirements,0);
1730:
1731: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_decrease =' || JG_RX_FAREG.var.asset_cost_decrease);
1732:
1733: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_decrease()-');
1734:
1735:
1729: NVL(X_retirements,0);
1730:
1731: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.asset_cost_decrease =' || JG_RX_FAREG.var.asset_cost_decrease);
1732:
1733: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_cost_decrease()-');
1734:
1735:
1736: END Get_cost_decrease;
1737:
1742: PROCEDURE Get_revaluation
1743: IS
1744:
1745: BEGIN
1746: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation()+');
1747:
1748: BEGIN
1749: FA_RX_UTIL_PKG.debug('Get_revaluation initial value');
1750: -- Get initial value
1745: BEGIN
1746: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation()+');
1747:
1748: BEGIN
1749: FA_RX_UTIL_PKG.debug('Get_revaluation initial value');
1750: -- Get initial value
1751: SELECT SUM(DECODE(debit_credit_flag, 'DR', adjustment_amount, 0)) -
1752: SUM(DECODE(debit_credit_flag, 'CR', adjustment_amount, 0))
1753: INTO JG_RX_FAREG.var.revaluation_initial
1761: IF JG_RX_FAREG.var.revaluation_initial IS NULL THEN
1762: JG_RX_FAREG.var.revaluation_initial := 0;
1763: END IF;
1764:
1765: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_initial =' || TO_CHAR(JG_RX_FAREG.var.revaluation_initial));
1766: END;
1767:
1768:
1769: BEGIN
1766: END;
1767:
1768:
1769: BEGIN
1770: FA_RX_UTIL_PKG.debug('Get_revaluation final value');
1771: -- Get final value
1772: SELECT SUM(DECODE(debit_credit_flag, 'DR', adjustment_amount, 0)) -
1773: SUM(DECODE(debit_credit_flag, 'CR', adjustment_amount, 0))
1774: INTO JG_RX_FAREG.var.revaluation_final
1783: JG_RX_FAREG.var.revaluation_final := 0;
1784: END IF;
1785:
1786:
1787: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_final =' || TO_CHAR(JG_RX_FAREG.var.revaluation_final));
1788: END;
1789:
1790: -- It takes the asset revaluation increase
1791: Get_revaluation_change;
1793: -- 09/08/00 AFERRARA
1794: JG_RX_FAREG.var.reval_variation := JG_RX_FAREG.var.revaluation_increase -
1795: JG_RX_FAREG.var.revaluation_decrease;
1796:
1797: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.reval_variation =' || JG_RX_FAREG.var.reval_variation);
1798: -- 09/08/00 AFERRARA
1799:
1800: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation()-');
1801:
1796:
1797: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.reval_variation =' || JG_RX_FAREG.var.reval_variation);
1798: -- 09/08/00 AFERRARA
1799:
1800: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation()-');
1801:
1802: END Get_revaluation;
1803:
1804: /*===================================================================+
1807: PROCEDURE Get_revaluation_change
1808: IS
1809:
1810: BEGIN
1811: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_change()+');
1812:
1813: SELECT SUM(DECODE(DEBIT_CREDIT_FLAG,'DR',AD.adjustment_amount,0)),
1814: SUM(DECODE(DEBIT_CREDIT_FLAG,'CR',AD.adjustment_amount,0))
1815: INTO JG_RX_FAREG.var.revaluation_increase,JG_RX_FAREG.var.revaluation_decrease
1826: IF JG_RX_FAREG.var.revaluation_decrease IS NULL THEN
1827: JG_RX_FAREG.var.revaluation_decrease := 0;
1828: END IF;
1829:
1830: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_increase =' || JG_RX_FAREG.var.revaluation_increase);
1831: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_decrease =' || JG_RX_FAREG.var.revaluation_decrease);
1832:
1833: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_change()-');
1834:
1827: JG_RX_FAREG.var.revaluation_decrease := 0;
1828: END IF;
1829:
1830: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_increase =' || JG_RX_FAREG.var.revaluation_increase);
1831: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_decrease =' || JG_RX_FAREG.var.revaluation_decrease);
1832:
1833: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_change()-');
1834:
1835:
1829:
1830: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_increase =' || JG_RX_FAREG.var.revaluation_increase);
1831: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.revaluation_decrease =' || JG_RX_FAREG.var.revaluation_decrease);
1832:
1833: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_change()-');
1834:
1835:
1836: END Get_revaluation_change;
1837:
1843:
1844: X_msg VARCHAR2(100);
1845:
1846: BEGIN
1847: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_value()+');
1848:
1849: -------------------------------------------------------------------------------
1850: BEGIN
1851: FA_RX_UTIL_PKG.debug('Get deprn reserve initial value');
1847: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_value()+');
1848:
1849: -------------------------------------------------------------------------------
1850: BEGIN
1851: FA_RX_UTIL_PKG.debug('Get deprn reserve initial value');
1852: -- Get initial value
1853:
1854: SELECT (NVL(deprn_reserve,0) - NVL(bonus_deprn_reserve,0))
1855: INTO JG_RX_FAREG.var.deprn_reserve_initial
1862: and asset_id= JG_RX_FAREG.var.asset_id
1863: and book_type_code = PARM.p_book_type_code );
1864:
1865:
1866: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_reserve_initial =' || TO_CHAR(JG_RX_FAREG.var.deprn_reserve_initial));
1867: EXCEPTION
1868: WHEN NO_DATA_FOUND THEN
1869: JG_RX_FAREG.var.deprn_reserve_initial := 0;
1870: END;
1871:
1872:
1873: -------------------------------------------------------------------------------
1874: BEGIN
1875: FA_RX_UTIL_PKG.debug('Get deprn reserve final value');
1876: -- Get final value
1877: SELECT (NVL(deprn_reserve,0) - NVL(bonus_deprn_reserve,0)),
1878: ytd_deprn
1879: INTO JG_RX_FAREG.var.deprn_reserve_final
1888: and asset_id= JG_RX_FAREG.var.asset_id
1889: and book_type_code = PARM.p_book_type_code );
1890:
1891:
1892: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_reserve_final =' || TO_CHAR(JG_RX_FAREG.var.deprn_reserve_final));
1893: --Added this part to fix bug 3240485
1894: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.ytd_deprn=' || TO_CHAR(JG_RX_FAREG.var.ytd_deprn));
1895: --Added the above part to fix bug 3240485
1896: EXCEPTION
1890:
1891:
1892: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_reserve_final =' || TO_CHAR(JG_RX_FAREG.var.deprn_reserve_final));
1893: --Added this part to fix bug 3240485
1894: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.ytd_deprn=' || TO_CHAR(JG_RX_FAREG.var.ytd_deprn));
1895: --Added the above part to fix bug 3240485
1896: EXCEPTION
1897: WHEN NO_DATA_FOUND THEN
1898: JG_RX_FAREG.var.deprn_reserve_final := 0;
1908: -- 09/08/00 AFERRARA
1909: JG_RX_FAREG.var.deprn_variation := JG_RX_FAREG.var.deprn_reserve_increase -
1910: JG_RX_FAREG.var.deprn_reserve_decrease;
1911:
1912: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_variation =' || JG_RX_FAREG.var.deprn_variation);
1913: -- 09/08/00 AFERRARA
1914:
1915:
1916: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_value()-');
1912: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_variation =' || JG_RX_FAREG.var.deprn_variation);
1913: -- 09/08/00 AFERRARA
1914:
1915:
1916: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_value()-');
1917:
1918: EXCEPTION
1919: WHEN TOO_MANY_ROWS THEN
1920: X_msg := 'JG_RX_FAREG.Get_deprn_reserve_value: TOO_MANY_ROWS';
1917:
1918: EXCEPTION
1919: WHEN TOO_MANY_ROWS THEN
1920: X_msg := 'JG_RX_FAREG.Get_deprn_reserve_value: TOO_MANY_ROWS';
1921: FA_RX_UTIL_PKG.debug(X_msg);
1922: RAISE_APPLICATION_ERROR(-20010,X_msg);
1923:
1924:
1925: END Get_deprn_reserve_value;
1937: X_tax_re_adjustment_plus NUMBER := 0;
1938: X_revaluation_cr NUMBER := 0;
1939:
1940: BEGIN
1941: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_increase()+');
1942:
1943: -------------------------------------------------------------------------------
1944: FA_RX_UTIL_PKG.debug('Get ordinary depreciation ');
1945:
1940: BEGIN
1941: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_increase()+');
1942:
1943: -------------------------------------------------------------------------------
1944: FA_RX_UTIL_PKG.debug('Get ordinary depreciation ');
1945:
1946: SELECT SUM((NVL(deprn_amount,0) - NVL(bonus_deprn_amount,0)))
1947: INTO X_ord_deprn
1948: FROM fa_deprn_summary
1950: AND asset_id = JG_RX_FAREG.var.asset_id
1951: AND period_counter BETWEEN PARM.p_begin_period_counter
1952: AND PARM.p_end_period_counter;
1953:
1954: FA_RX_UTIL_PKG.debug('Ordinary depreciation =' || TO_CHAR(X_ord_deprn));
1955:
1956:
1957: -------------------------------------------------------------------------------
1958: FA_RX_UTIL_PKG.debug('Get increase due to reinstatements and Revaluations ');
1954: FA_RX_UTIL_PKG.debug('Ordinary depreciation =' || TO_CHAR(X_ord_deprn));
1955:
1956:
1957: -------------------------------------------------------------------------------
1958: FA_RX_UTIL_PKG.debug('Get increase due to reinstatements and Revaluations ');
1959:
1960: SELECT nvl(abs(SUM(DECODE(adjustment_type,'RESERVE',adjustment_amount,0)) -
1961: SUM(DECODE(adjustment_type,'BONUS RESERVE',adjustment_amount,0))),0)
1962: INTO X_revaluation_cr
1987:
1988: X_reinstatements := X_reinstatements+X_revaluation_cr;
1989:
1990:
1991: FA_RX_UTIL_PKG.debug('Reinstatements =' || TO_CHAR(X_reinstatements));
1992:
1993: -------------------------------------------------------------------------------
1994: FA_RX_UTIL_PKG.debug('Get positive tax reserve adjustment ');
1995:
1990:
1991: FA_RX_UTIL_PKG.debug('Reinstatements =' || TO_CHAR(X_reinstatements));
1992:
1993: -------------------------------------------------------------------------------
1994: FA_RX_UTIL_PKG.debug('Get positive tax reserve adjustment ');
1995:
1996: SELECT SUM(adjustment_amount)
1997: INTO X_tax_re_adjustment_plus
1998: FROM fa_adjustments AD
2003: AND AD.asset_id = JG_RX_FAREG.var.asset_id
2004: AND AD.period_counter_created BETWEEN PARM.p_begin_period_counter
2005: AND PARM.p_end_period_counter;
2006: -- changed period_counter_adjusted to period_counter_created
2007: FA_RX_UTIL_PKG.debug('Positive tax reserve adjustment =' || TO_CHAR(X_tax_re_adjustment_plus));
2008:
2009:
2010: JG_RX_FAREG.var.deprn_reserve_increase := NVL(X_ord_deprn,0) +
2011: NVL(X_reinstatements,0) +
2010: JG_RX_FAREG.var.deprn_reserve_increase := NVL(X_ord_deprn,0) +
2011: NVL(X_reinstatements,0) +
2012: NVL(X_tax_re_adjustment_plus,0);
2013:
2014: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_reserve_increase =' || JG_RX_FAREG.var.deprn_reserve_increase);
2015:
2016:
2017: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_increase()-');
2018:
2013:
2014: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_reserve_increase =' || JG_RX_FAREG.var.deprn_reserve_increase);
2015:
2016:
2017: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_increase()-');
2018:
2019:
2020: END Get_deprn_reserve_increase;
2021:
2031: X_tax_re_adjustment_minus NUMBER := 0;
2032: X_revaluation_dr NUMBER := 0;
2033:
2034: BEGIN
2035: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_decrease()+');
2036:
2037:
2038: -------------------------------------------------------------------------------
2039: FA_RX_UTIL_PKG.debug('Get deprn reserve decrease due to retirements and revaluations');
2035: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_decrease()+');
2036:
2037:
2038: -------------------------------------------------------------------------------
2039: FA_RX_UTIL_PKG.debug('Get deprn reserve decrease due to retirements and revaluations');
2040:
2041: SELECT nvl(abs(SUM(DECODE(adjustment_type,'RESERVE',adjustment_amount,0)) -
2042: SUM(DECODE(adjustment_type,'BONUS RESERVE',adjustment_amount,0))),0)
2043: INTO X_revaluation_dr
2066: AND PARM.p_end_period_counter;
2067:
2068: X_retirements := X_retirements+X_revaluation_dr;
2069:
2070: FA_RX_UTIL_PKG.debug('Retirements =' || TO_CHAR(X_retirements));
2071:
2072:
2073:
2074: -------------------------------------------------------------------------------
2071:
2072:
2073:
2074: -------------------------------------------------------------------------------
2075: FA_RX_UTIL_PKG.debug('Get negative financial adjustment ');
2076:
2077: SELECT abs(SUM(DECODE(adjustment_type,'EXPENSE',adjustment_amount,0)) -
2078: SUM(DECODE(adjustment_type,'BONUS EXPENSE',adjustment_amount,0)))
2079: INTO X_financ_adjustment_minus
2084: AND AD.asset_id = JG_RX_FAREG.var.asset_id
2085: AND AD.period_counter_adjusted BETWEEN PARM.p_begin_period_counter
2086: AND PARM.p_end_period_counter;
2087:
2088: FA_RX_UTIL_PKG.debug('Negative financial adjustment =' || TO_CHAR(X_financ_adjustment_minus));
2089:
2090: JG_RX_FAREG.var.deprn_reserve_increase := JG_RX_FAREG.var.deprn_reserve_increase +nvl(X_financ_adjustment_minus,0);
2091:
2092: /* to show the increase and then minus it */
2091:
2092: /* to show the increase and then minus it */
2093:
2094: -------------------------------------------------------------------------------
2095: FA_RX_UTIL_PKG.debug('Get negative tax reserve adjustment ');
2096:
2097: SELECT SUM(adjustment_amount)
2098: INTO X_tax_re_adjustment_minus
2099: FROM fa_adjustments AD
2104: AND AD.asset_id = JG_RX_FAREG.var.asset_id
2105: AND AD.period_counter_created BETWEEN PARM.p_begin_period_counter
2106: AND PARM.p_end_period_counter;
2107: -- jmary changed period_counter_adjusted to period_counter_created
2108: FA_RX_UTIL_PKG.debug('Negative tax reserve adjustment =' || TO_CHAR(X_tax_re_adjustment_minus));
2109:
2110:
2111: JG_RX_FAREG.var.deprn_reserve_decrease := NVL(X_retirements,0) +
2112: NVL(X_financ_adjustment_minus,0) +
2111: JG_RX_FAREG.var.deprn_reserve_decrease := NVL(X_retirements,0) +
2112: NVL(X_financ_adjustment_minus,0) +
2113: NVL(X_tax_re_adjustment_minus,0);
2114:
2115: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_reserve_decrease =' || JG_RX_FAREG.var.deprn_reserve_decrease);
2116:
2117:
2118: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_decrease()-');
2119:
2114:
2115: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.deprn_reserve_decrease =' || JG_RX_FAREG.var.deprn_reserve_decrease);
2116:
2117:
2118: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_deprn_reserve_decrease()-');
2119:
2120:
2121: END Get_deprn_reserve_decrease;
2122:
2130:
2131: X_msg VARCHAR2(100);
2132:
2133: BEGIN
2134: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_value()+');
2135:
2136: -------------------------------------------------------------------------------
2137: BEGIN
2138: FA_RX_UTIL_PKG.debug('Get bonus reserve initial value');
2134: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_value()+');
2135:
2136: -------------------------------------------------------------------------------
2137: BEGIN
2138: FA_RX_UTIL_PKG.debug('Get bonus reserve initial value');
2139: -- Get initial value
2140:
2141: SELECT NVL(bonus_deprn_reserve,0)
2142: INTO JG_RX_FAREG.var.bonus_reserve_initial
2150: AND asset_id= JG_RX_FAREG.var.asset_id
2151: AND book_type_code = PARM.p_book_type_code );
2152:
2153:
2154: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.bonus_reserve_initial =' || TO_CHAR(JG_RX_FAREG.var.bonus_reserve_initial));
2155: EXCEPTION
2156: WHEN NO_DATA_FOUND THEN
2157: JG_RX_FAREG.var.bonus_reserve_initial := 0;
2158: END;
2159:
2160:
2161: -------------------------------------------------------------------------------
2162: BEGIN
2163: FA_RX_UTIL_PKG.debug('Get bonus reserve final value');
2164: -- Get final value
2165: SELECT NVL(bonus_deprn_reserve,0)
2166: INTO JG_RX_FAREG.var.bonus_reserve_final
2167: FROM fa_deprn_summary
2174: AND asset_id= JG_RX_FAREG.var.asset_id
2175: AND book_type_code = PARM.p_book_type_code );
2176:
2177:
2178: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.bonus_reserve_final =' || TO_CHAR(JG_RX_FAREG.var.bonus_reserve_final));
2179: EXCEPTION
2180: WHEN NO_DATA_FOUND THEN
2181: JG_RX_FAREG.var.bonus_reserve_final := 0;
2182: END;
2190: -- 09/08/00 AFERRARA
2191: JG_RX_FAREG.var.bonus_variation := JG_RX_FAREG.var.bonus_reserve_increase -
2192: JG_RX_FAREG.var.bonus_reserve_decrease;
2193:
2194: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.bonus_variation =' || JG_RX_FAREG.var.bonus_variation);
2195: -- 09/08/00 AFERRARA
2196:
2197:
2198:
2195: -- 09/08/00 AFERRARA
2196:
2197:
2198:
2199: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_value()-');
2200:
2201: EXCEPTION
2202: WHEN TOO_MANY_ROWS THEN
2203: X_msg := 'JG_RX_FAREG.Get_bonus_reserve_value: TOO_MANY_ROWS';
2200:
2201: EXCEPTION
2202: WHEN TOO_MANY_ROWS THEN
2203: X_msg := 'JG_RX_FAREG.Get_bonus_reserve_value: TOO_MANY_ROWS';
2204: FA_RX_UTIL_PKG.debug(X_msg);
2205: RAISE_APPLICATION_ERROR(-20010,X_msg);
2206:
2207:
2208: END Get_bonus_reserve_value;
2220: X_financ_adjustment_plus NUMBER := 0;
2221: X_tax_re_adjustment_plus NUMBER := 0;
2222:
2223: BEGIN
2224: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_increase()+');
2225:
2226: -------------------------------------------------------------------------------
2227: FA_RX_UTIL_PKG.debug('Get bonus depreciation ');
2228:
2223: BEGIN
2224: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_increase()+');
2225:
2226: -------------------------------------------------------------------------------
2227: FA_RX_UTIL_PKG.debug('Get bonus depreciation ');
2228:
2229: SELECT sum(bonus_deprn_amount)
2230: INTO X_bonus_deprn
2231: FROM fa_deprn_summary
2233: AND asset_id = JG_RX_FAREG.var.asset_id
2234: AND period_counter BETWEEN PARM.p_begin_period_counter
2235: AND PARM.p_end_period_counter;
2236:
2237: FA_RX_UTIL_PKG.debug('Bonus depreciation =' || TO_CHAR(X_bonus_deprn));
2238:
2239:
2240: -------------------------------------------------------------------------------
2241: FA_RX_UTIL_PKG.debug('Get reinstatements ');
2237: FA_RX_UTIL_PKG.debug('Bonus depreciation =' || TO_CHAR(X_bonus_deprn));
2238:
2239:
2240: -------------------------------------------------------------------------------
2241: FA_RX_UTIL_PKG.debug('Get reinstatements ');
2242:
2243: SELECT SUM(adjustment_amount)
2244: INTO X_reinstatements
2245: FROM fa_adjustments AD
2249: AND AD.adjustment_type = 'BONUS RESERVE'
2250: AND AD.debit_credit_flag = 'CR'
2251: AND AD.period_counter_adjusted BETWEEN PARM.p_begin_period_counter
2252: AND PARM.p_end_period_counter;
2253: FA_RX_UTIL_PKG.debug('Reinstatements =' || TO_CHAR(X_reinstatements));
2254:
2255:
2256: JG_RX_FAREG.var.bonus_reserve_increase := NVL(X_bonus_deprn,0) +
2257: NVL(X_reinstatements,0) ;
2255:
2256: JG_RX_FAREG.var.bonus_reserve_increase := NVL(X_bonus_deprn,0) +
2257: NVL(X_reinstatements,0) ;
2258:
2259: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.bonus_reserve_increase =' || JG_RX_FAREG.var.bonus_reserve_increase);
2260:
2261:
2262: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_increase()-');
2263:
2258:
2259: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.bonus_reserve_increase =' || JG_RX_FAREG.var.bonus_reserve_increase);
2260:
2261:
2262: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_increase()-');
2263:
2264:
2265: END Get_bonus_reserve_increase;
2266:
2274: X_retirements NUMBER := 0;
2275: X_financ_adjustment_minus NUMBER := 0;
2276:
2277: BEGIN
2278: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_decrease()+');
2279:
2280:
2281: -------------------------------------------------------------------------------
2282: FA_RX_UTIL_PKG.debug('Get retirements and revaluations ');
2278: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_decrease()+');
2279:
2280:
2281: -------------------------------------------------------------------------------
2282: FA_RX_UTIL_PKG.debug('Get retirements and revaluations ');
2283: SELECT ABS(SUM(adjustment_amount))
2284: INTO X_retirements
2285: FROM fa_adjustments AD
2286: WHERE AD.source_type_code in ('RETIREMENT','REVALUATION')
2291: AND AD.period_counter_adjusted BETWEEN PARM.p_begin_period_counter
2292: AND PARM.p_end_period_counter;
2293:
2294:
2295: FA_RX_UTIL_PKG.debug('Retirements =' || TO_CHAR(X_retirements));
2296:
2297:
2298:
2299: -------------------------------------------------------------------------------
2296:
2297:
2298:
2299: -------------------------------------------------------------------------------
2300: FA_RX_UTIL_PKG.debug('Get Negative financial adjustment ');
2301: SELECT ABS(SUM(adjustment_amount))
2302: INTO X_financ_adjustment_minus
2303: FROM fa_adjustments AD
2304: WHERE AD.source_type_code = 'DEPRECIATION'
2309: AND AD.period_counter_adjusted BETWEEN PARM.p_begin_period_counter
2310: AND PARM.p_end_period_counter;
2311: JG_RX_FAREG.var.bonus_reserve_increase := JG_RX_FAREG.var.bonus_reserve_increase +nvl(X_financ_adjustment_minus,0);
2312:
2313: FA_RX_UTIL_PKG.debug('Negative financial adjustment =' || TO_CHAR(X_financ_adjustment_minus));
2314:
2315:
2316: JG_RX_FAREG.var.bonus_reserve_decrease := NVL(X_retirements,0) +
2317: NVL(X_financ_adjustment_minus,0);
2315:
2316: JG_RX_FAREG.var.bonus_reserve_decrease := NVL(X_retirements,0) +
2317: NVL(X_financ_adjustment_minus,0);
2318:
2319: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.bonus_reserve_decrease =' || JG_RX_FAREG.var.bonus_reserve_decrease);
2320:
2321:
2322: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_decrease()-');
2323:
2318:
2319: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.bonus_reserve_decrease =' || JG_RX_FAREG.var.bonus_reserve_decrease);
2320:
2321:
2322: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_reserve_decrease()-');
2323:
2324:
2325: END Get_bonus_reserve_decrease;
2326:
2333:
2334: X_msg VARCHAR2(100);
2335:
2336: BEGIN
2337: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_fiscal_year_date()+');
2338:
2339: SELECT start_date,
2340: end_date,
2341: deprn_calendar,
2350: AND FY.fiscal_year_name = BC.fiscal_year_name
2351: AND BC.book_type_code = PARM.p_book_type_code;
2352:
2353:
2354: FA_RX_UTIL_PKG.debug('X_fiscal_year_start_date =' || TO_CHAR(X_fiscal_year_start_date));
2355: FA_RX_UTIL_PKG.debug('X_fiscal_year_end_date =' || TO_CHAR(X_fiscal_year_end_date));
2356:
2357:
2358: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_fiscal_year_date()-');
2351: AND BC.book_type_code = PARM.p_book_type_code;
2352:
2353:
2354: FA_RX_UTIL_PKG.debug('X_fiscal_year_start_date =' || TO_CHAR(X_fiscal_year_start_date));
2355: FA_RX_UTIL_PKG.debug('X_fiscal_year_end_date =' || TO_CHAR(X_fiscal_year_end_date));
2356:
2357:
2358: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_fiscal_year_date()-');
2359:
2354: FA_RX_UTIL_PKG.debug('X_fiscal_year_start_date =' || TO_CHAR(X_fiscal_year_start_date));
2355: FA_RX_UTIL_PKG.debug('X_fiscal_year_end_date =' || TO_CHAR(X_fiscal_year_end_date));
2356:
2357:
2358: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_fiscal_year_date()-');
2359:
2360: -- Added for ECE Project
2361: BEGIN
2362: SELECT number_per_fiscal_year
2370:
2371: EXCEPTION
2372: WHEN NO_DATA_FOUND THEN
2373: X_msg := 'JG_RX_FAREG.Get_fiscal_year_date: NO_DATA_FOUND';
2374: FA_RX_UTIL_PKG.debug(X_msg);
2375: RAISE_APPLICATION_ERROR(-20010,X_msg);
2376:
2377: WHEN TOO_MANY_ROWS THEN
2378: X_msg := 'JG_RX_FAREG.Get_fiscal_year_date: TOO_MANY_ROWS';
2375: RAISE_APPLICATION_ERROR(-20010,X_msg);
2376:
2377: WHEN TOO_MANY_ROWS THEN
2378: X_msg := 'JG_RX_FAREG.Get_fiscal_year_date: TOO_MANY_ROWS';
2379: FA_RX_UTIL_PKG.debug(X_msg);
2380: RAISE_APPLICATION_ERROR(-20010,X_msg);
2381:
2382: END Get_fiscal_year_date;
2383:
2391: X_year NUMBER;
2392: X_starting_depreciation_year NUMBER(4);
2393:
2394: BEGIN
2395: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_rate()+');
2396:
2397: JG_RX_FAREG.var.bonus_rate := 0; -- To print 0 instead of NULL
2398:
2399: IF JG_RX_FAREG.var.bonus_rule IS NOT NULL THEN
2396:
2397: JG_RX_FAREG.var.bonus_rate := 0; -- To print 0 instead of NULL
2398:
2399: IF JG_RX_FAREG.var.bonus_rule IS NOT NULL THEN
2400: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_bonus_rate: JG_RX_FAREG.var.bonus_rule IS NOT NULL');
2401:
2402: X_starting_depreciation_year := Get_starting_depreciation_year;
2403:
2404: X_year := TO_NUMBER(X_fiscal_year) - X_starting_depreciation_year + 1;
2427:
2428: X_msg VARCHAR2(100);
2429:
2430: BEGIN
2431: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_transactions()+');
2432:
2433: Get_addition_transactions;
2434:
2435: Get_adjustment_transactions;
2437: Get_retirement_transactions;
2438:
2439: Get_revaluation_transactions;
2440:
2441: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_transactions()-');
2442:
2443: END Get_transactions;
2444:
2445:
2465: AND TH.transaction_date_entered BETWEEN X_fiscal_year_start_date
2466: AND PARM.p_end_period_to_date;
2467: -- changing X_fiscal_year_end_date to PARM.p_end_period_to_date
2468: BEGIN
2469: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_addition_transactions()+');
2470: FOR c_addition IN c_additon_trans LOOP
2471: IF (X_first_row = FALSE and c_additon_trans%ROWCOUNT=0) then
2472: exit ;
2473: end if;
2484: p_transaction_amount => c_addition.cost);
2485: END IF;
2486:
2487: END LOOP;
2488: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_addition_transactions()-');
2489:
2490: END Get_addition_transactions;
2491:
2492:
2516:
2517: -- changing X_fiscal_year_end_date to PARM.p_end_period_to_date
2518:
2519: BEGIN
2520: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_adjustment_transactions()+');
2521: FOR c_adjustment IN c_adjustment_trans LOOP
2522: IF (X_first_row = FALSE and c_adjustment_trans%ROWCOUNT=0) then
2523: exit ;
2524: end if;
2536: END IF;
2537:
2538: END LOOP;
2539:
2540: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_adjustment_transactions()-');
2541:
2542: END Get_adjustment_transactions;
2543:
2544:
2568:
2569: -- changing X_fiscal_year_end_date to PARM.p_end_period_to_date
2570:
2571: BEGIN
2572: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_retirement_transactions()+');
2573:
2574: FOR c_retirement IN c_retirement_trans LOOP
2575: IF (X_first_row = FALSE and c_retirement_trans%ROWCOUNT=0) then
2576: exit ;
2589: END IF;
2590:
2591: END LOOP;
2592:
2593: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_retirement_transactions()-');
2594:
2595: END Get_retirement_transactions;
2596:
2597: /*===================================================================+
2623:
2624: -- changing X_fiscal_year_end_date to PARM.p_end_period_to_date
2625:
2626: BEGIN
2627: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_transactions()+');
2628: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_transactions()+');
2629: FOR c_revaluation IN c_revaluation_trans LOOP
2630: IF X_first_row = FALSE THEN -- It is the first time...
2631: JG_RX_FAREG.var.transaction_date := c_revaluation.transaction_date_entered;
2624: -- changing X_fiscal_year_end_date to PARM.p_end_period_to_date
2625:
2626: BEGIN
2627: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_transactions()+');
2628: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_transactions()+');
2629: FOR c_revaluation IN c_revaluation_trans LOOP
2630: IF X_first_row = FALSE THEN -- It is the first time...
2631: JG_RX_FAREG.var.transaction_date := c_revaluation.transaction_date_entered;
2632: JG_RX_FAREG.var.transaction_number := c_revaluation.transaction_header_id;
2633: JG_RX_FAREG.var.transaction_code := c_revaluation.transaction_type_code;
2634: JG_RX_FAREG.var.transaction_amount := c_revaluation.adjustment_amount;
2635: X_first_row := TRUE;
2636: ELSE -- The current row is alredy used
2637: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.rowcount'||to_char(c_revaluation_trans%ROWCOUNT));
2638: Insert_transaction(p_transaction_date => c_revaluation.transaction_date_entered,
2639: p_transaction_number => c_revaluation.transaction_header_id,
2640: p_transaction_code => c_revaluation.transaction_type_code,
2641: p_transaction_amount => c_revaluation.adjustment_amount);
2642: END IF;
2643:
2644: END LOOP;
2645:
2646: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_revaluation_transactions()-');
2647:
2648: END Get_revaluation_transactions;
2649:
2650:
2657: p_transaction_amount NUMBER)
2658: IS
2659:
2660: BEGIN
2661: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Insert_transaction()+');
2662:
2663: INSERT INTO jg_zz_fa_reg_itf(
2664: request_id,
2665: organization_name,
2821: -- Added above to fix bug 3240485
2822: );
2823:
2824:
2825: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Insert_transaction()-');
2826:
2827: END Insert_transaction;
2828:
2829:
2833: PROCEDURE Get_Net_Book_Value
2834: IS
2835:
2836: BEGIN
2837: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_Net_Book_Value()+');
2838:
2839: JG_RX_FAREG.var.net_book_value_initial := NVL(JG_RX_FAREG.var.asset_cost_initial,0) -
2840: NVL(JG_RX_FAREG.var.deprn_reserve_initial,0) -
2841: NVL(JG_RX_FAREG.var.bonus_reserve_initial,0) ;
2853: -- + 09/08/00 AFERRARA
2854: JG_RX_FAREG.var.netbo_variation := JG_RX_FAREG.var.net_book_value_increase -
2855: JG_RX_FAREG.var.net_book_value_decrease;
2856:
2857: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.var.netbo_variation =' || JG_RX_FAREG.var.netbo_variation);
2858: -- - 09/08/00 AFERRARA
2859:
2860: JG_RX_FAREG.var.net_book_value_final := NVL(JG_RX_FAREG.var.asset_cost_final,0) -
2861: NVL(JG_RX_FAREG.var.deprn_reserve_final,0) -
2860: JG_RX_FAREG.var.net_book_value_final := NVL(JG_RX_FAREG.var.asset_cost_final,0) -
2861: NVL(JG_RX_FAREG.var.deprn_reserve_final,0) -
2862: NVL(JG_RX_FAREG.var.bonus_reserve_final,0) ;
2863:
2864: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_Net_Book_Value()-');
2865:
2866: END Get_Net_Book_Value;
2867:
2868: