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.FA_DEPRN_TAX_REP_PKG dependencies on DUAL

Line 130: h_theoretical_residual_rate number;

126: h_add_year number; /* RRRR */
127: h_add_month number;
128: h_start_life number;
129: h_end_life number;
130: h_theoretical_residual_rate number;
131: h_evaluated_residual_rate number;
132: h_adjusted_rate number;
133: h_theoretical_taxable_cost number;
134: h_evaluated_taxable_cost number;

Line 131: h_evaluated_residual_rate number;

127: h_add_month number;
128: h_start_life number;
129: h_end_life number;
130: h_theoretical_residual_rate number;
131: h_evaluated_residual_rate number;
132: h_adjusted_rate number;
133: h_theoretical_taxable_cost number;
134: h_evaluated_taxable_cost number;
135: h_all_reason_type varchar2(30);

Line 184: h_half_rate number; /* half year residual rate */

180: h_req3 number;
181: h_req4 number;
182:
183: /* NBV CALCULATION */
184: h_half_rate number; /* half year residual rate */
185: h_full_rate number; /* full year residual rate */
186: h_diff_year number; /* target year - add_year */
187: i number :=0; /* Loop counter */
188: k number :=0; /* Loop counter for main sql */

Line 185: h_full_rate number; /* full year residual rate */

181: h_req4 number;
182:
183: /* NBV CALCULATION */
184: h_half_rate number; /* half year residual rate */
185: h_full_rate number; /* full year residual rate */
186: h_diff_year number; /* target year - add_year */
187: i number :=0; /* Loop counter */
188: k number :=0; /* Loop counter for main sql */
189:

Line 1308: /* Get theoretical and evaluated nbv,residual rate */

1304: fa_rx_util_pkg.debug('fadptx_insert: h_abs_units: '||h_abs_units);
1305: fa_rx_util_pkg.debug('fadptx_insert: **** End of queried values list for '||h_asset_id||' ****');
1306: -- END IF;
1307:
1308: /* Get theoretical and evaluated nbv,residual rate */
1309:
1310: /* following logic must be run only once for each asset */
1311: if dist_asset_id <> h_asset_id then
1312:

Line 1639: NBV and Residual Rate Calculation: After half_rate and full_rate,

1635: fa_rx_util_pkg.debug('fadptx_insert: ' || 'end cost:'||h_end_cost);
1636: END IF;
1637:
1638: /*==========================================================================
1639: NBV and Residual Rate Calculation: After half_rate and full_rate,
1640: calculate NBV and Residual Rate. [First year Theoretical NBV]
1641: = [COST]*(1-[adjusted rate]*(13- [addition month])/12
1642: [Fist year Evaluated NBV]=[COST]*[half_rate] [After next year
1643: Theoretical NBV]=[Prior year Theoretical NBV]*[full_rate] [After next

Line 1640: calculate NBV and Residual Rate. [First year Theoretical NBV]

1636: END IF;
1637:
1638: /*==========================================================================
1639: NBV and Residual Rate Calculation: After half_rate and full_rate,
1640: calculate NBV and Residual Rate. [First year Theoretical NBV]
1641: = [COST]*(1-[adjusted rate]*(13- [addition month])/12
1642: [Fist year Evaluated NBV]=[COST]*[half_rate] [After next year
1643: Theoretical NBV]=[Prior year Theoretical NBV]*[full_rate] [After next
1644: year Evaluated NBV] =[Prior year Evaluated NBV]*[full_rate]

Line 1724: /* Residual rates calculation */

1720: h_evaluated_nbv := round(h_end_cost*0.05, h_precision);
1721: end if;
1722:
1723:
1724: /* Residual rates calculation */
1725:
1726: -- Bug 7571174: The following code is being added as part of Japan tax reforms 2008
1727: if h_year >= 2008 then
1728: h_theoretical_nbv := 0;

Line 1736: -- At 1st year: Residual rate is h_half_rate

1732: CLOSE c_nbv_update;
1733:
1734: -- Bug: :Design Change
1735: -- Changed as followings
1736: -- At 1st year: Residual rate is h_half_rate
1737: -- After 2nd years: Residula rate is h_full_rate
1738:
1739: /* Bug 7571174: Bug 7422776 changed the formula for calculating h_theoretical_residual_rate for first year*/
1740: if h_diff_year = 1 then -- At 1st year

Line 1739: /* Bug 7571174: Bug 7422776 changed the formula for calculating h_theoretical_residual_rate for first year*/

1735: -- Changed as followings
1736: -- At 1st year: Residual rate is h_half_rate
1737: -- After 2nd years: Residula rate is h_full_rate
1738:
1739: /* Bug 7571174: Bug 7422776 changed the formula for calculating h_theoretical_residual_rate for first year*/
1740: if h_diff_year = 1 then -- At 1st year
1741: h_theoretical_residual_rate := (1-h_adjusted_rate*
1742: (13- h_add_month)/12);
1743: -- End Bug 7571174

Line 1741: h_theoretical_residual_rate := (1-h_adjusted_rate*

1737: -- After 2nd years: Residula rate is h_full_rate
1738:
1739: /* Bug 7571174: Bug 7422776 changed the formula for calculating h_theoretical_residual_rate for first year*/
1740: if h_diff_year = 1 then -- At 1st year
1741: h_theoretical_residual_rate := (1-h_adjusted_rate*
1742: (13- h_add_month)/12);
1743: -- End Bug 7571174
1744: h_evaluated_residual_rate := h_half_rate;
1745: else -- After 2 years

Line 1744: h_evaluated_residual_rate := h_half_rate;

1740: if h_diff_year = 1 then -- At 1st year
1741: h_theoretical_residual_rate := (1-h_adjusted_rate*
1742: (13- h_add_month)/12);
1743: -- End Bug 7571174
1744: h_evaluated_residual_rate := h_half_rate;
1745: else -- After 2 years
1746: h_theoretical_residual_rate := h_full_rate;
1747: h_evaluated_residual_rate := h_full_rate;
1748: end if;

Line 1746: h_theoretical_residual_rate := h_full_rate;

1742: (13- h_add_month)/12);
1743: -- End Bug 7571174
1744: h_evaluated_residual_rate := h_half_rate;
1745: else -- After 2 years
1746: h_theoretical_residual_rate := h_full_rate;
1747: h_evaluated_residual_rate := h_full_rate;
1748: end if;
1749:
1750: IF (p_log_level_rec.statement_level) THEN

Line 1747: h_evaluated_residual_rate := h_full_rate;

1743: -- End Bug 7571174
1744: h_evaluated_residual_rate := h_half_rate;
1745: else -- After 2 years
1746: h_theoretical_residual_rate := h_full_rate;
1747: h_evaluated_residual_rate := h_full_rate;
1748: end if;
1749:
1750: IF (p_log_level_rec.statement_level) THEN
1751: fa_rx_util_pkg.debug('fadptx_insert: ' || 'theoretical nbv: '||h_theoretical_nbv);

Line 1753: fa_rx_util_pkg.debug('fadptx_insert: ' || 'theoretical residual rate: '||h_theoretical_residual_rate);

1749:
1750: IF (p_log_level_rec.statement_level) THEN
1751: fa_rx_util_pkg.debug('fadptx_insert: ' || 'theoretical nbv: '||h_theoretical_nbv);
1752: fa_rx_util_pkg.debug('fadptx_insert: ' || 'evaluated nbv: '||h_evaluated_nbv);
1753: fa_rx_util_pkg.debug('fadptx_insert: ' || 'theoretical residual rate: '||h_theoretical_residual_rate);
1754: fa_rx_util_pkg.debug('fadptx_insert: ' || 'evaluated residual rate: '||h_evaluated_residual_rate);
1755: END IF;
1756:
1757:

Line 1754: fa_rx_util_pkg.debug('fadptx_insert: ' || 'evaluated residual rate: '||h_evaluated_residual_rate);

1750: IF (p_log_level_rec.statement_level) THEN
1751: fa_rx_util_pkg.debug('fadptx_insert: ' || 'theoretical nbv: '||h_theoretical_nbv);
1752: fa_rx_util_pkg.debug('fadptx_insert: ' || 'evaluated nbv: '||h_evaluated_nbv);
1753: fa_rx_util_pkg.debug('fadptx_insert: ' || 'theoretical residual rate: '||h_theoretical_residual_rate);
1754: fa_rx_util_pkg.debug('fadptx_insert: ' || 'evaluated residual rate: '||h_evaluated_residual_rate);
1755: END IF;
1756:
1757:
1758: /* Set Taxable Cost */

Line 2178: THEORETICAL_RESIDUAL_RATE,

2174: ADD_ERA_YEAR,
2175: ADD_MONTH,
2176: START_LIFE,
2177: END_LIFE,
2178: THEORETICAL_RESIDUAL_RATE,
2179: EVALUATED_RESIDUAL_RATE,
2180: THEORETICAL_TAXABLE_COST,
2181: EVALUATED_TAXABLE_COST,
2182: ADJUSTED_RATE,

Line 2179: EVALUATED_RESIDUAL_RATE,

2175: ADD_MONTH,
2176: START_LIFE,
2177: END_LIFE,
2178: THEORETICAL_RESIDUAL_RATE,
2179: EVALUATED_RESIDUAL_RATE,
2180: THEORETICAL_TAXABLE_COST,
2181: EVALUATED_TAXABLE_COST,
2182: ADJUSTED_RATE,
2183: INCREASE_COST,

Line 2225: h_theoretical_residual_rate,

2221: h_add_era_year,
2222: h_add_month,
2223: h_start_life,
2224: h_end_life,
2225: h_theoretical_residual_rate,
2226: h_evaluated_residual_rate,
2227: h_theoretical_taxable_cost,
2228: h_evaluated_taxable_cost,
2229: h_adjusted_rate,

Line 2226: h_evaluated_residual_rate,

2222: h_add_month,
2223: h_start_life,
2224: h_end_life,
2225: h_theoretical_residual_rate,
2226: h_evaluated_residual_rate,
2227: h_theoretical_taxable_cost,
2228: h_evaluated_taxable_cost,
2229: h_adjusted_rate,
2230: h_increase_cost,

Line 2295: FROM dual;

2291: -- fa_rx_util_pkg.debug ('Updated - asset id:'||h_asset_id||', state: '||h_state||' to NBV table.');
2292: -- ELSE
2293: SELECT FA.FA_DEPRN_TAX_REP_NBVS_S.NEXTVAL
2294: INTO h_deprn_tax_rep_nbv_id
2295: FROM dual;
2296:
2297: INSERT INTO FA_DEPRN_TAX_REP_NBVS
2298: (
2299: deprn_tax_rep_nbv_id,