eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JGRX_FAREG dependencies on FA_RX_UTIL_PKG

Line 78: FA_RX_UTIL_PKG.debug(X_calling_proc || '()+');

74: X_bind := 'JGRX_FAREG.fa_' || p_type || '_bind' || '(:CURSOR_SELECT);';
75: X_after_fetch := 'JGRX_FAREG.fa_' || p_type || '_after_fetch'|| ';';
76: X_after_report := 'JGRX_FAREG.fa_' || p_type || '_after_report'|| ';';
77:
78: FA_RX_UTIL_PKG.debug(X_calling_proc || '()+');
79:
80: FA_RX_UTIL_PKG.init_request(X_calling_proc, request_id);
81:
82: -- Store the parameters in a variable which can be accesed globally accross all procedures

Line 80: FA_RX_UTIL_PKG.init_request(X_calling_proc, request_id);

76: X_after_report := 'JGRX_FAREG.fa_' || p_type || '_after_report'|| ';';
77:
78: FA_RX_UTIL_PKG.debug(X_calling_proc || '()+');
79:
80: FA_RX_UTIL_PKG.init_request(X_calling_proc, request_id);
81:
82: -- Store the parameters in a variable which can be accesed globally accross all procedures
83: PARM.p_book_type_code := p_book_type_code;
84: PARM.p_period_from := p_period_from;

Line 109: FA_RX_UTIL_PKG.debug('FA_RX_UTIL_PKG.assign_report(' || X_section_name);

105: -- Call the core report.This executes the core report and the SELECT statement of the core
106: -- is built.
107: -- No data is inserted into the interface table.
108:
109: FA_RX_UTIL_PKG.debug('FA_RX_UTIL_PKG.assign_report(' || X_section_name);
110: FA_RX_UTIL_PKG.debug(' TRUE');
111: FA_RX_UTIL_PKG.debug(' ' || X_before_report);
112: FA_RX_UTIL_PKG.debug(' ' || X_bind);
113: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);

Line 110: FA_RX_UTIL_PKG.debug(' TRUE');

106: -- is built.
107: -- No data is inserted into the interface table.
108:
109: FA_RX_UTIL_PKG.debug('FA_RX_UTIL_PKG.assign_report(' || X_section_name);
110: FA_RX_UTIL_PKG.debug(' TRUE');
111: FA_RX_UTIL_PKG.debug(' ' || X_before_report);
112: FA_RX_UTIL_PKG.debug(' ' || X_bind);
113: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);
114: FA_RX_UTIL_PKG.debug(' ' || X_after_report);

Line 111: FA_RX_UTIL_PKG.debug(' ' || X_before_report);

107: -- No data is inserted into the interface table.
108:
109: FA_RX_UTIL_PKG.debug('FA_RX_UTIL_PKG.assign_report(' || X_section_name);
110: FA_RX_UTIL_PKG.debug(' TRUE');
111: FA_RX_UTIL_PKG.debug(' ' || X_before_report);
112: FA_RX_UTIL_PKG.debug(' ' || X_bind);
113: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);
114: FA_RX_UTIL_PKG.debug(' ' || X_after_report);
115: FA_RX_UTIL_PKG.debug(' )');

Line 112: FA_RX_UTIL_PKG.debug(' ' || X_bind);

108:
109: FA_RX_UTIL_PKG.debug('FA_RX_UTIL_PKG.assign_report(' || X_section_name);
110: FA_RX_UTIL_PKG.debug(' TRUE');
111: FA_RX_UTIL_PKG.debug(' ' || X_before_report);
112: FA_RX_UTIL_PKG.debug(' ' || X_bind);
113: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);
114: FA_RX_UTIL_PKG.debug(' ' || X_after_report);
115: FA_RX_UTIL_PKG.debug(' )');
116:

Line 113: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);

109: FA_RX_UTIL_PKG.debug('FA_RX_UTIL_PKG.assign_report(' || X_section_name);
110: FA_RX_UTIL_PKG.debug(' TRUE');
111: FA_RX_UTIL_PKG.debug(' ' || X_before_report);
112: FA_RX_UTIL_PKG.debug(' ' || X_bind);
113: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);
114: FA_RX_UTIL_PKG.debug(' ' || X_after_report);
115: FA_RX_UTIL_PKG.debug(' )');
116:
117: FA_RX_UTIL_PKG.assign_report(X_section_name,

Line 114: FA_RX_UTIL_PKG.debug(' ' || X_after_report);

110: FA_RX_UTIL_PKG.debug(' TRUE');
111: FA_RX_UTIL_PKG.debug(' ' || X_before_report);
112: FA_RX_UTIL_PKG.debug(' ' || X_bind);
113: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);
114: FA_RX_UTIL_PKG.debug(' ' || X_after_report);
115: FA_RX_UTIL_PKG.debug(' )');
116:
117: FA_RX_UTIL_PKG.assign_report(X_section_name,
118: TRUE,

Line 115: FA_RX_UTIL_PKG.debug(' )');

111: FA_RX_UTIL_PKG.debug(' ' || X_before_report);
112: FA_RX_UTIL_PKG.debug(' ' || X_bind);
113: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);
114: FA_RX_UTIL_PKG.debug(' ' || X_after_report);
115: FA_RX_UTIL_PKG.debug(' )');
116:
117: FA_RX_UTIL_PKG.assign_report(X_section_name,
118: TRUE,
119: X_before_report,

Line 117: FA_RX_UTIL_PKG.assign_report(X_section_name,

113: FA_RX_UTIL_PKG.debug(' ' || X_after_fetch);
114: FA_RX_UTIL_PKG.debug(' ' || X_after_report);
115: FA_RX_UTIL_PKG.debug(' )');
116:
117: FA_RX_UTIL_PKG.assign_report(X_section_name,
118: TRUE,
119: X_before_report,
120: X_bind,
121: X_after_fetch,

Line 124: FA_RX_UTIL_PKG.run_report(X_calling_proc, retcode, errbuf);

120: X_bind,
121: X_after_fetch,
122: X_after_report);
123:
124: FA_RX_UTIL_PKG.run_report(X_calling_proc, retcode, errbuf);
125:
126: FA_RX_UTIL_PKG.debug(X_calling_proc || '()-');
127:
128: END fa_get_report;

Line 126: FA_RX_UTIL_PKG.debug(X_calling_proc || '()-');

122: X_after_report);
123:
124: FA_RX_UTIL_PKG.run_report(X_calling_proc, retcode, errbuf);
125:
126: FA_RX_UTIL_PKG.debug(X_calling_proc || '()-');
127:
128: END fa_get_report;
129:
130:

Line 149: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_before_report()+');

145: IS
146:
147:
148: BEGIN
149: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_before_report()+');
150:
151:
152: -- It takes the segment condition, Company name, currency code and store in placeholder variable
153: Startup;

Line 161: -- FA_RX_UTIL_PKG.assign_column(#, select, insert, place, type, len);

157:
158: -- Assign SELECT list
159: -- the Select statement is build over here
160:
161: -- FA_RX_UTIL_PKG.assign_column(#, select, insert, place, type, len);
162: fa_rx_util_pkg.debug(' checking if value is available'||to_char(X_fiscal_year_start_date));
163:
164: -->>SELECT_START<<--
165:

Line 162: fa_rx_util_pkg.debug(' checking if value is available'||to_char(X_fiscal_year_start_date));

158: -- Assign SELECT list
159: -- the Select statement is build over here
160:
161: -- FA_RX_UTIL_PKG.assign_column(#, select, insert, place, type, len);
162: fa_rx_util_pkg.debug(' checking if value is available'||to_char(X_fiscal_year_start_date));
163:
164: -->>SELECT_START<<--
165:
166: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JGRX_FAREG.var.organization_name','VARCHAR2',60);

Line 166: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JGRX_FAREG.var.organization_name','VARCHAR2',60);

162: fa_rx_util_pkg.debug(' checking if value is available'||to_char(X_fiscal_year_start_date));
163:
164: -->>SELECT_START<<--
165:
166: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JGRX_FAREG.var.organization_name','VARCHAR2',60);
167: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JGRX_FAREG.var.functional_currency_code', 'VARCHAR2',15);
168:
169: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JGRX_FAREG.var.major_category','VARCHAR2', 30);
170: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JGRX_FAREG.var.minor_category','VARCHAR2', 30);

Line 167: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JGRX_FAREG.var.functional_currency_code', 'VARCHAR2',15);

163:
164: -->>SELECT_START<<--
165:
166: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JGRX_FAREG.var.organization_name','VARCHAR2',60);
167: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JGRX_FAREG.var.functional_currency_code', 'VARCHAR2',15);
168:
169: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JGRX_FAREG.var.major_category','VARCHAR2', 30);
170: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JGRX_FAREG.var.minor_category','VARCHAR2', 30);
171:

Line 169: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JGRX_FAREG.var.major_category','VARCHAR2', 30);

165:
166: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JGRX_FAREG.var.organization_name','VARCHAR2',60);
167: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JGRX_FAREG.var.functional_currency_code', 'VARCHAR2',15);
168:
169: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JGRX_FAREG.var.major_category','VARCHAR2', 30);
170: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JGRX_FAREG.var.minor_category','VARCHAR2', 30);
171:
172: FA_RX_UTIL_PKG.assign_column('5', NULL, 'deprn_rate','JGRX_FAREG.var.deprn_rate','NUMBER');
173:

Line 170: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JGRX_FAREG.var.minor_category','VARCHAR2', 30);

166: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JGRX_FAREG.var.organization_name','VARCHAR2',60);
167: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JGRX_FAREG.var.functional_currency_code', 'VARCHAR2',15);
168:
169: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JGRX_FAREG.var.major_category','VARCHAR2', 30);
170: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JGRX_FAREG.var.minor_category','VARCHAR2', 30);
171:
172: FA_RX_UTIL_PKG.assign_column('5', NULL, 'deprn_rate','JGRX_FAREG.var.deprn_rate','NUMBER');
173:
174: FA_RX_UTIL_PKG.assign_column('6', NULL,'starting_deprn_year','JGRX_FAREG.var.starting_deprn_year','VARCHAR2', 4);

Line 172: FA_RX_UTIL_PKG.assign_column('5', NULL, 'deprn_rate','JGRX_FAREG.var.deprn_rate','NUMBER');

168:
169: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JGRX_FAREG.var.major_category','VARCHAR2', 30);
170: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JGRX_FAREG.var.minor_category','VARCHAR2', 30);
171:
172: FA_RX_UTIL_PKG.assign_column('5', NULL, 'deprn_rate','JGRX_FAREG.var.deprn_rate','NUMBER');
173:
174: FA_RX_UTIL_PKG.assign_column('6', NULL,'starting_deprn_year','JGRX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
175:
176: /* FA_RX_UTIL_PKG.assign_column('7', 'TO_CHAR(BO.date_placed_in_service,"YYYY")','starting_deprn_year','JGRX_FAREG.var.starting_deprn_year','VARCHAR2', 4);

Line 174: FA_RX_UTIL_PKG.assign_column('6', NULL,'starting_deprn_year','JGRX_FAREG.var.starting_deprn_year','VARCHAR2', 4);

170: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JGRX_FAREG.var.minor_category','VARCHAR2', 30);
171:
172: FA_RX_UTIL_PKG.assign_column('5', NULL, 'deprn_rate','JGRX_FAREG.var.deprn_rate','NUMBER');
173:
174: FA_RX_UTIL_PKG.assign_column('6', NULL,'starting_deprn_year','JGRX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
175:
176: /* FA_RX_UTIL_PKG.assign_column('7', 'TO_CHAR(BO.date_placed_in_service,"YYYY")','starting_deprn_year','JGRX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
177: */
178: FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JGRX_FAREG.var.date_placed_in_service','DATE');

Line 176: /* FA_RX_UTIL_PKG.assign_column('7', 'TO_CHAR(BO.date_placed_in_service,"YYYY")','starting_deprn_year','JGRX_FAREG.var.starting_deprn_year','VARCHAR2', 4);

172: FA_RX_UTIL_PKG.assign_column('5', NULL, 'deprn_rate','JGRX_FAREG.var.deprn_rate','NUMBER');
173:
174: FA_RX_UTIL_PKG.assign_column('6', NULL,'starting_deprn_year','JGRX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
175:
176: /* FA_RX_UTIL_PKG.assign_column('7', 'TO_CHAR(BO.date_placed_in_service,"YYYY")','starting_deprn_year','JGRX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
177: */
178: FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JGRX_FAREG.var.date_placed_in_service','DATE');
179:
180: FA_RX_UTIL_PKG.assign_column('8', 'BO.asset_id', NULL,'JGRX_FAREG.var.asset_id','NUMBER');

Line 178: FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JGRX_FAREG.var.date_placed_in_service','DATE');

174: FA_RX_UTIL_PKG.assign_column('6', NULL,'starting_deprn_year','JGRX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
175:
176: /* FA_RX_UTIL_PKG.assign_column('7', 'TO_CHAR(BO.date_placed_in_service,"YYYY")','starting_deprn_year','JGRX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
177: */
178: FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JGRX_FAREG.var.date_placed_in_service','DATE');
179:
180: FA_RX_UTIL_PKG.assign_column('8', 'BO.asset_id', NULL,'JGRX_FAREG.var.asset_id','NUMBER');
181: FA_RX_UTIL_PKG.assign_column('9', 'AD.asset_number', 'asset_number','JGRX_FAREG.var.asset_number','VARCHAR2', 25);
182: FA_RX_UTIL_PKG.assign_column('10', 'AD.description', 'description','JGRX_FAREG.var.description','VARCHAR2', 80);

Line 180: FA_RX_UTIL_PKG.assign_column('8', 'BO.asset_id', NULL,'JGRX_FAREG.var.asset_id','NUMBER');

176: /* FA_RX_UTIL_PKG.assign_column('7', 'TO_CHAR(BO.date_placed_in_service,"YYYY")','starting_deprn_year','JGRX_FAREG.var.starting_deprn_year','VARCHAR2', 4);
177: */
178: FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JGRX_FAREG.var.date_placed_in_service','DATE');
179:
180: FA_RX_UTIL_PKG.assign_column('8', 'BO.asset_id', NULL,'JGRX_FAREG.var.asset_id','NUMBER');
181: FA_RX_UTIL_PKG.assign_column('9', 'AD.asset_number', 'asset_number','JGRX_FAREG.var.asset_number','VARCHAR2', 25);
182: FA_RX_UTIL_PKG.assign_column('10', 'AD.description', 'description','JGRX_FAREG.var.description','VARCHAR2', 80);
183:
184: FA_RX_UTIL_PKG.assign_column('11', 'AD.parent_asset_id', NULL,'JGRX_FAREG.var.parent_asset_id','NUMBER');

Line 181: FA_RX_UTIL_PKG.assign_column('9', 'AD.asset_number', 'asset_number','JGRX_FAREG.var.asset_number','VARCHAR2', 25);

177: */
178: FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JGRX_FAREG.var.date_placed_in_service','DATE');
179:
180: FA_RX_UTIL_PKG.assign_column('8', 'BO.asset_id', NULL,'JGRX_FAREG.var.asset_id','NUMBER');
181: FA_RX_UTIL_PKG.assign_column('9', 'AD.asset_number', 'asset_number','JGRX_FAREG.var.asset_number','VARCHAR2', 25);
182: FA_RX_UTIL_PKG.assign_column('10', 'AD.description', 'description','JGRX_FAREG.var.description','VARCHAR2', 80);
183:
184: FA_RX_UTIL_PKG.assign_column('11', 'AD.parent_asset_id', NULL,'JGRX_FAREG.var.parent_asset_id','NUMBER');
185: FA_RX_UTIL_PKG.assign_column('12', NULL, 'parent_asset_number','JGRX_FAREG.var.parent_asset_number','VARCHAR2', 15);

Line 182: FA_RX_UTIL_PKG.assign_column('10', 'AD.description', 'description','JGRX_FAREG.var.description','VARCHAR2', 80);

178: FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JGRX_FAREG.var.date_placed_in_service','DATE');
179:
180: FA_RX_UTIL_PKG.assign_column('8', 'BO.asset_id', NULL,'JGRX_FAREG.var.asset_id','NUMBER');
181: FA_RX_UTIL_PKG.assign_column('9', 'AD.asset_number', 'asset_number','JGRX_FAREG.var.asset_number','VARCHAR2', 25);
182: FA_RX_UTIL_PKG.assign_column('10', 'AD.description', 'description','JGRX_FAREG.var.description','VARCHAR2', 80);
183:
184: FA_RX_UTIL_PKG.assign_column('11', 'AD.parent_asset_id', NULL,'JGRX_FAREG.var.parent_asset_id','NUMBER');
185: FA_RX_UTIL_PKG.assign_column('12', NULL, 'parent_asset_number','JGRX_FAREG.var.parent_asset_number','VARCHAR2', 15);
186:

Line 184: FA_RX_UTIL_PKG.assign_column('11', 'AD.parent_asset_id', NULL,'JGRX_FAREG.var.parent_asset_id','NUMBER');

180: FA_RX_UTIL_PKG.assign_column('8', 'BO.asset_id', NULL,'JGRX_FAREG.var.asset_id','NUMBER');
181: FA_RX_UTIL_PKG.assign_column('9', 'AD.asset_number', 'asset_number','JGRX_FAREG.var.asset_number','VARCHAR2', 25);
182: FA_RX_UTIL_PKG.assign_column('10', 'AD.description', 'description','JGRX_FAREG.var.description','VARCHAR2', 80);
183:
184: FA_RX_UTIL_PKG.assign_column('11', 'AD.parent_asset_id', NULL,'JGRX_FAREG.var.parent_asset_id','NUMBER');
185: FA_RX_UTIL_PKG.assign_column('12', NULL, 'parent_asset_number','JGRX_FAREG.var.parent_asset_number','VARCHAR2', 15);
186:
187: FA_RX_UTIL_PKG.assign_column('13', 'BO.original_cost', 'asset_cost_orig','JGRX_FAREG.var.asset_cost_orig','NUMBER');
188:

Line 185: FA_RX_UTIL_PKG.assign_column('12', NULL, 'parent_asset_number','JGRX_FAREG.var.parent_asset_number','VARCHAR2', 15);

181: FA_RX_UTIL_PKG.assign_column('9', 'AD.asset_number', 'asset_number','JGRX_FAREG.var.asset_number','VARCHAR2', 25);
182: FA_RX_UTIL_PKG.assign_column('10', 'AD.description', 'description','JGRX_FAREG.var.description','VARCHAR2', 80);
183:
184: FA_RX_UTIL_PKG.assign_column('11', 'AD.parent_asset_id', NULL,'JGRX_FAREG.var.parent_asset_id','NUMBER');
185: FA_RX_UTIL_PKG.assign_column('12', NULL, 'parent_asset_number','JGRX_FAREG.var.parent_asset_number','VARCHAR2', 15);
186:
187: FA_RX_UTIL_PKG.assign_column('13', 'BO.original_cost', 'asset_cost_orig','JGRX_FAREG.var.asset_cost_orig','NUMBER');
188:
189: FA_RX_UTIL_PKG.assign_column('14', NULL, 'bonus_rate','JGRX_FAREG.var.bonus_rate','NUMBER');

Line 187: FA_RX_UTIL_PKG.assign_column('13', 'BO.original_cost', 'asset_cost_orig','JGRX_FAREG.var.asset_cost_orig','NUMBER');

183:
184: FA_RX_UTIL_PKG.assign_column('11', 'AD.parent_asset_id', NULL,'JGRX_FAREG.var.parent_asset_id','NUMBER');
185: FA_RX_UTIL_PKG.assign_column('12', NULL, 'parent_asset_number','JGRX_FAREG.var.parent_asset_number','VARCHAR2', 15);
186:
187: FA_RX_UTIL_PKG.assign_column('13', 'BO.original_cost', 'asset_cost_orig','JGRX_FAREG.var.asset_cost_orig','NUMBER');
188:
189: FA_RX_UTIL_PKG.assign_column('14', NULL, 'bonus_rate','JGRX_FAREG.var.bonus_rate','NUMBER');
190:
191: FA_RX_UTIL_PKG.assign_column('15', NULL, 'invoice_number','JGRX_FAREG.var.invoice_number','VARCHAR2', 50);

Line 189: FA_RX_UTIL_PKG.assign_column('14', NULL, 'bonus_rate','JGRX_FAREG.var.bonus_rate','NUMBER');

185: FA_RX_UTIL_PKG.assign_column('12', NULL, 'parent_asset_number','JGRX_FAREG.var.parent_asset_number','VARCHAR2', 15);
186:
187: FA_RX_UTIL_PKG.assign_column('13', 'BO.original_cost', 'asset_cost_orig','JGRX_FAREG.var.asset_cost_orig','NUMBER');
188:
189: FA_RX_UTIL_PKG.assign_column('14', NULL, 'bonus_rate','JGRX_FAREG.var.bonus_rate','NUMBER');
190:
191: FA_RX_UTIL_PKG.assign_column('15', NULL, 'invoice_number','JGRX_FAREG.var.invoice_number','VARCHAR2', 50);
192: FA_RX_UTIL_PKG.assign_column('16', NULL, 'supplier_name','JGRX_FAREG.var.supplier_name','VARCHAR2', 80);
193:

Line 191: FA_RX_UTIL_PKG.assign_column('15', NULL, 'invoice_number','JGRX_FAREG.var.invoice_number','VARCHAR2', 50);

187: FA_RX_UTIL_PKG.assign_column('13', 'BO.original_cost', 'asset_cost_orig','JGRX_FAREG.var.asset_cost_orig','NUMBER');
188:
189: FA_RX_UTIL_PKG.assign_column('14', NULL, 'bonus_rate','JGRX_FAREG.var.bonus_rate','NUMBER');
190:
191: FA_RX_UTIL_PKG.assign_column('15', NULL, 'invoice_number','JGRX_FAREG.var.invoice_number','VARCHAR2', 50);
192: FA_RX_UTIL_PKG.assign_column('16', NULL, 'supplier_name','JGRX_FAREG.var.supplier_name','VARCHAR2', 80);
193:
194: FA_RX_UTIL_PKG.assign_column('17', 'CB.asset_cost_acct', 'cost_account','JGRX_FAREG.var.cost_account','VARCHAR2', 25);
195:

Line 192: FA_RX_UTIL_PKG.assign_column('16', NULL, 'supplier_name','JGRX_FAREG.var.supplier_name','VARCHAR2', 80);

188:
189: FA_RX_UTIL_PKG.assign_column('14', NULL, 'bonus_rate','JGRX_FAREG.var.bonus_rate','NUMBER');
190:
191: FA_RX_UTIL_PKG.assign_column('15', NULL, 'invoice_number','JGRX_FAREG.var.invoice_number','VARCHAR2', 50);
192: FA_RX_UTIL_PKG.assign_column('16', NULL, 'supplier_name','JGRX_FAREG.var.supplier_name','VARCHAR2', 80);
193:
194: FA_RX_UTIL_PKG.assign_column('17', 'CB.asset_cost_acct', 'cost_account','JGRX_FAREG.var.cost_account','VARCHAR2', 25);
195:
196: FA_RX_UTIL_PKG.assign_column('18', NULL, 'expense_account','JGRX_FAREG.var.expense_account','VARCHAR2', 25);

Line 194: FA_RX_UTIL_PKG.assign_column('17', 'CB.asset_cost_acct', 'cost_account','JGRX_FAREG.var.cost_account','VARCHAR2', 25);

190:
191: FA_RX_UTIL_PKG.assign_column('15', NULL, 'invoice_number','JGRX_FAREG.var.invoice_number','VARCHAR2', 50);
192: FA_RX_UTIL_PKG.assign_column('16', NULL, 'supplier_name','JGRX_FAREG.var.supplier_name','VARCHAR2', 80);
193:
194: FA_RX_UTIL_PKG.assign_column('17', 'CB.asset_cost_acct', 'cost_account','JGRX_FAREG.var.cost_account','VARCHAR2', 25);
195:
196: FA_RX_UTIL_PKG.assign_column('18', NULL, 'expense_account','JGRX_FAREG.var.expense_account','VARCHAR2', 25);
197: FA_RX_UTIL_PKG.assign_column('19', 'CB.deprn_reserve_acct', 'reserve_account','JGRX_FAREG.var.reserve_account','VARCHAR2', 25);
198:

Line 196: FA_RX_UTIL_PKG.assign_column('18', NULL, 'expense_account','JGRX_FAREG.var.expense_account','VARCHAR2', 25);

192: FA_RX_UTIL_PKG.assign_column('16', NULL, 'supplier_name','JGRX_FAREG.var.supplier_name','VARCHAR2', 80);
193:
194: FA_RX_UTIL_PKG.assign_column('17', 'CB.asset_cost_acct', 'cost_account','JGRX_FAREG.var.cost_account','VARCHAR2', 25);
195:
196: FA_RX_UTIL_PKG.assign_column('18', NULL, 'expense_account','JGRX_FAREG.var.expense_account','VARCHAR2', 25);
197: FA_RX_UTIL_PKG.assign_column('19', 'CB.deprn_reserve_acct', 'reserve_account','JGRX_FAREG.var.reserve_account','VARCHAR2', 25);
198:
199: FA_RX_UTIL_PKG.assign_column('20', 'CB.bonus_deprn_expense_acct', 'bonus_deprn_account','JGRX_FAREG.var.bonus_deprn_account','VARCHAR2', 25);
200: FA_RX_UTIL_PKG.assign_column('21', 'CB.bonus_deprn_reserve_acct', 'bonus_reserve_account','JGRX_FAREG.var.bonus_reserve_account','VARCHAR2', 25);

Line 197: FA_RX_UTIL_PKG.assign_column('19', 'CB.deprn_reserve_acct', 'reserve_account','JGRX_FAREG.var.reserve_account','VARCHAR2', 25);

193:
194: FA_RX_UTIL_PKG.assign_column('17', 'CB.asset_cost_acct', 'cost_account','JGRX_FAREG.var.cost_account','VARCHAR2', 25);
195:
196: FA_RX_UTIL_PKG.assign_column('18', NULL, 'expense_account','JGRX_FAREG.var.expense_account','VARCHAR2', 25);
197: FA_RX_UTIL_PKG.assign_column('19', 'CB.deprn_reserve_acct', 'reserve_account','JGRX_FAREG.var.reserve_account','VARCHAR2', 25);
198:
199: FA_RX_UTIL_PKG.assign_column('20', 'CB.bonus_deprn_expense_acct', 'bonus_deprn_account','JGRX_FAREG.var.bonus_deprn_account','VARCHAR2', 25);
200: FA_RX_UTIL_PKG.assign_column('21', 'CB.bonus_deprn_reserve_acct', 'bonus_reserve_account','JGRX_FAREG.var.bonus_reserve_account','VARCHAR2', 25);
201:

Line 199: FA_RX_UTIL_PKG.assign_column('20', 'CB.bonus_deprn_expense_acct', 'bonus_deprn_account','JGRX_FAREG.var.bonus_deprn_account','VARCHAR2', 25);

195:
196: FA_RX_UTIL_PKG.assign_column('18', NULL, 'expense_account','JGRX_FAREG.var.expense_account','VARCHAR2', 25);
197: FA_RX_UTIL_PKG.assign_column('19', 'CB.deprn_reserve_acct', 'reserve_account','JGRX_FAREG.var.reserve_account','VARCHAR2', 25);
198:
199: FA_RX_UTIL_PKG.assign_column('20', 'CB.bonus_deprn_expense_acct', 'bonus_deprn_account','JGRX_FAREG.var.bonus_deprn_account','VARCHAR2', 25);
200: FA_RX_UTIL_PKG.assign_column('21', 'CB.bonus_deprn_reserve_acct', 'bonus_reserve_account','JGRX_FAREG.var.bonus_reserve_account','VARCHAR2', 25);
201:
202: FA_RX_UTIL_PKG.assign_column('22', NULL, 'asset_cost_initial','JGRX_FAREG.var.asset_cost_initial', 'NUMBER');
203: FA_RX_UTIL_PKG.assign_column('23', NULL, 'asset_cost_increase','JGRX_FAREG.var.asset_cost_increase', 'NUMBER');

Line 200: FA_RX_UTIL_PKG.assign_column('21', 'CB.bonus_deprn_reserve_acct', 'bonus_reserve_account','JGRX_FAREG.var.bonus_reserve_account','VARCHAR2', 25);

196: FA_RX_UTIL_PKG.assign_column('18', NULL, 'expense_account','JGRX_FAREG.var.expense_account','VARCHAR2', 25);
197: FA_RX_UTIL_PKG.assign_column('19', 'CB.deprn_reserve_acct', 'reserve_account','JGRX_FAREG.var.reserve_account','VARCHAR2', 25);
198:
199: FA_RX_UTIL_PKG.assign_column('20', 'CB.bonus_deprn_expense_acct', 'bonus_deprn_account','JGRX_FAREG.var.bonus_deprn_account','VARCHAR2', 25);
200: FA_RX_UTIL_PKG.assign_column('21', 'CB.bonus_deprn_reserve_acct', 'bonus_reserve_account','JGRX_FAREG.var.bonus_reserve_account','VARCHAR2', 25);
201:
202: FA_RX_UTIL_PKG.assign_column('22', NULL, 'asset_cost_initial','JGRX_FAREG.var.asset_cost_initial', 'NUMBER');
203: FA_RX_UTIL_PKG.assign_column('23', NULL, 'asset_cost_increase','JGRX_FAREG.var.asset_cost_increase', 'NUMBER');
204: FA_RX_UTIL_PKG.assign_column('24', NULL, 'asset_cost_decrease','JGRX_FAREG.var.asset_cost_decrease', 'NUMBER');

Line 202: FA_RX_UTIL_PKG.assign_column('22', NULL, 'asset_cost_initial','JGRX_FAREG.var.asset_cost_initial', 'NUMBER');

198:
199: FA_RX_UTIL_PKG.assign_column('20', 'CB.bonus_deprn_expense_acct', 'bonus_deprn_account','JGRX_FAREG.var.bonus_deprn_account','VARCHAR2', 25);
200: FA_RX_UTIL_PKG.assign_column('21', 'CB.bonus_deprn_reserve_acct', 'bonus_reserve_account','JGRX_FAREG.var.bonus_reserve_account','VARCHAR2', 25);
201:
202: FA_RX_UTIL_PKG.assign_column('22', NULL, 'asset_cost_initial','JGRX_FAREG.var.asset_cost_initial', 'NUMBER');
203: FA_RX_UTIL_PKG.assign_column('23', NULL, 'asset_cost_increase','JGRX_FAREG.var.asset_cost_increase', 'NUMBER');
204: FA_RX_UTIL_PKG.assign_column('24', NULL, 'asset_cost_decrease','JGRX_FAREG.var.asset_cost_decrease', 'NUMBER');
205: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_cost_final','JGRX_FAREG.var.asset_cost_final', 'NUMBER');
206:

Line 203: FA_RX_UTIL_PKG.assign_column('23', NULL, 'asset_cost_increase','JGRX_FAREG.var.asset_cost_increase', 'NUMBER');

199: FA_RX_UTIL_PKG.assign_column('20', 'CB.bonus_deprn_expense_acct', 'bonus_deprn_account','JGRX_FAREG.var.bonus_deprn_account','VARCHAR2', 25);
200: FA_RX_UTIL_PKG.assign_column('21', 'CB.bonus_deprn_reserve_acct', 'bonus_reserve_account','JGRX_FAREG.var.bonus_reserve_account','VARCHAR2', 25);
201:
202: FA_RX_UTIL_PKG.assign_column('22', NULL, 'asset_cost_initial','JGRX_FAREG.var.asset_cost_initial', 'NUMBER');
203: FA_RX_UTIL_PKG.assign_column('23', NULL, 'asset_cost_increase','JGRX_FAREG.var.asset_cost_increase', 'NUMBER');
204: FA_RX_UTIL_PKG.assign_column('24', NULL, 'asset_cost_decrease','JGRX_FAREG.var.asset_cost_decrease', 'NUMBER');
205: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_cost_final','JGRX_FAREG.var.asset_cost_final', 'NUMBER');
206:
207: FA_RX_UTIL_PKG.assign_column('26', NULL, 'revaluation_initial','JGRX_FAREG.var.revaluation_initial', 'NUMBER');

Line 204: FA_RX_UTIL_PKG.assign_column('24', NULL, 'asset_cost_decrease','JGRX_FAREG.var.asset_cost_decrease', 'NUMBER');

200: FA_RX_UTIL_PKG.assign_column('21', 'CB.bonus_deprn_reserve_acct', 'bonus_reserve_account','JGRX_FAREG.var.bonus_reserve_account','VARCHAR2', 25);
201:
202: FA_RX_UTIL_PKG.assign_column('22', NULL, 'asset_cost_initial','JGRX_FAREG.var.asset_cost_initial', 'NUMBER');
203: FA_RX_UTIL_PKG.assign_column('23', NULL, 'asset_cost_increase','JGRX_FAREG.var.asset_cost_increase', 'NUMBER');
204: FA_RX_UTIL_PKG.assign_column('24', NULL, 'asset_cost_decrease','JGRX_FAREG.var.asset_cost_decrease', 'NUMBER');
205: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_cost_final','JGRX_FAREG.var.asset_cost_final', 'NUMBER');
206:
207: FA_RX_UTIL_PKG.assign_column('26', NULL, 'revaluation_initial','JGRX_FAREG.var.revaluation_initial', 'NUMBER');
208: FA_RX_UTIL_PKG.assign_column('27', NULL, 'revaluation_increase','JGRX_FAREG.var.revaluation_increase', 'NUMBER');

Line 205: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_cost_final','JGRX_FAREG.var.asset_cost_final', 'NUMBER');

201:
202: FA_RX_UTIL_PKG.assign_column('22', NULL, 'asset_cost_initial','JGRX_FAREG.var.asset_cost_initial', 'NUMBER');
203: FA_RX_UTIL_PKG.assign_column('23', NULL, 'asset_cost_increase','JGRX_FAREG.var.asset_cost_increase', 'NUMBER');
204: FA_RX_UTIL_PKG.assign_column('24', NULL, 'asset_cost_decrease','JGRX_FAREG.var.asset_cost_decrease', 'NUMBER');
205: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_cost_final','JGRX_FAREG.var.asset_cost_final', 'NUMBER');
206:
207: FA_RX_UTIL_PKG.assign_column('26', NULL, 'revaluation_initial','JGRX_FAREG.var.revaluation_initial', 'NUMBER');
208: FA_RX_UTIL_PKG.assign_column('27', NULL, 'revaluation_increase','JGRX_FAREG.var.revaluation_increase', 'NUMBER');
209: FA_RX_UTIL_PKG.assign_column('28', NULL, 'revaluation_decrease','JGRX_FAREG.var.revaluation_decrease', 'NUMBER');

Line 207: FA_RX_UTIL_PKG.assign_column('26', NULL, 'revaluation_initial','JGRX_FAREG.var.revaluation_initial', 'NUMBER');

203: FA_RX_UTIL_PKG.assign_column('23', NULL, 'asset_cost_increase','JGRX_FAREG.var.asset_cost_increase', 'NUMBER');
204: FA_RX_UTIL_PKG.assign_column('24', NULL, 'asset_cost_decrease','JGRX_FAREG.var.asset_cost_decrease', 'NUMBER');
205: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_cost_final','JGRX_FAREG.var.asset_cost_final', 'NUMBER');
206:
207: FA_RX_UTIL_PKG.assign_column('26', NULL, 'revaluation_initial','JGRX_FAREG.var.revaluation_initial', 'NUMBER');
208: FA_RX_UTIL_PKG.assign_column('27', NULL, 'revaluation_increase','JGRX_FAREG.var.revaluation_increase', 'NUMBER');
209: FA_RX_UTIL_PKG.assign_column('28', NULL, 'revaluation_decrease','JGRX_FAREG.var.revaluation_decrease', 'NUMBER');
210: FA_RX_UTIL_PKG.assign_column('29', NULL, 'revaluation_final','JGRX_FAREG.var.revaluation_final', 'NUMBER');
211:

Line 208: FA_RX_UTIL_PKG.assign_column('27', NULL, 'revaluation_increase','JGRX_FAREG.var.revaluation_increase', 'NUMBER');

204: FA_RX_UTIL_PKG.assign_column('24', NULL, 'asset_cost_decrease','JGRX_FAREG.var.asset_cost_decrease', 'NUMBER');
205: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_cost_final','JGRX_FAREG.var.asset_cost_final', 'NUMBER');
206:
207: FA_RX_UTIL_PKG.assign_column('26', NULL, 'revaluation_initial','JGRX_FAREG.var.revaluation_initial', 'NUMBER');
208: FA_RX_UTIL_PKG.assign_column('27', NULL, 'revaluation_increase','JGRX_FAREG.var.revaluation_increase', 'NUMBER');
209: FA_RX_UTIL_PKG.assign_column('28', NULL, 'revaluation_decrease','JGRX_FAREG.var.revaluation_decrease', 'NUMBER');
210: FA_RX_UTIL_PKG.assign_column('29', NULL, 'revaluation_final','JGRX_FAREG.var.revaluation_final', 'NUMBER');
211:
212: FA_RX_UTIL_PKG.assign_column('30', NULL, 'deprn_reserve_initial','JGRX_FAREG.var.deprn_reserve_initial', 'NUMBER');

Line 209: FA_RX_UTIL_PKG.assign_column('28', NULL, 'revaluation_decrease','JGRX_FAREG.var.revaluation_decrease', 'NUMBER');

205: FA_RX_UTIL_PKG.assign_column('25', NULL, 'asset_cost_final','JGRX_FAREG.var.asset_cost_final', 'NUMBER');
206:
207: FA_RX_UTIL_PKG.assign_column('26', NULL, 'revaluation_initial','JGRX_FAREG.var.revaluation_initial', 'NUMBER');
208: FA_RX_UTIL_PKG.assign_column('27', NULL, 'revaluation_increase','JGRX_FAREG.var.revaluation_increase', 'NUMBER');
209: FA_RX_UTIL_PKG.assign_column('28', NULL, 'revaluation_decrease','JGRX_FAREG.var.revaluation_decrease', 'NUMBER');
210: FA_RX_UTIL_PKG.assign_column('29', NULL, 'revaluation_final','JGRX_FAREG.var.revaluation_final', 'NUMBER');
211:
212: FA_RX_UTIL_PKG.assign_column('30', NULL, 'deprn_reserve_initial','JGRX_FAREG.var.deprn_reserve_initial', 'NUMBER');
213: FA_RX_UTIL_PKG.assign_column('31', NULL, 'deprn_reserve_increase','JGRX_FAREG.var.deprn_reserve_increase', 'NUMBER');

Line 210: FA_RX_UTIL_PKG.assign_column('29', NULL, 'revaluation_final','JGRX_FAREG.var.revaluation_final', 'NUMBER');

206:
207: FA_RX_UTIL_PKG.assign_column('26', NULL, 'revaluation_initial','JGRX_FAREG.var.revaluation_initial', 'NUMBER');
208: FA_RX_UTIL_PKG.assign_column('27', NULL, 'revaluation_increase','JGRX_FAREG.var.revaluation_increase', 'NUMBER');
209: FA_RX_UTIL_PKG.assign_column('28', NULL, 'revaluation_decrease','JGRX_FAREG.var.revaluation_decrease', 'NUMBER');
210: FA_RX_UTIL_PKG.assign_column('29', NULL, 'revaluation_final','JGRX_FAREG.var.revaluation_final', 'NUMBER');
211:
212: FA_RX_UTIL_PKG.assign_column('30', NULL, 'deprn_reserve_initial','JGRX_FAREG.var.deprn_reserve_initial', 'NUMBER');
213: FA_RX_UTIL_PKG.assign_column('31', NULL, 'deprn_reserve_increase','JGRX_FAREG.var.deprn_reserve_increase', 'NUMBER');
214: FA_RX_UTIL_PKG.assign_column('32', NULL, 'deprn_reserve_decrease','JGRX_FAREG.var.deprn_reserve_decrease', 'NUMBER');

Line 212: FA_RX_UTIL_PKG.assign_column('30', NULL, 'deprn_reserve_initial','JGRX_FAREG.var.deprn_reserve_initial', 'NUMBER');

208: FA_RX_UTIL_PKG.assign_column('27', NULL, 'revaluation_increase','JGRX_FAREG.var.revaluation_increase', 'NUMBER');
209: FA_RX_UTIL_PKG.assign_column('28', NULL, 'revaluation_decrease','JGRX_FAREG.var.revaluation_decrease', 'NUMBER');
210: FA_RX_UTIL_PKG.assign_column('29', NULL, 'revaluation_final','JGRX_FAREG.var.revaluation_final', 'NUMBER');
211:
212: FA_RX_UTIL_PKG.assign_column('30', NULL, 'deprn_reserve_initial','JGRX_FAREG.var.deprn_reserve_initial', 'NUMBER');
213: FA_RX_UTIL_PKG.assign_column('31', NULL, 'deprn_reserve_increase','JGRX_FAREG.var.deprn_reserve_increase', 'NUMBER');
214: FA_RX_UTIL_PKG.assign_column('32', NULL, 'deprn_reserve_decrease','JGRX_FAREG.var.deprn_reserve_decrease', 'NUMBER');
215: FA_RX_UTIL_PKG.assign_column('33', NULL, 'deprn_reserve_final','JGRX_FAREG.var.deprn_reserve_final', 'NUMBER');
216:

Line 213: FA_RX_UTIL_PKG.assign_column('31', NULL, 'deprn_reserve_increase','JGRX_FAREG.var.deprn_reserve_increase', 'NUMBER');

209: FA_RX_UTIL_PKG.assign_column('28', NULL, 'revaluation_decrease','JGRX_FAREG.var.revaluation_decrease', 'NUMBER');
210: FA_RX_UTIL_PKG.assign_column('29', NULL, 'revaluation_final','JGRX_FAREG.var.revaluation_final', 'NUMBER');
211:
212: FA_RX_UTIL_PKG.assign_column('30', NULL, 'deprn_reserve_initial','JGRX_FAREG.var.deprn_reserve_initial', 'NUMBER');
213: FA_RX_UTIL_PKG.assign_column('31', NULL, 'deprn_reserve_increase','JGRX_FAREG.var.deprn_reserve_increase', 'NUMBER');
214: FA_RX_UTIL_PKG.assign_column('32', NULL, 'deprn_reserve_decrease','JGRX_FAREG.var.deprn_reserve_decrease', 'NUMBER');
215: FA_RX_UTIL_PKG.assign_column('33', NULL, 'deprn_reserve_final','JGRX_FAREG.var.deprn_reserve_final', 'NUMBER');
216:
217: FA_RX_UTIL_PKG.assign_column('34', NULL, 'bonus_reserve_initial','JGRX_FAREG.var.bonus_reserve_initial', 'NUMBER');

Line 214: FA_RX_UTIL_PKG.assign_column('32', NULL, 'deprn_reserve_decrease','JGRX_FAREG.var.deprn_reserve_decrease', 'NUMBER');

210: FA_RX_UTIL_PKG.assign_column('29', NULL, 'revaluation_final','JGRX_FAREG.var.revaluation_final', 'NUMBER');
211:
212: FA_RX_UTIL_PKG.assign_column('30', NULL, 'deprn_reserve_initial','JGRX_FAREG.var.deprn_reserve_initial', 'NUMBER');
213: FA_RX_UTIL_PKG.assign_column('31', NULL, 'deprn_reserve_increase','JGRX_FAREG.var.deprn_reserve_increase', 'NUMBER');
214: FA_RX_UTIL_PKG.assign_column('32', NULL, 'deprn_reserve_decrease','JGRX_FAREG.var.deprn_reserve_decrease', 'NUMBER');
215: FA_RX_UTIL_PKG.assign_column('33', NULL, 'deprn_reserve_final','JGRX_FAREG.var.deprn_reserve_final', 'NUMBER');
216:
217: FA_RX_UTIL_PKG.assign_column('34', NULL, 'bonus_reserve_initial','JGRX_FAREG.var.bonus_reserve_initial', 'NUMBER');
218: FA_RX_UTIL_PKG.assign_column('35', NULL, 'bonus_reserve_increase','JGRX_FAREG.var.bonus_reserve_increase', 'NUMBER');

Line 215: FA_RX_UTIL_PKG.assign_column('33', NULL, 'deprn_reserve_final','JGRX_FAREG.var.deprn_reserve_final', 'NUMBER');

211:
212: FA_RX_UTIL_PKG.assign_column('30', NULL, 'deprn_reserve_initial','JGRX_FAREG.var.deprn_reserve_initial', 'NUMBER');
213: FA_RX_UTIL_PKG.assign_column('31', NULL, 'deprn_reserve_increase','JGRX_FAREG.var.deprn_reserve_increase', 'NUMBER');
214: FA_RX_UTIL_PKG.assign_column('32', NULL, 'deprn_reserve_decrease','JGRX_FAREG.var.deprn_reserve_decrease', 'NUMBER');
215: FA_RX_UTIL_PKG.assign_column('33', NULL, 'deprn_reserve_final','JGRX_FAREG.var.deprn_reserve_final', 'NUMBER');
216:
217: FA_RX_UTIL_PKG.assign_column('34', NULL, 'bonus_reserve_initial','JGRX_FAREG.var.bonus_reserve_initial', 'NUMBER');
218: FA_RX_UTIL_PKG.assign_column('35', NULL, 'bonus_reserve_increase','JGRX_FAREG.var.bonus_reserve_increase', 'NUMBER');
219: FA_RX_UTIL_PKG.assign_column('36', NULL, 'bonus_reserve_decrease','JGRX_FAREG.var.bonus_reserve_decrease', 'NUMBER');

Line 217: FA_RX_UTIL_PKG.assign_column('34', NULL, 'bonus_reserve_initial','JGRX_FAREG.var.bonus_reserve_initial', 'NUMBER');

213: FA_RX_UTIL_PKG.assign_column('31', NULL, 'deprn_reserve_increase','JGRX_FAREG.var.deprn_reserve_increase', 'NUMBER');
214: FA_RX_UTIL_PKG.assign_column('32', NULL, 'deprn_reserve_decrease','JGRX_FAREG.var.deprn_reserve_decrease', 'NUMBER');
215: FA_RX_UTIL_PKG.assign_column('33', NULL, 'deprn_reserve_final','JGRX_FAREG.var.deprn_reserve_final', 'NUMBER');
216:
217: FA_RX_UTIL_PKG.assign_column('34', NULL, 'bonus_reserve_initial','JGRX_FAREG.var.bonus_reserve_initial', 'NUMBER');
218: FA_RX_UTIL_PKG.assign_column('35', NULL, 'bonus_reserve_increase','JGRX_FAREG.var.bonus_reserve_increase', 'NUMBER');
219: FA_RX_UTIL_PKG.assign_column('36', NULL, 'bonus_reserve_decrease','JGRX_FAREG.var.bonus_reserve_decrease', 'NUMBER');
220: FA_RX_UTIL_PKG.assign_column('37', NULL, 'bonus_reserve_final','JGRX_FAREG.var.bonus_reserve_final', 'NUMBER');
221:

Line 218: FA_RX_UTIL_PKG.assign_column('35', NULL, 'bonus_reserve_increase','JGRX_FAREG.var.bonus_reserve_increase', 'NUMBER');

214: FA_RX_UTIL_PKG.assign_column('32', NULL, 'deprn_reserve_decrease','JGRX_FAREG.var.deprn_reserve_decrease', 'NUMBER');
215: FA_RX_UTIL_PKG.assign_column('33', NULL, 'deprn_reserve_final','JGRX_FAREG.var.deprn_reserve_final', 'NUMBER');
216:
217: FA_RX_UTIL_PKG.assign_column('34', NULL, 'bonus_reserve_initial','JGRX_FAREG.var.bonus_reserve_initial', 'NUMBER');
218: FA_RX_UTIL_PKG.assign_column('35', NULL, 'bonus_reserve_increase','JGRX_FAREG.var.bonus_reserve_increase', 'NUMBER');
219: FA_RX_UTIL_PKG.assign_column('36', NULL, 'bonus_reserve_decrease','JGRX_FAREG.var.bonus_reserve_decrease', 'NUMBER');
220: FA_RX_UTIL_PKG.assign_column('37', NULL, 'bonus_reserve_final','JGRX_FAREG.var.bonus_reserve_final', 'NUMBER');
221:
222: FA_RX_UTIL_PKG.assign_column('38', NULL, 'net_book_value_initial','JGRX_FAREG.var.net_book_value_initial', 'NUMBER');

Line 219: FA_RX_UTIL_PKG.assign_column('36', NULL, 'bonus_reserve_decrease','JGRX_FAREG.var.bonus_reserve_decrease', 'NUMBER');

215: FA_RX_UTIL_PKG.assign_column('33', NULL, 'deprn_reserve_final','JGRX_FAREG.var.deprn_reserve_final', 'NUMBER');
216:
217: FA_RX_UTIL_PKG.assign_column('34', NULL, 'bonus_reserve_initial','JGRX_FAREG.var.bonus_reserve_initial', 'NUMBER');
218: FA_RX_UTIL_PKG.assign_column('35', NULL, 'bonus_reserve_increase','JGRX_FAREG.var.bonus_reserve_increase', 'NUMBER');
219: FA_RX_UTIL_PKG.assign_column('36', NULL, 'bonus_reserve_decrease','JGRX_FAREG.var.bonus_reserve_decrease', 'NUMBER');
220: FA_RX_UTIL_PKG.assign_column('37', NULL, 'bonus_reserve_final','JGRX_FAREG.var.bonus_reserve_final', 'NUMBER');
221:
222: FA_RX_UTIL_PKG.assign_column('38', NULL, 'net_book_value_initial','JGRX_FAREG.var.net_book_value_initial', 'NUMBER');
223: FA_RX_UTIL_PKG.assign_column('39', NULL, 'net_book_value_increase','JGRX_FAREG.var.net_book_value_increase', 'NUMBER');

Line 220: FA_RX_UTIL_PKG.assign_column('37', NULL, 'bonus_reserve_final','JGRX_FAREG.var.bonus_reserve_final', 'NUMBER');

216:
217: FA_RX_UTIL_PKG.assign_column('34', NULL, 'bonus_reserve_initial','JGRX_FAREG.var.bonus_reserve_initial', 'NUMBER');
218: FA_RX_UTIL_PKG.assign_column('35', NULL, 'bonus_reserve_increase','JGRX_FAREG.var.bonus_reserve_increase', 'NUMBER');
219: FA_RX_UTIL_PKG.assign_column('36', NULL, 'bonus_reserve_decrease','JGRX_FAREG.var.bonus_reserve_decrease', 'NUMBER');
220: FA_RX_UTIL_PKG.assign_column('37', NULL, 'bonus_reserve_final','JGRX_FAREG.var.bonus_reserve_final', 'NUMBER');
221:
222: FA_RX_UTIL_PKG.assign_column('38', NULL, 'net_book_value_initial','JGRX_FAREG.var.net_book_value_initial', 'NUMBER');
223: FA_RX_UTIL_PKG.assign_column('39', NULL, 'net_book_value_increase','JGRX_FAREG.var.net_book_value_increase', 'NUMBER');
224: FA_RX_UTIL_PKG.assign_column('40', NULL, 'net_book_value_decrease','JGRX_FAREG.var.net_book_value_decrease', 'NUMBER');

Line 222: FA_RX_UTIL_PKG.assign_column('38', NULL, 'net_book_value_initial','JGRX_FAREG.var.net_book_value_initial', 'NUMBER');

218: FA_RX_UTIL_PKG.assign_column('35', NULL, 'bonus_reserve_increase','JGRX_FAREG.var.bonus_reserve_increase', 'NUMBER');
219: FA_RX_UTIL_PKG.assign_column('36', NULL, 'bonus_reserve_decrease','JGRX_FAREG.var.bonus_reserve_decrease', 'NUMBER');
220: FA_RX_UTIL_PKG.assign_column('37', NULL, 'bonus_reserve_final','JGRX_FAREG.var.bonus_reserve_final', 'NUMBER');
221:
222: FA_RX_UTIL_PKG.assign_column('38', NULL, 'net_book_value_initial','JGRX_FAREG.var.net_book_value_initial', 'NUMBER');
223: FA_RX_UTIL_PKG.assign_column('39', NULL, 'net_book_value_increase','JGRX_FAREG.var.net_book_value_increase', 'NUMBER');
224: FA_RX_UTIL_PKG.assign_column('40', NULL, 'net_book_value_decrease','JGRX_FAREG.var.net_book_value_decrease', 'NUMBER');
225: FA_RX_UTIL_PKG.assign_column('41', NULL, 'net_book_value_final','JGRX_FAREG.var.net_book_value_final', 'NUMBER');
226:

Line 223: FA_RX_UTIL_PKG.assign_column('39', NULL, 'net_book_value_increase','JGRX_FAREG.var.net_book_value_increase', 'NUMBER');

219: FA_RX_UTIL_PKG.assign_column('36', NULL, 'bonus_reserve_decrease','JGRX_FAREG.var.bonus_reserve_decrease', 'NUMBER');
220: FA_RX_UTIL_PKG.assign_column('37', NULL, 'bonus_reserve_final','JGRX_FAREG.var.bonus_reserve_final', 'NUMBER');
221:
222: FA_RX_UTIL_PKG.assign_column('38', NULL, 'net_book_value_initial','JGRX_FAREG.var.net_book_value_initial', 'NUMBER');
223: FA_RX_UTIL_PKG.assign_column('39', NULL, 'net_book_value_increase','JGRX_FAREG.var.net_book_value_increase', 'NUMBER');
224: FA_RX_UTIL_PKG.assign_column('40', NULL, 'net_book_value_decrease','JGRX_FAREG.var.net_book_value_decrease', 'NUMBER');
225: FA_RX_UTIL_PKG.assign_column('41', NULL, 'net_book_value_final','JGRX_FAREG.var.net_book_value_final', 'NUMBER');
226:
227: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JGRX_FAREG.var.transaction_date', 'DATE');

Line 224: FA_RX_UTIL_PKG.assign_column('40', NULL, 'net_book_value_decrease','JGRX_FAREG.var.net_book_value_decrease', 'NUMBER');

220: FA_RX_UTIL_PKG.assign_column('37', NULL, 'bonus_reserve_final','JGRX_FAREG.var.bonus_reserve_final', 'NUMBER');
221:
222: FA_RX_UTIL_PKG.assign_column('38', NULL, 'net_book_value_initial','JGRX_FAREG.var.net_book_value_initial', 'NUMBER');
223: FA_RX_UTIL_PKG.assign_column('39', NULL, 'net_book_value_increase','JGRX_FAREG.var.net_book_value_increase', 'NUMBER');
224: FA_RX_UTIL_PKG.assign_column('40', NULL, 'net_book_value_decrease','JGRX_FAREG.var.net_book_value_decrease', 'NUMBER');
225: FA_RX_UTIL_PKG.assign_column('41', NULL, 'net_book_value_final','JGRX_FAREG.var.net_book_value_final', 'NUMBER');
226:
227: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JGRX_FAREG.var.transaction_date', 'DATE');
228: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JGRX_FAREG.var.transaction_number', 'NUMBER');

Line 225: FA_RX_UTIL_PKG.assign_column('41', NULL, 'net_book_value_final','JGRX_FAREG.var.net_book_value_final', 'NUMBER');

221:
222: FA_RX_UTIL_PKG.assign_column('38', NULL, 'net_book_value_initial','JGRX_FAREG.var.net_book_value_initial', 'NUMBER');
223: FA_RX_UTIL_PKG.assign_column('39', NULL, 'net_book_value_increase','JGRX_FAREG.var.net_book_value_increase', 'NUMBER');
224: FA_RX_UTIL_PKG.assign_column('40', NULL, 'net_book_value_decrease','JGRX_FAREG.var.net_book_value_decrease', 'NUMBER');
225: FA_RX_UTIL_PKG.assign_column('41', NULL, 'net_book_value_final','JGRX_FAREG.var.net_book_value_final', 'NUMBER');
226:
227: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JGRX_FAREG.var.transaction_date', 'DATE');
228: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JGRX_FAREG.var.transaction_number', 'NUMBER');
229: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JGRX_FAREG.var.transaction_code', 'VARCHAR2', 20);

Line 227: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JGRX_FAREG.var.transaction_date', 'DATE');

223: FA_RX_UTIL_PKG.assign_column('39', NULL, 'net_book_value_increase','JGRX_FAREG.var.net_book_value_increase', 'NUMBER');
224: FA_RX_UTIL_PKG.assign_column('40', NULL, 'net_book_value_decrease','JGRX_FAREG.var.net_book_value_decrease', 'NUMBER');
225: FA_RX_UTIL_PKG.assign_column('41', NULL, 'net_book_value_final','JGRX_FAREG.var.net_book_value_final', 'NUMBER');
226:
227: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JGRX_FAREG.var.transaction_date', 'DATE');
228: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JGRX_FAREG.var.transaction_number', 'NUMBER');
229: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JGRX_FAREG.var.transaction_code', 'VARCHAR2', 20);
230: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JGRX_FAREG.var.transaction_amount', 'NUMBER');
231:

Line 228: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JGRX_FAREG.var.transaction_number', 'NUMBER');

224: FA_RX_UTIL_PKG.assign_column('40', NULL, 'net_book_value_decrease','JGRX_FAREG.var.net_book_value_decrease', 'NUMBER');
225: FA_RX_UTIL_PKG.assign_column('41', NULL, 'net_book_value_final','JGRX_FAREG.var.net_book_value_final', 'NUMBER');
226:
227: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JGRX_FAREG.var.transaction_date', 'DATE');
228: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JGRX_FAREG.var.transaction_number', 'NUMBER');
229: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JGRX_FAREG.var.transaction_code', 'VARCHAR2', 20);
230: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JGRX_FAREG.var.transaction_amount', 'NUMBER');
231:
232: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JGRX_FAREG.var.date_placed_in_service','DATE');

Line 229: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JGRX_FAREG.var.transaction_code', 'VARCHAR2', 20);

225: FA_RX_UTIL_PKG.assign_column('41', NULL, 'net_book_value_final','JGRX_FAREG.var.net_book_value_final', 'NUMBER');
226:
227: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JGRX_FAREG.var.transaction_date', 'DATE');
228: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JGRX_FAREG.var.transaction_number', 'NUMBER');
229: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JGRX_FAREG.var.transaction_code', 'VARCHAR2', 20);
230: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JGRX_FAREG.var.transaction_amount', 'NUMBER');
231:
232: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JGRX_FAREG.var.date_placed_in_service','DATE');
233: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JGRX_FAREG.var.prorate_date','DATE');

Line 230: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JGRX_FAREG.var.transaction_amount', 'NUMBER');

226:
227: FA_RX_UTIL_PKG.assign_column('42', NULL, 'transaction_date','JGRX_FAREG.var.transaction_date', 'DATE');
228: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JGRX_FAREG.var.transaction_number', 'NUMBER');
229: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JGRX_FAREG.var.transaction_code', 'VARCHAR2', 20);
230: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JGRX_FAREG.var.transaction_amount', 'NUMBER');
231:
232: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JGRX_FAREG.var.date_placed_in_service','DATE');
233: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JGRX_FAREG.var.prorate_date','DATE');
234: FA_RX_UTIL_PKG.assign_column('48', 'ME.method_id', NULL,'JGRX_FAREG.var.method_id','NUMBER');

Line 232: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JGRX_FAREG.var.date_placed_in_service','DATE');

228: FA_RX_UTIL_PKG.assign_column('43', NULL, 'transaction_number','JGRX_FAREG.var.transaction_number', 'NUMBER');
229: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JGRX_FAREG.var.transaction_code', 'VARCHAR2', 20);
230: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JGRX_FAREG.var.transaction_amount', 'NUMBER');
231:
232: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JGRX_FAREG.var.date_placed_in_service','DATE');
233: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JGRX_FAREG.var.prorate_date','DATE');
234: FA_RX_UTIL_PKG.assign_column('48', 'ME.method_id', NULL,'JGRX_FAREG.var.method_id','NUMBER');
235: FA_RX_UTIL_PKG.assign_column('49', 'ME.rate_source_rule', NULL,'JGRX_FAREG.var.rate_source_rule','VARCHAR2', 10);
236: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JGRX_FAREG.var.adjusted_rate','NUMBER');

Line 233: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JGRX_FAREG.var.prorate_date','DATE');

229: FA_RX_UTIL_PKG.assign_column('44', NULL, 'transaction_code','JGRX_FAREG.var.transaction_code', 'VARCHAR2', 20);
230: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JGRX_FAREG.var.transaction_amount', 'NUMBER');
231:
232: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JGRX_FAREG.var.date_placed_in_service','DATE');
233: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JGRX_FAREG.var.prorate_date','DATE');
234: FA_RX_UTIL_PKG.assign_column('48', 'ME.method_id', NULL,'JGRX_FAREG.var.method_id','NUMBER');
235: FA_RX_UTIL_PKG.assign_column('49', 'ME.rate_source_rule', NULL,'JGRX_FAREG.var.rate_source_rule','VARCHAR2', 10);
236: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JGRX_FAREG.var.adjusted_rate','NUMBER');
237: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', NULL,'JGRX_FAREG.var.life_in_months','NUMBER');

Line 234: FA_RX_UTIL_PKG.assign_column('48', 'ME.method_id', NULL,'JGRX_FAREG.var.method_id','NUMBER');

230: FA_RX_UTIL_PKG.assign_column('45', NULL, 'transaction_amount','JGRX_FAREG.var.transaction_amount', 'NUMBER');
231:
232: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JGRX_FAREG.var.date_placed_in_service','DATE');
233: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JGRX_FAREG.var.prorate_date','DATE');
234: FA_RX_UTIL_PKG.assign_column('48', 'ME.method_id', NULL,'JGRX_FAREG.var.method_id','NUMBER');
235: FA_RX_UTIL_PKG.assign_column('49', 'ME.rate_source_rule', NULL,'JGRX_FAREG.var.rate_source_rule','VARCHAR2', 10);
236: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JGRX_FAREG.var.adjusted_rate','NUMBER');
237: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', NULL,'JGRX_FAREG.var.life_in_months','NUMBER');
238: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JGRX_FAREG.var.bonus_rule','VARCHAR2', 30);

Line 235: FA_RX_UTIL_PKG.assign_column('49', 'ME.rate_source_rule', NULL,'JGRX_FAREG.var.rate_source_rule','VARCHAR2', 10);

231:
232: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JGRX_FAREG.var.date_placed_in_service','DATE');
233: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JGRX_FAREG.var.prorate_date','DATE');
234: FA_RX_UTIL_PKG.assign_column('48', 'ME.method_id', NULL,'JGRX_FAREG.var.method_id','NUMBER');
235: FA_RX_UTIL_PKG.assign_column('49', 'ME.rate_source_rule', NULL,'JGRX_FAREG.var.rate_source_rule','VARCHAR2', 10);
236: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JGRX_FAREG.var.adjusted_rate','NUMBER');
237: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', NULL,'JGRX_FAREG.var.life_in_months','NUMBER');
238: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JGRX_FAREG.var.bonus_rule','VARCHAR2', 30);
239: FA_RX_UTIL_PKG.assign_column('53', NULL,'asset_heading','JGRX_FAREG.var.asset_heading','VARCHAR2', 15);

Line 236: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JGRX_FAREG.var.adjusted_rate','NUMBER');

232: -- FA_RX_UTIL_PKG.assign_column('46', 'BO.date_placed_in_service', NULL,'JGRX_FAREG.var.date_placed_in_service','DATE');
233: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JGRX_FAREG.var.prorate_date','DATE');
234: FA_RX_UTIL_PKG.assign_column('48', 'ME.method_id', NULL,'JGRX_FAREG.var.method_id','NUMBER');
235: FA_RX_UTIL_PKG.assign_column('49', 'ME.rate_source_rule', NULL,'JGRX_FAREG.var.rate_source_rule','VARCHAR2', 10);
236: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JGRX_FAREG.var.adjusted_rate','NUMBER');
237: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', NULL,'JGRX_FAREG.var.life_in_months','NUMBER');
238: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JGRX_FAREG.var.bonus_rule','VARCHAR2', 30);
239: FA_RX_UTIL_PKG.assign_column('53', NULL,'asset_heading','JGRX_FAREG.var.asset_heading','VARCHAR2', 15);
240: FA_RX_UTIL_PKG.assign_column('54', NULL,'initial_heading','JGRX_FAREG.var.initial_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA

Line 237: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', NULL,'JGRX_FAREG.var.life_in_months','NUMBER');

233: FA_RX_UTIL_PKG.assign_column('47', 'BO.prorate_date', NULL,'JGRX_FAREG.var.prorate_date','DATE');
234: FA_RX_UTIL_PKG.assign_column('48', 'ME.method_id', NULL,'JGRX_FAREG.var.method_id','NUMBER');
235: FA_RX_UTIL_PKG.assign_column('49', 'ME.rate_source_rule', NULL,'JGRX_FAREG.var.rate_source_rule','VARCHAR2', 10);
236: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JGRX_FAREG.var.adjusted_rate','NUMBER');
237: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', NULL,'JGRX_FAREG.var.life_in_months','NUMBER');
238: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JGRX_FAREG.var.bonus_rule','VARCHAR2', 30);
239: FA_RX_UTIL_PKG.assign_column('53', NULL,'asset_heading','JGRX_FAREG.var.asset_heading','VARCHAR2', 15);
240: FA_RX_UTIL_PKG.assign_column('54', NULL,'initial_heading','JGRX_FAREG.var.initial_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
241: FA_RX_UTIL_PKG.assign_column('55', '''Variation''','variation_heading','JGRX_FAREG.var.variation_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA

Line 238: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JGRX_FAREG.var.bonus_rule','VARCHAR2', 30);

234: FA_RX_UTIL_PKG.assign_column('48', 'ME.method_id', NULL,'JGRX_FAREG.var.method_id','NUMBER');
235: FA_RX_UTIL_PKG.assign_column('49', 'ME.rate_source_rule', NULL,'JGRX_FAREG.var.rate_source_rule','VARCHAR2', 10);
236: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JGRX_FAREG.var.adjusted_rate','NUMBER');
237: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', NULL,'JGRX_FAREG.var.life_in_months','NUMBER');
238: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JGRX_FAREG.var.bonus_rule','VARCHAR2', 30);
239: FA_RX_UTIL_PKG.assign_column('53', NULL,'asset_heading','JGRX_FAREG.var.asset_heading','VARCHAR2', 15);
240: FA_RX_UTIL_PKG.assign_column('54', NULL,'initial_heading','JGRX_FAREG.var.initial_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
241: FA_RX_UTIL_PKG.assign_column('55', '''Variation''','variation_heading','JGRX_FAREG.var.variation_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
242: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',

Line 239: FA_RX_UTIL_PKG.assign_column('53', NULL,'asset_heading','JGRX_FAREG.var.asset_heading','VARCHAR2', 15);

235: FA_RX_UTIL_PKG.assign_column('49', 'ME.rate_source_rule', NULL,'JGRX_FAREG.var.rate_source_rule','VARCHAR2', 10);
236: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JGRX_FAREG.var.adjusted_rate','NUMBER');
237: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', NULL,'JGRX_FAREG.var.life_in_months','NUMBER');
238: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JGRX_FAREG.var.bonus_rule','VARCHAR2', 30);
239: FA_RX_UTIL_PKG.assign_column('53', NULL,'asset_heading','JGRX_FAREG.var.asset_heading','VARCHAR2', 15);
240: FA_RX_UTIL_PKG.assign_column('54', NULL,'initial_heading','JGRX_FAREG.var.initial_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
241: FA_RX_UTIL_PKG.assign_column('55', '''Variation''','variation_heading','JGRX_FAREG.var.variation_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
242: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',
243: 'JGRX_FAREG.var.final_heading','VARCHAR2', 132); -- 09/08/00 AFERRARA

Line 240: FA_RX_UTIL_PKG.assign_column('54', NULL,'initial_heading','JGRX_FAREG.var.initial_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA

236: FA_RX_UTIL_PKG.assign_column('50', 'BO.adjusted_rate', NULL,'JGRX_FAREG.var.adjusted_rate','NUMBER');
237: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', NULL,'JGRX_FAREG.var.life_in_months','NUMBER');
238: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JGRX_FAREG.var.bonus_rule','VARCHAR2', 30);
239: FA_RX_UTIL_PKG.assign_column('53', NULL,'asset_heading','JGRX_FAREG.var.asset_heading','VARCHAR2', 15);
240: FA_RX_UTIL_PKG.assign_column('54', NULL,'initial_heading','JGRX_FAREG.var.initial_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
241: FA_RX_UTIL_PKG.assign_column('55', '''Variation''','variation_heading','JGRX_FAREG.var.variation_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
242: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',
243: 'JGRX_FAREG.var.final_heading','VARCHAR2', 132); -- 09/08/00 AFERRARA
244: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JGRX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA

Line 241: FA_RX_UTIL_PKG.assign_column('55', '''Variation''','variation_heading','JGRX_FAREG.var.variation_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA

237: FA_RX_UTIL_PKG.assign_column('51', 'BO.life_in_months', NULL,'JGRX_FAREG.var.life_in_months','NUMBER');
238: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JGRX_FAREG.var.bonus_rule','VARCHAR2', 30);
239: FA_RX_UTIL_PKG.assign_column('53', NULL,'asset_heading','JGRX_FAREG.var.asset_heading','VARCHAR2', 15);
240: FA_RX_UTIL_PKG.assign_column('54', NULL,'initial_heading','JGRX_FAREG.var.initial_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
241: FA_RX_UTIL_PKG.assign_column('55', '''Variation''','variation_heading','JGRX_FAREG.var.variation_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
242: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',
243: 'JGRX_FAREG.var.final_heading','VARCHAR2', 132); -- 09/08/00 AFERRARA
244: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JGRX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA
245: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JGRX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA

Line 242: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',

238: FA_RX_UTIL_PKG.assign_column('52', 'BO.bonus_rule', NULL,'JGRX_FAREG.var.bonus_rule','VARCHAR2', 30);
239: FA_RX_UTIL_PKG.assign_column('53', NULL,'asset_heading','JGRX_FAREG.var.asset_heading','VARCHAR2', 15);
240: FA_RX_UTIL_PKG.assign_column('54', NULL,'initial_heading','JGRX_FAREG.var.initial_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
241: FA_RX_UTIL_PKG.assign_column('55', '''Variation''','variation_heading','JGRX_FAREG.var.variation_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
242: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',
243: 'JGRX_FAREG.var.final_heading','VARCHAR2', 132); -- 09/08/00 AFERRARA
244: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JGRX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA
245: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JGRX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA
246: FA_RX_UTIL_PKG.assign_column('59', NULL, 'deprn_variation','JGRX_FAREG.var.deprn_variation', 'NUMBER'); -- 09/08/00 AFERRARA

Line 244: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JGRX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA

240: FA_RX_UTIL_PKG.assign_column('54', NULL,'initial_heading','JGRX_FAREG.var.initial_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
241: FA_RX_UTIL_PKG.assign_column('55', '''Variation''','variation_heading','JGRX_FAREG.var.variation_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
242: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',
243: 'JGRX_FAREG.var.final_heading','VARCHAR2', 132); -- 09/08/00 AFERRARA
244: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JGRX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA
245: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JGRX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA
246: FA_RX_UTIL_PKG.assign_column('59', NULL, 'deprn_variation','JGRX_FAREG.var.deprn_variation', 'NUMBER'); -- 09/08/00 AFERRARA
247: FA_RX_UTIL_PKG.assign_column('60', NULL, 'bonus_variation','JGRX_FAREG.var.bonus_variation', 'NUMBER'); -- 09/08/00 AFERRARA
248: FA_RX_UTIL_PKG.assign_column('61', NULL, 'netbo_variation','JGRX_FAREG.var.netbo_variation', 'NUMBER'); -- 09/08/00 AFERRARA

Line 245: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JGRX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA

241: FA_RX_UTIL_PKG.assign_column('55', '''Variation''','variation_heading','JGRX_FAREG.var.variation_heading','VARCHAR2', 15); -- 09/08/00 AFERRARA
242: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',
243: 'JGRX_FAREG.var.final_heading','VARCHAR2', 132); -- 09/08/00 AFERRARA
244: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JGRX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA
245: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JGRX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA
246: FA_RX_UTIL_PKG.assign_column('59', NULL, 'deprn_variation','JGRX_FAREG.var.deprn_variation', 'NUMBER'); -- 09/08/00 AFERRARA
247: FA_RX_UTIL_PKG.assign_column('60', NULL, 'bonus_variation','JGRX_FAREG.var.bonus_variation', 'NUMBER'); -- 09/08/00 AFERRARA
248: FA_RX_UTIL_PKG.assign_column('61', NULL, 'netbo_variation','JGRX_FAREG.var.netbo_variation', 'NUMBER'); -- 09/08/00 AFERRARA
249: FA_RX_UTIL_PKG.assign_column('62', NULL, 'revaluation_total','JGRX_FAREG.var.revaluation_total', 'NUMBER'); -- 09/08/00 AFERRARA

Line 246: FA_RX_UTIL_PKG.assign_column('59', NULL, 'deprn_variation','JGRX_FAREG.var.deprn_variation', 'NUMBER'); -- 09/08/00 AFERRARA

242: FA_RX_UTIL_PKG.assign_column('56', '''------------------------------------------------------------------------------------------------------------------------------------''','final_heading',
243: 'JGRX_FAREG.var.final_heading','VARCHAR2', 132); -- 09/08/00 AFERRARA
244: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JGRX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA
245: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JGRX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA
246: FA_RX_UTIL_PKG.assign_column('59', NULL, 'deprn_variation','JGRX_FAREG.var.deprn_variation', 'NUMBER'); -- 09/08/00 AFERRARA
247: FA_RX_UTIL_PKG.assign_column('60', NULL, 'bonus_variation','JGRX_FAREG.var.bonus_variation', 'NUMBER'); -- 09/08/00 AFERRARA
248: FA_RX_UTIL_PKG.assign_column('61', NULL, 'netbo_variation','JGRX_FAREG.var.netbo_variation', 'NUMBER'); -- 09/08/00 AFERRARA
249: FA_RX_UTIL_PKG.assign_column('62', NULL, 'revaluation_total','JGRX_FAREG.var.revaluation_total', 'NUMBER'); -- 09/08/00 AFERRARA
250: /* FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JGRX_FAREG.var.date_placed_in_service','DATE');

Line 247: FA_RX_UTIL_PKG.assign_column('60', NULL, 'bonus_variation','JGRX_FAREG.var.bonus_variation', 'NUMBER'); -- 09/08/00 AFERRARA

243: 'JGRX_FAREG.var.final_heading','VARCHAR2', 132); -- 09/08/00 AFERRARA
244: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JGRX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA
245: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JGRX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA
246: FA_RX_UTIL_PKG.assign_column('59', NULL, 'deprn_variation','JGRX_FAREG.var.deprn_variation', 'NUMBER'); -- 09/08/00 AFERRARA
247: FA_RX_UTIL_PKG.assign_column('60', NULL, 'bonus_variation','JGRX_FAREG.var.bonus_variation', 'NUMBER'); -- 09/08/00 AFERRARA
248: FA_RX_UTIL_PKG.assign_column('61', NULL, 'netbo_variation','JGRX_FAREG.var.netbo_variation', 'NUMBER'); -- 09/08/00 AFERRARA
249: FA_RX_UTIL_PKG.assign_column('62', NULL, 'revaluation_total','JGRX_FAREG.var.revaluation_total', 'NUMBER'); -- 09/08/00 AFERRARA
250: /* FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JGRX_FAREG.var.date_placed_in_service','DATE');
251: */

Line 248: FA_RX_UTIL_PKG.assign_column('61', NULL, 'netbo_variation','JGRX_FAREG.var.netbo_variation', 'NUMBER'); -- 09/08/00 AFERRARA

244: FA_RX_UTIL_PKG.assign_column('57', NULL, 'asset_variation','JGRX_FAREG.var.asset_variation', 'NUMBER'); -- 09/08/00 AFERRARA
245: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JGRX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA
246: FA_RX_UTIL_PKG.assign_column('59', NULL, 'deprn_variation','JGRX_FAREG.var.deprn_variation', 'NUMBER'); -- 09/08/00 AFERRARA
247: FA_RX_UTIL_PKG.assign_column('60', NULL, 'bonus_variation','JGRX_FAREG.var.bonus_variation', 'NUMBER'); -- 09/08/00 AFERRARA
248: FA_RX_UTIL_PKG.assign_column('61', NULL, 'netbo_variation','JGRX_FAREG.var.netbo_variation', 'NUMBER'); -- 09/08/00 AFERRARA
249: FA_RX_UTIL_PKG.assign_column('62', NULL, 'revaluation_total','JGRX_FAREG.var.revaluation_total', 'NUMBER'); -- 09/08/00 AFERRARA
250: /* FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JGRX_FAREG.var.date_placed_in_service','DATE');
251: */
252: -->>SELECT_END<<--

Line 249: FA_RX_UTIL_PKG.assign_column('62', NULL, 'revaluation_total','JGRX_FAREG.var.revaluation_total', 'NUMBER'); -- 09/08/00 AFERRARA

245: FA_RX_UTIL_PKG.assign_column('58', NULL, 'reval_variation','JGRX_FAREG.var.reval_variation', 'NUMBER'); -- 09/08/00 AFERRARA
246: FA_RX_UTIL_PKG.assign_column('59', NULL, 'deprn_variation','JGRX_FAREG.var.deprn_variation', 'NUMBER'); -- 09/08/00 AFERRARA
247: FA_RX_UTIL_PKG.assign_column('60', NULL, 'bonus_variation','JGRX_FAREG.var.bonus_variation', 'NUMBER'); -- 09/08/00 AFERRARA
248: FA_RX_UTIL_PKG.assign_column('61', NULL, 'netbo_variation','JGRX_FAREG.var.netbo_variation', 'NUMBER'); -- 09/08/00 AFERRARA
249: FA_RX_UTIL_PKG.assign_column('62', NULL, 'revaluation_total','JGRX_FAREG.var.revaluation_total', 'NUMBER'); -- 09/08/00 AFERRARA
250: /* FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JGRX_FAREG.var.date_placed_in_service','DATE');
251: */
252: -->>SELECT_END<<--
253:

Line 250: /* FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JGRX_FAREG.var.date_placed_in_service','DATE');

246: FA_RX_UTIL_PKG.assign_column('59', NULL, 'deprn_variation','JGRX_FAREG.var.deprn_variation', 'NUMBER'); -- 09/08/00 AFERRARA
247: FA_RX_UTIL_PKG.assign_column('60', NULL, 'bonus_variation','JGRX_FAREG.var.bonus_variation', 'NUMBER'); -- 09/08/00 AFERRARA
248: FA_RX_UTIL_PKG.assign_column('61', NULL, 'netbo_variation','JGRX_FAREG.var.netbo_variation', 'NUMBER'); -- 09/08/00 AFERRARA
249: FA_RX_UTIL_PKG.assign_column('62', NULL, 'revaluation_total','JGRX_FAREG.var.revaluation_total', 'NUMBER'); -- 09/08/00 AFERRARA
250: /* FA_RX_UTIL_PKG.assign_column('7', 'BO.date_placed_in_service','date_placed_in_service','JGRX_FAREG.var.date_placed_in_service','DATE');
251: */
252: -->>SELECT_END<<--
253:
254:

Line 258: FA_RX_UTIL_PKG.From_Clause :=

254:
255: --
256: -- Assign From Clause
257: --
258: FA_RX_UTIL_PKG.From_Clause :=
259: 'fa_books BO,
260: fa_additions AD,
261: fa_categories CA,
262: fa_category_books CB,

Line 270: FA_RX_UTIL_PKG.Where_clause:=

266: --
267: -- Assign Where Clause
268: --
269:
270: FA_RX_UTIL_PKG.Where_clause:=
271: ' AD.asset_id = BO.asset_id' ||
272: ' AND AD.in_use_flag = ''YES''' ||
273: ' AND AD.asset_category_id = CA.category_id' ||
274: ' AND (BO.date_effective,transaction_header_id_in) = (SELECT MAX(date_effective),'||

Line 299: FA_RX_UTIL_PKG.Where_Clause := FA_RX_UTIL_PKG.Where_clause || X_where_clause_tmp;

295:
296:
297: -- It takes the segment condition
298: IF X_where_clause_tmp IS NOT NULL THEN
299: FA_RX_UTIL_PKG.Where_Clause := FA_RX_UTIL_PKG.Where_clause || X_where_clause_tmp;
300: END IF;
301:
302: IF PARM.p_book_type_code IS NOT NULL THEN
303: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause ||

Line 303: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause ||

299: FA_RX_UTIL_PKG.Where_Clause := FA_RX_UTIL_PKG.Where_clause || X_where_clause_tmp;
300: END IF;
301:
302: IF PARM.p_book_type_code IS NOT NULL THEN
303: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause ||
304: ' AND BO.book_type_code = :b_book_type_code ';
305: END IF;
306:
307: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_before_report()-');

Line 307: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_before_report()-');

303: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause ||
304: ' AND BO.book_type_code = :b_book_type_code ';
305: END IF;
306:
307: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_before_report()-');
308:
309: END fa_ASSET_before_report;
310:
311:

Line 327: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_bind()+');

323: b_book_type_code VARCHAR2(15);
324: b_fiscal_year_start_date DATE;
325:
326: BEGIN
327: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_bind()+');
328:
329: IF PARM.p_end_period_to_date IS NOT NULL THEN
330: FA_RX_UTIL_PKG.debug('Binding b_period_to_date');
331: DBMS_SQL.bind_variable(c, 'b_period_to_date', PARM.p_end_period_to_date);

Line 330: FA_RX_UTIL_PKG.debug('Binding b_period_to_date');

326: BEGIN
327: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_bind()+');
328:
329: IF PARM.p_end_period_to_date IS NOT NULL THEN
330: FA_RX_UTIL_PKG.debug('Binding b_period_to_date');
331: DBMS_SQL.bind_variable(c, 'b_period_to_date', PARM.p_end_period_to_date);
332: END IF;
333:
334: IF PARM.p_major_category IS NOT NULL THEN

Line 335: FA_RX_UTIL_PKG.debug('Binding major_category');

331: DBMS_SQL.bind_variable(c, 'b_period_to_date', PARM.p_end_period_to_date);
332: END IF;
333:
334: IF PARM.p_major_category IS NOT NULL THEN
335: FA_RX_UTIL_PKG.debug('Binding major_category');
336: DBMS_SQL.bind_variable(c, 'b_major_category', PARM.p_major_category);
337: END IF;
338:
339: IF PARM.p_minor_category IS NOT NULL THEN

Line 340: FA_RX_UTIL_PKG.debug('Binding b_minor_category');

336: DBMS_SQL.bind_variable(c, 'b_major_category', PARM.p_major_category);
337: END IF;
338:
339: IF PARM.p_minor_category IS NOT NULL THEN
340: FA_RX_UTIL_PKG.debug('Binding b_minor_category');
341: DBMS_SQL.bind_variable(c, 'b_minor_category', PARM.p_minor_category);
342: END IF;
343:
344: IF PARM.p_book_type_code IS NOT NULL THEN

Line 345: FA_RX_UTIL_PKG.debug('Binding b_book_type_code');

341: DBMS_SQL.bind_variable(c, 'b_minor_category', PARM.p_minor_category);
342: END IF;
343:
344: IF PARM.p_book_type_code IS NOT NULL THEN
345: FA_RX_UTIL_PKG.debug('Binding b_book_type_code');
346: DBMS_SQL.bind_variable(c, 'b_book_type_code', PARM.p_book_type_code);
347: END IF;
348:
349: IF PARM.p_fiscal_year_start_date IS NOT NULL THEN

Line 350: FA_RX_UTIL_PKG.debug('Binding b_fiscal_year_start_date');

346: DBMS_SQL.bind_variable(c, 'b_book_type_code', PARM.p_book_type_code);
347: END IF;
348:
349: IF PARM.p_fiscal_year_start_date IS NOT NULL THEN
350: FA_RX_UTIL_PKG.debug('Binding b_fiscal_year_start_date');
351: DBMS_SQL.bind_variable(c, 'b_fiscal_year_start_date', PARM.p_fiscal_year_start_date);
352: END IF;
353:
354:

Line 355: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_bind()-');

351: DBMS_SQL.bind_variable(c, 'b_fiscal_year_start_date', PARM.p_fiscal_year_start_date);
352: END IF;
353:
354:
355: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_bind()-');
356:
357: END fa_ASSET_bind;
358:
359:

Line 366: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_after_fetch()+');

362: +====================================================================*/
363: -- The after fetch trigger fires after the Select statement has executed
364: PROCEDURE fa_ASSET_after_fetch IS
365: BEGIN
366: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_after_fetch()+');
367:
368: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_id =' || TO_CHAR(JGRX_FAREG.var.asset_id));
369:
370: --Clear the Parent Asset Number

Line 368: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_id =' || TO_CHAR(JGRX_FAREG.var.asset_id));

364: PROCEDURE fa_ASSET_after_fetch IS
365: BEGIN
366: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_after_fetch()+');
367:
368: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_id =' || TO_CHAR(JGRX_FAREG.var.asset_id));
369:
370: --Clear the Parent Asset Number
371: JGRX_FAREG.var.parent_asset_number := NULL;
372: -- It takes the parent asset number

Line 378: FA_RX_UTIL_PKG.debug('date_placed_in_service'||to_char(JGRX_FAREG.var.date_placed_in_service));

374: JGRX_FAREG.var.parent_asset_number := Get_parent_asset_number;
375: END IF;
376: JGRX_FAREG.var.asset_heading := 'ASSET NUMBER ';
377: JGRX_FAREG.var.starting_deprn_year := to_char(JGRX_FAREG.var.date_placed_in_service,'YYYY');
378: FA_RX_UTIL_PKG.debug('date_placed_in_service'||to_char(JGRX_FAREG.var.date_placed_in_service));
379: FA_RX_UTIL_PKG.debug('Starting deprn Year' || JGRX_FAREG.var.starting_deprn_year);
380: -- It takes the cost values
381:
382:

Line 379: FA_RX_UTIL_PKG.debug('Starting deprn Year' || JGRX_FAREG.var.starting_deprn_year);

375: END IF;
376: JGRX_FAREG.var.asset_heading := 'ASSET NUMBER ';
377: JGRX_FAREG.var.starting_deprn_year := to_char(JGRX_FAREG.var.date_placed_in_service,'YYYY');
378: FA_RX_UTIL_PKG.debug('date_placed_in_service'||to_char(JGRX_FAREG.var.date_placed_in_service));
379: FA_RX_UTIL_PKG.debug('Starting deprn Year' || JGRX_FAREG.var.starting_deprn_year);
380: -- It takes the cost values
381:
382:
383: FA_RX_UTIL_PKG.debug('PARM.p_period_from'||PARM.p_period_from);

Line 383: FA_RX_UTIL_PKG.debug('PARM.p_period_from'||PARM.p_period_from);

379: FA_RX_UTIL_PKG.debug('Starting deprn Year' || JGRX_FAREG.var.starting_deprn_year);
380: -- It takes the cost values
381:
382:
383: FA_RX_UTIL_PKG.debug('PARM.p_period_from'||PARM.p_period_from);
384: FA_RX_UTIL_PKG.debug('PARM.p_period_to'||PARM.p_period_to);
385:
386: JGRX_FAREG.var.expense_account := null;
387: if X_Account_segment <> 'NONE'then

Line 384: FA_RX_UTIL_PKG.debug('PARM.p_period_to'||PARM.p_period_to);

380: -- It takes the cost values
381:
382:
383: FA_RX_UTIL_PKG.debug('PARM.p_period_from'||PARM.p_period_from);
384: FA_RX_UTIL_PKG.debug('PARM.p_period_to'||PARM.p_period_to);
385:
386: JGRX_FAREG.var.expense_account := null;
387: if X_Account_segment <> 'NONE'then
388: Get_Deprn_Accounts;

Line 426: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_after_fetch()-');

422: JGRX_FAREG.var.transaction_code := NULL;
423: JGRX_FAREG.var.transaction_amount := NULL;
424: Get_Transactions;
425:
426: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_after_fetch()-');
427: END fa_ASSET_after_fetch;
428:
429:
430: /*===================================================================+

Line 435: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_after_report()+');

431: | fa_ASSET_after_report |
432: +====================================================================*/
433: PROCEDURE fa_ASSET_after_report IS
434: BEGIN
435: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_after_report()+');
436:
437: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_after_report()-');
438: END fa_ASSET_after_report;
439:

Line 437: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_after_report()-');

433: PROCEDURE fa_ASSET_after_report IS
434: BEGIN
435: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_after_report()+');
436:
437: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_after_report()-');
438: END fa_ASSET_after_report;
439:
440:
441: /*****************************************************************************************************

Line 459: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_before_report()+');

455: IS
456:
457:
458: BEGIN
459: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_before_report()+');
460:
461:
462: -- It takes the segment condition, Company name, currency code and store in placeholder variable
463: Startup;

Line 468: -- FA_RX_UTIL_PKG.assign_column(#, select, insert, place, type, len);

464:
465: --Assign SELECT list
466: -- the Select statement is build over here
467:
468: -- FA_RX_UTIL_PKG.assign_column(#, select, insert, place, type, len);
469:
470:
471: -->>SELECT_START<<--
472:

Line 473: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JGRX_FAREG.var.organization_name','VARCHAR2',60);

469:
470:
471: -->>SELECT_START<<--
472:
473: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JGRX_FAREG.var.organization_name','VARCHAR2',60);
474: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JGRX_FAREG.var.functional_currency_code', 'VARCHAR2',15);
475:
476: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JGRX_FAREG.var.major_category','VARCHAR2', 30);
477: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JGRX_FAREG.var.minor_category','VARCHAR2', 30);

Line 474: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JGRX_FAREG.var.functional_currency_code', 'VARCHAR2',15);

470:
471: -->>SELECT_START<<--
472:
473: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JGRX_FAREG.var.organization_name','VARCHAR2',60);
474: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JGRX_FAREG.var.functional_currency_code', 'VARCHAR2',15);
475:
476: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JGRX_FAREG.var.major_category','VARCHAR2', 30);
477: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JGRX_FAREG.var.minor_category','VARCHAR2', 30);
478:

Line 476: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JGRX_FAREG.var.major_category','VARCHAR2', 30);

472:
473: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JGRX_FAREG.var.organization_name','VARCHAR2',60);
474: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JGRX_FAREG.var.functional_currency_code', 'VARCHAR2',15);
475:
476: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JGRX_FAREG.var.major_category','VARCHAR2', 30);
477: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JGRX_FAREG.var.minor_category','VARCHAR2', 30);
478:
479: FA_RX_UTIL_PKG.assign_column('5', 'AD.asset_number', 'asset_number','JGRX_FAREG.var.asset_number','VARCHAR2', 15);
480: FA_RX_UTIL_PKG.assign_column('6', 'AD.description', 'description','JGRX_FAREG.var.description','VARCHAR2', 80);

Line 477: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JGRX_FAREG.var.minor_category','VARCHAR2', 30);

473: FA_RX_UTIL_PKG.assign_column('1', NULL, 'organization_name','JGRX_FAREG.var.organization_name','VARCHAR2',60);
474: FA_RX_UTIL_PKG.assign_column('2', NULL, 'functional_currency_code','JGRX_FAREG.var.functional_currency_code', 'VARCHAR2',15);
475:
476: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JGRX_FAREG.var.major_category','VARCHAR2', 30);
477: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JGRX_FAREG.var.minor_category','VARCHAR2', 30);
478:
479: FA_RX_UTIL_PKG.assign_column('5', 'AD.asset_number', 'asset_number','JGRX_FAREG.var.asset_number','VARCHAR2', 15);
480: FA_RX_UTIL_PKG.assign_column('6', 'AD.description', 'description','JGRX_FAREG.var.description','VARCHAR2', 80);
481:

Line 479: FA_RX_UTIL_PKG.assign_column('5', 'AD.asset_number', 'asset_number','JGRX_FAREG.var.asset_number','VARCHAR2', 15);

475:
476: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JGRX_FAREG.var.major_category','VARCHAR2', 30);
477: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JGRX_FAREG.var.minor_category','VARCHAR2', 30);
478:
479: FA_RX_UTIL_PKG.assign_column('5', 'AD.asset_number', 'asset_number','JGRX_FAREG.var.asset_number','VARCHAR2', 15);
480: FA_RX_UTIL_PKG.assign_column('6', 'AD.description', 'description','JGRX_FAREG.var.description','VARCHAR2', 80);
481:
482: FA_RX_UTIL_PKG.assign_column('7', 'AD.parent_asset_id', NULL,'JGRX_FAREG.var.parent_asset_id','NUMBER');
483: FA_RX_UTIL_PKG.assign_column('8', NULL, 'parent_asset_number','JGRX_FAREG.var.parent_asset_number','VARCHAR2', 15);

Line 480: FA_RX_UTIL_PKG.assign_column('6', 'AD.description', 'description','JGRX_FAREG.var.description','VARCHAR2', 80);

476: FA_RX_UTIL_PKG.assign_column('3', 'CA.' || X_major_segment, 'major_category','JGRX_FAREG.var.major_category','VARCHAR2', 30);
477: FA_RX_UTIL_PKG.assign_column('4', X_minor_segment_sel, 'minor_category','JGRX_FAREG.var.minor_category','VARCHAR2', 30);
478:
479: FA_RX_UTIL_PKG.assign_column('5', 'AD.asset_number', 'asset_number','JGRX_FAREG.var.asset_number','VARCHAR2', 15);
480: FA_RX_UTIL_PKG.assign_column('6', 'AD.description', 'description','JGRX_FAREG.var.description','VARCHAR2', 80);
481:
482: FA_RX_UTIL_PKG.assign_column('7', 'AD.parent_asset_id', NULL,'JGRX_FAREG.var.parent_asset_id','NUMBER');
483: FA_RX_UTIL_PKG.assign_column('8', NULL, 'parent_asset_number','JGRX_FAREG.var.parent_asset_number','VARCHAR2', 15);
484:

Line 482: FA_RX_UTIL_PKG.assign_column('7', 'AD.parent_asset_id', NULL,'JGRX_FAREG.var.parent_asset_id','NUMBER');

478:
479: FA_RX_UTIL_PKG.assign_column('5', 'AD.asset_number', 'asset_number','JGRX_FAREG.var.asset_number','VARCHAR2', 15);
480: FA_RX_UTIL_PKG.assign_column('6', 'AD.description', 'description','JGRX_FAREG.var.description','VARCHAR2', 80);
481:
482: FA_RX_UTIL_PKG.assign_column('7', 'AD.parent_asset_id', NULL,'JGRX_FAREG.var.parent_asset_id','NUMBER');
483: FA_RX_UTIL_PKG.assign_column('8', NULL, 'parent_asset_number','JGRX_FAREG.var.parent_asset_number','VARCHAR2', 15);
484:
485: FA_RX_UTIL_PKG.assign_column('9', 'BO.original_cost', 'asset_cost_orig','JGRX_FAREG.var.asset_cost_orig','NUMBER');
486: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JGRX_FAREG.var.sales_amount','NUMBER');

Line 483: FA_RX_UTIL_PKG.assign_column('8', NULL, 'parent_asset_number','JGRX_FAREG.var.parent_asset_number','VARCHAR2', 15);

479: FA_RX_UTIL_PKG.assign_column('5', 'AD.asset_number', 'asset_number','JGRX_FAREG.var.asset_number','VARCHAR2', 15);
480: FA_RX_UTIL_PKG.assign_column('6', 'AD.description', 'description','JGRX_FAREG.var.description','VARCHAR2', 80);
481:
482: FA_RX_UTIL_PKG.assign_column('7', 'AD.parent_asset_id', NULL,'JGRX_FAREG.var.parent_asset_id','NUMBER');
483: FA_RX_UTIL_PKG.assign_column('8', NULL, 'parent_asset_number','JGRX_FAREG.var.parent_asset_number','VARCHAR2', 15);
484:
485: FA_RX_UTIL_PKG.assign_column('9', 'BO.original_cost', 'asset_cost_orig','JGRX_FAREG.var.asset_cost_orig','NUMBER');
486: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JGRX_FAREG.var.sales_amount','NUMBER');
487: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JGRX_FAREG.var.cost_retired','NUMBER');

Line 485: FA_RX_UTIL_PKG.assign_column('9', 'BO.original_cost', 'asset_cost_orig','JGRX_FAREG.var.asset_cost_orig','NUMBER');

481:
482: FA_RX_UTIL_PKG.assign_column('7', 'AD.parent_asset_id', NULL,'JGRX_FAREG.var.parent_asset_id','NUMBER');
483: FA_RX_UTIL_PKG.assign_column('8', NULL, 'parent_asset_number','JGRX_FAREG.var.parent_asset_number','VARCHAR2', 15);
484:
485: FA_RX_UTIL_PKG.assign_column('9', 'BO.original_cost', 'asset_cost_orig','JGRX_FAREG.var.asset_cost_orig','NUMBER');
486: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JGRX_FAREG.var.sales_amount','NUMBER');
487: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JGRX_FAREG.var.cost_retired','NUMBER');
488: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JGRX_FAREG.var.deprn_reserve','NUMBER');
489: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JGRX_FAREG.var.bonus_reserve','NUMBER');

Line 486: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JGRX_FAREG.var.sales_amount','NUMBER');

482: FA_RX_UTIL_PKG.assign_column('7', 'AD.parent_asset_id', NULL,'JGRX_FAREG.var.parent_asset_id','NUMBER');
483: FA_RX_UTIL_PKG.assign_column('8', NULL, 'parent_asset_number','JGRX_FAREG.var.parent_asset_number','VARCHAR2', 15);
484:
485: FA_RX_UTIL_PKG.assign_column('9', 'BO.original_cost', 'asset_cost_orig','JGRX_FAREG.var.asset_cost_orig','NUMBER');
486: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JGRX_FAREG.var.sales_amount','NUMBER');
487: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JGRX_FAREG.var.cost_retired','NUMBER');
488: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JGRX_FAREG.var.deprn_reserve','NUMBER');
489: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JGRX_FAREG.var.bonus_reserve','NUMBER');
490: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JGRX_FAREG.var.net_book_value','NUMBER');

Line 487: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JGRX_FAREG.var.cost_retired','NUMBER');

483: FA_RX_UTIL_PKG.assign_column('8', NULL, 'parent_asset_number','JGRX_FAREG.var.parent_asset_number','VARCHAR2', 15);
484:
485: FA_RX_UTIL_PKG.assign_column('9', 'BO.original_cost', 'asset_cost_orig','JGRX_FAREG.var.asset_cost_orig','NUMBER');
486: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JGRX_FAREG.var.sales_amount','NUMBER');
487: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JGRX_FAREG.var.cost_retired','NUMBER');
488: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JGRX_FAREG.var.deprn_reserve','NUMBER');
489: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JGRX_FAREG.var.bonus_reserve','NUMBER');
490: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JGRX_FAREG.var.net_book_value','NUMBER');
491: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JGRX_FAREG.var.gain_loss','NUMBER');

Line 488: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JGRX_FAREG.var.deprn_reserve','NUMBER');

484:
485: FA_RX_UTIL_PKG.assign_column('9', 'BO.original_cost', 'asset_cost_orig','JGRX_FAREG.var.asset_cost_orig','NUMBER');
486: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JGRX_FAREG.var.sales_amount','NUMBER');
487: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JGRX_FAREG.var.cost_retired','NUMBER');
488: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JGRX_FAREG.var.deprn_reserve','NUMBER');
489: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JGRX_FAREG.var.bonus_reserve','NUMBER');
490: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JGRX_FAREG.var.net_book_value','NUMBER');
491: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JGRX_FAREG.var.gain_loss','NUMBER');
492: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JGRX_FAREG.var.invoice_number','VARCHAR2', 50);

Line 489: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JGRX_FAREG.var.bonus_reserve','NUMBER');

485: FA_RX_UTIL_PKG.assign_column('9', 'BO.original_cost', 'asset_cost_orig','JGRX_FAREG.var.asset_cost_orig','NUMBER');
486: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JGRX_FAREG.var.sales_amount','NUMBER');
487: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JGRX_FAREG.var.cost_retired','NUMBER');
488: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JGRX_FAREG.var.deprn_reserve','NUMBER');
489: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JGRX_FAREG.var.bonus_reserve','NUMBER');
490: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JGRX_FAREG.var.net_book_value','NUMBER');
491: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JGRX_FAREG.var.gain_loss','NUMBER');
492: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JGRX_FAREG.var.invoice_number','VARCHAR2', 50);
493: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JGRX_FAREG.var.asset_id','NUMBER');

Line 490: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JGRX_FAREG.var.net_book_value','NUMBER');

486: FA_RX_UTIL_PKG.assign_column('10', 'RE.proceeds_of_sale', 'sales_amount','JGRX_FAREG.var.sales_amount','NUMBER');
487: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JGRX_FAREG.var.cost_retired','NUMBER');
488: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JGRX_FAREG.var.deprn_reserve','NUMBER');
489: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JGRX_FAREG.var.bonus_reserve','NUMBER');
490: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JGRX_FAREG.var.net_book_value','NUMBER');
491: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JGRX_FAREG.var.gain_loss','NUMBER');
492: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JGRX_FAREG.var.invoice_number','VARCHAR2', 50);
493: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JGRX_FAREG.var.asset_id','NUMBER');
494: FA_RX_UTIL_PKG.assign_column('18', 'RE.date_retired', 'date_retired','JGRX_FAREG.var.date_retired','DATE');

Line 491: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JGRX_FAREG.var.gain_loss','NUMBER');

487: FA_RX_UTIL_PKG.assign_column('11', 'RE.cost_retired', 'cost_retired','JGRX_FAREG.var.cost_retired','NUMBER');
488: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JGRX_FAREG.var.deprn_reserve','NUMBER');
489: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JGRX_FAREG.var.bonus_reserve','NUMBER');
490: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JGRX_FAREG.var.net_book_value','NUMBER');
491: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JGRX_FAREG.var.gain_loss','NUMBER');
492: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JGRX_FAREG.var.invoice_number','VARCHAR2', 50);
493: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JGRX_FAREG.var.asset_id','NUMBER');
494: FA_RX_UTIL_PKG.assign_column('18', 'RE.date_retired', 'date_retired','JGRX_FAREG.var.date_retired','DATE');
495: FA_RX_UTIL_PKG.assign_column('19', 'RE.transaction_header_id_in', NULL,'JGRX_FAREG.var.transaction_header_id','NUMBER');

Line 492: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JGRX_FAREG.var.invoice_number','VARCHAR2', 50);

488: FA_RX_UTIL_PKG.assign_column('12', NULL, 'deprn_reserve','JGRX_FAREG.var.deprn_reserve','NUMBER');
489: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JGRX_FAREG.var.bonus_reserve','NUMBER');
490: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JGRX_FAREG.var.net_book_value','NUMBER');
491: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JGRX_FAREG.var.gain_loss','NUMBER');
492: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JGRX_FAREG.var.invoice_number','VARCHAR2', 50);
493: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JGRX_FAREG.var.asset_id','NUMBER');
494: FA_RX_UTIL_PKG.assign_column('18', 'RE.date_retired', 'date_retired','JGRX_FAREG.var.date_retired','DATE');
495: FA_RX_UTIL_PKG.assign_column('19', 'RE.transaction_header_id_in', NULL,'JGRX_FAREG.var.transaction_header_id','NUMBER');
496: FA_RX_UTIL_PKG.assign_column('20', NULL,'asset_heading','JGRX_FAREG.var.asset_heading','VARCHAR2', 15);

Line 493: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JGRX_FAREG.var.asset_id','NUMBER');

489: FA_RX_UTIL_PKG.assign_column('13', NULL, 'bonus_reserve','JGRX_FAREG.var.bonus_reserve','NUMBER');
490: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JGRX_FAREG.var.net_book_value','NUMBER');
491: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JGRX_FAREG.var.gain_loss','NUMBER');
492: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JGRX_FAREG.var.invoice_number','VARCHAR2', 50);
493: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JGRX_FAREG.var.asset_id','NUMBER');
494: FA_RX_UTIL_PKG.assign_column('18', 'RE.date_retired', 'date_retired','JGRX_FAREG.var.date_retired','DATE');
495: FA_RX_UTIL_PKG.assign_column('19', 'RE.transaction_header_id_in', NULL,'JGRX_FAREG.var.transaction_header_id','NUMBER');
496: FA_RX_UTIL_PKG.assign_column('20', NULL,'asset_heading','JGRX_FAREG.var.asset_heading','VARCHAR2', 15);
497: -->>SELECT_END<<--

Line 494: FA_RX_UTIL_PKG.assign_column('18', 'RE.date_retired', 'date_retired','JGRX_FAREG.var.date_retired','DATE');

490: FA_RX_UTIL_PKG.assign_column('14', 'RE.nbv_retired', 'net_book_value','JGRX_FAREG.var.net_book_value','NUMBER');
491: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JGRX_FAREG.var.gain_loss','NUMBER');
492: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JGRX_FAREG.var.invoice_number','VARCHAR2', 50);
493: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JGRX_FAREG.var.asset_id','NUMBER');
494: FA_RX_UTIL_PKG.assign_column('18', 'RE.date_retired', 'date_retired','JGRX_FAREG.var.date_retired','DATE');
495: FA_RX_UTIL_PKG.assign_column('19', 'RE.transaction_header_id_in', NULL,'JGRX_FAREG.var.transaction_header_id','NUMBER');
496: FA_RX_UTIL_PKG.assign_column('20', NULL,'asset_heading','JGRX_FAREG.var.asset_heading','VARCHAR2', 15);
497: -->>SELECT_END<<--
498:

Line 495: FA_RX_UTIL_PKG.assign_column('19', 'RE.transaction_header_id_in', NULL,'JGRX_FAREG.var.transaction_header_id','NUMBER');

491: FA_RX_UTIL_PKG.assign_column('15', 'RE.gain_loss_amount', 'gain_loss','JGRX_FAREG.var.gain_loss','NUMBER');
492: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JGRX_FAREG.var.invoice_number','VARCHAR2', 50);
493: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JGRX_FAREG.var.asset_id','NUMBER');
494: FA_RX_UTIL_PKG.assign_column('18', 'RE.date_retired', 'date_retired','JGRX_FAREG.var.date_retired','DATE');
495: FA_RX_UTIL_PKG.assign_column('19', 'RE.transaction_header_id_in', NULL,'JGRX_FAREG.var.transaction_header_id','NUMBER');
496: FA_RX_UTIL_PKG.assign_column('20', NULL,'asset_heading','JGRX_FAREG.var.asset_heading','VARCHAR2', 15);
497: -->>SELECT_END<<--
498:
499:

Line 496: FA_RX_UTIL_PKG.assign_column('20', NULL,'asset_heading','JGRX_FAREG.var.asset_heading','VARCHAR2', 15);

492: FA_RX_UTIL_PKG.assign_column('16', 'RE.reference_num', 'invoice_number','JGRX_FAREG.var.invoice_number','VARCHAR2', 50);
493: FA_RX_UTIL_PKG.assign_column('17', 'RE.asset_id', NULL,'JGRX_FAREG.var.asset_id','NUMBER');
494: FA_RX_UTIL_PKG.assign_column('18', 'RE.date_retired', 'date_retired','JGRX_FAREG.var.date_retired','DATE');
495: FA_RX_UTIL_PKG.assign_column('19', 'RE.transaction_header_id_in', NULL,'JGRX_FAREG.var.transaction_header_id','NUMBER');
496: FA_RX_UTIL_PKG.assign_column('20', NULL,'asset_heading','JGRX_FAREG.var.asset_heading','VARCHAR2', 15);
497: -->>SELECT_END<<--
498:
499:
500: --

Line 503: FA_RX_UTIL_PKG.From_Clause :=

499:
500: --
501: -- Assign From Clause
502: --
503: FA_RX_UTIL_PKG.From_Clause :=
504: 'fa_retirements re,
505: fa_additions ad,
506: fa_categories ca,
507: fa_books bo';

Line 514: FA_RX_UTIL_PKG.Where_clause:=

510: --
511: -- Assign Where Clause
512: --
513:
514: FA_RX_UTIL_PKG.Where_clause:=
515: ' AD.asset_id = RE.ASSET_ID' ||
516: ' AND RE.STATUS = ''PROCESSED'''||
517: ' AND AD.asset_category_id = CA.category_id' ||
518: ' AND AD.asset_id = BO.asset_id' ||

Line 534: FA_RX_UTIL_PKG.Where_Clause := FA_RX_UTIL_PKG.Where_clause || X_where_clause_tmp;

530: ' AND asset_id = BO.asset_id)';
531:
532: -- It takes the segment condition
533: IF X_where_clause_tmp IS NOT NULL THEN
534: FA_RX_UTIL_PKG.Where_Clause := FA_RX_UTIL_PKG.Where_clause || X_where_clause_tmp;
535: END IF;
536:
537: IF PARM.p_book_type_code IS NOT NULL THEN
538: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause ||

Line 538: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause ||

534: FA_RX_UTIL_PKG.Where_Clause := FA_RX_UTIL_PKG.Where_clause || X_where_clause_tmp;
535: END IF;
536:
537: IF PARM.p_book_type_code IS NOT NULL THEN
538: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause ||
539: ' AND BO.book_type_code = :b_book_type_code ';
540: END IF;
541: -- Both parameters are not null...anyway
542: IF PARM.p_begin_period_from_date IS NOT NULL AND PARM.p_end_period_to_date IS NOT NULL THEN

Line 543: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause || ' AND RE.date_retired ' ||

539: ' AND BO.book_type_code = :b_book_type_code ';
540: END IF;
541: -- Both parameters are not null...anyway
542: IF PARM.p_begin_period_from_date IS NOT NULL AND PARM.p_end_period_to_date IS NOT NULL THEN
543: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause || ' AND RE.date_retired ' ||
544: 'BETWEEN :b_period_from_date AND :b_period_to_date ';
545: END IF;
546:
547: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_before_report()-');

Line 547: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_before_report()-');

543: FA_RX_UTIL_PKG.Where_clause := FA_RX_UTIL_PKG.Where_clause || ' AND RE.date_retired ' ||
544: 'BETWEEN :b_period_from_date AND :b_period_to_date ';
545: END IF;
546:
547: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_before_report()-');
548:
549: END fa_RTRMNT_before_report;
550:
551:

Line 566: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_bind()+');

562: b_period_to_date VARCHAR2(20);
563: b_book_type_code VARCHAR2(15);
564:
565: BEGIN
566: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_bind()+');
567:
568: IF PARM.p_begin_period_from_date IS NOT NULL THEN
569: FA_RX_UTIL_PKG.debug('Binding b_period_from_date');
570: DBMS_SQL.bind_variable(c, 'b_period_from_date', PARM.p_begin_period_from_date);

Line 569: FA_RX_UTIL_PKG.debug('Binding b_period_from_date');

565: BEGIN
566: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_bind()+');
567:
568: IF PARM.p_begin_period_from_date IS NOT NULL THEN
569: FA_RX_UTIL_PKG.debug('Binding b_period_from_date');
570: DBMS_SQL.bind_variable(c, 'b_period_from_date', PARM.p_begin_period_from_date);
571: END IF;
572:
573: IF PARM.p_end_period_to_date IS NOT NULL THEN

Line 574: FA_RX_UTIL_PKG.debug('Binding b_period_to_date');

570: DBMS_SQL.bind_variable(c, 'b_period_from_date', PARM.p_begin_period_from_date);
571: END IF;
572:
573: IF PARM.p_end_period_to_date IS NOT NULL THEN
574: FA_RX_UTIL_PKG.debug('Binding b_period_to_date');
575: DBMS_SQL.bind_variable(c, 'b_period_to_date', PARM.p_end_period_to_date);
576: END IF;
577:
578: IF PARM.p_major_category IS NOT NULL THEN

Line 579: FA_RX_UTIL_PKG.debug('Binding major_category');

575: DBMS_SQL.bind_variable(c, 'b_period_to_date', PARM.p_end_period_to_date);
576: END IF;
577:
578: IF PARM.p_major_category IS NOT NULL THEN
579: FA_RX_UTIL_PKG.debug('Binding major_category');
580: DBMS_SQL.bind_variable(c, 'b_major_category', PARM.p_major_category);
581: END IF;
582:
583: IF PARM.p_minor_category IS NOT NULL THEN

Line 584: FA_RX_UTIL_PKG.debug('Binding b_minor_category');

580: DBMS_SQL.bind_variable(c, 'b_major_category', PARM.p_major_category);
581: END IF;
582:
583: IF PARM.p_minor_category IS NOT NULL THEN
584: FA_RX_UTIL_PKG.debug('Binding b_minor_category');
585: DBMS_SQL.bind_variable(c, 'b_minor_category', PARM.p_minor_category);
586: END IF;
587:
588: IF PARM.p_book_type_code IS NOT NULL THEN

Line 589: FA_RX_UTIL_PKG.debug('Binding b_book_type_code');

585: DBMS_SQL.bind_variable(c, 'b_minor_category', PARM.p_minor_category);
586: END IF;
587:
588: IF PARM.p_book_type_code IS NOT NULL THEN
589: FA_RX_UTIL_PKG.debug('Binding b_book_type_code');
590: DBMS_SQL.bind_variable(c, 'b_book_type_code', PARM.p_book_type_code);
591: END IF;
592:
593: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_bind()-');

Line 593: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_bind()-');

589: FA_RX_UTIL_PKG.debug('Binding b_book_type_code');
590: DBMS_SQL.bind_variable(c, 'b_book_type_code', PARM.p_book_type_code);
591: END IF;
592:
593: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_bind()-');
594:
595: END fa_RTRMNT_bind;
596:
597:

Line 604: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_after_fetch()+');

600: +====================================================================*/
601: -- The after fetch trigger fires after the Select statement has executed
602: PROCEDURE fa_RTRMNT_after_fetch IS
603: BEGIN
604: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_after_fetch()+');
605:
606: -- It takes the parent asset number
607:
608: JGRX_FAREG.var.parent_asset_number := null;

Line 618: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_after_fetch()-');

614:
615: -- It takes the reserve values
616: Get_RTRMNT_reserve;
617:
618: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_after_fetch()-');
619: END fa_RTRMNT_after_fetch;
620:
621:
622: /*===================================================================+

Line 627: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_after_report()+');

623: | fa_RTRMNT_after_report |
624: +====================================================================*/
625: PROCEDURE fa_RTRMNT_after_report IS
626: BEGIN
627: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_after_report()+');
628:
629:
630: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_after_report()-');
631: END fa_RTRMNT_after_report;

Line 630: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_after_report()-');

626: BEGIN
627: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_after_report()+');
628:
629:
630: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_after_report()-');
631: END fa_RTRMNT_after_report;
632:
633:
634: /*===================================================================+

Line 643: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_Account_segment()+');

639: X_Account_Segment Varchar2(50);
640: X_ret BOOLEAN := TRUE;
641: X_id_flex_num Number(15);
642: Begin
643: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_Account_segment()+');
644:
645: select sob.chart_of_accounts_id
646: into X_id_flex_num
647: from gl_sets_of_books sob,

Line 659: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Account_segment'||X_account_segment);

655: X_id_flex_Num, -- x_id_flex_num in
656: 'GL_ACCOUNT', -- x_seg_attr_type
657: X_Account_segment); -- x_app_column_name
658: If X_ret = TRUE then
659: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Account_segment'||X_account_segment);
660: return (X_Account_Segment);
661: else
662: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Account_segment'||'NONE');
663: return ('NONE');

Line 662: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Account_segment'||'NONE');

658: If X_ret = TRUE then
659: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Account_segment'||X_account_segment);
660: return (X_Account_Segment);
661: else
662: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Account_segment'||'NONE');
663: return ('NONE');
664: end if;
665: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_Account_segment()-');
666:

Line 665: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_Account_segment()-');

661: else
662: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Account_segment'||'NONE');
663: return ('NONE');
664: end if;
665: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_Account_segment()-');
666:
667: end Get_Account_Segment;
668:
669: /*===================================================================+

Line 680: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_category_segment()+');

676: X_ret BOOLEAN := TRUE;
677: X_msg VARCHAR2(100);
678:
679: BEGIN
680: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_category_segment()+');
681:
682: -- Takes major segment
683: X_ret := FND_FLEX_APIS.get_segment_column(
684: 140, -- x_application_id

Line 692: FA_RX_UTIL_PKG.debug(X_msg);

688: X_major_segment); -- x_app_column_name
689:
690: IF X_ret = FALSE THEN
691: X_msg := 'JGRX_FAREG.Get_category_segment: error retrieving MAJOR SEGMENT';
692: FA_RX_UTIL_PKG.debug(X_msg);
693: RAISE_APPLICATION_ERROR(-20010,X_msg);
694: ELSIF PARM.p_major_category IS NOT NULL THEN
695: -- Building major segment condition
696: FA_RX_UTIL_PKG.debug('Major Category');

Line 696: FA_RX_UTIL_PKG.debug('Major Category');

692: FA_RX_UTIL_PKG.debug(X_msg);
693: RAISE_APPLICATION_ERROR(-20010,X_msg);
694: ELSIF PARM.p_major_category IS NOT NULL THEN
695: -- Building major segment condition
696: FA_RX_UTIL_PKG.debug('Major Category');
697: X_where_clause := ' AND CA.' || X_major_segment || ' = :b_major_category ';
698: END IF;
699:
700: -- Takes minor segment

Line 710: FA_RX_UTIL_PKG.debug(X_msg);

706: X_minor_segment); -- x_app_column_name
707:
708: IF X_ret = FALSE THEN
709: X_msg := 'JGRX_FAREG.Get_category_segment: error retrieving MINOR SEGMENT';
710: FA_RX_UTIL_PKG.debug(X_msg);
711: X_minor_segment_sel := 'NULL';
712: -- RAISE_APPLICATION_ERROR(-20010,X_msg);
713: ELSIF PARM.p_minor_category IS NOT NULL THEN
714: -- Building minor segment condition

Line 723: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_category_segment()-');

719: IF X_ret <> FALSE and PARM.p_minor_category IS NULL THEN
720: X_minor_segment_sel := 'CA.'||X_minor_segment;
721: END IF;
722:
723: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_category_segment()-');
724:
725: RETURN X_where_clause;
726:
727: END Get_category_segment;

Line 741: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_period_date()+');

737: IS
738:
739: X_msg VARCHAR2(100);
740: BEGIN
741: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_period_date()+');
742:
743: PARM.p_period_from := p_period_from;
744: PARM.p_period_to := p_period_to;
745:

Line 748: FA_RX_UTIL_PKG.debug('Get period date from');

744: PARM.p_period_to := p_period_to;
745:
746: -- Both period are required by anyway...
747: IF PARM.p_period_from IS NOT NULL THEN
748: FA_RX_UTIL_PKG.debug('Get period date from');
749:
750: SELECT calendar_period_open_date,
751: calendar_period_close_date,
752: period_counter,

Line 767: FA_RX_UTIL_PKG.debug('Get period date to');

763: AND period_name = PARM.p_period_from;
764: END IF;
765:
766: IF PARM.p_period_to IS NOT NULL THEN
767: FA_RX_UTIL_PKG.debug('Get period date to');
768:
769: SELECT calendar_period_open_date,
770: calendar_period_close_date,
771: period_counter

Line 784: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_from_date ' || to_char(PARM.p_begin_period_from_date));

780: AND period_name = PARM.p_period_to;
781: END IF;
782:
783:
784: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_from_date ' || to_char(PARM.p_begin_period_from_date));
785: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_to_date ' || to_char(PARM.p_begin_period_to_date));
786: FA_RX_UTIL_PKG.debug('PARM.p_end_period_from_date ' || to_char(PARM.p_end_period_from_date));
787: FA_RX_UTIL_PKG.debug('PARM.p_end_period_to_date ' || to_char(PARM.p_end_period_to_date));
788: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_counter ' || to_char(PARM.p_begin_period_counter));

Line 785: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_to_date ' || to_char(PARM.p_begin_period_to_date));

781: END IF;
782:
783:
784: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_from_date ' || to_char(PARM.p_begin_period_from_date));
785: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_to_date ' || to_char(PARM.p_begin_period_to_date));
786: FA_RX_UTIL_PKG.debug('PARM.p_end_period_from_date ' || to_char(PARM.p_end_period_from_date));
787: FA_RX_UTIL_PKG.debug('PARM.p_end_period_to_date ' || to_char(PARM.p_end_period_to_date));
788: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_counter ' || to_char(PARM.p_begin_period_counter));
789: FA_RX_UTIL_PKG.debug('PARM.p_end_period_counter'|| to_char(PARM.p_end_period_counter));

Line 786: FA_RX_UTIL_PKG.debug('PARM.p_end_period_from_date ' || to_char(PARM.p_end_period_from_date));

782:
783:
784: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_from_date ' || to_char(PARM.p_begin_period_from_date));
785: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_to_date ' || to_char(PARM.p_begin_period_to_date));
786: FA_RX_UTIL_PKG.debug('PARM.p_end_period_from_date ' || to_char(PARM.p_end_period_from_date));
787: FA_RX_UTIL_PKG.debug('PARM.p_end_period_to_date ' || to_char(PARM.p_end_period_to_date));
788: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_counter ' || to_char(PARM.p_begin_period_counter));
789: FA_RX_UTIL_PKG.debug('PARM.p_end_period_counter'|| to_char(PARM.p_end_period_counter));
790:

Line 787: FA_RX_UTIL_PKG.debug('PARM.p_end_period_to_date ' || to_char(PARM.p_end_period_to_date));

783:
784: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_from_date ' || to_char(PARM.p_begin_period_from_date));
785: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_to_date ' || to_char(PARM.p_begin_period_to_date));
786: FA_RX_UTIL_PKG.debug('PARM.p_end_period_from_date ' || to_char(PARM.p_end_period_from_date));
787: FA_RX_UTIL_PKG.debug('PARM.p_end_period_to_date ' || to_char(PARM.p_end_period_to_date));
788: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_counter ' || to_char(PARM.p_begin_period_counter));
789: FA_RX_UTIL_PKG.debug('PARM.p_end_period_counter'|| to_char(PARM.p_end_period_counter));
790:
791: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_period_date()-');

Line 788: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_counter ' || to_char(PARM.p_begin_period_counter));

784: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_from_date ' || to_char(PARM.p_begin_period_from_date));
785: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_to_date ' || to_char(PARM.p_begin_period_to_date));
786: FA_RX_UTIL_PKG.debug('PARM.p_end_period_from_date ' || to_char(PARM.p_end_period_from_date));
787: FA_RX_UTIL_PKG.debug('PARM.p_end_period_to_date ' || to_char(PARM.p_end_period_to_date));
788: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_counter ' || to_char(PARM.p_begin_period_counter));
789: FA_RX_UTIL_PKG.debug('PARM.p_end_period_counter'|| to_char(PARM.p_end_period_counter));
790:
791: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_period_date()-');
792:

Line 789: FA_RX_UTIL_PKG.debug('PARM.p_end_period_counter'|| to_char(PARM.p_end_period_counter));

785: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_to_date ' || to_char(PARM.p_begin_period_to_date));
786: FA_RX_UTIL_PKG.debug('PARM.p_end_period_from_date ' || to_char(PARM.p_end_period_from_date));
787: FA_RX_UTIL_PKG.debug('PARM.p_end_period_to_date ' || to_char(PARM.p_end_period_to_date));
788: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_counter ' || to_char(PARM.p_begin_period_counter));
789: FA_RX_UTIL_PKG.debug('PARM.p_end_period_counter'|| to_char(PARM.p_end_period_counter));
790:
791: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_period_date()-');
792:
793: EXCEPTION

Line 791: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_period_date()-');

787: FA_RX_UTIL_PKG.debug('PARM.p_end_period_to_date ' || to_char(PARM.p_end_period_to_date));
788: FA_RX_UTIL_PKG.debug('PARM.p_begin_period_counter ' || to_char(PARM.p_begin_period_counter));
789: FA_RX_UTIL_PKG.debug('PARM.p_end_period_counter'|| to_char(PARM.p_end_period_counter));
790:
791: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_period_date()-');
792:
793: EXCEPTION
794: WHEN NO_DATA_FOUND THEN
795: X_msg := 'JGRX_FAREG.Get_period_date: NO_DATA_FOUND';

Line 796: FA_RX_UTIL_PKG.debug(X_msg);

792:
793: EXCEPTION
794: WHEN NO_DATA_FOUND THEN
795: X_msg := 'JGRX_FAREG.Get_period_date: NO_DATA_FOUND';
796: FA_RX_UTIL_PKG.debug(X_msg);
797: RAISE_APPLICATION_ERROR(-20010,X_msg);
798:
799: WHEN TOO_MANY_ROWS THEN
800: X_msg := 'JGRX_FAREG.Get_period_date: TOO_MANY_ROWS';

Line 801: FA_RX_UTIL_PKG.debug(X_msg);

797: RAISE_APPLICATION_ERROR(-20010,X_msg);
798:
799: WHEN TOO_MANY_ROWS THEN
800: X_msg := 'JGRX_FAREG.Get_period_date: TOO_MANY_ROWS';
801: FA_RX_UTIL_PKG.debug(X_msg);
802: RAISE_APPLICATION_ERROR(-20010,X_msg);
803:
804: END Get_period_date;
805:

Line 844: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_starting_depreciation_year()+');

840: X_ret NUMBER(4);
841: X_msg VARCHAR2(100);
842:
843: BEGIN
844: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_starting_depreciation_year()+');
845:
846: SELECT FY.fiscal_year
847: INTO X_ret
848: FROM fa_fiscal_year FY,

Line 859: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_starting_depreciation_year()-');

855: AND FY.end_date
856: AND BO.asset_id = JGRX_FAREG.var.asset_id
857: AND BO.book_type_code = PARM.p_book_type_code;
858:
859: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_starting_depreciation_year()-');
860:
861: RETURN X_ret;
862:
863: EXCEPTION

Line 866: FA_RX_UTIL_PKG.debug(X_msg);

862:
863: EXCEPTION
864: WHEN NO_DATA_FOUND THEN
865: X_msg := 'JGRX_FAREG.Get_starting_depreciation_year: NO_DATA_FOUND';
866: FA_RX_UTIL_PKG.debug(X_msg);
867: RAISE_APPLICATION_ERROR(-20010,X_msg);
868:
869: WHEN TOO_MANY_ROWS THEN
870: X_msg := 'JGRX_FAREG.Get_starting_depreciation_year: TOO_MANY_ROWS';

Line 871: FA_RX_UTIL_PKG.debug(X_msg);

867: RAISE_APPLICATION_ERROR(-20010,X_msg);
868:
869: WHEN TOO_MANY_ROWS THEN
870: X_msg := 'JGRX_FAREG.Get_starting_depreciation_year: TOO_MANY_ROWS';
871: FA_RX_UTIL_PKG.debug(X_msg);
872: RAISE_APPLICATION_ERROR(-20010,X_msg);
873:
874: END Get_starting_depreciation_year;
875:

Line 888: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_depreciation_rate()+');

884: X_number_per_fiscal_year NUMBER;
885: X_life_of_asset NUMBER;
886:
887: BEGIN
888: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_depreciation_rate()+');
889:
890: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.rate_source_rule = ' || JGRX_FAREG.var.rate_source_rule);
891:
892: -- FLAT

Line 890: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.rate_source_rule = ' || JGRX_FAREG.var.rate_source_rule);

886:
887: BEGIN
888: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_depreciation_rate()+');
889:
890: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.rate_source_rule = ' || JGRX_FAREG.var.rate_source_rule);
891:
892: -- FLAT
893: IF JGRX_FAREG.var.rate_source_rule = 'FLAT' THEN
894: JGRX_FAREG.var.deprn_rate := JGRX_FAREG.var.adjusted_rate;

Line 906: FA_RX_UTIL_PKG.debug('Life in years ='||to_char(X_life_in_years));

902: FROM fa_calendar_types
903: WHERE calendar_type = X_deprn_calendar; -- X_deprn_calendar is retrieved in Get_fiscal_year_date()
904: IF JGRX_FAREG.var.rate_source_rule = 'CALCULATED' THEN
905: X_life_in_years := JGRX_FAREG.var.life_in_months / X_number_per_fiscal_year;
906: FA_RX_UTIL_PKG.debug('Life in years ='||to_char(X_life_in_years));
907: JGRX_FAREG.var.deprn_rate := 1 / X_life_in_years;
908: FA_RX_UTIL_PKG.debug('deprn rate'||to_char(JGRX_FAREG.var.deprn_rate));
909: END IF;
910: END IF;

Line 908: FA_RX_UTIL_PKG.debug('deprn rate'||to_char(JGRX_FAREG.var.deprn_rate));

904: IF JGRX_FAREG.var.rate_source_rule = 'CALCULATED' THEN
905: X_life_in_years := JGRX_FAREG.var.life_in_months / X_number_per_fiscal_year;
906: FA_RX_UTIL_PKG.debug('Life in years ='||to_char(X_life_in_years));
907: JGRX_FAREG.var.deprn_rate := 1 / X_life_in_years;
908: FA_RX_UTIL_PKG.debug('deprn rate'||to_char(JGRX_FAREG.var.deprn_rate));
909: END IF;
910: END IF;
911:
912:

Line 920: FA_RX_UTIL_PKG.debug('Life of the asset= ' || to_char(x_life_of_asset));

916: X_number_per_fiscal_year))+1
917: INTO X_life_of_asset
918: FROM dual;
919:
920: FA_RX_UTIL_PKG.debug('Life of the asset= ' || to_char(x_life_of_asset));
921: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
922: FA_RX_UTIL_PKG.debug('start date = ' || JGRX_FAREG.var.prorate_date);
923: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JGRX_FAREG.var.date_placed_in_service);
924: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));

Line 921: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);

917: INTO X_life_of_asset
918: FROM dual;
919:
920: FA_RX_UTIL_PKG.debug('Life of the asset= ' || to_char(x_life_of_asset));
921: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
922: FA_RX_UTIL_PKG.debug('start date = ' || JGRX_FAREG.var.prorate_date);
923: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JGRX_FAREG.var.date_placed_in_service);
924: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
925: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JGRX_FAREG.var.method_id));

Line 922: FA_RX_UTIL_PKG.debug('start date = ' || JGRX_FAREG.var.prorate_date);

918: FROM dual;
919:
920: FA_RX_UTIL_PKG.debug('Life of the asset= ' || to_char(x_life_of_asset));
921: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
922: FA_RX_UTIL_PKG.debug('start date = ' || JGRX_FAREG.var.prorate_date);
923: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JGRX_FAREG.var.date_placed_in_service);
924: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
925: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JGRX_FAREG.var.method_id));
926:

Line 923: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JGRX_FAREG.var.date_placed_in_service);

919:
920: FA_RX_UTIL_PKG.debug('Life of the asset= ' || to_char(x_life_of_asset));
921: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
922: FA_RX_UTIL_PKG.debug('start date = ' || JGRX_FAREG.var.prorate_date);
923: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JGRX_FAREG.var.date_placed_in_service);
924: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
925: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JGRX_FAREG.var.method_id));
926:
927: SELECT rate

Line 924: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));

920: FA_RX_UTIL_PKG.debug('Life of the asset= ' || to_char(x_life_of_asset));
921: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
922: FA_RX_UTIL_PKG.debug('start date = ' || JGRX_FAREG.var.prorate_date);
923: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JGRX_FAREG.var.date_placed_in_service);
924: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
925: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JGRX_FAREG.var.method_id));
926:
927: SELECT rate
928: INTO JGRX_FAREG.var.deprn_rate

Line 925: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JGRX_FAREG.var.method_id));

921: FA_RX_UTIL_PKG.debug('deprn calendar = ' || x_deprn_calendar);
922: FA_RX_UTIL_PKG.debug('start date = ' || JGRX_FAREG.var.prorate_date);
923: FA_RX_UTIL_PKG.debug(' date placed in service = ' || JGRX_FAREG.var.date_placed_in_service);
924: FA_RX_UTIL_PKG.debug('number per fiscal year= ' || to_char(x_number_per_fiscal_year));
925: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JGRX_FAREG.var.method_id));
926:
927: SELECT rate
928: INTO JGRX_FAREG.var.deprn_rate
929: FROM fa_rates

Line 944: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.deprn_rate =' || TO_CHAR(JGRX_FAREG.var.deprn_rate));

940:
941: JGRX_FAREG.var.deprn_rate := JGRX_FAREG.var.deprn_rate *100;
942: END IF;
943:
944: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.deprn_rate =' || TO_CHAR(JGRX_FAREG.var.deprn_rate));
945:
946: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_depreciation_rate()-');
947:
948: EXCEPTION

Line 946: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_depreciation_rate()-');

942: END IF;
943:
944: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.deprn_rate =' || TO_CHAR(JGRX_FAREG.var.deprn_rate));
945:
946: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_depreciation_rate()-');
947:
948: EXCEPTION
949: WHEN NO_DATA_FOUND THEN
950: X_msg := 'JGRX_FAREG.Get_depreciation_rate: NO_DATA_FOUND';

Line 951: FA_RX_UTIL_PKG.debug(X_msg);

947:
948: EXCEPTION
949: WHEN NO_DATA_FOUND THEN
950: X_msg := 'JGRX_FAREG.Get_depreciation_rate: NO_DATA_FOUND';
951: FA_RX_UTIL_PKG.debug(X_msg);
952: RAISE_APPLICATION_ERROR(-20010,X_msg);
953:
954: WHEN TOO_MANY_ROWS THEN
955: X_msg := 'JGRX_FAREG.Get_depreciation_rate: TOO_MANY_ROWS';

Line 956: FA_RX_UTIL_PKG.debug(X_msg);

952: RAISE_APPLICATION_ERROR(-20010,X_msg);
953:
954: WHEN TOO_MANY_ROWS THEN
955: X_msg := 'JGRX_FAREG.Get_depreciation_rate: TOO_MANY_ROWS';
956: FA_RX_UTIL_PKG.debug(X_msg);
957: RAISE_APPLICATION_ERROR(-20010,X_msg);
958:
959: END Get_depreciation_rate;
960:

Line 977: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_Deprn_Account()+');

973: v_selectstmnt3 varchar2(10000);
974: V_expense_account varchar2(100);
975: v_dummy integer ;
976: BEGIN
977: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_Deprn_Account()+');
978: JGRX_FAREG.var.expense_account := NULL;
979: v_cursorId := DBMS_SQL.OPEN_CURSOR;
980: v_Selectstmnt1 :=
981: 'select '||X_account_segment||' from '||

Line 1007: FA_RX_UTIL_PKG.debug('JGRX_FAREG.expense_account = ' || JGRX_FAREG.var.expense_account);

1003: DBMS_SQL.COLUMN_VALUE(V_cursorId,1,V_expense_account);
1004: JGRX_FAREG.var.expense_account:= JGRX_FAREG.var.expense_account||V_expense_account;
1005: END LOOP;
1006: dbms_sql.close_cursor(v_cursorId);
1007: FA_RX_UTIL_PKG.debug('JGRX_FAREG.expense_account = ' || JGRX_FAREG.var.expense_account);
1008: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_depr_account()-');
1009: END Get_deprn_accounts;
1010:
1011:

Line 1008: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_depr_account()-');

1004: JGRX_FAREG.var.expense_account:= JGRX_FAREG.var.expense_account||V_expense_account;
1005: END LOOP;
1006: dbms_sql.close_cursor(v_cursorId);
1007: FA_RX_UTIL_PKG.debug('JGRX_FAREG.expense_account = ' || JGRX_FAREG.var.expense_account);
1008: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_depr_account()-');
1009: END Get_deprn_accounts;
1010:
1011:
1012:

Line 1029: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_inv_number()+');

1025: ai.asset_id = JGRX_FAREG.var.asset_id and
1026: ai.invoice_transaction_id_in = IT.invoice_transaction_id and
1027: IT.book_type_code = PARM.p_book_type_code;
1028: BEGIN
1029: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_inv_number()+');
1030: JGRX_FAREG.var.invoice_number := null;
1031: JGRX_FAREG.var.supplier_name := null;
1032: FOR c_inv in c_invoice_supplier LOOP
1033: IF c_invoice_supplier%ROWCOUNT=0 then

Line 1039: FA_RX_UTIL_PKG.debug('JGRX_FAREG.invoice_number = ' || JGRX_FAREG.var.invoice_number);

1035: END IF;
1036: JGRX_FAREG.var.invoice_number := JGRX_FAREG.var.invoice_number||c_inv.invoice_number;
1037: JGRX_FAREG.var.supplier_name := JGRX_FAREG.var.supplier_name ||c_inv.vendor_name;
1038: END LOOP;
1039: FA_RX_UTIL_PKG.debug('JGRX_FAREG.invoice_number = ' || JGRX_FAREG.var.invoice_number);
1040: FA_RX_UTIL_PKG.debug('JGRX_FAREG.supplier_name = ' || JGRX_FAREG.var.supplier_name);
1041: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_inv_number()-');
1042: END Get_invoice_number;
1043:

Line 1040: FA_RX_UTIL_PKG.debug('JGRX_FAREG.supplier_name = ' || JGRX_FAREG.var.supplier_name);

1036: JGRX_FAREG.var.invoice_number := JGRX_FAREG.var.invoice_number||c_inv.invoice_number;
1037: JGRX_FAREG.var.supplier_name := JGRX_FAREG.var.supplier_name ||c_inv.vendor_name;
1038: END LOOP;
1039: FA_RX_UTIL_PKG.debug('JGRX_FAREG.invoice_number = ' || JGRX_FAREG.var.invoice_number);
1040: FA_RX_UTIL_PKG.debug('JGRX_FAREG.supplier_name = ' || JGRX_FAREG.var.supplier_name);
1041: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_inv_number()-');
1042: END Get_invoice_number;
1043:
1044: /*

Line 1041: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_inv_number()-');

1037: JGRX_FAREG.var.supplier_name := JGRX_FAREG.var.supplier_name ||c_inv.vendor_name;
1038: END LOOP;
1039: FA_RX_UTIL_PKG.debug('JGRX_FAREG.invoice_number = ' || JGRX_FAREG.var.invoice_number);
1040: FA_RX_UTIL_PKG.debug('JGRX_FAREG.supplier_name = ' || JGRX_FAREG.var.supplier_name);
1041: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_inv_number()-');
1042: END Get_invoice_number;
1043:
1044: /*
1045: BEGIN

Line 1057: FA_RX_UTIL_PKG.debug('JGRX_FAREG.invoice_number = ' || JGRX_FAREG.var.invoice_number);

1053: WHERE AI1.asset_id = JGRX_FAREG.var.asset_id
1054: AND AI1.invoice_transaction_id_in = IT.invoice_transaction_id
1055: AND IT.book_type_code = PARM.p_book_type_code);
1056:
1057: FA_RX_UTIL_PKG.debug('JGRX_FAREG.invoice_number = ' || JGRX_FAREG.var.invoice_number);
1058: FA_RX_UTIL_PKG.debug('JGRX_FAREG.supplier_name = ' || JGRX_FAREG.var.supplier_name);
1059: EXCEPTION
1060: WHEN NO_DATA_FOUND THEN
1061: X_msg := 'JGRX_FAREG.Get_inv_number: NO_DATA_FOUND';

Line 1058: FA_RX_UTIL_PKG.debug('JGRX_FAREG.supplier_name = ' || JGRX_FAREG.var.supplier_name);

1054: AND AI1.invoice_transaction_id_in = IT.invoice_transaction_id
1055: AND IT.book_type_code = PARM.p_book_type_code);
1056:
1057: FA_RX_UTIL_PKG.debug('JGRX_FAREG.invoice_number = ' || JGRX_FAREG.var.invoice_number);
1058: FA_RX_UTIL_PKG.debug('JGRX_FAREG.supplier_name = ' || JGRX_FAREG.var.supplier_name);
1059: EXCEPTION
1060: WHEN NO_DATA_FOUND THEN
1061: X_msg := 'JGRX_FAREG.Get_inv_number: NO_DATA_FOUND';
1062: FA_RX_UTIL_PKG.debug(X_msg);

Line 1062: FA_RX_UTIL_PKG.debug(X_msg);

1058: FA_RX_UTIL_PKG.debug('JGRX_FAREG.supplier_name = ' || JGRX_FAREG.var.supplier_name);
1059: EXCEPTION
1060: WHEN NO_DATA_FOUND THEN
1061: X_msg := 'JGRX_FAREG.Get_inv_number: NO_DATA_FOUND';
1062: FA_RX_UTIL_PKG.debug(X_msg);
1063: JGRX_FAREG.var.invoice_number := null;
1064: JGRX_FAREG.var.supplier_name := null;
1065: END;
1066: */

Line 1080: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_parent_asset_number()+');

1076: X_msg VARCHAR2(100);
1077: X_parent_asset_number VARCHAR2(15);
1078:
1079: BEGIN
1080: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_parent_asset_number()+');
1081:
1082: SELECT asset_number
1083: INTO X_parent_asset_number
1084: FROM fa_additions

Line 1087: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_parent_asset_number()-');

1083: INTO X_parent_asset_number
1084: FROM fa_additions
1085: WHERE asset_id = JGRX_FAREG.var.parent_asset_id;
1086:
1087: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_parent_asset_number()-');
1088:
1089: RETURN X_parent_asset_number;
1090:
1091: EXCEPTION

Line 1094: FA_RX_UTIL_PKG.debug(X_msg);

1090:
1091: EXCEPTION
1092: WHEN NO_DATA_FOUND THEN
1093: X_msg := 'JGRX_FAREG.Get_parent_asset_number: NO_DATA_FOUND';
1094: FA_RX_UTIL_PKG.debug(X_msg);
1095: RAISE_APPLICATION_ERROR(-20010,X_msg);
1096:
1097: END Get_parent_asset_number;
1098:

Line 1109: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Startup()+');

1105:
1106: X_msg VARCHAR2(100);
1107:
1108: BEGIN
1109: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Startup()+');
1110:
1111: -- It takes the segment condition
1112: X_where_clause_tmp := Get_category_segment;
1113:

Line 1114: FA_RX_UTIL_PKG.debug('Get Company name');

1110:
1111: -- It takes the segment condition
1112: X_where_clause_tmp := Get_category_segment;
1113:
1114: FA_RX_UTIL_PKG.debug('Get Company name');
1115: -- Get Company name and store in placeholder variable
1116: SELECT company_name
1117: INTO JGRX_FAREG.var.organization_name
1118: FROM fa_system_controls;

Line 1121: FA_RX_UTIL_PKG.debug('Get currency code');

1117: INTO JGRX_FAREG.var.organization_name
1118: FROM fa_system_controls;
1119:
1120:
1121: FA_RX_UTIL_PKG.debug('Get currency code');
1122: -- Get currency code and store in placeholder variable
1123: SELECT currency_code
1124: INTO JGRX_FAREG.var.functional_currency_code
1125: FROM gl_sets_of_books

Line 1128: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Startup()-');

1124: INTO JGRX_FAREG.var.functional_currency_code
1125: FROM gl_sets_of_books
1126: WHERE set_of_books_id = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
1127:
1128: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Startup()-');
1129:
1130: EXCEPTION
1131: WHEN NO_DATA_FOUND THEN
1132: X_msg := 'JGRX_FAREG.Startup: NO_DATA_FOUND';

Line 1133: FA_RX_UTIL_PKG.debug(X_msg);

1129:
1130: EXCEPTION
1131: WHEN NO_DATA_FOUND THEN
1132: X_msg := 'JGRX_FAREG.Startup: NO_DATA_FOUND';
1133: FA_RX_UTIL_PKG.debug(X_msg);
1134: RAISE_APPLICATION_ERROR(-20010,X_msg);
1135:
1136: WHEN TOO_MANY_ROWS THEN
1137: X_msg := 'JGRX_FAREG.Startup: TOO_MANY_ROWS';

Line 1138: FA_RX_UTIL_PKG.debug(X_msg);

1134: RAISE_APPLICATION_ERROR(-20010,X_msg);
1135:
1136: WHEN TOO_MANY_ROWS THEN
1137: X_msg := 'JGRX_FAREG.Startup: TOO_MANY_ROWS';
1138: FA_RX_UTIL_PKG.debug(X_msg);
1139: RAISE_APPLICATION_ERROR(-20010,X_msg);
1140:
1141: END Startup;
1142:

Line 1154: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_value()+');

1150: X_msg VARCHAR2(100);
1151: X_capitalized NUMBER(10);
1152:
1153: BEGIN
1154: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_value()+');
1155:
1156: BEGIN
1157: FA_RX_UTIL_PKG.debug('Get cost initial value');
1158: -- Get initial value

Line 1157: FA_RX_UTIL_PKG.debug('Get cost initial value');

1153: BEGIN
1154: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_value()+');
1155:
1156: BEGIN
1157: FA_RX_UTIL_PKG.debug('Get cost initial value');
1158: -- Get initial value
1159: SELECT count(*)
1160: INTO X_capitalized
1161: FROM fa_books BO

Line 1186: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_cost_initial =' || TO_CHAR(JGRX_FAREG.var.asset_cost_initial));

1182: AND BO1.asset_id = BO.asset_id
1183: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1184: AND TRH.transaction_date_entered < PARM.p_begin_period_from_date);
1185: END IF;
1186: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_cost_initial =' || TO_CHAR(JGRX_FAREG.var.asset_cost_initial));
1187:
1188: EXCEPTION
1189: WHEN NO_DATA_FOUND THEN
1190: JGRX_FAREG.var.asset_cost_initial := 0;

Line 1193: FA_RX_UTIL_PKG.debug('Get cost final value');

1189: WHEN NO_DATA_FOUND THEN
1190: JGRX_FAREG.var.asset_cost_initial := 0;
1191: END;
1192:
1193: FA_RX_UTIL_PKG.debug('Get cost final value');
1194: -- Get final value
1195: BEGIN
1196: SELECT cost,
1197: transaction_header_id_in

Line 1211: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_cost_final =' || TO_CHAR(JGRX_FAREG.var.asset_cost_final));

1207: WHERE BO1.book_type_code = BO.book_type_code
1208: AND BO1.asset_id = BO.asset_id
1209: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1210: AND TRH.transaction_date_entered <= PARM.p_end_period_to_date);
1211: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_cost_final =' || TO_CHAR(JGRX_FAREG.var.asset_cost_final));
1212: EXCEPTION
1213: WHEN NO_DATA_FOUND THEN
1214: JGRX_FAREG.var.asset_cost_final := 0;
1215: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_cost_final =' ||'no data found');

Line 1215: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_cost_final =' ||'no data found');

1211: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_cost_final =' || TO_CHAR(JGRX_FAREG.var.asset_cost_final));
1212: EXCEPTION
1213: WHEN NO_DATA_FOUND THEN
1214: JGRX_FAREG.var.asset_cost_final := 0;
1215: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_cost_final =' ||'no data found');
1216:
1217: END;
1218:
1219: -- It takes the asset cost increase

Line 1230: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_variation =' || JGRX_FAREG.var.asset_variation);

1226: JGRX_FAREG.var.asset_cost_decrease;
1227:
1228: JGRX_FAREG.var.revaluation_total := JGRX_FAREG.var.asset_cost_final -
1229: JGRX_FAREG.var.asset_cost_orig;
1230: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_variation =' || JGRX_FAREG.var.asset_variation);
1231: -- 09/08/00 AFERRARA
1232:
1233: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_value()-');
1234:

Line 1233: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_value()-');

1229: JGRX_FAREG.var.asset_cost_orig;
1230: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_variation =' || JGRX_FAREG.var.asset_variation);
1231: -- 09/08/00 AFERRARA
1232:
1233: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_value()-');
1234:
1235: EXCEPTION
1236: WHEN NO_DATA_FOUND THEN
1237: X_msg := 'JGRX_FAREG.Get_cost_value: NO_DATA_FOUND';

Line 1238: FA_RX_UTIL_PKG.debug(X_msg);

1234:
1235: EXCEPTION
1236: WHEN NO_DATA_FOUND THEN
1237: X_msg := 'JGRX_FAREG.Get_cost_value: NO_DATA_FOUND';
1238: FA_RX_UTIL_PKG.debug(X_msg);
1239: RAISE_APPLICATION_ERROR(-20010,X_msg);
1240:
1241: WHEN TOO_MANY_ROWS THEN
1242: X_msg := 'JGRX_FAREG.Get_cost_value: TOO_MANY_ROWS';

Line 1243: FA_RX_UTIL_PKG.debug(X_msg);

1239: RAISE_APPLICATION_ERROR(-20010,X_msg);
1240:
1241: WHEN TOO_MANY_ROWS THEN
1242: X_msg := 'JGRX_FAREG.Get_cost_value: TOO_MANY_ROWS';
1243: FA_RX_UTIL_PKG.debug(X_msg);
1244: RAISE_APPLICATION_ERROR(-20010,X_msg);
1245:
1246: END Get_cost_value;
1247:

Line 1261: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_increase()+');

1257: X_revaluation_plus NUMBER := 0;
1258: X_reinstatements NUMBER := 0;
1259:
1260: BEGIN
1261: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_increase()+');
1262:
1263: -------------------------------------------------------------------------------
1264: FA_RX_UTIL_PKG.debug('Get partial addition ');
1265: fa_rx_util_pkg.debug('transaction id'||X_transaction_id_initial);

Line 1264: FA_RX_UTIL_PKG.debug('Get partial addition ');

1260: BEGIN
1261: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_increase()+');
1262:
1263: -------------------------------------------------------------------------------
1264: FA_RX_UTIL_PKG.debug('Get partial addition ');
1265: fa_rx_util_pkg.debug('transaction id'||X_transaction_id_initial);
1266: fa_rx_util_pkg.debug('PARM.p_begin_period_to_date'||to_char(PARM.p_begin_period_to_date));
1267: fa_rx_util_pkg.debug('PARM.p_end_period_from_date'||to_char(PARM.p_end_period_from_date));
1268:

Line 1265: fa_rx_util_pkg.debug('transaction id'||X_transaction_id_initial);

1261: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_increase()+');
1262:
1263: -------------------------------------------------------------------------------
1264: FA_RX_UTIL_PKG.debug('Get partial addition ');
1265: fa_rx_util_pkg.debug('transaction id'||X_transaction_id_initial);
1266: fa_rx_util_pkg.debug('PARM.p_begin_period_to_date'||to_char(PARM.p_begin_period_to_date));
1267: fa_rx_util_pkg.debug('PARM.p_end_period_from_date'||to_char(PARM.p_end_period_from_date));
1268:
1269: SELECT SUM(AD.adjustment_amount)

Line 1266: fa_rx_util_pkg.debug('PARM.p_begin_period_to_date'||to_char(PARM.p_begin_period_to_date));

1262:
1263: -------------------------------------------------------------------------------
1264: FA_RX_UTIL_PKG.debug('Get partial addition ');
1265: fa_rx_util_pkg.debug('transaction id'||X_transaction_id_initial);
1266: fa_rx_util_pkg.debug('PARM.p_begin_period_to_date'||to_char(PARM.p_begin_period_to_date));
1267: fa_rx_util_pkg.debug('PARM.p_end_period_from_date'||to_char(PARM.p_end_period_from_date));
1268:
1269: SELECT SUM(AD.adjustment_amount)
1270: INTO X_partial_addition

Line 1267: fa_rx_util_pkg.debug('PARM.p_end_period_from_date'||to_char(PARM.p_end_period_from_date));

1263: -------------------------------------------------------------------------------
1264: FA_RX_UTIL_PKG.debug('Get partial addition ');
1265: fa_rx_util_pkg.debug('transaction id'||X_transaction_id_initial);
1266: fa_rx_util_pkg.debug('PARM.p_begin_period_to_date'||to_char(PARM.p_begin_period_to_date));
1267: fa_rx_util_pkg.debug('PARM.p_end_period_from_date'||to_char(PARM.p_end_period_from_date));
1268:
1269: SELECT SUM(AD.adjustment_amount)
1270: INTO X_partial_addition
1271: FROM fa_books BO,

Line 1292: FA_RX_UTIL_PKG.debug('partial addition =' || TO_CHAR(X_partial_addition));

1288: AND TH.transaction_date_entered BETWEEN (PARM.p_begin_period_from_date)
1289: AND (PARM.p_end_period_to_date);
1290: -- changed bo.date_effective to TH.transaction_date_entered
1291:
1292: FA_RX_UTIL_PKG.debug('partial addition =' || TO_CHAR(X_partial_addition));
1293:
1294:
1295: -------------------------------------------------------------------------------
1296: FA_RX_UTIL_PKG.debug('Get manual adjustment upwards');

Line 1296: FA_RX_UTIL_PKG.debug('Get manual adjustment upwards');

1292: FA_RX_UTIL_PKG.debug('partial addition =' || TO_CHAR(X_partial_addition));
1293:
1294:
1295: -------------------------------------------------------------------------------
1296: FA_RX_UTIL_PKG.debug('Get manual adjustment upwards');
1297:
1298: SELECT SUM(AD.adjustment_amount)
1299: INTO X_manual_adjustment_plus
1300: FROM fa_transaction_headers TH,

Line 1313: FA_RX_UTIL_PKG.debug('Get manual adjustment upwards =' || TO_CHAR(X_manual_adjustment_plus));

1309: AND AD.debit_credit_flag = 'DR'
1310: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1311: AND PARM.p_end_period_to_date;
1312:
1313: FA_RX_UTIL_PKG.debug('Get manual adjustment upwards =' || TO_CHAR(X_manual_adjustment_plus));
1314:
1315:
1316: -------------------------------------------------------------------------------
1317: FA_RX_UTIL_PKG.debug('Get revaluations upward ');

Line 1317: FA_RX_UTIL_PKG.debug('Get revaluations upward ');

1313: FA_RX_UTIL_PKG.debug('Get manual adjustment upwards =' || TO_CHAR(X_manual_adjustment_plus));
1314:
1315:
1316: -------------------------------------------------------------------------------
1317: FA_RX_UTIL_PKG.debug('Get revaluations upward ');
1318:
1319: SELECT SUM(AD.adjustment_amount)
1320: INTO X_revaluation_plus
1321: FROM fa_transaction_headers TH,

Line 1335: FA_RX_UTIL_PKG.debug('Revaluations Upward =' || TO_CHAR(X_revaluation_plus));

1331: AND AD.adjustment_amount > 0
1332: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1333: AND PARM.p_end_period_to_date;
1334:
1335: FA_RX_UTIL_PKG.debug('Revaluations Upward =' || TO_CHAR(X_revaluation_plus));
1336:
1337:
1338: -------------------------------------------------------------------------------
1339: FA_RX_UTIL_PKG.debug('Get reinstatements ');

Line 1339: FA_RX_UTIL_PKG.debug('Get reinstatements ');

1335: FA_RX_UTIL_PKG.debug('Revaluations Upward =' || TO_CHAR(X_revaluation_plus));
1336:
1337:
1338: -------------------------------------------------------------------------------
1339: FA_RX_UTIL_PKG.debug('Get reinstatements ');
1340:
1341: SELECT SUM(RE.cost_retired)
1342: INTO X_reinstatements
1343: FROM fa_transaction_headers TH,

Line 1354: FA_RX_UTIL_PKG.debug('Reinstatements =' || TO_CHAR(X_reinstatements));

1350: AND TH.asset_id = JGRX_FAREG.var.asset_id
1351: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1352: AND PARM.p_end_period_to_date;
1353: -- jmary changing date_retired to transaction_date
1354: FA_RX_UTIL_PKG.debug('Reinstatements =' || TO_CHAR(X_reinstatements));
1355:
1356:
1357:
1358: JGRX_FAREG.var.asset_cost_increase := NVL(X_partial_addition,0) +

Line 1363: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_cost_increase =' || JGRX_FAREG.var.asset_cost_increase);

1359: NVL(X_manual_adjustment_plus,0) +
1360: NVL(X_revaluation_plus,0) +
1361: NVL(X_reinstatements,0);
1362:
1363: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_cost_increase =' || JGRX_FAREG.var.asset_cost_increase);
1364:
1365: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_increase()-');
1366:
1367:

Line 1365: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_increase()-');

1361: NVL(X_reinstatements,0);
1362:
1363: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_cost_increase =' || JGRX_FAREG.var.asset_cost_increase);
1364:
1365: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_increase()-');
1366:
1367:
1368: END Get_cost_increase;
1369:

Line 1384: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_decrease()+');

1380: X_revaluation_minus NUMBER := 0;
1381: X_retirements NUMBER := 0;
1382:
1383: BEGIN
1384: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_decrease()+');
1385:
1386:
1387: -------------------------------------------------------------------------------
1388: FA_RX_UTIL_PKG.debug('Get credit memos ');

Line 1388: FA_RX_UTIL_PKG.debug('Get credit memos ');

1384: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_decrease()+');
1385:
1386:
1387: -------------------------------------------------------------------------------
1388: FA_RX_UTIL_PKG.debug('Get credit memos ');
1389:
1390: SELECT SUM(AD.adjustment_amount)
1391: INTO X_credit_memos
1392: FROM fa_books BO,

Line 1413: FA_RX_UTIL_PKG.debug('credit memos =' || TO_CHAR(X_credit_memos));

1409: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1410: AND PARM.p_end_period_to_date;
1411: -- changed date_effective to transaction_date_entered
1412:
1413: FA_RX_UTIL_PKG.debug('credit memos =' || TO_CHAR(X_credit_memos));
1414:
1415:
1416: -------------------------------------------------------------------------------
1417: FA_RX_UTIL_PKG.debug('Get manual adjustment downwards');

Line 1417: FA_RX_UTIL_PKG.debug('Get manual adjustment downwards');

1413: FA_RX_UTIL_PKG.debug('credit memos =' || TO_CHAR(X_credit_memos));
1414:
1415:
1416: -------------------------------------------------------------------------------
1417: FA_RX_UTIL_PKG.debug('Get manual adjustment downwards');
1418:
1419: SELECT SUM(AD.adjustment_amount)
1420: INTO X_manual_adjustment_minus
1421: FROM fa_transaction_headers TH,

Line 1434: FA_RX_UTIL_PKG.debug('Get manual adjustment downwards =' || TO_CHAR(X_manual_adjustment_minus));

1430: AND AD.debit_credit_flag = 'CR'
1431: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1432: AND PARM.p_end_period_to_date;
1433:
1434: FA_RX_UTIL_PKG.debug('Get manual adjustment downwards =' || TO_CHAR(X_manual_adjustment_minus));
1435:
1436:
1437: -------------------------------------------------------------------------------
1438: FA_RX_UTIL_PKG.debug('Get revaluations downward ');

Line 1438: FA_RX_UTIL_PKG.debug('Get revaluations downward ');

1434: FA_RX_UTIL_PKG.debug('Get manual adjustment downwards =' || TO_CHAR(X_manual_adjustment_minus));
1435:
1436:
1437: -------------------------------------------------------------------------------
1438: FA_RX_UTIL_PKG.debug('Get revaluations downward ');
1439:
1440: SELECT SUM(AD.adjustment_amount)
1441: INTO X_revaluation_minus
1442: FROM fa_transaction_headers TH,

Line 1455: FA_RX_UTIL_PKG.debug('Revaluations downward =' || TO_CHAR(X_revaluation_minus));

1451: AND AD.debit_credit_flag = 'CR'
1452: AND TH.transaction_date_entered BETWEEN PARM.p_begin_period_from_date
1453: AND PARM.p_end_period_to_date;
1454:
1455: FA_RX_UTIL_PKG.debug('Revaluations downward =' || TO_CHAR(X_revaluation_minus));
1456:
1457:
1458: -------------------------------------------------------------------------------
1459: FA_RX_UTIL_PKG.debug('Get retirements ');

Line 1459: FA_RX_UTIL_PKG.debug('Get retirements ');

1455: FA_RX_UTIL_PKG.debug('Revaluations downward =' || TO_CHAR(X_revaluation_minus));
1456:
1457:
1458: -------------------------------------------------------------------------------
1459: FA_RX_UTIL_PKG.debug('Get retirements ');
1460:
1461: SELECT SUM(RE.cost_retired)
1462: INTO X_retirements
1463: FROM fa_transaction_headers TH,

Line 1475: FA_RX_UTIL_PKG.debug('Retirements =' || TO_CHAR(X_retirements));

1471: AND TH.asset_id = JGRX_FAREG.var.asset_id
1472: AND RE.date_retired BETWEEN PARM.p_begin_period_from_date /* changed Transaction Date to Retirement Date */
1473: AND PARM.p_end_period_to_date;
1474:
1475: FA_RX_UTIL_PKG.debug('Retirements =' || TO_CHAR(X_retirements));
1476:
1477:
1478:
1479: JGRX_FAREG.var.asset_cost_decrease := NVL(X_credit_memos,0) +

Line 1484: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_cost_decrease =' || JGRX_FAREG.var.asset_cost_decrease);

1480: NVL(X_manual_adjustment_minus,0) +
1481: NVL(X_revaluation_minus,0) +
1482: NVL(X_retirements,0);
1483:
1484: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_cost_decrease =' || JGRX_FAREG.var.asset_cost_decrease);
1485:
1486: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_decrease()-');
1487:
1488:

Line 1486: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_decrease()-');

1482: NVL(X_retirements,0);
1483:
1484: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.asset_cost_decrease =' || JGRX_FAREG.var.asset_cost_decrease);
1485:
1486: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_cost_decrease()-');
1487:
1488:
1489: END Get_cost_decrease;
1490:

Line 1499: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation()+');

1495: PROCEDURE Get_revaluation
1496: IS
1497:
1498: BEGIN
1499: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation()+');
1500:
1501: BEGIN
1502: FA_RX_UTIL_PKG.debug('Get_revaluation initial value');
1503: -- Get initial value

Line 1502: FA_RX_UTIL_PKG.debug('Get_revaluation initial value');

1498: BEGIN
1499: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation()+');
1500:
1501: BEGIN
1502: FA_RX_UTIL_PKG.debug('Get_revaluation initial value');
1503: -- Get initial value
1504: SELECT SUM(DECODE(debit_credit_flag, 'DR', adjustment_amount, 0)) -
1505: SUM(DECODE(debit_credit_flag, 'CR', adjustment_amount, 0))
1506: INTO JGRX_FAREG.var.revaluation_initial

Line 1518: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.revaluation_initial =' || TO_CHAR(JGRX_FAREG.var.revaluation_initial));

1514: IF JGRX_FAREG.var.revaluation_initial IS NULL THEN
1515: JGRX_FAREG.var.revaluation_initial := 0;
1516: END IF;
1517:
1518: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.revaluation_initial =' || TO_CHAR(JGRX_FAREG.var.revaluation_initial));
1519: END;
1520:
1521:
1522: BEGIN

Line 1523: FA_RX_UTIL_PKG.debug('Get_revaluation final value');

1519: END;
1520:
1521:
1522: BEGIN
1523: FA_RX_UTIL_PKG.debug('Get_revaluation final value');
1524: -- Get final value
1525: SELECT SUM(DECODE(debit_credit_flag, 'DR', adjustment_amount, 0)) -
1526: SUM(DECODE(debit_credit_flag, 'CR', adjustment_amount, 0))
1527: INTO JGRX_FAREG.var.revaluation_final

Line 1540: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.revaluation_final =' || TO_CHAR(JGRX_FAREG.var.revaluation_final));

1536: JGRX_FAREG.var.revaluation_final := 0;
1537: END IF;
1538:
1539:
1540: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.revaluation_final =' || TO_CHAR(JGRX_FAREG.var.revaluation_final));
1541: END;
1542:
1543: -- It takes the asset revaluation increase
1544: Get_revaluation_change;

Line 1550: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.reval_variation =' || JGRX_FAREG.var.reval_variation);

1546: -- 09/08/00 AFERRARA
1547: JGRX_FAREG.var.reval_variation := JGRX_FAREG.var.revaluation_increase -
1548: JGRX_FAREG.var.revaluation_decrease;
1549:
1550: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.reval_variation =' || JGRX_FAREG.var.reval_variation);
1551: -- 09/08/00 AFERRARA
1552:
1553: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation()-');
1554:

Line 1553: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation()-');

1549:
1550: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.reval_variation =' || JGRX_FAREG.var.reval_variation);
1551: -- 09/08/00 AFERRARA
1552:
1553: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation()-');
1554:
1555: END Get_revaluation;
1556:
1557: /*===================================================================+

Line 1564: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation_change()+');

1560: PROCEDURE Get_revaluation_change
1561: IS
1562:
1563: BEGIN
1564: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation_change()+');
1565:
1566: SELECT SUM(DECODE(DEBIT_CREDIT_FLAG,'DR',AD.adjustment_amount,0)),
1567: SUM(DECODE(DEBIT_CREDIT_FLAG,'CR',AD.adjustment_amount,0))
1568: INTO JGRX_FAREG.var.revaluation_increase,JGRX_FAREG.var.revaluation_decrease

Line 1583: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.revaluation_increase =' || JGRX_FAREG.var.revaluation_increase);

1579: IF JGRX_FAREG.var.revaluation_decrease IS NULL THEN
1580: JGRX_FAREG.var.revaluation_decrease := 0;
1581: END IF;
1582:
1583: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.revaluation_increase =' || JGRX_FAREG.var.revaluation_increase);
1584: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.revaluation_decrease =' || JGRX_FAREG.var.revaluation_decrease);
1585:
1586: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation_change()-');
1587:

Line 1584: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.revaluation_decrease =' || JGRX_FAREG.var.revaluation_decrease);

1580: JGRX_FAREG.var.revaluation_decrease := 0;
1581: END IF;
1582:
1583: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.revaluation_increase =' || JGRX_FAREG.var.revaluation_increase);
1584: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.revaluation_decrease =' || JGRX_FAREG.var.revaluation_decrease);
1585:
1586: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation_change()-');
1587:
1588:

Line 1586: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation_change()-');

1582:
1583: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.revaluation_increase =' || JGRX_FAREG.var.revaluation_increase);
1584: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.revaluation_decrease =' || JGRX_FAREG.var.revaluation_decrease);
1585:
1586: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation_change()-');
1587:
1588:
1589: END Get_revaluation_change;
1590:

Line 1600: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_value()+');

1596:
1597: X_msg VARCHAR2(100);
1598:
1599: BEGIN
1600: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_value()+');
1601:
1602: -------------------------------------------------------------------------------
1603: BEGIN
1604: FA_RX_UTIL_PKG.debug('Get deprn reserve initial value');

Line 1604: FA_RX_UTIL_PKG.debug('Get deprn reserve initial value');

1600: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_value()+');
1601:
1602: -------------------------------------------------------------------------------
1603: BEGIN
1604: FA_RX_UTIL_PKG.debug('Get deprn reserve initial value');
1605: -- Get initial value
1606:
1607: SELECT (NVL(deprn_reserve,0) - NVL(bonus_deprn_reserve,0))
1608: INTO JGRX_FAREG.var.deprn_reserve_initial

Line 1619: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.deprn_reserve_initial =' || TO_CHAR(JGRX_FAREG.var.deprn_reserve_initial));

1615: and asset_id= JGRX_FAREG.var.asset_id
1616: and book_type_code = PARM.p_book_type_code );
1617:
1618:
1619: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.deprn_reserve_initial =' || TO_CHAR(JGRX_FAREG.var.deprn_reserve_initial));
1620: EXCEPTION
1621: WHEN NO_DATA_FOUND THEN
1622: JGRX_FAREG.var.deprn_reserve_initial := 0;
1623: END;

Line 1628: FA_RX_UTIL_PKG.debug('Get deprn reserve final value');

1624:
1625:
1626: -------------------------------------------------------------------------------
1627: BEGIN
1628: FA_RX_UTIL_PKG.debug('Get deprn reserve final value');
1629: -- Get final value
1630: SELECT (NVL(deprn_reserve,0) - NVL(bonus_deprn_reserve,0))
1631: INTO JGRX_FAREG.var.deprn_reserve_final
1632: FROM fa_deprn_summary

Line 1643: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.deprn_reserve_final =' || TO_CHAR(JGRX_FAREG.var.deprn_reserve_final));

1639: and asset_id= JGRX_FAREG.var.asset_id
1640: and book_type_code = PARM.p_book_type_code );
1641:
1642:
1643: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.deprn_reserve_final =' || TO_CHAR(JGRX_FAREG.var.deprn_reserve_final));
1644: EXCEPTION
1645: WHEN NO_DATA_FOUND THEN
1646: JGRX_FAREG.var.deprn_reserve_final := 0;
1647: END;

Line 1660: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.deprn_variation =' || JGRX_FAREG.var.deprn_variation);

1656: -- 09/08/00 AFERRARA
1657: JGRX_FAREG.var.deprn_variation := JGRX_FAREG.var.deprn_reserve_increase -
1658: JGRX_FAREG.var.deprn_reserve_decrease;
1659:
1660: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.deprn_variation =' || JGRX_FAREG.var.deprn_variation);
1661: -- 09/08/00 AFERRARA
1662:
1663: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_value()-');
1664:

Line 1663: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_value()-');

1659:
1660: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.deprn_variation =' || JGRX_FAREG.var.deprn_variation);
1661: -- 09/08/00 AFERRARA
1662:
1663: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_value()-');
1664:
1665: EXCEPTION
1666: WHEN TOO_MANY_ROWS THEN
1667: X_msg := 'JGRX_FAREG.Get_deprn_reserve_value: TOO_MANY_ROWS';

Line 1668: FA_RX_UTIL_PKG.debug(X_msg);

1664:
1665: EXCEPTION
1666: WHEN TOO_MANY_ROWS THEN
1667: X_msg := 'JGRX_FAREG.Get_deprn_reserve_value: TOO_MANY_ROWS';
1668: FA_RX_UTIL_PKG.debug(X_msg);
1669: RAISE_APPLICATION_ERROR(-20010,X_msg);
1670:
1671:
1672: END Get_deprn_reserve_value;

Line 1687: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_increase()+');

1683: X_reinstatements NUMBER := 0;
1684: X_tax_re_adjustment_plus NUMBER := 0;
1685:
1686: BEGIN
1687: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_increase()+');
1688:
1689: -------------------------------------------------------------------------------
1690: FA_RX_UTIL_PKG.debug('Get ordinary depreciation ');
1691:

Line 1690: FA_RX_UTIL_PKG.debug('Get ordinary depreciation ');

1686: BEGIN
1687: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_increase()+');
1688:
1689: -------------------------------------------------------------------------------
1690: FA_RX_UTIL_PKG.debug('Get ordinary depreciation ');
1691:
1692: SELECT SUM((NVL(deprn_amount,0) - NVL(bonus_deprn_amount,0)))
1693: INTO X_ord_deprn
1694: FROM fa_deprn_summary

Line 1700: FA_RX_UTIL_PKG.debug('Ordinary depreciation =' || TO_CHAR(X_ord_deprn));

1696: AND asset_id = JGRX_FAREG.var.asset_id
1697: AND period_counter BETWEEN PARM.p_begin_period_counter
1698: AND PARM.p_end_period_counter;
1699:
1700: FA_RX_UTIL_PKG.debug('Ordinary depreciation =' || TO_CHAR(X_ord_deprn));
1701:
1702:
1703: -------------------------------------------------------------------------------
1704: FA_RX_UTIL_PKG.debug('Get increase due to reinstatements and Revaluations ');

Line 1704: FA_RX_UTIL_PKG.debug('Get increase due to reinstatements and Revaluations ');

1700: FA_RX_UTIL_PKG.debug('Ordinary depreciation =' || TO_CHAR(X_ord_deprn));
1701:
1702:
1703: -------------------------------------------------------------------------------
1704: FA_RX_UTIL_PKG.debug('Get increase due to reinstatements and Revaluations ');
1705:
1706: SELECT abs(SUM(DECODE(adjustment_type,'RESERVE',adjustment_amount,0)) -
1707: SUM(DECODE(adjustment_type,'BONUS RESERVE',adjustment_amount,0)))
1708: INTO X_reinstatements

Line 1718: FA_RX_UTIL_PKG.debug('Reinstatements =' || TO_CHAR(X_reinstatements));

1714: AND AD.period_counter_adjusted BETWEEN PARM.p_begin_period_counter
1715: AND PARM.p_end_period_counter;
1716:
1717:
1718: FA_RX_UTIL_PKG.debug('Reinstatements =' || TO_CHAR(X_reinstatements));
1719:
1720: -------------------------------------------------------------------------------
1721: FA_RX_UTIL_PKG.debug('Get positive tax reserve adjustment ');
1722:

Line 1721: FA_RX_UTIL_PKG.debug('Get positive tax reserve adjustment ');

1717:
1718: FA_RX_UTIL_PKG.debug('Reinstatements =' || TO_CHAR(X_reinstatements));
1719:
1720: -------------------------------------------------------------------------------
1721: FA_RX_UTIL_PKG.debug('Get positive tax reserve adjustment ');
1722:
1723: SELECT SUM(adjustment_amount)
1724: INTO X_tax_re_adjustment_plus
1725: FROM fa_adjustments AD

Line 1734: FA_RX_UTIL_PKG.debug('Positive tax reserve adjustment =' || TO_CHAR(X_tax_re_adjustment_plus));

1730: AND AD.asset_id = JGRX_FAREG.var.asset_id
1731: AND AD.period_counter_created BETWEEN PARM.p_begin_period_counter
1732: AND PARM.p_end_period_counter;
1733: -- changed period_counter_adjusted to period_counter_created
1734: FA_RX_UTIL_PKG.debug('Positive tax reserve adjustment =' || TO_CHAR(X_tax_re_adjustment_plus));
1735:
1736:
1737: JGRX_FAREG.var.deprn_reserve_increase := NVL(X_ord_deprn,0) +
1738: NVL(X_reinstatements,0) +

Line 1741: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.deprn_reserve_increase =' || JGRX_FAREG.var.deprn_reserve_increase);

1737: JGRX_FAREG.var.deprn_reserve_increase := NVL(X_ord_deprn,0) +
1738: NVL(X_reinstatements,0) +
1739: NVL(X_tax_re_adjustment_plus,0);
1740:
1741: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.deprn_reserve_increase =' || JGRX_FAREG.var.deprn_reserve_increase);
1742:
1743:
1744: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_increase()-');
1745:

Line 1744: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_increase()-');

1740:
1741: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.deprn_reserve_increase =' || JGRX_FAREG.var.deprn_reserve_increase);
1742:
1743:
1744: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_increase()-');
1745:
1746:
1747: END Get_deprn_reserve_increase;
1748:

Line 1761: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_decrease()+');

1757: X_financ_adjustment_minus NUMBER := 0;
1758: X_tax_re_adjustment_minus NUMBER := 0;
1759:
1760: BEGIN
1761: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_decrease()+');
1762:
1763:
1764: -------------------------------------------------------------------------------
1765: FA_RX_UTIL_PKG.debug('Get deprn reserve decrease due to retirements and revaluations');

Line 1765: FA_RX_UTIL_PKG.debug('Get deprn reserve decrease due to retirements and revaluations');

1761: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_decrease()+');
1762:
1763:
1764: -------------------------------------------------------------------------------
1765: FA_RX_UTIL_PKG.debug('Get deprn reserve decrease due to retirements and revaluations');
1766:
1767: SELECT abs(SUM(DECODE(adjustment_type,'RESERVE',adjustment_amount,0)) -
1768: SUM(DECODE(adjustment_type,'BONUS RESERVE',adjustment_amount,0)))
1769: INTO X_retirements

Line 1780: FA_RX_UTIL_PKG.debug('Retirements =' || TO_CHAR(X_retirements));

1776: AND PARM.p_end_period_counter;
1777:
1778:
1779:
1780: FA_RX_UTIL_PKG.debug('Retirements =' || TO_CHAR(X_retirements));
1781:
1782:
1783:
1784: -------------------------------------------------------------------------------

Line 1785: FA_RX_UTIL_PKG.debug('Get negative financial adjustment ');

1781:
1782:
1783:
1784: -------------------------------------------------------------------------------
1785: FA_RX_UTIL_PKG.debug('Get negative financial adjustment ');
1786:
1787: SELECT abs(SUM(DECODE(adjustment_type,'EXPENSE',adjustment_amount,0)) -
1788: SUM(DECODE(adjustment_type,'BONUS EXPENSE',adjustment_amount,0)))
1789: INTO X_financ_adjustment_minus

Line 1798: FA_RX_UTIL_PKG.debug('Negative financial adjustment =' || TO_CHAR(X_financ_adjustment_minus));

1794: AND AD.asset_id = JGRX_FAREG.var.asset_id
1795: AND AD.period_counter_adjusted BETWEEN PARM.p_begin_period_counter
1796: AND PARM.p_end_period_counter;
1797:
1798: FA_RX_UTIL_PKG.debug('Negative financial adjustment =' || TO_CHAR(X_financ_adjustment_minus));
1799:
1800: JGRX_FAREG.var.deprn_reserve_increase := JGRX_FAREG.var.deprn_reserve_increase +nvl(X_financ_adjustment_minus,0);
1801:
1802: /* to show the increase and then minus it */

Line 1805: FA_RX_UTIL_PKG.debug('Get negative tax reserve adjustment ');

1801:
1802: /* to show the increase and then minus it */
1803:
1804: -------------------------------------------------------------------------------
1805: FA_RX_UTIL_PKG.debug('Get negative tax reserve adjustment ');
1806:
1807: SELECT SUM(adjustment_amount)
1808: INTO X_tax_re_adjustment_minus
1809: FROM fa_adjustments AD

Line 1818: FA_RX_UTIL_PKG.debug('Negative tax reserve adjustment =' || TO_CHAR(X_tax_re_adjustment_minus));

1814: AND AD.asset_id = JGRX_FAREG.var.asset_id
1815: AND AD.period_counter_created BETWEEN PARM.p_begin_period_counter
1816: AND PARM.p_end_period_counter;
1817: -- jmary changed period_counter_adjusted to period_counter_created
1818: FA_RX_UTIL_PKG.debug('Negative tax reserve adjustment =' || TO_CHAR(X_tax_re_adjustment_minus));
1819:
1820:
1821: JGRX_FAREG.var.deprn_reserve_decrease := NVL(X_retirements,0) +
1822: NVL(X_financ_adjustment_minus,0) +

Line 1825: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.deprn_reserve_decrease =' || JGRX_FAREG.var.deprn_reserve_decrease);

1821: JGRX_FAREG.var.deprn_reserve_decrease := NVL(X_retirements,0) +
1822: NVL(X_financ_adjustment_minus,0) +
1823: NVL(X_tax_re_adjustment_minus,0);
1824:
1825: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.deprn_reserve_decrease =' || JGRX_FAREG.var.deprn_reserve_decrease);
1826:
1827:
1828: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_decrease()-');
1829:

Line 1828: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_decrease()-');

1824:
1825: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.deprn_reserve_decrease =' || JGRX_FAREG.var.deprn_reserve_decrease);
1826:
1827:
1828: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_deprn_reserve_decrease()-');
1829:
1830:
1831: END Get_deprn_reserve_decrease;
1832:

Line 1844: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_value()+');

1840:
1841: X_msg VARCHAR2(100);
1842:
1843: BEGIN
1844: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_value()+');
1845:
1846: -------------------------------------------------------------------------------
1847: BEGIN
1848: FA_RX_UTIL_PKG.debug('Get bonus reserve initial value');

Line 1848: FA_RX_UTIL_PKG.debug('Get bonus reserve initial value');

1844: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_value()+');
1845:
1846: -------------------------------------------------------------------------------
1847: BEGIN
1848: FA_RX_UTIL_PKG.debug('Get bonus reserve initial value');
1849: -- Get initial value
1850:
1851: SELECT NVL(bonus_deprn_reserve,0)
1852: INTO JGRX_FAREG.var.bonus_reserve_initial

Line 1864: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.bonus_reserve_initial =' || TO_CHAR(JGRX_FAREG.var.bonus_reserve_initial));

1860: AND asset_id= JGRX_FAREG.var.asset_id
1861: AND book_type_code = PARM.p_book_type_code );
1862:
1863:
1864: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.bonus_reserve_initial =' || TO_CHAR(JGRX_FAREG.var.bonus_reserve_initial));
1865: EXCEPTION
1866: WHEN NO_DATA_FOUND THEN
1867: JGRX_FAREG.var.bonus_reserve_initial := 0;
1868: END;

Line 1873: FA_RX_UTIL_PKG.debug('Get bonus reserve final value');

1869:
1870:
1871: -------------------------------------------------------------------------------
1872: BEGIN
1873: FA_RX_UTIL_PKG.debug('Get bonus reserve final value');
1874: -- Get final value
1875: SELECT NVL(bonus_deprn_reserve,0)
1876: INTO JGRX_FAREG.var.bonus_reserve_final
1877: FROM fa_deprn_summary

Line 1888: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.bonus_reserve_final =' || TO_CHAR(JGRX_FAREG.var.bonus_reserve_final));

1884: AND asset_id= JGRX_FAREG.var.asset_id
1885: AND book_type_code = PARM.p_book_type_code );
1886:
1887:
1888: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.bonus_reserve_final =' || TO_CHAR(JGRX_FAREG.var.bonus_reserve_final));
1889: EXCEPTION
1890: WHEN NO_DATA_FOUND THEN
1891: JGRX_FAREG.var.bonus_reserve_final := 0;
1892: END;

Line 1904: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.bonus_variation =' || JGRX_FAREG.var.bonus_variation);

1900: -- 09/08/00 AFERRARA
1901: JGRX_FAREG.var.bonus_variation := JGRX_FAREG.var.bonus_reserve_increase -
1902: JGRX_FAREG.var.bonus_reserve_decrease;
1903:
1904: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.bonus_variation =' || JGRX_FAREG.var.bonus_variation);
1905: -- 09/08/00 AFERRARA
1906:
1907:
1908:

Line 1909: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_value()-');

1905: -- 09/08/00 AFERRARA
1906:
1907:
1908:
1909: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_value()-');
1910:
1911: EXCEPTION
1912: WHEN TOO_MANY_ROWS THEN
1913: X_msg := 'JGRX_FAREG.Get_bonus_reserve_value: TOO_MANY_ROWS';

Line 1914: FA_RX_UTIL_PKG.debug(X_msg);

1910:
1911: EXCEPTION
1912: WHEN TOO_MANY_ROWS THEN
1913: X_msg := 'JGRX_FAREG.Get_bonus_reserve_value: TOO_MANY_ROWS';
1914: FA_RX_UTIL_PKG.debug(X_msg);
1915: RAISE_APPLICATION_ERROR(-20010,X_msg);
1916:
1917:
1918: END Get_bonus_reserve_value;

Line 1934: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_increase()+');

1930: X_financ_adjustment_plus NUMBER := 0;
1931: X_tax_re_adjustment_plus NUMBER := 0;
1932:
1933: BEGIN
1934: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_increase()+');
1935:
1936: -------------------------------------------------------------------------------
1937: FA_RX_UTIL_PKG.debug('Get bonus depreciation ');
1938:

Line 1937: FA_RX_UTIL_PKG.debug('Get bonus depreciation ');

1933: BEGIN
1934: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_increase()+');
1935:
1936: -------------------------------------------------------------------------------
1937: FA_RX_UTIL_PKG.debug('Get bonus depreciation ');
1938:
1939: SELECT sum(bonus_deprn_amount)
1940: INTO X_bonus_deprn
1941: FROM fa_deprn_summary

Line 1947: FA_RX_UTIL_PKG.debug('Bonus depreciation =' || TO_CHAR(X_bonus_deprn));

1943: AND asset_id = JGRX_FAREG.var.asset_id
1944: AND period_counter BETWEEN PARM.p_begin_period_counter
1945: AND PARM.p_end_period_counter;
1946:
1947: FA_RX_UTIL_PKG.debug('Bonus depreciation =' || TO_CHAR(X_bonus_deprn));
1948:
1949:
1950: -------------------------------------------------------------------------------
1951: FA_RX_UTIL_PKG.debug('Get reinstatements ');

Line 1951: FA_RX_UTIL_PKG.debug('Get reinstatements ');

1947: FA_RX_UTIL_PKG.debug('Bonus depreciation =' || TO_CHAR(X_bonus_deprn));
1948:
1949:
1950: -------------------------------------------------------------------------------
1951: FA_RX_UTIL_PKG.debug('Get reinstatements ');
1952:
1953: SELECT SUM(adjustment_amount)
1954: INTO X_reinstatements
1955: FROM fa_adjustments AD

Line 1963: FA_RX_UTIL_PKG.debug('Reinstatements =' || TO_CHAR(X_reinstatements));

1959: AND AD.adjustment_type = 'BONUS RESERVE'
1960: AND AD.debit_credit_flag = 'CR'
1961: AND AD.period_counter_adjusted BETWEEN PARM.p_begin_period_counter
1962: AND PARM.p_end_period_counter;
1963: FA_RX_UTIL_PKG.debug('Reinstatements =' || TO_CHAR(X_reinstatements));
1964:
1965:
1966: JGRX_FAREG.var.bonus_reserve_increase := NVL(X_bonus_deprn,0) +
1967: NVL(X_reinstatements,0) ;

Line 1969: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.bonus_reserve_increase =' || JGRX_FAREG.var.bonus_reserve_increase);

1965:
1966: JGRX_FAREG.var.bonus_reserve_increase := NVL(X_bonus_deprn,0) +
1967: NVL(X_reinstatements,0) ;
1968:
1969: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.bonus_reserve_increase =' || JGRX_FAREG.var.bonus_reserve_increase);
1970:
1971:
1972: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_increase()-');
1973:

Line 1972: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_increase()-');

1968:
1969: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.bonus_reserve_increase =' || JGRX_FAREG.var.bonus_reserve_increase);
1970:
1971:
1972: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_increase()-');
1973:
1974:
1975: END Get_bonus_reserve_increase;
1976:

Line 1988: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_decrease()+');

1984: X_retirements NUMBER := 0;
1985: X_financ_adjustment_minus NUMBER := 0;
1986:
1987: BEGIN
1988: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_decrease()+');
1989:
1990:
1991: -------------------------------------------------------------------------------
1992: FA_RX_UTIL_PKG.debug('Get retirements and revaluations ');

Line 1992: FA_RX_UTIL_PKG.debug('Get retirements and revaluations ');

1988: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_decrease()+');
1989:
1990:
1991: -------------------------------------------------------------------------------
1992: FA_RX_UTIL_PKG.debug('Get retirements and revaluations ');
1993: SELECT ABS(SUM(adjustment_amount))
1994: INTO X_retirements
1995: FROM fa_adjustments AD
1996: WHERE AD.source_type_code in ('RETIREMENT','REVALUATION')

Line 2005: FA_RX_UTIL_PKG.debug('Retirements =' || TO_CHAR(X_retirements));

2001: AND AD.period_counter_adjusted BETWEEN PARM.p_begin_period_counter
2002: AND PARM.p_end_period_counter;
2003:
2004:
2005: FA_RX_UTIL_PKG.debug('Retirements =' || TO_CHAR(X_retirements));
2006:
2007:
2008:
2009: -------------------------------------------------------------------------------

Line 2010: FA_RX_UTIL_PKG.debug('Get Negative financial adjustment ');

2006:
2007:
2008:
2009: -------------------------------------------------------------------------------
2010: FA_RX_UTIL_PKG.debug('Get Negative financial adjustment ');
2011: SELECT ABS(SUM(adjustment_amount))
2012: INTO X_financ_adjustment_minus
2013: FROM fa_adjustments AD
2014: WHERE AD.source_type_code = 'DEPRECIATION'

Line 2023: FA_RX_UTIL_PKG.debug('Negative financial adjustment =' || TO_CHAR(X_financ_adjustment_minus));

2019: AND AD.period_counter_adjusted BETWEEN PARM.p_begin_period_counter
2020: AND PARM.p_end_period_counter;
2021: JGRX_FAREG.var.bonus_reserve_increase := JGRX_FAREG.var.bonus_reserve_increase +nvl(X_financ_adjustment_minus,0);
2022:
2023: FA_RX_UTIL_PKG.debug('Negative financial adjustment =' || TO_CHAR(X_financ_adjustment_minus));
2024:
2025:
2026: JGRX_FAREG.var.bonus_reserve_decrease := NVL(X_retirements,0) +
2027: NVL(X_financ_adjustment_minus,0);

Line 2029: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.bonus_reserve_decrease =' || JGRX_FAREG.var.bonus_reserve_decrease);

2025:
2026: JGRX_FAREG.var.bonus_reserve_decrease := NVL(X_retirements,0) +
2027: NVL(X_financ_adjustment_minus,0);
2028:
2029: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.bonus_reserve_decrease =' || JGRX_FAREG.var.bonus_reserve_decrease);
2030:
2031:
2032: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_decrease()-');
2033:

Line 2032: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_decrease()-');

2028:
2029: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.bonus_reserve_decrease =' || JGRX_FAREG.var.bonus_reserve_decrease);
2030:
2031:
2032: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_reserve_decrease()-');
2033:
2034:
2035: END Get_bonus_reserve_decrease;
2036:

Line 2047: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_fiscal_year_date()+');

2043:
2044: X_msg VARCHAR2(100);
2045:
2046: BEGIN
2047: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_fiscal_year_date()+');
2048:
2049: SELECT start_date,
2050: end_date,
2051: deprn_calendar,

Line 2064: FA_RX_UTIL_PKG.debug('X_fiscal_year_start_date =' || TO_CHAR(X_fiscal_year_start_date));

2060: AND FY.fiscal_year_name = BC.fiscal_year_name
2061: AND BC.book_type_code = PARM.p_book_type_code;
2062:
2063:
2064: FA_RX_UTIL_PKG.debug('X_fiscal_year_start_date =' || TO_CHAR(X_fiscal_year_start_date));
2065: FA_RX_UTIL_PKG.debug('X_fiscal_year_end_date =' || TO_CHAR(X_fiscal_year_end_date));
2066:
2067:
2068: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_fiscal_year_date()-');

Line 2065: FA_RX_UTIL_PKG.debug('X_fiscal_year_end_date =' || TO_CHAR(X_fiscal_year_end_date));

2061: AND BC.book_type_code = PARM.p_book_type_code;
2062:
2063:
2064: FA_RX_UTIL_PKG.debug('X_fiscal_year_start_date =' || TO_CHAR(X_fiscal_year_start_date));
2065: FA_RX_UTIL_PKG.debug('X_fiscal_year_end_date =' || TO_CHAR(X_fiscal_year_end_date));
2066:
2067:
2068: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_fiscal_year_date()-');
2069:

Line 2068: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_fiscal_year_date()-');

2064: FA_RX_UTIL_PKG.debug('X_fiscal_year_start_date =' || TO_CHAR(X_fiscal_year_start_date));
2065: FA_RX_UTIL_PKG.debug('X_fiscal_year_end_date =' || TO_CHAR(X_fiscal_year_end_date));
2066:
2067:
2068: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_fiscal_year_date()-');
2069:
2070: EXCEPTION
2071: WHEN NO_DATA_FOUND THEN
2072: X_msg := 'JGRX_FAREG.Get_fiscal_year_date: NO_DATA_FOUND';

Line 2073: FA_RX_UTIL_PKG.debug(X_msg);

2069:
2070: EXCEPTION
2071: WHEN NO_DATA_FOUND THEN
2072: X_msg := 'JGRX_FAREG.Get_fiscal_year_date: NO_DATA_FOUND';
2073: FA_RX_UTIL_PKG.debug(X_msg);
2074: RAISE_APPLICATION_ERROR(-20010,X_msg);
2075:
2076: WHEN TOO_MANY_ROWS THEN
2077: X_msg := 'JGRX_FAREG.Get_fiscal_year_date: TOO_MANY_ROWS';

Line 2078: FA_RX_UTIL_PKG.debug(X_msg);

2074: RAISE_APPLICATION_ERROR(-20010,X_msg);
2075:
2076: WHEN TOO_MANY_ROWS THEN
2077: X_msg := 'JGRX_FAREG.Get_fiscal_year_date: TOO_MANY_ROWS';
2078: FA_RX_UTIL_PKG.debug(X_msg);
2079: RAISE_APPLICATION_ERROR(-20010,X_msg);
2080:
2081: END Get_fiscal_year_date;
2082:

Line 2094: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_rate()+');

2090: X_year NUMBER;
2091: X_starting_depreciation_year NUMBER(4);
2092:
2093: BEGIN
2094: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_rate()+');
2095:
2096: JGRX_FAREG.var.bonus_rate := 0; -- To print 0 instead of NULL
2097:
2098: IF JGRX_FAREG.var.bonus_rule IS NOT NULL THEN

Line 2099: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_rate: JGRX_FAREG.var.bonus_rule IS NOT NULL');

2095:
2096: JGRX_FAREG.var.bonus_rate := 0; -- To print 0 instead of NULL
2097:
2098: IF JGRX_FAREG.var.bonus_rule IS NOT NULL THEN
2099: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_bonus_rate: JGRX_FAREG.var.bonus_rule IS NOT NULL');
2100:
2101: X_starting_depreciation_year := Get_starting_depreciation_year;
2102:
2103: X_year := TO_NUMBER(X_fiscal_year) - X_starting_depreciation_year + 1;

Line 2130: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_transactions()+');

2126:
2127: X_msg VARCHAR2(100);
2128:
2129: BEGIN
2130: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_transactions()+');
2131:
2132: Get_addition_transactions;
2133:
2134: Get_adjustment_transactions;

Line 2140: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_transactions()-');

2136: Get_retirement_transactions;
2137:
2138: Get_revaluation_transactions;
2139:
2140: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_transactions()-');
2141:
2142: END Get_transactions;
2143:
2144:

Line 2168: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_addition_transactions()+');

2164: AND TH.transaction_date_entered BETWEEN X_fiscal_year_start_date
2165: AND PARM.p_end_period_to_date;
2166: -- changing X_fiscal_year_end_date to PARM.p_end_period_to_date
2167: BEGIN
2168: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_addition_transactions()+');
2169: FOR c_addition IN c_additon_trans LOOP
2170: IF (X_first_row = FALSE and c_additon_trans%ROWCOUNT=0) then
2171: exit ;
2172: end if;

Line 2187: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_addition_transactions()-');

2183: p_transaction_amount => c_addition.cost);
2184: END IF;
2185:
2186: END LOOP;
2187: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_addition_transactions()-');
2188:
2189: END Get_addition_transactions;
2190:
2191:

Line 2219: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_adjustment_transactions()+');

2215:
2216: -- changing X_fiscal_year_end_date to PARM.p_end_period_to_date
2217:
2218: BEGIN
2219: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_adjustment_transactions()+');
2220: FOR c_adjustment IN c_adjustment_trans LOOP
2221: IF (X_first_row = FALSE and c_adjustment_trans%ROWCOUNT=0) then
2222: exit ;
2223: end if;

Line 2239: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_adjustment_transactions()-');

2235: END IF;
2236:
2237: END LOOP;
2238:
2239: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_adjustment_transactions()-');
2240:
2241: END Get_adjustment_transactions;
2242:
2243:

Line 2271: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_retirement_transactions()+');

2267:
2268: -- changing X_fiscal_year_end_date to PARM.p_end_period_to_date
2269:
2270: BEGIN
2271: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_retirement_transactions()+');
2272:
2273: FOR c_retirement IN c_retirement_trans LOOP
2274: IF (X_first_row = FALSE and c_retirement_trans%ROWCOUNT=0) then
2275: exit ;

Line 2292: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_retirement_transactions()-');

2288: END IF;
2289:
2290: END LOOP;
2291:
2292: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_retirement_transactions()-');
2293:
2294: END Get_retirement_transactions;
2295:
2296: /*===================================================================+

Line 2326: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation_transactions()+');

2322:
2323: -- changing X_fiscal_year_end_date to PARM.p_end_period_to_date
2324:
2325: BEGIN
2326: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation_transactions()+');
2327: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation_transactions()+');
2328: FOR c_revaluation IN c_revaluation_trans LOOP
2329: IF X_first_row = FALSE THEN -- It is the first time...
2330: JGRX_FAREG.var.transaction_date := c_revaluation.transaction_date_entered;

Line 2327: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation_transactions()+');

2323: -- changing X_fiscal_year_end_date to PARM.p_end_period_to_date
2324:
2325: BEGIN
2326: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation_transactions()+');
2327: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation_transactions()+');
2328: FOR c_revaluation IN c_revaluation_trans LOOP
2329: IF X_first_row = FALSE THEN -- It is the first time...
2330: JGRX_FAREG.var.transaction_date := c_revaluation.transaction_date_entered;
2331: JGRX_FAREG.var.transaction_number := c_revaluation.transaction_header_id;

Line 2336: FA_RX_UTIL_PKG.debug('JGRX_FAREG.rowcount'||to_char(c_revaluation_trans%ROWCOUNT));

2332: JGRX_FAREG.var.transaction_code := c_revaluation.transaction_type_code;
2333: JGRX_FAREG.var.transaction_amount := c_revaluation.adjustment_amount;
2334: X_first_row := TRUE;
2335: ELSE -- The current row is alredy used
2336: FA_RX_UTIL_PKG.debug('JGRX_FAREG.rowcount'||to_char(c_revaluation_trans%ROWCOUNT));
2337: Insert_transaction(p_transaction_date => c_revaluation.transaction_date_entered,
2338: p_transaction_number => c_revaluation.transaction_header_id,
2339: p_transaction_code => c_revaluation.transaction_type_code,
2340: p_transaction_amount => c_revaluation.adjustment_amount);

Line 2345: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation_transactions()-');

2341: END IF;
2342:
2343: END LOOP;
2344:
2345: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_revaluation_transactions()-');
2346:
2347: END Get_revaluation_transactions;
2348:
2349:

Line 2360: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Insert_transaction()+');

2356: p_transaction_amount NUMBER)
2357: IS
2358:
2359: BEGIN
2360: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Insert_transaction()+');
2361:
2362: INSERT INTO jg_zz_fa_reg_itf(
2363: request_id,
2364: organization_name,

Line 2502: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Insert_transaction()-');

2498: JGRX_FAREG.var.revaluation_total -- 09/08/00 AFERRARA
2499: );
2500:
2501:
2502: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Insert_transaction()-');
2503:
2504: END Insert_transaction;
2505:
2506:

Line 2514: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_Net_Book_Value()+');

2510: PROCEDURE Get_Net_Book_Value
2511: IS
2512:
2513: BEGIN
2514: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_Net_Book_Value()+');
2515:
2516: JGRX_FAREG.var.net_book_value_initial := NVL(JGRX_FAREG.var.asset_cost_initial,0) -
2517: NVL(JGRX_FAREG.var.deprn_reserve_initial,0) -
2518: NVL(JGRX_FAREG.var.bonus_reserve_initial,0) ;

Line 2534: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.netbo_variation =' || JGRX_FAREG.var.netbo_variation);

2530: -- + 09/08/00 AFERRARA
2531: JGRX_FAREG.var.netbo_variation := JGRX_FAREG.var.net_book_value_increase -
2532: JGRX_FAREG.var.net_book_value_decrease;
2533:
2534: FA_RX_UTIL_PKG.debug('JGRX_FAREG.var.netbo_variation =' || JGRX_FAREG.var.netbo_variation);
2535: -- - 09/08/00 AFERRARA
2536:
2537: JGRX_FAREG.var.net_book_value_final := NVL(JGRX_FAREG.var.asset_cost_final,0) -
2538: NVL(JGRX_FAREG.var.deprn_reserve_final,0) -

Line 2541: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_Net_Book_Value()-');

2537: JGRX_FAREG.var.net_book_value_final := NVL(JGRX_FAREG.var.asset_cost_final,0) -
2538: NVL(JGRX_FAREG.var.deprn_reserve_final,0) -
2539: NVL(JGRX_FAREG.var.bonus_reserve_final,0) ;
2540:
2541: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_Net_Book_Value()-');
2542:
2543: END Get_Net_Book_Value;
2544:
2545: