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

Line 15: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

11: p_funcmode IN VARCHAR2,
12: p_resultout OUT NOCOPY VARCHAR2)
13: IS
14:
15: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
16: itemtype=>p_itemtype,
17: itemkey=>P_itemkey,
18: aname=>'EVENT_NAME');
19: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

Line 19: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

15: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
16: itemtype=>p_itemtype,
17: itemkey=>P_itemkey,
18: aname=>'EVENT_NAME');
19: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
20: itemtype=>p_itemtype,
21: itemkey=>P_itemkey,
22: aname=>'EVENT_KEY');
23:

Line 1632: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1628: END IF;
1629:
1630:
1631: /* Set the User Attribute */
1632: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1633: aname => 'CURRENT_APPROVER',
1634: avalue => l_user);
1635: /* Set All other Attributes */
1636:

Line 1637: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1633: aname => 'CURRENT_APPROVER',
1634: avalue => l_user);
1635: /* Set All other Attributes */
1636:
1637: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1638: aname => 'APPS_FORM',
1639: avalue =>l_form );
1640:
1641: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1641: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1637: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1638: aname => 'APPS_FORM',
1639: avalue =>l_form );
1640:
1641: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1642: aname => 'ITEM_NUMBER',
1643: avalue =>l_ITEM_NUMBER );
1644:
1645: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1645: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1641: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1642: aname => 'ITEM_NUMBER',
1643: avalue =>l_ITEM_NUMBER );
1644:
1645: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1646: aname => 'ITEM_REVISION',
1647: avalue =>l_REVISION );
1648:
1649: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1649: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1645: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1646: aname => 'ITEM_REVISION',
1647: avalue =>l_REVISION );
1648:
1649: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1650: aname => 'ITEM_DESC',
1651: avalue =>l_item_desc );
1652:
1653: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1653: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1649: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1650: aname => 'ITEM_DESC',
1651: avalue =>l_item_desc );
1652:
1653: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1654: aname => 'PARENT_LOT',
1655: avalue =>l_parent_lot_number );
1656:
1657: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1657: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1653: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1654: aname => 'PARENT_LOT',
1655: avalue =>l_parent_lot_number );
1656:
1657: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1658: aname => 'LOT_NUMBER',
1659: avalue =>l_lot_number );
1660:
1661: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1661: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1657: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1658: aname => 'LOT_NUMBER',
1659: avalue =>l_lot_number );
1660:
1661: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1662: aname => 'ORGANIZATION_CODE',
1663: avalue =>l_ORGANIZATION_CODE );
1664:
1665: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1665: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1661: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1662: aname => 'ORGANIZATION_CODE',
1663: avalue =>l_ORGANIZATION_CODE );
1664:
1665: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1666: aname => 'SUBINVENTORY',
1667: avalue =>l_subinventory );
1668:
1669: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1669: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1665: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1666: aname => 'SUBINVENTORY',
1667: avalue =>l_subinventory );
1668:
1669: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1670: aname => 'LOCATOR',
1671: avalue =>l_locator );
1672:
1673: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1673: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1669: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1670: aname => 'LOCATOR',
1671: avalue =>l_locator );
1672:
1673: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1674: aname => 'DOC_TYPE',
1675: avalue =>l_doc_type );
1676:
1677: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1677: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1673: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1674: aname => 'DOC_TYPE',
1675: avalue =>l_doc_type );
1676:
1677: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1678: aname => 'DOCUMENT_NO',
1679: avalue =>l_doc_number ); -- where does doc no come from???
1680: -- Bug #3473230 (JKB) Added doc_no above.
1681: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1681: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1677: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1678: aname => 'DOCUMENT_NO',
1679: avalue =>l_doc_number ); -- where does doc no come from???
1680: -- Bug #3473230 (JKB) Added doc_no above.
1681: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1682: aname => 'DOC_DESC',
1683: avalue =>l_transaction_type_name );
1684:
1685: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1685: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,

1681: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1682: aname => 'DOC_DESC',
1683: avalue =>l_transaction_type_name );
1684:
1685: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
1686: aname => 'TRANS_QTY',
1687: avalue =>l_trans_qty );
1688:
1689: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1689: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,

1685: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
1686: aname => 'TRANS_QTY',
1687: avalue =>l_trans_qty );
1688:
1689: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
1690: aname => 'TRANS_QTY2',
1691: avalue =>l_trans_qty2 );
1692:
1693: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1693: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1689: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
1690: aname => 'TRANS_QTY2',
1691: avalue =>l_trans_qty2 );
1692:
1693: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1694: aname => 'TRANS_UOM',
1695: avalue =>l_trans_qty_uom );
1696:
1697: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1697: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1693: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1694: aname => 'TRANS_UOM',
1695: avalue =>l_trans_qty_uom );
1696:
1697: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1698: aname => 'TRANS_UOM2',
1699: avalue =>l_trans_qty_uom2 );
1700:
1701: --RLNAGARA B4905645 Changed SETITEMATTRDATE with SETITEMATTRTEXT for retest and expiry dates.

Line 1702: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1698: aname => 'TRANS_UOM2',
1699: avalue =>l_trans_qty_uom2 );
1700:
1701: --RLNAGARA B4905645 Changed SETITEMATTRDATE with SETITEMATTRTEXT for retest and expiry dates.
1702: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1703: aname => 'RETEST_DATE',
1704: avalue =>l_retest_date );
1705:
1706: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1706: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1702: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1703: aname => 'RETEST_DATE',
1704: avalue =>l_retest_date );
1705:
1706: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1707: aname => 'EXPIRY_DATE',
1708: avalue =>l_expiry_date );
1709:
1710: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1710: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1706: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1707: aname => 'EXPIRY_DATE',
1708: avalue =>l_expiry_date );
1709:
1710: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1711: aname => 'PURCHASE_NO',
1712: avalue =>l_purchase_no );
1713:
1714: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1714: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1710: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1711: aname => 'PURCHASE_NO',
1712: avalue =>l_purchase_no );
1713:
1714: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1715: aname => 'SUPPLIER_NO',
1716: avalue =>l_vendor_no );
1717:
1718: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1718: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1714: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1715: aname => 'SUPPLIER_NO',
1716: avalue =>l_vendor_no );
1717:
1718: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1719: aname => 'RECEIPT_NO',
1720: avalue =>l_receipt_no );
1721:
1722: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1722: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1718: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1719: aname => 'RECEIPT_NO',
1720: avalue =>l_receipt_no );
1721:
1722: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1723: aname => 'SAMPLING_PLAN',
1724: avalue =>l_sample_plan );
1725:
1726: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1726: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1722: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1723: aname => 'SAMPLING_PLAN',
1724: avalue =>l_sample_plan );
1725:
1726: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1727: aname => '#FROM_ROLE',
1728: avalue =>l_from_role );
1729:
1730: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1730: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1726: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1727: aname => '#FROM_ROLE',
1728: avalue =>l_from_role );
1729:
1730: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1731: aname => 'AME_TRANS',
1732: avalue =>l_transaction_type );
1733:
1734: --RLNAGARA B5018797 Added this as Operting Unit is added to the Notification also.

Line 1736: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1732: avalue =>l_transaction_type );
1733:
1734: --RLNAGARA B5018797 Added this as Operting Unit is added to the Notification also.
1735:
1736: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1737: aname => 'OPERATING_UNIT',
1738: avalue =>l_operating_unit );
1739:
1740: --RLNAGARA Bug5334308

Line 1741: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,

1737: aname => 'OPERATING_UNIT',
1738: avalue =>l_operating_unit );
1739:
1740: --RLNAGARA Bug5334308
1741: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
1742: aname => 'LOT_QTY',
1743: avalue =>l_lot_qty );
1744:
1745: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1745: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,

1741: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
1742: aname => 'LOT_QTY',
1743: avalue =>l_lot_qty );
1744:
1745: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
1746: aname => 'LOT_QTY2',
1747: avalue =>l_lot_qty2 );
1748:
1749: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1749: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1745: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
1746: aname => 'LOT_QTY2',
1747: avalue =>l_lot_qty2 );
1748:
1749: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1750: aname => 'LOT_UOM',
1751: avalue =>l_trans_qty_uom );
1752:
1753: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 1753: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1749: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1750: aname => 'LOT_UOM',
1751: avalue =>l_trans_qty_uom );
1752:
1753: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1754: aname => 'LOT_UOM2',
1755: avalue =>l_trans_qty_uom2 );
1756:
1757:

Line 1802: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

1798: p_funcmode IN VARCHAR2,
1799: p_resultout OUT NOCOPY VARCHAR2)
1800:
1801: IS
1802: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
1803: itemtype=>p_itemtype,
1804: itemkey=>P_itemkey,
1805: aname=>'EVENT_NAME');
1806:

Line 1807: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

1803: itemtype=>p_itemtype,
1804: itemkey=>P_itemkey,
1805: aname=>'EVENT_NAME');
1806:
1807: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
1808: itemtype=>p_itemtype,
1809: itemkey=>P_itemkey,
1810: aname=>'EVENT_KEY');
1811:

Line 1815: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(

1811:
1812: l_current_approver varchar2(240);
1813:
1814: l_application_id number;
1815: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(
1816: itemtype=>p_itemtype,
1817: itemkey=>P_itemkey,
1818: aname=>'AME_TRANS');
1819: l_user varchar2(32);

Line 1864: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

1860:
1861:
1862: /* Set the User Attribute */
1863:
1864: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
1865: aname => 'CURRENT_APPROVER',
1866: avalue => l_user);
1867:
1868: P_resultout:='COMPLETE:Y';

Line 1894: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT( itemtype => p_itemtype,

1890: p_funcmode IN VARCHAR2,
1891: p_resultout OUT NOCOPY VARCHAR2)
1892:
1893: IS
1894: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT( itemtype => p_itemtype,
1895: itemkey => P_itemkey,
1896: aname => 'EVENT_NAME');
1897:
1898: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT( itemtype => p_itemtype,

Line 1898: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT( itemtype => p_itemtype,

1894: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT( itemtype => p_itemtype,
1895: itemkey => P_itemkey,
1896: aname => 'EVENT_NAME');
1897:
1898: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT( itemtype => p_itemtype,
1899: itemkey => P_itemkey,
1900: aname => 'EVENT_KEY');
1901:
1902: Approver AME_UTIL.APPROVERRECORD;

Line 2648: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,

2644: ||'-'||to_char(sysdate,'dd/mm/yy hh:mi:ss');
2645: l_workflow_process:='GMDQMSMC_PROD_PROCESS';
2646:
2647:
2648: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
2649: itemkey => l_itemkey,
2650: process => l_Workflow_Process) ;
2651:
2652: --wf_log_pkg.string(6, 'Dummy','Child Process Created');

Line 2656: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

2652: --wf_log_pkg.string(6, 'Dummy','Child Process Created');
2653:
2654: /* Set the User Attribute */
2655:
2656: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2657: aname => 'CURRENT_APPROVER',
2658: avalue => l_user);
2659:
2660: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 2660: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

2656: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2657: aname => 'CURRENT_APPROVER',
2658: avalue => l_user);
2659:
2660: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2661: aname => 'APPS_FORM',
2662: avalue =>l_form );
2663: /* Set All other Attributes */
2664:

Line 2665: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

2661: aname => 'APPS_FORM',
2662: avalue =>l_form );
2663: /* Set All other Attributes */
2664:
2665: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2666: aname => 'EVENT_NAME',
2667: avalue =>l_event_name );
2668:
2669: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 2669: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

2665: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2666: aname => 'EVENT_NAME',
2667: avalue =>l_event_name );
2668:
2669: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2670: aname => 'EVENT_KEY',
2671: avalue =>l_event_key );
2672:
2673: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 2673: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

2669: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2670: aname => 'EVENT_KEY',
2671: avalue =>l_event_key );
2672:
2673: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2674: aname => 'APPS_FORM',
2675: avalue =>l_form );
2676:
2677: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 2677: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

2673: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2674: aname => 'APPS_FORM',
2675: avalue =>l_form );
2676:
2677: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2678: aname => 'ITEM_NUMBER',
2679: avalue =>l_ITEM_NUMBER );
2680:
2681: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 2681: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

2677: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2678: aname => 'ITEM_NUMBER',
2679: avalue =>l_ITEM_NUMBER );
2680:
2681: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2682: aname => 'ITEM_REVISION',
2683: avalue =>l_REVISION );
2684:
2685: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 2685: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

2681: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2682: aname => 'ITEM_REVISION',
2683: avalue =>l_REVISION );
2684:
2685: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2686: aname => 'ITEM_DESC',
2687: avalue =>l_item_desc );
2688:
2689: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 2689: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

2685: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2686: aname => 'ITEM_DESC',
2687: avalue =>l_item_desc );
2688:
2689: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2690: aname => 'ORGANIZATION_CODE',
2691: avalue =>l_organization_code );
2692:
2693: WF_ENGINE.SETITEMATTRTEXT(itemtype =>l_itemtype,itemkey => l_itemkey,

Line 2693: WF_ENGINE.SETITEMATTRTEXT(itemtype =>l_itemtype,itemkey => l_itemkey,

2689: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2690: aname => 'ORGANIZATION_CODE',
2691: avalue =>l_organization_code );
2692:
2693: WF_ENGINE.SETITEMATTRTEXT(itemtype =>l_itemtype,itemkey => l_itemkey,
2694: aname => 'SUBINVENTORY',
2695: avalue =>l_subinventory );
2696:
2697: WF_ENGINE.SETITEMATTRTEXT(itemtype =>l_itemtype,itemkey => l_itemkey,

Line 2697: WF_ENGINE.SETITEMATTRTEXT(itemtype =>l_itemtype,itemkey => l_itemkey,

2693: WF_ENGINE.SETITEMATTRTEXT(itemtype =>l_itemtype,itemkey => l_itemkey,
2694: aname => 'SUBINVENTORY',
2695: avalue =>l_subinventory );
2696:
2697: WF_ENGINE.SETITEMATTRTEXT(itemtype =>l_itemtype,itemkey => l_itemkey,
2698: aname => 'LOCATOR',
2699: avalue => l_locator);
2700:
2701: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 2701: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

2697: WF_ENGINE.SETITEMATTRTEXT(itemtype =>l_itemtype,itemkey => l_itemkey,
2698: aname => 'LOCATOR',
2699: avalue => l_locator);
2700:
2701: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2702: aname => 'FORMULA_NO',
2703: avalue =>l_formula_no );
2704:
2705: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 2705: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

2701: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2702: aname => 'FORMULA_NO',
2703: avalue =>l_formula_no );
2704:
2705: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2706: aname => 'RECIPE_NO',
2707: avalue =>l_recipe_no );
2708:
2709: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey =>l_itemkey,

