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.HXC_FIND_NOTIFY_APRS_PKG dependencies on WF_ENGINE

Line 481: wf_engine.AbortProcess(itemkey => l_item_key,

477: --Updating the WF_NOTIFICATION_ATTRIBUTES, incase of archival.
478: IF (p_archived = 'Yes') THEN
479: hxc_archive_restore_utils.upd_wf_notif_attributes(p_item_type => 'HXCEMP',p_item_key => l_item_key);
480: END IF;
481: wf_engine.AbortProcess(itemkey => l_item_key,
482: itemtype => 'HXCEMP');
483: EXCEPTION
484: When others then
485: null;

Line 494: wf_engine.AbortProcess(itemkey => l_item_key,

490: --Updating the WF_NOTIFICATION_ATTRIBUTES, incase of archival.
491: IF (p_archived = 'Yes') THEN
492: hxc_archive_restore_utils.upd_wf_notif_attributes(p_item_type => 'HXCEMP',p_item_key => l_item_key);
493: END IF;
494: wf_engine.AbortProcess(itemkey => l_item_key,
495: itemtype => 'HXCEMP');
496: END IF;
497:
498: Exception

Line 578: l_resource_id := wf_engine.GetItemAttrNumber(

574: BEGIN
575: --cancel all the notifications for all the other application periods
576: --associated with the submitted timecard
577:
578: l_resource_id := wf_engine.GetItemAttrNumber(
579: itemtype => p_itemtype,
580: itemkey => p_itemkey,
581: aname => 'RESOURCE_ID');
582:

Line 583: l_tc_start := wf_engine.GetItemAttrDate(

579: itemtype => p_itemtype,
580: itemkey => p_itemkey,
581: aname => 'RESOURCE_ID');
582:
583: l_tc_start := wf_engine.GetItemAttrDate(
584: itemtype => p_itemtype,
585: itemkey => p_itemkey,
586: aname => 'TC_START');
587:

Line 588: l_tc_stop := wf_engine.GetItemAttrDate(

584: itemtype => p_itemtype,
585: itemkey => p_itemkey,
586: aname => 'TC_START');
587:
588: l_tc_stop := wf_engine.GetItemAttrDate(
589: itemtype => p_itemtype,
590: itemkey => p_itemkey,
591: aname => 'TC_STOP');
592:

Line 816: l_tc_bb_id := wf_engine.GetItemAttrNumber(

812: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');
813: g_trace := '10';
814:
815: if p_funcmode = 'RUN' then
816: l_tc_bb_id := wf_engine.GetItemAttrNumber(
817: itemtype => p_itemtype,
818: itemkey => p_itemkey,
819: aname => 'TC_BLD_BLK_ID');
820:

Line 821: l_tc_bb_ovn := wf_engine.GetItemAttrNumber(

817: itemtype => p_itemtype,
818: itemkey => p_itemkey,
819: aname => 'TC_BLD_BLK_ID');
820:
821: l_tc_bb_ovn := wf_engine.GetItemAttrNumber(
822: itemtype => p_itemtype,
823: itemkey => p_itemkey,
824: aname => 'TC_BLD_BLK_OVN');
825:

Line 826: l_ap_bb_id := wf_engine.GetItemAttrNumber(

822: itemtype => p_itemtype,
823: itemkey => p_itemkey,
824: aname => 'TC_BLD_BLK_OVN');
825:
826: l_ap_bb_id := wf_engine.GetItemAttrNumber(
827: itemtype => p_itemtype,
828: itemkey => p_itemkey,
829: aname => 'APP_BB_ID');
830:

Line 831: l_ap_bb_ovn := wf_engine.GetItemAttrNumber(

827: itemtype => p_itemtype,
828: itemkey => p_itemkey,
829: aname => 'APP_BB_ID');
830:
831: l_ap_bb_ovn := wf_engine.GetItemAttrNumber(
832: itemtype => p_itemtype,
833: itemkey => p_itemkey,
834: aname => 'APP_BB_OVN');
835:

Line 920: wf_engine.SetItemAttrText(

916: g_trace := '60';
917:
918: -- set tokens used by all notifications
919: --
920: wf_engine.SetItemAttrText(
921: itemtype => p_itemtype,
922: itemkey => p_itemkey,
923: aname => 'TC_OWNER',
924: avalue => get_name(l_resource_id,l_tc_start_time)

Line 963: wf_engine.SetItemAttrText(

959:
960: g_trace := '100';
961:
962: --set role attribute
963: wf_engine.SetItemAttrText(
964: itemtype => p_itemtype,
965: itemkey => p_itemkey,
966: aname => 'TC_FROM_ROLE',
967: avalue => l_login);

Line 971: wf_engine.SetItemAttrText(itemtype => p_itemtype,

967: avalue => l_login);
968:
969: g_trace := '110';
970:
971: wf_engine.SetItemAttrText(itemtype => p_itemtype,
972: itemkey => p_itemkey,
973: aname => 'TC_OWNER_SS_LOGIN',
974: avalue => l_login);
975:

Line 978: wf_engine.SetItemAttrDate(itemtype => p_itemtype,

974: avalue => l_login);
975:
976: g_trace := '120';
977:
978: wf_engine.SetItemAttrDate(itemtype => p_itemtype,
979: itemkey => p_itemkey,
980: aname => 'TC_START',
981: avalue => l_tc_start_time);
982: g_trace := '130';

Line 984: wf_engine.SetItemAttrDate(itemtype => p_itemtype,

980: aname => 'TC_START',
981: avalue => l_tc_start_time);
982: g_trace := '130';
983:
984: wf_engine.SetItemAttrDate(itemtype => p_itemtype,
985: itemkey => p_itemkey,
986: aname => 'TC_STOP',
987: avalue => l_tc_stop_time);
988:

Line 1003: wf_engine.SetItemAttrNumber(

999: g_trace := '160';
1000: --
1001: -- set parameters required by next activity
1002: --
1003: wf_engine.SetItemAttrNumber(
1004: itemtype => p_itemtype,
1005: itemkey => p_itemkey,
1006: aname => 'APR_PERSON_ID',
1007: avalue => l_approval_mechanism_id);

Line 1015: wf_engine.SetItemAttrNumber(

1011:
1012: elsif l_approval_mechanism = 'HR_SUPERVISOR'
1013: then
1014: g_trace := '180';
1015: wf_engine.SetItemAttrNumber(
1016: itemtype => p_itemtype,
1017: itemkey => p_itemkey,
1018: aname => 'APR_PERSON_ID',
1019: avalue => l_resource_id);

Line 1029: wf_engine.SetItemAttrNumber(

1025:
1026: elsif l_approval_mechanism = 'FORMULA_MECHANISM'
1027: then
1028: g_trace := '200';
1029: wf_engine.SetItemAttrNumber(
1030: itemtype => p_itemtype,
1031: itemkey => p_itemkey,
1032: aname => 'FORMULA_ID',
1033: avalue => l_approval_mechanism_id);

Line 1042: wf_engine.SetItemAttrText(

1038: elsif l_approval_mechanism = 'WORKFLOW'
1039: then
1040:
1041: g_trace := '220';
1042: wf_engine.SetItemAttrText(
1043: itemtype => p_itemtype,
1044: itemkey => p_itemkey,
1045: aname => 'WF_ITEM_TYPE',
1046: avalue => l_wf_item_type);

Line 1048: wf_engine.SetItemAttrText(

1044: itemkey => p_itemkey,
1045: aname => 'WF_ITEM_TYPE',
1046: avalue => l_wf_item_type);
1047:
1048: wf_engine.SetItemAttrText(
1049: itemtype => p_itemtype,
1050: itemkey => p_itemkey,
1051: aname => 'WF_PROCESS_NAME',
1052: avalue => l_wf_name);

Line 1116: wf_engine.SetItemAttrText(

1112: l_real_approver := get_name(l_employee_id,sysdate);
1113: END IF;
1114:
1115:
1116: wf_engine.SetItemAttrText(
1117: itemtype => p_itemtype,
1118: itemkey => p_itemkey,
1119: aname => 'APR_NAME',
1120: avalue => l_real_approver

Line 1124: wf_engine.SetItemAttrText(

1120: avalue => l_real_approver
1121: );
1122:
1123: --Bug 5375656
1124: wf_engine.SetItemAttrText(
1125: itemtype => p_itemtype,
1126: itemkey => p_itemkey,
1127: aname => 'TC_APPROVER_FROM_ROLE',
1128: avalue => l_real_approver

Line 1164: l_approvers_visited := wf_engine.GetItemAttrNumber(

1160: );
1161: --
1162: -- set variables for approval hierarchy
1163: --
1164: l_approvers_visited := wf_engine.GetItemAttrNumber(
1165: itemtype => p_itemtype,
1166: itemkey => p_itemkey,
1167: aname => 'APPROVERS_VISITED');
1168: if g_debug then

Line 1171: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

1167: aname => 'APPROVERS_VISITED');
1168: if g_debug then
1169: hr_utility.trace('l_approvers_visited=' || l_approvers_visited);
1170: end if;
1171: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
1172: itemkey => p_itemkey,
1173: aname => 'APPROVED_AT_LEVEL',
1174: avalue => l_approvers_visited);
1175:

Line 1179: wf_engine.SetItemAttrText(itemtype => p_itemtype,

1175:
1176: --
1177: -- set up attribute required for next activity
1178: --
1179: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1180: itemkey => p_itemkey,
1181: aname => 'APPROVAL_STATUS',
1182: avalue => 'APPROVED');
1183:

Line 1229: wf_engine.SetItemAttrText(itemtype => p_itemtype,

1225: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');
1226:
1227: if p_funcmode = 'RUN' then
1228: --
1229: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1230: itemkey => p_itemkey,
1231: aname => 'APPROVAL_STATUS',
1232: avalue => 'APPROVED');
1233:

Line 1234: wf_engine.SetItemAttrText(itemtype => p_itemtype,

1230: itemkey => p_itemkey,
1231: aname => 'APPROVAL_STATUS',
1232: avalue => 'APPROVED');
1233:
1234: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1235: itemkey => p_itemkey,
1236: aname => 'APR_REJ_REASON',
1237: avalue => 'TIMED_OUT');
1238:

Line 1285: wf_engine.SetItemAttrText(itemtype => p_itemtype,

1281: );
1282: --
1283: -- set up attribute required for next activity
1284: --
1285: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1286: itemkey => p_itemkey,
1287: aname => 'APPROVAL_STATUS',
1288: avalue => 'REJECTED');
1289:

Line 1406: l_ap_bb_id := wf_engine.GetItemAttrNumber(

1402: if g_debug then
1403: l_proc := g_pkg || 'find_project_manager';
1404: hr_utility.trace('in ' || l_proc);
1405: end if;
1406: l_ap_bb_id := wf_engine.GetItemAttrNumber(
1407: itemtype => p_itemtype,
1408: itemkey => p_itemkey,
1409: aname => 'APP_BB_ID');
1410:

Line 1411: l_is_blank := wf_engine.GetItemAttrText(itemtype => p_itemtype,

1407: itemtype => p_itemtype,
1408: itemkey => p_itemkey,
1409: aname => 'APP_BB_ID');
1410:
1411: l_is_blank := wf_engine.GetItemAttrText(itemtype => p_itemtype,
1412: itemkey => p_itemkey,
1413: aname => 'IS_DIFF_TC',
1414: ignore_notfound => true);
1415:

Line 1464: wf_engine.SetItemAttrNumber(

1460: hr_utility.raise_error;
1461:
1462: END IF;
1463:
1464: wf_engine.SetItemAttrNumber(
1465: itemtype => p_itemtype,
1466: itemkey => p_itemkey,
1467: aname => 'APR_PERSON_ID',
1468: avalue => l_project_manager);

Line 1482: wf_engine.SetItemAttrNumber

1478: --
1479: l_project_manager := hxc_approval_wf_util.get_previous_approver
1480: (p_itemtype,p_itemkey,l_ap_bb_id);
1481: if(l_project_manager is not null) then
1482: wf_engine.SetItemAttrNumber
1483: (itemtype => p_itemtype,
1484: itemkey => p_itemkey,
1485: aname => 'APR_PERSON_ID',
1486: avalue => l_project_manager);

Line 1539: wf_engine.SetItemAttrText(itemtype => p_itemtype,

1535: if p_funcmode = 'RUN' then
1536: --
1537: -- set up attribute required for next activity
1538: --
1539: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1540: itemkey => p_itemkey,
1541: aname => 'APPROVAL_STATUS',
1542: avalue => 'APPROVED');
1543:

Line 1544: wf_engine.SetItemAttrText(itemtype => p_itemtype,

1540: itemkey => p_itemkey,
1541: aname => 'APPROVAL_STATUS',
1542: avalue => 'APPROVED');
1543:
1544: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1545: itemkey => p_itemkey,
1546: aname => 'APR_REJ_REASON',
1547: avalue => 'AUTO_APPROVE');
1548:

Line 1820: l_effective_end_date := wf_engine.GetItemAttrDate(

1816: if p_funcmode = 'RUN' then
1817: --
1818: -- all datetrack data should be valid for duration of application period
1819: --
1820: l_effective_end_date := wf_engine.GetItemAttrDate(
1821: itemtype => p_itemtype,
1822: itemkey => p_itemkey,
1823: aname => 'APP_END_DATE');
1824:

Line 1825: l_effective_start_date := wf_engine.GetItemAttrDate(

1821: itemtype => p_itemtype,
1822: itemkey => p_itemkey,
1823: aname => 'APP_END_DATE');
1824:
1825: l_effective_start_date := wf_engine.GetItemAttrDate(
1826: itemtype => p_itemtype,
1827: itemkey => p_itemkey,
1828: aname => 'APP_START_DATE');
1829:

Line 1830: l_apr_person_id := wf_engine.GetItemAttrNumber(

1826: itemtype => p_itemtype,
1827: itemkey => p_itemkey,
1828: aname => 'APP_START_DATE');
1829:
1830: l_apr_person_id := wf_engine.GetItemAttrNumber(
1831: itemtype => p_itemtype,
1832: itemkey => p_itemkey,
1833: aname => 'APR_PERSON_ID');
1834:

Line 1835: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(

1831: itemtype => p_itemtype,
1832: itemkey => p_itemkey,
1833: aname => 'APR_PERSON_ID');
1834:
1835: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(
1836: itemtype => p_itemtype,
1837: itemkey => p_itemkey,
1838: aname => 'APP_BB_ID');
1839: l_is_blank := wf_engine.GetItemAttrText(itemtype => p_itemtype,

Line 1839: l_is_blank := wf_engine.GetItemAttrText(itemtype => p_itemtype,

1835: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(
1836: itemtype => p_itemtype,
1837: itemkey => p_itemkey,
1838: aname => 'APP_BB_ID');
1839: l_is_blank := wf_engine.GetItemAttrText(itemtype => p_itemtype,
1840: itemkey => p_itemkey ,
1841: aname => 'IS_DIFF_TC',
1842: ignore_notfound => true);
1843: --Added as part of OIT enhancement

Line 1844: l_resource_id := wf_engine.GetItemAttrNumber(

1840: itemkey => p_itemkey ,
1841: aname => 'IS_DIFF_TC',
1842: ignore_notfound => true);
1843: --Added as part of OIT enhancement
1844: l_resource_id := wf_engine.GetItemAttrNumber(
1845: itemtype => p_itemtype,
1846: itemkey => p_itemkey,
1847: aname => 'RESOURCE_ID');
1848:

Line 1856: wf_engine.SetItemAttrNumber(

1852: IF l_is_blank = 'Y' THEN
1853:
1854: l_apr_person_id := get_supervisor(l_resource_id, sysdate);
1855:
1856: wf_engine.SetItemAttrNumber(
1857: itemtype => p_itemtype,
1858: itemkey => p_itemkey,
1859: aname => 'APR_PERSON_ID',
1860: avalue => l_apr_person_id);

Line 1887: wf_engine.SetItemAttrText(

1883: end if;
1884:
1885: --sb_msgs_pkg.trace('approver login>' || l_login || '<');
1886:
1887: wf_engine.SetItemAttrText(
1888: itemtype => p_itemtype,
1889: itemkey => p_itemkey,
1890: aname => 'APR_SS_LOGIN',
1891: avalue => l_login);

Line 1898: wf_engine.SetItemAttrText(

1894: -- set information for notification
1895: --
1896:
1897:
1898: wf_engine.SetItemAttrText(
1899: itemtype => p_itemtype,
1900: itemkey => p_itemkey,
1901: aname => 'APR_NAME',
1902: avalue => get_name(l_apr_person_id,l_effective_end_date)

Line 1904: wf_engine.SetItemAttrText(

1900: itemkey => p_itemkey,
1901: aname => 'APR_NAME',
1902: avalue => get_name(l_apr_person_id,l_effective_end_date)
1903: );
1904: wf_engine.SetItemAttrText(
1905: itemtype => p_itemtype,
1906: itemkey => p_itemkey,
1907: aname => 'TC_APPROVER_FROM_ROLE',
1908: avalue => l_login);

Line 1916: wf_engine.SetItemAttrText(

1912: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1913:
1914: l_title := fnd_message.get();
1915:
1916: wf_engine.SetItemAttrText(
1917: itemtype => p_itemtype,
1918: itemkey => p_itemkey,
1919: aname => 'TITLE',
1920: avalue => l_title);

Line 1924: wf_engine.SetItemAttrText(

1920: avalue => l_title);
1921:
1922: l_otl_appr_id := l_appl_period_bb_id||'#'||p_itemkey;
1923:
1924: wf_engine.SetItemAttrText(
1925: itemtype => p_itemtype,
1926: itemkey => p_itemkey,
1927: aname => 'OTL_APPR_ID',
1928: avalue => l_otl_appr_id);

Line 1930: wf_engine.SetItemAttrText(

1926: itemkey => p_itemkey,
1927: aname => 'OTL_APPR_ID',
1928: avalue => l_otl_appr_id);
1929:
1930: wf_engine.SetItemAttrText(
1931: itemtype => p_itemtype,
1932: itemkey => p_itemkey,
1933: aname => 'DESCRIPTION',
1934: avalue => get_description(l_appl_period_bb_id));

Line 1936: wf_engine.SetItemAttrNumber(

1932: itemkey => p_itemkey,
1933: aname => 'DESCRIPTION',
1934: avalue => get_description(l_appl_period_bb_id));
1935:
1936: wf_engine.SetItemAttrNumber(
1937: itemtype => p_itemtype,
1938: itemkey => p_itemkey,
1939: aname => 'TOTAL_TC_HOURS',
1940: avalue => l_total_hours);

Line 2036: l_approvers_visited := wf_engine.GetItemAttrNumber(

2032: p_itemkey in varchar2)
2033: is
2034: l_approvers_visited number;
2035: begin
2036: l_approvers_visited := wf_engine.GetItemAttrNumber(
2037: itemtype => p_itemtype,
2038: itemkey => p_itemkey,
2039: aname => 'APPROVERS_VISITED');
2040:

Line 2043: wf_engine.SetItemAttrText(itemtype => p_itemtype,

2039: aname => 'APPROVERS_VISITED');
2040:
2041: l_approvers_visited := l_approvers_visited + 1;
2042:
2043: wf_engine.SetItemAttrText(itemtype => p_itemtype,
2044: itemkey => p_itemkey,
2045: aname => 'APPROVERS_VISITED',
2046: avalue => l_approvers_visited);
2047: end inc_approvers_visited;

Line 2246: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber

2242: if g_debug then
2243: hr_utility.trace('Begin hr_supervisor_approval');
2244: end if;
2245:
2246: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber
2247: (itemtype => p_itemtype,
2248: itemkey => p_itemkey,
2249: aname => 'TC_BLD_BLK_ID');
2250:

Line 2256: l_tc_ovn := wf_engine.GetItemAttrNumber

2252:
2253: if g_debug then
2254: hr_utility.trace('Timecard BB ID is : ' || to_char(l_tc_bld_blk_id));
2255: end if;
2256: l_tc_ovn := wf_engine.GetItemAttrNumber
2257: (itemtype => p_itemtype,
2258: itemkey => p_itemkey,
2259: aname => 'TC_BLD_BLK_OVN');
2260:

Line 2261: l_approvers_visited := wf_engine.GetItemAttrNumber(

2257: (itemtype => p_itemtype,
2258: itemkey => p_itemkey,
2259: aname => 'TC_BLD_BLK_OVN');
2260:
2261: l_approvers_visited := wf_engine.GetItemAttrNumber(
2262: itemtype => p_itemtype,
2263: itemkey => p_itemkey,
2264: aname => 'APPROVERS_VISITED');
2265:

Line 2266: l_time_recipient := wf_engine.GetItemAttrText(

2262: itemtype => p_itemtype,
2263: itemkey => p_itemkey,
2264: aname => 'APPROVERS_VISITED');
2265:
2266: l_time_recipient := wf_engine.GetItemAttrText(
2267: itemtype => p_itemtype,
2268: itemkey => p_itemkey ,
2269: aname => 'TIME_RECIPIENT_ID');
2270:

Line 2271: l_person_id := wf_engine.GetItemAttrNumber(

2267: itemtype => p_itemtype,
2268: itemkey => p_itemkey ,
2269: aname => 'TIME_RECIPIENT_ID');
2270:
2271: l_person_id := wf_engine.GetItemAttrNumber(
2272: itemtype => p_itemtype,
2273: itemkey => p_itemkey,
2274: aname => 'APR_PERSON_ID');
2275:

Line 2276: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(

2272: itemtype => p_itemtype,
2273: itemkey => p_itemkey,
2274: aname => 'APR_PERSON_ID');
2275:
2276: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(
2277: itemtype => p_itemtype,
2278: itemkey => p_itemkey,
2279: aname => 'APP_BB_ID');
2280: l_app_ovn :=wf_engine.GetItemAttrNumber(

Line 2280: l_app_ovn :=wf_engine.GetItemAttrNumber(

2276: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(
2277: itemtype => p_itemtype,
2278: itemkey => p_itemkey,
2279: aname => 'APP_BB_ID');
2280: l_app_ovn :=wf_engine.GetItemAttrNumber(
2281: itemtype => p_itemtype,
2282: itemkey => p_itemkey,
2283: aname => 'APP_BB_OVN');
2284: --OIT Change.

Line 2296: wf_engine.SetItemAttrNumber(

2292: close get_result;
2293:
2294: if l_result = 'RESEND' then
2295:
2296: wf_engine.SetItemAttrNumber(
2297: itemtype => p_itemtype,
2298: itemkey => p_itemkey,
2299: aname => 'APPROVERS_VISITED',
2300: avalue => l_approvers_visited-1);

Line 2340: wf_engine.SetItemAttrText(itemtype => p_itemtype,

2336: g_trace := 'extension code exists';
2337: if g_debug then
2338: hr_utility.trace('extension code exists');
2339: end if;
2340: wf_engine.SetItemAttrText(itemtype => p_itemtype,
2341: itemkey => p_itemkey,
2342: aname => 'APR_KEY_LEVEL',
2343: avalue => '100');
2344:

Line 2345: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

2341: itemkey => p_itemkey,
2342: aname => 'APR_KEY_LEVEL',
2343: avalue => '100');
2344:
2345: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
2346: itemkey => p_itemkey,
2347: aname => 'APPROVAL_TIMEOUT',
2348: avalue => 0);
2349:

Line 2407: wf_engine.SetItemAttrText(itemtype => p_itemtype,

2403: hr_utility.trace('end calling extension');
2404: end if;
2405: IF l_next_supervisor_id = -99
2406: THEN
2407: wf_engine.SetItemAttrText(itemtype => p_itemtype,
2408: itemkey => p_itemkey,
2409: aname => 'FINAL_APR',
2410: avalue => 'YES');
2411:

Line 2433: wf_engine.SetItemAttrText(itemtype => p_itemtype,

2429: hr_utility.raise_error;
2430:
2431: END IF;
2432: ELSE -- if no client extension, find supervisor from assignments
2433: wf_engine.SetItemAttrText(itemtype => p_itemtype,
2434: itemkey => p_itemkey,
2435: aname => 'FINAL_APR',
2436: avalue => 'NO_EXTENSION');
2437:

Line 2447: l_effective_end_date := wf_engine.GetItemAttrDate(

2443: end if;
2444:
2445: -- Bug 4202019. These variables need to be set outside this IF block.
2446: /*
2447: l_effective_end_date := wf_engine.GetItemAttrDate(
2448: itemtype => p_itemtype,
2449: itemkey => p_itemkey,
2450: aname => 'APP_END_DATE');
2451:

Line 2452: l_effective_start_date := wf_engine.GetItemAttrDate(

2448: itemtype => p_itemtype,
2449: itemkey => p_itemkey,
2450: aname => 'APP_END_DATE');
2451:
2452: l_effective_start_date := wf_engine.GetItemAttrDate(
2453: itemtype => p_itemtype,
2454: itemkey => p_itemkey,
2455: aname => 'APP_START_DATE');
2456: */

Line 2513: l_default_timeout := wf_engine.GetItemAttrText(

2509: g_trace :='allow timeout';
2510: if g_debug then
2511: hr_utility.trace('allow timeout');
2512: end if;
2513: l_default_timeout := wf_engine.GetItemAttrText(
2514: itemtype => p_itemtype,
2515: itemkey => p_itemkey,
2516: aname => 'DEFAULT_TIMEOUT');
2517:

Line 2519: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

2515: itemkey => p_itemkey,
2516: aname => 'DEFAULT_TIMEOUT');
2517:
2518:
2519: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
2520: itemkey => p_itemkey,
2521: aname => 'APPROVAL_TIMEOUT',
2522: avalue => l_default_timeout);
2523:

Line 2535: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

2531: g_trace :='NOT allow timeout';
2532: if g_debug then
2533: hr_utility.trace('NOT allow timeout');
2534: end if;
2535: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
2536: itemkey => p_itemkey,
2537: aname => 'APPROVAL_TIMEOUT',
2538: avalue => 0);
2539: end if;

Line 2578: wf_engine.SetItemAttrText(

2574: hr_utility.trace('increase approvers visited');
2575: end if;
2576: inc_approvers_visited(p_itemtype, p_itemkey);
2577:
2578: wf_engine.SetItemAttrText(
2579: itemtype => p_itemtype,
2580: itemkey => p_itemkey,
2581: aname => 'APR_SS_LOGIN',
2582: avalue => l_login

Line 2590: wf_engine.SetItemAttrText(

2586: if g_debug then
2587: hr_utility.trace('setting apr_name');
2588: end if;
2589: -- set information for notification
2590: wf_engine.SetItemAttrText(
2591: itemtype => p_itemtype,
2592: itemkey => p_itemkey,
2593: aname => 'APR_NAME',
2594: avalue => get_name(l_supervisor_id,sysdate)

Line 2601: wf_engine.SetItemAttrText(

2597: g_trace := 'setting from_role';
2598: if g_debug then
2599: hr_utility.trace('setting from_role');
2600: end if;
2601: wf_engine.SetItemAttrText(
2602: itemtype => p_itemtype,
2603: itemkey => p_itemkey,
2604: aname => 'TC_APPROVER_FROM_ROLE',
2605: avalue => l_login

Line 2615: wf_engine.SetItemAttrNumber(

2611: end if;
2612: --
2613: -- set supervisor's person id, ready for next iteration
2614:
2615: wf_engine.SetItemAttrNumber(
2616: itemtype => p_itemtype,
2617: itemkey => p_itemkey,
2618: aname => 'APR_PERSON_ID',
2619: avalue => l_supervisor_id);

Line 2623: l_effective_end_date := wf_engine.GetItemAttrDate(

2619: avalue => l_supervisor_id);
2620:
2621: -- Bug 4202019. These variables are set just before they are being used in the TITLE of Worklist notification.
2622:
2623: l_effective_end_date := wf_engine.GetItemAttrDate(
2624: itemtype => p_itemtype,
2625: itemkey => p_itemkey,
2626: aname => 'APP_END_DATE');
2627:

Line 2628: l_effective_start_date := wf_engine.GetItemAttrDate(

2624: itemtype => p_itemtype,
2625: itemkey => p_itemkey,
2626: aname => 'APP_END_DATE');
2627:
2628: l_effective_start_date := wf_engine.GetItemAttrDate(
2629: itemtype => p_itemtype,
2630: itemkey => p_itemkey,
2631: aname => 'APP_START_DATE');
2632:

Line 2640: wf_engine.SetItemAttrText(

2636: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2637:
2638: l_title := fnd_message.get();
2639:
2640: wf_engine.SetItemAttrText(
2641: itemtype => p_itemtype,
2642: itemkey => p_itemkey,
2643: aname => 'TITLE',
2644: avalue => l_title);

Line 2648: wf_engine.SetItemAttrText(

2644: avalue => l_title);
2645:
2646: l_otl_appr_id := l_appl_period_bb_id||'#'||p_itemkey;
2647:
2648: wf_engine.SetItemAttrText(
2649: itemtype => p_itemtype,
2650: itemkey => p_itemkey,
2651: aname => 'OTL_APPR_ID',
2652: avalue => l_otl_appr_id);

Line 2665: wf_engine.SetItemAttrText

2661: fnd_message.set_name('HXC','HXC_APPR_WF_DESC_NO_PA_MANAGER');
2662: l_description := l_description || fnd_message.get();
2663: end if;
2664:
2665: wf_engine.SetItemAttrText
2666: (itemtype => p_itemtype,
2667: itemkey => p_itemkey,
2668: aname => 'DESCRIPTION',
2669: avalue => l_description);

Line 2671: wf_engine.SetItemAttrNumber(

2667: itemkey => p_itemkey,
2668: aname => 'DESCRIPTION',
2669: avalue => l_description);
2670:
2671: wf_engine.SetItemAttrNumber(
2672: itemtype => p_itemtype,
2673: itemkey => p_itemkey,
2674: aname => 'TOTAL_TC_HOURS',
2675: avalue => l_total_hours);

Line 2741: l_approvers_visited := wf_engine.GetItemAttrNumber(

2737: --
2738: -- set variables for approval hierarchy
2739: --
2740: /*jxtan should move this to other procedure
2741: l_approvers_visited := wf_engine.GetItemAttrNumber(
2742: itemtype => p_itemtype,
2743: itemkey => p_itemkey,
2744: aname => 'APPROVERS_VISITED');
2745:

Line 2746: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

2742: itemtype => p_itemtype,
2743: itemkey => p_itemkey,
2744: aname => 'APPROVERS_VISITED');
2745:
2746: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
2747: itemkey => p_itemkey,
2748: aname => 'APPROVED_AT_LEVEL',
2749: avalue => l_approvers_visited);
2750:

Line 2755: wf_engine.SetItemAttrText(itemtype => p_itemtype,

2751: */
2752: --
2753: -- set up attribute required for next activity
2754: --
2755: wf_engine.SetItemAttrText(itemtype => p_itemtype,
2756: itemkey => p_itemkey,
2757: aname => 'APPROVAL_STATUS',
2758: avalue => 'APPROVED');
2759:

Line 2804: wf_engine.SetItemAttrText(itemtype => p_itemtype,

2800: if p_funcmode = 'RUN' then
2801: --
2802: -- set up attribute required for next activity
2803: --
2804: wf_engine.SetItemAttrText(itemtype => p_itemtype,
2805: itemkey => p_itemkey,
2806: aname => 'APPROVAL_STATUS',
2807: avalue => 'REJECTED');
2808: --

Line 2863: l_final_apr := wf_engine.GetItemAttrText(

2859: hr_utility.trace('is final approver');
2860: end if;
2861: if p_funcmode = 'RUN' then
2862:
2863: l_final_apr := wf_engine.GetItemAttrText(
2864: itemtype => p_itemtype,
2865: itemkey => p_itemkey,
2866: aname => 'FINAL_APR');
2867:

Line 2883: l_apr_person_id := wf_engine.GetItemAttrNumber(

2879: p_result := 'COMPLETE:N';
2880: return;
2881: END IF;
2882:
2883: l_apr_person_id := wf_engine.GetItemAttrNumber(
2884: itemtype => p_itemtype,
2885: itemkey => p_itemkey,
2886: aname => 'APR_PERSON_ID');
2887:

Line 2898: l_effective_date := wf_engine.GetItemAttrDate(

2894: if g_debug then
2895: hr_utility.trace('NOT final');
2896: end if;
2897:
2898: l_effective_date := wf_engine.GetItemAttrDate(
2899: itemtype => p_itemtype,
2900: itemkey => p_itemkey,
2901: aname => 'APP_END_DATE');
2902:

Line 2903: l_approval_timeout := wf_engine.GetItemAttrText(

2899: itemtype => p_itemtype,
2900: itemkey => p_itemkey,
2901: aname => 'APP_END_DATE');
2902:
2903: l_approval_timeout := wf_engine.GetItemAttrText(
2904: itemtype => p_itemtype,
2905: itemkey => p_itemkey,
2906: aname => 'APPROVAL_TIMEOUT');
2907:

Line 2908: l_default_timeout := wf_engine.GetItemAttrText(

2904: itemtype => p_itemtype,
2905: itemkey => p_itemkey,
2906: aname => 'APPROVAL_TIMEOUT');
2907:
2908: l_default_timeout := wf_engine.GetItemAttrText(
2909: itemtype => p_itemtype,
2910: itemkey => p_itemkey,
2911: aname => 'DEFAULT_TIMEOUT');
2912:

Line 2916: l_apr_key_level := wf_engine.GetItemAttrText(

2912:
2913:
2914: --sb_msgs_pkg.trace('current apr per id>' || l_apr_person_id || '<');
2915:
2916: l_apr_key_level := wf_engine.GetItemAttrText(
2917: itemtype => p_itemtype,
2918: itemkey => p_itemkey,
2919: aname => 'APR_KEY_LEVEL');
2920:

Line 2921: l_approved_at_level := wf_engine.GetItemAttrText(

2917: itemtype => p_itemtype,
2918: itemkey => p_itemkey,
2919: aname => 'APR_KEY_LEVEL');
2920:
2921: l_approved_at_level := wf_engine.GetItemAttrText(
2922: itemtype => p_itemtype,
2923: itemkey => p_itemkey,
2924: aname => 'APPROVED_AT_LEVEL');
2925:

Line 2926: l_approvers_visited := wf_engine.GetItemAttrText(

2922: itemtype => p_itemtype,
2923: itemkey => p_itemkey,
2924: aname => 'APPROVED_AT_LEVEL');
2925:
2926: l_approvers_visited := wf_engine.GetItemAttrText(
2927: itemtype => p_itemtype,
2928: itemkey => p_itemkey,
2929: aname => 'APPROVERS_VISITED');
2930:

Line 2942: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

2938: if g_debug then
2939: hr_utility.trace('not final 1');
2940: end if;
2941:
2942: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
2943: itemkey => p_itemkey,
2944: aname => 'APPROVAL_TIMEOUT',
2945: avalue => l_default_timeout);
2946: p_result := 'COMPLETE:N';

Line 2962: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

2958: if get_supervisor(l_apr_person_id,
2959: SYSDATE) is not null then
2960: --sb_msgs_pkg.trace('22 - if');
2961:
2962: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
2963: itemkey => p_itemkey,
2964: aname => 'APPROVAL_TIMEOUT',
2965: avalue => l_default_timeout);
2966: --

Line 2972: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

2968: -- next approver NOT allowed to timeout
2969: else
2970: --sb_msgs_pkg.trace('24 - else');
2971:
2972: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
2973: itemkey => p_itemkey,
2974: aname => 'APPROVAL_TIMEOUT',
2975: avalue => 0);
2976: end if;

Line 3005: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3001: if g_debug then
3002: hr_utility.trace('not final 3');
3003: end if;
3004:
3005: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3006: itemkey => p_itemkey,
3007: aname => 'APPROVAL_TIMEOUT',
3008: avalue => 0);
3009: p_result := 'COMPLETE:N';

Line 3016: l_approval_timeout := wf_engine.GetItemAttrText(

3012:
3013: --
3014: -- timeout to be used by next notification
3015: --
3016: l_approval_timeout := wf_engine.GetItemAttrText(
3017: itemtype => p_itemtype,
3018: itemkey => p_itemkey,
3019: aname => 'APPROVAL_TIMEOUT');
3020: --sb_msgs_pkg.trace('l_apr_timeout(A)>' || l_approval_timeout || '<');

Line 3089: l_person_id := wf_engine.GetItemAttrNumber(

3085: l_proc := g_pkg || '.' || 'formula_selects_mechanism';
3086: hr_utility.set_location(l_proc, 10);
3087: end if;
3088:
3089: l_person_id := wf_engine.GetItemAttrNumber(
3090: itemtype => p_itemtype,
3091: itemkey => p_itemkey,
3092: aname => 'RESOURCE_ID');
3093: if p_funcmode = 'RUN' then

Line 3094: l_effective_date := wf_engine.GetItemAttrDate(

3090: itemtype => p_itemtype,
3091: itemkey => p_itemkey,
3092: aname => 'RESOURCE_ID');
3093: if p_funcmode = 'RUN' then
3094: l_effective_date := wf_engine.GetItemAttrDate(
3095: itemtype => p_itemtype,
3096: itemkey => p_itemkey,
3097: aname => 'APP_END_DATE');
3098:

Line 3099: l_formula_id := wf_engine.GetItemAttrNumber(

3095: itemtype => p_itemtype,
3096: itemkey => p_itemkey,
3097: aname => 'APP_END_DATE');
3098:
3099: l_formula_id := wf_engine.GetItemAttrNumber(
3100: itemtype => p_itemtype,
3101: itemkey => p_itemkey,
3102: aname => 'FORMULA_ID');
3103:

Line 3136: l_inputs(i).value := wf_engine.GetItemAttrNumber(

3132:
3133: if g_debug then
3134: hr_utility.set_location(l_proc, 40);
3135: end if;
3136: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3137: itemtype => p_itemtype,
3138: itemkey => p_itemkey,
3139: aname => 'TC_BLD_BLK_ID');
3140:

Line 3145: l_inputs(i).value := wf_engine.GetItemAttrNumber(

3141: elsif l_inputs(i).name = 'TIMECARD_BB_OVN' then
3142: if g_debug then
3143: hr_utility.set_location(l_proc, 50);
3144: end if;
3145: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3146: itemtype => p_itemtype,
3147: itemkey => p_itemkey,
3148: aname => 'TC_BLD_BLK_OVN');
3149:

Line 3154: l_inputs(i).value := wf_engine.GetItemAttrNumber(

3150: elsif l_inputs(i).name = 'APPLICATION_PERIOD_BB_ID' then
3151: if g_debug then
3152: hr_utility.set_location(l_proc, 60);
3153: end if;
3154: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3155: itemtype => p_itemtype,
3156: itemkey => p_itemkey,
3157: aname => 'APP_BB_ID');
3158:

Line 3163: l_inputs(i).value := wf_engine.GetItemAttrNumber(

3159: elsif l_inputs(i).name = 'APPLICATION_PERIOD_BB_OVN' then
3160: if g_debug then
3161: hr_utility.set_location(l_proc, 70);
3162: end if;
3163: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3164: itemtype => p_itemtype,
3165: itemkey => p_itemkey,
3166: aname => 'APP_BB_OVN');
3167:

Line 3172: l_inputs(i).value := wf_engine.GetItemAttrNumber(

3168: elsif l_inputs(i).name = 'TIME_RECIPIENT_ID' then
3169: if g_debug then
3170: hr_utility.set_location(l_proc, 80);
3171: end if;
3172: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3173: itemtype => p_itemtype,
3174: itemkey => p_itemkey,
3175: aname => 'TIME_RECIPIENT_ID');
3176: l_inputs(i).value := 5;

Line 3182: l_inputs(i).value := wf_engine.GetItemAttrNumber(

3178: elsif l_inputs(i).name = 'RESOURCE_ID' then
3179: if g_debug then
3180: hr_utility.set_location(l_proc, 90);
3181: end if;
3182: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3183: itemtype => p_itemtype,
3184: itemkey => p_itemkey,
3185: aname => 'RESOURCE_ID');
3186:

Line 3329: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3325: if g_debug then
3326: hr_utility.set_location(l_proc, 180);
3327: end if;
3328:
3329: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3330: itemkey => p_itemkey,
3331: aname => 'APR_PERSON_ID',
3332: avalue => l_approval_mechanism_id);
3333:

Line 3347: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3343: --
3344: elsif l_approval_mechanism = 'HR_SUPERVISOR' then
3345: --sb_msgs_pkg.trace('formula selects hr supervisor approval');
3346:
3347: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3348: itemkey => p_itemkey,
3349: aname => 'APR_PERSON_ID',
3350: avalue => l_person_id);
3351:

Line 3358: wf_engine.SetItemAttrText(itemtype => p_itemtype,

3354: --
3355: elsif l_approval_mechanism = 'WORKFLOW' then
3356: --sb_msgs_pkg.trace('formula selects workflow approval');
3357:
3358: wf_engine.SetItemAttrText(itemtype => p_itemtype,
3359: itemkey => p_itemkey,
3360: aname => 'WF_ITEM_TYPE',
3361: avalue => l_wf_item_type);
3362:

Line 3363: wf_engine.SetItemAttrText(itemtype => p_itemtype,

3359: itemkey => p_itemkey,
3360: aname => 'WF_ITEM_TYPE',
3361: avalue => l_wf_item_type);
3362:
3363: wf_engine.SetItemAttrText(itemtype => p_itemtype,
3364: itemkey => p_itemkey,
3365: aname => 'WF_PROCESS_NAME',
3366: avalue => l_wf_process_name);
3367:

Line 3428: l_ap_bbid := wf_engine.GetItemAttrNumber(

3424: begin
3425: --sb_msgs_pkg.begin_call(l_proc);
3426: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');
3427:
3428: l_ap_bbid := wf_engine.GetItemAttrNumber(
3429: itemtype => p_itemtype,
3430: itemkey => p_itemkey,
3431: aname => 'APP_BB_ID');
3432:

Line 3433: l_ap_bbovn := wf_engine.GetItemAttrNumber(

3429: itemtype => p_itemtype,
3430: itemkey => p_itemkey,
3431: aname => 'APP_BB_ID');
3432:
3433: l_ap_bbovn := wf_engine.GetItemAttrNumber(
3434: itemtype => p_itemtype,
3435: itemkey => p_itemkey,
3436: aname => 'APP_BB_OVN');
3437:

Line 3438: l_wf_item_type := wf_engine.GetItemAttrText(itemtype => p_itemtype,

3434: itemtype => p_itemtype,
3435: itemkey => p_itemkey,
3436: aname => 'APP_BB_OVN');
3437:
3438: l_wf_item_type := wf_engine.GetItemAttrText(itemtype => p_itemtype,
3439: itemkey => p_itemkey,
3440: aname => 'WF_ITEM_TYPE');
3441:
3442: l_wf_process_name := wf_engine.GetItemAttrText(

Line 3442: l_wf_process_name := wf_engine.GetItemAttrText(

3438: l_wf_item_type := wf_engine.GetItemAttrText(itemtype => p_itemtype,
3439: itemkey => p_itemkey,
3440: aname => 'WF_ITEM_TYPE');
3441:
3442: l_wf_process_name := wf_engine.GetItemAttrText(
3443: itemtype => p_itemtype,
3444: itemkey => p_itemkey,
3445: aname => 'WF_PROCESS_NAME');
3446:

Line 3456: wf_engine.createProcess(l_wf_item_type, l_item_key, l_wf_process_name);

3452: FROM DUAL;
3453:
3454: --sb_msgs_pkg.trace('l_item_key>' || l_item_key || '<');
3455:
3456: wf_engine.createProcess(l_wf_item_type, l_item_key, l_wf_process_name);
3457:
3458:
3459: --
3460: -- set attributes required by child workflow,

Line 3463: wf_engine.SetItemAttrText(itemtype => l_wf_item_type,

3459: --
3460: -- set attributes required by child workflow,
3461: -- set parent item type and key in child workflow process
3462: --
3463: wf_engine.SetItemAttrText(itemtype => l_wf_item_type,
3464: itemkey => l_item_key,
3465: aname => 'PARENT_ITEM_TYPE',
3466: avalue => p_itemtype);
3467:

Line 3468: wf_engine.SetItemAttrText(itemtype => l_wf_item_type,

3464: itemkey => l_item_key,
3465: aname => 'PARENT_ITEM_TYPE',
3466: avalue => p_itemtype);
3467:
3468: wf_engine.SetItemAttrText(itemtype => l_wf_item_type,
3469: itemkey => l_item_key,
3470: aname => 'PARENT_ITEM_KEY',
3471: avalue => p_itemkey);
3472: --

Line 3473: wf_engine.SetItemParent

3469: itemkey => l_item_key,
3470: aname => 'PARENT_ITEM_KEY',
3471: avalue => p_itemkey);
3472: --
3473: wf_engine.SetItemParent
3474: (itemtype => l_wf_item_type,
3475: itemkey => l_item_key,
3476: parent_itemtype => p_itemtype,
3477: parent_itemkey => p_itemkey,

Line 3482: wf_engine.startProcess(l_wf_item_type, l_item_key);

3478: parent_context => NULL);
3479: --
3480: -- launch customer's workflow process
3481: --
3482: wf_engine.startProcess(l_wf_item_type, l_item_key);
3483:
3484: l_apr_person_id := wf_engine.GetItemAttrNumber(
3485: itemtype => p_itemtype,
3486: itemkey => p_itemkey,

Line 3484: l_apr_person_id := wf_engine.GetItemAttrNumber(

3480: -- launch customer's workflow process
3481: --
3482: wf_engine.startProcess(l_wf_item_type, l_item_key);
3483:
3484: l_apr_person_id := wf_engine.GetItemAttrNumber(
3485: itemtype => p_itemtype,
3486: itemkey => p_itemkey,
3487: aname => 'APR_PERSON_ID');
3488: l_resource_id := wf_engine.GetItemAttrNumber(

Line 3488: l_resource_id := wf_engine.GetItemAttrNumber(

3484: l_apr_person_id := wf_engine.GetItemAttrNumber(
3485: itemtype => p_itemtype,
3486: itemkey => p_itemkey,
3487: aname => 'APR_PERSON_ID');
3488: l_resource_id := wf_engine.GetItemAttrNumber(
3489: itemtype => p_itemtype,
3490: itemkey => p_itemkey,
3491: aname => 'RESOURCE_ID');
3492: --OIT Enhancement

Line 3550: l_wf_apr_result := wf_engine.GetItemAttrText(

3546: --sb_msgs_pkg.begin_call(l_proc);
3547: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');
3548:
3549: if p_funcmode = 'RUN' then
3550: l_wf_apr_result := wf_engine.GetItemAttrText(
3551: itemtype => p_itemtype,
3552: itemkey => p_itemkey,
3553: aname => 'WF_APPROVAL_RESULT');
3554: --sb_msgs_pkg.trace('WF_APPROVAL_RESULT>' || l_wf_apr_result || '<');

Line 3556: wf_engine.SetItemAttrText(itemtype => p_itemtype,

3552: itemkey => p_itemkey,
3553: aname => 'WF_APPROVAL_RESULT');
3554: --sb_msgs_pkg.trace('WF_APPROVAL_RESULT>' || l_wf_apr_result || '<');
3555:
3556: wf_engine.SetItemAttrText(itemtype => p_itemtype,
3557: itemkey => p_itemkey,
3558: aname => 'APPROVAL_STATUS',
3559: avalue => l_wf_apr_result);
3560:

Line 3635: l_next_period_id := wf_engine.GetItemAttrNumber(

3631: hr_utility.trace('in set next period');
3632: end if;
3633: IF p_funcmode = 'RUN'
3634: THEN
3635: l_next_period_id := wf_engine.GetItemAttrNumber(
3636: itemtype => p_itemtype,
3637: itemkey => p_itemkey,
3638: aname => 'NEXT_APP_BB_ID');
3639:

Line 3644: l_next_period_ovn := wf_engine.GetItemAttrNumber(

3640: if g_debug then
3641: hr_utility.set_location(l_proc, 60);
3642: end if;
3643:
3644: l_next_period_ovn := wf_engine.GetItemAttrNumber(
3645: itemtype => p_itemtype,
3646: itemkey => p_itemkey,
3647: aname => 'NEXT_APP_BB_OVN');
3648:

Line 3649: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3645: itemtype => p_itemtype,
3646: itemkey => p_itemkey,
3647: aname => 'NEXT_APP_BB_OVN');
3648:
3649: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3650: itemkey => p_itemkey,
3651: aname => 'APP_BB_ID',
3652: avalue => l_next_period_id);
3653:

Line 3654: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3650: itemkey => p_itemkey,
3651: aname => 'APP_BB_ID',
3652: avalue => l_next_period_id);
3653:
3654: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3655: itemkey => p_itemkey,
3656: aname => 'APP_BB_OVN',
3657: avalue => l_next_period_ovn);
3658:

Line 3659: wf_engine.SetItemAttrText(itemtype => p_itemtype,

3655: itemkey => p_itemkey,
3656: aname => 'APP_BB_OVN',
3657: avalue => l_next_period_ovn);
3658:
3659: wf_engine.SetItemAttrText(itemtype => p_itemtype,
3660: itemkey => p_itemkey,
3661: aname => 'APR_REJ_REASON',
3662: avalue => '');
3663:

Line 3664: wf_engine.SetItemAttrText(itemtype => p_itemtype,

3660: itemkey => p_itemkey,
3661: aname => 'APR_REJ_REASON',
3662: avalue => '');
3663:
3664: wf_engine.SetItemAttrText(itemtype => p_itemtype,
3665: itemkey => p_itemkey,
3666: aname => 'APPROVAL_STATUS',
3667: avalue => '');
3668: