DBA Data[Home] [Help]

APPS.PER_CHECKLIST_EVENTS dependencies on WF_ENGINE

Line 27: l_taskin_cklid := wf_engine.GetItemAttrNumber(

23: l_proc := g_package||'check_process';
24: hr_utility.set_location('Entering:'|| l_proc, 10);
25: hr_utility.set_location(l_proc,1);
26:
27: l_taskin_cklid := wf_engine.GetItemAttrNumber(
28: itemtype => itemtype
29: ,itemkey => itemkey
30: ,aname => 'TASKIN_CKLID'
31: ,ignore_notfound => false

Line 168: wf_engine.SetItemAttrText(itemtype,itemkey,'TASK_STATUS', hr_general.decode_lookup('PER_CHECKLIST_TASK_STATUS','COM'));

164: open cur_check_wf_status(itemtype||':'|| itemkey ||':%');
165: fetch cur_check_wf_status into l_status,l_responder;
166: if(cur_check_wf_status%FOUND) then
167: if(l_status is not null and l_status='COMPLETE' )then
168: wf_engine.SetItemAttrText(itemtype,itemkey,'TASK_STATUS', hr_general.decode_lookup('PER_CHECKLIST_TASK_STATUS','COM'));
169: wf_engine.SetItemAttrText(itemtype,itemkey,'TASK_DONE_BY',l_responder);
170: resultout:='COMPLETE:'||l_status;
171: else
172: if (l_status is not null and l_status='NOT COMPLETED' )then

Line 169: wf_engine.SetItemAttrText(itemtype,itemkey,'TASK_DONE_BY',l_responder);

165: fetch cur_check_wf_status into l_status,l_responder;
166: if(cur_check_wf_status%FOUND) then
167: if(l_status is not null and l_status='COMPLETE' )then
168: wf_engine.SetItemAttrText(itemtype,itemkey,'TASK_STATUS', hr_general.decode_lookup('PER_CHECKLIST_TASK_STATUS','COM'));
169: wf_engine.SetItemAttrText(itemtype,itemkey,'TASK_DONE_BY',l_responder);
170: resultout:='COMPLETE:'||l_status;
171: else
172: if (l_status is not null and l_status='NOT COMPLETED' )then
173: wf_engine.SetItemAttrText(itemtype,itemkey,'TASK_STATUS',hr_general.decode_lookup('PER_CHECKLIST_TASK_STATUS','REJ'));

Line 173: wf_engine.SetItemAttrText(itemtype,itemkey,'TASK_STATUS',hr_general.decode_lookup('PER_CHECKLIST_TASK_STATUS','REJ'));

169: wf_engine.SetItemAttrText(itemtype,itemkey,'TASK_DONE_BY',l_responder);
170: resultout:='COMPLETE:'||l_status;
171: else
172: if (l_status is not null and l_status='NOT COMPLETED' )then
173: wf_engine.SetItemAttrText(itemtype,itemkey,'TASK_STATUS',hr_general.decode_lookup('PER_CHECKLIST_TASK_STATUS','REJ'));
174: wf_engine.SetItemAttrText(itemtype,itemkey,'TASK_DONE_BY',l_responder);
175: resultout:='COMPLETE:'||l_status;
176: end if;
177: end if;

Line 174: wf_engine.SetItemAttrText(itemtype,itemkey,'TASK_DONE_BY',l_responder);

170: resultout:='COMPLETE:'||l_status;
171: else
172: if (l_status is not null and l_status='NOT COMPLETED' )then
173: wf_engine.SetItemAttrText(itemtype,itemkey,'TASK_STATUS',hr_general.decode_lookup('PER_CHECKLIST_TASK_STATUS','REJ'));
174: wf_engine.SetItemAttrText(itemtype,itemkey,'TASK_DONE_BY',l_responder);
175: resultout:='COMPLETE:'||l_status;
176: end if;
177: end if;
178: end if;

Line 823: varname Wf_Engine.NameTabTyp;

819: from per_all_people_f
820: where person_id = p_person_id
821: and trunc(sysdate) between effective_start_date and effective_end_date;
822:
823: varname Wf_Engine.NameTabTyp;
824: varvalue Wf_Engine.TextTabTyp;
825: numname Wf_Engine.NameTabTyp;
826: numvalue Wf_Engine.NumTabTyp;
827: --

Line 824: varvalue Wf_Engine.TextTabTyp;

820: where person_id = p_person_id
821: and trunc(sysdate) between effective_start_date and effective_end_date;
822:
823: varname Wf_Engine.NameTabTyp;
824: varvalue Wf_Engine.TextTabTyp;
825: numname Wf_Engine.NameTabTyp;
826: numvalue Wf_Engine.NumTabTyp;
827: --
828: l_performer_name varchar2(3000);

Line 825: numname Wf_Engine.NameTabTyp;

821: and trunc(sysdate) between effective_start_date and effective_end_date;
822:
823: varname Wf_Engine.NameTabTyp;
824: varvalue Wf_Engine.TextTabTyp;
825: numname Wf_Engine.NameTabTyp;
826: numvalue Wf_Engine.NumTabTyp;
827: --
828: l_performer_name varchar2(3000);
829:

Line 826: numvalue Wf_Engine.NumTabTyp;

822:
823: varname Wf_Engine.NameTabTyp;
824: varvalue Wf_Engine.TextTabTyp;
825: numname Wf_Engine.NameTabTyp;
826: numvalue Wf_Engine.NumTabTyp;
827: --
828: l_performer_name varchar2(3000);
829:
830: begin

Line 844: wf_engine.CreateProcess (ItemType => l_Item_Type

840: FETCH csr_person_name into l_person_name;
841: CLOSE csr_person_name;
842:
843:
844: wf_engine.CreateProcess (ItemType => l_Item_Type
845: ,ItemKey => l_Item_Key
846: ,process => l_process
847: ,User_Key => l_user_key
848: ,Owner_Role => 'COREHR' --l_task_owner -- p_task_owner

Line 870: wf_engine.SetItemAttrTextArray(l_Item_Type,l_Item_Key,varname,varvalue);

866: varvalue(6) := p_checklist_description;
867: varname(7) := 'PERSON';
868: varvalue(7) := l_person_name;
869:
870: wf_engine.SetItemAttrTextArray(l_Item_Type,l_Item_Key,varname,varvalue);
871: --
872: numname(1) := 'ALLOC_TASKID';
873: numvalue(1) := p_allocated_task_id;
874: numname(2) := 'TASKIN_CKLID';

Line 877: wf_engine.SetItemAttrNumberArray(l_Item_Type,l_Item_Key,numname,numvalue);

873: numvalue(1) := p_allocated_task_id;
874: numname(2) := 'TASKIN_CKLID';
875: numvalue(2) := p_task_in_checklist_id;
876:
877: wf_engine.SetItemAttrNumberArray(l_Item_Type,l_Item_Key,numname,numvalue);
878: --
879: wf_engine.SetItemAttrDate (itemtype => l_Item_Type
880: ,itemkey => l_Item_Key
881: ,aname => 'TARGETDATE'

Line 879: wf_engine.SetItemAttrDate (itemtype => l_Item_Type

875: numvalue(2) := p_task_in_checklist_id;
876:
877: wf_engine.SetItemAttrNumberArray(l_Item_Type,l_Item_Key,numname,numvalue);
878: --
879: wf_engine.SetItemAttrDate (itemtype => l_Item_Type
880: ,itemkey => l_Item_Key
881: ,aname => 'TARGETDATE'
882: ,avalue => p_target_date
883: );

Line 885: wf_engine.StartProcess (itemtype => l_Item_Type

881: ,aname => 'TARGETDATE'
882: ,avalue => p_target_date
883: );
884:
885: wf_engine.StartProcess (itemtype => l_Item_Type
886: ,itemkey => l_Item_Key
887: );
888: --
889: if g_debug then

Line 925: l_alloc_id := wf_engine.GetItemAttrNumber(

921: --
922: if (funcmode = 'RUN') then
923: --
924: --
925: l_alloc_id := wf_engine.GetItemAttrNumber(
926: itemtype => itemtype
927: ,itemkey => itemkey
928: ,aname => 'ALLOC_TASKID'
929: ,ignore_notfound => false

Line 979: l_alloc_id := wf_engine.GetItemAttrNumber(

975: --
976: if (funcmode = 'RUN')
977: then
978: --
979: l_alloc_id := wf_engine.GetItemAttrNumber(
980: itemtype => itemtype
981: ,itemkey => itemkey
982: ,aname => 'ALLOC_TASKID'
983: ,ignore_notfound => false

Line 1043: l_total_approvers := wf_engine.GetItemAttrNumber(

1039: --
1040: if (funcmode = 'RUN')
1041: then
1042: --
1043: l_total_approvers := wf_engine.GetItemAttrNumber(
1044: itemtype => itemtype
1045: ,itemkey => itemkey
1046: ,aname => 'TOTAL_APPROVERS'
1047: ,ignore_notfound => false

Line 1049: l_curr_approver := wf_engine.GetItemAttrNumber(

1045: ,itemkey => itemkey
1046: ,aname => 'TOTAL_APPROVERS'
1047: ,ignore_notfound => false
1048: );
1049: l_curr_approver := wf_engine.GetItemAttrNumber(
1050: itemtype => itemtype
1051: ,itemkey => itemkey
1052: ,aname => 'CURRENT_APPROVER'
1053: ,ignore_notfound => false

Line 1060: l_taskin_cklid := wf_engine.GetItemAttrNumber(

1056: if l_total_approvers > 1 and (l_curr_approver < l_total_approvers) then
1057: --
1058: l_count := l_curr_approver+1;
1059: -- insert into tp_temp values ('Current Apr lcount ',l_count);
1060: l_taskin_cklid := wf_engine.GetItemAttrNumber(
1061: itemtype => itemtype
1062: ,itemkey => itemkey
1063: ,aname => 'TASKIN_CKLID'
1064: ,ignore_notfound => false

Line 1079: wf_engine.SetItemAttrNumber (

1075: l_recipient := all_approvers(l_count).name;
1076: l_recipient_name := all_approvers(l_count).display_name;
1077:
1078: end;
1079: wf_engine.SetItemAttrNumber (
1080: itemtype => itemtype
1081: ,itemkey => itemkey
1082: ,aname => 'CURRENT_APPROVER'
1083: ,avalue => l_count

Line 1085: wf_engine.SetItemAttrText (

1081: ,itemkey => itemkey
1082: ,aname => 'CURRENT_APPROVER'
1083: ,avalue => l_count
1084: );
1085: wf_engine.SetItemAttrText (
1086: itemtype => itemtype
1087: ,itemkey => itemkey
1088: ,aname => 'RECIPIENT'
1089: ,avalue => l_recipient

Line 1091: wf_engine.SetItemAttrText (

1087: ,itemkey => itemkey
1088: ,aname => 'RECIPIENT'
1089: ,avalue => l_recipient
1090: );
1091: wf_engine.SetItemAttrText (
1092: itemtype => itemtype
1093: ,itemkey => itemkey
1094: ,aname => 'RECIPIENT_NAME'
1095: ,avalue => l_recipient_name