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

Line 45: contextUser := wf_engine.getitemattrtext(p_item_type,p_item_key,'HR_CONTEXT_USER_ATTR',true);

41:
42: -- check if we have the context set by the Approver Notification
43: -- call back function; if exists
44: -- HR_CONTEXT_USER_ATTR
45: contextUser := wf_engine.getitemattrtext(p_item_type,p_item_key,'HR_CONTEXT_USER_ATTR',true);
46: contextProxyUser := wf_engine.getitemattrtext(p_item_type,p_item_key,'HR_CONTEXT_PROXY_ATTR',true);
47:
48: if g_debug then
49: hr_utility.set_location('contextUser value :'|| contextUser,6);

Line 46: contextProxyUser := wf_engine.getitemattrtext(p_item_type,p_item_key,'HR_CONTEXT_PROXY_ATTR',true);

42: -- check if we have the context set by the Approver Notification
43: -- call back function; if exists
44: -- HR_CONTEXT_USER_ATTR
45: contextUser := wf_engine.getitemattrtext(p_item_type,p_item_key,'HR_CONTEXT_USER_ATTR',true);
46: contextProxyUser := wf_engine.getitemattrtext(p_item_type,p_item_key,'HR_CONTEXT_PROXY_ATTR',true);
47:
48: if g_debug then
49: hr_utility.set_location('contextUser value :'|| contextUser,6);
50: hr_utility.set_location('contextProxyUser value :'|| contextProxyUser,6);

Line 223: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

219: ,p_item_key => p_item_key
220: ,p_name => 'HR_AME_APP_ID_ATTR') then
221: -- get the attribute value
222: hr_utility.trace('In : (if hr_workflow_utility.item_attribute_exists) '|| l_proc);
223: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
224: itemkey => p_item_key,
225: aname => 'HR_AME_APP_ID_ATTR');
226:
227: else

Line 240: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

236: ,p_item_key => p_item_key
237: ,p_name => 'TRANSACTION_ID') then
238: -- get the attribute value
239: hr_utility.trace('In : (if hr_workflow_utility.item_attribute_exists) '|| l_proc);
240: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
241: itemkey => p_item_key,
242: aname => 'TRANSACTION_ID');
243: else
244: hr_utility.trace('In : else of (if hr_workflow_utility.item_attribute_exists) '|| l_proc);

Line 255: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,

251: ,p_item_key => p_item_key
252: ,p_name => 'HR_AME_TRAN_TYPE_ATTR') then
253: -- get the attribute value
254: hr_utility.trace('In : (if hr_workflow_utility.item_attribute_exists) '|| l_proc);
255: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
256: itemkey => p_item_key,
257: aname => 'HR_AME_TRAN_TYPE_ATTR');
258: else
259: hr_utility.trace('In : else of (if hr_workflow_utility.item_attribute_exists) '|| l_proc);

Line 267: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,

263:
264:
265:
266:
267: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
268: itemkey => p_item_key,
269: aname => 'HR_AME_TRAN_TYPE_ATTR');
270:
271: if(c_transaction_type is not null) then

Line 283: c_creator_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,

279: transactionTypeIn =>c_transaction_type,
280: approversOut=>c_all_approvers);
281:
282: --ns begin
283: c_creator_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,
284: itemkey => p_item_key,
285: aname => 'CREATOR_PERSON_USERNAME');
286: Begin
287: c_return_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,

Line 287: c_return_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,

283: c_creator_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,
284: itemkey => p_item_key,
285: aname => 'CREATOR_PERSON_USERNAME');
286: Begin
287: c_return_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,
288: itemkey => p_item_key,
289: aname => 'RETURN_TO_USERNAME');
290: Exception
291: WHEN others then

Line 379: wf_engine.SetItemAttrText(itemtype => p_item_type ,

375: (p_item_type => p_item_type
376: ,p_item_key => p_item_key
377: ,p_name => 'FORWARD_FROM_DISPLAY_NAME') then
378: -- set the attribute value to null
379: wf_engine.SetItemAttrText(itemtype => p_item_type ,
380: itemkey => p_item_key,
381: aname => 'FORWARD_FROM_DISPLAY_NAME',
382: avalue=>null);
383: end if;

Line 390: wf_engine.SetItemAttrText(itemtype => p_item_type ,

386: (p_item_type => p_item_type
387: ,p_item_key => p_item_key
388: ,p_name => 'FORWARD_FROM_USERNAME') then
389: -- set the attribute value to null
390: wf_engine.SetItemAttrText(itemtype => p_item_type ,
391: itemkey => p_item_key,
392: aname => 'FORWARD_FROM_USERNAME',
393: avalue=>null);
394: end if;

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

397: (p_item_type => p_item_type
398: ,p_item_key => p_item_key
399: ,p_name => 'FORWARD_FROM_PERSON_ID') then
400: -- set the attribute value to null
401: wf_engine.SetItemAttrNumber(itemtype => p_item_type ,
402: itemkey => p_item_key,
403: aname => 'FORWARD_FROM_PERSON_ID',
404: avalue=>null);
405: end if;

Line 412: wf_engine.SetItemAttrText(itemtype => p_item_type ,

408: (p_item_type => p_item_type
409: ,p_item_key => p_item_key
410: ,p_name => 'FORWARD_TO_DISPLAY_NAME') then
411: -- set the attribute value to null
412: wf_engine.SetItemAttrText(itemtype => p_item_type ,
413: itemkey => p_item_key,
414: aname => 'FORWARD_TO_DISPLAY_NAME',
415: avalue=>null);
416: end if;

Line 423: wf_engine.SetItemAttrText(itemtype => p_item_type ,

419: (p_item_type => p_item_type
420: ,p_item_key => p_item_key
421: ,p_name => 'FORWARD_TO_USERNAME') then
422: -- set the attribute value to null
423: wf_engine.SetItemAttrText(itemtype => p_item_type ,
424: itemkey => p_item_key,
425: aname => 'FORWARD_TO_USERNAME',
426: avalue=>null);
427: end if;

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

430: (p_item_type => p_item_type
431: ,p_item_key => p_item_key
432: ,p_name => 'FORWARD_TO_PERSON_ID') then
433: -- set the attribute value to null
434: wf_engine.SetItemAttrNumber(itemtype => p_item_type ,
435: itemkey => p_item_key,
436: aname => 'FORWARD_TO_PERSON_ID',
437: avalue=>null);
438: end if;

Line 447: l_approvalProcessVersion := wf_engine.GetItemAttrText(

443: * CAUTION: IF this procedure is invoked from somewhere else (apart from RFC) then this needs
444: * to be checked for that condition too.
445: */
446: Begin
447: l_approvalProcessVersion := wf_engine.GetItemAttrText(
448: itemtype => p_item_Type,
449: itemkey => p_item_Key,
450: aname => 'HR_APPROVAL_PRC_VERSION');
451: Exception

Line 459: wf_engine.GetItemAttrText(

455:
456: End;
457:
458: IF ( NVL(l_approvalProcessversion,'X') <> 'V5' OR
459: wf_engine.GetItemAttrText(
460: itemtype => p_item_Type, itemkey => p_item_Key,
461: aname => 'HR_AME_TRAN_TYPE_ATTR') IS NOT NULL) THEN
462: -- CURRENT_APPROVER_INDEX
463: hr_utility.trace('In ( IF ( NVL(l_approvalProcessversion,X) <> V5 OR

Line 464: wf_engine.GetItemAttrText(..,..,..,)IS NOT NULL '|| l_proc);

460: itemtype => p_item_Type, itemkey => p_item_Key,
461: aname => 'HR_AME_TRAN_TYPE_ATTR') IS NOT NULL) THEN
462: -- CURRENT_APPROVER_INDEX
463: hr_utility.trace('In ( IF ( NVL(l_approvalProcessversion,X) <> V5 OR
464: wf_engine.GetItemAttrText(..,..,..,)IS NOT NULL '|| l_proc);
465: if hr_workflow_utility.item_attribute_exists
466: (p_item_type => p_item_type
467: ,p_item_key => p_item_key
468: ,p_name => 'CURRENT_APPROVER_INDEX') then

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

466: (p_item_type => p_item_type
467: ,p_item_key => p_item_key
468: ,p_name => 'CURRENT_APPROVER_INDEX') then
469: -- set the attribute value to null
470: wf_engine.SetItemAttrNumber(itemtype => p_item_type ,
471: itemkey => p_item_key,
472: aname => 'CURRENT_APPROVER_INDEX',
473: avalue=>null);
474: end if;

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

478: (p_item_type => p_item_type
479: ,p_item_key => p_item_key
480: ,p_name => 'LAST_DEFAULT_APPROVER') then
481: -- set the attribute value to null
482: wf_engine.SetItemAttrNumber(itemtype => p_item_type ,
483: itemkey => p_item_key,
484: aname => 'LAST_DEFAULT_APPROVER',
485: avalue=>null);
486: end if;

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

491: (p_item_type => p_item_type
492: ,p_item_key => p_item_key
493: ,p_name => 'CURRENT_DEF_APPR_INDEX') then
494: -- set the attribute value to null
495: wf_engine.SetItemAttrNumber(itemtype => p_item_type ,
496: itemkey => p_item_key,
497: aname => 'CURRENT_DEF_APPR_INDEX',
498: avalue=>null);
499: end if;

Line 540: l_effective_date := wf_engine.getitemattrtext

536: open csr_item_type_key;
537: fetch csr_item_type_key into l_item_type,l_item_key;
538: close csr_item_type_key;
539: if l_item_type is not null and l_item_key is not null then
540: l_effective_date := wf_engine.getitemattrtext
541: (itemtype => l_item_type
542: ,itemkey => l_item_key
543: ,aname => 'P_EFFECTIVE_DATE');
544: else

Line 577: wf_engine.SetItemAttrText(itemtype => p_item_type,

573: hr_utility.set_location('Entering: '|| l_proc,5);
574: If (p_item_type is not null and
575: p_item_key is not null )
576: then
577: wf_engine.SetItemAttrText(itemtype => p_item_type,
578: itemkey => p_item_key,
579: aname => 'TRAN_SUBMIT',
580: avalue => p_status);
581: End If;

Line 790: return(wf_engine.getitemattrnumber

786: l_transaction_id number;
787: begin
788: hr_utility.set_location('Entering: '|| l_proc,5);
789: hr_utility.set_location('Leaving: '|| l_proc,10);
790: return(wf_engine.getitemattrnumber
791: (itemtype => p_item_type
792: ,itemkey => p_item_key
793: ,aname => 'TRANSACTION_ID'));
794: exception

Line 860: ln_selected_person_id := wf_engine.GetItemAttrNumber(p_item_type,

856: end if;
857:
858: If p_selected_person_id is null then
859: If p_item_type is not null and p_item_key is not null then
860: ln_selected_person_id := wf_engine.GetItemAttrNumber(p_item_type,
861: p_item_key,
862: 'CURRENT_PERSON_ID');
863: end if;
864: else

Line 870: lv_process_name := wf_engine.GetItemAttrText(p_item_type

866: end if;
867:
868: If p_process_name is null then
869: If p_item_type is not null and p_item_key is not null then
870: lv_process_name := wf_engine.GetItemAttrText(p_item_type
871: ,p_item_key
872: ,'PROCESS_NAME');
873: end if;
874: else

Line 880: lv_status := wf_engine.GetItemAttrText(p_item_type

876: end if;
877:
878: If p_status is null then
879: If p_item_type is not null and p_item_key is not null then
880: lv_status := wf_engine.GetItemAttrText(p_item_type
881: ,p_item_key
882: ,'TRAN_SUBMIT');
883: end if;
884: else

Line 890: lv_section_display_name := wf_engine.GetItemAttrText( p_item_type

886: end if;
887:
888: If p_section_display_name is null then
889: If p_item_type is not null and p_item_key is not null then
890: lv_section_display_name := wf_engine.GetItemAttrText( p_item_type
891: ,p_item_key
892: ,'HR_SECTION_DISPLAY_NAME');
893: end if;
894: else

Line 900: ln_assignment_id := wf_engine.GetItemAttrText(p_item_type

896: end if;
897:
898: If p_assignment_id is null then
899: If p_item_type is not null and p_item_key is not null then
900: ln_assignment_id := wf_engine.GetItemAttrText(p_item_type
901: ,p_item_key
902: ,'CURRENT_ASSIGNMENT_ID');
903: end if;
904: else

Line 910: ld_trans_effec_date := wf_engine.GetItemAttrText(p_item_type

906: end if;
907:
908: If p_transaction_effective_date is null then
909: If p_item_type is not null and p_item_key is not null then
910: ld_trans_effec_date := wf_engine.GetItemAttrText(p_item_type
911: ,p_item_key
912: ,'CURRENT_EFFECTIVE_DATE');
913: end if;
914: else

Line 1024: wf_engine.additemattr

1020: end if;
1021: else
1022: hr_utility.trace('In else of (if hr_workflow_utility.item_attribute_exists) '|| l_proc);
1023: -- the TRANSACTION_ID does not exist so create it
1024: wf_engine.additemattr
1025: (itemtype => itemtype
1026: ,itemkey => itemkey
1027: ,aname => 'TRANSACTION_ID');
1028: end if;

Line 1035: wf_engine.additemattr

1031: (p_item_type => itemtype
1032: ,p_item_key => itemkey
1033: ,p_name => 'TRANSACTION_PRIVILEGE') then
1034: -- the TRANSACTION_PRIVILEGE does not exist so create it
1035: wf_engine.additemattr
1036: (itemtype => itemtype
1037: ,itemkey => itemkey
1038: ,aname => 'TRANSACTION_PRIVILEGE');
1039: end if;

Line 1042: wf_engine.getitemattrtext

1038: ,aname => 'TRANSACTION_PRIVILEGE');
1039: end if;
1040: -- get the TRANSACTION_PRIVILEGE
1041: l_transaction_privilege :=
1042: wf_engine.getitemattrtext
1043: (itemtype => itemtype
1044: ,itemkey => itemkey
1045: ,aname => 'TRANSACTION_PRIVILEGE');
1046: -- check to see if the TRANSACTION_PRIVILEGE is null

Line 1050: wf_engine.setitemattrtext

1046: -- check to see if the TRANSACTION_PRIVILEGE is null
1047: if l_transaction_privilege is null then
1048: -- default the TRANSACTION_PRIVILEGE to PRIVATE
1049: l_transaction_privilege := 'PRIVATE';
1050: wf_engine.setitemattrtext
1051: (itemtype => itemtype
1052: ,itemkey => itemkey
1053: ,aname => 'TRANSACTION_PRIVILEGE'
1054: ,avalue => l_transaction_privilege);

Line 1091: wf_engine.setitemattrnumber

1087: ,p_effective_date_option=>p_effective_date_option
1088: ,p_api_addtnl_info=>p_api_addtnl_info);
1089:
1090: -- set the TRANSACTION_ID
1091: wf_engine.setitemattrnumber
1092: (itemtype => itemtype
1093: ,itemkey => itemkey
1094: ,aname => 'TRANSACTION_ID'
1095: ,avalue => l_transaction_id);

Line 1788: wf_engine.setitemattrtext

1784: l_error_text := hr_utility.get_message;
1785: if l_error_text is null then
1786: l_error_text := fnd_message.get;
1787: end if;
1788: wf_engine.setitemattrtext
1789: (itemtype => itemtype
1790: ,itemkey => itemkey
1791: ,aname => 'ERROR_MESSAGE_TEXT'
1792: ,avalue => nvl(l_error_text,l_sqlerrm));

Line 1794: wf_engine.setitemattrtext

1790: ,itemkey => itemkey
1791: ,aname => 'ERROR_MESSAGE_TEXT'
1792: ,avalue => nvl(l_error_text,l_sqlerrm));
1793:
1794: wf_engine.setitemattrtext
1795: (itemtype => itemtype
1796: ,itemkey => itemkey
1797: ,aname => 'TRAN_SUBMIT'
1798: ,avalue => 'E');

Line 1808: wf_engine.setitemattrtext

1804: l_error_text := hr_utility.get_message;
1805: if l_error_text is null then
1806: l_error_text := fnd_message.get;
1807: end if;
1808: wf_engine.setitemattrtext
1809: (itemtype => itemtype
1810: ,itemkey => itemkey
1811: ,aname => 'ERROR_MESSAGE_TEXT'
1812: ,avalue => nvl(l_error_text,l_sqlerrm));

Line 1814: wf_engine.setitemattrtext

1810: ,itemkey => itemkey
1811: ,aname => 'ERROR_MESSAGE_TEXT'
1812: ,avalue => nvl(l_error_text,l_sqlerrm));
1813:
1814: wf_engine.setitemattrtext
1815: (itemtype => itemtype
1816: ,itemkey => itemkey
1817: ,aname => 'TRAN_SUBMIT'
1818: ,avalue => 'E');

Line 1845: wf_engine.setitemattrtext

1841: if l_error_text is null then
1842: l_error_text := fnd_message.get;
1843: end if;
1844: -- 1903606
1845: wf_engine.setitemattrtext
1846: (itemtype => itemtype
1847: ,itemkey => itemkey
1848: ,aname => 'TRAN_SUBMIT'
1849: ,avalue => 'E');

Line 1852: wf_engine.setitemattrtext

1848: ,aname => 'TRAN_SUBMIT'
1849: ,avalue => 'E');
1850:
1851: -- set the ERROR_MESSAGE_TEXT
1852: wf_engine.setitemattrtext
1853: (itemtype => itemtype
1854: ,itemkey => itemkey
1855: ,aname => 'ERROR_MESSAGE_TEXT'
1856: ,avalue => nvl(l_error_text, l_sqlerrm));

Line 1872: p_data := nvl(wf_engine.GetItemAttrText

1868: hr_utility.set_location('EXCEPTION: '|| l_proc,565);
1869:
1870: if(itemkey IS NOT NULL) THEN
1871: hr_utility.set_location('PDATA11 : ' || p_data, 20);
1872: p_data := nvl(wf_engine.GetItemAttrText
1873: (itemtype => itemtype
1874: ,itemkey => itemkey
1875: ,aname => 'ERROR_STACK'),' ') || p_data;
1876: hr_utility.set_location('PDATA21 : ' || p_data, 20);

Line 1886: wf_engine.setitemattrtext

1882:
1883: if(itemkey IS NOT NULL) THEN
1884: hr_utility.set_location('PDATA25 : ' || p_data, 20);
1885: hr_utility.set_location('ITEM_KEY : ' || itemkey, 20);
1886: wf_engine.setitemattrtext
1887: (itemtype => itemtype
1888: ,itemkey => itemkey
1889: ,aname => 'ERROR_STACK'
1890: ,avalue => p_data);

Line 1895: wf_engine.setitemattrtext

1891: hr_utility.set_location('PDATA25 : ' || p_data, 20);
1892: end if;
1893:
1894: -- 1903606
1895: wf_engine.setitemattrtext
1896: (itemtype => itemtype
1897: ,itemkey => itemkey
1898: ,aname => 'TRAN_SUBMIT'
1899: ,avalue => 'E');

Line 1901: wf_engine.setitemattrtext

1897: ,itemkey => itemkey
1898: ,aname => 'TRAN_SUBMIT'
1899: ,avalue => 'E');
1900: -- set the ERROR_MESSAGE_TEXT
1901: wf_engine.setitemattrtext
1902: (itemtype => itemtype
1903: ,itemkey => itemkey
1904: ,aname => 'ERROR_MESSAGE_TEXT'
1905: ,avalue => l_sqlerrm);

Line 1973: --wf_engine.completeactivity

1969: (p_item_type => p_item_type
1970: ,p_item_key => p_item_key
1971: ,p_actid => p_actid
1972: ,p_result => 'SUCCESS');
1973: --wf_engine.completeactivity
1974: -- (itemtype => p_item_type
1975: -- ,itemkey => p_item_key
1976: -- ,activity => '#'||p_actid
1977: -- ,result => 'SUCCESS');

Line 2237: if ( wf_engine.GetItemAttrText(p_item_type ,p_item_key ,'HR_APPROVAL_PRC_VERSION') = 'V5' ) then

2233:
2234: IF ln_transaction_id IS NOT NULL THEN
2235: hr_utility.trace('In ( I IF ln_transaction_id IS NOT NULL ) '|| l_proc);
2236: Begin
2237: if ( wf_engine.GetItemAttrText(p_item_type ,p_item_key ,'HR_APPROVAL_PRC_VERSION') = 'V5' ) then
2238: lv_status := hr_api.g_varchar2; -- so that the original value is picked from txn table;
2239: end if;
2240: Exception
2241: when Others then -- wf attribute not found