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_MASS_AWARDS_PKG dependencies on GHR_PA_REMARKS

Line 1644: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;

1640: l_multiple_error_flag boolean;
1641: l_result boolean;
1642:
1643: l_scd_leave varchar2(30);
1644: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
1645: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
1646: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
1647: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
1648: l_mass_action_select_flag ghr_pa_requests.mass_action_select_flag%TYPE;

Line 3185: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;

3181:
3182: is
3183:
3184: l_proc varchar2(72) := g_package || 'create_remarks';
3185: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
3186: l_remark_id ghr_pa_remarks.remark_id%type;
3187: l_description ghr_pa_remarks.description%type;
3188: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
3189: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;

Line 3186: l_remark_id ghr_pa_remarks.remark_id%type;

3182: is
3183:
3184: l_proc varchar2(72) := g_package || 'create_remarks';
3185: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
3186: l_remark_id ghr_pa_remarks.remark_id%type;
3187: l_description ghr_pa_remarks.description%type;
3188: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
3189: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
3190: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;

Line 3187: l_description ghr_pa_remarks.description%type;

3183:
3184: l_proc varchar2(72) := g_package || 'create_remarks';
3185: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
3186: l_remark_id ghr_pa_remarks.remark_id%type;
3187: l_description ghr_pa_remarks.description%type;
3188: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
3189: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
3190: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
3191: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;

Line 3188: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;

3184: l_proc varchar2(72) := g_package || 'create_remarks';
3185: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
3186: l_remark_id ghr_pa_remarks.remark_id%type;
3187: l_description ghr_pa_remarks.description%type;
3188: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
3189: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
3190: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
3191: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
3192: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;

Line 3189: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;

3185: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
3186: l_remark_id ghr_pa_remarks.remark_id%type;
3187: l_description ghr_pa_remarks.description%type;
3188: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
3189: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
3190: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
3191: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
3192: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
3193: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;

Line 3190: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;

3186: l_remark_id ghr_pa_remarks.remark_id%type;
3187: l_description ghr_pa_remarks.description%type;
3188: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
3189: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
3190: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
3191: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
3192: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
3193: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;
3194: l_p_object_version_number ghr_pa_remarks.object_version_number%type;

Line 3191: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;

3187: l_description ghr_pa_remarks.description%type;
3188: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
3189: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
3190: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
3191: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
3192: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
3193: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;
3194: l_p_object_version_number ghr_pa_remarks.object_version_number%type;
3195:

Line 3192: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;

3188: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
3189: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
3190: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
3191: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
3192: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
3193: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;
3194: l_p_object_version_number ghr_pa_remarks.object_version_number%type;
3195:
3196: cursor cur_rem_tmp is

Line 3193: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;

3189: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
3190: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
3191: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
3192: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
3193: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;
3194: l_p_object_version_number ghr_pa_remarks.object_version_number%type;
3195:
3196: cursor cur_rem_tmp is
3197: select pa_remark_id,

Line 3194: l_p_object_version_number ghr_pa_remarks.object_version_number%type;

3190: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
3191: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
3192: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
3193: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;
3194: l_p_object_version_number ghr_pa_remarks.object_version_number%type;
3195:
3196: cursor cur_rem_tmp is
3197: select pa_remark_id,
3198: remark_id,

Line 3205: from ghr_pa_remarks

3201: remark_code_information2,
3202: remark_code_information3,
3203: remark_code_information4,
3204: remark_code_information5
3205: from ghr_pa_remarks
3206: where pa_request_id =
3207: (select pa_request_id from ghr_pa_requests
3208: where mass_action_id = p_mass_award_id
3209: and rpa_type = p_rpa_type

Line 3216: from ghr_pa_remarks

3212:
3213: cursor cur_rem is
3214: select pa_remark_id,
3215: object_version_number
3216: from ghr_pa_remarks
3217: where pa_request_id = p_pa_request_id
3218: and remark_id = l_remark_id
3219: and description = l_description
3220: order by pa_remark_id;

Line 3246: ghr_pa_remarks_api.create_pa_remarks

3242: l_p_object_version_number := cur_rem_rec.object_version_number;
3243: end loop;
3244:
3245: if l_p_pa_remark_id is null then
3246: ghr_pa_remarks_api.create_pa_remarks
3247: (
3248: p_pa_request_id => p_pa_request_id
3249: ,p_remark_id => l_remark_id
3250: ,p_description => l_description

Line 3260: ghr_pa_remarks_api.update_pa_remarks

3256: ,p_pa_remark_id => l_p_pa_remark_id
3257: ,p_object_version_number => l_p_object_version_number
3258: );
3259: else
3260: ghr_pa_remarks_api.update_pa_remarks
3261: (p_pa_remark_id => l_p_pa_remark_id
3262: ,p_object_version_number => l_p_object_version_number
3263: ,p_remark_code_information1 => l_remark_code_information1
3264: ,p_remark_code_information2 => l_remark_code_information2