DBA Data[Home] [Help]

APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on HXC_APPROVAL_WF_HELPER

Line 131: hxc_approval_wf_helper.set_notif_attribute_values

127:
128: if g_debug then
129: hr_utility.set_location(l_proc, 20);
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

Line 180: if(hxc_approval_wf_helper.item_attribute_value_exists(p_item_type,p_item_key,'NOTIFICATION_RESEND_COUNTER')) then

176: p_resend_number in number) is
177:
178: BEGIN
179:
180: if(hxc_approval_wf_helper.item_attribute_value_exists(p_item_type,p_item_key,'NOTIFICATION_RESEND_COUNTER')) then
181:
182: wf_engine.SetItemAttrNumber(itemtype => p_item_type,
183: itemkey => p_item_key,
184: aname => 'NOTIFICATION_RESEND_COUNTER',

Line 330: l_preparer_role := hxc_approval_wf_helper.find_role_for_recipient('PREPARER',p_tc_bbid,p_tc_bbovn);

326:
327: --Bug 5359397.
328: --TC_FROM_ROLE needs ro reset to preparer role since we are overwriting this attribute with approver role
329: --in reset_for_next_timeout.
330: l_preparer_role := hxc_approval_wf_helper.find_role_for_recipient('PREPARER',p_tc_bbid,p_tc_bbovn);
331: wf_engine.SetItemAttrText(itemtype => p_itemtype,
332: itemkey => p_itemkey,
333: aname => 'TC_FROM_ROLE',
334: avalue => l_preparer_role);

Line 351: aname => hxc_approval_wf_helper.c_recipient_code_attribute,

347: avalue => l_approver_timeout);
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';

Line 448: aname => hxc_approval_wf_helper.c_recipient_code_attribute,

444:
445: l_current_recipient := wf_engine.getItemAttrText(
446: itemtype => p_itemtype,
447: itemkey => p_itemkey,
448: aname => hxc_approval_wf_helper.c_recipient_code_attribute,
449: ignore_notfound => true);
450:
451: l_approval_style_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
452: itemkey => p_itemkey,

Line 455: l_worker_role :=hxc_approval_wf_helper.find_role_for_recipient('WORKER',l_timecard_id,l_timecard_ovn);

451: l_approval_style_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
452: itemkey => p_itemkey,
453: aname => 'APPROVAL_STYLE_ID');
454:
455: l_worker_role :=hxc_approval_wf_helper.find_role_for_recipient('WORKER',l_timecard_id,l_timecard_ovn);
456:
457: l_worker_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_worker_role,l_tc_start_date);
458:
459: l_preparer_role := hxc_approval_wf_helper.find_role_for_recipient('PREPARER',l_timecard_id,l_timecard_ovn);

Line 457: l_worker_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_worker_role,l_tc_start_date);

453: aname => 'APPROVAL_STYLE_ID');
454:
455: l_worker_role :=hxc_approval_wf_helper.find_role_for_recipient('WORKER',l_timecard_id,l_timecard_ovn);
456:
457: l_worker_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_worker_role,l_tc_start_date);
458:
459: l_preparer_role := hxc_approval_wf_helper.find_role_for_recipient('PREPARER',l_timecard_id,l_timecard_ovn);
460:
461: l_preparer_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_preparer_role,l_tc_start_date);

Line 459: l_preparer_role := hxc_approval_wf_helper.find_role_for_recipient('PREPARER',l_timecard_id,l_timecard_ovn);

455: l_worker_role :=hxc_approval_wf_helper.find_role_for_recipient('WORKER',l_timecard_id,l_timecard_ovn);
456:
457: l_worker_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_worker_role,l_tc_start_date);
458:
459: l_preparer_role := hxc_approval_wf_helper.find_role_for_recipient('PREPARER',l_timecard_id,l_timecard_ovn);
460:
461: l_preparer_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_preparer_role,l_tc_start_date);
462:
463: l_admin_role :=hxc_approval_wf_helper.find_role_for_recipient('ADMIN',l_timecard_id,l_timecard_ovn);

Line 461: l_preparer_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_preparer_role,l_tc_start_date);

457: l_worker_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_worker_role,l_tc_start_date);
458:
459: l_preparer_role := hxc_approval_wf_helper.find_role_for_recipient('PREPARER',l_timecard_id,l_timecard_ovn);
460:
461: l_preparer_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_preparer_role,l_tc_start_date);
462:
463: l_admin_role :=hxc_approval_wf_helper.find_role_for_recipient('ADMIN',l_timecard_id,l_timecard_ovn);
464:
465: l_admin_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_admin_role,l_tc_start_date);

Line 463: l_admin_role :=hxc_approval_wf_helper.find_role_for_recipient('ADMIN',l_timecard_id,l_timecard_ovn);

459: l_preparer_role := hxc_approval_wf_helper.find_role_for_recipient('PREPARER',l_timecard_id,l_timecard_ovn);
460:
461: l_preparer_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_preparer_role,l_tc_start_date);
462:
463: l_admin_role :=hxc_approval_wf_helper.find_role_for_recipient('ADMIN',l_timecard_id,l_timecard_ovn);
464:
465: l_admin_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_admin_role,l_tc_start_date);
466:
467:

Line 465: l_admin_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_admin_role,l_tc_start_date);

461: l_preparer_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_preparer_role,l_tc_start_date);
462:
463: l_admin_role :=hxc_approval_wf_helper.find_role_for_recipient('ADMIN',l_timecard_id,l_timecard_ovn);
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:

Line 500: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));

496: fnd_message.set_name('HXC','HXC_APPR_TO_PREPARER');
497: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
498: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
499: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
500: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));
501:
502: l_fyi_subject :=fnd_message.get();
503:
504: wf_engine.SetItemAttrText(

Line 522: aname => hxc_approval_wf_helper.c_recipient_code_attribute,

518:
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

Line 561: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));

557: fnd_message.set_name('HXC','HXC_APPR_TO_ADMIN');
558: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
559: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
560: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
561: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));
562:
563: l_fyi_subject :=fnd_message.get();
564:
565:

Line 587: aname => hxc_approval_wf_helper.c_recipient_code_attribute,

583:
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: