APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on HXC_APP_COMP_NOTIFICATIONS

Line 134: hxc_app_comp_notifications_api.c_action_transfer,

130: end if;
131: hxc_approval_wf_helper.set_notif_attribute_values
132: (p_itemtype,
133: p_itemkey,
134: hxc_app_comp_notifications_api.c_action_transfer,
135: hxc_app_comp_notifications_api.c_recipient_preparer
136: );
137:
138: --Bug 5361995.

Line 135: hxc_app_comp_notifications_api.c_recipient_preparer

131: hxc_approval_wf_helper.set_notif_attribute_values
132: (p_itemtype,
133: p_itemkey,
134: hxc_app_comp_notifications_api.c_action_transfer,
135: hxc_app_comp_notifications_api.c_recipient_preparer
136: );
137:
138: --Bug 5361995.
139: if p_result = 'COMPLETE:Y' and l_label = 'APPROVAL_NOTIFICATION:APPROVED_BY_APR_INACTION' then

Line 212: ,hxc_app_comp_notifications hacn

208: select hacn.notification_number_retries
209: from hxc_app_period_summary haps
210: ,hxc_approval_comps hac
211: ,hxc_app_comp_notif_usages hacnu
212: ,hxc_app_comp_notifications hacn
213: where haps.application_period_id = p_app_bb_id
214: and haps.approval_comp_id = hac.approval_comp_id
215: and hacnu.approval_comp_id = hac.approval_comp_id
216: and hacnu.approval_comp_ovn = hac.object_version_number

Line 241: ,hxc_app_comp_notifications hacn

237: IS
238: select hacn.notification_number_retries
239: from hxc_approval_comps hac
240: ,hxc_app_comp_notif_usages hacnu
241: ,hxc_app_comp_notifications hacn
242: where hac.approval_comp_id = p_app_comp_id
243: and hacnu.approval_comp_id = hac.approval_comp_id
244: and hacnu.approval_comp_ovn = hac.object_version_number
245: and hacnu.comp_notification_id = hacn.comp_notification_id

Line 352: avalue => hxc_app_comp_notifications_api.c_recipient_approver);

348: wf_engine.SetItemAttrText(
349: itemtype => p_itemtype,
350: itemkey => p_itemkey,
351: aname => hxc_approval_wf_helper.c_recipient_code_attribute,
352: avalue => hxc_app_comp_notifications_api.c_recipient_approver);
353:
354:
355: p_result := 'COMPLETE:Y';
356: else

Line 468: if l_current_recipient = hxc_app_comp_notifications_api.c_recipient_approver then

464:
465: l_admin_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_admin_role,l_tc_start_date);
466:
467:
468: if l_current_recipient = hxc_app_comp_notifications_api.c_recipient_approver then
469:
470: if g_debug then
471: hr_utility.set_location(l_proc, 20);
472: end if;

Line 523: avalue => hxc_app_comp_notifications_api.c_recipient_preparer);

519: wf_engine.SetItemAttrText(
520: itemtype => p_itemtype,
521: itemkey => p_itemkey,
522: aname => hxc_approval_wf_helper.c_recipient_code_attribute,
523: avalue => hxc_app_comp_notifications_api.c_recipient_preparer);
524:
525:
526: elsif l_current_recipient = hxc_app_comp_notifications_api.c_recipient_preparer then
527: --set the attibutes for the ADMIN

Line 526: elsif l_current_recipient = hxc_app_comp_notifications_api.c_recipient_preparer then

522: aname => hxc_approval_wf_helper.c_recipient_code_attribute,
523: avalue => hxc_app_comp_notifications_api.c_recipient_preparer);
524:
525:
526: elsif l_current_recipient = hxc_app_comp_notifications_api.c_recipient_preparer then
527: --set the attibutes for the ADMIN
528:
529: if g_debug then
530: hr_utility.set_location(l_proc, 30);

Line 588: avalue => hxc_app_comp_notifications_api.c_recipient_admin);

584: wf_engine.SetItemAttrText(
585: itemtype => p_itemtype,
586: itemkey => p_itemkey,
587: aname => hxc_approval_wf_helper.c_recipient_code_attribute,
588: avalue => hxc_app_comp_notifications_api.c_recipient_admin);
589:
590: elsif l_current_recipient = hxc_app_comp_notifications_api.c_recipient_admin then
591:
592: --In this case all the attributes were already set in the l_current_recipient = 'PREPARER' section.

Line 590: elsif l_current_recipient = hxc_app_comp_notifications_api.c_recipient_admin then

586: itemkey => p_itemkey,
587: aname => hxc_approval_wf_helper.c_recipient_code_attribute,
588: avalue => hxc_app_comp_notifications_api.c_recipient_admin);
589:
590: elsif l_current_recipient = hxc_app_comp_notifications_api.c_recipient_admin then
591:
592: --In this case all the attributes were already set in the l_current_recipient = 'PREPARER' section.
593:
594: if g_debug then