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

Line 134: l_timeouts := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

130: begin
131:
132: IF p_funcmode = 'TIMEOUT' then
133:
134: l_timeouts := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
135: itemkey => p_itemkey,
136: aname => 'TIMEOUT_COUNT');
137:
138: if l_timeouts > 0 then

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

136: aname => 'TIMEOUT_COUNT');
137:
138: if l_timeouts > 0 then
139:
140: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
141: itemkey => p_itemkey,
142: aname => 'DEFAULT_TIMEOUT',
143: avalue => 0);
144:

Line 146: l_approver_type := wf_engine.GetItemAttrText(

142: aname => 'DEFAULT_TIMEOUT',
143: avalue => 0);
144:
145:
146: l_approver_type := wf_engine.GetItemAttrText(
147: itemtype => p_itemtype,
148: itemkey => p_itemkey,
149: aname => 'APR_NOTIFY_TO');
150:

Line 151: l_tbb_id := wf_engine.GetItemAttrNumber(

147: itemtype => p_itemtype,
148: itemkey => p_itemkey,
149: aname => 'APR_NOTIFY_TO');
150:
151: l_tbb_id := wf_engine.GetItemAttrNumber(
152: itemtype => p_itemtype,
153: itemkey => p_itemkey,
154: aname => 'TC_BLD_BLK_ID');
155:

Line 156: l_tbb_ovn := wf_engine.GetItemAttrNumber(

152: itemtype => p_itemtype,
153: itemkey => p_itemkey,
154: aname => 'TC_BLD_BLK_ID');
155:
156: l_tbb_ovn := wf_engine.GetItemAttrNumber(
157: itemtype => p_itemtype,
158: itemkey => p_itemkey,
159: aname => 'TC_BLD_BLK_OVN');
160:

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

193: end if;
194:
195: l_timeouts :=l_timeouts +1;
196:
197: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
198: itemkey => p_itemkey,
199: aname => 'TIMEOUT_COUNT',
200: avalue => l_timeouts );
201:

Line 303: wf_engine.abortprocess

299: -- in Notified state
300: -- This will start calcelling the notifications when the bug 3468491 get's fixed
301: -- We need not call cancel notifications after this bug is fixed.
302:
303: wf_engine.abortprocess
304: (itemkey => audit_keys.item_key
305: ,itemtype => audit_keys.item_typE);
306:
307: EXCEPTION

Line 343: wf_engine.SetItemAttrText

339:
340: l_total_hours number;
341:
342: BEGIN
343: wf_engine.SetItemAttrText
344: (itemtype => p_itemtype,
345: itemkey => p_itemkey,
346: aname => 'DESCRIPTION',
347: avalue => hxc_find_notify_aprs_pkg.get_description_tc(p_tc_bb_id,p_tc_bb_ovn)

Line 355: wf_engine.SetItemAttrNumber(

351: p_tbb_id => p_tc_bb_id
352: , p_tbb_ovn => p_tc_bb_ovn
353: , P_TIME_CATEGORY_NAME => '' );
354:
355: wf_engine.SetItemAttrNumber(
356: itemtype => p_itemtype,
357: itemkey => p_itemkey,
358: aname => 'TOTAL_TC_HOURS',
359: avalue => round(l_total_hours,3));

Line 451: wf_engine.CreateProcess(itemtype => p_tc_item_type,

447:
448: BEGIN
449: l_child_item_key := hxc_timekeeper_wf_pkg.get_item_key;
450:
451: wf_engine.CreateProcess(itemtype => p_tc_item_type,
452: itemkey => l_child_item_key,
453: process => p_tc_process_name);
454:
455: wf_engine.setitemowner(p_tc_item_type,

Line 455: wf_engine.setitemowner(p_tc_item_type,

451: wf_engine.CreateProcess(itemtype => p_tc_item_type,
452: itemkey => l_child_item_key,
453: process => p_tc_process_name);
454:
455: wf_engine.setitemowner(p_tc_item_type,
456: l_child_item_key,
457: HXC_FIND_NOTIFY_APRS_PKG.get_login(p_tc_timekeeper_id));
458:
459:

Line 460: wf_engine.SetItemAttrNumber

456: l_child_item_key,
457: HXC_FIND_NOTIFY_APRS_PKG.get_login(p_tc_timekeeper_id));
458:
459:
460: wf_engine.SetItemAttrNumber
461: (itemtype => p_tc_item_type
462: ,itemkey => l_child_item_key
463: ,aname => 'TC_BLD_BLK_ID'
464: ,avalue => p_tc_bb_id

Line 467: wf_engine.SetItemAttrNumber

463: ,aname => 'TC_BLD_BLK_ID'
464: ,avalue => p_tc_bb_id
465: );
466:
467: wf_engine.SetItemAttrNumber
468: (itemtype => p_tc_item_type
469: ,itemkey => l_child_item_key
470: ,aname => 'TC_BLD_BLK_OVN'
471: ,avalue => p_tc_bb_ovn

Line 474: wf_engine.SetItemAttrNumber

470: ,aname => 'TC_BLD_BLK_OVN'
471: ,avalue => p_tc_bb_ovn
472: );
473:
474: wf_engine.SetItemAttrNumber
475: (itemtype => p_tc_item_type
476: ,itemkey => l_child_item_key
477: ,aname => 'RESOURCE_ID'
478: ,avalue => p_tc_resource_id

Line 481: wf_engine.SetItemAttrDate

477: ,aname => 'RESOURCE_ID'
478: ,avalue => p_tc_resource_id
479: );
480:
481: wf_engine.SetItemAttrDate
482: (itemtype => p_tc_item_type
483: ,itemkey => l_child_item_key
484: ,aname => 'TC_START'
485: ,avalue => p_tc_start_time

Line 488: wf_engine.SetItemAttrText

484: ,aname => 'TC_START'
485: ,avalue => p_tc_start_time
486: );
487:
488: wf_engine.SetItemAttrText
489: (itemtype => p_tc_item_type
490: ,itemkey => l_child_item_key
491: ,aname => 'FORMATTED_TC_START'
492: ,avalue => to_char(p_tc_start_time,'YYYY/MM/DD')

Line 495: wf_engine.SetItemAttrDate

491: ,aname => 'FORMATTED_TC_START'
492: ,avalue => to_char(p_tc_start_time,'YYYY/MM/DD')
493: );
494:
495: wf_engine.SetItemAttrDate
496: (itemtype => p_tc_item_type
497: ,itemkey => l_child_item_key
498: ,aname => 'TC_STOP'
499: ,avalue => p_tc_stop_time

Line 502: wf_engine.SetItemAttrText

498: ,aname => 'TC_STOP'
499: ,avalue => p_tc_stop_time
500: );
501:
502: wf_engine.SetItemAttrText
503: (itemtype => p_tc_item_type
504: ,itemkey => l_child_item_key
505: ,aname => 'FORMATTED_TC_STOP'
506: ,avalue => to_char(p_tc_stop_time,'YYYY/MM/DD')

Line 509: wf_engine.SetItemAttrNumber

505: ,aname => 'FORMATTED_TC_STOP'
506: ,avalue => to_char(p_tc_stop_time,'YYYY/MM/DD')
507: );
508:
509: wf_engine.SetItemAttrNumber
510: (itemtype => p_tc_item_type
511: ,itemkey => l_child_item_key
512: ,aname => 'TIMEKEEPER_ID'
513: ,avalue => p_tc_timekeeper_id

Line 516: wf_engine.SetItemAttrText

512: ,aname => 'TIMEKEEPER_ID'
513: ,avalue => p_tc_timekeeper_id
514: );
515:
516: wf_engine.SetItemAttrText
517: (itemtype => p_tc_item_type,
518: itemkey => l_child_item_key,
519: aname => 'APR_NOTIFY_TYPE',
520: avalue => p_tc_tk_nofity_type

Line 523: wf_engine.SetItemAttrText

519: aname => 'APR_NOTIFY_TYPE',
520: avalue => p_tc_tk_nofity_type
521: );
522:
523: wf_engine.SetItemAttrText
524: (itemtype => p_tc_item_type,
525: itemkey => l_child_item_key,
526: aname => 'APR_NOTIFY_TO',
527: avalue => p_tc_tk_nofity_to

Line 530: wf_engine.SetItemParent

526: aname => 'APR_NOTIFY_TO',
527: avalue => p_tc_tk_nofity_to
528: );
529:
530: wf_engine.SetItemParent
531: (itemtype => p_tc_item_type,
532: itemkey => l_child_item_key,
533: parent_itemtype => p_tc_item_type,
534: parent_itemkey => p_tc_item_key,

Line 537: wf_engine.StartProcess(itemtype => p_tc_item_type,

533: parent_itemtype => p_tc_item_type,
534: parent_itemkey => p_tc_item_key,
535: parent_context => NULL);
536:
537: wf_engine.StartProcess(itemtype => p_tc_item_type,
538: itemkey => l_child_item_key);
539: END START_CHILD_PROCESS;
540:
541: -------------------------------------------------------------------

Line 557: wf_engine.createProcess

553: ,p_tk_nofity_to IN VARCHAR2
554: )is
555: BEGIN
556:
557: wf_engine.createProcess
558: (itemtype => p_item_type
559: ,itemkey => p_item_key
560: ,process => p_process_name
561: );

Line 563: wf_engine.SetItemAttrNumber

559: ,itemkey => p_item_key
560: ,process => p_process_name
561: );
562:
563: wf_engine.SetItemAttrNumber
564: (itemtype => p_item_type
565: ,itemkey => p_item_key
566: ,aname => 'TC_BLD_BLK_ID'
567: ,avalue => p_tc_bb_id

Line 570: wf_engine.SetItemAttrNumber

566: ,aname => 'TC_BLD_BLK_ID'
567: ,avalue => p_tc_bb_id
568: );
569:
570: wf_engine.SetItemAttrNumber
571: (itemtype => p_item_type
572: ,itemkey => p_item_key
573: ,aname => 'TC_BLD_BLK_OVN'
574: ,avalue => p_tc_ovn

Line 577: wf_engine.SetItemAttrNumber

573: ,aname => 'TC_BLD_BLK_OVN'
574: ,avalue => p_tc_ovn
575: );
576:
577: wf_engine.SetItemAttrNumber
578: (itemtype => p_item_type
579: ,itemkey => p_item_key
580: ,aname => 'RESOURCE_ID'
581: ,avalue => p_tc_resource_id

Line 584: wf_engine.SetItemAttrNumber

580: ,aname => 'RESOURCE_ID'
581: ,avalue => p_tc_resource_id
582: );
583:
584: wf_engine.SetItemAttrNumber
585: (itemtype => p_item_type
586: ,itemkey => p_item_key
587: ,aname => 'TIMEKEEPER_ID'
588: ,avalue => p_timekeeper_id

Line 591: wf_engine.SetItemAttrText

587: ,aname => 'TIMEKEEPER_ID'
588: ,avalue => p_timekeeper_id
589: );
590:
591: wf_engine.SetItemAttrText
592: (itemtype => p_item_type,
593: itemkey => p_item_key,
594: aname => 'TK_NOTIFY_TYPE',
595: avalue => p_tk_nofity_type

Line 598: wf_engine.SetItemAttrText

594: aname => 'TK_NOTIFY_TYPE',
595: avalue => p_tk_nofity_type
596: );
597:
598: wf_engine.SetItemAttrText
599: (itemtype => p_item_type,
600: itemkey => p_item_key,
601: aname => 'TK_NOTIFY_TO',
602: avalue => p_tk_nofity_to

Line 605: wf_engine.setitemowner

601: aname => 'TK_NOTIFY_TO',
602: avalue => p_tk_nofity_to
603: );
604:
605: wf_engine.setitemowner
606: (itemtype => p_item_type
607: ,itemkey => p_item_key
608: ,owner => HXC_FIND_NOTIFY_APRS_PKG.get_login(p_tc_resource_id));
609:

Line 610: wf_engine.StartProcess

606: (itemtype => p_item_type
607: ,itemkey => p_item_key
608: ,owner => HXC_FIND_NOTIFY_APRS_PKG.get_login(p_tc_resource_id));
609:
610: wf_engine.StartProcess
611: (itemtype => p_item_type
612: ,itemkey => p_item_key
613: );
614:

Line 615: wf_engine.threshold := 50;

611: (itemtype => p_item_type
612: ,itemkey => p_item_key
613: );
614:
615: wf_engine.threshold := 50;
616:
617: END start_tk_wf_process;
618:
619: -------------------------------------------------------------------

Line 659: l_tc_bb_id := wf_engine.GetItemAttrNumber(

655: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
656:
657: BEGIN
658:
659: l_tc_bb_id := wf_engine.GetItemAttrNumber(
660: itemtype => p_itemtype,
661: itemkey => p_itemkey,
662: aname => 'TC_BLD_BLK_ID');
663:

Line 664: l_tc_bb_ovn := wf_engine.GetItemAttrNumber(

660: itemtype => p_itemtype,
661: itemkey => p_itemkey,
662: aname => 'TC_BLD_BLK_ID');
663:
664: l_tc_bb_ovn := wf_engine.GetItemAttrNumber(
665: itemtype => p_itemtype,
666: itemkey => p_itemkey,
667: aname => 'TC_BLD_BLK_OVN');
668:

Line 669: l_timkeeper_id := wf_engine.GetItemAttrNumber(

665: itemtype => p_itemtype,
666: itemkey => p_itemkey,
667: aname => 'TC_BLD_BLK_OVN');
668:
669: l_timkeeper_id := wf_engine.GetItemAttrNumber(
670: itemtype => p_itemtype,
671: itemkey => p_itemkey,
672: aname => 'TIMEKEEPER_ID');
673:

Line 674: l_resource_id := wf_engine.GetItemAttrNumber(

670: itemtype => p_itemtype,
671: itemkey => p_itemkey,
672: aname => 'TIMEKEEPER_ID');
673:
674: l_resource_id := wf_engine.GetItemAttrNumber(
675: itemtype => p_itemtype,
676: itemkey => p_itemkey,
677: aname => 'RESOURCE_ID');
678:

Line 679: l_ntf_to := wf_engine.GetItemAttrText(

675: itemtype => p_itemtype,
676: itemkey => p_itemkey,
677: aname => 'RESOURCE_ID');
678:
679: l_ntf_to := wf_engine.GetItemAttrText(
680: itemtype => p_itemtype,
681: itemkey => p_itemkey ,
682: aname => 'TK_NOTIFY_TO');
683:

Line 684: l_ntf_type := wf_engine.GetItemAttrText(

680: itemtype => p_itemtype,
681: itemkey => p_itemkey ,
682: aname => 'TK_NOTIFY_TO');
683:
684: l_ntf_type := wf_engine.GetItemAttrText(
685: itemtype => p_itemtype,
686: itemkey => p_itemkey ,
687: aname => 'TK_NOTIFY_TYPE');
688:

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

698: hr_utility.raise_error;
699: end if;
700: close c_tc_info;
701:
702: wf_engine.SetItemAttrDate(itemtype => p_itemtype,
703: itemkey => p_itemkey,
704: aname => 'TC_START',
705: avalue => l_tc_start_time);
706:

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

703: itemkey => p_itemkey,
704: aname => 'TC_START',
705: avalue => l_tc_start_time);
706:
707: wf_engine.SetItemAttrDate(itemtype => p_itemtype,
708: itemkey => p_itemkey,
709: aname => 'TC_STOP',
710: avalue => l_tc_stop_time);
711:

Line 778: l_apr_ntf_to := wf_engine.GetItemAttrText(

774: l_apr_ntf_to VARCHAR2(150);
775:
776: BEGIN
777:
778: l_apr_ntf_to := wf_engine.GetItemAttrText(
779: itemtype => p_itemtype,
780: itemkey => p_itemkey ,
781: aname => 'APR_NOTIFY_TO');
782:

Line 819: l_tc_bb_id := wf_engine.GetItemAttrNumber(

815: BEGIN
816:
817: g_debug := hr_utility.debug_enabled;
818:
819: l_tc_bb_id := wf_engine.GetItemAttrNumber(
820: itemtype => p_itemtype,
821: itemkey => p_itemkey,
822: aname => 'TC_BLD_BLK_ID');
823:

Line 829: l_tc_bb_ovn := wf_engine.GetItemAttrNumber(

825: l_proc := 'hxc_timekeeper_wf_pkg.PERSON_NOTIFY';
826: hr_utility.trace('l_tc_bb_id='||l_tc_bb_id);
827: end if;
828:
829: l_tc_bb_ovn := wf_engine.GetItemAttrNumber(
830: itemtype => p_itemtype,
831: itemkey => p_itemkey,
832: aname => 'TC_BLD_BLK_OVN');
833:

Line 838: l_resource_id := wf_engine.GetItemAttrNumber(

834: if g_debug then
835: hr_utility.trace('l_tc_bb_ovn='||l_tc_bb_ovn);
836: end if;
837:
838: l_resource_id := wf_engine.GetItemAttrNumber(
839: itemtype => p_itemtype,
840: itemkey => p_itemkey,
841: aname => 'RESOURCE_ID');
842:

Line 847: l_start_date := wf_engine.GetItemAttrDate(

843: if g_debug then
844: hr_utility.trace('l_resource_id='||l_resource_id);
845: end if;
846:
847: l_start_date := wf_engine.GetItemAttrDate(
848: itemtype => p_itemtype,
849: itemkey => p_itemkey ,
850: aname => 'TC_START');
851:

Line 856: l_stop_date := wf_engine.GetItemAttrDate(

852: if g_debug then
853: hr_utility.trace('l_start_date='||to_char(l_start_date));
854: end if;
855:
856: l_stop_date := wf_engine.GetItemAttrDate(
857: itemtype => p_itemtype,
858: itemkey => p_itemkey ,
859: aname => 'TC_STOP');
860:

Line 865: l_ntf_type := wf_engine.GetItemAttrText(

861: if g_debug then
862: hr_utility.trace('l_stop_date='||to_char(l_stop_date));
863: end if;
864:
865: l_ntf_type := wf_engine.GetItemAttrText(
866: itemtype => p_itemtype,
867: itemkey => p_itemkey ,
868: aname => 'APR_NOTIFY_TYPE');
869:

Line 874: l_timekeeper_id := wf_engine.GetItemAttrNumber(

870: if g_debug then
871: hr_utility.trace('l_ntf_type='||l_ntf_type);
872: end if;
873:
874: l_timekeeper_id := wf_engine.GetItemAttrNumber(
875: itemtype => p_itemtype,
876: itemkey => p_itemkey,
877: aname => 'TIMEKEEPER_ID');
878:

Line 883: wf_engine.SetItemAttrNumber(

879: if g_debug then
880: hr_utility.trace('l_timekeeper_id='||l_timekeeper_id);
881: end if;
882:
883: wf_engine.SetItemAttrNumber(
884: itemtype => p_itemtype,
885: itemkey => p_itemkey,
886: aname => 'APR_PERSON_ID',
887: avalue => l_resource_id);

Line 902: wf_engine.SetItemAttrText(

898: hr_utility.trace('l_login'||l_login);
899: end if;
900:
901: --set role attribute
902: wf_engine.SetItemAttrText(
903: itemtype => p_itemtype,
904: itemkey => p_itemkey,
905: aname => 'TC_FROM_ROLE',
906: avalue => l_login);

Line 916: wf_engine.SetItemAttrText(

912: if g_debug then
913: hr_utility.trace('l_fyi_login='||l_fyi_login);
914: end if;
915:
916: wf_engine.SetItemAttrText(
917: itemtype => p_itemtype,
918: itemkey => p_itemkey,
919: aname => 'TC_OWNER',
920: avalue => get_name(l_resource_id,l_start_date)

Line 923: wf_engine.SetItemAttrText(

919: aname => 'TC_OWNER',
920: avalue => get_name(l_resource_id,l_start_date)
921: );
922:
923: wf_engine.SetItemAttrText(
924: itemtype => p_itemtype,
925: itemkey => p_itemkey,
926: aname => 'TC_TIMEKEEPER',
927: avalue => get_name(l_timekeeper_id,l_start_date)

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

926: aname => 'TC_TIMEKEEPER',
927: avalue => get_name(l_timekeeper_id,l_start_date)
928: );
929:
930: wf_engine.SetItemAttrText(itemtype => p_itemtype,
931: itemkey => p_itemkey,
932: aname => 'TC_OWNER_SS_LOGIN',
933: avalue => l_fyi_login);
934:

Line 935: wf_engine.SetItemAttrText(

931: itemkey => p_itemkey,
932: aname => 'TC_OWNER_SS_LOGIN',
933: avalue => l_fyi_login);
934:
935: wf_engine.SetItemAttrText(
936: itemtype => p_itemtype,
937: itemkey => p_itemkey,
938: aname => 'APR_SS_LOGIN',
939: avalue => l_fyi_login);

Line 951: wf_engine.SetItemAttrText(

947: if g_debug then
948: hr_utility.trace('l_title='||substr(l_title,1,20));
949: end if;
950:
951: wf_engine.SetItemAttrText(
952: itemtype => p_itemtype,
953: itemkey => p_itemkey,
954: aname => 'TITLE',
955: avalue => l_title);

Line 963: wf_engine.SetItemAttrText(

959: if g_debug then
960: hr_utility.trace('l_otl_appr_id='||l_otl_appr_id);
961: end if;
962:
963: wf_engine.SetItemAttrText(
964: itemtype => p_itemtype,
965: itemkey => p_itemkey,
966: aname => 'OTL_APPR_ID',
967: avalue => l_otl_appr_id);

Line 1020: l_tc_bb_id := wf_engine.GetItemAttrNumber(

1016:
1017:
1018: BEGIN
1019:
1020: l_tc_bb_id := wf_engine.GetItemAttrNumber(
1021: itemtype => p_itemtype,
1022: itemkey => p_itemkey,
1023: aname => 'TC_BLD_BLK_ID');
1024:

Line 1025: l_tc_bb_ovn := wf_engine.GetItemAttrNumber(

1021: itemtype => p_itemtype,
1022: itemkey => p_itemkey,
1023: aname => 'TC_BLD_BLK_ID');
1024:
1025: l_tc_bb_ovn := wf_engine.GetItemAttrNumber(
1026: itemtype => p_itemtype,
1027: itemkey => p_itemkey,
1028: aname => 'TC_BLD_BLK_OVN');
1029:

Line 1030: l_resource_id := wf_engine.GetItemAttrNumber(

1026: itemtype => p_itemtype,
1027: itemkey => p_itemkey,
1028: aname => 'TC_BLD_BLK_OVN');
1029:
1030: l_resource_id := wf_engine.GetItemAttrNumber(
1031: itemtype => p_itemtype,
1032: itemkey => p_itemkey,
1033: aname => 'RESOURCE_ID');
1034:

Line 1035: l_start_date := wf_engine.GetItemAttrDate(

1031: itemtype => p_itemtype,
1032: itemkey => p_itemkey,
1033: aname => 'RESOURCE_ID');
1034:
1035: l_start_date := wf_engine.GetItemAttrDate(
1036: itemtype => p_itemtype,
1037: itemkey => p_itemkey ,
1038: aname => 'TC_START');
1039: l_stop_date := wf_engine.GetItemAttrDate(

Line 1039: l_stop_date := wf_engine.GetItemAttrDate(

1035: l_start_date := wf_engine.GetItemAttrDate(
1036: itemtype => p_itemtype,
1037: itemkey => p_itemkey ,
1038: aname => 'TC_START');
1039: l_stop_date := wf_engine.GetItemAttrDate(
1040: itemtype => p_itemtype,
1041: itemkey => p_itemkey ,
1042: aname => 'TC_STOP');
1043:

Line 1044: l_timekeeper_id := wf_engine.GetItemAttrNumber(

1040: itemtype => p_itemtype,
1041: itemkey => p_itemkey ,
1042: aname => 'TC_STOP');
1043:
1044: l_timekeeper_id := wf_engine.GetItemAttrNumber(
1045: itemtype => p_itemtype,
1046: itemkey => p_itemkey,
1047: aname => 'TIMEKEEPER_ID');
1048:

Line 1049: l_ntf_type := wf_engine.GetItemAttrText(

1045: itemtype => p_itemtype,
1046: itemkey => p_itemkey,
1047: aname => 'TIMEKEEPER_ID');
1048:
1049: l_ntf_type := wf_engine.GetItemAttrText(
1050: itemtype => p_itemtype,
1051: itemkey => p_itemkey ,
1052: aname => 'APR_NOTIFY_TYPE');
1053:

Line 1058: wf_engine.SetItemAttrText(

1054: l_login := set_login(p_person_id => l_timekeeper_id
1055: ,p_tc_bb_id => l_tc_bb_id
1056: ,p_tc_bb_ovn => l_tc_bb_ovn);
1057:
1058: wf_engine.SetItemAttrText(
1059: itemtype => p_itemtype,
1060: itemkey => p_itemkey,
1061: aname => 'TC_TIMEKEEPER',
1062: avalue => get_name(l_timekeeper_id,l_start_date)

Line 1066: wf_engine.SetItemAttrText(

1062: avalue => get_name(l_timekeeper_id,l_start_date)
1063: );
1064:
1065: --set role attribute
1066: wf_engine.SetItemAttrText(
1067: itemtype => p_itemtype,
1068: itemkey => p_itemkey,
1069: aname => 'TC_FROM_ROLE',
1070: avalue => l_login);

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

1072: l_login := set_login(p_person_id => l_resource_id
1073: ,p_tc_bb_id => l_tc_bb_id
1074: ,p_tc_bb_ovn => l_tc_bb_ovn);
1075:
1076: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1077: itemkey => p_itemkey,
1078: aname => 'TC_OWNER_SS_LOGIN',
1079: avalue => l_login);
1080:

Line 1081: wf_engine.SetItemAttrText(

1077: itemkey => p_itemkey,
1078: aname => 'TC_OWNER_SS_LOGIN',
1079: avalue => l_login);
1080:
1081: wf_engine.SetItemAttrText(
1082: itemtype => p_itemtype,
1083: itemkey => p_itemkey,
1084: aname => 'TC_OWNER',
1085: avalue => get_name(l_resource_id,l_start_date)

Line 1091: wf_engine.SetItemAttrNumber(

1087:
1088: l_supervisor := get_supervisor(l_resource_id,l_start_date);
1089:
1090:
1091: wf_engine.SetItemAttrNumber(
1092: itemtype => p_itemtype,
1093: itemkey => p_itemkey,
1094: aname => 'APR_PERSON_ID',
1095: avalue => l_supervisor);

Line 1101: wf_engine.SetItemAttrText(

1097: l_login := set_login(p_person_id => l_supervisor
1098: ,p_tc_bb_id => l_tc_bb_id
1099: ,p_tc_bb_ovn => l_tc_bb_ovn);
1100:
1101: wf_engine.SetItemAttrText(
1102: itemtype => p_itemtype,
1103: itemkey => p_itemkey,
1104: aname => 'APR_SS_LOGIN',
1105: avalue => l_login);

Line 1112: wf_engine.SetItemAttrText(

1108: fnd_message.set_token('END_DATE',to_char(l_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1109:
1110: l_title := fnd_message.get();
1111:
1112: wf_engine.SetItemAttrText(
1113: itemtype => p_itemtype,
1114: itemkey => p_itemkey,
1115: aname => 'TITLE',
1116: avalue => l_title);

Line 1120: wf_engine.SetItemAttrText(

1116: avalue => l_title);
1117:
1118: l_otl_appr_id := l_tc_bb_id||'#'||p_itemkey;
1119:
1120: wf_engine.SetItemAttrText(
1121: itemtype => p_itemtype,
1122: itemkey => p_itemkey,
1123: aname => 'OTL_APPR_ID',
1124: avalue => l_otl_appr_id);

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

1149:
1150:
1151: BEGIN
1152:
1153: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1154: itemkey => p_itemkey,
1155: aname => 'APPROVAL_STATUS',
1156: avalue => 'APPROVED');
1157:

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

1174: l_display_name VARCHAR2(250);
1175:
1176: BEGIN
1177:
1178: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1179: itemkey => p_itemkey,
1180: aname => 'APPROVAL_STATUS',
1181: avalue => 'REJECTED');
1182:

Line 1231: l_tc_resource_id := wf_engine.GetItemAttrNumber(

1227: BEGIN
1228:
1229: g_debug := hr_utility.debug_enabled;
1230:
1231: l_tc_resource_id := wf_engine.GetItemAttrNumber(
1232: itemtype => p_itemtype,
1233: itemkey => p_itemkey ,
1234: aname => 'RESOURCE_ID');
1235:

Line 1236: l_period_start_date := wf_engine.GetItemAttrDate(

1232: itemtype => p_itemtype,
1233: itemkey => p_itemkey ,
1234: aname => 'RESOURCE_ID');
1235:
1236: l_period_start_date := wf_engine.GetItemAttrDate(
1237: itemtype => p_itemtype,
1238: itemkey => p_itemkey ,
1239: aname => 'TC_START');
1240:

Line 1241: l_period_end_date := wf_engine.GetItemAttrDate(

1237: itemtype => p_itemtype,
1238: itemkey => p_itemkey ,
1239: aname => 'TC_START');
1240:
1241: l_period_end_date := wf_engine.GetItemAttrDate(
1242: itemtype => p_itemtype,
1243: itemkey => p_itemkey ,
1244: aname => 'TC_STOP');
1245:

Line 1246: l_tbb_id := wf_engine.GetItemAttrNumber(

1242: itemtype => p_itemtype,
1243: itemkey => p_itemkey ,
1244: aname => 'TC_STOP');
1245:
1246: l_tbb_id := wf_engine.GetItemAttrNumber(
1247: itemtype => p_itemtype,
1248: itemkey => p_itemkey,
1249: aname => 'TC_BLD_BLK_ID');
1250:

Line 1251: l_tbb_ovn := wf_engine.GetItemAttrNumber(

1247: itemtype => p_itemtype,
1248: itemkey => p_itemkey,
1249: aname => 'TC_BLD_BLK_ID');
1250:
1251: l_tbb_ovn := wf_engine.GetItemAttrNumber(
1252: itemtype => p_itemtype,
1253: itemkey => p_itemkey,
1254: aname => 'TC_BLD_BLK_OVN');
1255:

Line 1256: l_approval_status := wf_engine.GetItemAttrText(

1252: itemtype => p_itemtype,
1253: itemkey => p_itemkey,
1254: aname => 'TC_BLD_BLK_OVN');
1255:
1256: l_approval_status := wf_engine.GetItemAttrText(
1257: itemtype => p_itemtype,
1258: itemkey => p_itemkey ,
1259: aname => 'APPROVAL_STATUS');
1260:

Line 1261: l_approver_comment := wf_engine.GetItemAttrText(

1257: itemtype => p_itemtype,
1258: itemkey => p_itemkey ,
1259: aname => 'APPROVAL_STATUS');
1260:
1261: l_approver_comment := wf_engine.GetItemAttrText(
1262: itemtype => p_itemtype,
1263: itemkey => p_itemkey,
1264: aname => 'APR_REJ_REASON');
1265:

Line 1266: l_approver_type := wf_engine.GetItemAttrText(

1262: itemtype => p_itemtype,
1263: itemkey => p_itemkey,
1264: aname => 'APR_REJ_REASON');
1265:
1266: l_approver_type := wf_engine.GetItemAttrText(
1267: itemtype => p_itemtype,
1268: itemkey => p_itemkey,
1269: aname => 'APR_NOTIFY_TO');
1270: