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 138: h_theoretical_residual_rate number;

134: h_add_year number; /* RRRR */
135: h_add_month number;
136: h_start_life number;
137: h_end_life number;
138: h_theoretical_residual_rate number;
139: h_evaluated_residual_rate number;
140: h_adjusted_rate number;
141: h_theoretical_taxable_cost number;
142: h_evaluated_taxable_cost number;

Line 139: h_evaluated_residual_rate number;

135: h_add_month number;
136: h_start_life number;
137: h_end_life number;
138: h_theoretical_residual_rate number;
139: h_evaluated_residual_rate number;
140: h_adjusted_rate number;
141: h_theoretical_taxable_cost number;
142: h_evaluated_taxable_cost number;
143: h_all_reason_type varchar2(30);

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

189: h_req3 number;
190: h_req4 number;
191:
192: /* NBV CALCULATION */
193: h_half_rate number; /* half year residual rate */
194: h_full_rate number; /* full year residual rate */
195: h_diff_year number; /* target year - add_year */
196: i number :=0; /* Loop counter */
197: k number :=0; /* Loop counter for main sql */

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

190: h_req4 number;
191:
192: /* NBV CALCULATION */
193: h_half_rate number; /* half year residual rate */
194: h_full_rate number; /* full year residual rate */
195: h_diff_year number; /* target year - add_year */
196: i number :=0; /* Loop counter */
197: k number :=0; /* Loop counter for main sql */
198:

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

1382: fa_rx_util_pkg.debug('fadptx_insert: action flag: '||h_action_flag);
1383: fa_rx_util_pkg.debug('fadptx_insert: **** End of queried values list for '||h_asset_id||' ****');
1384: -- END IF;
1385:
1386: /* Get theoretical and evaluated nbv,residual rate */
1387:
1388: /* following logic must be run only once for each asset */
1389: if dist_asset_id <> h_asset_id then
1390:

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

1713: fa_rx_util_pkg.debug('fadptx_insert: ' || 'end cost:'||h_end_cost);
1714: END IF;
1715:
1716: /*==========================================================================
1717: NBV and Residual Rate Calculation: After half_rate and full_rate,
1718: calculate NBV and Residual Rate. [First year Theoretical NBV]
1719: = [COST]*(1-[adjusted rate]*(13- [addition month])/12
1720: [Fist year Evaluated NBV]=[COST]*[half_rate] [After next year
1721: Theoretical NBV]=[Prior year Theoretical NBV]*[full_rate] [After next

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

1714: END IF;
1715:
1716: /*==========================================================================
1717: NBV and Residual Rate Calculation: After half_rate and full_rate,
1718: calculate NBV and Residual Rate. [First year Theoretical NBV]
1719: = [COST]*(1-[adjusted rate]*(13- [addition month])/12
1720: [Fist year Evaluated NBV]=[COST]*[half_rate] [After next year
1721: Theoretical NBV]=[Prior year Theoretical NBV]*[full_rate] [After next
1722: year Evaluated NBV] =[Prior year Evaluated NBV]*[full_rate]

Line 1839: /* Residual rates calculation */

1835: end if;
1836: -- End Bug 9145830
1837:
1838:
1839: /* Residual rates calculation */
1840:
1841: -- The following code is being added as part of Japan tax reforms 2008
1842: if h_year >= 2008 then
1843: h_theoretical_nbv := 0;

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

1847: CLOSE c_nbv_update;
1848:
1849: -- Bug: :Design Change
1850: -- Changed as followings
1851: -- At 1st year: Residual rate is h_half_rate
1852: -- After 2nd years: Residula rate is h_full_rate
1853:
1854: /* Bug 7422776 changed the formula for calculating h_theoretical_residual_rate for first year*/
1855: if h_diff_year = 1 then -- At 1st year

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

1850: -- Changed as followings
1851: -- At 1st year: Residual rate is h_half_rate
1852: -- After 2nd years: Residula rate is h_full_rate
1853:
1854: /* Bug 7422776 changed the formula for calculating h_theoretical_residual_rate for first year*/
1855: if h_diff_year = 1 then -- At 1st year
1856: h_theoretical_residual_rate := (1-h_adjusted_rate*
1857: (13- h_add_month)/12);
1858: if (rounding) then

Line 1856: h_theoretical_residual_rate := (1-h_adjusted_rate*

1852: -- After 2nd years: Residula rate is h_full_rate
1853:
1854: /* Bug 7422776 changed the formula for calculating h_theoretical_residual_rate for first year*/
1855: if h_diff_year = 1 then -- At 1st year
1856: h_theoretical_residual_rate := (1-h_adjusted_rate*
1857: (13- h_add_month)/12);
1858: if (rounding) then
1859: h_theoretical_residual_rate := trunc(h_theoretical_residual_rate,3);
1860: end if;

Line 1859: h_theoretical_residual_rate := trunc(h_theoretical_residual_rate,3);

1855: if h_diff_year = 1 then -- At 1st year
1856: h_theoretical_residual_rate := (1-h_adjusted_rate*
1857: (13- h_add_month)/12);
1858: if (rounding) then
1859: h_theoretical_residual_rate := trunc(h_theoretical_residual_rate,3);
1860: end if;
1861: h_evaluated_residual_rate := h_half_rate;
1862: else -- After 2 years
1863: h_theoretical_residual_rate := h_full_rate;

Line 1861: h_evaluated_residual_rate := h_half_rate;

1857: (13- h_add_month)/12);
1858: if (rounding) then
1859: h_theoretical_residual_rate := trunc(h_theoretical_residual_rate,3);
1860: end if;
1861: h_evaluated_residual_rate := h_half_rate;
1862: else -- After 2 years
1863: h_theoretical_residual_rate := h_full_rate;
1864: h_evaluated_residual_rate := h_full_rate;
1865: end if;

Line 1863: h_theoretical_residual_rate := h_full_rate;

1859: h_theoretical_residual_rate := trunc(h_theoretical_residual_rate,3);
1860: end if;
1861: h_evaluated_residual_rate := h_half_rate;
1862: else -- After 2 years
1863: h_theoretical_residual_rate := h_full_rate;
1864: h_evaluated_residual_rate := h_full_rate;
1865: end if;
1866:
1867: IF (g_print_debug) THEN

Line 1864: h_evaluated_residual_rate := h_full_rate;

1860: end if;
1861: h_evaluated_residual_rate := h_half_rate;
1862: else -- After 2 years
1863: h_theoretical_residual_rate := h_full_rate;
1864: h_evaluated_residual_rate := h_full_rate;
1865: end if;
1866:
1867: IF (g_print_debug) THEN
1868: fa_rx_util_pkg.debug('fadptx_insert: ' || 'theoretical nbv: '||h_theoretical_nbv);

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

1866:
1867: IF (g_print_debug) THEN
1868: fa_rx_util_pkg.debug('fadptx_insert: ' || 'theoretical nbv: '||h_theoretical_nbv);
1869: fa_rx_util_pkg.debug('fadptx_insert: ' || 'evaluated nbv: '||h_evaluated_nbv);
1870: fa_rx_util_pkg.debug('fadptx_insert: ' || 'theoretical residual rate: '||h_theoretical_residual_rate);
1871: fa_rx_util_pkg.debug('fadptx_insert: ' || 'evaluated residual rate: '||h_evaluated_residual_rate);
1872: END IF;
1873:
1874:

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

1867: IF (g_print_debug) THEN
1868: fa_rx_util_pkg.debug('fadptx_insert: ' || 'theoretical nbv: '||h_theoretical_nbv);
1869: fa_rx_util_pkg.debug('fadptx_insert: ' || 'evaluated nbv: '||h_evaluated_nbv);
1870: fa_rx_util_pkg.debug('fadptx_insert: ' || 'theoretical residual rate: '||h_theoretical_residual_rate);
1871: fa_rx_util_pkg.debug('fadptx_insert: ' || 'evaluated residual rate: '||h_evaluated_residual_rate);
1872: END IF;
1873:
1874:
1875: /* Set Taxable Cost */

Line 2332: THEORETICAL_RESIDUAL_RATE,

2328: ADD_ERA_YEAR,
2329: ADD_MONTH,
2330: START_LIFE,
2331: END_LIFE,
2332: THEORETICAL_RESIDUAL_RATE,
2333: EVALUATED_RESIDUAL_RATE,
2334: THEORETICAL_TAXABLE_COST,
2335: EVALUATED_TAXABLE_COST,
2336: ADJUSTED_RATE,

Line 2333: EVALUATED_RESIDUAL_RATE,

2329: ADD_MONTH,
2330: START_LIFE,
2331: END_LIFE,
2332: THEORETICAL_RESIDUAL_RATE,
2333: EVALUATED_RESIDUAL_RATE,
2334: THEORETICAL_TAXABLE_COST,
2335: EVALUATED_TAXABLE_COST,
2336: ADJUSTED_RATE,
2337: INCREASE_COST,

Line 2379: h_theoretical_residual_rate,

2375: h_add_era_year,
2376: h_add_month,
2377: h_start_life,
2378: h_end_life,
2379: h_theoretical_residual_rate,
2380: h_evaluated_residual_rate,
2381: h_theoretical_taxable_cost,
2382: h_evaluated_taxable_cost,
2383: h_adjusted_rate,

Line 2380: h_evaluated_residual_rate,

2376: h_add_month,
2377: h_start_life,
2378: h_end_life,
2379: h_theoretical_residual_rate,
2380: h_evaluated_residual_rate,
2381: h_theoretical_taxable_cost,
2382: h_evaluated_taxable_cost,
2383: h_adjusted_rate,
2384: h_increase_cost,

Line 2450: FROM dual;

2446: -- fa_rx_util_pkg.debug ('Updated - asset id:'||h_asset_id||', state: '||h_state||' to NBV table.');
2447: -- ELSE
2448: SELECT FA_DEPRN_TAX_REP_NBVS_S.NEXTVAL
2449: INTO h_deprn_tax_rep_nbv_id
2450: FROM dual;
2451:
2452: INSERT INTO FA_DEPRN_TAX_REP_NBVS
2453: (
2454: deprn_tax_rep_nbv_id,

Line 2721: THEORETICAL_RESIDUAL_RATE,

2717: ADD_ERA_YEAR,
2718: ADD_MONTH,
2719: START_LIFE,
2720: END_LIFE,
2721: THEORETICAL_RESIDUAL_RATE,
2722: EVALUATED_RESIDUAL_RATE,
2723: THEORETICAL_TAXABLE_COST,
2724: EVALUATED_TAXABLE_COST,
2725: ADJUSTED_RATE,

Line 2722: EVALUATED_RESIDUAL_RATE,

2718: ADD_MONTH,
2719: START_LIFE,
2720: END_LIFE,
2721: THEORETICAL_RESIDUAL_RATE,
2722: EVALUATED_RESIDUAL_RATE,
2723: THEORETICAL_TAXABLE_COST,
2724: EVALUATED_TAXABLE_COST,
2725: ADJUSTED_RATE,
2726: INCREASE_COST,

Line 2790: FROM dual

2786: h_login_id,
2787: h_login_id,
2788: NULL,
2789: NULL
2790: FROM dual
2791: WHERE NOT EXISTS (SELECT 1 FROM fa_deprn_tax_rep_itf
2792: WHERE request_id=h_request_id
2793: and year=h_year
2794: and state=state_code_v(l_local_cntr)