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

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

Line: 34


 l_datetrack_update_mode varchar2(50);

Line: 60


  ln_gsp_update_mode  varchar2(10);

Line: 67


    select max(pspp.effective_start_date)
    from per_spinal_point_placements_f pspp
    where pspp.placement_id=p_placement_id;

Line: 72


    select null
    from   per_spinal_point_placements_f pspp
    where  pspp.placement_id             = p_placement_id
    and    pspp.effective_start_date      = l_effective_date;

Line: 78


    select assignment_id,assignment_type, pay_basis_id
    from per_all_assignments_f
    where assignment_id = p_assignment_id and
    l_effective_date between effective_start_date and effective_end_date;

Line: 84


    select grade_id,grade_ladder_pgm_id,pay_basis_id
    from per_all_assignments_f
    where assignment_id = l_assignment_id and
    l_effective_date between effective_start_date and effective_end_date;

Line: 90


    select step_id,reason
    from per_spinal_point_placements_f
    where placement_id=p_placement_id and
    l_effective_date between effective_start_date and effective_end_date;

Line: 96


    select step_id, reason, object_version_number,
    effective_start_date, effective_end_date
    from per_spinal_point_placements_f
    where placement_id = p_placement_id and
    l_effective_date between effective_start_date and effective_end_date;

Line: 102


    CURSOR lc_sal_updateable_grade_ladder is
     select pgm_id, update_salary_cd  from ben_pgm_f
        where
         pgm_id = l_grade_ladder_pgm_id
         and l_effective_date between effective_start_date and effective_end_date;

Line: 150


      hr_transaction_ss.delete_transaction_step
         (p_transaction_step_id => l_transaction_step_id
          ,p_login_person_id => p_login_person_id);

Line: 153


      delete_pay_step(
         p_item_type => p_item_type,
         p_item_key  =>  p_item_key,
         p_login_person_id => p_login_person_id);

Line: 193


                null,--selection_mode        VARCHAR2(1),
                null,--ovn                   NUMBER,
                null,--currency              VARCHAR2(15),
                null,--pay_basis_name        VARCHAR2(80),
                null,--annual_equivalent     NUMBER ,
                null,--total_percent        NUMBER ,
                null,--quartile              NUMBER ,
                null,--comparatio            NUMBER ,
                null,--lv_selection_mode     VARCHAR2(1),
                null,--attribute_category           VARCHAR2(150),
                null,--attribute1            VARCHAR2(150),
                null,--attribute2            VARCHAR2(150),
                null,--attribute3            VARCHAR2(150),
                null,--attribute4            VARCHAR2(150),
                null,--attribute5            VARCHAR2(150),
                null,--attribute6            VARCHAR2(150),
                null,--attribute7            VARCHAR2(150),
                null,--attribute8            VARCHAR2(150),
                null,--attribute9            VARCHAR2(150),
                null,--attribute10           VARCHAR2(150),
                null,--attribute11           VARCHAR2(150),
                null,--attribute12           VARCHAR2(150),
                null,--attribute13           VARCHAR2(150),
                null,--attribute14           VARCHAR2(150),
                null,--attribute15           VARCHAR2(150),
                null,--attribute16           VARCHAR2(150),
                null,--attribute17           VARCHAR2(150),
                null,--attribute18           VARCHAR2(150),
                null,--attribute19           VARCHAR2(150),
                null,--attribute20           VARCHAR2(150),
                null, --no_of_components       NUMBER,
                null,  -- salary_basis_change_type varchar2(30)
                null,  -- default_date           date
                null,  -- default_bg_id          number
                null,  -- default_currency       VARCHAR2(15)
                null,  -- default_format_string  VARCHAR2(40)
                null,  -- default_salary_basis_name  varchar2(30)
                null,  -- default_pay_basis_name     varchar2(80)
                null,  -- default_pay_basis      varchar2(30)
                null,  -- default_pay_annual_factor  number
                null,  -- default_grade          VARCHAR2(240)
                null,  -- default_grade_annual_factor number
                null,  -- default_minimum_salary      number
                null,  -- default_maximum_salary      number
                null,  -- default_midpoint_salary     number
                null,  -- default_prev_salary         number
                null,  -- default_last_change_date    date
                null,  -- default_element_entry_id    number
                null,  -- default_basis_changed       number
                null,  -- default_uom                 VARCHAR2(30)
                null,  -- default_grade_uom           VARCHAR2(30)
                null,  -- default_change_amount       number
                null,  -- default_change_percent      number
                null,  -- default_quartile            number
                null,  -- default_comparatio          number
                null,  -- default_last_pay_change     varchar2(200)
                null,  -- default_flsa_status         varchar2(80)
                null,  -- default_currency_symbol     varchar2(4)
                null,   -- default_precision           number
                null,    -- salary_effective_date    date
                null,    -- gsp_dummy_txn            varchar2(30)
                null,
                null,
                null,
                null,
                null
          ));

Line: 288


    hr_new_user_reg_ss.process_selected_transaction(p_item_type => p_item_type,
                                                   		p_item_key => p_item_key
                                                  		,p_api_name => 'HR_PROCESS_PERSON_SS.PROCESS_API');

Line: 291


    hr_new_user_reg_ss.process_selected_transaction(p_item_type => p_item_type,
                                                   		 p_item_key => p_item_key
                    			 ,p_api_name => 'HR_PROCESS_ADDRESS_SS.PROCESS_API');

Line: 294


    hr_new_user_reg_ss.process_selected_transaction(p_item_type => p_item_type,
                                                   		  p_item_key => p_item_key
	                    		 ,p_api_name => 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API');

Line: 301


    hr_new_user_reg_ss.process_selected_transaction(p_item_type => p_item_type,
                                                   		p_item_key => p_item_key
			,p_api_name => 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API');

Line: 320


        hr_utility.set_location('Datetrack Mode Update:'||l_proc, 30);

Line: 321


        l_datetrack_update_mode:='UPDATE';

Line: 327


          l_datetrack_update_mode:='CORRECTION';

Line: 329


          hr_utility.set_location('Datetrack Mode Update Change Insert:'||l_proc, 40);

Line: 330


          l_datetrack_update_mode:='UPDATE_CHANGE_INSERT';

Line: 354


    update_step
    (p_validate => true,
    p_effective_date => l_effective_date,
    p_datetrack_update_mode => l_datetrack_update_mode,
    p_step_id   => p_step_id,
    p_reason    => p_reason,
    p_business_group_id => p_business_group_id,
    p_assignment_id => l_assignment_id,
    p_placement_id      => p_placement_id,
    p_object_version_number     => l_object_version_number,
    p_effective_start_date     => l_effective_start_date,
    p_effective_end_date       => l_effective_end_date,
    p_gsp_post_process_warning     => p_gsp_post_process_warning,
    p_ltt_salary_data => ltt_salary_data,
    p_page_error    => p_page_error,
    p_page_error_msg    => p_page_error_msg);

Line: 512


  l_trans_tbl(l_count).param_name      := 'P_DATETRACK_UPDATE_MODE';

Line: 513


  l_trans_tbl(l_count).param_value     :=  l_datetrack_update_mode;

Line: 514


  l_trans_tbl(l_count).param_original_value := l_datetrack_update_mode;

Line: 540


open lc_sal_updateable_grade_ladder;

Line: 541


fetch lc_sal_updateable_grade_ladder into lc_temp_grade_ladder_id,lc_temp_upd_sal_cd;

Line: 542


close lc_sal_updateable_grade_ladder;

Line: 576


             p_update_mode           => ln_gsp_update_mode,
             p_effective_date_option   =>    p_effective_date_option);

Line: 613


        delete_pay_step(
         p_item_type => p_item_type,
         p_item_key  =>  p_item_key,
         p_login_person_id => p_login_person_id);

Line: 723


PROCEDURE update_step
(p_validate in boolean default false,
p_effective_date in date,
p_datetrack_update_mode in varchar2 default 'UPDATE',
p_placement_id in number,
p_business_group_id in number,
p_assignment_id in number,
p_step_id in number,
p_object_version_number in number,
p_effective_start_date in date,
p_effective_end_date in date,
p_reason in varchar2 default hr_api.g_varchar2,
p_gsp_post_process_warning out nocopy varchar2,
p_ltt_salary_data    IN OUT NOCOPY  sshr_sal_prop_tab_typ,
p_page_error               in out nocopy varchar2,
p_page_error_msg           in out nocopy varchar2
)
IS
     l_object_version_number number;

Line: 745


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

Line: 754


savepoint update_step;

Line: 755


      hr_sp_placement_api.update_spp
      (p_effective_date => p_effective_date,
      p_datetrack_mode   => p_datetrack_update_mode,
      p_placement_id => p_placement_id,
      p_object_version_number => l_object_version_number,
      p_step_id => p_step_id,
      p_reason=> p_reason,
      p_effective_start_date  => l_effective_start_date,
      p_effective_end_date    => l_effective_end_date,
      p_gsp_post_process_warning       => p_gsp_post_process_warning
      );

Line: 783


    rollback to update_step;

Line: 790


           rollback to update_step;

Line: 792


END update_step;

Line: 811


l_datetrack_update_mode varchar2(50);

Line: 850


l_datetrack_update_mode:=
    hr_transaction_api.get_varchar2_value
    (p_transaction_step_id => p_transaction_step_id
    ,p_name                => 'P_DATETRACK_UPDATE_MODE');

Line: 873


                null,--selection_mode        VARCHAR2(1),
                null,--ovn                   NUMBER,
                null,--currency              VARCHAR2(15),
                null,--pay_basis_name        VARCHAR2(80),
                null,--annual_equivalent     NUMBER ,
                null,--total_percent        NUMBER ,
                null,--quartile              NUMBER ,
                null,--comparatio            NUMBER ,
                null,--lv_selection_mode     VARCHAR2(1),
                null,--attribute_category           VARCHAR2(150),
                null,--attribute1            VARCHAR2(150),
                null,--attribute2            VARCHAR2(150),
                null,--attribute3            VARCHAR2(150),
                null,--attribute4            VARCHAR2(150),
                null,--attribute5            VARCHAR2(150),
                null,--attribute6            VARCHAR2(150),
                null,--attribute7            VARCHAR2(150),
                null,--attribute8            VARCHAR2(150),
                null,--attribute9            VARCHAR2(150),
                null,--attribute10           VARCHAR2(150),
                null,--attribute11           VARCHAR2(150),
                null,--attribute12           VARCHAR2(150),
                null,--attribute13           VARCHAR2(150),
                null,--attribute14           VARCHAR2(150),
                null,--attribute15           VARCHAR2(150),
                null,--attribute16           VARCHAR2(150),
                null,--attribute17           VARCHAR2(150),
                null,--attribute18           VARCHAR2(150),
                null,--attribute19           VARCHAR2(150),
                null,--attribute20           VARCHAR2(150),
                null, --no_of_components       NUMBER,
                null,  -- salary_basis_change_type varchar2(30)
                null,  -- default_date           date
                null,  -- default_bg_id          number
                null,  -- default_currency       VARCHAR2(15)
                null,  -- default_format_string  VARCHAR2(40)
                null,  -- default_salary_basis_name  varchar2(30)
                null,  -- default_pay_basis_name     varchar2(80)
                null,  -- default_pay_basis      varchar2(30)
                null,  -- default_pay_annual_factor  number
                null,  -- default_grade          VARCHAR2(240)
                null,  -- default_grade_annual_factor number
                null,  -- default_minimum_salary      number
                null,  -- default_maximum_salary      number
                null,  -- default_midpoint_salary     number
                null,  -- default_prev_salary         number
                null,  -- default_last_change_date    date
                null,  -- default_element_entry_id    number
                null,  -- default_basis_changed       number
                null,  -- default_uom                 VARCHAR2(30)
                null,  -- default_grade_uom           VARCHAR2(30)
                null,  -- default_change_amount       number
                null,  -- default_change_percent      number
                null,  -- default_quartile            number
                null,  -- default_comparatio          number
                null,  -- default_last_pay_change     varchar2(200)
                null,  -- default_flsa_status         varchar2(80)
                null,  -- default_currency_symbol     varchar2(4)
                null,   -- default_precision           number
                null,    -- salary_effective_date    date
                null,
                null,
                null,
                null,
                null,
                null
                ));

Line: 958


update_step
(p_validate => p_validate,
p_effective_date => l_effective_date,
p_datetrack_update_mode => l_datetrack_update_mode,
p_step_id   => l_step_id,
p_reason    => l_reason,
p_business_group_id => l_business_group_id,
p_assignment_id => l_assignment_id
,p_placement_id      => l_placement_id
,p_object_version_number     => l_object_version_number
,p_effective_start_date     => l_effective_start_date
,p_effective_end_date       => l_effective_end_date
,p_gsp_post_process_warning     => l_gsp_post_process_warning
,p_ltt_salary_data => ltt_salary_data
,p_page_error    => l_page_error
,p_page_error_msg    => l_page_error_msg);

Line: 998


select spinal_point from
per_spinal_points psp, per_spinal_point_steps_f psps where
psp.spinal_point_id=psps.spinal_point_id and psps.step_id=p_step_id;

Line: 1055


procedure delete_pay_step
(p_item_type                in     wf_items.item_type%TYPE
,p_item_key                 in     wf_items.item_key%TYPE
,p_login_person_id          in      varchar2)	is

 l_transaction_id number;

Line: 1089


            hr_transaction_ss.delete_transaction_step
                (p_transaction_step_id => ln_gsp_step_id
                 ,p_login_person_id => p_login_person_id);

Line: 1092


           delete from per_pay_transactions where TRANSACTION_STEP_ID=ln_gsp_step_id;

Line: 1095


end delete_pay_step;