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.

[Home] [Help]

APPS.GHR_MTI_INT_INSERT SQL Statements

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

Line: 114


                 l_action := 'INSERT';

Line: 123


                 l_action := 'UPDATE';

Line: 129


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: 369


    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: 376


       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: 405


    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: 411


       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: 449


    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: 455


       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: 478


    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: 484


       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: 511


    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: 517


       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: 539


    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: 545


       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: 574


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

Line: 576


       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: 582


       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: 608


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

Line: 610


       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: 616


       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: 680


    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: 687


       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: 722


    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: 729


       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: 762


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

Line: 764


       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: 770


       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: 799


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

Line: 801


       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: 807


       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: 832


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

Line: 834


       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_ei3_rec);

Line: 840


       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_ei3_rec);

Line: 866


   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: 877


      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: 899


      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: 916


      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: 923


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: 964


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

Line: 985


  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;