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 3224: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;

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

Line 3225: l_rem_ovn ghr_pa_remarks.OBJECT_VERSION_NUMBER%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);
3228: l_WS_pm varchar2(50);
3229: l_DS_pm varchar2(50);

Line 3667: FROM ghr_pa_remarks

3663: AND pa_request_id = p_pa_request_rec.pa_request_id;
3664:
3665: CURSOR check_remarks is
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');

Line 3756: ghr_pa_remarks_api.create_pa_remarks

3752: p_remark_desc => l_remark_description
3753: );
3754:
3755:
3756: ghr_pa_remarks_api.create_pa_remarks
3757: (
3758: p_PA_REQUEST_ID => p_pa_request_rec.pa_request_id,
3759: p_REMARK_ID => l_remark_id,
3760: p_DESCRIPTION => l_remark_description,

Line 3803: ghr_pa_remarks_api.create_pa_remarks

3799: --while terminating the MDDDS_SPECIAL_PAY element it should delete the remarks also.
3800: IF ( l_mddds_total_special_pay <> 0 )
3801: and ( l_mddds_total_special_pay IS NOT NULL ) THEN
3802:
3803: ghr_pa_remarks_api.create_pa_remarks
3804: (
3805: p_PA_REQUEST_ID => p_pa_request_rec.pa_request_id,
3806: p_REMARK_ID => l_remark_id,
3807: p_DESCRIPTION => l_remark_description,

Line 6860: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;

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

Line 6861: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;

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

Line 6863: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;

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

Line 6864: l_remark_information2 ghr_pa_remarks.remark_code_information2%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;
6867: l_remark_information5 ghr_pa_remarks.remark_code_information5%TYPE;
6868: l_remark_desc_out ghr_remarks.description%TYPE;

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

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

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

Line 6939: ghr_pa_remarks_api.create_pa_remarks

6935: p_desc_out => l_remark_desc_out
6936: );
6937: l_remark_desc := l_remark_desc_out;
6938:
6939: ghr_pa_remarks_api.create_pa_remarks
6940: (p_pa_request_id => p_pa_request_id,
6941: p_remark_id => l_remark_id,
6942: p_description => l_remark_desc,
6943: p_remark_code_information1 => l_remark_information1,