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,
  argument18		in  varchar2,
  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: 150

  fadptx_insert_err     Exception;

Line: 151

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

Line: 159

        raise fadptx_insert_err;

Line: 164

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

Line: 165

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

Line: 166

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

Line: 167

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

Line: 168

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

Line: 169

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

Line: 170

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

Line: 171

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

Line: 172

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

Line: 173

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

Line: 174

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

Line: 175

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

Line: 176

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

Line: 177

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

Line: 178

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

Line: 179

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

Line: 223

   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,
	request_id	=> h_request_id,
	login_id	=> h_login_id
					 );

Line: 239

     raise fadptx_insert_err;

Line: 255

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

Line: 380

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

Line: 390

END fadptx_insert;