APPS.FA_DEPRN_TAX_REP_PKG dependencies on FA_DEPRN_TAX_REP_PKG

Line 1: PACKAGE BODY FA_DEPRN_TAX_REP_PKG as

1: PACKAGE BODY FA_DEPRN_TAX_REP_PKG as
2: /* $Header: fadptxb.pls 120.37.12010000.2 2008/12/11 07:23:04 pmadas ship $ */
3:
4:
5: /*===========================================================================

Line 350: l_calling_fn varchar2(50) :='fa_deprn_tax_rep_pkg.fadptx_insert';

346:
347:
348:
349: -- Exception message
350: l_calling_fn varchar2(50) :='fa_deprn_tax_rep_pkg.fadptx_insert';
351: err_msg varchar2(100);
352:
353: -- Check the values of theoretical nbv and evaluated nbv on all states
354: l_chk_nbv_total number;

Line 444: fa_rx_util_pkg.debug ('*****START FA_DEPRN_TAX_REP_PKG.FADPTX_INSERT*****');

440:
441: begin
442:
443: IF (p_log_level_rec.statement_level) THEN
444: fa_rx_util_pkg.debug ('*****START FA_DEPRN_TAX_REP_PKG.FADPTX_INSERT*****');
445: END IF;
446:
447: /*======================================================================
448: SET DEFALUT

Line 950: -- l_main(k) := substrb(fa_deprn_tax_rep_pkg.debug( -- bug#2434220

946: sql_nbv := l_select_nbv||l_from_nbv||l_nbv_where;
947:
948: Loop
949:
950: -- l_main(k) := substrb(fa_deprn_tax_rep_pkg.debug( -- bug#2434220
951: l_main(k) := fa_deprn_tax_rep_pkg.debug(substrb(
952: l_select_end||' from ('||sql_base||') BA1,
953: ('||replace(sql_base_ba2,':p_target_',':p_prior_')||'
954: UNION '||sql_nbv||') BA2

Line 951: l_main(k) := fa_deprn_tax_rep_pkg.debug(substrb(

947:
948: Loop
949:
950: -- l_main(k) := substrb(fa_deprn_tax_rep_pkg.debug( -- bug#2434220
951: l_main(k) := fa_deprn_tax_rep_pkg.debug(substrb(
952: l_select_end||' from ('||sql_base||') BA1,
953: ('||replace(sql_base_ba2,':p_target_',':p_prior_')||'
954: UNION '||sql_nbv||') BA2
955: where BA1.ASSET_ID=BA2.ASSET_ID (+)

Line 2434: fa_rx_util_pkg.debug ('*****END FA_DEPRN_TAX_REP_PKG.FADPTX_INSERT*****');

2430: -- END IF;
2431:
2432: end;
2433:
2434: fa_rx_util_pkg.debug ('*****END FA_DEPRN_TAX_REP_PKG.FADPTX_INSERT*****');
2435:
2436: commit;
2437:
2438: EXCEPTION

Line 2464: FA_DEPRN_TAX_REP_PKG.DEBUG

2460: end fadptx_insert;
2461:
2462: /* ======================================================================
2463: Function
2464: FA_DEPRN_TAX_REP_PKG.DEBUG
2465:
2466: DESCRIPTION
2467: This function is to print debug main sql.
2468: =======================================================================*/

Line 2472: l_calling_fn varchar2(50) :='fa_deprn_tax_rep_pkg.debug';

2468: =======================================================================*/
2469:
2470: function debug (p_print varchar2, k number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2 is
2471:
2472: l_calling_fn varchar2(50) :='fa_deprn_tax_rep_pkg.debug';
2473:
2474: begin
2475: if k =0 then
2476: -- IF (p_log_level_rec.statement_level) THEN

Line 2495: end FA_DEPRN_TAX_REP_PKG;

2491: ,p_log_level_rec => p_log_level_rec);
2492:
2493: end debug;
2494:
2495: end FA_DEPRN_TAX_REP_PKG;