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 834: l_tc_bb_id := wf_engine.GetItemAttrNumber(

830: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');
831: g_trace := '10';
832:
833: if p_funcmode = 'RUN' then
834: l_tc_bb_id := wf_engine.GetItemAttrNumber(
835: itemtype => p_itemtype,
836: itemkey => p_itemkey,
837: aname => 'TC_BLD_BLK_ID');
838:

Line 839: l_tc_bb_ovn := wf_engine.GetItemAttrNumber(

835: itemtype => p_itemtype,
836: itemkey => p_itemkey,
837: aname => 'TC_BLD_BLK_ID');
838:
839: l_tc_bb_ovn := wf_engine.GetItemAttrNumber(
840: itemtype => p_itemtype,
841: itemkey => p_itemkey,
842: aname => 'TC_BLD_BLK_OVN');
843:

Line 844: l_ap_bb_id := wf_engine.GetItemAttrNumber(

840: itemtype => p_itemtype,
841: itemkey => p_itemkey,
842: aname => 'TC_BLD_BLK_OVN');
843:
844: l_ap_bb_id := wf_engine.GetItemAttrNumber(
845: itemtype => p_itemtype,
846: itemkey => p_itemkey,
847: aname => 'APP_BB_ID');
848:

Line 849: l_ap_bb_ovn := wf_engine.GetItemAttrNumber(

845: itemtype => p_itemtype,
846: itemkey => p_itemkey,
847: aname => 'APP_BB_ID');
848:
849: l_ap_bb_ovn := wf_engine.GetItemAttrNumber(
850: itemtype => p_itemtype,
851: itemkey => p_itemkey,
852: aname => 'APP_BB_OVN');
853:

Line 938: wf_engine.SetItemAttrText(

934: g_trace := '60';
935:
936: -- set tokens used by all notifications
937: --
938: wf_engine.SetItemAttrText(
939: itemtype => p_itemtype,
940: itemkey => p_itemkey,
941: aname => 'TC_OWNER',
942: avalue => get_name(l_resource_id,l_tc_start_time)

Line 981: wf_engine.SetItemAttrText(

977:
978: g_trace := '100';
979:
980: --set role attribute
981: wf_engine.SetItemAttrText(
982: itemtype => p_itemtype,
983: itemkey => p_itemkey,
984: aname => 'TC_FROM_ROLE',
985: avalue => l_login);

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

985: avalue => l_login);
986:
987: g_trace := '110';
988:
989: wf_engine.SetItemAttrText(itemtype => p_itemtype,
990: itemkey => p_itemkey,
991: aname => 'TC_OWNER_SS_LOGIN',
992: avalue => l_login);
993:

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

992: avalue => l_login);
993:
994: g_trace := '120';
995:
996: wf_engine.SetItemAttrDate(itemtype => p_itemtype,
997: itemkey => p_itemkey,
998: aname => 'TC_START',
999: avalue => l_tc_start_time);
1000: g_trace := '130';

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

998: aname => 'TC_START',
999: avalue => l_tc_start_time);
1000: g_trace := '130';
1001:
1002: wf_engine.SetItemAttrDate(itemtype => p_itemtype,
1003: itemkey => p_itemkey,
1004: aname => 'TC_STOP',
1005: avalue => l_tc_stop_time);
1006:

Line 1021: wf_engine.SetItemAttrNumber(

1017: g_trace := '160';
1018: --
1019: -- set parameters required by next activity
1020: --
1021: wf_engine.SetItemAttrNumber(
1022: itemtype => p_itemtype,
1023: itemkey => p_itemkey,
1024: aname => 'APR_PERSON_ID',
1025: avalue => l_approval_mechanism_id);

Line 1033: wf_engine.SetItemAttrNumber(

1029:
1030: elsif l_approval_mechanism = 'HR_SUPERVISOR'
1031: then
1032: g_trace := '180';
1033: wf_engine.SetItemAttrNumber(
1034: itemtype => p_itemtype,
1035: itemkey => p_itemkey,
1036: aname => 'APR_PERSON_ID',
1037: avalue => l_resource_id);

Line 1047: wf_engine.SetItemAttrNumber(

1043:
1044: elsif l_approval_mechanism = 'FORMULA_MECHANISM'
1045: then
1046: g_trace := '200';
1047: wf_engine.SetItemAttrNumber(
1048: itemtype => p_itemtype,
1049: itemkey => p_itemkey,
1050: aname => 'FORMULA_ID',
1051: avalue => l_approval_mechanism_id);

Line 1060: wf_engine.SetItemAttrText(

1056: elsif l_approval_mechanism = 'WORKFLOW'
1057: then
1058:
1059: g_trace := '220';
1060: wf_engine.SetItemAttrText(
1061: itemtype => p_itemtype,
1062: itemkey => p_itemkey,
1063: aname => 'WF_ITEM_TYPE',
1064: avalue => l_wf_item_type);

Line 1066: wf_engine.SetItemAttrText(

1062: itemkey => p_itemkey,
1063: aname => 'WF_ITEM_TYPE',
1064: avalue => l_wf_item_type);
1065:
1066: wf_engine.SetItemAttrText(
1067: itemtype => p_itemtype,
1068: itemkey => p_itemkey,
1069: aname => 'WF_PROCESS_NAME',
1070: avalue => l_wf_name);

Line 1134: wf_engine.SetItemAttrText(

1130: l_real_approver := get_name(l_employee_id,sysdate);
1131: END IF;
1132:
1133:
1134: wf_engine.SetItemAttrText(
1135: itemtype => p_itemtype,
1136: itemkey => p_itemkey,
1137: aname => 'APR_NAME',
1138: avalue => l_real_approver

Line 1150: l_appr_ss_login := wf_engine.GetItemAttrText(

1146:
1147: We go by method 2
1148: */
1149:
1150: l_appr_ss_login := wf_engine.GetItemAttrText(
1151: itemtype => p_itemtype,
1152: itemkey => p_itemkey ,
1153: aname => 'APR_SS_LOGIN');
1154:

Line 1157: wf_engine.SetItemAttrText(

1153: aname => 'APR_SS_LOGIN');
1154:
1155:
1156: --Bug 5375656
1157: wf_engine.SetItemAttrText(
1158: itemtype => p_itemtype,
1159: itemkey => p_itemkey,
1160: aname => 'TC_APPROVER_FROM_ROLE',
1161: avalue => l_appr_ss_login

Line 1197: l_approvers_visited := wf_engine.GetItemAttrNumber(

1193: );
1194: --
1195: -- set variables for approval hierarchy
1196: --
1197: l_approvers_visited := wf_engine.GetItemAttrNumber(
1198: itemtype => p_itemtype,
1199: itemkey => p_itemkey,
1200: aname => 'APPROVERS_VISITED');
1201: if g_debug then

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

1200: aname => 'APPROVERS_VISITED');
1201: if g_debug then
1202: hr_utility.trace('l_approvers_visited=' || l_approvers_visited);
1203: end if;
1204: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
1205: itemkey => p_itemkey,
1206: aname => 'APPROVED_AT_LEVEL',
1207: avalue => l_approvers_visited);
1208:

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

1208:
1209: --
1210: -- set up attribute required for next activity
1211: --
1212: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1213: itemkey => p_itemkey,
1214: aname => 'APPROVAL_STATUS',
1215: avalue => 'APPROVED');
1216:

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

1258: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');
1259:
1260: if p_funcmode = 'RUN' then
1261: --
1262: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1263: itemkey => p_itemkey,
1264: aname => 'APPROVAL_STATUS',
1265: avalue => 'APPROVED');
1266:

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

1263: itemkey => p_itemkey,
1264: aname => 'APPROVAL_STATUS',
1265: avalue => 'APPROVED');
1266:
1267: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1268: itemkey => p_itemkey,
1269: aname => 'APR_REJ_REASON',
1270: avalue => 'TIMED_OUT');
1271:

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

1314: );
1315: --
1316: -- set up attribute required for next activity
1317: --
1318: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1319: itemkey => p_itemkey,
1320: aname => 'APPROVAL_STATUS',
1321: avalue => 'REJECTED');
1322:

Line 1439: l_ap_bb_id := wf_engine.GetItemAttrNumber(

1435: if g_debug then
1436: l_proc := g_pkg || 'find_project_manager';
1437: hr_utility.trace('in ' || l_proc);
1438: end if;
1439: l_ap_bb_id := wf_engine.GetItemAttrNumber(
1440: itemtype => p_itemtype,
1441: itemkey => p_itemkey,
1442: aname => 'APP_BB_ID');
1443:

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

1440: itemtype => p_itemtype,
1441: itemkey => p_itemkey,
1442: aname => 'APP_BB_ID');
1443:
1444: l_is_blank := wf_engine.GetItemAttrText(itemtype => p_itemtype,
1445: itemkey => p_itemkey,
1446: aname => 'IS_DIFF_TC',
1447: ignore_notfound => true);
1448:

Line 1497: wf_engine.SetItemAttrNumber(

1493: hr_utility.raise_error;
1494:
1495: END IF;
1496:
1497: wf_engine.SetItemAttrNumber(
1498: itemtype => p_itemtype,
1499: itemkey => p_itemkey,
1500: aname => 'APR_PERSON_ID',
1501: avalue => l_project_manager);

Line 1515: wf_engine.SetItemAttrNumber

1511: --
1512: l_project_manager := hxc_approval_wf_util.get_previous_approver
1513: (p_itemtype,p_itemkey,l_ap_bb_id);
1514: if(l_project_manager is not null) then
1515: wf_engine.SetItemAttrNumber
1516: (itemtype => p_itemtype,
1517: itemkey => p_itemkey,
1518: aname => 'APR_PERSON_ID',
1519: avalue => l_project_manager);

Line 1607: l_tc_bb_id := wf_engine.GetItemAttrNumber(

1603: IF (nvl(fnd_profile.value('HXC_DEBUG_CHECK_ENABLED'), 'N') = 'Y') THEN -- OTL: Debug Check Enabled
1604:
1605: IF p_funcmode = 'RUN' THEN
1606:
1607: l_tc_bb_id := wf_engine.GetItemAttrNumber(
1608: itemtype => p_itemtype,
1609: itemkey => p_itemkey,
1610: aname => 'TC_BLD_BLK_ID');
1611:

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

1676: if p_funcmode = 'RUN' then
1677: --
1678: -- set up attribute required for next activity
1679: --
1680: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1681: itemkey => p_itemkey,
1682: aname => 'APPROVAL_STATUS',
1683: avalue => 'APPROVED');
1684:

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

1681: itemkey => p_itemkey,
1682: aname => 'APPROVAL_STATUS',
1683: avalue => 'APPROVED');
1684:
1685: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1686: itemkey => p_itemkey,
1687: aname => 'APR_REJ_REASON',
1688: avalue => 'AUTO_APPROVE');
1689:

Line 1961: l_effective_end_date := wf_engine.GetItemAttrDate(

1957: if p_funcmode = 'RUN' then
1958: --
1959: -- all datetrack data should be valid for duration of application period
1960: --
1961: l_effective_end_date := wf_engine.GetItemAttrDate(
1962: itemtype => p_itemtype,
1963: itemkey => p_itemkey,
1964: aname => 'APP_END_DATE');
1965:

Line 1966: l_effective_start_date := wf_engine.GetItemAttrDate(

1962: itemtype => p_itemtype,
1963: itemkey => p_itemkey,
1964: aname => 'APP_END_DATE');
1965:
1966: l_effective_start_date := wf_engine.GetItemAttrDate(
1967: itemtype => p_itemtype,
1968: itemkey => p_itemkey,
1969: aname => 'APP_START_DATE');
1970:

Line 1971: l_apr_person_id := wf_engine.GetItemAttrNumber(

1967: itemtype => p_itemtype,
1968: itemkey => p_itemkey,
1969: aname => 'APP_START_DATE');
1970:
1971: l_apr_person_id := wf_engine.GetItemAttrNumber(
1972: itemtype => p_itemtype,
1973: itemkey => p_itemkey,
1974: aname => 'APR_PERSON_ID');
1975:

Line 1976: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(

1972: itemtype => p_itemtype,
1973: itemkey => p_itemkey,
1974: aname => 'APR_PERSON_ID');
1975:
1976: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(
1977: itemtype => p_itemtype,
1978: itemkey => p_itemkey,
1979: aname => 'APP_BB_ID');
1980: l_is_blank := wf_engine.GetItemAttrText(itemtype => p_itemtype,

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

1976: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(
1977: itemtype => p_itemtype,
1978: itemkey => p_itemkey,
1979: aname => 'APP_BB_ID');
1980: l_is_blank := wf_engine.GetItemAttrText(itemtype => p_itemtype,
1981: itemkey => p_itemkey ,
1982: aname => 'IS_DIFF_TC',
1983: ignore_notfound => true);
1984: --Added as part of OIT enhancement

Line 1985: l_resource_id := wf_engine.GetItemAttrNumber(

1981: itemkey => p_itemkey ,
1982: aname => 'IS_DIFF_TC',
1983: ignore_notfound => true);
1984: --Added as part of OIT enhancement
1985: l_resource_id := wf_engine.GetItemAttrNumber(
1986: itemtype => p_itemtype,
1987: itemkey => p_itemkey,
1988: aname => 'RESOURCE_ID');
1989:

Line 1997: wf_engine.SetItemAttrNumber(

1993: IF l_is_blank = 'Y' THEN
1994:
1995: l_apr_person_id := get_supervisor(l_resource_id, sysdate);
1996:
1997: wf_engine.SetItemAttrNumber(
1998: itemtype => p_itemtype,
1999: itemkey => p_itemkey,
2000: aname => 'APR_PERSON_ID',
2001: avalue => l_apr_person_id);

Line 2028: wf_engine.SetItemAttrText(

2024: end if;
2025:
2026: --sb_msgs_pkg.trace('approver login>' || l_login || '<');
2027:
2028: wf_engine.SetItemAttrText(
2029: itemtype => p_itemtype,
2030: itemkey => p_itemkey,
2031: aname => 'APR_SS_LOGIN',
2032: avalue => l_login);

Line 2039: wf_engine.SetItemAttrText(

2035: -- set information for notification
2036: --
2037:
2038:
2039: wf_engine.SetItemAttrText(
2040: itemtype => p_itemtype,
2041: itemkey => p_itemkey,
2042: aname => 'APR_NAME',
2043: avalue => get_name(l_apr_person_id,l_effective_end_date)

Line 2045: wf_engine.SetItemAttrText(

2041: itemkey => p_itemkey,
2042: aname => 'APR_NAME',
2043: avalue => get_name(l_apr_person_id,l_effective_end_date)
2044: );
2045: wf_engine.SetItemAttrText(
2046: itemtype => p_itemtype,
2047: itemkey => p_itemkey,
2048: aname => 'TC_APPROVER_FROM_ROLE',
2049: avalue => l_login);

Line 2057: wf_engine.SetItemAttrText(

2053: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2054:
2055: l_title := fnd_message.get();
2056:
2057: wf_engine.SetItemAttrText(
2058: itemtype => p_itemtype,
2059: itemkey => p_itemkey,
2060: aname => 'TITLE',
2061: avalue => l_title);

Line 2065: wf_engine.SetItemAttrText(

2061: avalue => l_title);
2062:
2063: l_otl_appr_id := l_appl_period_bb_id||'#'||p_itemkey;
2064:
2065: wf_engine.SetItemAttrText(
2066: itemtype => p_itemtype,
2067: itemkey => p_itemkey,
2068: aname => 'OTL_APPR_ID',
2069: avalue => l_otl_appr_id);

Line 2071: wf_engine.SetItemAttrText(

2067: itemkey => p_itemkey,
2068: aname => 'OTL_APPR_ID',
2069: avalue => l_otl_appr_id);
2070:
2071: wf_engine.SetItemAttrText(
2072: itemtype => p_itemtype,
2073: itemkey => p_itemkey,
2074: aname => 'DESCRIPTION',
2075: avalue => get_description(l_appl_period_bb_id));

Line 2077: wf_engine.SetItemAttrNumber(

2073: itemkey => p_itemkey,
2074: aname => 'DESCRIPTION',
2075: avalue => get_description(l_appl_period_bb_id));
2076:
2077: wf_engine.SetItemAttrNumber(
2078: itemtype => p_itemtype,
2079: itemkey => p_itemkey,
2080: aname => 'TOTAL_TC_HOURS',
2081: avalue => l_total_hours);

Line 2177: l_approvers_visited := wf_engine.GetItemAttrNumber(

2173: p_itemkey in varchar2)
2174: is
2175: l_approvers_visited number;
2176: begin
2177: l_approvers_visited := wf_engine.GetItemAttrNumber(
2178: itemtype => p_itemtype,
2179: itemkey => p_itemkey,
2180: aname => 'APPROVERS_VISITED');
2181:

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

2180: aname => 'APPROVERS_VISITED');
2181:
2182: l_approvers_visited := l_approvers_visited + 1;
2183:
2184: wf_engine.SetItemAttrText(itemtype => p_itemtype,
2185: itemkey => p_itemkey,
2186: aname => 'APPROVERS_VISITED',
2187: avalue => l_approvers_visited);
2188: end inc_approvers_visited;

Line 2387: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber

2383: if g_debug then
2384: hr_utility.trace('Begin hr_supervisor_approval');
2385: end if;
2386:
2387: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber
2388: (itemtype => p_itemtype,
2389: itemkey => p_itemkey,
2390: aname => 'TC_BLD_BLK_ID');
2391:

Line 2397: l_tc_ovn := wf_engine.GetItemAttrNumber

2393:
2394: if g_debug then
2395: hr_utility.trace('Timecard BB ID is : ' || to_char(l_tc_bld_blk_id));
2396: end if;
2397: l_tc_ovn := wf_engine.GetItemAttrNumber
2398: (itemtype => p_itemtype,
2399: itemkey => p_itemkey,
2400: aname => 'TC_BLD_BLK_OVN');
2401:

Line 2402: l_approvers_visited := wf_engine.GetItemAttrNumber(

2398: (itemtype => p_itemtype,
2399: itemkey => p_itemkey,
2400: aname => 'TC_BLD_BLK_OVN');
2401:
2402: l_approvers_visited := wf_engine.GetItemAttrNumber(
2403: itemtype => p_itemtype,
2404: itemkey => p_itemkey,
2405: aname => 'APPROVERS_VISITED');
2406:

Line 2407: l_time_recipient := wf_engine.GetItemAttrText(

2403: itemtype => p_itemtype,
2404: itemkey => p_itemkey,
2405: aname => 'APPROVERS_VISITED');
2406:
2407: l_time_recipient := wf_engine.GetItemAttrText(
2408: itemtype => p_itemtype,
2409: itemkey => p_itemkey ,
2410: aname => 'TIME_RECIPIENT_ID');
2411:

Line 2412: l_person_id := wf_engine.GetItemAttrNumber(

2408: itemtype => p_itemtype,
2409: itemkey => p_itemkey ,
2410: aname => 'TIME_RECIPIENT_ID');
2411:
2412: l_person_id := wf_engine.GetItemAttrNumber(
2413: itemtype => p_itemtype,
2414: itemkey => p_itemkey,
2415: aname => 'APR_PERSON_ID');
2416:

Line 2417: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(

2413: itemtype => p_itemtype,
2414: itemkey => p_itemkey,
2415: aname => 'APR_PERSON_ID');
2416:
2417: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(
2418: itemtype => p_itemtype,
2419: itemkey => p_itemkey,
2420: aname => 'APP_BB_ID');
2421: l_app_ovn :=wf_engine.GetItemAttrNumber(

Line 2421: l_app_ovn :=wf_engine.GetItemAttrNumber(

2417: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(
2418: itemtype => p_itemtype,
2419: itemkey => p_itemkey,
2420: aname => 'APP_BB_ID');
2421: l_app_ovn :=wf_engine.GetItemAttrNumber(
2422: itemtype => p_itemtype,
2423: itemkey => p_itemkey,
2424: aname => 'APP_BB_OVN');
2425: --OIT Change.

Line 2437: wf_engine.SetItemAttrNumber(

2433: close get_result;
2434:
2435: if l_result = 'RESEND' then
2436:
2437: wf_engine.SetItemAttrNumber(
2438: itemtype => p_itemtype,
2439: itemkey => p_itemkey,
2440: aname => 'APPROVERS_VISITED',
2441: avalue => l_approvers_visited-1);

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

2477: g_trace := 'extension code exists';
2478: if g_debug then
2479: hr_utility.trace('extension code exists');
2480: end if;
2481: wf_engine.SetItemAttrText(itemtype => p_itemtype,
2482: itemkey => p_itemkey,
2483: aname => 'APR_KEY_LEVEL',
2484: avalue => '100');
2485:

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

2482: itemkey => p_itemkey,
2483: aname => 'APR_KEY_LEVEL',
2484: avalue => '100');
2485:
2486: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
2487: itemkey => p_itemkey,
2488: aname => 'APPROVAL_TIMEOUT',
2489: avalue => 0);
2490:

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

2544: hr_utility.trace('end calling extension');
2545: end if;
2546: IF l_next_supervisor_id = -99
2547: THEN
2548: wf_engine.SetItemAttrText(itemtype => p_itemtype,
2549: itemkey => p_itemkey,
2550: aname => 'FINAL_APR',
2551: avalue => 'YES');
2552:

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

2570: hr_utility.raise_error;
2571:
2572: END IF;
2573: ELSE -- if no client extension, find supervisor from assignments
2574: wf_engine.SetItemAttrText(itemtype => p_itemtype,
2575: itemkey => p_itemkey,
2576: aname => 'FINAL_APR',
2577: avalue => 'NO_EXTENSION');
2578:

Line 2588: l_effective_end_date := wf_engine.GetItemAttrDate(

2584: end if;
2585:
2586: -- Bug 4202019. These variables need to be set outside this IF block.
2587: /*
2588: l_effective_end_date := wf_engine.GetItemAttrDate(
2589: itemtype => p_itemtype,
2590: itemkey => p_itemkey,
2591: aname => 'APP_END_DATE');
2592:

Line 2593: l_effective_start_date := wf_engine.GetItemAttrDate(

2589: itemtype => p_itemtype,
2590: itemkey => p_itemkey,
2591: aname => 'APP_END_DATE');
2592:
2593: l_effective_start_date := wf_engine.GetItemAttrDate(
2594: itemtype => p_itemtype,
2595: itemkey => p_itemkey,
2596: aname => 'APP_START_DATE');
2597: */

Line 2654: l_default_timeout := wf_engine.GetItemAttrText(

2650: g_trace :='allow timeout';
2651: if g_debug then
2652: hr_utility.trace('allow timeout');
2653: end if;
2654: l_default_timeout := wf_engine.GetItemAttrText(
2655: itemtype => p_itemtype,
2656: itemkey => p_itemkey,
2657: aname => 'DEFAULT_TIMEOUT');
2658:

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

2656: itemkey => p_itemkey,
2657: aname => 'DEFAULT_TIMEOUT');
2658:
2659:
2660: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
2661: itemkey => p_itemkey,
2662: aname => 'APPROVAL_TIMEOUT',
2663: avalue => l_default_timeout);
2664:

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

2672: g_trace :='NOT allow timeout';
2673: if g_debug then
2674: hr_utility.trace('NOT allow timeout');
2675: end if;
2676: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
2677: itemkey => p_itemkey,
2678: aname => 'APPROVAL_TIMEOUT',
2679: avalue => 0);
2680: end if;

Line 2719: wf_engine.SetItemAttrText(

2715: hr_utility.trace('increase approvers visited');
2716: end if;
2717: inc_approvers_visited(p_itemtype, p_itemkey);
2718:
2719: wf_engine.SetItemAttrText(
2720: itemtype => p_itemtype,
2721: itemkey => p_itemkey,
2722: aname => 'APR_SS_LOGIN',
2723: avalue => l_login

Line 2731: wf_engine.SetItemAttrText(

2727: if g_debug then
2728: hr_utility.trace('setting apr_name');
2729: end if;
2730: -- set information for notification
2731: wf_engine.SetItemAttrText(
2732: itemtype => p_itemtype,
2733: itemkey => p_itemkey,
2734: aname => 'APR_NAME',
2735: avalue => get_name(l_supervisor_id,sysdate)

Line 2742: wf_engine.SetItemAttrText(

2738: g_trace := 'setting from_role';
2739: if g_debug then
2740: hr_utility.trace('setting from_role');
2741: end if;
2742: wf_engine.SetItemAttrText(
2743: itemtype => p_itemtype,
2744: itemkey => p_itemkey,
2745: aname => 'TC_APPROVER_FROM_ROLE',
2746: avalue => l_login

Line 2756: wf_engine.SetItemAttrNumber(

2752: end if;
2753: --
2754: -- set supervisor's person id, ready for next iteration
2755:
2756: wf_engine.SetItemAttrNumber(
2757: itemtype => p_itemtype,
2758: itemkey => p_itemkey,
2759: aname => 'APR_PERSON_ID',
2760: avalue => l_supervisor_id);

Line 2764: l_effective_end_date := wf_engine.GetItemAttrDate(

2760: avalue => l_supervisor_id);
2761:
2762: -- Bug 4202019. These variables are set just before they are being used in the TITLE of Worklist notification.
2763:
2764: l_effective_end_date := wf_engine.GetItemAttrDate(
2765: itemtype => p_itemtype,
2766: itemkey => p_itemkey,
2767: aname => 'APP_END_DATE');
2768:

Line 2769: l_effective_start_date := wf_engine.GetItemAttrDate(

2765: itemtype => p_itemtype,
2766: itemkey => p_itemkey,
2767: aname => 'APP_END_DATE');
2768:
2769: l_effective_start_date := wf_engine.GetItemAttrDate(
2770: itemtype => p_itemtype,
2771: itemkey => p_itemkey,
2772: aname => 'APP_START_DATE');
2773:

Line 2781: wf_engine.SetItemAttrText(

2777: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2778:
2779: l_title := fnd_message.get();
2780:
2781: wf_engine.SetItemAttrText(
2782: itemtype => p_itemtype,
2783: itemkey => p_itemkey,
2784: aname => 'TITLE',
2785: avalue => l_title);

Line 2789: wf_engine.SetItemAttrText(

2785: avalue => l_title);
2786:
2787: l_otl_appr_id := l_appl_period_bb_id||'#'||p_itemkey;
2788:
2789: wf_engine.SetItemAttrText(
2790: itemtype => p_itemtype,
2791: itemkey => p_itemkey,
2792: aname => 'OTL_APPR_ID',
2793: avalue => l_otl_appr_id);

Line 2806: wf_engine.SetItemAttrText

2802: fnd_message.set_name('HXC','HXC_APPR_WF_DESC_NO_PA_MANAGER');
2803: l_description := l_description || fnd_message.get();
2804: end if;
2805:
2806: wf_engine.SetItemAttrText
2807: (itemtype => p_itemtype,
2808: itemkey => p_itemkey,
2809: aname => 'DESCRIPTION',
2810: avalue => l_description);

Line 2812: wf_engine.SetItemAttrNumber(

2808: itemkey => p_itemkey,
2809: aname => 'DESCRIPTION',
2810: avalue => l_description);
2811:
2812: wf_engine.SetItemAttrNumber(
2813: itemtype => p_itemtype,
2814: itemkey => p_itemkey,
2815: aname => 'TOTAL_TC_HOURS',
2816: avalue => l_total_hours);

Line 2882: l_approvers_visited := wf_engine.GetItemAttrNumber(

2878: --
2879: -- set variables for approval hierarchy
2880: --
2881: /*jxtan should move this to other procedure
2882: l_approvers_visited := wf_engine.GetItemAttrNumber(
2883: itemtype => p_itemtype,
2884: itemkey => p_itemkey,
2885: aname => 'APPROVERS_VISITED');
2886:

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

2883: itemtype => p_itemtype,
2884: itemkey => p_itemkey,
2885: aname => 'APPROVERS_VISITED');
2886:
2887: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
2888: itemkey => p_itemkey,
2889: aname => 'APPROVED_AT_LEVEL',
2890: avalue => l_approvers_visited);
2891:

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

2892: */
2893: --
2894: -- set up attribute required for next activity
2895: --
2896: wf_engine.SetItemAttrText(itemtype => p_itemtype,
2897: itemkey => p_itemkey,
2898: aname => 'APPROVAL_STATUS',
2899: avalue => 'APPROVED');
2900:

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

2941: if p_funcmode = 'RUN' then
2942: --
2943: -- set up attribute required for next activity
2944: --
2945: wf_engine.SetItemAttrText(itemtype => p_itemtype,
2946: itemkey => p_itemkey,
2947: aname => 'APPROVAL_STATUS',
2948: avalue => 'REJECTED');
2949: --

Line 3004: l_final_apr := wf_engine.GetItemAttrText(

3000: hr_utility.trace('is final approver');
3001: end if;
3002: if p_funcmode = 'RUN' then
3003:
3004: l_final_apr := wf_engine.GetItemAttrText(
3005: itemtype => p_itemtype,
3006: itemkey => p_itemkey,
3007: aname => 'FINAL_APR');
3008:

Line 3024: l_apr_person_id := wf_engine.GetItemAttrNumber(

3020: p_result := 'COMPLETE:N';
3021: return;
3022: END IF;
3023:
3024: l_apr_person_id := wf_engine.GetItemAttrNumber(
3025: itemtype => p_itemtype,
3026: itemkey => p_itemkey,
3027: aname => 'APR_PERSON_ID');
3028:

Line 3039: l_effective_date := wf_engine.GetItemAttrDate(

3035: if g_debug then
3036: hr_utility.trace('NOT final');
3037: end if;
3038:
3039: l_effective_date := wf_engine.GetItemAttrDate(
3040: itemtype => p_itemtype,
3041: itemkey => p_itemkey,
3042: aname => 'APP_END_DATE');
3043:

Line 3044: l_approval_timeout := wf_engine.GetItemAttrText(

3040: itemtype => p_itemtype,
3041: itemkey => p_itemkey,
3042: aname => 'APP_END_DATE');
3043:
3044: l_approval_timeout := wf_engine.GetItemAttrText(
3045: itemtype => p_itemtype,
3046: itemkey => p_itemkey,
3047: aname => 'APPROVAL_TIMEOUT');
3048:

Line 3049: l_default_timeout := wf_engine.GetItemAttrText(

3045: itemtype => p_itemtype,
3046: itemkey => p_itemkey,
3047: aname => 'APPROVAL_TIMEOUT');
3048:
3049: l_default_timeout := wf_engine.GetItemAttrText(
3050: itemtype => p_itemtype,
3051: itemkey => p_itemkey,
3052: aname => 'DEFAULT_TIMEOUT');
3053:

Line 3057: l_apr_key_level := wf_engine.GetItemAttrText(

3053:
3054:
3055: --sb_msgs_pkg.trace('current apr per id>' || l_apr_person_id || '<');
3056:
3057: l_apr_key_level := wf_engine.GetItemAttrText(
3058: itemtype => p_itemtype,
3059: itemkey => p_itemkey,
3060: aname => 'APR_KEY_LEVEL');
3061:

Line 3062: l_approved_at_level := wf_engine.GetItemAttrText(

3058: itemtype => p_itemtype,
3059: itemkey => p_itemkey,
3060: aname => 'APR_KEY_LEVEL');
3061:
3062: l_approved_at_level := wf_engine.GetItemAttrText(
3063: itemtype => p_itemtype,
3064: itemkey => p_itemkey,
3065: aname => 'APPROVED_AT_LEVEL');
3066:

Line 3067: l_approvers_visited := wf_engine.GetItemAttrText(

3063: itemtype => p_itemtype,
3064: itemkey => p_itemkey,
3065: aname => 'APPROVED_AT_LEVEL');
3066:
3067: l_approvers_visited := wf_engine.GetItemAttrText(
3068: itemtype => p_itemtype,
3069: itemkey => p_itemkey,
3070: aname => 'APPROVERS_VISITED');
3071:

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

3079: if g_debug then
3080: hr_utility.trace('not final 1');
3081: end if;
3082:
3083: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3084: itemkey => p_itemkey,
3085: aname => 'APPROVAL_TIMEOUT',
3086: avalue => l_default_timeout);
3087: p_result := 'COMPLETE:N';

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

3099: if get_supervisor(l_apr_person_id,
3100: SYSDATE) is not null then
3101: --sb_msgs_pkg.trace('22 - if');
3102:
3103: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3104: itemkey => p_itemkey,
3105: aname => 'APPROVAL_TIMEOUT',
3106: avalue => l_default_timeout);
3107: --

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

3109: -- next approver NOT allowed to timeout
3110: else
3111: --sb_msgs_pkg.trace('24 - else');
3112:
3113: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3114: itemkey => p_itemkey,
3115: aname => 'APPROVAL_TIMEOUT',
3116: avalue => 0);
3117: end if;

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

3142: if g_debug then
3143: hr_utility.trace('not final 3');
3144: end if;
3145:
3146: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3147: itemkey => p_itemkey,
3148: aname => 'APPROVAL_TIMEOUT',
3149: avalue => 0);
3150: p_result := 'COMPLETE:N';

Line 3157: l_approval_timeout := wf_engine.GetItemAttrText(

3153:
3154: --
3155: -- timeout to be used by next notification
3156: --
3157: l_approval_timeout := wf_engine.GetItemAttrText(
3158: itemtype => p_itemtype,
3159: itemkey => p_itemkey,
3160: aname => 'APPROVAL_TIMEOUT');
3161: --sb_msgs_pkg.trace('l_apr_timeout(A)>' || l_approval_timeout || '<');

Line 3216: l_tc_user_name := wf_engine.GetItemAttrText(

3212: end if;
3213:
3214: if p_funcmode = 'RUN' then
3215:
3216: l_tc_user_name := wf_engine.GetItemAttrText(
3217: itemtype => p_itemtype,
3218: itemkey => p_itemkey,
3219: aname => 'TC_OWNER_SS_LOGIN');
3220:

Line 3290: l_person_id := wf_engine.GetItemAttrNumber(

3286: l_proc := g_pkg || '.' || 'formula_selects_mechanism';
3287: hr_utility.set_location(l_proc, 10);
3288: end if;
3289:
3290: l_person_id := wf_engine.GetItemAttrNumber(
3291: itemtype => p_itemtype,
3292: itemkey => p_itemkey,
3293: aname => 'RESOURCE_ID');
3294: if p_funcmode = 'RUN' then

Line 3295: l_effective_date := wf_engine.GetItemAttrDate(

3291: itemtype => p_itemtype,
3292: itemkey => p_itemkey,
3293: aname => 'RESOURCE_ID');
3294: if p_funcmode = 'RUN' then
3295: l_effective_date := wf_engine.GetItemAttrDate(
3296: itemtype => p_itemtype,
3297: itemkey => p_itemkey,
3298: aname => 'APP_END_DATE');
3299:

Line 3300: l_formula_id := wf_engine.GetItemAttrNumber(

3296: itemtype => p_itemtype,
3297: itemkey => p_itemkey,
3298: aname => 'APP_END_DATE');
3299:
3300: l_formula_id := wf_engine.GetItemAttrNumber(
3301: itemtype => p_itemtype,
3302: itemkey => p_itemkey,
3303: aname => 'FORMULA_ID');
3304:

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

3337:
3338: if g_debug then
3339: hr_utility.set_location(l_proc, 40);
3340: end if;
3341: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3342: itemtype => p_itemtype,
3343: itemkey => p_itemkey,
3344: aname => 'TC_BLD_BLK_ID');
3345:

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

3346: elsif l_inputs(i).name = 'TIMECARD_BB_OVN' then
3347: if g_debug then
3348: hr_utility.set_location(l_proc, 50);
3349: end if;
3350: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3351: itemtype => p_itemtype,
3352: itemkey => p_itemkey,
3353: aname => 'TC_BLD_BLK_OVN');
3354:

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

3355: elsif l_inputs(i).name = 'APPLICATION_PERIOD_BB_ID' then
3356: if g_debug then
3357: hr_utility.set_location(l_proc, 60);
3358: end if;
3359: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3360: itemtype => p_itemtype,
3361: itemkey => p_itemkey,
3362: aname => 'APP_BB_ID');
3363:

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

3364: elsif l_inputs(i).name = 'APPLICATION_PERIOD_BB_OVN' then
3365: if g_debug then
3366: hr_utility.set_location(l_proc, 70);
3367: end if;
3368: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3369: itemtype => p_itemtype,
3370: itemkey => p_itemkey,
3371: aname => 'APP_BB_OVN');
3372:

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

3373: elsif l_inputs(i).name = 'TIME_RECIPIENT_ID' then
3374: if g_debug then
3375: hr_utility.set_location(l_proc, 80);
3376: end if;
3377: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3378: itemtype => p_itemtype,
3379: itemkey => p_itemkey,
3380: aname => 'TIME_RECIPIENT_ID');
3381: l_inputs(i).value := 5;

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

3383: elsif l_inputs(i).name = 'RESOURCE_ID' then
3384: if g_debug then
3385: hr_utility.set_location(l_proc, 90);
3386: end if;
3387: l_inputs(i).value := wf_engine.GetItemAttrNumber(
3388: itemtype => p_itemtype,
3389: itemkey => p_itemkey,
3390: aname => 'RESOURCE_ID');
3391:

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

3531: if g_debug then
3532: hr_utility.set_location(l_proc, 180);
3533: end if;
3534:
3535: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3536: itemkey => p_itemkey,
3537: aname => 'APR_PERSON_ID',
3538: avalue => l_approval_mechanism_id);
3539:

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

3549: --
3550: elsif l_approval_mechanism = 'HR_SUPERVISOR' then
3551: --sb_msgs_pkg.trace('formula selects hr supervisor approval');
3552:
3553: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3554: itemkey => p_itemkey,
3555: aname => 'APR_PERSON_ID',
3556: avalue => l_person_id);
3557:

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

3560: --
3561: elsif l_approval_mechanism = 'WORKFLOW' then
3562: --sb_msgs_pkg.trace('formula selects workflow approval');
3563:
3564: wf_engine.SetItemAttrText(itemtype => p_itemtype,
3565: itemkey => p_itemkey,
3566: aname => 'WF_ITEM_TYPE',
3567: avalue => l_wf_item_type);
3568:

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

3565: itemkey => p_itemkey,
3566: aname => 'WF_ITEM_TYPE',
3567: avalue => l_wf_item_type);
3568:
3569: wf_engine.SetItemAttrText(itemtype => p_itemtype,
3570: itemkey => p_itemkey,
3571: aname => 'WF_PROCESS_NAME',
3572: avalue => l_wf_process_name);
3573:

Line 3634: l_ap_bbid := wf_engine.GetItemAttrNumber(

3630: begin
3631: --sb_msgs_pkg.begin_call(l_proc);
3632: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');
3633:
3634: l_ap_bbid := wf_engine.GetItemAttrNumber(
3635: itemtype => p_itemtype,
3636: itemkey => p_itemkey,
3637: aname => 'APP_BB_ID');
3638:

Line 3639: l_ap_bbovn := wf_engine.GetItemAttrNumber(

3635: itemtype => p_itemtype,
3636: itemkey => p_itemkey,
3637: aname => 'APP_BB_ID');
3638:
3639: l_ap_bbovn := wf_engine.GetItemAttrNumber(
3640: itemtype => p_itemtype,
3641: itemkey => p_itemkey,
3642: aname => 'APP_BB_OVN');
3643:

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

3640: itemtype => p_itemtype,
3641: itemkey => p_itemkey,
3642: aname => 'APP_BB_OVN');
3643:
3644: l_wf_item_type := wf_engine.GetItemAttrText(itemtype => p_itemtype,
3645: itemkey => p_itemkey,
3646: aname => 'WF_ITEM_TYPE');
3647:
3648: l_wf_process_name := wf_engine.GetItemAttrText(

Line 3648: l_wf_process_name := wf_engine.GetItemAttrText(

3644: l_wf_item_type := wf_engine.GetItemAttrText(itemtype => p_itemtype,
3645: itemkey => p_itemkey,
3646: aname => 'WF_ITEM_TYPE');
3647:
3648: l_wf_process_name := wf_engine.GetItemAttrText(
3649: itemtype => p_itemtype,
3650: itemkey => p_itemkey,
3651: aname => 'WF_PROCESS_NAME');
3652:

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

3658: FROM DUAL;
3659:
3660: --sb_msgs_pkg.trace('l_item_key>' || l_item_key || '<');
3661:
3662: wf_engine.createProcess(l_wf_item_type, l_item_key, l_wf_process_name);
3663:
3664:
3665: --
3666: -- set attributes required by child workflow,

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

3665: --
3666: -- set attributes required by child workflow,
3667: -- set parent item type and key in child workflow process
3668: --
3669: wf_engine.SetItemAttrText(itemtype => l_wf_item_type,
3670: itemkey => l_item_key,
3671: aname => 'PARENT_ITEM_TYPE',
3672: avalue => p_itemtype);
3673:

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

3670: itemkey => l_item_key,
3671: aname => 'PARENT_ITEM_TYPE',
3672: avalue => p_itemtype);
3673:
3674: wf_engine.SetItemAttrText(itemtype => l_wf_item_type,
3675: itemkey => l_item_key,
3676: aname => 'PARENT_ITEM_KEY',
3677: avalue => p_itemkey);
3678: --

Line 3679: wf_engine.SetItemParent

3675: itemkey => l_item_key,
3676: aname => 'PARENT_ITEM_KEY',
3677: avalue => p_itemkey);
3678: --
3679: wf_engine.SetItemParent
3680: (itemtype => l_wf_item_type,
3681: itemkey => l_item_key,
3682: parent_itemtype => p_itemtype,
3683: parent_itemkey => p_itemkey,

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

3684: parent_context => NULL);
3685: --
3686: -- launch customer's workflow process
3687: --
3688: wf_engine.startProcess(l_wf_item_type, l_item_key);
3689:
3690: l_apr_person_id := wf_engine.GetItemAttrNumber(
3691: itemtype => p_itemtype,
3692: itemkey => p_itemkey,

Line 3690: l_apr_person_id := wf_engine.GetItemAttrNumber(

3686: -- launch customer's workflow process
3687: --
3688: wf_engine.startProcess(l_wf_item_type, l_item_key);
3689:
3690: l_apr_person_id := wf_engine.GetItemAttrNumber(
3691: itemtype => p_itemtype,
3692: itemkey => p_itemkey,
3693: aname => 'APR_PERSON_ID');
3694: l_resource_id := wf_engine.GetItemAttrNumber(

Line 3694: l_resource_id := wf_engine.GetItemAttrNumber(

3690: l_apr_person_id := wf_engine.GetItemAttrNumber(
3691: itemtype => p_itemtype,
3692: itemkey => p_itemkey,
3693: aname => 'APR_PERSON_ID');
3694: l_resource_id := wf_engine.GetItemAttrNumber(
3695: itemtype => p_itemtype,
3696: itemkey => p_itemkey,
3697: aname => 'RESOURCE_ID');
3698: --OIT Enhancement

Line 3756: l_wf_apr_result := wf_engine.GetItemAttrText(

3752: --sb_msgs_pkg.begin_call(l_proc);
3753: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');
3754:
3755: if p_funcmode = 'RUN' then
3756: l_wf_apr_result := wf_engine.GetItemAttrText(
3757: itemtype => p_itemtype,
3758: itemkey => p_itemkey,
3759: aname => 'WF_APPROVAL_RESULT');
3760: --sb_msgs_pkg.trace('WF_APPROVAL_RESULT>' || l_wf_apr_result || '<');

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

3758: itemkey => p_itemkey,
3759: aname => 'WF_APPROVAL_RESULT');
3760: --sb_msgs_pkg.trace('WF_APPROVAL_RESULT>' || l_wf_apr_result || '<');
3761:
3762: wf_engine.SetItemAttrText(itemtype => p_itemtype,
3763: itemkey => p_itemkey,
3764: aname => 'APPROVAL_STATUS',
3765: avalue => l_wf_apr_result);
3766:

Line 3841: l_next_period_id := wf_engine.GetItemAttrNumber(

3837: hr_utility.trace('in set next period');
3838: end if;
3839: IF p_funcmode = 'RUN'
3840: THEN
3841: l_next_period_id := wf_engine.GetItemAttrNumber(
3842: itemtype => p_itemtype,
3843: itemkey => p_itemkey,
3844: aname => 'NEXT_APP_BB_ID');
3845:

Line 3850: l_next_period_ovn := wf_engine.GetItemAttrNumber(

3846: if g_debug then
3847: hr_utility.set_location(l_proc, 60);
3848: end if;
3849:
3850: l_next_period_ovn := wf_engine.GetItemAttrNumber(
3851: itemtype => p_itemtype,
3852: itemkey => p_itemkey,
3853: aname => 'NEXT_APP_BB_OVN');
3854:

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

3851: itemtype => p_itemtype,
3852: itemkey => p_itemkey,
3853: aname => 'NEXT_APP_BB_OVN');
3854:
3855: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3856: itemkey => p_itemkey,
3857: aname => 'APP_BB_ID',
3858: avalue => l_next_period_id);
3859:

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

3856: itemkey => p_itemkey,
3857: aname => 'APP_BB_ID',
3858: avalue => l_next_period_id);
3859:
3860: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3861: itemkey => p_itemkey,
3862: aname => 'APP_BB_OVN',
3863: avalue => l_next_period_ovn);
3864:

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

3861: itemkey => p_itemkey,
3862: aname => 'APP_BB_OVN',
3863: avalue => l_next_period_ovn);
3864:
3865: wf_engine.SetItemAttrText(itemtype => p_itemtype,
3866: itemkey => p_itemkey,
3867: aname => 'APR_REJ_REASON',
3868: avalue => '');
3869:

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

3866: itemkey => p_itemkey,
3867: aname => 'APR_REJ_REASON',
3868: avalue => '');
3869:
3870: wf_engine.SetItemAttrText(itemtype => p_itemtype,
3871: itemkey => p_itemkey,
3872: aname => 'APPROVAL_STATUS',
3873: avalue => '');
3874: