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_CORR_CANC_SF52 dependencies on PER_POSITION_EXTRA_INFO

Line 3514: l_pos_ei_grade_data per_position_extra_info%rowtype;

3510: from ghr_pa_history
3511: where pa_request_id = c_pa_request_id;
3512:
3513: -- Bug#5435374
3514: l_pos_ei_grade_data per_position_extra_info%rowtype;
3515:
3516: cursor c_grade_kff (grd_id number) is
3517: select gdf.segment1
3518: ,gdf.segment2

Line 3528: l_pos_ei_grp1_data per_position_extra_info%rowtype;

3524: --bug #6356058 start
3525: l_core_chg_avbl number;
3526: l_prev_request_id number;
3527: l_curr_pa_history_id number;
3528: l_pos_ei_grp1_data per_position_extra_info%rowtype;
3529: -- 8737300 Modified the cursor for improving performance
3530: cursor core_chg_check(p_to_position_id in number,
3531: p_effective_date in date)
3532: is

Line 3541: from per_position_extra_info

3537: from ghr_pa_history
3538: where pa_request_id = l_prev_request_id)
3539: and hist_1.pa_history_id < nvl(l_curr_pa_history_id,999999999)
3540: and information1 in (select to_char(position_extra_info_id)
3541: from per_position_extra_info
3542: where position_id = p_to_position_id
3543: and information_type in ('GHR_US_POS_GRP1'))
3544: and information5 = 'GHR_US_POS_GRP1'
3545: and effective_date = p_effective_date

Line 3546: and table_name = 'PER_POSITION_EXTRA_INFO';

3542: where position_id = p_to_position_id
3543: and information_type in ('GHR_US_POS_GRP1'))
3544: and information5 = 'GHR_US_POS_GRP1'
3545: and effective_date = p_effective_date
3546: and table_name = 'PER_POSITION_EXTRA_INFO';
3547: --bug #6356058 start
3548:
3549:
3550:

Line 4881: -- This procedure deletes a row from per_position_extra_info table.

4877: -- ---------------------------------------------------------------------------
4878: -- {Start Of Comments}
4879: --
4880: -- Description:
4881: -- This procedure deletes a row from per_position_extra_info table.
4882: --
4883: -- Pre-Requisities:
4884: -- None.
4885: --

Line 4890: -- per_position_extra_info row will have been deleted.

4886: -- In Parameters:
4887: -- p_position_extra_info_id -> position_extra_info_id to be deleted.
4888: --
4889: -- Post Success:
4890: -- per_position_extra_info row will have been deleted.
4891: --
4892: -- Post Failure:
4893: -- message will have been displayed to user explaining why the delete could not be completed.
4894: --

Line 4904: l_proc varchar2(72) := 'delete_per_position_extra_info_row';

4900: --
4901: -- {End Of Comments}
4902: -- ---------------------------------------------------------------------------
4903: PROCEDURE delete_posnei_row( p_position_extra_info_id in varchar2) IS
4904: l_proc varchar2(72) := 'delete_per_position_extra_info_row';
4905: l_ovn number;
4906: -- this cursor gets the object_version_number for the position_extra_info_id passed.
4907: cursor c_get_ovn (cp_position_extra_info_id in number) is
4908: SELECT object_version_number

Line 4909: FROM PER_POSITION_EXTRA_INFO

4905: l_ovn number;
4906: -- this cursor gets the object_version_number for the position_extra_info_id passed.
4907: cursor c_get_ovn (cp_position_extra_info_id in number) is
4908: SELECT object_version_number
4909: FROM PER_POSITION_EXTRA_INFO
4910: WHERE position_extra_info_id = cp_position_extra_info_id ;
4911: BEGIN
4912: hr_utility.set_location( 'Entering : ' || l_proc, 10);
4913: open c_get_ovn(p_position_extra_info_id);

Line 5382: l_pos_ei_grade_data per_position_extra_info%rowtype;

5378: select altered_pa_request_id from
5379: ghr_pa_requests where pa_request_id = p_pa_request_id);
5380:
5381: -- Bug#5435374
5382: l_pos_ei_grade_data per_position_extra_info%rowtype;
5383:
5384: cursor c_grade_kff (grd_id number) is
5385: select gdf.segment1
5386: ,gdf.segment2

Line 7284: l_pos_ei_grade_data per_position_extra_info%rowtype;

7280: from ghr_pa_history
7281: where pa_request_id = c_pa_request_id;
7282:
7283: -- Bug#5435374
7284: l_pos_ei_grade_data per_position_extra_info%rowtype;
7285:
7286: cursor c_grade_kff (grd_id number)
7287: is
7288: select gdf.segment1

Line 7299: l_pos_ei_grp1_data per_position_extra_info%rowtype;

7295: --bug #6356058 start
7296: l_core_chg_avbl number;
7297: l_prev_request_id number;
7298: l_curr_pa_history_id number;
7299: l_pos_ei_grp1_data per_position_extra_info%rowtype;
7300:
7301: -- 8737300 Modified the cursor for improving performance
7302: cursor core_chg_check(p_to_position_id in number,
7303: p_effective_date in date)

Line 7313: from per_position_extra_info

7309: from ghr_pa_history
7310: where pa_request_id = l_prev_request_id)
7311: and hist_1.pa_history_id < nvl(l_curr_pa_history_id,999999999)
7312: and information1 in (select to_char(position_extra_info_id)
7313: from per_position_extra_info
7314: where position_id = p_to_position_id
7315: and information_type in ('GHR_US_POS_GRP1'))
7316: and information5 = 'GHR_US_POS_GRP1'
7317: and effective_date = p_effective_date

Line 7318: and table_name = 'PER_POSITION_EXTRA_INFO';

7314: where position_id = p_to_position_id
7315: and information_type in ('GHR_US_POS_GRP1'))
7316: and information5 = 'GHR_US_POS_GRP1'
7317: and effective_date = p_effective_date
7318: and table_name = 'PER_POSITION_EXTRA_INFO';
7319: --bug #6356058 start
7320:
7321: --BUG 6976052
7322: cursor get_position_det(p_position_id in number,