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 13: l_event_name varchar2(240) := WF_ENGINE.GETITEMATTRTEXT(itemtype => p_itemtype,

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

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

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

Line 1815: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1811:
1812: END IF;
1813:
1814: /* Set the User Attribute */
1815: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1816: itemkey => p_itemkey,
1817: aname => 'CURRENT_APPROVER',
1818: avalue => l_user);
1819: /* Set All other Attributes */

Line 1821: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1817: aname => 'CURRENT_APPROVER',
1818: avalue => l_user);
1819: /* Set All other Attributes */
1820:
1821: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1822: itemkey => p_itemkey,
1823: aname => 'APPS_FORM',
1824: avalue => l_form);
1825:

Line 1826: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1822: itemkey => p_itemkey,
1823: aname => 'APPS_FORM',
1824: avalue => l_form);
1825:
1826: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1827: itemkey => p_itemkey,
1828: aname => 'ITEM_NUMBER',
1829: avalue => l_ITEM_NUMBER);
1830:

Line 1831: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1827: itemkey => p_itemkey,
1828: aname => 'ITEM_NUMBER',
1829: avalue => l_ITEM_NUMBER);
1830:
1831: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1832: itemkey => p_itemkey,
1833: aname => 'ITEM_REVISION',
1834: avalue => l_REVISION);
1835:

Line 1836: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1832: itemkey => p_itemkey,
1833: aname => 'ITEM_REVISION',
1834: avalue => l_REVISION);
1835:
1836: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1837: itemkey => p_itemkey,
1838: aname => 'ITEM_DESC',
1839: avalue => l_item_desc);
1840:

Line 1841: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1837: itemkey => p_itemkey,
1838: aname => 'ITEM_DESC',
1839: avalue => l_item_desc);
1840:
1841: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1842: itemkey => p_itemkey,
1843: aname => 'PARENT_LOT',
1844: avalue => l_parent_lot_number);
1845:

Line 1849: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1845:
1846:
1847: -- 9777830 use mobile lot number if transaction is mobile else normal lot number
1848: IF nvl(l_mobile_txn,'N') = 'Y' then
1849: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1850: itemkey => p_itemkey,
1851: aname => 'LOT_NUMBER',
1852: avalue => l_mobile_lot_num);
1853:

Line 1855: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1851: aname => 'LOT_NUMBER',
1852: avalue => l_mobile_lot_num);
1853:
1854: ELSE
1855: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1856: itemkey => p_itemkey,
1857: aname => 'LOT_NUMBER',
1858: avalue => l_lot_number);
1859:

Line 1865: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1861:
1862:
1863: -- 9777830 add vendor lot num
1864:
1865: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1866: itemkey => p_itemkey,
1867: aname => 'VENDOR_LOT_NUMBER',
1868: avalue => l_vendor_lot_num);
1869:

Line 1870: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1866: itemkey => p_itemkey,
1867: aname => 'VENDOR_LOT_NUMBER',
1868: avalue => l_vendor_lot_num);
1869:
1870: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1871: itemkey => p_itemkey,
1872: aname => 'ORGANIZATION_CODE',
1873: avalue => l_ORGANIZATION_CODE);
1874:

Line 1875: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1871: itemkey => p_itemkey,
1872: aname => 'ORGANIZATION_CODE',
1873: avalue => l_ORGANIZATION_CODE);
1874:
1875: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1876: itemkey => p_itemkey,
1877: aname => 'SUBINVENTORY',
1878: avalue => l_subinventory);
1879:

Line 1880: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1876: itemkey => p_itemkey,
1877: aname => 'SUBINVENTORY',
1878: avalue => l_subinventory);
1879:
1880: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1881: itemkey => p_itemkey,
1882: aname => 'LOCATOR',
1883: avalue => l_locator);
1884:

Line 1885: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1881: itemkey => p_itemkey,
1882: aname => 'LOCATOR',
1883: avalue => l_locator);
1884:
1885: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1886: itemkey => p_itemkey,
1887: aname => 'DOC_TYPE',
1888: avalue => l_doc_type);
1889:

Line 1890: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1886: itemkey => p_itemkey,
1887: aname => 'DOC_TYPE',
1888: avalue => l_doc_type);
1889:
1890: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1891: itemkey => p_itemkey,
1892: aname => 'DOCUMENT_NO',
1893: avalue => l_doc_number); -- where does doc no come from???
1894: -- Bug #3473230 (JKB) Added doc_no above.

Line 1895: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1891: itemkey => p_itemkey,
1892: aname => 'DOCUMENT_NO',
1893: avalue => l_doc_number); -- where does doc no come from???
1894: -- Bug #3473230 (JKB) Added doc_no above.
1895: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1896: itemkey => p_itemkey,
1897: aname => 'DOC_DESC',
1898: avalue => l_transaction_type_name);
1899:

Line 1900: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,

1896: itemkey => p_itemkey,
1897: aname => 'DOC_DESC',
1898: avalue => l_transaction_type_name);
1899:
1900: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,
1901: itemkey => p_itemkey,
1902: aname => 'TRANS_QTY',
1903: avalue => l_trans_qty);
1904:

Line 1905: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,

1901: itemkey => p_itemkey,
1902: aname => 'TRANS_QTY',
1903: avalue => l_trans_qty);
1904:
1905: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,
1906: itemkey => p_itemkey,
1907: aname => 'TRANS_QTY2',
1908: avalue => l_trans_qty2);
1909:

Line 1910: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1906: itemkey => p_itemkey,
1907: aname => 'TRANS_QTY2',
1908: avalue => l_trans_qty2);
1909:
1910: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1911: itemkey => p_itemkey,
1912: aname => 'TRANS_UOM',
1913: avalue => l_trans_qty_uom);
1914:

Line 1915: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1911: itemkey => p_itemkey,
1912: aname => 'TRANS_UOM',
1913: avalue => l_trans_qty_uom);
1914:
1915: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1916: itemkey => p_itemkey,
1917: aname => 'TRANS_UOM2',
1918: avalue => l_trans_qty_uom2);
1919:

Line 1921: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1917: aname => 'TRANS_UOM2',
1918: avalue => l_trans_qty_uom2);
1919:
1920: --RLNAGARA B4905645 Changed SETITEMATTRDATE with SETITEMATTRTEXT for retest and expiry dates.
1921: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1922: itemkey => p_itemkey,
1923: aname => 'RETEST_DATE',
1924: avalue => l_retest_date);
1925:

Line 1926: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1922: itemkey => p_itemkey,
1923: aname => 'RETEST_DATE',
1924: avalue => l_retest_date);
1925:
1926: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1927: itemkey => p_itemkey,
1928: aname => 'EXPIRY_DATE',
1929: avalue => l_expiry_date);
1930:

Line 1931: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1927: itemkey => p_itemkey,
1928: aname => 'EXPIRY_DATE',
1929: avalue => l_expiry_date);
1930:
1931: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1932: itemkey => p_itemkey,
1933: aname => 'PURCHASE_NO',
1934: avalue => l_purchase_no);
1935:

Line 1936: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1932: itemkey => p_itemkey,
1933: aname => 'PURCHASE_NO',
1934: avalue => l_purchase_no);
1935:
1936: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1937: itemkey => p_itemkey,
1938: aname => 'SUPPLIER_NO',
1939: avalue => l_vendor_no);
1940:

Line 1941: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1937: itemkey => p_itemkey,
1938: aname => 'SUPPLIER_NO',
1939: avalue => l_vendor_no);
1940:
1941: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1942: itemkey => p_itemkey,
1943: aname => 'RECEIPT_NO',
1944: avalue => l_receipt_no);
1945:

Line 1946: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1942: itemkey => p_itemkey,
1943: aname => 'RECEIPT_NO',
1944: avalue => l_receipt_no);
1945:
1946: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1947: itemkey => p_itemkey,
1948: aname => 'SAMPLING_PLAN',
1949: avalue => l_sample_plan);
1950:

Line 1951: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1947: itemkey => p_itemkey,
1948: aname => 'SAMPLING_PLAN',
1949: avalue => l_sample_plan);
1950:
1951: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1952: itemkey => p_itemkey,
1953: aname => '#FROM_ROLE',
1954: avalue => l_from_role);
1955:

Line 1956: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1952: itemkey => p_itemkey,
1953: aname => '#FROM_ROLE',
1954: avalue => l_from_role);
1955:
1956: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1957: itemkey => p_itemkey,
1958: aname => 'AME_TRANS',
1959: avalue => l_transaction_type);
1960:

Line 1963: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1959: avalue => l_transaction_type);
1960:
1961: --RLNAGARA B5018797 Added this as Operting Unit is added to the Notification also.
1962:
1963: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1964: itemkey => p_itemkey,
1965: aname => 'OPERATING_UNIT',
1966: avalue => l_operating_unit);
1967:

Line 1969: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,

1965: aname => 'OPERATING_UNIT',
1966: avalue => l_operating_unit);
1967:
1968: --RLNAGARA Bug5334308
1969: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,
1970: itemkey => p_itemkey,
1971: aname => 'LOT_QTY',
1972: avalue => l_lot_qty);
1973:

Line 1974: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,

1970: itemkey => p_itemkey,
1971: aname => 'LOT_QTY',
1972: avalue => l_lot_qty);
1973:
1974: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,
1975: itemkey => p_itemkey,
1976: aname => 'LOT_QTY2',
1977: avalue => l_lot_qty2);
1978:

Line 1979: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1975: itemkey => p_itemkey,
1976: aname => 'LOT_QTY2',
1977: avalue => l_lot_qty2);
1978:
1979: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1980: itemkey => p_itemkey,
1981: aname => 'LOT_UOM',
1982: avalue => l_trans_qty_uom);
1983:

Line 1984: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

1980: itemkey => p_itemkey,
1981: aname => 'LOT_UOM',
1982: avalue => l_trans_qty_uom);
1983:
1984: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
1985: itemkey => p_itemkey,
1986: aname => 'LOT_UOM2',
1987: avalue => l_trans_qty_uom2);
1988:

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

2021: p_funcmode IN VARCHAR2,
2022: p_resultout OUT NOCOPY VARCHAR2)
2023:
2024: IS
2025: l_event_name varchar2(240) := WF_ENGINE.GETITEMATTRTEXT(itemtype => p_itemtype,
2026: itemkey => P_itemkey,
2027: aname => 'EVENT_NAME');
2028:
2029: l_event_key varchar2(240) := WF_ENGINE.GETITEMATTRTEXT(itemtype => p_itemtype,

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

2025: l_event_name varchar2(240) := WF_ENGINE.GETITEMATTRTEXT(itemtype => p_itemtype,
2026: itemkey => P_itemkey,
2027: aname => 'EVENT_NAME');
2028:
2029: l_event_key varchar2(240) := WF_ENGINE.GETITEMATTRTEXT(itemtype => p_itemtype,
2030: itemkey => P_itemkey,
2031: aname => 'EVENT_KEY');
2032:
2033: l_current_approver varchar2(240);

Line 2036: l_transaction_type varchar2(100) := WF_ENGINE.GETITEMATTRTEXT(itemtype => p_itemtype,

2032:
2033: l_current_approver varchar2(240);
2034:
2035: l_application_id number;
2036: l_transaction_type varchar2(100) := WF_ENGINE.GETITEMATTRTEXT(itemtype => p_itemtype,
2037: itemkey => P_itemkey,
2038: aname => 'AME_TRANS');
2039: l_user varchar2(32);
2040: Approver AME_UTIL.APPROVERRECORD;

Line 2114: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

2110: END IF;
2111:
2112: /* Set the User Attribute */
2113:
2114: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
2115: itemkey => p_itemkey,
2116: aname => 'CURRENT_APPROVER',
2117: avalue => l_user);
2118:

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

2143: p_funcmode IN VARCHAR2,
2144: p_resultout OUT NOCOPY VARCHAR2)
2145:
2146: IS
2147: l_event_name varchar2(240) := WF_ENGINE.GETITEMATTRTEXT(itemtype => p_itemtype,
2148: itemkey => P_itemkey,
2149: aname => 'EVENT_NAME');
2150:
2151: l_event_key varchar2(240) := WF_ENGINE.GETITEMATTRTEXT(itemtype => p_itemtype,

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

2147: l_event_name varchar2(240) := WF_ENGINE.GETITEMATTRTEXT(itemtype => p_itemtype,
2148: itemkey => P_itemkey,
2149: aname => 'EVENT_NAME');
2150:
2151: l_event_key varchar2(240) := WF_ENGINE.GETITEMATTRTEXT(itemtype => p_itemtype,
2152: itemkey => P_itemkey,
2153: aname => 'EVENT_KEY');
2154:
2155: Approver AME_UTIL.APPROVERRECORD;

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

3019: l_INVENTORY_item_id || '-' ||
3020: to_char(sysdate, 'dd/mm/yy hh:mi:ss');
3021: l_workflow_process := 'GMDQMSMC_PROD_PROCESS';
3022:
3023: WF_ENGINE.CREATEPROCESS(itemtype => l_itemtype,
3024: itemkey => l_itemkey,
3025: process => l_Workflow_Process);
3026:
3027: --wf_log_pkg.string(6, 'Dummy','Child Process Created');

Line 3031: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3027: --wf_log_pkg.string(6, 'Dummy','Child Process Created');
3028:
3029: /* Set the User Attribute */
3030:
3031: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3032: itemkey => l_itemkey,
3033: aname => 'CURRENT_APPROVER',
3034: avalue => l_user);
3035:

Line 3036: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3032: itemkey => l_itemkey,
3033: aname => 'CURRENT_APPROVER',
3034: avalue => l_user);
3035:
3036: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3037: itemkey => l_itemkey,
3038: aname => 'APPS_FORM',
3039: avalue => l_form);
3040: /* Set All other Attributes */

Line 3042: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3038: aname => 'APPS_FORM',
3039: avalue => l_form);
3040: /* Set All other Attributes */
3041:
3042: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3043: itemkey => l_itemkey,
3044: aname => 'EVENT_NAME',
3045: avalue => l_event_name);
3046:

Line 3047: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3043: itemkey => l_itemkey,
3044: aname => 'EVENT_NAME',
3045: avalue => l_event_name);
3046:
3047: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3048: itemkey => l_itemkey,
3049: aname => 'EVENT_KEY',
3050: avalue => l_event_key);
3051:

Line 3052: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3048: itemkey => l_itemkey,
3049: aname => 'EVENT_KEY',
3050: avalue => l_event_key);
3051:
3052: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3053: itemkey => l_itemkey,
3054: aname => 'APPS_FORM',
3055: avalue => l_form);
3056:

Line 3057: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3053: itemkey => l_itemkey,
3054: aname => 'APPS_FORM',
3055: avalue => l_form);
3056:
3057: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3058: itemkey => l_itemkey,
3059: aname => 'ITEM_NUMBER',
3060: avalue => l_ITEM_NUMBER);
3061:

Line 3062: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3058: itemkey => l_itemkey,
3059: aname => 'ITEM_NUMBER',
3060: avalue => l_ITEM_NUMBER);
3061:
3062: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3063: itemkey => l_itemkey,
3064: aname => 'ITEM_REVISION',
3065: avalue => l_REVISION);
3066:

Line 3067: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3063: itemkey => l_itemkey,
3064: aname => 'ITEM_REVISION',
3065: avalue => l_REVISION);
3066:
3067: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3068: itemkey => l_itemkey,
3069: aname => 'ITEM_DESC',
3070: avalue => l_item_desc);
3071:

Line 3072: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3068: itemkey => l_itemkey,
3069: aname => 'ITEM_DESC',
3070: avalue => l_item_desc);
3071:
3072: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3073: itemkey => l_itemkey,
3074: aname => 'ORGANIZATION_CODE',
3075: avalue => l_organization_code);
3076:

Line 3077: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3073: itemkey => l_itemkey,
3074: aname => 'ORGANIZATION_CODE',
3075: avalue => l_organization_code);
3076:
3077: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3078: itemkey => l_itemkey,
3079: aname => 'SUBINVENTORY',
3080: avalue => l_subinventory);
3081:

Line 3082: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3078: itemkey => l_itemkey,
3079: aname => 'SUBINVENTORY',
3080: avalue => l_subinventory);
3081:
3082: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3083: itemkey => l_itemkey,
3084: aname => 'LOCATOR',
3085: avalue => l_locator);
3086:

Line 3087: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3083: itemkey => l_itemkey,
3084: aname => 'LOCATOR',
3085: avalue => l_locator);
3086:
3087: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3088: itemkey => l_itemkey,
3089: aname => 'FORMULA_NO',
3090: avalue => l_formula_no);
3091:

Line 3092: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3088: itemkey => l_itemkey,
3089: aname => 'FORMULA_NO',
3090: avalue => l_formula_no);
3091:
3092: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3093: itemkey => l_itemkey,
3094: aname => 'RECIPE_NO',
3095: avalue => l_recipe_no);
3096:

Line 3097: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3093: itemkey => l_itemkey,
3094: aname => 'RECIPE_NO',
3095: avalue => l_recipe_no);
3096:
3097: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3098: itemkey => l_itemkey,
3099: aname => 'BATCH_NO',
3100: avalue => l_batch_no);
3101:

Line 3102: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3098: itemkey => l_itemkey,
3099: aname => 'BATCH_NO',
3100: avalue => l_batch_no);
3101:
3102: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3103: itemkey => l_itemkey,
3104: aname => 'BATCH_STEP_NO',
3105: avalue => l_step_no);
3106:

Line 3107: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3103: itemkey => l_itemkey,
3104: aname => 'BATCH_STEP_NO',
3105: avalue => l_step_no);
3106:
3107: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3108: itemkey => l_itemkey,
3109: aname => 'SAMPLING_PLAN',
3110: avalue => l_sample_plan);
3111:

Line 3112: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

3108: itemkey => l_itemkey,
3109: aname => 'SAMPLING_PLAN',
3110: avalue => l_sample_plan);
3111:
3112: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
3113: itemkey => p_itemkey,
3114: aname => '#FROM_ROLE',
3115: avalue => l_from_role);
3116:

Line 3117: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3113: itemkey => p_itemkey,
3114: aname => '#FROM_ROLE',
3115: avalue => l_from_role);
3116:
3117: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3118: itemkey => l_itemkey,
3119: aname => 'AME_TRANS',
3120: avalue => l_transaction_type);
3121:

Line 3123: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3119: aname => 'AME_TRANS',
3120: avalue => l_transaction_type);
3121:
3122: -- RLNAGARA Bug 5032406 (FP of 4604305 ME) Setting spec name and version wf attributes
3123: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3124: itemkey => l_itemkey,
3125: aname => 'SPEC_NAME',
3126: avalue => l_spec_name);
3127: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

Line 3127: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

3123: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3124: itemkey => l_itemkey,
3125: aname => 'SPEC_NAME',
3126: avalue => l_spec_name);
3127: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
3128: itemkey => l_itemkey,
3129: aname => 'SPEC_VERS',
3130: avalue => l_spec_vers);
3131:

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

3130: avalue => l_spec_vers);
3131:
3132: WF_LOG_PKG.STRING(6, 'Setting', 'Setting Parent');
3133:
3134: WF_ENGINE.SETITEMPARENT(itemtype => l_itemtype,
3135: itemkey => l_itemkey,
3136: parent_itemtype => p_itemtype,
3137: parent_itemkey => p_itemkey,
3138: parent_context => NULL);

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

3137: parent_itemkey => p_itemkey,
3138: parent_context => NULL);
3139:
3140: /* As this a pure FYI notification we will set the approver to approve status */
3141: /* Bug #4576699 Moved this code before WF_ENGINE.STARTPROCESS so that
3142: CHECK_NEXT_APPROVER doesn't fetch records from the first approver to whom
3143: a notification is already sent */
3144:
3145: Approver.approval_status := AME_UTIL.APPROVEDSTATUS;

Line 3154: WF_ENGINE.STARTPROCESS(itemtype => l_itemtype,

3150: forwardeeIn => AME_UTIL.EMPTYAPPROVERRECORD);
3151:
3152: /* start the Workflow process */
3153: --WF_LOG_PKG.STRING(6, 'Dummy','Starting Process');
3154: WF_ENGINE.STARTPROCESS(itemtype => l_itemtype,
3155: itemkey => l_itemkey);
3156: END IF; /* Added in Bug no. 7033224 */
3157: END IF; /* Spec Found */
3158: END LOOP;

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

3177: p_itemkey IN VARCHAR2,
3178: p_actid IN NUMBER,
3179: p_funcmode IN VARCHAR2,
3180: p_resultout OUT NOCOPY VARCHAR2) IS
3181: l_event_name varchar2(240) := WF_ENGINE.GETITEMATTRTEXT(itemtype => p_itemtype,
3182: itemkey => P_itemkey,
3183: aname => 'EVENT_NAME');
3184:
3185: BEGIN