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.GHR_MTI_INT_INSERT SQL Statements

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

Line: 108


                 l_action := 'INSERT';

Line: 117


                 l_action := 'UPDATE';

Line: 123


if l_action = 'INSERT' then
      map_mtv_to_assign_f(
                  p_transfer_name          => p_transfer_name,
                  p_effective_date         => p_effective_date,
                  p_assignment_id          => l_assignment_id );

Line: 351


    if p_action = 'INSERT' then
       ghr_mto_int.insert_people_f
            ( p_transfer_name        =>   p_transfer_name,
              p_inter_bg_transfer    =>   p_inter_bg_transfer,
              p_effective_date       =>   p_effective_date,
              ppf                    =>   l_people_f_rec);

Line: 358


       ghr_mto_int.update_people_f
            ( p_transfer_name        =>   p_transfer_name,
              p_inter_bg_transfer    =>   p_inter_bg_transfer,
              p_effective_date       =>   p_effective_date,
              ppf                    =>   l_people_f_rec);

Line: 387


    if p_action = 'INSERT' then
       ghr_mto_int.insert_people_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_effective_date       =>   p_effective_date,
              pp_ei                  =>   l_people_ei1_rec);

Line: 393


       ghr_mto_int.update_people_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_effective_date       =>   p_effective_date,
              pp_ei                  =>   l_people_ei1_rec);

Line: 427


    if p_action = 'INSERT' then
       ghr_mto_int.insert_people_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_effective_date       =>   p_effective_date,
              pp_ei                  =>   l_people_ei2_rec);

Line: 433


       ghr_mto_int.update_people_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_effective_date       =>   p_effective_date,
              pp_ei                  =>   l_people_ei2_rec);

Line: 456


    if p_action = 'INSERT' then
       ghr_mto_int.insert_people_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_effective_date       =>   p_effective_date,
              pp_ei                  =>   l_people_ei3_rec);

Line: 462


       ghr_mto_int.update_people_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_effective_date       =>   p_effective_date,
              pp_ei                  =>   l_people_ei3_rec);

Line: 489


    if p_action = 'INSERT' then
       ghr_mto_int.insert_people_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_effective_date       =>   p_effective_date,
              pp_ei                  =>   l_people_ei4_rec);

Line: 495


       ghr_mto_int.update_people_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_effective_date       =>   p_effective_date,
              pp_ei                  =>   l_people_ei4_rec);

Line: 517


    if p_action = 'INSERT' then
       ghr_mto_int.insert_people_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_effective_date       =>   p_effective_date,
              pp_ei                  =>   l_people_ei5_rec);

Line: 523


       ghr_mto_int.update_people_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_effective_date       =>   p_effective_date,
              pp_ei                  =>   l_people_ei5_rec);

Line: 552


    if p_action = 'INSERT' then
       l_position_ei1_rec.POSITION_ID          := p_person_id;

Line: 554


       ghr_mto_int.insert_position_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_person_id            =>   p_person_id,
              p_effective_date       =>   p_effective_date,
              p_pos_ei               =>   l_position_ei1_rec);

Line: 560


       ghr_mto_int.update_position_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_person_id            =>   p_person_id,
              p_effective_date       =>   p_effective_date,
              p_pos_ei               =>   l_position_ei1_rec);

Line: 586


    if p_action = 'INSERT' then
       l_position_ei2_rec.POSITION_ID          := p_person_id;

Line: 588


       ghr_mto_int.insert_position_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_person_id            =>   p_person_id,
              p_effective_date       =>   p_effective_date,
              p_pos_ei               =>   l_position_ei2_rec);

Line: 594


       ghr_mto_int.update_position_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_person_id            =>   p_person_id,
              p_effective_date       =>   p_effective_date,
              p_pos_ei               =>   l_position_ei2_rec);

Line: 658


    if p_action = 'INSERT' then
       ghr_mto_int.insert_element_entries
            ( p_transfer_name        =>   p_transfer_name,
              p_person_id            =>   p_person_id,
              p_effective_date       =>   p_effective_date,
              p_element              =>   l_ghr_mt_ele_rec);

