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_NOTIFICATION_PROCESS_PKG dependencies on WF_ENGINE

Line 39: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

35: if g_debug then
36: hr_utility.set_location(l_proc, 10);
37: end if;
38:
39: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
40: itemkey => p_itemkey,
41: aname => 'APP_BB_ID');
42: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
43: itemkey => p_itemkey,

Line 42: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

38:
39: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
40: itemkey => p_itemkey,
41: aname => 'APP_BB_ID');
42: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
43: itemkey => p_itemkey,
44: aname => 'APP_BB_OVN');
45: open c_get_app_mechanism(l_app_bb_id,l_app_bb_ovn);
46: fetch c_get_app_mechanism into l_app_mechanism;

Line 51: l_label := wf_engine.GetActivityLabel ( actid => p_actid);

47:
48: --Bug 5361995.
49: --We should not show the button 'Send to next approver' in the preparer notification when the current
50: --approver is the final approver
51: l_label := wf_engine.GetActivityLabel ( actid => p_actid);
52:
53: if l_label = 'APPROVAL_NOTIFICATION:APPROVED_BY_APR_INACTION' then
54:
55: HXC_FIND_NOTIFY_APRS_PKG.is_final_apr(

Line 62: l_approval_style_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

58: p_actid ,
59: p_funcmode ,
60: p_result );
61:
62: l_approval_style_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
63: itemkey => p_itemkey,
64: aname => 'APPROVAL_STYLE_ID');
65:
66: l_preparer_timeout := hxc_notification_helper.preparer_timeout_value(l_approval_style_id);

Line 68: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

64: aname => 'APPROVAL_STYLE_ID');
65:
66: l_preparer_timeout := hxc_notification_helper.preparer_timeout_value(l_approval_style_id);
67:
68: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
69: itemkey => p_itemkey,
70: aname => 'APPROVAL_TIMEOUT',
71: avalue => l_preparer_timeout);
72:

Line 131: wf_engine.SetItemAttrNumber(itemtype => p_item_type,

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',
134: avalue => p_resend_number);
135:

Line 138: wf_engine.AddItemAttr(itemtype => p_item_type,

134: avalue => p_resend_number);
135:
136: else
137:
138: wf_engine.AddItemAttr(itemtype => p_item_type,
139: itemkey => p_item_key,
140: aname => 'NOTIFICATION_RESEND_COUNTER',
141: number_value => p_resend_number);
142:

Line 226: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

222:
223:
224: --find application period id item attribute value
225:
226: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
227: itemkey => p_itemkey,
228: aname => 'APP_BB_ID');
229:
230: -- We need to set the total hours and Description in this procedure because we are over writing these values in

Line 232: wf_engine.SetItemAttrText

228: aname => 'APP_BB_ID');
229:
230: -- We need to set the total hours and Description in this procedure because we are over writing these values in
231: -- prepare notification process while sending superviosr notification.
232: wf_engine.SetItemAttrText
233: (itemtype => p_itemtype,
234: itemkey => p_itemkey,
235: aname => 'DESCRIPTION',
236: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));

Line 239: wf_engine.SetItemAttrNumber(

235: aname => 'DESCRIPTION',
236: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));
237:
238: l_total_hours:= HXC_FIND_NOTIFY_APRS_PKG.category_timecard_hrs(l_app_bb_id,'');
239: wf_engine.SetItemAttrNumber(
240: itemtype => p_itemtype,
241: itemkey => p_itemkey,
242: aname => 'TOTAL_TC_HOURS',
243: avalue => l_total_hours);

Line 245: p_tc_bbid:= wf_engine.GetItemAttrNumber

241: itemkey => p_itemkey,
242: aname => 'TOTAL_TC_HOURS',
243: avalue => l_total_hours);
244:
245: p_tc_bbid:= wf_engine.GetItemAttrNumber
246: (itemtype => p_itemtype,
247: itemkey => p_itemkey,
248: aname => 'TC_BLD_BLK_ID');
249: p_tc_bbovn:= wf_engine.GetItemAttrNumber

Line 249: p_tc_bbovn:= wf_engine.GetItemAttrNumber

245: p_tc_bbid:= wf_engine.GetItemAttrNumber
246: (itemtype => p_itemtype,
247: itemkey => p_itemkey,
248: aname => 'TC_BLD_BLK_ID');
249: p_tc_bbovn:= wf_engine.GetItemAttrNumber
250: (itemtype => p_itemtype,
251: itemkey => p_itemkey,
252: aname => 'TC_BLD_BLK_OVN');
253:

Line 280: wf_engine.SetItemAttrText(itemtype => p_itemtype,

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);
284:

Line 287: l_approval_style_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

283: avalue => l_preparer_role);
284:
285: loop_initialization(p_itemtype ,p_itemkey ,l_resend_number-1);
286:
287: l_approval_style_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
288: itemkey => p_itemkey,
289: aname => 'APPROVAL_STYLE_ID');
290:
291: l_approver_timeout := hxc_notification_helper.approver_timeout_value(l_approval_style_id);

Line 293: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

289: aname => 'APPROVAL_STYLE_ID');
290:
291: l_approver_timeout := hxc_notification_helper.approver_timeout_value(l_approval_style_id);
292:
293: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
294: itemkey => p_itemkey,
295: aname => 'APPROVAL_TIMEOUT',
296: avalue => l_approver_timeout);
297: wf_engine.SetItemAttrText(

Line 297: wf_engine.SetItemAttrText(

293: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
294: itemkey => p_itemkey,
295: aname => 'APPROVAL_TIMEOUT',
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);

Line 366: l_timecard_id := wf_engine.GetItemAttrNumber

362: if g_debug then
363: hr_utility.set_location(l_proc, 10);
364: end if;
365:
366: l_timecard_id := wf_engine.GetItemAttrNumber
367: (itemtype => p_itemtype,
368: itemkey => p_itemkey,
369: aname => 'TC_BLD_BLK_ID');
370: l_timecard_ovn := wf_engine.GetItemAttrNumber

Line 370: l_timecard_ovn := wf_engine.GetItemAttrNumber

366: l_timecard_id := wf_engine.GetItemAttrNumber
367: (itemtype => p_itemtype,
368: itemkey => p_itemkey,
369: aname => 'TC_BLD_BLK_ID');
370: l_timecard_ovn := wf_engine.GetItemAttrNumber
371: (itemtype => p_itemtype,
372: itemkey => p_itemkey,
373: aname => 'TC_BLD_BLK_OVN');
374: l_tc_stop_date := wf_engine.GetItemAttrDate(

Line 374: l_tc_stop_date := wf_engine.GetItemAttrDate(

370: l_timecard_ovn := wf_engine.GetItemAttrNumber
371: (itemtype => p_itemtype,
372: itemkey => p_itemkey,
373: aname => 'TC_BLD_BLK_OVN');
374: l_tc_stop_date := wf_engine.GetItemAttrDate(
375: itemtype => p_itemtype,
376: itemkey => p_itemkey,
377: aname => 'TC_STOP');
378:

Line 379: l_tc_start_date := wf_engine.GetItemAttrDate(

375: itemtype => p_itemtype,
376: itemkey => p_itemkey,
377: aname => 'TC_STOP');
378:
379: l_tc_start_date := wf_engine.GetItemAttrDate(
380: itemtype => p_itemtype,
381: itemkey => p_itemkey,
382: aname => 'TC_START');
383:

Line 384: l_effective_end_date := wf_engine.GetItemAttrDate(

380: itemtype => p_itemtype,
381: itemkey => p_itemkey,
382: aname => 'TC_START');
383:
384: l_effective_end_date := wf_engine.GetItemAttrDate(
385: itemtype => p_itemtype,
386: itemkey => p_itemkey,
387: aname => 'APP_END_DATE');
388:

Line 389: l_effective_start_date := wf_engine.GetItemAttrDate(

385: itemtype => p_itemtype,
386: itemkey => p_itemkey,
387: aname => 'APP_END_DATE');
388:
389: l_effective_start_date := wf_engine.GetItemAttrDate(
390: itemtype => p_itemtype,
391: itemkey => p_itemkey,
392: aname => 'APP_START_DATE');
393:

Line 394: l_current_recipient := wf_engine.getItemAttrText(

390: itemtype => p_itemtype,
391: itemkey => p_itemkey,
392: aname => 'APP_START_DATE');
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);

Line 400: l_approval_style_id:= wf_engine.GetItemAttrNumber(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,
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);

Line 427: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

423: --set the attibutes for the PREPARER
424:
425: l_preparer_timeout := hxc_notification_helper.preparer_timeout_value(l_approval_style_id);
426:
427: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
428: itemkey => p_itemkey,
429: aname => 'APPROVAL_TIMEOUT',
430: avalue => l_preparer_timeout);
431: --loop variable seeting is not required as it is already set in the timeout_enabled

Line 434: l_tc_from_role :=wf_engine.GetItemAttrText(

430: avalue => l_preparer_timeout);
431: --loop variable seeting is not required as it is already set in the timeout_enabled
432:
433:
434: l_tc_from_role :=wf_engine.GetItemAttrText(
435:
436: itemtype => p_itemtype,
437: itemkey => p_itemkey,
438: aname => 'TC_APPROVER_FROM_ROLE');

Line 439: wf_engine.SetItemAttrText(itemtype => p_itemtype,

435:
436: itemtype => p_itemtype,
437: itemkey => p_itemkey,
438: aname => 'TC_APPROVER_FROM_ROLE');
439: wf_engine.SetItemAttrText(itemtype => p_itemtype,
440: itemkey => p_itemkey,
441: aname => 'TC_FROM_ROLE',
442: avalue => l_tc_from_role);
443:

Line 453: wf_engine.SetItemAttrText(

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(
454: itemtype => p_itemtype,
455: itemkey => p_itemkey,
456: aname => 'FYI_SUBJECT',
457: avalue => l_fyi_subject);

Line 459: wf_engine.SetItemAttrText(

455: itemkey => p_itemkey,
456: aname => 'FYI_SUBJECT',
457: avalue => l_fyi_subject);
458:
459: wf_engine.SetItemAttrText(
460: itemtype => p_itemtype,
461: itemkey => p_itemkey,
462: aname => 'PREPARER_ROLE',
463: avalue => l_preparer_role );

Line 468: wf_engine.SetItemAttrText(

464:
465:
466:
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);

Line 483: l_resend_counter := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

479: hr_utility.set_location(l_proc, 30);
480: end if;
481:
482: l_admin_timeout := hxc_notification_helper.admin_timeout_value(l_approval_style_id);
483: l_resend_counter := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
484: itemkey => p_itemkey,
485: aname => 'NOTIFICATION_RESEND_COUNTER');
486: if l_resend_counter = 0 then
487: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 487: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

483: l_resend_counter := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
484: itemkey => p_itemkey,
485: aname => 'NOTIFICATION_RESEND_COUNTER');
486: if l_resend_counter = 0 then
487: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
488: itemkey => p_itemkey,
489: aname => 'APPROVAL_TIMEOUT',
490: avalue => 0);
491:

