APPS.FA_XADJ_ITF_PKG SQL Statements

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

Line: 81

   select fat.rowid
        , fab.asset_id id
        , fat.asset_number num
	, fat.book_type_code book
        , fat.extended_deprn_flag flag
        , fat.extended_depreciation_period period
	, fat.posting_status status
	, fat.extended_deprn_limit -- bug 6658280
     from fa_adjustments_t fat,
          fa_additions_b fab
    where fat.asset_number = fab.asset_number
--      and fat.posting_status = 'POST'
      and fat.batch_id = p_batch_id
      and fab.asset_id >= l_start_range
      and fab.asset_id <= l_end_range
 order by fat.book_type_code, fab.asset_id;

Line: 135

             select nvl(sum(decode(status,'UNASSIGNED', 1, 0)),0),
          	     nvl(sum(decode(status,'FAILED', 1, 0)),0),
          	     nvl(sum(decode(status,'IN PROCESS', 1, 0)),0),
          	     nvl(sum(decode(status,'COMPLETED',1 , 0)),0),
          	     count(*)
             into   l_unassigned_cnt,
          	     l_failed_cnt,
          	     l_wip_cnt,
          	     l_completed_cnt,
          	     l_total_cnt
             from   fa_worker_jobs
             where  request_id = p_parent_request_id;

Line: 178

	       update fa_worker_jobs
               set    status = 'IN PROCESS',
         	     worker_num = p_request_number
               where  status = 'UNASSIGNED'
               and    request_id = p_parent_request_id
               and    rownum < 2;

Line: 209

               select start_range
                     ,end_range
                into l_start_range
                    ,l_end_range
                from fa_worker_jobs
               where request_id = p_parent_request_id
                 and worker_num = p_request_number
                 and  status = 'IN PROCESS';

Line: 222

        	      select min(asset_id), max(asset_id)
                        into l_start_range
            	       , l_end_range
                        from fa_adjustments_t fat
            	       , fa_additions_b fab
                       where batch_id = p_batch_id
                         and fat.asset_number = fab.asset_number;

Line: 279

                    update fa_adjustments_t
                       set request_id = l_request_id
                     where rowid      = l_itf_rowid(l_loop_count);

Line: 286

           		    update fa_books
                               set extended_deprn_flag = l_extended_deprn_flag(l_loop_count)
                             where asset_id = l_asset_id(l_loop_count)
                               and book_type_code = l_book_type_code(l_loop_count)
                               and transaction_header_id_out is null;

Line: 292

                    update fa_adjustments_t
                       set posting_status = 'POSTED'
                         , request_id = l_request_id
                     where rowid      = l_itf_rowid(l_loop_count);

Line: 310

                    update fa_adjustments_t
                       set request_id = l_request_id
                     where rowid      = l_itf_rowid(l_loop_count);

Line: 322

			       l_asset_fin_mrc_tbl_new.delete;

Line: 324

			       l_inv_tbl.delete;

Line: 325

			       l_inv_rate_tbl.delete;

Line: 328

			       l_asset_deprn_mrc_tbl_new.delete;

Line: 331

			       l_trans_rec.who_info.last_updated_by    := FND_GLOBAL.USER_ID;

Line: 334

			       l_trans_rec.who_info.last_update_date   := sysdate;

Line: 335

			       l_trans_rec.who_info.last_update_login  := FND_GLOBAL.CONC_LOGIN_ID;

Line: 362

			       l_trans_rec.who_info.last_updated_by   := FND_GLOBAL.USER_ID;

Line: 396

			       update fa_adjustments_t
				  set posting_status   = 'POSTED',
				      request_id   = l_request_id
				where rowid        = l_itf_rowid(l_loop_count);

Line: 450

               update fa_worker_jobs
                  set status     = 'FAILED'
                where request_id = p_parent_request_id
                  and worker_num = p_request_number
                  and status     = 'IN PROCESS';

Line: 458

               	   update fa_worker_jobs
                      set status     = 'COMPLETED'
                    where request_id = p_parent_request_id
                      and worker_num = p_request_number
                      and status     = 'IN PROCESS';

Line: 482

	   update fa_worker_jobs
              set status     = 'COMPLETED'
            where request_id = p_parent_request_id
              and worker_num = p_request_number
              and status     = 'IN PROCESS';

Line: 500

	   update fa_worker_jobs
              set status     = 'FAILED'
            where request_id = p_parent_request_id
              and worker_num = p_request_number
              and status     = 'IN PROCESS';

Line: 526

	   update fa_worker_jobs
              set status     = 'FAILED'
            where request_id = p_parent_request_id
              and worker_num = p_request_number
              and status     = 'IN PROCESS';

Line: 608

   insert into fa_worker_jobs
          (start_range, end_range, worker_num, status,request_id)
   select min(aid), max(aid), 0,
          'UNASSIGNED', p_parent_request_id  from ( select /*+ parallel(dh) */
          fab.asset_id aid, floor(rank()
          over (order by fab.asset_id)/l_batch_size ) unit_id
     from fa_adjustments_t fat, fa_additions_b fab
    where batch_id = p_batch_id
      and fat.asset_number = fab.asset_number)
    group by unit_id;

Line: 623

      fa_debug_pkg.add(l_calling_fn, 'rows inserted into worker jobs: ', SQL%ROWCOUNT);