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_SF52_DO_UPDATE dependencies on GHR_REMARKS

Line 3018: l_remark_id ghr_remarks.remark_id%type;

3014: l_hr_user_type varchar2(20);
3015:
3016: l_old_system_status per_assignment_status_types.per_system_status%type;
3017:
3018: l_remark_id ghr_remarks.remark_id%type;
3019: l_remark_description ghr_remarks.description%type;
3020: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
3021: l_rem_ovn ghr_pa_remarks.OBJECT_VERSION_NUMBER%type;
3022: l_form_field_name varchar2(50);

Line 3019: l_remark_description ghr_remarks.description%type;

3015:
3016: l_old_system_status per_assignment_status_types.per_system_status%type;
3017:
3018: l_remark_id ghr_remarks.remark_id%type;
3019: l_remark_description ghr_remarks.description%type;
3020: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
3021: l_rem_ovn ghr_pa_remarks.OBJECT_VERSION_NUMBER%type;
3022: l_form_field_name varchar2(50);
3023: l_posn_title_pm varchar2(50);

Line 3450: (select remark_id from ghr_remarks

3446: SELECT remark_id
3447: FROM ghr_pa_remarks
3448: WHERE pa_request_id = p_pa_request_rec.pa_request_id
3449: AND remark_id =
3450: (select remark_id from ghr_remarks
3451: where code = 'BBB');
3452:
3453:
3454:

Line 3456: Cursor cur_get_remark_code(p_remark_id ghr_remarks.remark_id%TYPE) is

3452:
3453:
3454:
3455:
3456: Cursor cur_get_remark_code(p_remark_id ghr_remarks.remark_id%TYPE) is
3457: select rem.code
3458: from ghr_remarks rem
3459: where rem.remark_id = p_remark_id
3460: and rem.enabled_flag = 'Y'

Line 3458: from ghr_remarks rem

3454:
3455:
3456: Cursor cur_get_remark_code(p_remark_id ghr_remarks.remark_id%TYPE) is
3457: select rem.code
3458: from ghr_remarks rem
3459: where rem.remark_id = p_remark_id
3460: and rem.enabled_flag = 'Y'
3461: and nvl(p_pa_request_rec.effective_date,sysdate)
3462: between rem.date_from and nvl(rem.date_to,nvl(p_pa_request_rec.effective_date, trunc(sysdate)));

Line 3467: l_rpa_remark_code ghr_remarks.code%TYPE;

3463:
3464: l_mddds_special_pay_nte_date ghr_pa_request_extra_info.rei_information12%TYPE;
3465: l_mddds_total_special_pay ghr_pa_request_extra_info.rei_information11%TYPE;
3466: l_check_remarks BOOLEAN := FALSE;
3467: l_rpa_remark_code ghr_remarks.code%TYPE;
3468: l_rpa_remark_id ghr_remarks.remark_id%TYPE;
3469:
3470: --bug 4542437
3471: l_position_id ghr_pa_requests.from_position_id%TYPE :=NULL;

Line 3468: l_rpa_remark_id ghr_remarks.remark_id%TYPE;

3464: l_mddds_special_pay_nte_date ghr_pa_request_extra_info.rei_information12%TYPE;
3465: l_mddds_total_special_pay ghr_pa_request_extra_info.rei_information11%TYPE;
3466: l_check_remarks BOOLEAN := FALSE;
3467: l_rpa_remark_code ghr_remarks.code%TYPE;
3468: l_rpa_remark_id ghr_remarks.remark_id%TYPE;
3469:
3470: --bug 4542437
3471: l_position_id ghr_pa_requests.from_position_id%TYPE :=NULL;
3472: l_job_id per_all_assignments_f.job_id%TYPE :=NULL;

Line 6583: l_remark_id ghr_remarks.remark_id%TYPE;

6579: p_amount IN NUMBER,
6580: p_payment_date IN DATE,
6581: p_end_date IN DATE) IS
6582:
6583: l_remark_id ghr_remarks.remark_id%TYPE;
6584: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
6585: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;
6586: l_remark_desc ghr_remarks.description%TYPE;
6587: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;

Line 6586: l_remark_desc ghr_remarks.description%TYPE;

6582:
6583: l_remark_id ghr_remarks.remark_id%TYPE;
6584: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
6585: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;
6586: l_remark_desc ghr_remarks.description%TYPE;
6587: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;
6588: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
6589: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;
6590: l_remark_information4 ghr_pa_remarks.remark_code_information4%TYPE;

Line 6592: l_remark_desc_out ghr_remarks.description%TYPE;

6588: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
6589: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;
6590: l_remark_information4 ghr_pa_remarks.remark_code_information4%TYPE;
6591: l_remark_information5 ghr_pa_remarks.remark_code_information5%TYPE;
6592: l_remark_desc_out ghr_remarks.description%TYPE;
6593: l_end_date DATE;
6594:
6595:
6596: BEGIN