APPS.GHR_CORR_CANC_SF52 dependencies on PER_POSITION_EXTRA_INFO

Line 3208: l_pos_ei_grade_data per_position_extra_info%rowtype;

3204: from ghr_pa_history
3205: where pa_request_id = c_pa_request_id;
3206:
3207: -- Bug#5435374
3208: l_pos_ei_grade_data per_position_extra_info%rowtype;
3209:
3210: cursor c_grade_kff (grd_id number) is
3211: select gdf.segment1
3212: ,gdf.segment2

Line 3222: l_pos_ei_grp1_data per_position_extra_info%rowtype;

3218: --bug #6356058 start
3219: l_core_chg_avbl number;
3220: l_prev_request_id number;
3221: l_curr_pa_history_id number;
3222: l_pos_ei_grp1_data per_position_extra_info%rowtype;
3223: cursor core_chg_check(p_to_position_id in number,
3224: p_effective_date in date)
3225: is
3226: select 1

Line 3234: from per_position_extra_info

3230: from ghr_pa_history
3231: where pa_request_id = l_prev_request_id)
3232: and hist_1.pa_history_id < nvl(l_curr_pa_history_id,999999999)
3233: and information1 in (select position_extra_info_id
3234: from per_position_extra_info
3235: where position_id = p_to_position_id
3236: and information_type in ('GHR_US_POS_GRP1'))
3237: and effective_date = p_effective_date
3238: and table_name = 'PER_POSITION_EXTRA_INFO';

Line 3238: and table_name = 'PER_POSITION_EXTRA_INFO';

3234: from per_position_extra_info
3235: where position_id = p_to_position_id
3236: and information_type in ('GHR_US_POS_GRP1'))
3237: and effective_date = p_effective_date
3238: and table_name = 'PER_POSITION_EXTRA_INFO';
3239: --bug #6356058 start
3240:
3241:
3242:

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

4535: -- ---------------------------------------------------------------------------
4536: -- {Start Of Comments}
4537: --
4538: -- Description:
4539: -- This procedure deletes a row from per_position_extra_info table.
4540: --
4541: -- Pre-Requisities:
4542: -- None.
4543: --

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

4544: -- In Parameters:
4545: -- p_position_extra_info_id -> position_extra_info_id to be deleted.
4546: --
4547: -- Post Success:
4548: -- per_position_extra_info row will have been deleted.
4549: --
4550: -- Post Failure:
4551: -- message will have been displayed to user explaining why the delete could not be completed.
4552: --

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

4558: --
4559: -- {End Of Comments}
4560: -- ---------------------------------------------------------------------------
4561: PROCEDURE delete_posnei_row( p_position_extra_info_id in varchar2) IS
4562: l_proc varchar2(72) := 'delete_per_position_extra_info_row';
4563: l_ovn number;
4564: -- this cursor gets the object_version_number for the position_extra_info_id passed.
4565: cursor c_get_ovn (cp_position_extra_info_id in number) is
4566: SELECT object_version_number

Line 4567: FROM PER_POSITION_EXTRA_INFO

4563: l_ovn number;
4564: -- this cursor gets the object_version_number for the position_extra_info_id passed.
4565: cursor c_get_ovn (cp_position_extra_info_id in number) is
4566: SELECT object_version_number
4567: FROM PER_POSITION_EXTRA_INFO
4568: WHERE position_extra_info_id = cp_position_extra_info_id ;
4569: BEGIN
4570: hr_utility.set_location( 'Entering : ' || l_proc, 10);
4571: open c_get_ovn(p_position_extra_info_id);

Line 5040: l_pos_ei_grade_data per_position_extra_info%rowtype;

5036: select altered_pa_request_id from
5037: ghr_pa_requests where pa_request_id = p_pa_request_id);
5038:
5039: -- Bug#5435374
5040: l_pos_ei_grade_data per_position_extra_info%rowtype;
5041:
5042: cursor c_grade_kff (grd_id number) is
5043: select gdf.segment1
5044: ,gdf.segment2