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 1092: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

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

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

Line 1100: l_timecard_id := wf_engine.GetItemAttrNumber

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

Line 1104: l_timecard_ovn := wf_engine.GetItemAttrNumber

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

Line 1126: l_effective_end_date := wf_engine.GetItemAttrDate(

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

Line 1131: l_effective_start_date := wf_engine.GetItemAttrDate(

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

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

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

Line 1201: wf_engine.SetItemAttrText(

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

Line 1208: wf_engine.SetItemAttrText

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

Line 1221: wf_engine.SetItemAttrText(

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

Line 1245: wf_engine.SetItemAttrText(

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

Line 1250: wf_engine.SetItemAttrText(

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

Line 1255: wf_engine.SetItemAttrText(

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

Line 1267: l_tc_from_role :=wf_engine.GetItemAttrText(

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

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

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

Line 1282: wf_engine.SetItemAttrText(

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

Line 1288: wf_engine.SetItemAttrText

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

Line 1303: wf_engine.SetItemAttrText(

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

Line 1310: wf_engine.SetItemAttrText(

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

Line 1316: wf_engine.SetItemAttrText(

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

Line 1321: wf_engine.SetItemAttrText(

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

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

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

Line 1338: wf_engine.SetItemAttrText(

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

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

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

Line 1356: wf_engine.SetItemAttrText(

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

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

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

Line 1393: wf_engine.SetItemAttrText(

1389: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);
1390:
1391: l_fyi_subject :=fnd_message.get();
1392:
1393: wf_engine.SetItemAttrText(
1394: itemtype => itemtype,
1395: itemkey => itemkey,
1396: aname => 'FYI_SUBJECT',
1397: avalue => l_fyi_subject);

Line 1418: wf_engine.SetItemAttrText(

1414: hr_utility.raise_error;
1415: end;
1416:
1417: end if;
1418: wf_engine.SetItemAttrText(
1419: itemtype => itemtype,
1420: itemkey => itemkey,
1421: aname => 'FYI_RECIPIENT_LOGIN',
1422: avalue => l_worker_role);

Line 1423: wf_engine.SetItemAttrText(

1419: itemtype => itemtype,
1420: itemkey => itemkey,
1421: aname => 'FYI_RECIPIENT_LOGIN',
1422: avalue => l_worker_role);
1423: wf_engine.SetItemAttrText(
1424: itemtype => itemtype,
1425: itemkey => itemkey,
1426: aname => '#HIDE_REASSIGN',
1427: avalue => 'Y');

Line 1428: wf_engine.SetItemAttrText(

1424: itemtype => itemtype,
1425: itemkey => itemkey,
1426: aname => '#HIDE_REASSIGN',
1427: avalue => 'Y');
1428: wf_engine.SetItemAttrText(
1429: itemtype => itemtype,
1430: itemkey => itemkey,
1431: aname => '#HIDE_MOREINFO',
1432: avalue => 'N');

Line 1433: wf_engine.SetItemAttrText(

1429: itemtype => itemtype,
1430: itemkey => itemkey,
1431: aname => '#HIDE_MOREINFO',
1432: avalue => 'N');
1433: wf_engine.SetItemAttrText(
1434: itemtype => itemtype,
1435: itemkey => itemkey,
1436: aname => 'RESOURCE_ID',
1437: avalue => l_resource_id);

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

1447: return;
1448: end if;
1449:
1450: --set TC_FROM_ROLE
1451: wf_engine.SetItemAttrText(itemtype => itemtype,
1452: itemkey => itemkey,
1453: aname => 'TC_FROM_ROLE',
1454: avalue => l_worker_role);
1455: --set TITLE

Line 1463: wf_engine.SetItemAttrText(

1459: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1460:
1461: l_title := fnd_message.get();
1462:
1463: wf_engine.SetItemAttrText(
1464: itemtype => itemtype,
1465: itemkey => itemkey,
1466: aname => 'TITLE',
1467: avalue => l_title);

Line 1469: wf_engine.SetItemAttrText

1465: itemkey => itemkey,
1466: aname => 'TITLE',
1467: avalue => l_title);
1468: --set DESCRIPTION
1469: wf_engine.SetItemAttrText
1470: (itemtype => itemtype,
1471: itemkey => itemkey,
1472: aname => 'DESCRIPTION',
1473: avalue => hxc_find_notify_aprs_pkg.get_description_date(l_effective_start_date,l_effective_end_date,l_resource_id));

Line 1476: l_tc_to_role :=wf_engine.GetItemAttrText(

1472: aname => 'DESCRIPTION',
1473: avalue => hxc_find_notify_aprs_pkg.get_description_date(l_effective_start_date,l_effective_end_date,l_resource_id));
1474:
1475: --set FYI_SUBJECT
1476: l_tc_to_role :=wf_engine.GetItemAttrText(
1477: itemtype => itemtype,
1478: itemkey => itemkey,
1479: aname => 'TC_APPROVER_FROM_ROLE');
1480:

Line 1488: wf_engine.SetItemAttrText(

1484: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1485:
1486: l_fyi_subject :=fnd_message.get();
1487:
1488: wf_engine.SetItemAttrText(
1489: itemtype => itemtype,
1490: itemkey => itemkey,
1491: aname => 'FYI_SUBJECT',
1492: avalue => l_fyi_subject);

Line 1495: wf_engine.SetItemAttrText(

1491: aname => 'FYI_SUBJECT',
1492: avalue => l_fyi_subject);
1493: --set FYI_RECIPIENT_LOGIN
1494:
1495: wf_engine.SetItemAttrText(
1496: itemtype => itemtype,
1497: itemkey => itemkey,
1498: aname => 'FYI_RECIPIENT_LOGIN',
1499: avalue =>l_supervisor_role );

Line 1500: wf_engine.SetItemAttrText(

1496: itemtype => itemtype,
1497: itemkey => itemkey,
1498: aname => 'FYI_RECIPIENT_LOGIN',
1499: avalue =>l_supervisor_role );
1500: wf_engine.SetItemAttrText(
1501: itemtype => itemtype,
1502: itemkey => itemkey,
1503: aname => '#HIDE_REASSIGN',
1504: avalue => 'Y');

Line 1505: wf_engine.SetItemAttrText(

1501: itemtype => itemtype,
1502: itemkey => itemkey,
1503: aname => '#HIDE_REASSIGN',
1504: avalue => 'Y');
1505: wf_engine.SetItemAttrText(
1506: itemtype => itemtype,
1507: itemkey => itemkey,
1508: aname => '#HIDE_MOREINFO',
1509: avalue => 'N');

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

1513: if g_debug then
1514: hr_utility.set_location(l_proc, 110);
1515: end if;
1516:
1517: wf_engine.SetItemAttrText(itemtype => itemtype,
1518: itemkey => itemkey,
1519: aname => 'TC_FROM_ROLE',
1520: avalue => l_preparer_role);
1521: --set TITLE

Line 1528: wf_engine.SetItemAttrText(

1524: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1525:
1526: l_title := fnd_message.get();
1527:
1528: wf_engine.SetItemAttrText(
1529: itemtype => itemtype,
1530: itemkey => itemkey,
1531: aname => 'TITLE',
1532: avalue => l_title);

Line 1534: wf_engine.SetItemAttrText

1530: itemkey => itemkey,
1531: aname => 'TITLE',
1532: avalue => l_title);
1533: --set DESCRIPTION
1534: wf_engine.SetItemAttrText
1535: (itemtype => itemtype,
1536: itemkey => itemkey,
1537: aname => 'DESCRIPTION',
1538: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));

Line 1541: l_apr_person_id :=wf_engine.GetItemAttrText(

1537: aname => 'DESCRIPTION',
1538: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));
1539:
1540: --set FYI_SUBJECT
1541: l_apr_person_id :=wf_engine.GetItemAttrText(
1542: itemtype => itemtype,
1543: itemkey => itemkey,
1544: aname => 'APR_PERSON_ID');
1545: l_supervisor_id :=hxc_find_notify_aprs_pkg.get_supervisor(l_apr_person_id,SYSDATE);

Line 1556: wf_engine.SetItemAttrText(

1552: fnd_message.set_token('SUPERVISOR_FULL_NAME',l_supervisor_name);
1553:
1554: l_fyi_subject :=fnd_message.get();
1555:
1556: wf_engine.SetItemAttrText(
1557: itemtype => itemtype,
1558: itemkey => itemkey,
1559: aname => 'FYI_SUBJECT',
1560: avalue => l_fyi_subject);

Line 1564: wf_engine.SetItemAttrText(

1560: avalue => l_fyi_subject);
1561: --set FYI_RECIPIENT_LOGIN
1562: l_tc_from_role :=hxc_find_notify_aprs_pkg.get_login(p_person_id => l_apr_person_id);
1563:
1564: wf_engine.SetItemAttrText(
1565: itemtype => itemtype,
1566: itemkey => itemkey,
1567: aname => 'FYI_RECIPIENT_LOGIN',
1568: avalue => l_tc_from_role);

Line 1570: wf_engine.SetItemAttrText(

1566: itemkey => itemkey,
1567: aname => 'FYI_RECIPIENT_LOGIN',
1568: avalue => l_tc_from_role);
1569:
1570: wf_engine.SetItemAttrText(
1571: itemtype => itemtype,
1572: itemkey => itemkey,
1573: aname => '#HIDE_REASSIGN',
1574: avalue => 'Y');

Line 1575: wf_engine.SetItemAttrText(

1571: itemtype => itemtype,
1572: itemkey => itemkey,
1573: aname => '#HIDE_REASSIGN',
1574: avalue => 'Y');
1575: wf_engine.SetItemAttrText(
1576: itemtype => itemtype,
1577: itemkey => itemkey,
1578: aname => '#HIDE_MOREINFO',
1579: avalue => 'N');

Line 1593: l_tc_from_role :=wf_engine.GetItemAttrText(

1589: if g_debug then
1590: hr_utility.set_location(l_proc, 120);
1591: end if;
1592: --set TC_FROM_ROLE
1593: l_tc_from_role :=wf_engine.GetItemAttrText(
1594: itemtype => itemtype,
1595: itemkey => itemkey,
1596: aname => 'APR_NAME');
1597: wf_engine.SetItemAttrText(itemtype => itemtype,

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

1593: l_tc_from_role :=wf_engine.GetItemAttrText(
1594: itemtype => itemtype,
1595: itemkey => itemkey,
1596: aname => 'APR_NAME');
1597: wf_engine.SetItemAttrText(itemtype => itemtype,
1598: itemkey => itemkey,
1599: aname => 'TC_FROM_ROLE',
1600: avalue => l_tc_from_role);
1601:

Line 1611: wf_engine.SetItemAttrText(

1607: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1608:
1609: l_fyi_subject :=fnd_message.get();
1610:
1611: wf_engine.SetItemAttrText(
1612: itemtype => itemtype,
1613: itemkey => itemkey,
1614: aname => 'FYI_SUBJECT',
1615: avalue => l_fyi_subject);

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

1619: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);
1620:
1621:
1622:
1623: l_apr_rej_reason :=wf_engine.GetItemAttrText(itemtype => itemtype,
1624: itemkey => itemkey,
1625: aname => 'APR_REJ_REASON');
1626:
1627: fnd_message.set_token('APR_REJ_REASON',l_apr_rej_reason);

Line 1631: wf_engine.SetItemAttrText(

1627: fnd_message.set_token('APR_REJ_REASON',l_apr_rej_reason);
1628:
1629: l_fyi_no_detail_body :=fnd_message.get();
1630:
1631: wf_engine.SetItemAttrText(
1632: itemtype => itemtype,
1633: itemkey => itemkey,
1634: aname => 'FYI_NO_DETAIL_BODY',
1635: avalue => l_fyi_no_detail_body);

Line 1638: wf_engine.SetItemAttrText(

1634: aname => 'FYI_NO_DETAIL_BODY',
1635: avalue => l_fyi_no_detail_body);
1636:
1637:
1638: wf_engine.SetItemAttrText(
1639: itemtype => itemtype,
1640: itemkey => itemkey,
1641: aname => 'FYI_RECIPIENT_LOGIN',
1642: avalue => l_preparer_role);

Line 1643: wf_engine.SetItemAttrText(

1639: itemtype => itemtype,
1640: itemkey => itemkey,
1641: aname => 'FYI_RECIPIENT_LOGIN',
1642: avalue => l_preparer_role);
1643: wf_engine.SetItemAttrText(
1644: itemtype => itemtype,
1645: itemkey => itemkey,
1646: aname => '#HIDE_REASSIGN',
1647: avalue => 'Y');

Line 1648: wf_engine.SetItemAttrText(

1644: itemtype => itemtype,
1645: itemkey => itemkey,
1646: aname => '#HIDE_REASSIGN',
1647: avalue => 'Y');
1648: wf_engine.SetItemAttrText(
1649: itemtype => itemtype,
1650: itemkey => itemkey,
1651: aname => '#HIDE_MOREINFO',
1652: avalue => 'N');

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

1730: close get_result;
1731:
1732: if l_result <> 'RESTART' then
1733:
1734: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
1735: itemkey => itemkey,
1736: aname => 'APP_BB_ID');
1737: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
1738: itemkey => itemkey,

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

1733:
1734: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
1735: itemkey => itemkey,
1736: aname => 'APP_BB_ID');
1737: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
1738: itemkey => itemkey,
1739: aname => 'APP_BB_OVN');
1740:
1741: update hxc_app_period_summary