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.HXC_HAN_BUS dependencies on HXC_APP_COMP_NOTIFICATIONS

Line 32: -- hxc_app_comp_notifications and PER_BUSINESS_GROUPS_PERF

28: --
29: -- Declare cursor
30: --
31: -- EDIT_HERE In the following cursor statement add join(s) between
32: -- hxc_app_comp_notifications and PER_BUSINESS_GROUPS_PERF
33: -- so that the security_group_id for
34: -- the current business group context can be derived.
35: -- Remove this comment when the edit has been completed.
36: cursor csr_sec_grp is

Line 40: , hxc_app_comp_notifications han

36: cursor csr_sec_grp is
37: select pbg.security_group_id,
38: pbg.legislation_code
39: from per_business_groups_perf pbg
40: , hxc_app_comp_notifications han
41: -- , EDIT_HERE table_name(s) 333
42: where han.comp_notification_id = p_comp_notification_id
43: and han.object_version_number = p_object_version_number;
44: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 122: -- hxc_app_comp_notifications and PER_BUSINESS_GROUPS_PERF

118: --
119: -- Declare cursor
120: --
121: -- EDIT_HERE In the following cursor statement add join(s) between
122: -- hxc_app_comp_notifications and PER_BUSINESS_GROUPS_PERF
123: -- so that the legislation_code for
124: -- the current business group context can be derived.
125: -- Remove this comment when the edit has been completed.
126: cursor csr_leg_code is

Line 129: , hxc_app_comp_notifications han

125: -- Remove this comment when the edit has been completed.
126: cursor csr_leg_code is
127: select pbg.legislation_code
128: from per_business_groups_perf pbg
129: , hxc_app_comp_notifications han
130: -- , EDIT_HERE table_name(s) 333
131: where han.comp_notification_id = p_comp_notification_id
132: and han.object_version_number = p_object_version_number;
133: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 286: hxc_app_comp_notifications_api.c_action_request_appr_resend

282: IS
283: BEGIN
284:
285: IF (p_notification_action_code <>
286: hxc_app_comp_notifications_api.c_action_request_appr_resend
287: )
288: THEN
289: IF (p_notification_number_retries <> 0)
290: THEN

Line 336: hxc_app_comp_notifications_api.C_ACTION_APPROVED

332: ) is
333: begin
334: if p_notification_action_code not in
335: (
336: hxc_app_comp_notifications_api.C_ACTION_APPROVED
337: ,hxc_app_comp_notifications_api.C_ACTION_AUTO_APPROVE
338: ,hxc_app_comp_notifications_api.C_ACTION_ERROR
339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED
340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL

Line 337: ,hxc_app_comp_notifications_api.C_ACTION_AUTO_APPROVE

333: begin
334: if p_notification_action_code not in
335: (
336: hxc_app_comp_notifications_api.C_ACTION_APPROVED
337: ,hxc_app_comp_notifications_api.C_ACTION_AUTO_APPROVE
338: ,hxc_app_comp_notifications_api.C_ACTION_ERROR
339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED
340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL
341: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPR_RESEND

Line 338: ,hxc_app_comp_notifications_api.C_ACTION_ERROR

334: if p_notification_action_code not in
335: (
336: hxc_app_comp_notifications_api.C_ACTION_APPROVED
337: ,hxc_app_comp_notifications_api.C_ACTION_AUTO_APPROVE
338: ,hxc_app_comp_notifications_api.C_ACTION_ERROR
339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED
340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL
341: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPR_RESEND
342: ,hxc_app_comp_notifications_api.C_ACTION_SUBMISSION

Line 339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED

335: (
336: hxc_app_comp_notifications_api.C_ACTION_APPROVED
337: ,hxc_app_comp_notifications_api.C_ACTION_AUTO_APPROVE
338: ,hxc_app_comp_notifications_api.C_ACTION_ERROR
339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED
340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL
341: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPR_RESEND
342: ,hxc_app_comp_notifications_api.C_ACTION_SUBMISSION
343: ,hxc_app_comp_notifications_api.C_ACTION_TRANSFER

Line 340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL

336: hxc_app_comp_notifications_api.C_ACTION_APPROVED
337: ,hxc_app_comp_notifications_api.C_ACTION_AUTO_APPROVE
338: ,hxc_app_comp_notifications_api.C_ACTION_ERROR
339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED
340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL
341: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPR_RESEND
342: ,hxc_app_comp_notifications_api.C_ACTION_SUBMISSION
343: ,hxc_app_comp_notifications_api.C_ACTION_TRANSFER
344: )

Line 341: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPR_RESEND

337: ,hxc_app_comp_notifications_api.C_ACTION_AUTO_APPROVE
338: ,hxc_app_comp_notifications_api.C_ACTION_ERROR
339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED
340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL
341: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPR_RESEND
342: ,hxc_app_comp_notifications_api.C_ACTION_SUBMISSION
343: ,hxc_app_comp_notifications_api.C_ACTION_TRANSFER
344: )
345: then

Line 342: ,hxc_app_comp_notifications_api.C_ACTION_SUBMISSION

338: ,hxc_app_comp_notifications_api.C_ACTION_ERROR
339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED
340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL
341: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPR_RESEND
342: ,hxc_app_comp_notifications_api.C_ACTION_SUBMISSION
343: ,hxc_app_comp_notifications_api.C_ACTION_TRANSFER
344: )
345: then
346: hr_utility.set_message(809,'HXC_ACTION_CODE');

Line 343: ,hxc_app_comp_notifications_api.C_ACTION_TRANSFER

339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED
340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL
341: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPR_RESEND
342: ,hxc_app_comp_notifications_api.C_ACTION_SUBMISSION
343: ,hxc_app_comp_notifications_api.C_ACTION_TRANSFER
344: )
345: then
346: hr_utility.set_message(809,'HXC_ACTION_CODE');
347: hr_utility.raise_error;

Line 362: hxc_app_comp_notifications_api.C_RECIPIENT_ADMIN

358: ) is
359: begin
360: if p_notification_recipient_code not in
361: (
362: hxc_app_comp_notifications_api.C_RECIPIENT_ADMIN
363: ,hxc_app_comp_notifications_api.C_RECIPIENT_APPROVER
364: ,hxc_app_comp_notifications_api.C_RECIPIENT_ERROR_ADMIN
365: ,hxc_app_comp_notifications_api.C_RECIPIENT_PREPARER
366: ,hxc_app_comp_notifications_api.C_RECIPIENT_SUPERVISOR

Line 363: ,hxc_app_comp_notifications_api.C_RECIPIENT_APPROVER

359: begin
360: if p_notification_recipient_code not in
361: (
362: hxc_app_comp_notifications_api.C_RECIPIENT_ADMIN
363: ,hxc_app_comp_notifications_api.C_RECIPIENT_APPROVER
364: ,hxc_app_comp_notifications_api.C_RECIPIENT_ERROR_ADMIN
365: ,hxc_app_comp_notifications_api.C_RECIPIENT_PREPARER
366: ,hxc_app_comp_notifications_api.C_RECIPIENT_SUPERVISOR
367: ,hxc_app_comp_notifications_api.C_RECIPIENT_WORKER

Line 364: ,hxc_app_comp_notifications_api.C_RECIPIENT_ERROR_ADMIN

360: if p_notification_recipient_code not in
361: (
362: hxc_app_comp_notifications_api.C_RECIPIENT_ADMIN
363: ,hxc_app_comp_notifications_api.C_RECIPIENT_APPROVER
364: ,hxc_app_comp_notifications_api.C_RECIPIENT_ERROR_ADMIN
365: ,hxc_app_comp_notifications_api.C_RECIPIENT_PREPARER
366: ,hxc_app_comp_notifications_api.C_RECIPIENT_SUPERVISOR
367: ,hxc_app_comp_notifications_api.C_RECIPIENT_WORKER
368: )

Line 365: ,hxc_app_comp_notifications_api.C_RECIPIENT_PREPARER

361: (
362: hxc_app_comp_notifications_api.C_RECIPIENT_ADMIN
363: ,hxc_app_comp_notifications_api.C_RECIPIENT_APPROVER
364: ,hxc_app_comp_notifications_api.C_RECIPIENT_ERROR_ADMIN
365: ,hxc_app_comp_notifications_api.C_RECIPIENT_PREPARER
366: ,hxc_app_comp_notifications_api.C_RECIPIENT_SUPERVISOR
367: ,hxc_app_comp_notifications_api.C_RECIPIENT_WORKER
368: )
369: then

Line 366: ,hxc_app_comp_notifications_api.C_RECIPIENT_SUPERVISOR

362: hxc_app_comp_notifications_api.C_RECIPIENT_ADMIN
363: ,hxc_app_comp_notifications_api.C_RECIPIENT_APPROVER
364: ,hxc_app_comp_notifications_api.C_RECIPIENT_ERROR_ADMIN
365: ,hxc_app_comp_notifications_api.C_RECIPIENT_PREPARER
366: ,hxc_app_comp_notifications_api.C_RECIPIENT_SUPERVISOR
367: ,hxc_app_comp_notifications_api.C_RECIPIENT_WORKER
368: )
369: then
370: hr_utility.set_message(809,'HXC_RECIPIENT_CODE');

Line 367: ,hxc_app_comp_notifications_api.C_RECIPIENT_WORKER

363: ,hxc_app_comp_notifications_api.C_RECIPIENT_APPROVER
364: ,hxc_app_comp_notifications_api.C_RECIPIENT_ERROR_ADMIN
365: ,hxc_app_comp_notifications_api.C_RECIPIENT_PREPARER
366: ,hxc_app_comp_notifications_api.C_RECIPIENT_SUPERVISOR
367: ,hxc_app_comp_notifications_api.C_RECIPIENT_WORKER
368: )
369: then
370: hr_utility.set_message(809,'HXC_RECIPIENT_CODE');
371: hr_utility.raise_error;