Line 2709: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey =>l_itemkey,

2705: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2706: aname => 'RECIPE_NO',
2707: avalue =>l_recipe_no );
2708:
2709: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey =>l_itemkey,
2710: aname => 'BATCH_NO',
2711: avalue =>l_batch_no );
2712:
2713: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 2713: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

2709: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey =>l_itemkey,
2710: aname => 'BATCH_NO',
2711: avalue =>l_batch_no );
2712:
2713: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2714: aname => 'BATCH_STEP_NO',
2715: avalue =>l_step_no );
2716:
2717: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 2717: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

2713: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2714: aname => 'BATCH_STEP_NO',
2715: avalue =>l_step_no );
2716:
2717: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2718: aname => 'SAMPLING_PLAN',
2719: avalue =>l_sample_plan );
2720:
2721: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 2721: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

2717: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2718: aname => 'SAMPLING_PLAN',
2719: avalue =>l_sample_plan );
2720:
2721: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
2722: aname => '#FROM_ROLE',
2723: avalue =>l_from_role );
2724:
2725: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 2725: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

2721: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
2722: aname => '#FROM_ROLE',
2723: avalue =>l_from_role );
2724:
2725: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2726: aname => 'AME_TRANS',
2727: avalue =>l_transaction_type );
2728:
2729: -- RLNAGARA Bug 5032406 (FP of 4604305 ME) Setting spec name and version wf attributes

Line 2730: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

2726: aname => 'AME_TRANS',
2727: avalue =>l_transaction_type );
2728:
2729: -- RLNAGARA Bug 5032406 (FP of 4604305 ME) Setting spec name and version wf attributes
2730: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2731: aname => 'SPEC_NAME',
2732: avalue =>l_spec_name );
2733: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2734: aname => 'SPEC_VERS',

Line 2733: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

2729: -- RLNAGARA Bug 5032406 (FP of 4604305 ME) Setting spec name and version wf attributes
2730: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2731: aname => 'SPEC_NAME',
2732: avalue =>l_spec_name );
2733: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
2734: aname => 'SPEC_VERS',
2735: avalue =>l_spec_vers );
2736:
2737: WF_LOG_PKG.STRING(6, 'Setting','Setting Parent');

Line 2739: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,

2735: avalue =>l_spec_vers );
2736:
2737: WF_LOG_PKG.STRING(6, 'Setting','Setting Parent');
2738:
2739: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,
2740: itemkey =>l_itemkey,
2741: parent_itemtype => p_itemtype,
2742: parent_itemkey => p_itemkey,
2743: parent_context => NULL);

Line 2747: /* Bug #4576699 Moved this code before WF_ENGINE.STARTPROCESS so that

2743: parent_context => NULL);
2744:
2745:
2746: /* As this a pure FYI notification we will set the approver to approve status */
2747: /* Bug #4576699 Moved this code before WF_ENGINE.STARTPROCESS so that
2748: CHECK_NEXT_APPROVER doesn't fetch records from the first approver to whom
2749: a notification is already sent */
2750:
2751: Approver.approval_status := AME_UTIL.APPROVEDSTATUS;

Line 2760: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);

2756: forwardeeIn => AME_UTIL.EMPTYAPPROVERRECORD);
2757:
2758: /* start the Workflow process */
2759: --WF_LOG_PKG.STRING(6, 'Dummy','Starting Process');
2760: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
2761: END IF; /* Added in Bug no. 7033224 */
2762: END IF; /* Spec Found */
2763: END LOOP;
2764: CLOSE C1;

Line 2785: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

2781: p_actid IN NUMBER,
2782: p_funcmode IN VARCHAR2,
2783: p_resultout OUT NOCOPY VARCHAR2)
2784: IS
2785: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
2786: itemtype=>p_itemtype,
2787: itemkey=>P_itemkey,
2788: aname=>'EVENT_NAME');
2789: