DBA Data[Home] [Help]

APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on HXC_APPROVAL_WF_HELPER

Line 80: hxc_approval_wf_helper.set_notif_attribute_values

76:
77: if g_debug then
78: hr_utility.set_location(l_proc, 20);
79: end if;
80: hxc_approval_wf_helper.set_notif_attribute_values
81: (p_itemtype,
82: p_itemkey,
83: hxc_app_comp_notifications_api.c_action_transfer,
84: hxc_app_comp_notifications_api.c_recipient_preparer

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

125: p_resend_number in number) is
126:
127: BEGIN
128:
129: if(hxc_approval_wf_helper.item_attribute_value_exists(p_item_type,p_item_key,'NOTIFICATION_RESEND_COUNTER')) then
130:
131: wf_engine.SetItemAttrNumber(itemtype => p_item_type,
132: itemkey => p_item_key,
133: aname => 'NOTIFICATION_RESEND_COUNTER',

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

275:
276: --Bug 5359397.
277: --TC_FROM_ROLE needs ro reset to preparer role since we are overwriting this attribute with approver role
278: --in reset_for_next_timeout.
279: l_preparer_role := hxc_approval_wf_helper.find_role_for_recipient('PREPARER',p_tc_bbid,p_tc_bbovn);
280: wf_engine.SetItemAttrText(itemtype => p_itemtype,
281: itemkey => p_itemkey,
282: aname => 'TC_FROM_ROLE',
283: avalue => l_preparer_role);

Line 300: aname => hxc_approval_wf_helper.c_recipient_code_attribute,

296: avalue => l_approver_timeout);
297: wf_engine.SetItemAttrText(
298: itemtype => p_itemtype,
299: itemkey => p_itemkey,
300: aname => hxc_approval_wf_helper.c_recipient_code_attribute,
301: avalue => hxc_app_comp_notifications_api.c_recipient_approver);
302:
303:
304: p_result := 'COMPLETE:Y';

Line 397: aname => hxc_approval_wf_helper.c_recipient_code_attribute,

393:
394: l_current_recipient := wf_engine.getItemAttrText(
395: itemtype => p_itemtype,
396: itemkey => p_itemkey,
397: aname => hxc_approval_wf_helper.c_recipient_code_attribute,
398: ignore_notfound => true);
399:
400: l_approval_style_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
401: itemkey => p_itemkey,

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

400: l_approval_style_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
401: itemkey => p_itemkey,
402: aname => 'APPROVAL_STYLE_ID');
403:
404: l_worker_role :=hxc_approval_wf_helper.find_role_for_recipient('WORKER',l_timecard_id,l_timecard_ovn);
405:
406: l_worker_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_worker_role,l_tc_start_date);
407:
408: l_preparer_role := hxc_approval_wf_helper.find_role_for_recipient('PREPARER',l_timecard_id,l_timecard_ovn);

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

402: aname => 'APPROVAL_STYLE_ID');
403:
404: l_worker_role :=hxc_approval_wf_helper.find_role_for_recipient('WORKER',l_timecard_id,l_timecard_ovn);
405:
406: l_worker_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_worker_role,l_tc_start_date);
407:
408: l_preparer_role := hxc_approval_wf_helper.find_role_for_recipient('PREPARER',l_timecard_id,l_timecard_ovn);
409:
410: l_preparer_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_preparer_role,l_tc_start_date);

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

404: l_worker_role :=hxc_approval_wf_helper.find_role_for_recipient('WORKER',l_timecard_id,l_timecard_ovn);
405:
406: l_worker_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_worker_role,l_tc_start_date);
407:
408: l_preparer_role := hxc_approval_wf_helper.find_role_for_recipient('PREPARER',l_timecard_id,l_timecard_ovn);
409:
410: l_preparer_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_preparer_role,l_tc_start_date);
411:
412: l_admin_role :=hxc_approval_wf_helper.find_role_for_recipient('ADMIN',l_timecard_id,l_timecard_ovn);

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

406: l_worker_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_worker_role,l_tc_start_date);
407:
408: l_preparer_role := hxc_approval_wf_helper.find_role_for_recipient('PREPARER',l_timecard_id,l_timecard_ovn);
409:
410: l_preparer_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_preparer_role,l_tc_start_date);
411:
412: l_admin_role :=hxc_approval_wf_helper.find_role_for_recipient('ADMIN',l_timecard_id,l_timecard_ovn);
413:
414: l_admin_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_admin_role,l_tc_start_date);

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

408: l_preparer_role := hxc_approval_wf_helper.find_role_for_recipient('PREPARER',l_timecard_id,l_timecard_ovn);
409:
410: l_preparer_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_preparer_role,l_tc_start_date);
411:
412: l_admin_role :=hxc_approval_wf_helper.find_role_for_recipient('ADMIN',l_timecard_id,l_timecard_ovn);
413:
414: l_admin_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_admin_role,l_tc_start_date);
415:
416:

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

410: l_preparer_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_preparer_role,l_tc_start_date);
411:
412: l_admin_role :=hxc_approval_wf_helper.find_role_for_recipient('ADMIN',l_timecard_id,l_timecard_ovn);
413:
414: l_admin_full_name := hxc_approval_wf_helper.find_full_name_from_role(l_admin_role,l_tc_start_date);
415:
416:
417: if l_current_recipient = hxc_app_comp_notifications_api.c_recipient_approver then
418:

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

445: fnd_message.set_name('HXC','HXC_APPR_TO_PREPARER');
446: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
447: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
448: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
449: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));
450:
451: l_fyi_subject :=fnd_message.get();
452:
453: wf_engine.SetItemAttrText(

Line 471: aname => hxc_approval_wf_helper.c_recipient_code_attribute,

467:
468: wf_engine.SetItemAttrText(
469: itemtype => p_itemtype,
470: itemkey => p_itemkey,
471: aname => hxc_approval_wf_helper.c_recipient_code_attribute,
472: avalue => hxc_app_comp_notifications_api.c_recipient_preparer);
473:
474:
475: elsif l_current_recipient = hxc_app_comp_notifications_api.c_recipient_preparer then

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

506: fnd_message.set_name('HXC','HXC_APPR_TO_ADMIN');
507: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
508: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
509: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
510: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));
511:
512: l_fyi_subject :=fnd_message.get();
513:
514:

Line 536: aname => hxc_approval_wf_helper.c_recipient_code_attribute,

532:
533: wf_engine.SetItemAttrText(
534: itemtype => p_itemtype,
535: itemkey => p_itemkey,
536: aname => hxc_approval_wf_helper.c_recipient_code_attribute,
537: avalue => hxc_app_comp_notifications_api.c_recipient_admin);
538:
539: elsif l_current_recipient = hxc_app_comp_notifications_api.c_recipient_admin then
540: