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

Line 371: wf_engine.SetItemAttrText (

367: l_api_name VARCHAR2(20) := 'Init_New_Lines';
368:
369: BEGIN
370:
371: wf_engine.SetItemAttrText (
372: itemtype => p_itemtype ,
373: itemkey => p_itemkey,
374: aname => 'NLTO',
375: avalue => l_new_line

Line 377: wf_engine.SetItemAttrText (

373: itemkey => p_itemkey,
374: aname => 'NLTO',
375: avalue => l_new_line
376: );
377: wf_engine.SetItemAttrText (
378: itemtype => p_itemtype,
379: itemkey => p_itemkey,
380: aname => 'NLTL',
381: avalue => l_new_line

Line 383: wf_engine.SetItemAttrText (

379: itemkey => p_itemkey,
380: aname => 'NLTL',
381: avalue => l_new_line
382: );
383: wf_engine.SetItemAttrText (
384: itemtype => p_itemtype,
385: itemkey => p_itemkey,
386: aname => 'NLTS',
387: avalue => l_new_line

Line 389: wf_engine.SetItemAttrText (

385: itemkey => p_itemkey,
386: aname => 'NLTS',
387: avalue => l_new_line
388: );
389: wf_engine.SetItemAttrText (
390: itemtype => p_itemtype,
391: itemkey => p_itemkey,
392: aname => 'NLTD',
393: avalue => l_new_line

Line 418: wf_engine.SetItemAttrText (

414: p_itemkey IN VARCHAR2) is
415: l_api_name VARCHAR2(20) := 'Hide_Owner_Line';
416: BEGIN
417:
418: wf_engine.SetItemAttrText (
419: itemtype => p_itemtype,
420: itemkey => p_itemkey,
421: aname => 'NLTO',
422: avalue => NULL

Line 424: wf_engine.SetItemAttrText (

420: itemkey => p_itemkey,
421: aname => 'NLTO',
422: avalue => NULL
423: );
424: wf_engine.SetItemAttrText (
425: itemtype => p_itemtype,
426: itemkey => p_itemkey,
427: aname => 'NLHO',
428: avalue => NULL

Line 430: wf_engine.SetItemAttrText (

426: itemkey => p_itemkey,
427: aname => 'NLHO',
428: avalue => NULL
429: );
430: wf_engine.SetItemAttrText (
431: itemtype => p_itemtype,
432: itemkey => p_itemkey,
433: aname => 'EOOV',
434: avalue => NULL

Line 436: wf_engine.SetItemAttrText (

432: itemkey => p_itemkey,
433: aname => 'EOOV',
434: avalue => NULL
435: );
436: wf_engine.SetItemAttrText (
437: itemtype => p_itemtype,
438: itemkey => p_itemkey,
439: aname => 'OWNER_NAME_OLD',
440: avalue => NULL

Line 442: wf_engine.SetItemAttrText (

438: itemkey => p_itemkey,
439: aname => 'OWNER_NAME_OLD',
440: avalue => NULL
441: );
442: wf_engine.SetItemAttrText (
443: itemtype => p_itemtype,
444: itemkey => p_itemkey,
445: aname => 'EONV',
446: avalue => NULL

Line 448: wf_engine.SetItemAttrText (

444: itemkey => p_itemkey,
445: aname => 'EONV',
446: avalue => NULL
447: );
448: wf_engine.SetItemAttrText (
449: itemtype => p_itemtype,
450: itemkey => p_itemkey,
451: aname => 'OWNER_NAME_C',
452: avalue => NULL

Line 475: wf_engine.SetItemAttrText (

471: p_itemkey IN VARCHAR2) is
472: l_api_name VARCHAR2(20) := 'Hide_Status_Line';
473:
474: BEGIN
475: wf_engine.SetItemAttrText (
476: itemtype => p_itemtype,
477: itemkey => p_itemkey,
478: aname => 'NLTS',
479: avalue => NULL

Line 481: wf_engine.SetItemAttrText (

477: itemkey => p_itemkey,
478: aname => 'NLTS',
479: avalue => NULL
480: );
481: wf_engine.SetItemAttrText (
482: itemtype => p_itemtype,
483: itemkey => p_itemkey,
484: aname => 'NLHS',
485: avalue => NULL

Line 487: wf_engine.SetItemAttrText (

483: itemkey => p_itemkey,
484: aname => 'NLHS',
485: avalue => NULL
486: );
487: wf_engine.SetItemAttrText (
488: itemtype => p_itemtype,
489: itemkey => p_itemkey,
490: aname => 'ESOV',
491: avalue => NULL

Line 493: wf_engine.SetItemAttrText (

489: itemkey => p_itemkey,
490: aname => 'ESOV',
491: avalue => NULL
492: );
493: wf_engine.SetItemAttrText (
494: itemtype => p_itemtype,
495: itemkey => p_itemkey,
496: aname => 'ESC_STATUS_OLD',
497: avalue => NULL

Line 499: wf_engine.SetItemAttrText (

495: itemkey => p_itemkey,
496: aname => 'ESC_STATUS_OLD',
497: avalue => NULL
498: );
499: wf_engine.SetItemAttrText (
500: itemtype => p_itemtype,
501: itemkey => p_itemkey,
502: aname => 'ESNV',
503: avalue => NULL

Line 506: wf_engine.SetItemAttrText (

502: aname => 'ESNV',
503: avalue => NULL
504: );
505:
506: wf_engine.SetItemAttrText (
507: itemtype => p_itemtype,
508: itemkey => p_itemkey,
509: aname => 'ESC_STATUS',
510: avalue => NULL

Line 536: wf_engine.SetItemAttrText (

532: l_api_name VARCHAR2(20) := 'Hide_Level_Line';
533:
534: BEGIN
535:
536: wf_engine.SetItemAttrText (
537: itemtype => p_itemtype,
538: itemkey => p_itemkey,
539: aname => 'NLTL',
540: avalue => NULL

Line 542: wf_engine.SetItemAttrText (

538: itemkey => p_itemkey,
539: aname => 'NLTL',
540: avalue => NULL
541: );
542: wf_engine.SetItemAttrText (
543: itemtype => p_itemtype,
544: itemkey => p_itemkey,
545: aname => 'NLHL',
546: avalue => NULL

Line 548: wf_engine.SetItemAttrText (

544: itemkey => p_itemkey,
545: aname => 'NLHL',
546: avalue => NULL
547: );
548: wf_engine.SetItemAttrText (
549: itemtype => p_itemtype,
550: itemkey => p_itemkey,
551: aname => 'ELOV',
552: avalue => NULL

Line 554: wf_engine.SetItemAttrText (

550: itemkey => p_itemkey,
551: aname => 'ELOV',
552: avalue => NULL
553: );
554: wf_engine.SetItemAttrText (
555: itemtype => p_itemtype,
556: itemkey => p_itemkey,
557: aname => 'ESC_LEVEL_OLD',
558: avalue => NULL

Line 560: wf_engine.SetItemAttrText (

556: itemkey => p_itemkey,
557: aname => 'ESC_LEVEL_OLD',
558: avalue => NULL
559: );
560: wf_engine.SetItemAttrText (
561: itemtype => p_itemtype,
562: itemkey => p_itemkey,
563: aname => 'ELNV',
564: avalue => NULL

Line 566: wf_engine.SetItemAttrText (

562: itemkey => p_itemkey,
563: aname => 'ELNV',
564: avalue => NULL
565: );
566: wf_engine.SetItemAttrText (
567: itemtype => p_itemtype,
568: itemkey => p_itemkey,
569: aname => 'ESC_LEVEL',
570: avalue => NULL

Line 595: wf_engine.SetItemAttrText (

591: l_api_name VARCHAR2(20) := 'Hide_Target_Line';
592:
593: BEGIN
594:
595: wf_engine.SetItemAttrText (
596: itemtype => p_itemtype,
597: itemkey => p_itemkey,
598: aname => 'NLTD',
599: avalue => NULL

Line 601: wf_engine.SetItemAttrText (

597: itemkey => p_itemkey,
598: aname => 'NLTD',
599: avalue => NULL
600: );
601: wf_engine.SetItemAttrText (
602: itemtype => p_itemtype,
603: itemkey => p_itemkey,
604: aname => 'NLHD',
605: avalue => NULL

Line 607: wf_engine.SetItemAttrText (

603: itemkey => p_itemkey,
604: aname => 'NLHD',
605: avalue => NULL
606: );
607: wf_engine.SetItemAttrText (
608: itemtype => p_itemtype,
609: itemkey => p_itemkey,
610: aname => 'ETDOV',
611: avalue => NULL

Line 613: wf_engine.SetItemAttrDate (

609: itemkey => p_itemkey,
610: aname => 'ETDOV',
611: avalue => NULL
612: );
613: wf_engine.SetItemAttrDate (
614: itemtype => p_itemtype,
615: itemkey => p_itemkey,
616: aname => 'TARGET_DATE_OLD',
617: avalue => NULL

Line 619: wf_engine.SetItemAttrText (

615: itemkey => p_itemkey,
616: aname => 'TARGET_DATE_OLD',
617: avalue => NULL
618: );
619: wf_engine.SetItemAttrText (
620: itemtype => p_itemtype,
621: itemkey => p_itemkey,
622: aname => 'ETDNV',
623: avalue => NULL

Line 625: wf_engine.SetItemAttrText (

621: itemkey => p_itemkey,
622: aname => 'ETDNV',
623: avalue => NULL
624: );
625: wf_engine.SetItemAttrText (
626: itemtype => p_itemtype,
627: itemkey => p_itemkey,
628: aname => 'TARGET_DATE',
629: avalue => NULL

Line 1246: wf_engine.CreateProcess (

1242: l_itemkey := to_char(p_task_id) || to_char(l_wf_key);
1243: x_wf_process_id := l_itemkey;
1244:
1245:
1246: wf_engine.CreateProcess (
1247: itemtype => p_wf_item_type_name,
1248: itemkey => l_itemkey,
1249: process => p_wf_process_name
1250: );

Line 1252: wf_engine.SetItemUserKey (

1248: itemkey => l_itemkey,
1249: process => p_wf_process_name
1250: );
1251:
1252: wf_engine.SetItemUserKey (
1253: itemtype => p_wf_item_type_name,
1254: itemkey => l_itemkey,
1255: userkey => task_details_rec.task_name
1256: );

Line 1258: wf_engine.SetItemAttrText (

1254: itemkey => l_itemkey,
1255: userkey => task_details_rec.task_name
1256: );
1257:
1258: wf_engine.SetItemAttrText (
1259: itemtype => p_wf_item_type_name,
1260: itemkey => l_itemkey,
1261: aname => 'TASK_NUMBER',
1262: avalue => task_details_rec.task_number

Line 1265: wf_engine.SetItemAttrText (

1261: aname => 'TASK_NUMBER',
1262: avalue => task_details_rec.task_number
1263: );
1264:
1265: wf_engine.SetItemAttrText (
1266: itemtype => p_wf_item_type_name,
1267: itemkey => l_itemkey,
1268: aname => 'TASK_DESC',
1269: avalue => task_details_rec.description

Line 1276: wf_engine.SetItemAttrText (

1272: open c_esc_status(task_details_rec.task_status_id);
1273: fetch c_esc_status into l_esc_status;
1274: close c_esc_status;
1275:
1276: wf_engine.SetItemAttrText (
1277: itemtype => p_wf_item_type_name,
1278: itemkey => l_itemkey,
1279: aname => 'ESC_STATUS',
1280: avalue => l_esc_status

Line 1287: wf_engine.SetItemAttrText (

1283: open c_esc_level(task_details_rec.escalation_level);
1284: fetch c_esc_level into l_esc_level;
1285: close c_esc_level;
1286:
1287: wf_engine.SetItemAttrText (
1288: itemtype => p_wf_item_type_name,
1289: itemkey => l_itemkey,
1290: aname => 'ESC_LEVEL',
1291: avalue => l_esc_level

Line 1298: wf_engine.SetItemAttrText (

1294: open c_cust_name;
1295: fetch c_cust_name into l_customer_name;
1296: close c_cust_name;
1297:
1298: wf_engine.SetItemAttrText (
1299: itemtype => p_wf_item_type_name,
1300: itemkey => l_itemkey,
1301: aname => 'CUST_NAME',
1302: avalue => l_customer_name

Line 1305: wf_engine.SetItemAttrDate (

1301: aname => 'CUST_NAME',
1302: avalue => l_customer_name
1303: );
1304:
1305: wf_engine.SetItemAttrDate (
1306: itemtype => p_wf_item_type_name,
1307: itemkey => l_itemkey,
1308: aname => 'DATE_OPENED',
1309: avalue => task_details_rec.date_opened

Line 1312: wf_engine.SetItemAttrDate (

1308: aname => 'DATE_OPENED',
1309: avalue => task_details_rec.date_opened
1310: );
1311:
1312: wf_engine.SetItemAttrDate (
1313: itemtype => p_wf_item_type_name,
1314: itemkey => l_itemkey,
1315: aname => 'DATE_CHANGED',
1316: avalue => task_details_rec.date_changed

Line 1325: wf_engine.SetItemAttrText (

1321: get_user_name(task_details_rec.create_id,
1322: l_user_name,
1323: l_temp_status);
1324:
1325: wf_engine.SetItemAttrText (
1326: itemtype => p_wf_item_type_name,
1327: itemkey => l_itemkey,
1328: aname => 'CREATE_NAME',
1329: avalue => l_user_name

Line 1338: wf_engine.SetItemAttrText (

1334: get_user_name(task_details_rec.update_id,
1335: l_user_name,
1336: l_temp_status);
1337:
1338: wf_engine.SetItemAttrText (
1339: itemtype => p_wf_item_type_name,
1340: itemkey => l_itemkey,
1341: aname => 'CHANGE_NAME',
1342: avalue => l_user_name

Line 1345: wf_engine.SetItemAttrDate (

1341: aname => 'CHANGE_NAME',
1342: avalue => l_user_name
1343: );
1344:
1345: wf_engine.SetItemAttrDate (
1346: itemtype => p_wf_item_type_name,
1347: itemkey => l_itemkey,
1348: aname => 'TARGET_DATE',
1349: avalue => task_details_rec.target_date

Line 1368: wf_engine.SetItemAttrText (

1364:
1365: end if;
1366:
1367:
1368: wf_engine.SetItemAttrText (
1369: itemtype => p_wf_item_type_name,
1370: itemkey => l_itemkey,
1371: aname => 'OWNER_NAME',
1372: avalue => l_owner_name

Line 1375: wf_engine.SetItemAttrText (

1371: aname => 'OWNER_NAME',
1372: avalue => l_owner_name
1373: );
1374:
1375: wf_engine.SetItemAttrText (
1376: itemtype => p_wf_item_type_name,
1377: itemkey => l_itemkey,
1378: aname => 'OWNER_NAME_C',
1379: avalue => l_owner_name

Line 1443: wf_engine.SetItemAttrText (

1439: end if;
1440:
1441: end if;
1442:
1443: wf_engine.SetItemAttrText (
1444: itemtype => p_wf_item_type_name,
1445: itemkey => l_itemkey,
1446: aname => 'EVENT',
1447: avalue => l_event

Line 1455: wf_engine.SetItemAttrText (

1451:
1452:
1453: if (l_notif_type = 'S') then -- for single doc escalation
1454:
1455: wf_engine.SetItemAttrText (
1456: itemtype => p_wf_item_type_name,
1457: itemkey => l_itemkey,
1458: aname => 'DOC_TYPE',
1459: avalue => l_doc_type

Line 1462: wf_engine.SetItemAttrText (

1458: aname => 'DOC_TYPE',
1459: avalue => l_doc_type
1460: );
1461:
1462: wf_engine.SetItemAttrText (
1463: itemtype => p_wf_item_type_name,
1464: itemkey => l_itemkey,
1465: aname => 'DOC_NUMBER',
1466: avalue => l_doc_number

Line 1469: wf_engine.SetItemAttrText (

1465: aname => 'DOC_NUMBER',
1466: avalue => l_doc_number
1467: );
1468:
1469: wf_engine.SetItemAttrText (
1470: itemtype => p_wf_item_type_name,
1471: itemkey => l_itemkey,
1472: aname => 'DOC_OWNER',
1473: avalue => l_owner_name

Line 1476: wf_engine.SetItemAttrText (

1472: aname => 'DOC_OWNER',
1473: avalue => l_owner_name
1474: );
1475: else -- for multi doc escalation
1476: wf_engine.SetItemAttrText (
1477: itemtype => p_wf_item_type_name,
1478: itemkey => l_itemkey,
1479: aname => 'DOC_DETAILS_T',
1480: avalue => l_doc_details_t

Line 1482: wf_engine.SetItemAttrText (

1478: itemkey => l_itemkey,
1479: aname => 'DOC_DETAILS_T',
1480: avalue => l_doc_details_t
1481: );
1482: wf_engine.SetItemAttrText (
1483: itemtype => p_wf_item_type_name,
1484: itemkey => l_itemkey,
1485: aname => 'DOC_DETAILS_H',
1486: avalue => l_doc_details_h

Line 1511: wf_engine.SetItemAttrText (

1507:
1508: l_owner_name := get_resource_name(p_old_owner_type_code, p_old_owner_id);
1509:
1510:
1511: wf_engine.SetItemAttrText (
1512: itemtype => p_wf_item_type_name,
1513: itemkey => l_itemkey,
1514: aname => 'OWNER_NAME_OLD',
1515: avalue => l_owner_name

Line 1517: wf_engine.SetItemAttrText (

1513: itemkey => l_itemkey,
1514: aname => 'OWNER_NAME_OLD',
1515: avalue => l_owner_name
1516: );
1517: wf_engine.SetItemAttrText (
1518: itemtype => p_wf_item_type_name,
1519: itemkey => l_itemkey,
1520: aname => 'NLTO',
1521: avalue => l_new_line

Line 1554: wf_engine.SetItemAttrText (

1550: end if;
1551:
1552: close c_esc_status;
1553:
1554: wf_engine.SetItemAttrText (
1555: itemtype => p_wf_item_type_name,
1556: itemkey => l_itemkey,
1557: aname => 'ESC_STATUS_OLD',
1558: avalue => l_esc_status

Line 1560: wf_engine.SetItemAttrText (

1556: itemkey => l_itemkey,
1557: aname => 'ESC_STATUS_OLD',
1558: avalue => l_esc_status
1559: );
1560: wf_engine.SetItemAttrText (
1561: itemtype => p_wf_item_type_name,
1562: itemkey => l_itemkey,
1563: aname => 'NLTS',
1564: avalue => l_new_line

Line 1603: wf_engine.SetItemAttrText (

1599: end if;
1600: end if;
1601: close c_esc_old_level;
1602:
1603: wf_engine.SetItemAttrText (
1604: itemtype => p_wf_item_type_name,
1605: itemkey => l_itemkey,
1606: aname => 'ESC_LEVEL_OLD',
1607: avalue => l_esc_level

Line 1610: wf_engine.SetItemAttrText (

1606: aname => 'ESC_LEVEL_OLD',
1607: avalue => l_esc_level
1608: );
1609:
1610: wf_engine.SetItemAttrText (
1611: itemtype => p_wf_item_type_name,
1612: itemkey => l_itemkey,
1613: aname => 'NLTL',
1614: avalue => l_new_line

Line 1629: wf_engine.SetItemAttrDate (

1625: -------------------------------------------------------------------------
1626:
1627: if p_target_date_changed = 'Y' then
1628:
1629: wf_engine.SetItemAttrDate (
1630: itemtype => p_wf_item_type_name,
1631: itemkey => l_itemkey,
1632: aname => 'TARGET_DATE_OLD',
1633: avalue => p_old_target_date

Line 1635: wf_engine.SetItemAttrText (

1631: itemkey => l_itemkey,
1632: aname => 'TARGET_DATE_OLD',
1633: avalue => p_old_target_date
1634: );
1635: wf_engine.SetItemAttrText (
1636: itemtype => p_wf_item_type_name,
1637: itemkey => l_itemkey,
1638: aname => 'NLTD',
1639: avalue => l_new_line

Line 1668: wf_engine.SetItemAttrNumber(

1664: -------------------------------------------------------------------------
1665:
1666: l_counter := jtf_ec_workflow_pkg.NotifList.COUNT;
1667:
1668: wf_engine.SetItemAttrNumber(
1669: itemtype => p_wf_item_type_name,
1670: itemkey => l_itemkey,
1671: aname => 'LIST_COUNTER',
1672: avalue => 1

Line 1675: wf_engine.SetItemAttrNumber(

1671: aname => 'LIST_COUNTER',
1672: avalue => 1
1673: );
1674:
1675: wf_engine.SetItemAttrNumber(
1676: itemtype => p_wf_item_type_name,
1677: itemkey => l_itemkey,
1678: aname => 'PERFORMER_LIMIT',
1679: avalue => l_counter

Line 1682: WF_ENGINE.StartProcess

1678: aname => 'PERFORMER_LIMIT',
1679: avalue => l_counter
1680: );
1681:
1682: WF_ENGINE.StartProcess
1683: (
1684: itemtype => p_wf_item_type_name,
1685: itemkey => l_itemkey
1686: );

Line 1786: wf_engine.GetItemAttrText (

1782: -- Return process to run
1783: --
1784:
1785: l_resultout :=
1786: wf_engine.GetItemAttrText (
1787: itemtype => itemtype,
1788: itemkey => itemkey,
1789: aname => 'EVENT'
1790: );

Line 1851: wf_engine.GetItemAttrText (

1847: --
1848: -- Return process to run
1849: --
1850: l_event :=
1851: wf_engine.GetItemAttrText (
1852: itemtype => itemtype,
1853: itemkey => itemkey,
1854: aname => 'EVENT'
1855: );

Line 1858: wf_engine.SetItemAttrText (

1854: aname => 'EVENT'
1855: );
1856:
1857: if l_event = 'ESC_DOC_CREATED_S' then
1858: wf_engine.SetItemAttrText (
1859: itemtype => itemtype,
1860: itemkey => itemkey,
1861: aname => 'MESSAGE_NAME',
1862: avalue => 'MSG_ESC_DOC_CREATED_S'

Line 1866: wf_engine.SetItemAttrText (

1862: avalue => 'MSG_ESC_DOC_CREATED_S'
1863: );
1864:
1865: elsif l_event = 'ESC_DOC_CREATED_M' then
1866: wf_engine.SetItemAttrText (
1867: itemtype => itemtype,
1868: itemkey => itemkey,
1869: aname => 'MESSAGE_NAME',
1870: avalue => 'MSG_ESC_DOC_CREATED_M'

Line 1874: wf_engine.SetItemAttrText (

1870: avalue => 'MSG_ESC_DOC_CREATED_M'
1871: );
1872:
1873: elsif l_event = 'ESC_DOC_CHANGED_S' then
1874: wf_engine.SetItemAttrText (
1875: itemtype => itemtype,
1876: itemkey => itemkey,
1877: aname => 'MESSAGE_NAME',
1878: avalue => 'MSG_ESC_DOC_CHANGED_S'

Line 1882: wf_engine.SetItemAttrText (

1878: avalue => 'MSG_ESC_DOC_CHANGED_S'
1879: );
1880:
1881: elsif l_event = 'ESC_DOC_CHANGED_M' then
1882: wf_engine.SetItemAttrText (
1883: itemtype => itemtype,
1884: itemkey => itemkey,
1885: aname => 'MESSAGE_NAME',
1886: avalue => 'MSG_ESC_DOC_CHANGED_M'

Line 1951: l_counter := wf_engine.GetItemAttrNumber(

1947: --
1948: -- Return process to run
1949: --
1950:
1951: l_counter := wf_engine.GetItemAttrNumber(
1952: itemtype => itemtype,
1953: itemkey => itemkey,
1954: aname => 'LIST_COUNTER'
1955: );

Line 1961: wf_engine.SetItemAttrText(

1957: l_role := jtf_ec_workflow_pkg.NotifList(l_counter).Name;
1958:
1959: if l_role is not NULL then
1960:
1961: wf_engine.SetItemAttrText(
1962: itemtype => itemtype,
1963: itemkey => itemkey,
1964: aname => 'MESSAGE_RECIPIENT',
1965: avalue => l_role

Line 1971: wf_engine.SetItemAttrNumber(

1967: end if;
1968:
1969: l_counter := l_counter + 1;
1970:
1971: wf_engine.SetItemAttrNumber(
1972: itemtype => itemtype,
1973: itemkey => itemkey,
1974: aname => 'LIST_COUNTER',
1975: avalue => l_counter