Line 493: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

489: aname => 'APPROVAL_TIMEOUT',
490: avalue => 0);
491:
492: else
493: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
494: itemkey => p_itemkey,
495: aname => 'APPROVAL_TIMEOUT',
496: avalue => l_admin_timeout);
497:

Line 502: l_apr_name := wf_engine.GetItemAttrText(itemtype => p_itemtype,

498: loop_initialization(p_itemtype ,p_itemkey ,l_resend_counter-1);
499: end if;
500:
501: --loop variable seeting is not required as it is already set in the timeout_enabled
502: l_apr_name := wf_engine.GetItemAttrText(itemtype => p_itemtype,
503: itemkey => p_itemkey,
504: aname => 'TC_APPROVER_FROM_ROLE');
505:
506: fnd_message.set_name('HXC','HXC_APPR_TO_ADMIN');

Line 516: wf_engine.SetItemAttrText(

512: l_fyi_subject :=fnd_message.get();
513:
514:
515:
516: wf_engine.SetItemAttrText(
517: itemtype => p_itemtype,
518: itemkey => p_itemkey,
519: aname => 'FYI_SUBJECT',
520: avalue => l_fyi_subject);

Line 522: wf_engine.SetItemAttrText(itemtype => p_itemtype,

518: itemkey => p_itemkey,
519: aname => 'FYI_SUBJECT',
520: avalue => l_fyi_subject);
521:
522: wf_engine.SetItemAttrText(itemtype => p_itemtype,
523: itemkey => p_itemkey,
524: aname => 'TC_FROM_ROLE',
525: avalue => l_preparer_role);
526:

Line 527: wf_engine.SetItemAttrText(

523: itemkey => p_itemkey,
524: aname => 'TC_FROM_ROLE',
525: avalue => l_preparer_role);
526:
527: wf_engine.SetItemAttrText(
528: itemtype => p_itemtype,
529: itemkey => p_itemkey,
530: aname => 'ADMIN_ROLE',
531: avalue => l_admin_role );

Line 533: wf_engine.SetItemAttrText(

529: itemkey => p_itemkey,
530: aname => 'ADMIN_ROLE',
531: avalue => l_admin_role );
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);

Line 547: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

543: if g_debug then
544: hr_utility.set_location(l_proc, 40);
545: end if;
546:
547: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
548: itemkey => p_itemkey,
549: aname => 'APPROVAL_TIMEOUT',
550: avalue => 0);
551:

