APPS.FARX_DP SQL Statements

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

Line: 188

		'farx_dp.bind(:CURSOR_SELECT);',

Line: 206

  if mesg_name in ('FA_SHARED_DELETE_FAILED', 'FA_SHARED_INSERT_FAILED') then
	fnd_message.set_token('TABLE', 'FA_DEPRN_REP_ITF', FALSE);

Line: 242

   maj_select_statement   varchar2(50);

Line: 243

   min_select_statement   varchar2(50);

Line: 244

   spec_select_statement  varchar2(50);

Line: 255

   select category_flex_structure, location_flex_structure,
	asset_key_flex_structure
   into var.cat_flex_struct, var.loc_flex_struct, var.assetkey_flex_struct
   from fa_system_controls;

Line: 272

   select
	bc.book_class,
	bc.accounting_flex_structure,
	bc.distribution_source_book,
	substrb(sob.currency_code, 1, 15),
	cur.precision,
	bc.fiscal_year_name,
	sob.chart_of_accounts_id,
        substrb(sob.name, 1, 80),
	sob.set_of_books_id
   into var.book_class,
	var.acct_flex_struct,
	var.dist_source_book,
	var.currency_code,
	var.precision,
	var.fy_name,
	var.chart_of_accounts_id,
	var.organization_name,
	var.set_of_books_id
   from fa_book_controls bc, gl_sets_of_books sob, fnd_currencies cur
   WHERE  bc.book_type_code = var.book
   AND    sob.set_of_books_id = bc.set_of_books_id
   AND    sob.currency_code    = cur.currency_code;

Line: 305

   select period_counter, period_open_date,
	nvl(period_close_date, sysdate),
	decode(period_close_date, null, 'NO','YES'),
	fiscal_year,
        trunc(calendar_period_open_date), -- Bug3499862
        trunc(calendar_period_close_date) -- Bug3499862
   into  var.period_counter,  var.period_open_date, var.period_close_date,
	period_closed, var.period_fy,
        var.calendar_period_open_date,var.calendar_period_close_date  -- Bug3499862
   from fa_deprn_periods
   where book_type_code = var.book
   and period_name = var.period;

Line: 346

	'SELECT', 'GL_BALANCING')||' between :from_bal and :to_bal)';

Line: 356

	'SELECT', 'GL_ACCOUNT') || ' between :from_acct and :to_acct)';

Line: 364

	'SELECT', 'FA_COST_CTR') ||' between :from_cc and :to_cc)';

Line: 371

	'SELECT', 'BASED_CATEGORY') ||' between :from_maj_cat and :to_maj_cat)';

Line: 380

	'SELECT', 'MINOR_CATEGORY') ||' between :from_min_cat and :to_min_cat)';

Line: 385

	'SELECT', 'MINOR_CATEGORY') ||'>= :from_min_cat)';

Line: 389

	'SELECT', 'MINOR_CATEGORY') ||'<= :to_min_cat )';

Line: 416

	   'SELECT',param.cat_seg_num) ||' between from_cat_seg_val and :to_cat_seg_val)';

Line: 425

    maj_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', 'BASED_CATEGORY');

Line: 428

     min_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', 'MINOR_CATEGORY');

Line: 431

       min_select_statement := 'null';

Line: 437

        spec_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', param.cat_seg_num);

Line: 439

       spec_select_statement := 'null';

Line: 444

       spec_select_statement := 'null';

Line: 502

   fa_rx_util_pkg.assign_column('47',maj_select_statement,	'major_category','farx_dp.var.major_category','VARCHAR2',240);

Line: 503

   fa_rx_util_pkg.assign_column('48',min_select_statement,	'minor_category','farx_dp.var.minor_category','VARCHAR2',240);

Line: 506

   fa_rx_util_pkg.assign_column('51',spec_select_statement,	'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);

Line: 576

           and exists (select 1
                       from   fa_books oldbk
                            , fa_transaction_headers oldth
                            , fa_deprn_periods dp
                       where  oldbk.transaction_header_id_out = books.transaction_header_id_in
                       and    oldbk.transaction_header_id_out = oldth.transaction_header_id
                       and   dp.book_type_code = :b_book
                       and   dp.period_counter = dd.period_counter
                       and   oldth.date_effective between dp.period_open_date
                                                      and nvl(dp.period_close_date, oldth.date_effective)
                       and   oldbk.group_asset_id is null)
             )
          or (nvl(:b_report_style,''S'') = ''D'')
               )
	and     dd.period_counter       = rsv.period_counter ' ||  l_param_where ;

Line: 798

 mesg_name := 'FA_SHARED_INSERT_FAILED';