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

Line 516: p_notif_action_code := wf_engine.getitemattrtext

512: end if;
513:
514: --The values for the recipient action code and recipient code are obtained via the safe method.
515:
516: p_notif_action_code := wf_engine.getitemattrtext
517: (itemtype => p_item_type ,
518: itemkey => p_item_key ,
519: aname => hxc_approval_wf_helper.c_action_code_attribute,
520: ignore_notfound => true);

Line 522: p_notif_recipient_code := wf_engine.getitemattrtext

518: itemkey => p_item_key ,
519: aname => hxc_approval_wf_helper.c_action_code_attribute,
520: ignore_notfound => true);
521:
522: p_notif_recipient_code := wf_engine.getitemattrtext
523: (itemtype => p_item_type,
524: itemkey => p_item_key ,
525: aname => hxc_approval_wf_helper.c_recipient_code_attribute,
526: ignore_notfound => true);

Line 555: p_tc_bbid:= wf_engine.GetItemAttrNumber

551: close c_get_app_comp_id;
552:
553: END if;
554:
555: p_tc_bbid:= wf_engine.GetItemAttrNumber
556: (itemtype => p_item_type,
557: itemkey => p_item_key,
558: aname => 'TC_BLD_BLK_ID');
559: p_tc_bbovn:= wf_engine.GetItemAttrNumber

Line 559: p_tc_bbovn:= wf_engine.GetItemAttrNumber

555: p_tc_bbid:= wf_engine.GetItemAttrNumber
556: (itemtype => p_item_type,
557: itemkey => p_item_key,
558: aname => 'TC_BLD_BLK_ID');
559: p_tc_bbovn:= wf_engine.GetItemAttrNumber
560: (itemtype => p_item_type,
561: itemkey => p_item_key,
562: aname => 'TC_BLD_BLK_OVN');
563:

Line 666: wf_engine.setitemattrtext

662: --process does not fail.
663:
664: if(item_attribute_value_exists(p_item_type,p_item_key,c_action_code_attribute)) then
665:
666: wf_engine.setitemattrtext
667: (itemtype => p_item_type,
668: itemkey => p_item_key,
669: aname => c_action_code_attribute,
670: avalue => p_notif_action_code

Line 675: wf_engine.additemattr

671: );
672:
673: else
674:
675: wf_engine.additemattr
676: (itemtype => p_item_type,
677: itemkey => p_item_key,
678: aname =>c_action_code_attribute,
679: text_value => p_notif_action_code

Line 686: wf_engine.setitemattrtext

682: END if;
683:
684: if(item_attribute_value_exists(p_item_type,p_item_key,c_recipient_code_attribute)) then
685:
686: wf_engine.setitemattrtext
687: (itemtype => p_item_type,
688: itemkey => p_item_key,
689: aname => c_recipient_code_attribute,
690: avalue => p_notif_recipient_code

Line 695: wf_engine.additemattr

691: );
692:
693: else
694:
695: wf_engine.additemattr
696: (itemtype => p_item_type,
697: itemkey => p_item_key,
698: aname => c_recipient_code_attribute,
699: text_value => p_notif_recipient_code

Line 1091: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,

1087: if g_debug then
1088: hr_utility.set_location(l_proc, 10);
1089: end if;
1090:
1091: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
1092: itemkey => itemkey,
1093: aname => 'APP_BB_ID');
1094:
1095: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 1095: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => itemtype,

1091: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
1092: itemkey => itemkey,
1093: aname => 'APP_BB_ID');
1094:
1095: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
1096: itemkey => itemkey,
1097: aname => 'APP_BB_OVN');
1098:
1099: l_timecard_id := wf_engine.GetItemAttrNumber

Line 1099: l_timecard_id := wf_engine.GetItemAttrNumber

1095: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
1096: itemkey => itemkey,
1097: aname => 'APP_BB_OVN');
1098:
1099: l_timecard_id := wf_engine.GetItemAttrNumber
1100: (itemtype => itemtype,
1101: itemkey => itemkey,
1102: aname => 'TC_BLD_BLK_ID');
1103: l_timecard_ovn := wf_engine.GetItemAttrNumber

Line 1103: l_timecard_ovn := wf_engine.GetItemAttrNumber

