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.

[Home] [Help]

APPS.IBU_REQ_PKG dependencies on WF_ENGINE

Line 1238: email_content Wf_Engine.TextTabTyp;

1234: context varchar2(100) := NULL;
1235: send_comment varchar2(100) := NULL;
1236: priority number := null;
1237:
1238: email_content Wf_Engine.TextTabTyp;
1239: email_content_count_end number := 1;
1240: temp_email_msg_body varchar2(32000) := null;
1241: truncateCharNum number := 0; -- added by wei ma
1242: retainCharNum number := 0;

Line 1520: content Wf_Engine.TextTabTyp,

1516: procedure StartEmailProcess (
1517: roleName in varchar2,
1518: srID in number,
1519: subject in varchar2,
1520: content Wf_Engine.TextTabTyp,
1521: ProcessOwner in varchar2,
1522: Workflowprocess in varchar2 ,
1523: item_type in varchar2,
1524: emailStyleSheet in varchar2,

Line 1539: mailAttrVals Wf_Engine.TextTabTyp ;

1535: seq number := 0;
1536: --create_seq varchar2(50) := 'create sequence IBU_SR_NOTIFICATION_S';
1537: --get_seq varchar2(50) := 'select ' || 'IBU_SR_NOTIFICATION_S' || '.nextval from dual';
1538: get_seq varchar2(50) := 'select ' || 'IBU_WF_ITEM_KEY_S' || '.nextval from dual';
1539: mailAttrVals Wf_Engine.TextTabTyp ;
1540: begin
1541: /* Get schema name */
1542: select user into l_user from dual;
1543:

Line 1559: wf_engine.CreateProcess(itemtype => ItemType,

1555: execute immediate get_seq into seq;
1556:
1557: ItemKey := roleName||seq;
1558:
1559: wf_engine.CreateProcess(itemtype => ItemType,
1560: itemkey => ItemKey,
1561: process => WorkflowProcess );
1562:
1563: wf_engine.SetItemUserKey(itemtype => Itemtype,

Line 1563: wf_engine.SetItemUserKey(itemtype => Itemtype,

1559: wf_engine.CreateProcess(itemtype => ItemType,
1560: itemkey => ItemKey,
1561: process => WorkflowProcess );
1562:
1563: wf_engine.SetItemUserKey(itemtype => Itemtype,
1564: itemkey => Itemkey,
1565: userkey => ItemUserKey);
1566:
1567: wf_engine.SetItemAttrText(itemtype => Itemtype,

Line 1567: wf_engine.SetItemAttrText(itemtype => Itemtype,

1563: wf_engine.SetItemUserKey(itemtype => Itemtype,
1564: itemkey => Itemkey,
1565: userkey => ItemUserKey);
1566:
1567: wf_engine.SetItemAttrText(itemtype => Itemtype,
1568: itemkey => Itemkey,
1569: aname => 'IBU_ROLE',
1570: avalue => roleName);
1571:

Line 1572: wf_engine.SetItemAttrText (itemtype => Itemtype,

1568: itemkey => Itemkey,
1569: aname => 'IBU_ROLE',
1570: avalue => roleName);
1571:
1572: wf_engine.SetItemAttrText (itemtype => Itemtype,
1573: itemkey => Itemkey,
1574: aname => 'IBU_SUBJECT_ITEM',
1575: avalue => subject);
1576:

Line 1577: wf_engine.SetItemAttrNumber(itemtype => Itemtype,

1573: itemkey => Itemkey,
1574: aname => 'IBU_SUBJECT_ITEM',
1575: avalue => subject);
1576:
1577: wf_engine.SetItemAttrNumber(itemtype => Itemtype,
1578: itemkey => Itemkey,
1579: aname => 'IBUSRID',
1580: avalue => srID);
1581:

Line 1582: wf_engine.SetItemAttrText(itemtype => Itemtype,

1578: itemkey => Itemkey,
1579: aname => 'IBUSRID',
1580: avalue => srID);
1581:
1582: wf_engine.SetItemAttrText(itemtype => Itemtype,
1583: itemkey => Itemkey,
1584: aname => 'IBUSTYLESHEET',
1585: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'|| emailStyleSheet);
1586:

Line 1587: wf_engine.SetItemAttrText(itemtype => Itemtype,

1583: itemkey => Itemkey,
1584: aname => 'IBUSTYLESHEET',
1585: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'|| emailStyleSheet);
1586:
1587: wf_engine.SetItemAttrText(itemtype => Itemtype,
1588: itemkey => Itemkey,
1589: aname => 'IBUBRANDING',
1590: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'|| emailbranding);
1591:

Line 1592: wf_engine.SetItemAttrText(itemtype => Itemtype,

1588: itemkey => Itemkey,
1589: aname => 'IBUBRANDING',
1590: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'|| emailbranding);
1591:
1592: wf_engine.SetItemAttrText(itemtype => Itemtype,
1593: itemkey => Itemkey,
1594: aname => 'IBUURL',
1595: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'|| emaillinkurl);
1596:

Line 1597: wf_engine.SetItemOwner(itemtype => Itemtype,

1593: itemkey => Itemkey,
1594: aname => 'IBUURL',
1595: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'|| emaillinkurl);
1596:
1597: wf_engine.SetItemOwner(itemtype => Itemtype,
1598: itemkey => Itemkey,
1599: owner => roleName);
1600:
1601: for i in 1..15 loop

Line 1604: wf_engine.SetItemAttrText(itemtype => Itemtype,

1600:
1601: for i in 1..15 loop
1602: mailAttrVals(i) := 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/' || content(i);
1603: if(i = 1) then
1604: wf_engine.SetItemAttrText(itemtype => Itemtype,
1605: itemkey => Itemkey,
1606: aname => 'IBU_ITEM_CONTENT',
1607: avalue => mailAttrVals(i));
1608: else

Line 1609: wf_engine.SetItemAttrText(itemtype => Itemtype,

1605: itemkey => Itemkey,
1606: aname => 'IBU_ITEM_CONTENT',
1607: avalue => mailAttrVals(i));
1608: else
1609: wf_engine.SetItemAttrText(itemtype => Itemtype,
1610: itemkey => Itemkey,
1611: aname => 'IBUCONTENT'||(i-1),
1612: avalue => mailAttrVals(i));
1613: end if;

Line 1616: wf_engine.StartProcess (itemtype => Itemtype,

1612: avalue => mailAttrVals(i));
1613: end if;
1614: end loop;
1615:
1616: wf_engine.StartProcess (itemtype => Itemtype,
1617: itemkey => Itemkey );
1618:
1619: end StartEmailProcess;
1620: