DBA Data[Home] [Help]

APPS.HR_WORKFLOW_SERVICE dependencies on WF_ENGINE

Line 70: l_current_person_username := wf_engine.GetItemAttrText

66: l_current_person_username VARCHAR2(2000) default null;
67: --
68: BEGIN
69: IF funcmode = 'RUN' THEN
70: l_current_person_username := wf_engine.GetItemAttrText
71: (itemtype => itemtype
72: ,itemkey => itemkey
73: ,aname => 'CURRENT_PERSON_USERNAME');
74: --

Line 185: wf_engine.additemattr

181: (p_item_type => p_item_type
182: ,p_item_key => p_item_key
183: ,p_name => l_item_type_attribute_name) then
184: -- the item attribute does not exist so create it
185: wf_engine.additemattr
186: (itemtype => p_item_type
187: ,itemkey => p_item_key
188: ,aname => l_item_type_attribute_name);
189: end if;

Line 193: wf_engine.setitemattrnumber

189: end if;
190: -- set the item attribue value
191: if i = 1 then
192: -- set the ID value
193: wf_engine.setitemattrnumber
194: (itemtype => p_item_type
195: ,itemkey => p_item_key
196: ,aname => l_item_type_attribute_name
197: ,avalue => p_service_person_id);

Line 200: wf_engine.setitemattrtext

196: ,aname => l_item_type_attribute_name
197: ,avalue => p_service_person_id);
198: elsif i = 2 then
199: -- set the USERNAME value
200: wf_engine.setitemattrtext
201: (itemtype => p_item_type
202: ,itemkey => p_item_key
203: ,aname => l_item_type_attribute_name
204: ,avalue => l_username);

Line 207: wf_engine.setitemattrtext

203: ,aname => l_item_type_attribute_name
204: ,avalue => l_username);
205: else
206: -- set the DISPLAY_NAME value
207: wf_engine.setitemattrtext
208: (itemtype => p_item_type
209: ,itemkey => p_item_key
210: ,aname => l_item_type_attribute_name
211: ,avalue => l_display_name);

Line 246: wf_engine.GetItemAttrInfo

242: p_date_value := null;
243: p_number_value := null;
244: p_text_value := null;
245: -- get the item attribute information
246: wf_engine.GetItemAttrInfo
247: (itemtype => p_item_type
248: ,aname => l_name
249: ,atype => l_type
250: ,subtype => p_subtype

Line 257: wf_engine.GetItemAttrNumber

253: p_type := l_type;
254: -- branch on the type
255: if l_type = 'NUMBER' then
256: p_number_value :=
257: wf_engine.GetItemAttrNumber
258: (itemtype => p_item_type
259: ,itemkey => p_item_key
260: ,aname => l_name);
261: elsif l_type = 'DATE' then

Line 263: wf_engine.GetItemAttrDate

259: ,itemkey => p_item_key
260: ,aname => l_name);
261: elsif l_type = 'DATE' then
262: p_date_value :=
263: wf_engine.GetItemAttrDate
264: (itemtype => p_item_type
265: ,itemkey => p_item_key
266: ,aname => l_name);
267: else

Line 269: wf_engine.GetItemAttrText

265: ,itemkey => p_item_key
266: ,aname => l_name);
267: else
268: p_text_value :=
269: wf_engine.GetItemAttrText
270: (itemtype => p_item_type
271: ,itemkey => p_item_key
272: ,aname => l_name);
273: end if;

Line 317: wf_engine.GetActivityAttrInfo

313: p_date_value := null;
314: p_number_value := null;
315: p_text_value := null;
316: -- get the item attribute information
317: wf_engine.GetActivityAttrInfo
318: (itemtype => p_item_type
319: ,itemkey => p_item_key
320: ,actid => p_actid
321: ,aname => l_name

Line 330: wf_engine.GetActivityAttrNumber

326: p_type := l_type;
327: -- branch on the type
328: if l_type = 'NUMBER' then
329: p_number_value :=
330: wf_engine.GetActivityAttrNumber
331: (itemtype => p_item_type
332: ,itemkey => p_item_key
333: ,actid => p_actid
334: ,aname => l_name);

Line 337: wf_engine.GetActivityAttrDate

333: ,actid => p_actid
334: ,aname => l_name);
335: elsif l_type = 'DATE' then
336: p_date_value :=
337: wf_engine.GetActivityAttrDate
338: (itemtype => p_item_type
339: ,itemkey => p_item_key
340: ,actid => p_actid
341: ,aname => l_name);

Line 344: wf_engine.GetActivityAttrText

340: ,actid => p_actid
341: ,aname => l_name);
342: else
343: p_text_value :=
344: wf_engine.GetActivityAttrText
345: (itemtype => p_item_type
346: ,itemkey => p_item_key
347: ,actid => p_actid
348: ,aname => l_name);

Line 859: wf_engine.CreateProcess

855: select hr_workflow_item_key_s.nextval
856: into l_item_key
857: from sys.dual;
858: -- Create the Workflow Process
859: wf_engine.CreateProcess
860: (itemtype => l_item_type
861: ,itemkey => l_item_key
862: ,process => l_process_name);
863: --

Line 883: wf_engine.additemattr

879: (p_item_type => l_item_type
880: ,p_item_key => l_item_key
881: ,p_name => 'SESSION_ID') then
882: -- the SESSION_ID does not exist so create it
883: wf_engine.additemattr
884: (itemtype => l_item_type
885: ,itemkey => l_item_key
886: ,aname => 'SESSION_ID');
887: end if;

Line 889: wf_engine.setitemattrnumber

885: ,itemkey => l_item_key
886: ,aname => 'SESSION_ID');
887: end if;
888: -- set the SESSION_ID to the person who is creating the process
889: wf_engine.setitemattrnumber
890: (itemtype => l_item_type
891: ,itemkey => l_item_key
892: ,aname => 'SESSION_ID'
893: ,avalue => to_number(icx_sec.getID(icx_sec.PV_SESSION_ID)));

Line 900: wf_engine.additemattr

896: (p_item_type => l_item_type
897: ,p_item_key => l_item_key
898: ,p_name => 'PROCESS_NAME') then
899: -- the PROCESS_NAME does not exist so create it
900: wf_engine.additemattr
901: (itemtype => l_item_type
902: ,itemkey => l_item_key
903: ,aname => 'PROCESS_NAME');
904: end if;

Line 906: wf_engine.setitemattrtext

902: ,itemkey => l_item_key
903: ,aname => 'PROCESS_NAME');
904: end if;
905: -- set the PROCESS_NAME
906: wf_engine.setitemattrtext
907: (itemtype => l_item_type
908: ,itemkey => l_item_key
909: ,aname => 'PROCESS_NAME'
910: ,avalue => l_process_name);

Line 917: wf_engine.additemattr

913: (p_item_type => l_item_type
914: ,p_item_key => l_item_key
915: ,p_name => 'PROCESS_DISPLAY_NAME') then
916: -- the PROCESS_DISPLAY_NAME does not exist so create it
917: wf_engine.additemattr
918: (itemtype => l_item_type
919: ,itemkey => l_item_key
920: ,aname => 'PROCESS_DISPLAY_NAME');
921: end if;

Line 923: wf_engine.setitemattrtext

919: ,itemkey => l_item_key
920: ,aname => 'PROCESS_DISPLAY_NAME');
921: end if;
922: -- set the PROCESS_DISPLAY_NAME to the person who is creating the process
923: wf_engine.setitemattrtext
924: (itemtype => l_item_type
925: ,itemkey => l_item_key
926: ,aname => 'PROCESS_DISPLAY_NAME'
927: ,avalue => wf_get_runnable_process_name

Line 935: wf_engine.additemattr

931: if not item_attribute_exists
932: (p_item_type => l_item_type
933: ,p_item_key => l_item_key
934: ,p_name => 'HR_EDA_MODE') then
935: wf_engine.additemattr
936: (itemtype => l_item_type
937: ,itemkey => l_item_key
938: ,aname => 'HR_EDA_MODE');
939: end if;

Line 942: wf_engine.setitemattrtext

938: ,aname => 'HR_EDA_MODE');
939: end if;
940: if p_person_id is null then
941: -- comming from Employee SS
942: wf_engine.setitemattrtext
943: (itemtype => l_item_type
944: ,itemkey => l_item_key
945: ,aname => 'HR_EDA_MODE'
946: ,avalue => 'Y');

Line 949: wf_engine.setitemattrtext

945: ,aname => 'HR_EDA_MODE'
946: ,avalue => 'Y');
947: else
948: -- comming from Manager SS
949: wf_engine.setitemattrtext
950: (itemtype => l_item_type
951: ,itemkey => l_item_key
952: ,aname => 'HR_EDA_MODE'
953: ,avalue => 'N');

Line 979: wf_engine.additemattr

975: if not item_attribute_exists
976: (p_item_type => l_item_type
977: ,p_item_key => l_item_key
978: ,p_name => l_temp_item_attribute) then
979: wf_engine.additemattr
980: (itemtype => l_item_type
981: ,itemkey => l_item_key
982: ,aname => l_temp_item_attribute);
983: end if;

Line 996: wf_engine.setitemattrtext

992: 1, length(l_temp_item_attribute) - 3)
993: ,p_service_person_id => nvl(l_temp_item_attribute_value,
994: l_creator_person_id));
995: else
996: wf_engine.setitemattrtext
997: (itemtype => l_item_type
998: ,itemkey => l_item_key
999: ,aname => l_temp_item_attribute
1000: ,avalue => l_temp_item_attribute_value);

Line 1026: wf_engine.setItemOwner

1022: END IF;
1023: -- ---------------------------------------------------
1024: -- Set the Item Owner (Fix for Bug # 758351)
1025: -- ---------------------------------------------------
1026: wf_engine.setItemOwner
1027: (itemtype => l_item_type
1028: ,itemkey => l_item_key
1029: ,owner => l_role_name);
1030:

Line 1037: wf_engine.additemattr

1033: if not item_attribute_exists
1034: (p_item_type => l_item_type
1035: ,p_item_key => l_item_key
1036: ,p_name => 'CURRENT_EFFECTIVE_DATE') then
1037: wf_engine.additemattr
1038: (itemtype => l_item_type
1039: ,itemkey => l_item_key
1040: ,aname => 'CURRENT_EFFECTIVE_DATE');
1041: end if;

Line 1045: wf_engine.setitemattrdate

1041: end if;
1042:
1043: -- set the item attribute for effective date
1044: --CURRENT_EFFECTIVE_DATE
1045: wf_engine.setitemattrdate
1046: (itemtype => l_item_type
1047: ,itemkey => l_item_key
1048: ,aname => 'CURRENT_EFFECTIVE_DATE'
1049: ,avalue => trunc(sysdate));

Line 1053: wf_engine.startprocess

1049: ,avalue => trunc(sysdate));
1050:
1051:
1052: -- Start the WF runtime process
1053: wf_engine.startprocess
1054: (itemtype => l_item_type
1055: ,itemkey => l_item_key);
1056: -- Continue the process
1057: continue_process

Line 1206: -- transition the wf engine

1202: ,p_actid in wf_activity_attr_values.process_activity_id%type
1203: ,p_result_code in wf_item_activity_statuses_v.activity_result_code%type) is
1204: --
1205: begin
1206: -- transition the wf engine
1207: wf_engine.CompleteActivity
1208: (itemtype => p_item_type
1209: ,itemkey => p_item_key
1210: ,activity => wf_engine.GetActivityLabel(actid => p_actid)

Line 1207: wf_engine.CompleteActivity

1203: ,p_result_code in wf_item_activity_statuses_v.activity_result_code%type) is
1204: --
1205: begin
1206: -- transition the wf engine
1207: wf_engine.CompleteActivity
1208: (itemtype => p_item_type
1209: ,itemkey => p_item_key
1210: ,activity => wf_engine.GetActivityLabel(actid => p_actid)
1211: ,result => p_result_code);

Line 1210: ,activity => wf_engine.GetActivityLabel(actid => p_actid)

1206: -- transition the wf engine
1207: wf_engine.CompleteActivity
1208: (itemtype => p_item_type
1209: ,itemkey => p_item_key
1210: ,activity => wf_engine.GetActivityLabel(actid => p_actid)
1211: ,result => p_result_code);
1212: -- continue the process after it has been transitioned
1213: continue_process
1214: (p_item_type => p_item_type

Line 2194: l_transaction_status_to_delete := wf_engine.getitemattrText

2190: --
2191: -- Get the transaction status value of items to be deleted
2192: -- This is normally passed through the Concurrent program
2193: -- and populated into item attribute HR_TRANS_STATUS_FOR_DEL_ATTR
2194: l_transaction_status_to_delete := wf_engine.getitemattrText
2195: (itemtype => itemtype
2196: ,itemkey => itemkey
2197: ,aname => 'HR_TRAN_STAT_FOR_DEL_ATTR');
2198: -- Get the transaction age value of items to be deleted

Line 2201: l_transaction_age:= wf_engine.getitemattrNumber

2197: ,aname => 'HR_TRAN_STAT_FOR_DEL_ATTR');
2198: -- Get the transaction age value of items to be deleted
2199: -- This is normally passed through the Concurrent program
2200: -- and populated into item attribute 'HR_TRANS_AGE_FOR_DEL_ATTR'
2201: l_transaction_age:= wf_engine.getitemattrNumber
2202: (itemtype => itemtype
2203: ,itemkey => itemkey
2204: ,aname => 'HR_TRANS_AGE_FOR_DEL_ATTR');
2205:

Line 2291: wf_engine.abortprocess(itemtype => itemtype

2287: if(l_delete_transaction) then -- delete transaction which explicitly
2288: -- identified for delete.
2289: -- First abort the WF process for this transaction record.
2290: BEGIN -- Block to 'abort' the WF process
2291: wf_engine.abortprocess(itemtype => itemtype
2292: ,itemkey => rec.item_key
2293: ,result => 'eng_force');
2294: EXCEPTION
2295: when others then

Line 2323: l_transaction_status :=wf_engine.GetItemAttrText(itemtype => itemtype

2319:
2320: if rec.item_key IS NOT NULL then
2321: -- Get the transaction status from the WF item attribute TRAN_SUBMIT
2322: -- need to remove this call once the SSHR V4.1 functionality is implemented.
2323: l_transaction_status :=wf_engine.GetItemAttrText(itemtype => itemtype
2324: ,itemkey => rec.item_key
2325: ,aname => 'TRAN_SUBMIT');
2326:
2327: -- reset the l_delete_transaction status false by default

Line 2344: wf_engine.abortprocess(itemtype => itemtype

2340: if(l_delete_transaction) then -- delete transaction which explicitly
2341: -- identified for delete.
2342: -- First abort the WF process for this transaction record.
2343: BEGIN -- Block to 'abort' the WF process
2344: wf_engine.abortprocess(itemtype => itemtype
2345: ,itemkey => rec.item_key
2346: ,result => 'eng_force');
2347: exception
2348: when others then

Line 2395: wf_engine.abortprocess(itemtype => rec.item_type

2391: -- start bug 5990955
2392:
2393: for rec in csr_wfdfctitmsapprs(l_transaction_age) loop
2394: BEGIN
2395: wf_engine.abortprocess(itemtype => rec.item_type
2396: ,itemkey => rec.item_key
2397: ,result => 'eng_force');
2398:
2399: hr_transaction_api.rollback_transaction(p_transaction_id => rec.transaction_id );

Line 2415: wf_engine.abortprocess(itemtype => 'HRSFL'

2411: -- Fix for bug 6501341
2412: BEGIN
2413: for rec in defunct_wfsfl_ids loop
2414: BEGIN -- Block to 'abort' the WF process
2415: wf_engine.abortprocess(itemtype => 'HRSFL'
2416: ,itemkey => rec.item_key
2417: ,result => 'eng_force');
2418: EXCEPTION
2419: when others then

Line 2495: wf_engine.CreateProcess

2491:
2492:
2493:
2494: -- Create the Workflow Process
2495: wf_engine.CreateProcess
2496: (itemtype => l_item_type
2497: ,itemkey => l_item_key
2498: ,process => l_process_name);
2499: -- set the user key

Line 2500: wf_engine.SetItemUserKey(itemtype=> l_item_type,

2496: (itemtype => l_item_type
2497: ,itemkey => l_item_key
2498: ,process => l_process_name);
2499: -- set the user key
2500: wf_engine.SetItemUserKey(itemtype=> l_item_type,
2501: itemkey => l_item_key,
2502: userkey => l_item_type);
2503:
2504: -- add run time attribute for storing the transaction age.

Line 2510: wf_engine.additemattr

2506: if not item_attribute_exists
2507: (p_item_type => l_item_type
2508: ,p_item_key => l_item_key
2509: ,p_name => 'HR_TRANS_AGE_FOR_DEL_ATTR') then
2510: wf_engine.additemattr
2511: (itemtype => l_item_type
2512: ,itemkey => l_item_key
2513: ,aname => 'HR_TRANS_AGE_FOR_DEL_ATTR');
2514: end if;

Line 2516: wf_engine.setitemattrnumber

2512: ,itemkey => l_item_key
2513: ,aname => 'HR_TRANS_AGE_FOR_DEL_ATTR');
2514: end if;
2515:
2516: wf_engine.setitemattrnumber
2517: (itemtype => l_item_type
2518: ,itemkey => l_item_key
2519: ,aname => 'HR_TRANS_AGE_FOR_DEL_ATTR'
2520: ,avalue => p_transaction_age);

Line 2528: wf_engine.additemattr

2524: if not item_attribute_exists
2525: (p_item_type => l_item_type
2526: ,p_item_key => l_item_key
2527: ,p_name => 'HR_TRAN_STAT_FOR_DEL_ATTR') then
2528: wf_engine.additemattr
2529: (itemtype => l_item_type
2530: ,itemkey => l_item_key
2531: ,aname => 'HR_TRAN_STAT_FOR_DEL_ATTR');
2532: end if;

Line 2534: wf_engine.setitemattrText

2530: ,itemkey => l_item_key
2531: ,aname => 'HR_TRAN_STAT_FOR_DEL_ATTR');
2532: end if;
2533:
2534: wf_engine.setitemattrText
2535: (itemtype => l_item_type
2536: ,itemkey => l_item_key
2537: ,aname => 'HR_TRAN_STAT_FOR_DEL_ATTR'
2538: ,avalue => p_transaction_status);

Line 2542: wf_engine.startprocess

2538: ,avalue => p_transaction_status);
2539:
2540:
2541: -- Start the WF runtime process
2542: wf_engine.startprocess
2543: (itemtype => l_item_type
2544: ,itemkey => l_item_key);
2545:
2546:

Line 2569: if (funcmode <> wf_engine.eng_run) then

2565: resultout in out nocopy varchar2)
2566: is
2567: begin
2568: -- Do nothing in cancel or timeout mode
2569: if (funcmode <> wf_engine.eng_run) then
2570: resultout := wf_engine.eng_null;
2571: return;
2572: end if;
2573:

Line 2570: resultout := wf_engine.eng_null;

2566: is
2567: begin
2568: -- Do nothing in cancel or timeout mode
2569: if (funcmode <> wf_engine.eng_run) then
2570: resultout := wf_engine.eng_null;
2571: return;
2572: end if;
2573:
2574: hr_transaction_api.Set_Process_Order_String(p_item_type => itemtype

Line 2578: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||

2574: hr_transaction_api.Set_Process_Order_String(p_item_type => itemtype
2575: ,p_item_key => itemkey
2576: ,p_actid => actid);
2577:
2578: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
2579: ':'||wf_engine.eng_null;
2580: exception
2581: when others then
2582: Wf_Core.Context('hr_workflow_service', 'Block', itemtype,

Line 2579: ':'||wf_engine.eng_null;

2575: ,p_item_key => itemkey
2576: ,p_actid => actid);
2577:
2578: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
2579: ':'||wf_engine.eng_null;
2580: exception
2581: when others then
2582: Wf_Core.Context('hr_workflow_service', 'Block', itemtype,
2583: itemkey, to_char(actid), funcmode);