APPS.IBU_REQ_PKG dependencies on WF_ENGINE

Line 1323: email_content Wf_Engine.TextTabTyp;

1319: context varchar2(100) := NULL;
1320: send_comment varchar2(100) := NULL;
1321: priority number := null;
1322:
1323: email_content Wf_Engine.TextTabTyp;
1324: email_content_count_end number := 1;
1325: temp_email_msg_body varchar2(32000) := null;
1326: truncateCharNum number := 0; -- added by wei ma
1327: retainCharNum number := 0;

Line 1607: content Wf_Engine.TextTabTyp,

1603: procedure StartEmailProcess (
1604: roleName in varchar2,
1605: srID in number,
1606: subject in varchar2,
1607: content Wf_Engine.TextTabTyp,
1608: ProcessOwner in varchar2,
1609: Workflowprocess in varchar2 ,
1610: item_type in varchar2,
1611: emailStyleSheet in varchar2,

Line 1629: mailAttrVals Wf_Engine.TextTabTyp ;

1625: seq number := 0;
1626: --create_seq varchar2(50) := 'create sequence IBU_SR_NOTIFICATION_S';
1627: --get_seq varchar2(50) := 'select ' || 'IBU_SR_NOTIFICATION_S' || '.nextval from dual';
1628: get_seq varchar2(50) := 'select ' || 'IBU_WF_ITEM_KEY_S' || '.nextval from dual';
1629: mailAttrVals Wf_Engine.TextTabTyp ;
1630: begin
1631: /* Get schema name */
1632: select user into l_user from dual;
1633:

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

1645: execute immediate get_seq into seq;
1646:
1647: ItemKey := roleName||seq;
1648:
1649: wf_engine.CreateProcess(itemtype => ItemType,
1650: itemkey => ItemKey,
1651: process => WorkflowProcess );
1652:
1653: wf_engine.SetItemUserKey(itemtype => Itemtype,

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

1649: wf_engine.CreateProcess(itemtype => ItemType,
1650: itemkey => ItemKey,
1651: process => WorkflowProcess );
1652:
1653: wf_engine.SetItemUserKey(itemtype => Itemtype,
1654: itemkey => Itemkey,
1655: userkey => ItemUserKey);
1656:
1657: wf_engine.SetItemAttrText(itemtype => Itemtype,

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

1653: wf_engine.SetItemUserKey(itemtype => Itemtype,
1654: itemkey => Itemkey,
1655: userkey => ItemUserKey);
1656:
1657: wf_engine.SetItemAttrText(itemtype => Itemtype,
1658: itemkey => Itemkey,
1659: aname => 'IBU_ROLE',
1660: avalue => roleName);
1661:

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

1658: itemkey => Itemkey,
1659: aname => 'IBU_ROLE',
1660: avalue => roleName);
1661:
1662: wf_engine.SetItemAttrText (itemtype => Itemtype,
1663: itemkey => Itemkey,
1664: aname => 'IBU_SUBJECT_ITEM',
1665: avalue => subject);
1666:

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

1663: itemkey => Itemkey,
1664: aname => 'IBU_SUBJECT_ITEM',
1665: avalue => subject);
1666:
1667: wf_engine.SetItemAttrNumber(itemtype => Itemtype,
1668: itemkey => Itemkey,
1669: aname => 'IBUSRID',
1670: avalue => srID);
1671:

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

1668: itemkey => Itemkey,
1669: aname => 'IBUSRID',
1670: avalue => srID);
1671:
1672: wf_engine.SetItemAttrText(itemtype => Itemtype,
1673: itemkey => Itemkey,
1674: aname => 'IBUSTYLESHEET',
1675: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'|| emailStyleSheet);
1676:

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

1673: itemkey => Itemkey,
1674: aname => 'IBUSTYLESHEET',
1675: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'|| emailStyleSheet);
1676:
1677: wf_engine.SetItemAttrText(itemtype => Itemtype,
1678: itemkey => Itemkey,
1679: aname => 'IBUBRANDING',
1680: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'|| emailbranding);
1681:

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

1678: itemkey => Itemkey,
1679: aname => 'IBUBRANDING',
1680: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'|| emailbranding);
1681:
1682: wf_engine.SetItemAttrText(itemtype => Itemtype,
1683: itemkey => Itemkey,
1684: aname => 'IBUURL',
1685: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'|| emaillinkurl);
1686:

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

1683: itemkey => Itemkey,
1684: aname => 'IBUURL',
1685: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'|| emaillinkurl);
1686:
1687: wf_engine.SetItemOwner(itemtype => Itemtype,
1688: itemkey => Itemkey,
1689: owner => roleName);
1690:
1691: for i in 1..15 loop

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

1690:
1691: for i in 1..15 loop
1692: mailAttrVals(i) := 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/' || content(i);
1693: if(i = 1) then
1694: wf_engine.SetItemAttrText(itemtype => Itemtype,
1695: itemkey => Itemkey,
1696: aname => 'IBU_ITEM_CONTENT',
1697: avalue => mailAttrVals(i));
1698: else

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

1695: itemkey => Itemkey,
1696: aname => 'IBU_ITEM_CONTENT',
1697: avalue => mailAttrVals(i));
1698: else
1699: wf_engine.SetItemAttrText(itemtype => Itemtype,
1700: itemkey => Itemkey,
1701: aname => 'IBUCONTENT'||(i-1),
1702: avalue => mailAttrVals(i));
1703: end if;

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

1702: avalue => mailAttrVals(i));
1703: end if;
1704: end loop;
1705:
1706: wf_engine.StartProcess (itemtype => Itemtype,
1707: itemkey => Itemkey );
1708:
1709: end StartEmailProcess;
1710: