eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_RLS_UPD SQL Statements

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

Line: 54


Procedure update_dml
  ( p_rec in out NOCOPY pqh_rls_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 72


    update pqh_roles
      set
       role_id                         = p_rec.role_id
      ,role_name                       = p_rec.role_name
      ,role_type_cd                    = p_rec.role_type_cd
      ,enable_flag                     = p_rec.enable_flag
      ,object_version_number           = p_rec.object_version_number
      ,business_group_id               = p_rec.business_group_id
  ,information_category       = p_rec.information_category
  ,information1	              = p_rec.information1
  ,information2	              = p_rec.information2
  ,information3	    	      = p_rec.information3
  ,information4	     	      = p_rec.information4
  ,information5	     	      = p_rec.information5
  ,information6	      	      = p_rec.information6
  ,information7	    	      = p_rec.information7
  ,information8	     	      = p_rec.information8
  ,information9	     	      = p_rec.information9
  ,information10    	      = p_rec.information10
  ,information11     	      = p_rec.information11
  ,information12    	      = p_rec.information12
  ,information13    	      = p_rec.information13
  ,information14    	      = p_rec.information14
  ,information15   	      = p_rec.information15
  ,information16   	      = p_rec.information16
  ,information17   	      = p_rec.information17
  ,information18     	      = p_rec.information18
  ,information19    	      = p_rec.information19
  ,information20     	      = p_rec.information20
  ,information21     	      = p_rec.information21
  ,information22    	      = p_rec.information22
  ,information23    	      = p_rec.information23
  ,information24    	      = p_rec.information24
  ,information25   	      = p_rec.information25
  ,information26   	      = p_rec.information26
  ,information27   	      = p_rec.information27
  ,information28     	      = p_rec.information28
  ,information29    	      = p_rec.information29
  ,information30     	      = p_rec.information30
   where role_id = p_rec.role_id;

Line: 136


End update_dml;

Line: 170


Procedure pre_update
  ( p_rec in pqh_rls_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'pre_update';

Line: 180


End pre_update;

Line: 217


Procedure post_update
  (p_effective_date               in date
  ,p_rec                        in pqh_rls_shd.g_rec_type
  ) is
--
  l_start_date         date := trunc(sysdate);

Line: 224


  l_proc  varchar2(72) := g_package||'post_update';

Line: 230


    pqh_rls_rku.after_update
    (p_effective_date         => p_effective_date
    ,p_role_id                => p_rec.role_id
    ,p_role_name              => p_rec.role_name
    ,p_role_type_cd           => p_rec.role_type_cd
    ,p_enable_flag            => p_rec.enable_flag
    ,p_object_version_number  => p_rec.object_version_number
    ,p_business_group_id      => p_rec.business_group_id
    ,p_information_category   => p_rec.information_category
    ,p_information1	      => p_rec.information1
    ,p_information2	      => p_rec.information2
    ,p_information3	      => p_rec.information3
    ,p_information4	      => p_rec.information4
    ,p_information5	      => p_rec.information5
    ,p_information6	      => p_rec.information6
    ,p_information7	      => p_rec.information7
    ,p_information8	      => p_rec.information8
    ,p_information9	      => p_rec.information9
    ,p_information10          => p_rec.information10
    ,p_information11          => p_rec.information11
    ,p_information12          => p_rec.information12
    ,p_information13          => p_rec.information13
    ,p_information14          => p_rec.information14
    ,p_information15          => p_rec.information15
    ,p_information16          => p_rec.information16
    ,p_information17          => p_rec.information17
    ,p_information18          => p_rec.information18
    ,p_information19          => p_rec.information19
    ,p_information20          => p_rec.information20
    ,p_information21          => p_rec.information21
    ,p_information22          => p_rec.information22
    ,p_information23          => p_rec.information23
    ,p_information24          => p_rec.information24
    ,p_information25          => p_rec.information25
    ,p_information26          => p_rec.information26
    ,p_information27          => p_rec.information27
    ,p_information28          => p_rec.information28
    ,p_information29          => p_rec.information29
    ,p_information30          => p_rec.information30
    ,p_role_name_o            => pqh_rls_shd.g_old_rec.role_name
    ,p_role_type_cd_o         => pqh_rls_shd.g_old_rec.role_type_cd
    ,p_enable_flag_o          => pqh_rls_shd.g_old_rec.enable_flag
    ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
    ,p_business_group_id_o    => pqh_rls_shd.g_old_rec.business_group_id
    ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
    ,p_information1_o	      => pqh_rls_shd.g_old_rec.information1
    ,p_information2_o	      => pqh_rls_shd.g_old_rec.information2
    ,p_information3_o	      => pqh_rls_shd.g_old_rec.information3
    ,p_information4_o	      => pqh_rls_shd.g_old_rec.information4
    ,p_information5_o	      => pqh_rls_shd.g_old_rec.information5
    ,p_information6_o	      => pqh_rls_shd.g_old_rec.information6
    ,p_information7_o	      => pqh_rls_shd.g_old_rec.information7
    ,p_information8_o	      => pqh_rls_shd.g_old_rec.information8
    ,p_information9_o	      => pqh_rls_shd.g_old_rec.information9
    ,p_information10_o	      => pqh_rls_shd.g_old_rec.information10
    ,p_information11_o	      => pqh_rls_shd.g_old_rec.information11
    ,p_information12_o	      => pqh_rls_shd.g_old_rec.information12
    ,p_information13_o	      => pqh_rls_shd.g_old_rec.information13
    ,p_information14_o	      => pqh_rls_shd.g_old_rec.information14
    ,p_information15_o	      => pqh_rls_shd.g_old_rec.information15
    ,p_information16_o	      => pqh_rls_shd.g_old_rec.information16
    ,p_information17_o	      => pqh_rls_shd.g_old_rec.information17
    ,p_information18_o	      => pqh_rls_shd.g_old_rec.information18
    ,p_information19_o	      => pqh_rls_shd.g_old_rec.information19
    ,p_information20_o	      => pqh_rls_shd.g_old_rec.information20
    ,p_information21_o	      => pqh_rls_shd.g_old_rec.information21
    ,p_information22_o	      => pqh_rls_shd.g_old_rec.information22
    ,p_information23_o	      => pqh_rls_shd.g_old_rec.information23
    ,p_information24_o	      => pqh_rls_shd.g_old_rec.information24
    ,p_information25_o	      => pqh_rls_shd.g_old_rec.information25
    ,p_information26_o	      => pqh_rls_shd.g_old_rec.information26
    ,p_information27_o	      => pqh_rls_shd.g_old_rec.information27
    ,p_information28_o	      => pqh_rls_shd.g_old_rec.information28
    ,p_information29_o	      => pqh_rls_shd.g_old_rec.information29
    ,p_information30_o	      => pqh_rls_shd.g_old_rec.information30
    );

Line: 313


      select ppei.person_id,usr.user_name
      from
      per_people_extra_info ppei,
      fnd_user usr
      where
      ppei.information_type = 'PQH_ROLE_USERS'
      and ppei.PEI_INFORMATION3 = p_rec.role_id
      and ppei.PEI_INFORMATION5 = 'Y'
      and ppei.person_id = usr.employee_id;

Line: 338


	   WF_EVENT.AddParameterToList('UPDATEONLY','TRUE',l_plist);

Line: 375


      select *
      from wf_local_user_roles
      where ROLE_ORIG_SYSTEM = 'PQH_ROLE'
      and ROLE_ORIG_SYSTEM_ID = p_rec.role_id;

Line: 384


     wf_event.AddParameterToList( 'DELETE', 'TRUE', l_plist);

Line: 400


     wf_event.AddParameterToList('DELETE', 'TRUE', l_plist);

Line: 413


End post_update;

Line: 644


  pqh_rls_bus.update_validate
     (p_effective_date
     ,p_rec
     );

Line: 651


  pqh_rls_upd.pre_update(p_rec);

Line: 655


  pqh_rls_upd.update_dml(p_rec);

Line: 659


  pqh_rls_upd.post_update
     (p_effective_date
     ,p_rec
     );