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

3164:
3165: is
3166:
3167: l_proc varchar2(72) := g_package || 'create_remarks';
3168: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
3169: l_remark_id ghr_pa_remarks.remark_id%type;
3170: l_description ghr_pa_remarks.description%type;
3171: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
3172: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;

Line 3169: l_remark_id ghr_pa_remarks.remark_id%type;

3165: is
3166:
3167: l_proc varchar2(72) := g_package || 'create_remarks';
3168: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
3169: l_remark_id ghr_pa_remarks.remark_id%type;
3170: l_description ghr_pa_remarks.description%type;
3171: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
3172: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
3173: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;

Line 3170: l_description ghr_pa_remarks.description%type;

3166:
3167: l_proc varchar2(72) := g_package || 'create_remarks';
3168: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
3169: l_remark_id ghr_pa_remarks.remark_id%type;
3170: l_description ghr_pa_remarks.description%type;
3171: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
3172: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
3173: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
3174: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;

Line 3171: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;

3167: l_proc varchar2(72) := g_package || 'create_remarks';
3168: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
3169: l_remark_id ghr_pa_remarks.remark_id%type;
3170: l_description ghr_pa_remarks.description%type;
3171: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
3172: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
3173: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
3174: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
3175: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;

Line 3172: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;

3168: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
3169: l_remark_id ghr_pa_remarks.remark_id%type;
3170: l_description ghr_pa_remarks.description%type;
3171: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
3172: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
3173: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
3174: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
3175: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
3176: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;

Line 3173: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;

3169: l_remark_id ghr_pa_remarks.remark_id%type;
3170: l_description ghr_pa_remarks.description%type;
3171: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
3172: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
3173: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
3174: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
3175: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
3176: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;
3177: l_p_object_version_number ghr_pa_remarks.object_version_number%type;

Line 3174: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;

3170: l_description ghr_pa_remarks.description%type;
3171: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
3172: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
3173: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
3174: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
3175: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
3176: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;
3177: l_p_object_version_number ghr_pa_remarks.object_version_number%type;
3178:

Line 3175: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;

3171: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
3172: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
3173: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
3174: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
3175: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
3176: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;
3177: l_p_object_version_number ghr_pa_remarks.object_version_number%type;
3178:
3179: cursor cur_rem_tmp is

Line 3176: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;

3172: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
3173: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
3174: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
3175: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
3176: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;
3177: l_p_object_version_number ghr_pa_remarks.object_version_number%type;
3178:
3179: cursor cur_rem_tmp is
3180: select pa_remark_id,

Line 3177: l_p_object_version_number ghr_pa_remarks.object_version_number%type;

3173: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
3174: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
3175: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
3176: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;
3177: l_p_object_version_number ghr_pa_remarks.object_version_number%type;
3178:
3179: cursor cur_rem_tmp is
3180: select pa_remark_id,
3181: remark_id,

Line 3188: from ghr_pa_remarks

3184: remark_code_information2,
3185: remark_code_information3,
3186: remark_code_information4,
3187: remark_code_information5
3188: from ghr_pa_remarks
3189: where pa_request_id =
3190: (select pa_request_id from ghr_pa_requests
3191: where mass_action_id = p_mass_award_id
3192: and rpa_type = p_rpa_type

Line 3199: from ghr_pa_remarks

3195:
3196: cursor cur_rem is
3197: select pa_remark_id,
3198: object_version_number
3199: from ghr_pa_remarks
3200: where pa_request_id = p_pa_request_id
3201: and remark_id = l_remark_id
3202: and description = l_description
3203: order by pa_remark_id;

Line 3229: ghr_pa_remarks_api.create_pa_remarks

3225: l_p_object_version_number := cur_rem_rec.object_version_number;
3226: end loop;
3227:
3228: if l_p_pa_remark_id is null then
3229: ghr_pa_remarks_api.create_pa_remarks
3230: (
3231: p_pa_request_id => p_pa_request_id
3232: ,p_remark_id => l_remark_id
3233: ,p_description => l_description

Line 3243: ghr_pa_remarks_api.update_pa_remarks

3239: ,p_pa_remark_id => l_p_pa_remark_id
3240: ,p_object_version_number => l_p_object_version_number
3241: );
3242: else
3243: ghr_pa_remarks_api.update_pa_remarks
3244: (p_pa_remark_id => l_p_pa_remark_id
3245: ,p_object_version_number => l_p_object_version_number
3246: ,p_remark_code_information1 => l_remark_code_information1
3247: ,p_remark_code_information2 => l_remark_code_information2