Line: 665


       ghr_mto_int.update_element_entries
            ( p_transfer_name        =>   p_transfer_name,
              p_person_id            =>   p_person_id,
              p_effective_date       =>   p_effective_date,
              p_element              =>   l_ghr_mt_ele_rec);

Line: 700


    if p_action = 'INSERT' then
       ghr_mto_int.insert_misc
            ( p_transfer_name        =>   p_transfer_name,
              p_person_id            =>   p_person_id,
              p_effective_date       =>   p_effective_date,
              p_misc                 =>   l_ghr_mt_misc_rec);

Line: 707


       ghr_mto_int.update_misc
            ( p_transfer_name        =>   p_transfer_name,
              p_person_id            =>   p_person_id,
              p_effective_date       =>   p_effective_date,
              p_misc                 =>   l_ghr_mt_misc_rec);

Line: 740


    if p_action = 'INSERT' then
       l_assign_ei1_rec.ASSIGNMENT_ID          := p_person_id;

Line: 742


       ghr_mto_int.insert_assignment_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_person_id            =>   p_person_id,
              p_effective_date       =>   p_effective_date,
              p_a_ei                 =>   l_assign_ei1_rec);

Line: 748


       ghr_mto_int.update_assignment_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_person_id            =>   p_person_id,
              p_effective_date       =>   p_effective_date,
              p_a_ei                 =>   l_assign_ei1_rec);

Line: 777


    if p_action = 'INSERT' then
       l_assign_ei2_rec.ASSIGNMENT_ID          := p_person_id;

Line: 779


       ghr_mto_int.insert_assignment_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_person_id            =>   p_person_id,
              p_effective_date       =>   p_effective_date,
              p_a_ei                 =>   l_assign_ei2_rec);

Line: 785


       ghr_mto_int.update_assignment_ei
            ( p_transfer_name        =>   p_transfer_name,
              p_person_id            =>   p_person_id,
              p_effective_date       =>   p_effective_date,
              p_a_ei                 =>   l_assign_ei2_rec);

Line: 811


   if p_action = 'INSERT' then
      ghr_mto_int.insert_special_info(
              p_transfer_name        =>   p_transfer_name,
              p_effective_date       =>   p_effective_date,
              p_person_id            =>   p_person_id,
              p_flex_name            =>   l_flex_name,
              p_si                   =>   l_si );

Line: 822


      ghr_mto_int.update_special_info(
              p_transfer_name        =>   p_transfer_name,
              p_effective_date       =>   p_effective_date,
              p_person_id            =>   p_person_id,
              p_flex_name            =>   l_flex_name,
              p_si                   =>   l_si );

Line: 844


      ghr_mto_int.insert_assignment_f(
              p_transfer_name        =>   p_transfer_name,
              p_effective_date       =>   p_effective_date,
              p_a                    =>   l_assign_f_rec );

Line: 861


      ghr_mto_int.insert_position(
              p_transfer_name        =>   p_transfer_name,
              p_person_id            =>   p_person_id,
              p_effective_date       =>   p_effective_date,
              p_pos                  =>   l_position_rec);

Line: 868


Procedure Update_Process_Flag(
	p_transfer_name 		in      varchar2,
	p_include_error			in	varchar2,
	p_override_prev_selection	in	varchar2,
	p_value				in      varchar2) is

Begin
 update ghr_mt_people_f_v
 set mt_status = p_value
 where mt_name = p_transfer_name
 and nvl(mt_Status, ' ') in (' ', decode(p_include_error, 'Y', 'E', ' '),
 decode(p_override_prev_selection, 'Y', decode(p_value, 'Y', 'N', 'Y'), ' '));

Line: 909


  SELECT loc.meaning
  FROM   hr_lookups loc
  WHERE
  loc.lookup_type    = p_lookup_type
  AND    loc.lookup_code    = p_lookup_code;

Line: 930


  update ghr_mt_people_f_v
    set mt_status = p_mt_status
    where mt_name = p_mt_name and
          mt_person_id = p_mt_person_id;