1099: l_timecard_id := wf_engine.GetItemAttrNumber
1100: (itemtype => itemtype,
1101: itemkey => itemkey,
1102: aname => 'TC_BLD_BLK_ID');
1103: l_timecard_ovn := wf_engine.GetItemAttrNumber
1104: (itemtype => itemtype,
1105: itemkey => itemkey,
1106: aname => 'TC_BLD_BLK_OVN');
1107:

Line 1125: l_effective_end_date := wf_engine.GetItemAttrDate(

1121: END if;
1122:
1123: close c_tc_info;
1124:
1125: l_effective_end_date := wf_engine.GetItemAttrDate(
1126: itemtype => itemtype,
1127: itemkey => itemkey,
1128: aname => 'APP_END_DATE');
1129:

Line 1130: l_effective_start_date := wf_engine.GetItemAttrDate(

1126: itemtype => itemtype,
1127: itemkey => itemkey,
1128: aname => 'APP_END_DATE');
1129:
1130: l_effective_start_date := wf_engine.GetItemAttrDate(
1131: itemtype => itemtype,
1132: itemkey => itemkey,
1133: aname => 'APP_START_DATE');
1134:

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

1185: end if;
1186:
1187: -- set FROM ROLE to Worker Role
1188: l_tc_from_role :=find_role_for_recipient(hxc_app_comp_notifications_api.c_recipient_worker,l_timecard_id,l_timecard_ovn);
1189: wf_engine.SetItemAttrText(itemtype => itemtype,
1190: itemkey => itemkey,
1191: aname => 'TC_FROM_ROLE',
1192: avalue => l_tc_from_role);
1193: --set TITLE

Line 1200: wf_engine.SetItemAttrText(

1196: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1197:
1198: l_title := fnd_message.get();
1199:
1200: wf_engine.SetItemAttrText(
1201: itemtype => itemtype,
1202: itemkey => itemkey,
1203: aname => 'TITLE',
1204: avalue => l_title);

Line 1207: wf_engine.SetItemAttrText

1203: aname => 'TITLE',
1204: avalue => l_title);
1205:
1206: --set DESCRIPTION
1207: wf_engine.SetItemAttrText
1208: (itemtype => itemtype,
1209: itemkey => itemkey,
1210: aname => 'DESCRIPTION',
1211: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));

Line 1220: wf_engine.SetItemAttrText(

1216: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1217:
1218: l_fyi_subject :=fnd_message.get();
1219:
1220: wf_engine.SetItemAttrText(
1221: itemtype => itemtype,
1222: itemkey => itemkey,
1223: aname => 'FYI_SUBJECT',
1224: avalue => l_fyi_subject);

Line 1244: wf_engine.SetItemAttrText(

1240: hr_utility.raise_error;
1241: end;
1242:
1243: end if;
1244: wf_engine.SetItemAttrText(
1245: itemtype => itemtype,
1246: itemkey => itemkey,
1247: aname => 'FYI_RECIPIENT_LOGIN',
1248: avalue =>l_worker_role);

Line 1249: wf_engine.SetItemAttrText(

1245: itemtype => itemtype,
1246: itemkey => itemkey,
1247: aname => 'FYI_RECIPIENT_LOGIN',
1248: avalue =>l_worker_role);
1249: wf_engine.SetItemAttrText(
1250: itemtype => itemtype,
1251: itemkey => itemkey,
1252: aname => '#HIDE_REASSIGN',
1253: avalue => 'Y');

Line 1254: wf_engine.SetItemAttrText(

1250: itemtype => itemtype,
1251: itemkey => itemkey,
1252: aname => '#HIDE_REASSIGN',
1253: avalue => 'Y');
1254: wf_engine.SetItemAttrText(
1255: itemtype => itemtype,
1256: itemkey => itemkey,
1257: aname => '#HIDE_MOREINFO',
1258: avalue => 'Y');

Line 1266: l_tc_from_role :=wf_engine.GetItemAttrText(

1262: if g_debug then
1263: hr_utility.set_location(l_proc, 80);
1264: end if;
1265: --set TC_FROM_ROLE
1266: l_tc_from_role :=wf_engine.GetItemAttrText(
1267: itemtype => itemtype,
1268: itemkey => itemkey,
1269: aname => 'APR_NAME');
1270: wf_engine.SetItemAttrText(itemtype => itemtype,

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

1266: l_tc_from_role :=wf_engine.GetItemAttrText(
1267: itemtype => itemtype,
1268: itemkey => itemkey,
1269: aname => 'APR_NAME');
1270: wf_engine.SetItemAttrText(itemtype => itemtype,
1271: itemkey => itemkey,
1272: aname => 'TC_FROM_ROLE',
1273: avalue => l_tc_from_role);
1274: --set TITLE

Line 1281: wf_engine.SetItemAttrText(

1277: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1278:
1279: l_title := fnd_message.get();
1280:
1281: wf_engine.SetItemAttrText(
1282: itemtype => itemtype,
1283: itemkey => itemkey,
1284: aname => 'TITLE',
1285: avalue => l_title);

Line 1287: wf_engine.SetItemAttrText

1283: itemkey => itemkey,
1284: aname => 'TITLE',
1285: avalue => l_title);
1286: --set DESCRIPTION
1287: wf_engine.SetItemAttrText
1288: (itemtype => itemtype,
1289: itemkey => itemkey,
1290: aname => 'DESCRIPTION',
1291: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));

Line 1302: wf_engine.SetItemAttrText(

1298: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1299:
1300: l_fyi_subject :=fnd_message.get();
1301:
1302: wf_engine.SetItemAttrText(
1303: itemtype => itemtype,
1304: itemkey => itemkey,
1305: aname => 'FYI_SUBJECT',
1306: avalue => l_fyi_subject);

Line 1309: wf_engine.SetItemAttrText(

1305: aname => 'FYI_SUBJECT',
1306: avalue => l_fyi_subject);
1307:
1308: --set FYI_RECIPIENT_LOGIN
1309: wf_engine.SetItemAttrText(
1310: itemtype => itemtype,
1311: itemkey => itemkey,
1312: aname => 'FYI_RECIPIENT_LOGIN',
1313: avalue => l_preparer_role);

Line 1315: wf_engine.SetItemAttrText(

1311: itemkey => itemkey,
1312: aname => 'FYI_RECIPIENT_LOGIN',
1313: avalue => l_preparer_role);
1314:
1315: wf_engine.SetItemAttrText(
1316: itemtype => itemtype,
1317: itemkey => itemkey,
1318: aname => '#HIDE_REASSIGN',
1319: avalue => 'Y');

Line 1320: wf_engine.SetItemAttrText(

1316: itemtype => itemtype,
1317: itemkey => itemkey,
1318: aname => '#HIDE_REASSIGN',
1319: avalue => 'Y');
1320: wf_engine.SetItemAttrText(
1321: itemtype => itemtype,
1322: itemkey => itemkey,
1323: aname => '#HIDE_MOREINFO',
1324: avalue => 'N');

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

1329: end if;
1330: -- We need to attach timecard Id to Application Id..it looks crazy...
1331: --but we need to do this as the TIMECARD attribute is using APP_BB_ID
1332: --in the URL.
1333: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1334: itemkey => itemkey,
1335: aname => 'APP_BB_ID',
1336: avalue => l_timecard_id);
1337: wf_engine.SetItemAttrText(

Line 1337: wf_engine.SetItemAttrText(

1333: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1334: itemkey => itemkey,
1335: aname => 'APP_BB_ID',
1336: avalue => l_timecard_id);
1337: wf_engine.SetItemAttrText(
1338: itemtype => itemtype,
1339: itemkey => itemkey,
1340: aname => 'FORMATTED_APP_START_DATE',
1341: avalue => to_char(l_tc_start_date,'YYYY/MM/DD'));

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

1339: itemkey => itemkey,
1340: aname => 'FORMATTED_APP_START_DATE',
1341: avalue => to_char(l_tc_start_date,'YYYY/MM/DD'));
1342: --set TC_FROM_ROLE
1343: wf_engine.SetItemAttrText(itemtype => itemtype,
1344: itemkey => itemkey,
1345: aname => 'TC_FROM_ROLE',
1346: avalue => l_preparer_role);
1347:

Line 1355: wf_engine.SetItemAttrText(

1351: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1352:
1353: l_title := fnd_message.get();
1354:
1355: wf_engine.SetItemAttrText(
1356: itemtype => itemtype,
1357: itemkey => itemkey,
1358: aname => 'TITLE',
1359: avalue => l_title);

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

1357: itemkey => itemkey,
1358: aname => 'TITLE',
1359: avalue => l_title);
1360: --set DESCRIPTION
1361: wf_engine.SetItemAttrText(itemtype => itemtype,
1362: itemkey => itemkey,
1363: aname => 'DESCRIPTION',
1364: avalue => hxc_find_notify_aprs_pkg.get_description_tc(l_timecard_id,l_timecard_ovn));
1365: --set FYI_SUBJECT

Line 1376: wf_engine.SetItemAttrText(

1372: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);
1373:
1374: l_fyi_subject :=fnd_message.get();
1375:
1376: wf_engine.SetItemAttrText(
1377: itemtype => itemtype,
1378: itemkey => itemkey,
1379: aname => 'FYI_SUBJECT',
1380: avalue => l_fyi_subject);

Line 1401: wf_engine.SetItemAttrText(

1397: hr_utility.raise_error;
1398: end;
1399:
1400: end if;
1401: wf_engine.SetItemAttrText(
1402: itemtype => itemtype,
1403: itemkey => itemkey,
1404: aname => 'FYI_RECIPIENT_LOGIN',
1405: avalue => l_worker_role);

Line 1406: wf_engine.SetItemAttrText(

1402: itemtype => itemtype,
1403: itemkey => itemkey,
1404: aname => 'FYI_RECIPIENT_LOGIN',
1405: avalue => l_worker_role);
1406: wf_engine.SetItemAttrText(
1407: itemtype => itemtype,
1408: itemkey => itemkey,
1409: aname => '#HIDE_REASSIGN',
1410: avalue => 'Y');

Line 1411: wf_engine.SetItemAttrText(

1407: itemtype => itemtype,
1408: itemkey => itemkey,
1409: aname => '#HIDE_REASSIGN',
1410: avalue => 'Y');
1411: wf_engine.SetItemAttrText(
1412: itemtype => itemtype,
1413: itemkey => itemkey,
1414: aname => '#HIDE_MOREINFO',
1415: avalue => 'N');

Line 1416: wf_engine.SetItemAttrText(

1412: itemtype => itemtype,
1413: itemkey => itemkey,
1414: aname => '#HIDE_MOREINFO',
1415: avalue => 'N');
1416: wf_engine.SetItemAttrText(
1417: itemtype => itemtype,
1418: itemkey => itemkey,
1419: aname => 'RESOURCE_ID',
1420: avalue => l_resource_id);

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

1430: return;
1431: end if;
1432:
1433: --set TC_FROM_ROLE
1434: wf_engine.SetItemAttrText(itemtype => itemtype,
1435: itemkey => itemkey,
1436: aname => 'TC_FROM_ROLE',
1437: avalue => l_worker_role);
1438: --set TITLE

Line 1446: wf_engine.SetItemAttrText(

1442: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1443:
1444: l_title := fnd_message.get();
1445:
1446: wf_engine.SetItemAttrText(
1447: itemtype => itemtype,
1448: itemkey => itemkey,
1449: aname => 'TITLE',
1450: avalue => l_title);

Line 1452: wf_engine.SetItemAttrText

1448: itemkey => itemkey,
1449: aname => 'TITLE',
1450: avalue => l_title);
1451: --set DESCRIPTION
1452: wf_engine.SetItemAttrText
1453: (itemtype => itemtype,
1454: itemkey => itemkey,
1455: aname => 'DESCRIPTION',
1456: avalue => hxc_find_notify_aprs_pkg.get_description_date(l_effective_start_date,l_effective_end_date,l_resource_id));

Line 1459: l_tc_to_role :=wf_engine.GetItemAttrText(

1455: aname => 'DESCRIPTION',
1456: avalue => hxc_find_notify_aprs_pkg.get_description_date(l_effective_start_date,l_effective_end_date,l_resource_id));
1457:
1458: --set FYI_SUBJECT
1459: l_tc_to_role :=wf_engine.GetItemAttrText(
1460: itemtype => itemtype,
1461: itemkey => itemkey,
1462: aname => 'TC_APPROVER_FROM_ROLE');
1463:

Line 1471: wf_engine.SetItemAttrText(

1467: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1468:
1469: l_fyi_subject :=fnd_message.get();
1470:
1471: wf_engine.SetItemAttrText(
1472: itemtype => itemtype,
1473: itemkey => itemkey,
1474: aname => 'FYI_SUBJECT',
1475: avalue => l_fyi_subject);

Line 1478: wf_engine.SetItemAttrText(

1474: aname => 'FYI_SUBJECT',
1475: avalue => l_fyi_subject);
1476: --set FYI_RECIPIENT_LOGIN
1477:
1478: wf_engine.SetItemAttrText(
1479: itemtype => itemtype,
1480: itemkey => itemkey,
1481: aname => 'FYI_RECIPIENT_LOGIN',
1482: avalue =>l_supervisor_role );

Line 1483: wf_engine.SetItemAttrText(

1479: itemtype => itemtype,
1480: itemkey => itemkey,
1481: aname => 'FYI_RECIPIENT_LOGIN',
1482: avalue =>l_supervisor_role );
1483: wf_engine.SetItemAttrText(
1484: itemtype => itemtype,
1485: itemkey => itemkey,
1486: aname => '#HIDE_REASSIGN',
1487: avalue => 'Y');

Line 1488: wf_engine.SetItemAttrText(

1484: itemtype => itemtype,
1485: itemkey => itemkey,
1486: aname => '#HIDE_REASSIGN',
1487: avalue => 'Y');
1488: wf_engine.SetItemAttrText(
1489: itemtype => itemtype,
1490: itemkey => itemkey,
1491: aname => '#HIDE_MOREINFO',
1492: avalue => 'N');

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

1496: if g_debug then
1497: hr_utility.set_location(l_proc, 110);
1498: end if;
1499:
1500: wf_engine.SetItemAttrText(itemtype => itemtype,
1501: itemkey => itemkey,
1502: aname => 'TC_FROM_ROLE',
1503: avalue => l_preparer_role);
1504: --set TITLE

Line 1511: wf_engine.SetItemAttrText(

1507: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1508:
1509: l_title := fnd_message.get();
1510:
1511: wf_engine.SetItemAttrText(
1512: itemtype => itemtype,
1513: itemkey => itemkey,
1514: aname => 'TITLE',
1515: avalue => l_title);

Line 1517: wf_engine.SetItemAttrText

1513: itemkey => itemkey,
1514: aname => 'TITLE',
1515: avalue => l_title);
1516: --set DESCRIPTION
1517: wf_engine.SetItemAttrText
1518: (itemtype => itemtype,
1519: itemkey => itemkey,
1520: aname => 'DESCRIPTION',
1521: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));

Line 1524: l_apr_person_id :=wf_engine.GetItemAttrText(

1520: aname => 'DESCRIPTION',
1521: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));
1522:
1523: --set FYI_SUBJECT
1524: l_apr_person_id :=wf_engine.GetItemAttrText(
1525: itemtype => itemtype,
1526: itemkey => itemkey,
1527: aname => 'APR_PERSON_ID');
1528: l_supervisor_id :=hxc_find_notify_aprs_pkg.get_supervisor(l_apr_person_id,SYSDATE);

Line 1539: wf_engine.SetItemAttrText(

1535: fnd_message.set_token('SUPERVISOR_FULL_NAME',l_supervisor_name);
1536:
1537: l_fyi_subject :=fnd_message.get();
1538:
1539: wf_engine.SetItemAttrText(
1540: itemtype => itemtype,
1541: itemkey => itemkey,
1542: aname => 'FYI_SUBJECT',
1543: avalue => l_fyi_subject);

Line 1547: wf_engine.SetItemAttrText(

1543: avalue => l_fyi_subject);
1544: --set FYI_RECIPIENT_LOGIN
1545: l_tc_from_role :=hxc_find_notify_aprs_pkg.get_login(p_person_id => l_apr_person_id);
1546:
1547: wf_engine.SetItemAttrText(
1548: itemtype => itemtype,
1549: itemkey => itemkey,
1550: aname => 'FYI_RECIPIENT_LOGIN',
1551: avalue => l_tc_from_role);

Line 1553: wf_engine.SetItemAttrText(

1549: itemkey => itemkey,
1550: aname => 'FYI_RECIPIENT_LOGIN',
1551: avalue => l_tc_from_role);
1552:
1553: wf_engine.SetItemAttrText(
1554: itemtype => itemtype,
1555: itemkey => itemkey,
1556: aname => '#HIDE_REASSIGN',
1557: avalue => 'Y');

Line 1558: wf_engine.SetItemAttrText(

1554: itemtype => itemtype,
1555: itemkey => itemkey,
1556: aname => '#HIDE_REASSIGN',
1557: avalue => 'Y');
1558: wf_engine.SetItemAttrText(
1559: itemtype => itemtype,
1560: itemkey => itemkey,
1561: aname => '#HIDE_MOREINFO',
1562: avalue => 'N');

Line 1576: l_tc_from_role :=wf_engine.GetItemAttrText(

1572: if g_debug then
1573: hr_utility.set_location(l_proc, 120);
1574: end if;
1575: --set TC_FROM_ROLE
1576: l_tc_from_role :=wf_engine.GetItemAttrText(
1577: itemtype => itemtype,
1578: itemkey => itemkey,
1579: aname => 'APR_NAME');
1580: wf_engine.SetItemAttrText(itemtype => itemtype,

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

1576: l_tc_from_role :=wf_engine.GetItemAttrText(
1577: itemtype => itemtype,
1578: itemkey => itemkey,
1579: aname => 'APR_NAME');
1580: wf_engine.SetItemAttrText(itemtype => itemtype,
1581: itemkey => itemkey,
1582: aname => 'TC_FROM_ROLE',
1583: avalue => l_tc_from_role);
1584:

Line 1594: wf_engine.SetItemAttrText(

1590: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1591:
1592: l_fyi_subject :=fnd_message.get();
1593:
1594: wf_engine.SetItemAttrText(
1595: itemtype => itemtype,
1596: itemkey => itemkey,
1597: aname => 'FYI_SUBJECT',
1598: avalue => l_fyi_subject);

Line 1606: l_apr_rej_reason :=wf_engine.GetItemAttrText(itemtype => itemtype,

1602: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);
1603:
1604:
1605:
1606: l_apr_rej_reason :=wf_engine.GetItemAttrText(itemtype => itemtype,
1607: itemkey => itemkey,
1608: aname => 'APR_REJ_REASON');
1609:
1610: fnd_message.set_token('APR_REJ_REASON',l_apr_rej_reason);

Line 1614: wf_engine.SetItemAttrText(

1610: fnd_message.set_token('APR_REJ_REASON',l_apr_rej_reason);
1611:
1612: l_fyi_no_detail_body :=fnd_message.get();
1613:
1614: wf_engine.SetItemAttrText(
1615: itemtype => itemtype,
1616: itemkey => itemkey,
1617: aname => 'FYI_NO_DETAIL_BODY',
1618: avalue => l_fyi_no_detail_body);

Line 1621: wf_engine.SetItemAttrText(

1617: aname => 'FYI_NO_DETAIL_BODY',
1618: avalue => l_fyi_no_detail_body);
1619:
1620:
1621: wf_engine.SetItemAttrText(
1622: itemtype => itemtype,
1623: itemkey => itemkey,
1624: aname => 'FYI_RECIPIENT_LOGIN',
1625: avalue => l_preparer_role);

Line 1626: wf_engine.SetItemAttrText(

1622: itemtype => itemtype,
1623: itemkey => itemkey,
1624: aname => 'FYI_RECIPIENT_LOGIN',
1625: avalue => l_preparer_role);
1626: wf_engine.SetItemAttrText(
1627: itemtype => itemtype,
1628: itemkey => itemkey,
1629: aname => '#HIDE_REASSIGN',
1630: avalue => 'Y');

Line 1631: wf_engine.SetItemAttrText(

1627: itemtype => itemtype,
1628: itemkey => itemkey,
1629: aname => '#HIDE_REASSIGN',
1630: avalue => 'Y');
1631: wf_engine.SetItemAttrText(
1632: itemtype => itemtype,
1633: itemkey => itemkey,
1634: aname => '#HIDE_MOREINFO',
1635: avalue => 'N');

Line 1717: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,

1713: close get_result;
1714:
1715: if l_result <> 'RESTART' then
1716:
1717: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
1718: itemkey => itemkey,
1719: aname => 'APP_BB_ID');
1720: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
1721: itemkey => itemkey,

Line 1720: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => itemtype,

1716:
1717: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
1718: itemkey => itemkey,
1719: aname => 'APP_BB_ID');
1720: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
1721: itemkey => itemkey,
1722: aname => 'APP_BB_OVN');
1723:
1724: update hxc_app_period_summary