DBA Data[Home] [Help]

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.48.12020000.5 2013/02/12 11:43:37 adaluru ship $ */
3:
4: -- ER 7661628: Adding this variable to make the code changes for 7661628 specific to R12 only
5: g_release number := fa_cache_pkg.fazarel_release;

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

355:
356:
357:
358: -- Exception message
359: l_calling_fn varchar2(50) :='fa_deprn_tax_rep_pkg.fadptx_insert';
360: err_msg varchar2(100);
361:
362: -- Check the values of theoretical nbv and evaluated nbv on all states
363: l_chk_nbv_total number;

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

489:
490: begin
491:
492: IF (g_print_debug) THEN
493: fa_rx_util_pkg.debug ('*****START FA_DEPRN_TAX_REP_PKG.FADPTX_INSERT*****');
494: END IF;
495:
496: --Start for 9935602
497:

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

1021: sql_nbv := l_select_nbv||l_from_nbv||l_nbv_where;
1022:
1023: Loop
1024:
1025: -- l_main(k) := substrb(fa_deprn_tax_rep_pkg.debug( -- bug#2434220
1026: l_main(k) := fa_deprn_tax_rep_pkg.debug(substrb(
1027: l_select_end||' from ('||sql_base||') BA1,
1028: ('||replace(sql_base_ba2,':p_target_',':p_prior_')||'
1029: UNION '||sql_nbv||') BA2

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

1022:
1023: Loop
1024:
1025: -- l_main(k) := substrb(fa_deprn_tax_rep_pkg.debug( -- bug#2434220
1026: l_main(k) := fa_deprn_tax_rep_pkg.debug(substrb(
1027: l_select_end||' from ('||sql_base||') BA1,
1028: ('||replace(sql_base_ba2,':p_target_',':p_prior_')||'
1029: UNION '||sql_nbv||') BA2
1030: where BA1.ASSET_ID=BA2.ASSET_ID (+)

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

2650: END LOOP;
2651: end if;
2652: -- End ER 7661628
2653:
2654: fa_rx_util_pkg.debug ('*****END FA_DEPRN_TAX_REP_PKG.FADPTX_INSERT*****');
2655:
2656: --Start for change 9935602
2657:
2658: FOR l_tax_type_cntr IN 1..6

Line 2832: FA_DEPRN_TAX_REP_PKG.DEBUG

2828: end fadptx_insert;
2829:
2830: /* ======================================================================
2831: Function
2832: FA_DEPRN_TAX_REP_PKG.DEBUG
2833:
2834: DESCRIPTION
2835: This function is to print debug main sql.
2836: =======================================================================*/

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

2836: =======================================================================*/
2837:
2838: function debug (p_print varchar2, k number) return varchar2 is
2839:
2840: l_calling_fn varchar2(50) :='fa_deprn_tax_rep_pkg.debug';
2841:
2842: begin
2843: if k =0 then
2844: -- IF (g_print_debug) THEN

Line 2862: end FA_DEPRN_TAX_REP_PKG;

2858: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn);
2859:
2860: end debug;
2861:
2862: end FA_DEPRN_TAX_REP_PKG;