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 3222: l_remark_id ghr_remarks.remark_id%type;

3218: l_hr_user_type varchar2(20);
3219:
3220: l_old_system_status per_assignment_status_types.per_system_status%type;
3221:
3222: l_remark_id ghr_remarks.remark_id%type;
3223: l_remark_description ghr_remarks.description%type;
3224: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
3225: l_rem_ovn ghr_pa_remarks.OBJECT_VERSION_NUMBER%type;
3226: l_form_field_name varchar2(50);

Line 3223: l_remark_description ghr_remarks.description%type;

3219:
3220: l_old_system_status per_assignment_status_types.per_system_status%type;
3221:
3222: l_remark_id ghr_remarks.remark_id%type;
3223: l_remark_description ghr_remarks.description%type;
3224: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
3225: l_rem_ovn ghr_pa_remarks.OBJECT_VERSION_NUMBER%type;
3226: l_form_field_name varchar2(50);
3227: l_posn_title_pm varchar2(50);

Line 3670: (select remark_id from ghr_remarks

3666: SELECT remark_id
3667: FROM ghr_pa_remarks
3668: WHERE pa_request_id = p_pa_request_rec.pa_request_id
3669: AND remark_id =
3670: (select remark_id from ghr_remarks
3671: where code = 'BBB');
3672:
3673: Cursor cur_get_remark_code(p_remark_id ghr_remarks.remark_id%TYPE) is
3674: select rem.code

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

3669: AND remark_id =
3670: (select remark_id from ghr_remarks
3671: where code = 'BBB');
3672:
3673: Cursor cur_get_remark_code(p_remark_id ghr_remarks.remark_id%TYPE) is
3674: select rem.code
3675: from ghr_remarks rem
3676: where rem.remark_id = p_remark_id
3677: and rem.enabled_flag = 'Y'

Line 3675: from ghr_remarks rem

3671: where code = 'BBB');
3672:
3673: Cursor cur_get_remark_code(p_remark_id ghr_remarks.remark_id%TYPE) is
3674: select rem.code
3675: from ghr_remarks rem
3676: where rem.remark_id = p_remark_id
3677: and rem.enabled_flag = 'Y'
3678: and nvl(p_pa_request_rec.effective_date,sysdate)
3679: between rem.date_from and nvl(rem.date_to,nvl(p_pa_request_rec.effective_date, trunc(sysdate)));

Line 3684: l_rpa_remark_code ghr_remarks.code%TYPE;

3680:
3681: l_mddds_special_pay_nte_date ghr_pa_request_extra_info.rei_information12%TYPE;
3682: l_mddds_total_special_pay ghr_pa_request_extra_info.rei_information11%TYPE;
3683: l_check_remarks BOOLEAN := FALSE;
3684: l_rpa_remark_code ghr_remarks.code%TYPE;
3685: l_rpa_remark_id ghr_remarks.remark_id%TYPE;
3686:
3687: --bug 4542437
3688: l_position_id ghr_pa_requests.from_position_id%TYPE :=NULL;

Line 3685: l_rpa_remark_id ghr_remarks.remark_id%TYPE;

3681: l_mddds_special_pay_nte_date ghr_pa_request_extra_info.rei_information12%TYPE;
3682: l_mddds_total_special_pay ghr_pa_request_extra_info.rei_information11%TYPE;
3683: l_check_remarks BOOLEAN := FALSE;
3684: l_rpa_remark_code ghr_remarks.code%TYPE;
3685: l_rpa_remark_id ghr_remarks.remark_id%TYPE;
3686:
3687: --bug 4542437
3688: l_position_id ghr_pa_requests.from_position_id%TYPE :=NULL;
3689: l_job_id per_all_assignments_f.job_id%TYPE :=NULL;

Line 6859: l_remark_id ghr_remarks.remark_id%TYPE;

6855: p_amount IN NUMBER,
6856: p_payment_date IN DATE,
6857: p_end_date IN DATE) IS
6858:
6859: l_remark_id ghr_remarks.remark_id%TYPE;
6860: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
6861: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;
6862: l_remark_desc ghr_remarks.description%TYPE;
6863: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;

Line 6862: l_remark_desc ghr_remarks.description%TYPE;

6858:
6859: l_remark_id ghr_remarks.remark_id%TYPE;
6860: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
6861: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;
6862: l_remark_desc ghr_remarks.description%TYPE;
6863: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;
6864: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
6865: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;
6866: l_remark_information4 ghr_pa_remarks.remark_code_information4%TYPE;

Line 6868: l_remark_desc_out ghr_remarks.description%TYPE;

6864: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
6865: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;
6866: l_remark_information4 ghr_pa_remarks.remark_code_information4%TYPE;
6867: l_remark_information5 ghr_pa_remarks.remark_code_information5%TYPE;
6868: l_remark_desc_out ghr_remarks.description%TYPE;
6869: l_end_date DATE;
6870:
6871:
6872: BEGIN