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_C_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5


PROCEDURE fadptx_insert (
  errbuf         out nocopy varchar2,
  retcode        out nocopy number,
  argument1             in  varchar2,   -- book
  argument2             in  varchar2,   -- year
  argument3             in  varchar2,   -- locstruct_num
  argument4             in  varchar2,   -- start_state
  argument5             in  varchar2,   -- end_state
  argument6             in  varchar2,   -- cat_struct_num
  argument7             in  varchar2,   -- tax_asset_type_seg
  argument8             in  varchar2,   -- minor_cat_exist
  argument9             in  varchar2,   -- start_category
  argument10            in  varchar2,   -- end_category
  argument11            in  varchar2,   -- sale_code
  argument12            in  varchar2,   -- sum_rep
  argument13            in  varchar2,   -- all_rep
  argument14            in  varchar2,   -- add_rep
  argument15            in  varchar2,   -- dec_rep
  argument16            in  varchar2,   -- debug
  argument17            in  varchar2,   -- round --bug4919991
  argument18            in  varchar2,   -- Bug 9145830: rounding of evaluated NBV
  argument19            in  varchar2,
  argument20            in  varchar2,
  argument21            in  varchar2,
  argument22            in  varchar2,
  argument23            in  varchar2,
  argument24            in  varchar2,
  argument25            in  varchar2,
  argument26            in  varchar2,
  argument27            in  varchar2,
  argument28            in  varchar2,
  argument29            in  varchar2,
  argument30            in  varchar2,
  argument31            in  varchar2,
  argument32            in  varchar2,
  argument33            in  varchar2,
  argument34            in  varchar2,
  argument35            in  varchar2,
  argument36            in  varchar2,
  argument37            in  varchar2,
  argument38            in  varchar2,
  argument39            in  varchar2,
  argument40            in  varchar2,
  argument41            in  varchar2,
  argument42            in  varchar2,
  argument43            in  varchar2,
  argument44            in  varchar2,
  argument45            in  varchar2,
  argument46            in  varchar2,
  argument47            in  varchar2,
  argument48            in  varchar2,
  argument49            in  varchar2,
  argument50            in  varchar2,
  argument51            in  varchar2,
  argument52            in  varchar2,
  argument53            in  varchar2,
  argument54            in  varchar2,
  argument55            in  varchar2,
  argument56            in  varchar2,
  argument57            in  varchar2,
  argument58            in  varchar2,
  argument59            in  varchar2,
  argument60            in  varchar2,
  argument61            in  varchar2,
  argument62            in  varchar2,
  argument63            in  varchar2,
  argument64            in  varchar2,
  argument65            in  varchar2,
  argument66            in  varchar2,
  argument67            in  varchar2,
  argument68            in  varchar2,
  argument69            in  varchar2,
  argument70            in  varchar2,
  argument71            in  varchar2,
  argument72            in  varchar2,
  argument73            in  varchar2,
  argument74            in  varchar2,
  argument75            in  varchar2,
  argument76            in  varchar2,
  argument77            in  varchar2,
  argument78            in  varchar2,
  argument79            in  varchar2,
  argument80            in  varchar2,
  argument81            in  varchar2,
  argument82            in  varchar2,
  argument83            in  varchar2,
  argument84            in  varchar2,
  argument85            in  varchar2,
  argument86            in  varchar2,
  argument87            in  varchar2,
  argument88            in  varchar2,
  argument89            in  varchar2,
  argument90            in  varchar2,
  argument91            in  varchar2,
  argument92            in  varchar2,
  argument93            in  varchar2,
  argument94            in  varchar2,
  argument95            in  varchar2,
  argument96            in  varchar2,
  argument97            in  varchar2,
  argument98            in  varchar2,
  argument99            in  varchar2,
  argument100           in  varchar2) is

  h_request_id          NUMBER;

Line: 154


  fadptx_insert_err     Exception;

Line: 155


  l_calling_fn          VARCHAR2(50) := 'fa_deprn_tax_c_pkg.fadptx_insert';

Line: 163


        raise fadptx_insert_err;

Line: 168


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument1:' ||argument1);

Line: 169


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument2:' ||argument2);

Line: 170


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument3:' ||argument3);

Line: 171


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument4:' ||argument4);

Line: 172


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument5:' ||argument5);

Line: 173


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument6:' ||argument6);

Line: 174


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument7:' ||argument7);

Line: 175


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument8:' ||argument8);

Line: 176


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument9:' ||argument9);

Line: 177


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument10:' ||argument10);

Line: 178


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument11:' ||argument11);

Line: 179


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument12:' ||argument12);

Line: 180


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument13:' ||argument13);

Line: 181


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument14:' ||argument14);

Line: 182


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument15:' ||argument15);

Line: 183


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument16:' ||argument16);

Line: 184


        fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument17:' ||argument17);

Line: 185


	fa_rx_util_pkg.debug('fadptx_insert: ' || 'argument18:' ||argument18);  -- Bug 9145830

Line: 232


   fa_deprn_tax_rep_pkg.fadptx_insert(
        errbuf          => errbuf,
        retcode         => retcode,
        book            => h_book,
        year            => h_year,
        state_from      => h_start_state,
        state_to        => h_end_state,
        tax_asset_type_seg => h_tax_asset_type_seg,  -- Bug#3305764 - Enhancement to make Category Flexfield flexible
        category_from   => h_start_category,
        category_to     => h_end_category,
        sale_code       => h_sale_code,
        all_state       => null,
        rounding        => h_round, --bug4919991
	eval_nbv_round  => h_eval_nbv_round,   -- Bug 9145830
        request_id      => h_request_id,
        login_id        => h_login_id
                                         );

Line: 250


     raise fadptx_insert_err;

Line: 267


  SELECT lower(iso_language),iso_territory
    INTO l_iso_language,l_iso_territory
    FROM FND_LANGUAGES
   WHERE language_code = USERENV('LANG');

Line: 396


  When  fadptx_insert_err THEN
        fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn);

Line: 406


END fadptx_insert;