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.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 2172: l_transaction_status_to_delete := wf_engine.getitemattrText

2168: --
2169: -- Get the transaction status value of items to be deleted
2170: -- This is normally passed through the Concurrent program
2171: -- and populated into item attribute HR_TRANS_STATUS_FOR_DEL_ATTR
2172: l_transaction_status_to_delete := wf_engine.getitemattrText
2173: (itemtype => itemtype
2174: ,itemkey => itemkey
2175: ,aname => 'HR_TRAN_STAT_FOR_DEL_ATTR');
2176: -- Get the transaction age value of items to be deleted

Line 2179: l_transaction_age:= wf_engine.getitemattrNumber

2175: ,aname => 'HR_TRAN_STAT_FOR_DEL_ATTR');
2176: -- Get the transaction age value of items to be deleted
2177: -- This is normally passed through the Concurrent program
2178: -- and populated into item attribute 'HR_TRANS_AGE_FOR_DEL_ATTR'
2179: l_transaction_age:= wf_engine.getitemattrNumber
2180: (itemtype => itemtype
2181: ,itemkey => itemkey
2182: ,aname => 'HR_TRANS_AGE_FOR_DEL_ATTR');
2183:

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

2240: -- Fix for bug 6501341
2241: BEGIN
2242: for rec in defunct_wfsfl_ids loop
2243: BEGIN -- Block to 'abort' the WF process
2244: wf_engine.abortprocess(itemtype => 'HRSFL'
2245: ,itemkey => rec.item_key
2246: ,result => 'eng_force');
2247: EXCEPTION
2248: when others then

Line 2284: wf_engine.abortprocess(itemtype => itemtype

2280: if(l_delete_transaction) then -- delete transaction which explicitly
2281: -- identified for delete.
2282: -- First abort the WF process for this transaction record.
2283: BEGIN -- Block to 'abort' the WF process
2284: wf_engine.abortprocess(itemtype => itemtype
2285: ,itemkey => rec.item_key
2286: ,result => 'eng_force');
2287: EXCEPTION
2288: when others then

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

2312:
2313: if rec.item_key IS NOT NULL then
2314: -- Get the transaction status from the WF item attribute TRAN_SUBMIT
2315: -- need to remove this call once the SSHR V4.1 functionality is implemented.
2316: l_transaction_status :=wf_engine.GetItemAttrText(itemtype => itemtype
2317: ,itemkey => rec.item_key
2318: ,aname => 'TRAN_SUBMIT');
2319:
2320: -- reset the l_delete_transaction status false by default

Line 2337: wf_engine.abortprocess(itemtype => itemtype

2333: if(l_delete_transaction) then -- delete transaction which explicitly
2334: -- identified for delete.
2335: -- First abort the WF process for this transaction record.
2336: BEGIN -- Block to 'abort' the WF process
2337: wf_engine.abortprocess(itemtype => itemtype
2338: ,itemkey => rec.item_key
2339: ,result => 'eng_force');
2340: exception
2341: when others then

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

2369: -- start bug 5990955
2370:
2371: for rec in csr_wfdfctitmsapprs(l_transaction_age) loop
2372: BEGIN
2373: wf_engine.abortprocess(itemtype => rec.item_type
2374: ,itemkey => rec.item_key
2375: ,result => 'eng_force');
2376:
2377: hr_transaction_api.rollback_transaction(p_transaction_id => rec.transaction_id );

Line 2456: wf_engine.CreateProcess

2452:
2453:
2454:
2455: -- Create the Workflow Process
2456: wf_engine.CreateProcess
2457: (itemtype => l_item_type
2458: ,itemkey => l_item_key
2459: ,process => l_process_name);
2460: -- set the user key

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

2457: (itemtype => l_item_type
2458: ,itemkey => l_item_key
2459: ,process => l_process_name);
2460: -- set the user key
2461: wf_engine.SetItemUserKey(itemtype=> l_item_type,
2462: itemkey => l_item_key,
2463: userkey => l_item_type);
2464:
2465: -- add run time attribute for storing the transaction age.

Line 2471: wf_engine.additemattr

2467: if not item_attribute_exists
2468: (p_item_type => l_item_type
2469: ,p_item_key => l_item_key
2470: ,p_name => 'HR_TRANS_AGE_FOR_DEL_ATTR') then
2471: wf_engine.additemattr
2472: (itemtype => l_item_type
2473: ,itemkey => l_item_key
2474: ,aname => 'HR_TRANS_AGE_FOR_DEL_ATTR');
2475: end if;

Line 2477: wf_engine.setitemattrnumber

2473: ,itemkey => l_item_key
2474: ,aname => 'HR_TRANS_AGE_FOR_DEL_ATTR');
2475: end if;
2476:
2477: wf_engine.setitemattrnumber
2478: (itemtype => l_item_type
2479: ,itemkey => l_item_key
2480: ,aname => 'HR_TRANS_AGE_FOR_DEL_ATTR'
2481: ,avalue => p_transaction_age);

Line 2489: wf_engine.additemattr

2485: if not item_attribute_exists
2486: (p_item_type => l_item_type
2487: ,p_item_key => l_item_key
2488: ,p_name => 'HR_TRAN_STAT_FOR_DEL_ATTR') then
2489: wf_engine.additemattr
2490: (itemtype => l_item_type
2491: ,itemkey => l_item_key
2492: ,aname => 'HR_TRAN_STAT_FOR_DEL_ATTR');
2493: end if;

Line 2495: wf_engine.setitemattrText

2491: ,itemkey => l_item_key
2492: ,aname => 'HR_TRAN_STAT_FOR_DEL_ATTR');
2493: end if;
2494:
2495: wf_engine.setitemattrText
2496: (itemtype => l_item_type
2497: ,itemkey => l_item_key
2498: ,aname => 'HR_TRAN_STAT_FOR_DEL_ATTR'
2499: ,avalue => p_transaction_status);

Line 2503: wf_engine.startprocess

2499: ,avalue => p_transaction_status);
2500:
2501:
2502: -- Start the WF runtime process
2503: wf_engine.startprocess
2504: (itemtype => l_item_type
2505: ,itemkey => l_item_key);
2506:
2507:

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

2526: resultout in out nocopy varchar2)
2527: is
2528: begin
2529: -- Do nothing in cancel or timeout mode
2530: if (funcmode <> wf_engine.eng_run) then
2531: resultout := wf_engine.eng_null;
2532: return;
2533: end if;
2534:

Line 2531: resultout := wf_engine.eng_null;

2527: is
2528: begin
2529: -- Do nothing in cancel or timeout mode
2530: if (funcmode <> wf_engine.eng_run) then
2531: resultout := wf_engine.eng_null;
2532: return;
2533: end if;
2534:
2535: hr_transaction_api.Set_Process_Order_String(p_item_type => itemtype

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

2535: hr_transaction_api.Set_Process_Order_String(p_item_type => itemtype
2536: ,p_item_key => itemkey
2537: ,p_actid => actid);
2538:
2539: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
2540: ':'||wf_engine.eng_null;
2541: exception
2542: when others then
2543: Wf_Core.Context('hr_workflow_service', 'Block', itemtype,

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

2536: ,p_item_key => itemkey
2537: ,p_actid => actid);
2538:
2539: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
2540: ':'||wf_engine.eng_null;
2541: exception
2542: when others then
2543: Wf_Core.Context('hr_workflow_service', 'Block', itemtype,
2544: itemkey, to_char(actid), funcmode);