APPS.IA_POST_REQUEST_PKG SQL Statements

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

Line: 30

      select irh.request_id,
             irh.book_type_code,
             irh.request_date,
             ird.asset_id,
             ird.request_detail_id,
             ird.from_distribution_id,
             ird.to_distribution_id,
             ird.to_location_id,
             ird.to_employee_id,
             ird.to_expense_ccid,
             ird.effective_date,
             irh.status,
             ird.status,
             ad.asset_number
      from   ia_request_headers irh,
             ia_request_details ird,
             fa_book_controls bc,
             fa_additions ad,
             fa_deprn_periods dp
      where  irh.request_id = ird.request_id
      and    irh.book_type_code = p_book_type_code
      and    irh.book_type_code = ird.book_type_code
      and    irh.book_type_code = bc.book_type_code
      and    irh.status in ('POST','PARTIAL_POST')
      and    ird.status = 'POST'
      and    ird.asset_id = ad.asset_id
      and    ird.book_type_code = dp.book_type_code
      and    dp.period_close_date is null
      and    nvl(ird.effective_date,nvl(irh.request_date,sysdate))
                <= dp.calendar_period_close_date
--      and    ird.request_detail_id > px_max_detail_id
--      and    MOD(ird.request_detail_id, p_total_requests) = (p_request_number -1)
      order by irh.request_id, ird.request_detail_id;

Line: 90

   l_last_update_login            number(15) := fnd_global.login_id;

Line: 215

         l_trans_rec.who_info.last_update_date := l_creation_date;

Line: 216

         l_trans_rec.who_info.last_updated_by := l_created_by;

Line: 219

         l_trans_rec.who_info.last_update_login := l_last_update_login;

Line: 228

         l_asset_dist_tbl.delete;

Line: 324

         update ia_request_details
         set    status = l_det_status(i)
         where  request_detail_id = l_request_detail_id(i);

Line: 331

               update ia_request_headers
               set status = 'COMPLETED_ERROR'
               where request_id = prev_req_id;

Line: 339

               update ia_request_headers
               set status = 'COMPLETED'
               where request_id = prev_req_id;

Line: 357

            update ia_request_headers
            set status = 'COMPLETED_ERROR'
            where request_id = prev_req_id;

Line: 365

            update ia_request_headers
            set status = 'COMPLETED'
            where request_id = prev_req_id;

Line: 465

     select  units_assigned
     into    l_curr_units
     from    fa_distribution_history
     where   asset_id = p_asset_id
     and     distribution_id = p_distribution_id
     and     date_ineffective IS NULL;

Line: 506

     select  units_assigned
     into    l_curr_units
     from    fa_distribution_history
     where   asset_id = p_asset_id
     and     distribution_id = p_distribution_id_from
     and     date_ineffective IS NULL;