Line 682: l_timecard_id := wf_engine.GetItemAttrNumber

678:
679: close c_is_error_process;
680:
681:
682: l_timecard_id := wf_engine.GetItemAttrNumber
683: (itemtype => p_itemtype,
684: itemkey => itemkey,
685: aname => 'TC_BLD_BLK_ID');
686: l_timecard_ovn := wf_engine.GetItemAttrNumber

Line 686: l_timecard_ovn := wf_engine.GetItemAttrNumber

682: l_timecard_id := wf_engine.GetItemAttrNumber
683: (itemtype => p_itemtype,
684: itemkey => itemkey,
685: aname => 'TC_BLD_BLK_ID');
686: l_timecard_ovn := wf_engine.GetItemAttrNumber
687: (itemtype => p_itemtype,
688: itemkey => itemkey,
689: aname => 'TC_BLD_BLK_OVN');
690: l_tc_resubmitted := wf_engine.GetItemAttrText

Line 690: l_tc_resubmitted := wf_engine.GetItemAttrText

686: l_timecard_ovn := wf_engine.GetItemAttrNumber
687: (itemtype => p_itemtype,
688: itemkey => itemkey,
689: aname => 'TC_BLD_BLK_OVN');
690: l_tc_resubmitted := wf_engine.GetItemAttrText
691: (itemtype => p_itemtype,
692: itemkey => itemkey,
693: aname => 'TC_RESUBMITTED');
694: l_bb_new := wf_engine.GetItemAttrText

Line 694: l_bb_new := wf_engine.GetItemAttrText

690: l_tc_resubmitted := wf_engine.GetItemAttrText
691: (itemtype => p_itemtype,
692: itemkey => itemkey,
693: aname => 'TC_RESUBMITTED');
694: l_bb_new := wf_engine.GetItemAttrText
695: (itemtype => p_itemtype,
696: itemkey => itemkey,
697: aname => 'BB_NEW');
698:

Line 699: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

695: (itemtype => p_itemtype,
696: itemkey => itemkey,
697: aname => 'BB_NEW');
698:
699: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
700: itemkey => itemkey,
701: aname => 'APP_BB_ID');
702:
703: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

Line 703: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

699: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
700: itemkey => itemkey,
701: aname => 'APP_BB_ID');
702:
703: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
704: itemkey => itemkey,
705: aname => 'APP_BB_OVN');
706: open c_csr_get_tc_info(l_timecard_id,
707: l_timecard_ovn);

