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

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

90: ,p_orig_system_id => p_approval_routing_id
91: ,p_name => l_approval_routing_username
92: ,p_display_name => l_approval_routing_disp_name);
93: --
94: wf_engine.SetItemAttrNumber (itemtype => p_item_type,
95: itemkey => p_item_key,
96: aname => 'APPROVAL_ROUTING_PERSON_ID'||p_router_index,
97: avalue => p_approval_routing_id ) ;
98:

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

96: aname => 'APPROVAL_ROUTING_PERSON_ID'||p_router_index,
97: avalue => p_approval_routing_id ) ;
98:
99:
100: wf_engine.SetItemAttrText (itemtype => p_item_type,
101: itemkey => p_item_key,
102: aname => 'APPROVAL_ROUTING_USERNAME'||p_router_index,
103: avalue => l_approval_routing_username );
104: --

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

101: itemkey => p_item_key,
102: aname => 'APPROVAL_ROUTING_USERNAME'||p_router_index,
103: avalue => l_approval_routing_username );
104: --
105: wf_engine.SetItemAttrText (itemtype => p_item_type,
106: itemkey => p_item_key,
107: aname => 'APPROVAL_ROUTING_DISPLAY_NAME'
108: ||p_router_index,
109: avalue => l_approval_routing_disp_name );

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

132: --
133: --
134: -- Set item attributes for the URL
135: --
136: wf_engine.SetItemAttrText(itemtype => p_item_type,
137: itemkey => p_item_key,
138: aname => 'APPROVAL_URL'||p_url_index,
139: avalue => p_url);
140: --

Line 173: wf_engine.additemattr

169: fetch csr_wiav into l_dummy;
170: if csr_wiav%notfound then
171: --
172: -- item attribute does not exist so create it
173: wf_engine.additemattr
174: (itemtype => p_item_type
175: ,itemkey => p_item_key
176: ,aname => p_name);
177: end if;

Line 230: -- wf_engine.SetItemAttrText

226: ,p_name => 'APPROVAL_COMMENT');
227: --
228: -- Comment by vtakru for MEE process as approval comments set
229: -- during the mee processes were being reset
230: -- wf_engine.SetItemAttrText
231: -- ( itemtype => itemtype,
232: -- itemkey => itemkey,
233: -- aname => 'APPROVAL_COMMENT',
234: -- avalue => '' );

Line 242: --wf_engine.SetItemAttrText

238: (p_item_type => itemtype
239: ,p_item_key => itemkey
240: ,p_name => 'APPROVAL_COMMENT_COPY');
241: --
242: --wf_engine.SetItemAttrText
243: -- ( itemtype => itemtype,
244: -- itemkey => itemkey,
245: -- aname => 'APPROVAL_COMMENT_COPY',
246: -- avalue => '' );

Line 405: l_creator_person_id := wf_engine.GetItemAttrNumber

401: --
402:
403: -- Set the creator, forward to and forward from attributes
404: --
405: l_creator_person_id := wf_engine.GetItemAttrNumber
406: (itemtype => itemtype,
407: itemkey => itemkey,
408: aname => 'CREATOR_PERSON_ID' );
409: --

Line 410: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

406: (itemtype => itemtype,
407: itemkey => itemkey,
408: aname => 'CREATOR_PERSON_ID' );
409: --
410: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
411: itemkey => itemkey,
412: aname => 'APPROVAL_CREATOR_PERSON_ID',
413: avalue => l_creator_person_id );
414: --

Line 420: wf_engine.SetItemAttrText ( itemtype => itemtype,

416: p_orig_system_id => l_creator_person_id,
417: p_name => l_creator_username,
418: p_display_name => l_creator_disp_name );
419: --
420: wf_engine.SetItemAttrText ( itemtype => itemtype,
421: itemkey => itemkey,
422: aname => 'APPROVAL_CREATOR_USERNAME',
423: avalue => l_creator_username );
424: --

Line 425: wf_engine.SetItemAttrText ( itemtype => itemtype,

421: itemkey => itemkey,
422: aname => 'APPROVAL_CREATOR_USERNAME',
423: avalue => l_creator_username );
424: --
425: wf_engine.SetItemAttrText ( itemtype => itemtype,
426: itemkey => itemkey,
427: aname => 'APPROVAL_CREATOR_DISPLAY_NAME',
428: avalue => l_creator_disp_name );
429: --

Line 436: wf_engine.SetItemAttrText ( itemtype => itemtype,

432: --
433: --
434: /*
435:
436: wf_engine.SetItemAttrText ( itemtype => itemtype,
437: itemkey => itemkey,
438: aname => 'FORWARD_TO_USERNAME',
439: avalue => l_creator_username );
440: --

Line 441: wf_engine.SetItemAttrText ( itemtype => itemtype,

437: itemkey => itemkey,
438: aname => 'FORWARD_TO_USERNAME',
439: avalue => l_creator_username );
440: --
441: wf_engine.SetItemAttrText ( itemtype => itemtype,
442: itemkey => itemkey,
443: aname => 'FORWARD_TO_DISPLAY_NAME',
444: avalue => l_creator_disp_name );
445: --

Line 446: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

442: itemkey => itemkey,
443: aname => 'FORWARD_TO_DISPLAY_NAME',
444: avalue => l_creator_disp_name );
445: --
446: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
447: itemkey => itemkey,
448: aname => 'FORWARD_TO_PERSON_ID',
449: avalue => l_creator_person_id) ;
450: */

Line 454: wf_engine.SetItemAttrText(itemtype => itemtype ,

450: */
451: -- fix for bug#2677648
452: -- FORWARD_TO_DISPLAY_NAME
453: -- set the attribute value to null
454: wf_engine.SetItemAttrText(itemtype => itemtype ,
455: itemkey => itemkey,
456: aname => 'FORWARD_TO_DISPLAY_NAME',
457: avalue=>null);
458: -- FORWARD_TO_USERNAME

Line 460: wf_engine.SetItemAttrText(itemtype => itemtype ,

456: aname => 'FORWARD_TO_DISPLAY_NAME',
457: avalue=>null);
458: -- FORWARD_TO_USERNAME
459: -- set the attribute value to null
460: wf_engine.SetItemAttrText(itemtype => itemtype ,
461: itemkey => itemkey,
462: aname => 'FORWARD_TO_USERNAME',
463: avalue=>null);
464: -- FORWARD_TO_PERSON_ID

Line 466: wf_engine.SetItemAttrNumber(itemtype => itemtype ,

462: aname => 'FORWARD_TO_USERNAME',
463: avalue=>null);
464: -- FORWARD_TO_PERSON_ID
465: -- set the attribute value to null
466: wf_engine.SetItemAttrNumber(itemtype => itemtype ,
467: itemkey => itemkey,
468: aname => 'FORWARD_TO_PERSON_ID',
469: avalue=>null);
470:

Line 476: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

472: -- Set forward from = creator. If this creator has no
473: -- supervisor, we won't ever call get_next_approver, so we have to
474: -- set all the variables for 'forward from'.
475: --
476: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
477: itemkey => itemkey,
478: aname => 'FORWARD_FROM_PERSON_ID',
479: avalue => l_creator_person_id) ;
480: --

Line 481: wf_engine.SetItemAttrText( itemtype => itemtype,

477: itemkey => itemkey,
478: aname => 'FORWARD_FROM_PERSON_ID',
479: avalue => l_creator_person_id) ;
480: --
481: wf_engine.SetItemAttrText( itemtype => itemtype,
482: itemkey => itemkey,
483: aname => 'FORWARD_FROM_USERNAME',
484: avalue => l_creator_username);
485: --

Line 486: wf_engine.SetItemAttrText( itemtype => itemtype,

482: itemkey => itemkey,
483: aname => 'FORWARD_FROM_USERNAME',
484: avalue => l_creator_username);
485: --
486: wf_engine.SetItemAttrText( itemtype => itemtype,
487: itemkey => itemkey,
488: aname => 'FORWARD_FROM_DISPLAY_NAME',
489: avalue => l_creator_disp_name );
490:

Line 495: -- wf_engine.SetItemAttrText ( itemtype => itemtype,

491: -- commented rajayara
492: -- Set the APPROVAL_COMMENT_COPY and APPROVAL_COMMENT attribute
493: -- to NULL
494: --
495: -- wf_engine.SetItemAttrText ( itemtype => itemtype,
496: -- itemkey => itemkey,
497: -- aname => 'APPROVAL_COMMENT_COPY',
498: -- avalue => NULL);
499: --

Line 500: wf_engine.SetItemAttrText ( itemtype => itemtype,

496: -- itemkey => itemkey,
497: -- aname => 'APPROVAL_COMMENT_COPY',
498: -- avalue => NULL);
499: --
500: wf_engine.SetItemAttrText ( itemtype => itemtype,
501: itemkey => itemkey,
502: aname => 'APPROVAL_COMMENT',
503: avalue => NULL);
504: --

Line 535: wf_engine.GetItemAttrNumber(itemtype => itemtype,

531: --
532: if ( funmode = 'RUN' ) then
533: --
534: l_creator_person_id :=
535: wf_engine.GetItemAttrNumber(itemtype => itemtype,
536: itemkey => itemkey,
537: aname => 'CREATOR_PERSON_ID' );
538: -- -----------------------------------------------------------------------
539: -- expose the wf control variables to the custom package

Line 589: wf_engine.GetItemAttrNumber(itemtype => itemtype,

585: --
586: if ( funmode = 'RUN' ) then
587: --
588: l_creator_person_id :=
589: wf_engine.GetItemAttrNumber(itemtype => itemtype,
590: itemkey => itemkey,
591: aname => 'CREATOR_PERSON_ID' );
592: -- -----------------------------------------------------------------------
593: -- expose the wf control variables to the custom package

Line 645: wf_engine.GetItemAttrNumber(itemtype => itemtype,

641: --
642: if ( funmode = 'RUN' ) then
643: --
644: l_creator_person_id :=
645: wf_engine.GetItemAttrNumber(itemtype => itemtype,
646: itemkey => itemkey,
647: aname => 'CREATOR_PERSON_ID' );
648: -- -----------------------------------------------------------------------
649: -- expose the wf control variables to the custom package

Line 704: wf_engine.GetItemAttrNumber(itemtype => itemtype,

700: --
701: if ( funmode = 'RUN' ) then
702: --
703: l_creator_person_id :=
704: wf_engine.GetItemAttrNumber(itemtype => itemtype,
705: itemkey => itemkey,
706: aname => 'CREATOR_PERSON_ID' );
707: --
708: -- get the routing id

Line 759: wf_engine.GetItemAttrNumber(itemtype => itemtype,

755: --
756: if ( funmode = 'RUN' ) then
757: --
758: l_creator_person_id :=
759: wf_engine.GetItemAttrNumber(itemtype => itemtype,
760: itemkey => itemkey,
761: aname => 'CREATOR_PERSON_ID' );
762: -- -----------------------------------------------------------------------
763: -- expose the wf control variables to the custom package

Line 1065: ,p_parameter2 => wf_engine.getitemattrtext

1061: ,p_parameter1 => '800*PER_VACANCY_APPLICATION_F*' ||
1062: '800*PER_EMPK_VACANCIES_FP*' ||
1063: '800*PER_EMPK_VACANCIES_R*'||
1064: '800*PER_EMPK_VACANCY_DETAILS1_FP*PER_CURVAC_VACID_PK1*]'
1065: ,p_parameter2 => wf_engine.getitemattrtext
1066: (itemtype => itemtype,
1067: itemkey => itemkey,
1068: aname =>'PARAMETER1') );
1069: end if;

Line 1121: l_vacancy_id := to_number(wf_engine.getitemattrtext

1117: -- get the url
1118: --
1119: l_url := hr_approval_custom.get_URL7;
1120: if l_url is null then
1121: l_vacancy_id := to_number(wf_engine.getitemattrtext
1122: (itemtype => itemtype,
1123: itemkey => itemkey,
1124: aname =>'PARAMETER1'));
1125: open g_csr_vacancies(l_vacancy_id);

Line 1188: l_person_id := wf_engine.getitemattrnumber

1184: -- get the url
1185: --
1186: l_url := hr_approval_custom.get_URL8;
1187: if l_url is null then
1188: l_person_id := wf_engine.getitemattrnumber
1189: (itemtype => itemtype,
1190: itemkey => itemkey,
1191: aname =>'APPROVAL_ROUTING_PERSON_ID3');
1192: open g_csr_email_address(trunc(sysdate),l_person_id);

Line 1250: l_person_id := wf_engine.GetItemAttrNumber

1246: -- get the url
1247: --
1248: l_url := hr_approval_custom.get_URL9;
1249: if l_url is null then
1250: l_person_id := wf_engine.GetItemAttrNumber
1251: (itemtype => itemtype,
1252: itemkey => itemkey,
1253: aname => 'CREATOR_PERSON_ID' );
1254: open g_csr_pa(trunc(sysdate), l_person_id);

Line 1315: l_person_id := wf_engine.GetItemAttrNumber

1311: -- get the url
1312: --
1313: l_url := hr_approval_custom.get_URL10;
1314: if l_url is null then
1315: l_person_id := wf_engine.GetItemAttrNumber
1316: (itemtype => itemtype,
1317: itemkey => itemkey,
1318: aname => 'CREATOR_PERSON_ID' );
1319: open g_csr_email_address(trunc(sysdate),l_person_id);

Line 1376: l_event_id := to_number(wf_engine.getitemattrtext

1372: -- get the url
1373: --
1374: l_url := hr_approval_custom.get_URL11;
1375: if l_url is null then
1376: l_event_id := to_number(wf_engine.getitemattrtext
1377: (itemtype => itemtype
1378: ,itemkey => itemkey
1379: ,aname =>'PARAMETER1'));
1380:

Line 1446: l_person_id := wf_engine.GetItemAttrNumber

1442: -- get the url
1443: --
1444: l_url := hr_approval_custom.get_URL12;
1445: if l_url is null then
1446: l_person_id := wf_engine.GetItemAttrNumber
1447: (itemtype => itemtype
1448: ,itemkey => itemkey
1449: ,aname => 'CREATOR_PERSON_ID');
1450:

Line 1518: l_person_id := wf_engine.GetItemAttrNumber

1514: -- get the url
1515: --
1516: l_url := hr_approval_custom.get_URL13;
1517: if l_url is null then
1518: l_person_id := wf_engine.GetItemAttrNumber
1519: (itemtype => itemtype,
1520: itemkey => itemkey,
1521: aname => 'APPROVAL_ROUTING_PERSON_ID4');
1522: open g_csr_email_address(trunc(sysdate),l_person_id);

Line 1634: l_creator_person_id := wf_engine.GetItemAttrNumber

1630: --
1631: if ( funmode = 'RUN' ) then
1632: --
1633: --
1634: l_creator_person_id := wf_engine.GetItemAttrNumber
1635: (itemtype => itemtype
1636: ,itemkey => itemkey
1637: ,aname => 'CREATOR_PERSON_ID');
1638: --

Line 1639: l_forward_to_person_id := wf_engine.GetItemAttrNumber

1635: (itemtype => itemtype
1636: ,itemkey => itemkey
1637: ,aname => 'CREATOR_PERSON_ID');
1638: --
1639: l_forward_to_person_id := wf_engine.GetItemAttrNumber
1640: (itemtype => itemtype
1641: ,itemkey => itemkey
1642: ,aname => 'FORWARD_TO_PERSON_ID');
1643: -- -----------------------------------------------------------------------

Line 1692: nvl(wf_engine.GetItemAttrNumber

1688: --
1689: if ( funmode = 'RUN' ) then
1690: -- get the current forward from person
1691: l_current_forward_from_id :=
1692: nvl(wf_engine.GetItemAttrNumber
1693: (itemtype => itemtype
1694: ,itemkey => itemkey
1695: ,aname => 'FORWARD_FROM_PERSON_ID'),
1696: wf_engine.GetItemAttrNumber

Line 1696: wf_engine.GetItemAttrNumber

1692: nvl(wf_engine.GetItemAttrNumber
1693: (itemtype => itemtype
1694: ,itemkey => itemkey
1695: ,aname => 'FORWARD_FROM_PERSON_ID'),
1696: wf_engine.GetItemAttrNumber
1697: (itemtype => itemtype
1698: ,itemkey => itemkey
1699: ,aname => 'CREATOR_PERSON_ID'));
1700: -- get the current forward to person

Line 1702: nvl(wf_engine.GetItemAttrNumber

1698: ,itemkey => itemkey
1699: ,aname => 'CREATOR_PERSON_ID'));
1700: -- get the current forward to person
1701: l_current_forward_to_id :=
1702: nvl(wf_engine.GetItemAttrNumber
1703: (itemtype => itemtype
1704: ,itemkey => itemkey
1705: ,aname => 'FORWARD_TO_PERSON_ID'),
1706: wf_engine.GetItemAttrNumber

Line 1706: wf_engine.GetItemAttrNumber

1702: nvl(wf_engine.GetItemAttrNumber
1703: (itemtype => itemtype
1704: ,itemkey => itemkey
1705: ,aname => 'FORWARD_TO_PERSON_ID'),
1706: wf_engine.GetItemAttrNumber
1707: (itemtype => itemtype
1708: ,itemkey => itemkey
1709: ,aname => 'CREATOR_PERSON_ID'));
1710: -- -----------------------------------------------------------------------

Line 1735: wf_engine.SetItemAttrNumber

1731: ,p_orig_system_id => l_forward_to_person_id
1732: ,p_name => l_forward_to_username
1733: ,p_display_name => l_forward_to_disp_name);
1734: --
1735: wf_engine.SetItemAttrNumber
1736: (itemtype => itemtype
1737: ,itemkey => itemkey
1738: ,aname => 'FORWARD_TO_PERSON_ID'
1739: ,avalue => l_forward_to_person_id);

Line 1741: wf_engine.SetItemAttrText

1737: ,itemkey => itemkey
1738: ,aname => 'FORWARD_TO_PERSON_ID'
1739: ,avalue => l_forward_to_person_id);
1740: --
1741: wf_engine.SetItemAttrText
1742: (itemtype => itemtype
1743: ,itemkey => itemkey
1744: ,aname => 'FORWARD_TO_USERNAME'
1745: ,avalue => l_forward_to_username);

Line 1747: Wf_engine.SetItemAttrText

1743: ,itemkey => itemkey
1744: ,aname => 'FORWARD_TO_USERNAME'
1745: ,avalue => l_forward_to_username);
1746: --
1747: Wf_engine.SetItemAttrText
1748: (itemtype => itemtype
1749: ,itemkey => itemkey
1750: ,aname => 'FORWARD_TO_DISPLAY_NAME'
1751: ,avalue => l_forward_to_disp_name);

Line 1755: wf_engine.SetItemAttrNumber

1751: ,avalue => l_forward_to_disp_name);
1752: --
1753: -- set forward from to old forward to
1754: --
1755: wf_engine.SetItemAttrNumber
1756: (itemtype => itemtype
1757: ,itemkey => itemkey
1758: ,aname => 'FORWARD_FROM_PERSON_ID'
1759: ,avalue => l_current_forward_to_id);

Line 1770: wf_engine.SetItemAttrText

1766: ,p_orig_system_id => l_current_forward_to_id
1767: ,p_name => l_forward_from_username
1768: ,p_display_name => l_forward_from_disp_name);
1769: --
1770: wf_engine.SetItemAttrText
1771: (itemtype => itemtype
1772: ,itemkey => itemkey
1773: ,aname => 'FORWARD_FROM_USERNAME'
1774: ,avalue => l_forward_from_username);

Line 1776: wf_engine.SetItemAttrText

1772: ,itemkey => itemkey
1773: ,aname => 'FORWARD_FROM_USERNAME'
1774: ,avalue => l_forward_from_username);
1775: --
1776: wf_engine.SetItemAttrText
1777: (itemtype => itemtype
1778: ,itemkey => itemkey
1779: ,aname => 'FORWARD_FROM_DISPLAY_NAME'
1780: ,avalue => l_forward_from_disp_name);

Line 1809: wf_engine.SetItemAttrText

1805: begin
1806: --
1807: if ( funmode = 'RUN' ) then
1808: --
1809: wf_engine.SetItemAttrText
1810: (itemtype => itemtype,
1811: itemkey => itemkey,
1812: aname => 'APPROVAL_COMMENT_COPY',
1813: avalue => wf_engine.GetItemAttrText

Line 1813: avalue => wf_engine.GetItemAttrText

1809: wf_engine.SetItemAttrText
1810: (itemtype => itemtype,
1811: itemkey => itemkey,
1812: aname => 'APPROVAL_COMMENT_COPY',
1813: avalue => wf_engine.GetItemAttrText
1814: (itemtype => itemtype,
1815: itemkey => itemkey,
1816: aname => 'APPROVAL_COMMENT'));
1817: --

Line 1847: wf_engine.SetItemAttrText

1843: --
1844: --
1845: -- Set the current_person_id to the creator_person_id
1846: --
1847: wf_engine.SetItemAttrText
1848: (itemtype => itemtype,
1849: itemkey => itemkey,
1850: aname => 'CURRENT_PERSON_ID',
1851: avalue => wf_engine.GetItemAttrNumber

Line 1851: avalue => wf_engine.GetItemAttrNumber

1847: wf_engine.SetItemAttrText
1848: (itemtype => itemtype,
1849: itemkey => itemkey,
1850: aname => 'CURRENT_PERSON_ID',
1851: avalue => wf_engine.GetItemAttrNumber
1852: (itemtype => itemtype,
1853: itemkey => itemkey,
1854: aname => 'CREATOR_PERSON_ID' ));
1855: --

Line 1922: (wf_engine.getitemattrnumber

1918: (p_item_type => itemtype
1919: ,p_item_key => itemkey
1920: ,p_service_name => 'SUPERVISOR'
1921: ,p_service_person_id => hr_offer_custom.set_supervisor_id
1922: (wf_engine.getitemattrnumber
1923: (itemtype
1924: ,itemkey
1925: ,'CURRENT_PERSON_ID')));
1926:

Line 1948: wf_engine.SetItemAttrText (itemtype => itemtype,

1944: -- workflow is RUNing this procedure
1945: --
1946: -- Set the current_person_id to the creator_person_id
1947: --
1948: wf_engine.SetItemAttrText (itemtype => itemtype,
1949: itemkey => itemkey,
1950: aname => 'FORWARD_TO_DISPLAY_NAME',
1951: avalue => wf_engine.getitemattrtext
1952: (itemtype => itemtype,

Line 1951: avalue => wf_engine.getitemattrtext

1947: --
1948: wf_engine.SetItemAttrText (itemtype => itemtype,
1949: itemkey => itemkey,
1950: aname => 'FORWARD_TO_DISPLAY_NAME',
1951: avalue => wf_engine.getitemattrtext
1952: (itemtype => itemtype,
1953: itemkey => itemkey,
1954: aname =>'RECRUITER_DISPLAY_NAME') );
1955:

Line 1956: wf_engine.SetItemAttrText (itemtype => itemtype,

1952: (itemtype => itemtype,
1953: itemkey => itemkey,
1954: aname =>'RECRUITER_DISPLAY_NAME') );
1955:
1956: wf_engine.SetItemAttrText (itemtype => itemtype,
1957: itemkey => itemkey,
1958: aname => 'FORWARD_TO_USERNAME',
1959: avalue => wf_engine.getitemattrtext
1960: (itemtype => itemtype,

Line 1959: avalue => wf_engine.getitemattrtext

1955:
1956: wf_engine.SetItemAttrText (itemtype => itemtype,
1957: itemkey => itemkey,
1958: aname => 'FORWARD_TO_USERNAME',
1959: avalue => wf_engine.getitemattrtext
1960: (itemtype => itemtype,
1961: itemkey => itemkey,
1962: aname =>'RECRUITER_USERNAME') );
1963: