APPS.IEX_WRITEOFFOBJ_PUB SQL Statements

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

Line: 21

      fnd_message.set_token('UPDATE', p_operation);

Line: 39

         SELECT  application_id
         FROM    fnd_application_vl
         WHERE   application_short_name = x_short_name;

Line: 44

         SELECT  msg.message_number
         FROM    fnd_new_messages msg, fnd_languages_vl lng
         WHERE   msg.message_name = x_msg
          and   msg.application_id = x_id
          and   lng.LANGUAGE_CODE = msg.language_code
          and   lng.language_id = x_lang_id;

Line: 165

 select b.user_name
      from JTF_RS_RESOURCE_EXTNS a,    JTF_RS_RESOURCE_EXTNS b
      where b.source_id = nvl(a.source_mgr_id,a.source_id)
        and a.user_name = (select fu.user_name from fnd_user fu where fu.user_id = p_id);

Line: 171

  select to_char(payment_schedule_id), invoice_currency_code, amount_due_remaining
   from ar_payment_schedules
  where customer_trx_id = p_object_id;

Line: 177

 select chr.contract_number, sum(iwob.adjustment_amount), chr.currency_code
   from iex_writeoff_objects iwob, okc_k_headers_b chr
  where chr.id = p_object_id
    and iwob.contract_id = chr.id
    and iwob.request_id = p_request_id
  group by chr.contract_number,chr.currency_code ;

Line: 256

      l_parameter_list.DELETE;

Line: 299

   SELECT name from   wf_roles
    where  orig_system     = 'FND_RESP'
      and  orig_system_id  = '23449';

Line: 304

  select rs.source_name, chr.contract_number
    from iex_cases_all_b icas,
         jtf_rs_resource_extns rs,
         iex_case_objects  ico,
         okc_k_headers_b chr
 where ico.cas_id = icas.cas_id
   and icas.owner_resource_id = rs.resource_id(+)
   and chr.id = ico.object_id
   and chr.id = to_number(p_object_id);

Line: 365

      l_parameter_list.DELETE;

Line: 420

       select object_version_number
         from iex_writeoffs
         where WRITEOFF_ID =p_WRITEOFF_ID;

Line: 466

      AddfailMsg( p_object    =>  'Writeoffs ', p_operation =>  'UPDATE' );

Line: 476

      IEX_WRITEOFFS_PVT.Update_writeoffs(
           P_Api_Version_Number   =>l_api_version_number
          ,P_Init_Msg_List        =>'F'
          ,P_Commit               =>'T'
          ,P_writeoffs_Rec        =>l_writeoff_rec
          ,x_return_status        => l_return_status
          ,x_msg_count            => l_msg_count
          ,x_msg_data             => l_msg_data
          ,xo_object_version_number  =>l_object_version_number
          );

Line: 566

    select object_version_number,writeoff_reason
      from iex_writeoffs
     where WRITEOFF_ID =p_WRITEOFF_ID;

Line: 573

   select writeoff_object_id, object_version_number, transaction_id,
          adjustment_amount, contract_id, org_id
     from iex_writeoff_objects io,ar_payment_schedules_all ap
    where WRITEOFF_ID = p_WRITEOFF_ID
      and writeoff_status ='W'
      and transaction_id = payment_schedule_id(+)
      and io.request_id = p_request_id;

Line: 618

       /** 1) insert into okl_trx_ar_adjst_b and tl
       ** 2) insert into okl_txl_adjst_lns_b and tl
       ** 3) call okl_adjst_create_pvt to create adjsutment
       ** 4) update iex_writeoff_objects with the adjustment ID
       ** 5) update iex_writeoffs disposition code to APPROVED
       ** 6) if writeoff type is CONTRACT then send asset mgr a termination notification */

      OPEN  c_get_obj_ver(l_WRITEOFF_ID);

Line: 658

         okl_trx_ar_adjsts_pub.insert_trx_ar_adjsts(
             p_api_version              =>1.0
            ,p_init_msg_list            =>'F'
            ,x_return_status            =>l_return_status
            ,x_msg_count                =>l_msg_count
            ,x_msg_data                 =>l_msg_data
            ,p_adjv_rec                 =>l_adjv_rec
            ,x_adjv_rec                 =>x_adjv_rec);

Line: 717

               select contract_number into l_contract_number
               from okc_k_headers_b
               where id=i.contract_id;

Line: 750

         okl_txl_adjsts_lns_pub.insert_txl_adjsts_lns(
             p_api_version              =>1.0
            ,p_init_msg_list            =>'F'
            ,x_return_status            =>l_return_status
            ,x_msg_count                =>l_msg_count
            ,x_msg_data                 =>l_msg_data
            ,p_ajlv_rec                 =>l_ajlv_rec
            ,x_ajlv_rec                 =>x_ajlv_rec);

Line: 867

                     p_operation =>  'UPDATE' );

Line: 869

        IEX_WRITEOFF_OBJECTS_PUB.update_writeoff_objects(
                 P_Api_Version_Number       =>l_Api_Version_Number
                ,P_Init_Msg_List            =>'F'
                ,P_Commit                   =>'F'
                ,P_writeoff_obj_rec         =>l_writeoff_obj_rec
                ,xo_object_version_number   =>l_object_version_number
                ,x_return_status            =>l_return_status
                ,x_msg_count                =>l_msg_count
                ,x_msg_data                 =>l_msg_data);

Line: 906

         AddfailMsg( p_object    =>  'Writeoffs ', p_operation =>  'UPDATE' );

Line: 913

        IEX_WRITEOFFS_PVT.Update_writeoffs(
           P_Api_Version_Number   => l_api_version_number
          ,P_Init_Msg_List        => 'F'
          ,P_Commit               => 'F'
          ,P_writeoffs_Rec        => l_writeoff_rec
          ,x_return_status        => l_return_status
          ,x_msg_count            => l_msg_count
          ,x_msg_data             => l_msg_data
          ,xo_object_version_number  =>l_object_version_number);

Line: 1017

  update disposition_code
**/
  PROCEDURE reject_writeoffs (itemtype        in varchar2,
                                 itemkey         in varchar2,
                                 actid           in number,
                                 funcmode        in varchar2,
                                 result       out nocopy varchar2) IS
l_api_version   NUMBER := 1;

Line: 1036

select object_version_number
from iex_writeoffs
where WRITEOFF_ID =p_WRITEOFF_ID;

Line: 1052

select writeoff_object_id,
       object_version_number
from iex_writeoff_objects
where WRITEOFF_ID =p_WRITEOFF_ID
and writeoff_status ='W'
and request_id      =p_request_id;

Line: 1084

                     p_operation =>  'UPDATE' );

Line: 1092

           IEX_WRITEOFF_OBJECTS_PUB.update_writeoff_objects(
            P_Api_Version_Number       =>l_Api_Version_Number
           ,P_Init_Msg_List            =>'F'
           ,P_Commit                   =>'F'
           ,P_writeoff_obj_rec         =>l_writeoff_obj_rec
           ,xo_object_version_number   =>l_object_version_number
           ,x_return_status            =>l_return_status
           ,x_msg_count                =>l_msg_count
           ,x_msg_data                 =>l_msg_data);

Line: 1124

                     p_operation =>  'UPDATE' );

Line: 1131

        IEX_WRITEOFFS_PVT.Update_writeoffs(
           P_Api_Version_Number   =>l_api_version_number
          ,P_Init_Msg_List        =>'F'
          ,P_Commit               =>'F'
          ,P_writeoffs_Rec        =>l_writeoff_rec
          ,x_return_status        => l_return_status
          ,x_msg_count            => l_msg_count
          ,x_msg_data             => l_msg_data
          ,xo_object_version_number => l_object_version_number);