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_PA_REMARKS

Line 3020: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;

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);
3024: l_WS_pm varchar2(50);

Line 3021: l_rem_ovn ghr_pa_remarks.OBJECT_VERSION_NUMBER%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);
3024: l_WS_pm varchar2(50);
3025: l_DS_pm varchar2(50);

Line 3447: FROM ghr_pa_remarks

3443: AND pa_request_id = p_pa_request_rec.pa_request_id;
3444:
3445: CURSOR check_remarks is
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');

Line 3536: ghr_pa_remarks_api.create_pa_remarks

3532: p_remark_desc => l_remark_description
3533: );
3534:
3535:
3536: ghr_pa_remarks_api.create_pa_remarks
3537: (
3538: p_PA_REQUEST_ID => p_pa_request_rec.pa_request_id,
3539: p_REMARK_ID => l_remark_id,
3540: p_DESCRIPTION => l_remark_description,

Line 3583: ghr_pa_remarks_api.create_pa_remarks

3579: --while terminating the MDDDS_SPECIAL_PAY element it should delete the remarks also.
3580: IF ( l_mddds_total_special_pay <> 0 )
3581: and ( l_mddds_total_special_pay IS NOT NULL ) THEN
3582:
3583: ghr_pa_remarks_api.create_pa_remarks
3584: (
3585: p_PA_REQUEST_ID => p_pa_request_rec.pa_request_id,
3586: p_REMARK_ID => l_remark_id,
3587: p_DESCRIPTION => l_remark_description,

Line 6584: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;

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;
6588: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;

Line 6585: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;

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;
6588: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
6589: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;

Line 6587: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;

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;
6591: l_remark_information5 ghr_pa_remarks.remark_code_information5%TYPE;

Line 6588: l_remark_information2 ghr_pa_remarks.remark_code_information2%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;
6591: l_remark_information5 ghr_pa_remarks.remark_code_information5%TYPE;
6592: l_remark_desc_out ghr_remarks.description%TYPE;

Line 6589: l_remark_information3 ghr_pa_remarks.remark_code_information3%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;
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;

Line 6590: l_remark_information4 ghr_pa_remarks.remark_code_information4%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;
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:

Line 6591: l_remark_information5 ghr_pa_remarks.remark_code_information5%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;
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:

Line 6663: ghr_pa_remarks_api.create_pa_remarks

6659: p_desc_out => l_remark_desc_out
6660: );
6661: l_remark_desc := l_remark_desc_out;
6662:
6663: ghr_pa_remarks_api.create_pa_remarks
6664: (p_pa_request_id => p_pa_request_id,
6665: p_remark_id => l_remark_id,
6666: p_description => l_remark_desc,
6667: p_remark_code_information1 => l_remark_information1,