Line 740: wf_engine.CreateProcess(itemtype => p_itemtype,

736: if g_debug then
737: hr_utility.trace('l_item_key is : ' || l_item_key);
738: end if;
739:
740: wf_engine.CreateProcess(itemtype => p_itemtype,
741: itemkey => l_item_key,
742: process => l_process_name);
743: wf_engine.setitemowner(p_itemtype,
744: p_item_key,

Line 743: wf_engine.setitemowner(p_itemtype,

739:
740: wf_engine.CreateProcess(itemtype => p_itemtype,
741: itemkey => l_item_key,
742: process => l_process_name);
743: wf_engine.setitemowner(p_itemtype,
744: p_item_key,
745: HXC_FIND_NOTIFY_APRS_PKG.get_login(p_person_id=>l_tc_resource_id,
746: p_user_id => l_last_updated_by)
747: );

Line 763: wf_engine.SetItemAttrDate(itemtype => p_itemtype,

759: if g_debug then
760: hr_utility.set_location(l_proc, 20);
761: end if;
762:
763: wf_engine.SetItemAttrDate(itemtype => p_itemtype,
764: itemkey => l_item_key,
765: aname => 'APP_START_DATE',
766: avalue => l_period_start_date);
767:

Line 768: wf_engine.SetItemAttrText(itemtype => p_itemtype,

764: itemkey => l_item_key,
765: aname => 'APP_START_DATE',
766: avalue => l_period_start_date);
767:
768: wf_engine.SetItemAttrText(itemtype => p_itemtype,
769: itemkey => l_item_key,
770: aname => 'FORMATTED_APP_START_DATE',
771: avalue => to_char(l_period_start_date,'YYYY/MM/DD'));
772: if g_debug then

Line 778: wf_engine.SetItemAttrDate(itemtype => p_itemtype,

774: hr_utility.trace('APP_START_DATE is : ' ||
775: to_char(l_period_start_date, 'DD-MM-YYYY'));
776: end if;
777:
778: wf_engine.SetItemAttrDate(itemtype => p_itemtype,
779: itemkey => l_item_key,
780: aname => 'APP_END_DATE',
781: avalue => l_period_end_date);
782:

Line 789: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

785: hr_utility.trace('APP_END_DATE is : ' ||
786: to_char(l_period_end_date, 'DD-MM-YYYY'));
787: end if;
788:
789: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
790: itemkey => l_item_key,
791: aname => 'APP_BB_ID',
792: avalue => l_app_bb_id);
793:

Line 799: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

795: hr_utility.set_location(l_proc, 50);
796: hr_utility.trace('APP_BB_ID is : ' || to_char(l_app_bb_id));
797: end if;
798:
799: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
800: itemkey => l_item_key,
801: aname => 'APP_BB_OVN',
802: avalue => l_app_bb_ovn);
803:

Line 811: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

807: hr_utility.trace('APP_BB_OVN is : ' ||
808: to_char(l_app_bb_ovn));
809: end if;
810:
811: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
812: itemkey => l_item_key,
813: aname => 'RESOURCE_ID',
814: avalue => l_tc_resource_id);
815:

Line 821: wf_engine.SetItemAttrText(itemtype => p_itemtype,

817: hr_utility.set_location(l_proc, 70);
818: hr_utility.trace('RESOURCE_ID is : ' || to_char(l_tc_resource_id));
819: end if;
820:
821: wf_engine.SetItemAttrText(itemtype => p_itemtype,
822: itemkey => l_item_key,
823: aname => 'TIME_RECIPIENT_ID',
824: avalue => l_time_recipient);
825:

Line 831: wf_engine.SetItemAttrText(itemtype => p_itemtype,

827: hr_utility.set_location(l_proc, 80);
828: hr_utility.trace('TIME_RECIPIENT_ID is : ' || l_time_recipient);
829: end if;
830:
831: wf_engine.SetItemAttrText(itemtype => p_itemtype,
832: itemkey => l_item_key,
833: aname => 'TC_RESUBMITTED',
834: avalue => l_tc_resubmitted);
835:

Line 841: wf_engine.SetItemAttrText(itemtype => p_itemtype,

837: hr_utility.set_location(l_proc, 90);
838: hr_utility.trace('TC_RESUBMITTED is : ' || l_tc_resubmitted);
839: end if;
840:
841: wf_engine.SetItemAttrText(itemtype => p_itemtype,
842: itemkey => l_item_key,
843: aname => 'BB_NEW',
844: avalue => l_bb_new);
845:

Line 851: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

847: hr_utility.set_location(l_proc, 100);
848: hr_utility.trace('BB_NEW is : ' || l_bb_new);
849: end if;
850:
851: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
852: itemkey => l_item_key,
853: aname => 'TC_BLD_BLK_ID',
854: avalue => l_timecard_id);
855:

Line 861: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

857: hr_utility.set_location(l_proc, 110);
858: hr_utility.trace('TC_BLD_BLK_ID is : ' || to_char(l_timecard_id));
859: end if;
860:
861: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
862: itemkey => l_item_key,
863: aname => 'TC_BLD_BLK_OVN',
864: avalue => l_timecard_ovn);
865:

Line 874: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

870: l_approval_style_id := hxc_approval_wf_pkg.get_approval_style_id(l_tc_start_time,
871: l_tc_stop_time,
872: l_tc_resource_id);
873:
874: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
875: itemkey => l_item_key,
876: aname => 'APPROVAL_STYLE_ID',
877: avalue => l_approval_style_id);
878:

Line 888: wf_engine.SetItemAttrText(itemtype => p_itemtype,

884: '\&AprvResourceId=' || to_char(l_tc_resource_id) ||
885: '\&OAFunc=HXC_TIME_ENTER'||
886: '\&NtfId=-&#NID-';
887:
888: wf_engine.SetItemAttrText(itemtype => p_itemtype,
889: itemkey => l_item_key,
890: aname => 'HXC_TIMECARD_URL',
891: avalue => l_tc_url);
892:

Line 912: wf_engine.StartProcess(itemtype => p_itemtype,itemkey => l_item_key);

908: where application_period_id = l_app_bb_id
909: and application_period_ovn = l_app_bb_ovn;
910:
911:
912: wf_engine.StartProcess(itemtype => p_itemtype,itemkey => l_item_key);
913:
914: p_result := 'COMPLETE';
915:
916: exception

Line 959: l_approver := wf_engine.GetItemAttrText(itemtype => p_itemtype,

955: fetch c_get_notification into l_original_recipient; --This will fetch the notification id that is in action currently
956: close c_get_notification;
957:
958: --Get the present owner of the notification
959: l_approver := wf_engine.GetItemAttrText(itemtype => p_itemtype,
960: itemkey => p_itemkey,
961: aname => 'APR_SS_LOGIN' );
962: --Compare the present owner with the original_recipient, if these not same, then it is a transfer action
963: --Delegate case:

Line 973: wf_engine.SetItemAttrText(itemtype => p_itemtype,

969:
970: if l_approver <> l_original_recipient then
971: --This condition ensures that we are resetting the attribute only in the case of transfer
972: --If it is a transfer action set the item attribute APR_SS_LOGIN with the new owner i.e. original_recipient.
973: wf_engine.SetItemAttrText(itemtype => p_itemtype,
974: itemkey => p_itemkey,
975: aname => 'APR_SS_LOGIN',
976: avalue => l_original_recipient);
977: wf_engine.SetItemAttrText(itemtype => p_itemtype,

Line 977: wf_engine.SetItemAttrText(itemtype => p_itemtype,

973: wf_engine.SetItemAttrText(itemtype => p_itemtype,
974: itemkey => p_itemkey,
975: aname => 'APR_SS_LOGIN',
976: avalue => l_original_recipient);
977: wf_engine.SetItemAttrText(itemtype => p_itemtype,
978: itemkey => p_itemkey,
979: aname => 'TC_APPROVER_FROM_ROLE',
980: avalue => l_original_recipient);
981: wf_engine.SetItemAttrText(itemtype => p_itemtype,

Line 981: wf_engine.SetItemAttrText(itemtype => p_itemtype,

977: wf_engine.SetItemAttrText(itemtype => p_itemtype,
978: itemkey => p_itemkey,
979: aname => 'TC_APPROVER_FROM_ROLE',
980: avalue => l_original_recipient);
981: wf_engine.SetItemAttrText(itemtype => p_itemtype,
982: itemkey => p_itemkey,
983: aname => 'TC_FROM_ROLE',
984: avalue => l_approver);
985: end if;