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

Line 122: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

118: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
119: l_api_name,l_debug_info);
120: END IF;
121:
122: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
123: itemkey,
124: 'ORG_ID');
125:
126: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 126: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

122: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
123: itemkey,
124: 'ORG_ID');
125:
126: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
127: itemkey,
128: 'INVOICE_ID');
129:
130: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 130: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,

126: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
127: itemkey,
128: 'INVOICE_ID');
129:
130: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,
131: itemkey,
132: 'ITERATION');
133:
134: l_debug_info := 'get invoice amount';

Line 233: resultout := wf_engine.eng_completed||':'||'N';

229: SET WFApproval_Status = 'NOT REQUIRED'
230: WHERE Invoice_Id = l_invoice_id
231: AND WFApproval_Status = 'INITIATED';
232:
233: resultout := wf_engine.eng_completed||':'||'N';
234:
235: --we do not care if there are anymore
236: --productions
237: EXIT;

Line 300: resultout := wf_engine.eng_completed||':'||'N';

296: SET WFApproval_Status = 'REJECTED'
297: WHERE Invoice_Id = l_invoice_id
298: AND WFApproval_Status = 'INITIATED';
299:
300: resultout := wf_engine.eng_completed||':'||'N';
301: END IF; --required and rejected
302:
303: ELSE --there were no production results
304:

Line 310: resultout := wf_engine.eng_completed||':'||'Y';

306: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
308: l_api_name,l_debug_info);
309: END IF;
310: resultout := wf_engine.eng_completed||':'||'Y';
311:
312: END IF;
313:
314: resultout := nvl(resultout, wf_engine.eng_completed||':'||'Y');

Line 314: resultout := nvl(resultout, wf_engine.eng_completed||':'||'Y');

310: resultout := wf_engine.eng_completed||':'||'Y';
311:
312: END IF;
313:
314: resultout := nvl(resultout, wf_engine.eng_completed||':'||'Y');
315:
316: EXCEPTION
317: WHEN OTHERS
318: THEN

Line 368: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

364: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
365: l_api_name,l_debug_info);
366: END IF;
367:
368: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
369: itemkey,
370: 'ORG_ID');
371:
372: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 372: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

368: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
369: itemkey,
370: 'ORG_ID');
371:
372: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
373: itemkey,
374: 'INVOICE_ID');
375:
376: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 376: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,

372: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
373: itemkey,
374: 'INVOICE_ID');
375:
376: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,
377: itemkey,
378: 'ITERATION');
379:
380: --check AME if any production rules should prevent approval

Line 510: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

506: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
507: l_api_name,l_debug_info);
508: END IF;
509:
510: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
511: itemkey,
512: 'INVOICE_ID');
513:
514: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 514: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,

510: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
511: itemkey,
512: 'INVOICE_ID');
513:
514: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,
515: itemkey,
516: 'ITERATION');
517:
518: l_debug_info := l_api_name ||': invoice_id = ' || l_invoice_id ||

Line 729: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

725: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
726: l_api_name,l_debug_info);
727: END IF;
728:
729: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
730: itemkey,
731: 'INVOICE_ID');
732:
733: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 733: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,

729: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
730: itemkey,
731: 'INVOICE_ID');
732:
733: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,
734: itemkey,
735: 'ITERATION');
736:
737: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 737: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

733: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,
734: itemkey,
735: 'ITERATION');
736:
737: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
738: itemkey,
739: 'ORG_ID');
740:
741: l_debug_info := l_api_name || ': get variables from workflow' ||

Line 1365: wf_engine.CompleteActivity(

1361: END IF;
1362:
1363: --amy
1364: --Let the parent process continue
1365: wf_engine.CompleteActivity(
1366: itemType => 'APINVLDP',
1367: itemKey => l_invoice_key,
1368: activity => 'APPROVAL_STAGING:BLOCK-LNP',
1369: result => 'NULL');

Line 1409: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,

1405: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1406: END IF;
1407:
1408: --Get the current approver info
1409: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,
1410: itemkey,
1411: 'APPROVER_ID');
1412:
1413: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 1413: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

1409: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,
1410: itemkey,
1411: 'APPROVER_ID');
1412:
1413: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
1414: itemkey,
1415: 'INVOICE_ID');
1416:
1417: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 1417: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,

1413: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
1414: itemkey,
1415: 'INVOICE_ID');
1416:
1417: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,
1418: itemkey,
1419: 'INVOICE_ITERATION');
1420:
1421: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 1421: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,

1417: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,
1418: itemkey,
1419: 'INVOICE_ITERATION');
1420:
1421: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,
1422: itemkey,
1423: 'ORG_ID');
1424:
1425: l_role := WF_ENGINE.GetItemAttrText(itemtype,

Line 1425: l_role := WF_ENGINE.GetItemAttrText(itemtype,

1421: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,
1422: itemkey,
1423: 'ORG_ID');
1424:
1425: l_role := WF_ENGINE.GetItemAttrText(itemtype,
1426: itemkey,
1427: 'ROLE_NAME');
1428:
1429:

Line 1465: WF_ENGINE.SetItemAttrText(itemtype,

1461: itemIdIn => to_char(l_invoice_id),
1462: forwardeeIn => l_esc_approver);
1463:
1464: --Set WF attributes
1465: WF_ENGINE.SetItemAttrText(itemtype,
1466: itemkey,
1467: 'ESC_APPROVER_NAME',
1468: l_esc_approver_name);
1469:

Line 1470: WF_ENGINE.SetItemAttrNumber(itemtype,

1466: itemkey,
1467: 'ESC_APPROVER_NAME',
1468: l_esc_approver_name);
1469:
1470: WF_ENGINE.SetItemAttrNumber(itemtype,
1471: itemkey,
1472: 'ESC_APPROVER_ID',
1473: l_esc_approver_id);
1474:

Line 1475: WF_ENGINE.SetItemAttrText(itemtype,

1471: itemkey,
1472: 'ESC_APPROVER_ID',
1473: l_esc_approver_id);
1474:
1475: WF_ENGINE.SetItemAttrText(itemtype,
1476: itemkey,
1477: 'ESC_ROLE_NAME',
1478: l_esc_role);
1479:

Line 1541: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,

1537: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1538: END IF;
1539:
1540: --Get the current approver info
1541: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,
1542: itemkey,
1543: 'APPROVER_ID');
1544:
1545: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 1545: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

1541: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,
1542: itemkey,
1543: 'APPROVER_ID');
1544:
1545: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
1546: itemkey,
1547: 'INVOICE_ID');
1548:
1549: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 1549: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,

1545: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
1546: itemkey,
1547: 'INVOICE_ID');
1548:
1549: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,
1550: itemkey,
1551: 'INVOICE_ITERATION');
1552:
1553: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 1553: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,

1549: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,
1550: itemkey,
1551: 'INVOICE_ITERATION');
1552:
1553: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,
1554: itemkey,
1555: 'ORG_ID');
1556:
1557: l_role := WF_ENGINE.GetItemAttrText(itemtype,

Line 1557: l_role := WF_ENGINE.GetItemAttrText(itemtype,

1553: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,
1554: itemkey,
1555: 'ORG_ID');
1556:
1557: l_role := WF_ENGINE.GetItemAttrText(itemtype,
1558: itemkey,
1559: 'ROLE_NAME');
1560:
1561: --Now set the environment

Line 1605: WF_ENGINE.SetItemAttrText(itemtype,

1601: END LOOP;
1602: CLOSE Items_Cur;
1603:
1604: --Set WF attributes
1605: WF_ENGINE.SetItemAttrText(itemtype,
1606: itemkey,
1607: 'ESC_APPROVER_NAME',
1608: l_esc_approver_name);
1609:

Line 1610: WF_ENGINE.SetItemAttrNumber(itemtype,

1606: itemkey,
1607: 'ESC_APPROVER_NAME',
1608: l_esc_approver_name);
1609:
1610: WF_ENGINE.SetItemAttrNumber(itemtype,
1611: itemkey,
1612: 'ESC_APPROVER_ID',
1613: l_esc_approver_id);
1614:

Line 1615: WF_ENGINE.SetItemAttrText(itemtype,

1611: itemkey,
1612: 'ESC_APPROVER_ID',
1613: l_esc_approver_id);
1614:
1615: WF_ENGINE.SetItemAttrText(itemtype,
1616: itemkey,
1617: 'ESC_ROLE_NAME',
1618: l_esc_role);
1619:

Line 1709: l_result := WF_ENGINE.GetActivityAttrText(itemtype => itemtype,

1705: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1706: END IF;
1707:
1708: --Get wf attribute values
1709: l_result := WF_ENGINE.GetActivityAttrText(itemtype => itemtype,
1710: itemkey => itemkey,
1711: actid => actid,
1712: aname => 'NOTIFICATION_RESULT');
1713:

Line 1714: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

1710: itemkey => itemkey,
1711: actid => actid,
1712: aname => 'NOTIFICATION_RESULT');
1713:
1714: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
1715: itemkey,
1716: 'INVOICE_ID');
1717:
1718: l_debug_info := l_api_name || ': itemtype = ' || itemtype

Line 1785: wf_engine.CompleteActivity(

1781:
1782: --Unblock the APINV parent process
1783: -- amy may need to make the Block a start node
1784: -- or use suspend/resume wf apis
1785: wf_engine.CompleteActivity(
1786: itemType => 'APINVLDP',
1787: itemKey => l_invoice_key,
1788: activity => 'APPROVAL_STAGING:BLOCK-1',
1789: result => 'NULL');

Line 1880: wf_engine.CompleteActivity(

1876:
1877: --Unblock the APINV parent process
1878: -- amy may need to make the Block a start node
1879: -- or use suspend/resume wf apis
1880: wf_engine.CompleteActivity(
1881: itemtype => 'APINVLDP',
1882: itemkey => l_invoice_key,
1883: activity => 'APPROVAL_STAGING:BLOCK-1',
1884: result => 'NULL');

Line 2084: WF_ENGINE.SetItemAttrText(itemtype,

2080: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2081: l_api_name,l_debug_info);
2082: END IF;
2083:
2084: WF_ENGINE.SetItemAttrText(itemtype,
2085: itemkey,
2086: 'NOTIFICATION_KEY',
2087: l_not_key);
2088:

Line 2089: WF_ENGINE.SetItemAttrNumber(itemtype,

2085: itemkey,
2086: 'NOTIFICATION_KEY',
2087: l_not_key);
2088:
2089: WF_ENGINE.SetItemAttrNumber(itemtype,
2090: itemkey,
2091: 'ITERATION',
2092: l_not_it);
2093:

Line 2113: WF_ENGINE.SetItemAttrNumber(itemtype,

2109: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2110: l_api_name,l_debug_info);
2111: END IF;
2112:
2113: WF_ENGINE.SetItemAttrNumber(itemtype,
2114: itemkey,
2115: 'APPROVER_ID',
2116: l_orig_id);
2117:

Line 2118: WF_ENGINE.SetItemAttrNumber(itemtype,

2114: itemkey,
2115: 'APPROVER_ID',
2116: l_orig_id);
2117:
2118: WF_ENGINE.SetItemAttrNumber(itemtype,
2119: itemkey,
2120: 'INVOICE_ITERATION',
2121: l_iteration);
2122:

Line 2123: WF_ENGINE.SetItemAttrText(itemtype,

2119: itemkey,
2120: 'INVOICE_ITERATION',
2121: l_iteration);
2122:
2123: WF_ENGINE.SetItemAttrText(itemtype,
2124: itemkey,
2125: 'NOTIFICATION_KEY',
2126: l_not_key);
2127:

Line 2128: WF_ENGINE.SetItemAttrNumber(itemtype,

2124: itemkey,
2125: 'NOTIFICATION_KEY',
2126: l_not_key);
2127:
2128: WF_ENGINE.SetItemAttrNumber(itemtype,
2129: itemkey,
2130: 'NOTIFICATION_ITERATION',
2131: l_not_it);
2132:

Line 2133: WF_ENGINE.SetItemAttrNumber(itemtype,

2129: itemkey,
2130: 'NOTIFICATION_ITERATION',
2131: l_not_it);
2132:
2133: WF_ENGINE.SetItemAttrNumber(itemtype,
2134: itemkey,
2135: 'ORG_ID',
2136: l_org_id);
2137:

Line 2138: WF_ENGINE.SetItemAttrNumber(itemtype,

2134: itemkey,
2135: 'ORG_ID',
2136: l_org_id);
2137:
2138: WF_ENGINE.SetItemAttrNumber(itemtype,
2139: itemkey,
2140: 'INVOICE_ID',
2141: l_invoice_id);
2142:

Line 2143: WF_ENGINE.SetItemAttrText(itemtype,

2139: itemkey,
2140: 'INVOICE_ID',
2141: l_invoice_id);
2142:
2143: WF_ENGINE.SetItemAttrText(itemtype,
2144: itemkey,
2145: 'ROLE_NAME',
2146: l_role);
2147:

Line 2183: WF_ENGINE.SETITEMATTRTEXT

2179: END IF;
2180:
2181: --set wf attributes
2182:
2183: WF_ENGINE.SETITEMATTRTEXT
2184: (
2185: itemtype => itemtype,
2186: itemkey => itemkey,
2187: aname => 'INVOICE_SUPPLIER_NAME',

Line 2191: WF_ENGINE.SETITEMATTRTEXT

2187: aname => 'INVOICE_SUPPLIER_NAME',
2188: avalue => l_invoice_supplier_name
2189: );
2190:
2191: WF_ENGINE.SETITEMATTRTEXT
2192: (
2193: itemtype => itemtype,
2194: itemkey => itemkey,
2195: aname => 'INVOICE_SUPPLIER_SITE',

Line 2199: WF_ENGINE.SETITEMATTRTEXT

2195: aname => 'INVOICE_SUPPLIER_SITE',
2196: avalue => l_invoice_supplier_site
2197: );
2198:
2199: WF_ENGINE.SETITEMATTRTEXT
2200: (
2201: itemtype => itemtype,
2202: itemkey => itemkey,
2203: aname => 'INVOICE_NUMBER',

Line 2207: WF_ENGINE.SETITEMATTRDATE

2203: aname => 'INVOICE_NUMBER',
2204: avalue => l_invoice_number
2205: );
2206:
2207: WF_ENGINE.SETITEMATTRDATE
2208: (
2209: itemtype => itemtype,
2210: itemkey => itemkey,
2211: aname => 'INVOICE_DATE',

Line 2215: WF_ENGINE.SETITEMATTRTEXT

2211: aname => 'INVOICE_DATE',
2212: avalue => l_invoice_date
2213: );
2214:
2215: WF_ENGINE.SETITEMATTRTEXT
2216: (
2217: itemtype => itemtype,
2218: itemkey => itemkey,
2219: aname => 'INVOICE_DESCRIPTION',

Line 2223: WF_ENGINE.SETITEMATTRNUMBER

2219: aname => 'INVOICE_DESCRIPTION',
2220: avalue => l_invoice_description
2221: );
2222:
2223: WF_ENGINE.SETITEMATTRNUMBER
2224: (
2225: itemtype => itemtype,
2226: itemkey => itemkey,
2227: aname => 'INVOICE_TOTAL',

Line 2231: WF_ENGINE.SETITEMATTRTEXT

2227: aname => 'INVOICE_TOTAL',
2228: avalue => l_invoice_total
2229: );
2230:
2231: WF_ENGINE.SETITEMATTRTEXT
2232: (
2233: itemtype => itemtype,
2234: itemkey => itemkey,
2235: aname => 'INVOICE_CURRENCY_CODE',

Line 2241: WF_ENGINE.SETITEMATTRTEXT

2237: );
2238:
2239: /*amy failed gscc because of CHR()
2240: * find alternative
2241: WF_ENGINE.SETITEMATTRTEXT
2242: (
2243: itemtype => itemtype,
2244: itemkey => itemkey,
2245: aname => 'INVOICE_ATTACHMENTS',

Line 2358: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,

2354: END IF;
2355:
2356: --Get attribute values to create record in the history table
2357: IF p_type = 'ESC' THEN
2358: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2359: itemkey,
2360: 'ESC_APPROVER_ID');
2361: ELSE
2362: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 2362: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,

2358: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2359: itemkey,
2360: 'ESC_APPROVER_ID');
2361: ELSE
2362: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2363: itemkey,
2364: 'APPROVER_ID');
2365: END IF;
2366:

Line 2367: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

2363: itemkey,
2364: 'APPROVER_ID');
2365: END IF;
2366:
2367: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2368: itemkey,
2369: 'INVOICE_ID');
2370:
2371: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 2371: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,

2367: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2368: itemkey,
2369: 'INVOICE_ID');
2370:
2371: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,
2372: itemkey,
2373: 'INVOICE_ITERATION');
2374:
2375: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 2375: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,

2371: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,
2372: itemkey,
2373: 'INVOICE_ITERATION');
2374:
2375: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2376: itemkey,
2377: 'ORG_ID');
2378:
2379: l_amount := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 2379: l_amount := WF_ENGINE.GetItemAttrNumber(itemtype,

2375: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2376: itemkey,
2377: 'ORG_ID');
2378:
2379: l_amount := WF_ENGINE.GetItemAttrNumber(itemtype,
2380: itemkey,
2381: 'INVOICE_TOTAL');
2382:
2383: --Now set the environment

Line 2549: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,

2545: END IF;
2546:
2547: --Get attribute values to create record in the history table
2548: IF p_type = 'ESC' THEN
2549: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2550: itemkey,
2551: 'ESC_APPROVER_ID');
2552: ELSE
2553: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 2553: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,

2549: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2550: itemkey,
2551: 'ESC_APPROVER_ID');
2552: ELSE
2553: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2554: itemkey,
2555: 'APPROVER_ID');
2556: END IF;
2557:

Line 2558: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

2554: itemkey,
2555: 'APPROVER_ID');
2556: END IF;
2557:
2558: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2559: itemkey,
2560: 'INVOICE_ID');
2561:
2562: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 2562: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,

2558: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2559: itemkey,
2560: 'INVOICE_ID');
2561:
2562: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,
2563: itemkey,
2564: 'INVOICE_ITERATION');
2565:
2566: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 2566: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,

2562: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,
2563: itemkey,
2564: 'INVOICE_ITERATION');
2565:
2566: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2567: itemkey,
2568: 'ORG_ID');
2569:
2570: l_line_amt := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 2570: l_line_amt := WF_ENGINE.GetItemAttrNumber(itemtype,

2566: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2567: itemkey,
2568: 'ORG_ID');
2569:
2570: l_line_amt := WF_ENGINE.GetItemAttrNumber(itemtype,
2571: itemkey,
2572: 'LINE_TOTAL');
2573:
2574: --Now set the environment

Line 2669: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

2665: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2666: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2667: END IF;
2668:
2669: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2670: itemkey,
2671: 'INVOICE_ID');
2672:
2673: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 2673: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,

2669: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2670: itemkey,
2671: 'INVOICE_ID');
2672:
2673: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,
2674: itemkey,
2675: 'INVOICE_ITERATION');
2676:
2677: l_comments := WF_ENGINE.GetItemAttrText(itemtype,

Line 2677: l_comments := WF_ENGINE.GetItemAttrText(itemtype,

2673: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,
2674: itemkey,
2675: 'INVOICE_ITERATION');
2676:
2677: l_comments := WF_ENGINE.GetItemAttrText(itemtype,
2678: itemkey,
2679: 'WF_NOTE');
2680:
2681: l_result := WF_ENGINE.GetActivityAttrText(itemtype,

Line 2681: l_result := WF_ENGINE.GetActivityAttrText(itemtype,

2677: l_comments := WF_ENGINE.GetItemAttrText(itemtype,
2678: itemkey,
2679: 'WF_NOTE');
2680:
2681: l_result := WF_ENGINE.GetActivityAttrText(itemtype,
2682: itemkey,
2683: actid,
2684: 'NOTIFICATION_RESULT');
2685:

Line 2686: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

2682: itemkey,
2683: actid,
2684: 'NOTIFICATION_RESULT');
2685:
2686: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
2687: itemkey,
2688: 'ORG_ID');
2689:
2690: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

Line 2816: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

2812: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2813: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2814: END IF;
2815:
2816: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2817: itemkey,
2818: 'INVOICE_ID');
2819:
2820: l_comments := WF_ENGINE.GetItemAttrText(itemtype,

Line 2820: l_comments := WF_ENGINE.GetItemAttrText(itemtype,

2816: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2817: itemkey,
2818: 'INVOICE_ID');
2819:
2820: l_comments := WF_ENGINE.GetItemAttrText(itemtype,
2821: itemkey,
2822: 'WF_NOTE');
2823:
2824: l_result := WF_ENGINE.GetActivityAttrText(itemtype,

Line 2824: l_result := WF_ENGINE.GetActivityAttrText(itemtype,

2820: l_comments := WF_ENGINE.GetItemAttrText(itemtype,
2821: itemkey,
2822: 'WF_NOTE');
2823:
2824: l_result := WF_ENGINE.GetActivityAttrText(itemtype,
2825: itemkey,
2826: actid,
2827: 'NOTIFICATION_RESULT');
2828:

Line 2829: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

2825: itemkey,
2826: actid,
2827: 'NOTIFICATION_RESULT');
2828:
2829: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
2830: itemkey,
2831: 'ORG_ID');
2832:
2833: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

Line 3060: WF_Engine.abortProcess(

3056: end if;
3057:
3058: IF p_line_number IS NULL THEN
3059: --End WF processes
3060: WF_Engine.abortProcess(
3061: itemType => 'APINVLDP',
3062: itemKey => l_invoice_key,
3063: process => 'APPROVAL_STAGING');
3064:

Line 3089: WF_Engine.abortProcess(

3085: itemIdIn => l_item_id);
3086:
3087: IF l_not_key <> nvl(l_old_not_key, 'dummy') THEN
3088:
3089: WF_Engine.abortProcess(
3090: itemType => 'APINVLPN',
3091: itemKey => l_not_key,
3092: process => 'SEND_NOTIFICATIONS');
3093:

Line 3126: WF_Engine.abortProcess(

3122: itemIdIn => l_item_id);
3123:
3124: IF l_not_key <> nvl(l_old_not_key, 'dummy') THEN
3125:
3126: WF_Engine.abortProcess(
3127: itemType => 'APINVLPN',
3128: itemKey => l_not_key,
3129: process => 'SEND_NOTIFICATIONS');
3130:

Line 3201: WF_Engine.abortProcess(

3197: EXIT WHEN key_Cur%NOTFOUND OR key_Cur%NOTFOUND IS NULL;
3198:
3199: --only the sent records are active wf processes
3200: IF l_not_status = 'SENT' THEN
3201: WF_Engine.abortProcess(
3202: itemType => 'APINVLPN',
3203: itemKey => l_not_key,
3204: process => 'SEND_NOTIFICATIONS');
3205: END IF;

Line 3210: WF_Engine.abortProcess(

3206:
3207: --we only need to update at the header level once
3208: IF l_invoice_key <> nvl(l_old_inv_key, 'dummy') THEN
3209:
3210: WF_Engine.abortProcess(
3211: itemType => 'APINVLDP',
3212: itemKey => l_invoice_key,
3213: process => 'APPROVAL_STAGING');
3214:

Line 3757: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

3753: l_invoice_id NUMBER;
3754: l_num number;
3755:
3756: begin
3757: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
3758: itemkey,
3759: 'ORG_ID');
3760:
3761: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 3761: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

3757: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
3758: itemkey,
3759: 'ORG_ID');
3760:
3761: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
3762: itemkey,
3763: 'INVOICE_ID');
3764:
3765: update ap_invoice_lines_all il

Line 3791: resultout := wf_engine.eng_completed||':'||'N';

3787: and org_id = l_org_id
3788: and disputable_flag = 'Y';
3789:
3790: if l_num = 0 then
3791: resultout := wf_engine.eng_completed||':'||'N';
3792: else
3793: resultout := wf_engine.eng_completed||':'||'Y';
3794: end if;
3795:

Line 3793: resultout := wf_engine.eng_completed||':'||'Y';

3789:
3790: if l_num = 0 then
3791: resultout := wf_engine.eng_completed||':'||'N';
3792: else
3793: resultout := wf_engine.eng_completed||':'||'Y';
3794: end if;
3795:
3796: end is_disputable;
3797:

Line 3808: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

3804: l_invoice_id NUMBER;
3805: l_num number;
3806:
3807: begin
3808: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
3809: itemkey,
3810: 'ORG_ID');
3811:
3812: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 3812: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

3808: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
3809: itemkey,
3810: 'ORG_ID');
3811:
3812: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
3813: itemkey,
3814: 'INVOICE_ID');
3815: select count(*)
3816: into l_num

Line 3823: resultout := wf_engine.eng_completed||':'||'N';

3819: and org_id = l_org_id
3820: and hold_lookup_code in ('QTY REC', 'AMT REC');
3821:
3822: if l_num = 0 then
3823: resultout := wf_engine.eng_completed||':'||'N';
3824: else
3825: resultout := wf_engine.eng_completed||':'||'Y';
3826: end if;
3827:

Line 3825: resultout := wf_engine.eng_completed||':'||'Y';

3821:
3822: if l_num = 0 then
3823: resultout := wf_engine.eng_completed||':'||'N';
3824: else
3825: resultout := wf_engine.eng_completed||':'||'Y';
3826: end if;
3827:
3828: end exists_receiving_hold;
3829:

Line 4070: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4066: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4067: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
4068: END IF;
4069:
4070: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4071: itemkey,
4072: 'INVOICE_ID');
4073:
4074: l_invoice_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 4074: l_invoice_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,

4070: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4071: itemkey,
4072: 'INVOICE_ID');
4073:
4074: l_invoice_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,
4075: itemkey,
4076: 'ITERATION');
4077:
4078: l_debug_info := l_api_name || ': get variables from workflow: itemtype = ' ||

Line 4232: l_fallback_role_name := WF_ENGINE.GETITEMATTRText(itemtype,

4228:
4229: -- last priority: Payables WF role - preseeded, user needs to assign a user with it
4230: if ( l_line_appr_tbl.COUNT = 0 ) then
4231: -- get default AP fallback role
4232: l_fallback_role_name := WF_ENGINE.GETITEMATTRText(itemtype,
4233: itemkey,
4234: 'FALL_BACK_INT_REP');
4235:
4236: assign_generic_role_for_lines(p_line_appr_tbl => l_line_appr_tbl,

Line 4303: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4299: and il.org_id = l_org_id
4300: and u.user_id = i.created_by;
4301:
4302: begin
4303: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4304: itemkey,
4305: 'ORG_ID');
4306:
4307: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 4307: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4303: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4304: itemkey,
4305: 'ORG_ID');
4306:
4307: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4308: itemkey,
4309: 'INVOICE_ID');
4310:
4311: for l_rec in internal_reps loop

Line 4346: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4342: l_org_id NUMBER;
4343: l_invoice_id NUMBER;
4344:
4345: begin
4346: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4347: itemkey,
4348: 'ORG_ID');
4349:
4350: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 4350: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4346: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4347: itemkey,
4348: 'ORG_ID');
4349:
4350: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4351: itemkey,
4352: 'INVOICE_ID');
4353:
4354: select count(*)

Line 4363: resultout := wf_engine.eng_completed||':'||'N';

4359: and line_owner_role is null
4360: and line_type_lookup_code = 'ITEM';
4361:
4362: if l_num = 0 then
4363: resultout := wf_engine.eng_completed||':'||'N';
4364: else
4365: resultout := wf_engine.eng_completed||':'||'Y';
4366: end if;
4367: end;

Line 4365: resultout := wf_engine.eng_completed||':'||'Y';

4361:
4362: if l_num = 0 then
4363: resultout := wf_engine.eng_completed||':'||'N';
4364: else
4365: resultout := wf_engine.eng_completed||':'||'Y';
4366: end if;
4367: end;
4368:
4369: PROCEDURE asgn_fallback_int_rep(itemtype IN VARCHAR2,

Line 4379: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4375: l_org_id NUMBER;
4376: l_invoice_id NUMBER;
4377:
4378: begin
4379: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4380: itemkey,
4381: 'ORG_ID');
4382:
4383: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 4383: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4379: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4380: itemkey,
4381: 'ORG_ID');
4382:
4383: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4384: itemkey,
4385: 'INVOICE_ID');
4386:
4387: l_role := wf_engine.getItemAttrText(itemType, itemKey, 'FALL_BACK_INT_REP');

Line 4387: l_role := wf_engine.getItemAttrText(itemType, itemKey, 'FALL_BACK_INT_REP');

4383: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4384: itemkey,
4385: 'INVOICE_ID');
4386:
4387: l_role := wf_engine.getItemAttrText(itemType, itemKey, 'FALL_BACK_INT_REP');
4388:
4389: update ap_invoice_lines_all
4390: set line_owner_role = l_role
4391: where invoice_id = l_invoice_id

Line 4409: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4405: resultout OUT NOCOPY VARCHAR2) as
4406: l_num number;
4407: l_invoice_id NUMBER;
4408: begin
4409: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4410: itemkey,
4411: 'INVOICE_ID');
4412:
4413: select count(*)

Line 4421: resultout := wf_engine.eng_completed||':'||'Y';

4417: and invoice_key = itemKey
4418: and notification_status is NULL;
4419:
4420: if l_num > 0 then
4421: resultout := wf_engine.eng_completed||':'||'Y';
4422: else
4423: resultout := wf_engine.eng_completed||':'||'N';
4424: end if;
4425: end;

Line 4423: resultout := wf_engine.eng_completed||':'||'N';

4419:
4420: if l_num > 0 then
4421: resultout := wf_engine.eng_completed||':'||'Y';
4422: else
4423: resultout := wf_engine.eng_completed||':'||'N';
4424: end if;
4425: end;
4426:
4427: PROCEDURE is_rejected( itemtype IN VARCHAR2,

Line 4439: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4435: l_r varchar2(1);
4436: l_dispute_key varchar2(320);
4437:
4438: begin
4439: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4440: itemkey,
4441: 'INVOICE_ID');
4442: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4443: itemkey,

Line 4442: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4438: begin
4439: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4440: itemkey,
4441: 'INVOICE_ID');
4442: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4443: itemkey,
4444: 'ORG_ID');
4445: begin
4446: select 'X'

Line 4466: resultout := wf_engine.eng_completed||':'||l_r;

4462: l_r := 'N';
4463: else
4464: l_r := 'Y';
4465: end if;
4466: resultout := wf_engine.eng_completed||':'||l_r;
4467: end;
4468:
4469:
4470: PROCEDURE launch_disp_notif_flow(itemtype IN VARCHAR2,

Line 4512: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4508: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4509: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
4510: END IF;
4511:
4512: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4513: itemkey,
4514: 'INVOICE_ID');
4515: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,
4516: itemkey,

Line 4515: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,

4511:
4512: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4513: itemkey,
4514: 'INVOICE_ID');
4515: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,
4516: itemkey,
4517: 'ITERATION');
4518: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4519: itemkey,

Line 4518: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4514: 'INVOICE_ID');
4515: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,
4516: itemkey,
4517: 'ITERATION');
4518: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4519: itemkey,
4520: 'ORG_ID');
4521: l_debug_info := l_api_name || ': itemtype ='|| itemtype ||
4522: ', itemkey = ' || itemkey ||

Line 4559: wf_engine.createProcess('APINVLDN', l_notification_key, 'DISP_NOTIF_PROCESS');

4555:
4556: EXIT WHEN dispute_process_csr%NOTFOUND;
4557:
4558:
4559: wf_engine.createProcess('APINVLDN', l_notification_key, 'DISP_NOTIF_PROCESS');
4560:
4561: WF_ENGINE.SetItemAttrNumber('APINVLDN', l_notification_key, 'ORG_ID',l_org_id);
4562: WF_ENGINE.SetItemAttrNumber('APINVLDN', l_notification_key, 'INVOICE_ID', l_invoice_id);
4563: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);

Line 4561: WF_ENGINE.SetItemAttrNumber('APINVLDN', l_notification_key, 'ORG_ID',l_org_id);

4557:
4558:
4559: wf_engine.createProcess('APINVLDN', l_notification_key, 'DISP_NOTIF_PROCESS');
4560:
4561: WF_ENGINE.SetItemAttrNumber('APINVLDN', l_notification_key, 'ORG_ID',l_org_id);
4562: WF_ENGINE.SetItemAttrNumber('APINVLDN', l_notification_key, 'INVOICE_ID', l_invoice_id);
4563: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
4564: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);
4565: WF_ENGINE.SETITEMATTRDATE('APINVLDN', l_notification_key,'INVOICE_DATE',l_invoice_date);

Line 4562: WF_ENGINE.SetItemAttrNumber('APINVLDN', l_notification_key, 'INVOICE_ID', l_invoice_id);

4558:
4559: wf_engine.createProcess('APINVLDN', l_notification_key, 'DISP_NOTIF_PROCESS');
4560:
4561: WF_ENGINE.SetItemAttrNumber('APINVLDN', l_notification_key, 'ORG_ID',l_org_id);
4562: WF_ENGINE.SetItemAttrNumber('APINVLDN', l_notification_key, 'INVOICE_ID', l_invoice_id);
4563: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
4564: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);
4565: WF_ENGINE.SETITEMATTRDATE('APINVLDN', l_notification_key,'INVOICE_DATE',l_invoice_date);
4566: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);

Line 4563: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);

4559: wf_engine.createProcess('APINVLDN', l_notification_key, 'DISP_NOTIF_PROCESS');
4560:
4561: WF_ENGINE.SetItemAttrNumber('APINVLDN', l_notification_key, 'ORG_ID',l_org_id);
4562: WF_ENGINE.SetItemAttrNumber('APINVLDN', l_notification_key, 'INVOICE_ID', l_invoice_id);
4563: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
4564: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);
4565: WF_ENGINE.SETITEMATTRDATE('APINVLDN', l_notification_key,'INVOICE_DATE',l_invoice_date);
4566: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);
4567: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'NOTIFICATION_KEY',l_notification_key);

Line 4564: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);

4560:
4561: WF_ENGINE.SetItemAttrNumber('APINVLDN', l_notification_key, 'ORG_ID',l_org_id);
4562: WF_ENGINE.SetItemAttrNumber('APINVLDN', l_notification_key, 'INVOICE_ID', l_invoice_id);
4563: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
4564: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);
4565: WF_ENGINE.SETITEMATTRDATE('APINVLDN', l_notification_key,'INVOICE_DATE',l_invoice_date);
4566: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);
4567: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'NOTIFICATION_KEY',l_notification_key);
4568: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'DISP_NOT_RECEIVER',l_role_name);

Line 4565: WF_ENGINE.SETITEMATTRDATE('APINVLDN', l_notification_key,'INVOICE_DATE',l_invoice_date);

4561: WF_ENGINE.SetItemAttrNumber('APINVLDN', l_notification_key, 'ORG_ID',l_org_id);
4562: WF_ENGINE.SetItemAttrNumber('APINVLDN', l_notification_key, 'INVOICE_ID', l_invoice_id);
4563: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
4564: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);
4565: WF_ENGINE.SETITEMATTRDATE('APINVLDN', l_notification_key,'INVOICE_DATE',l_invoice_date);
4566: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);
4567: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'NOTIFICATION_KEY',l_notification_key);
4568: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'DISP_NOT_RECEIVER',l_role_name);
4569:

Line 4566: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);

4562: WF_ENGINE.SetItemAttrNumber('APINVLDN', l_notification_key, 'INVOICE_ID', l_invoice_id);
4563: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
4564: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);
4565: WF_ENGINE.SETITEMATTRDATE('APINVLDN', l_notification_key,'INVOICE_DATE',l_invoice_date);
4566: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);
4567: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'NOTIFICATION_KEY',l_notification_key);
4568: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'DISP_NOT_RECEIVER',l_role_name);
4569:
4570: WF_ENGINE.setItemParent('APINVLDN', l_notification_key,

Line 4567: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'NOTIFICATION_KEY',l_notification_key);

4563: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
4564: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);
4565: WF_ENGINE.SETITEMATTRDATE('APINVLDN', l_notification_key,'INVOICE_DATE',l_invoice_date);
4566: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);
4567: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'NOTIFICATION_KEY',l_notification_key);
4568: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'DISP_NOT_RECEIVER',l_role_name);
4569:
4570: WF_ENGINE.setItemParent('APINVLDN', l_notification_key,
4571: 'APINVLDP', itemkey, null);

Line 4568: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'DISP_NOT_RECEIVER',l_role_name);

4564: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);
4565: WF_ENGINE.SETITEMATTRDATE('APINVLDN', l_notification_key,'INVOICE_DATE',l_invoice_date);
4566: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);
4567: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'NOTIFICATION_KEY',l_notification_key);
4568: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'DISP_NOT_RECEIVER',l_role_name);
4569:
4570: WF_ENGINE.setItemParent('APINVLDN', l_notification_key,
4571: 'APINVLDP', itemkey, null);
4572:

Line 4570: WF_ENGINE.setItemParent('APINVLDN', l_notification_key,

4566: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);
4567: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'NOTIFICATION_KEY',l_notification_key);
4568: WF_ENGINE.SETITEMATTRTEXT('APINVLDN', l_notification_key,'DISP_NOT_RECEIVER',l_role_name);
4569:
4570: WF_ENGINE.setItemParent('APINVLDN', l_notification_key,
4571: 'APINVLDP', itemkey, null);
4572:
4573: wf_engine.startProcess('APINVLDN', l_notification_key);
4574:

Line 4573: wf_engine.startProcess('APINVLDN', l_notification_key);

4569:
4570: WF_ENGINE.setItemParent('APINVLDN', l_notification_key,
4571: 'APINVLDP', itemkey, null);
4572:
4573: wf_engine.startProcess('APINVLDN', l_notification_key);
4574:
4575: update ap_apinv_approvers
4576: set notification_status = 'SENT'
4577: where invoice_id = l_invoice_id

Line 4604: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4600: and notification_key = itemkey;
4601:
4602: begin
4603: if(funcmode = 'RUN') then
4604: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4605: itemkey,
4606: 'INVOICE_ID');
4607: l_note := WF_ENGINE.getItemAttrText(itemtype, itemkey, 'WF_NOTE');
4608: wf_engine.setItemAttrText(itemType, itemkey, 'WF_NOTE', NULL);

Line 4607: l_note := WF_ENGINE.getItemAttrText(itemtype, itemkey, 'WF_NOTE');

4603: if(funcmode = 'RUN') then
4604: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4605: itemkey,
4606: 'INVOICE_ID');
4607: l_note := WF_ENGINE.getItemAttrText(itemtype, itemkey, 'WF_NOTE');
4608: wf_engine.setItemAttrText(itemType, itemkey, 'WF_NOTE', NULL);
4609:
4610: open notif_process;
4611: fetch notif_process into l_rowid;

Line 4608: wf_engine.setItemAttrText(itemType, itemkey, 'WF_NOTE', NULL);

4604: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4605: itemkey,
4606: 'INVOICE_ID');
4607: l_note := WF_ENGINE.getItemAttrText(itemtype, itemkey, 'WF_NOTE');
4608: wf_engine.setItemAttrText(itemType, itemkey, 'WF_NOTE', NULL);
4609:
4610: open notif_process;
4611: fetch notif_process into l_rowid;
4612:

Line 4630: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4626: funcmode IN VARCHAR2,
4627: resultout OUT NOCOPY VARCHAR2) as
4628: l_invoice_id number;
4629: begin
4630: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4631: itemkey,
4632: 'INVOICE_ID');
4633:
4634: delete from ap_apinv_approvers

Line 4657: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4653: where invoice_id = l_invoice_id
4654: and notification_key = itemkey;
4655:
4656: begin
4657: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4658: itemkey,
4659: 'INVOICE_ID');
4660:
4661: open notif_process;

Line 4665: wf_engine.setItemAttrText(itemType, itemKey, 'DISP_NOT_RECEIVER', l_a);

4661: open notif_process;
4662: fetch notif_process into l_a;
4663: close notif_process;
4664:
4665: wf_engine.setItemAttrText(itemType, itemKey, 'DISP_NOT_RECEIVER', l_a);
4666: end;
4667:
4668:
4669: PROCEDURE cancel_invoice( itemtype IN VARCHAR2,

Line 4701: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4697: where invoice_id = l_invoice_id
4698: and org_id = l_org_id;
4699: begin
4700: if(funcmode = 'RUN') then
4701: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4702: itemkey,
4703: 'INVOICE_ID');
4704:
4705: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 4705: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4701: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4702: itemkey,
4703: 'INVOICE_ID');
4704:
4705: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4706: itemkey,
4707: 'ORG_ID');
4708:
4709: open invoice;

Line 4731: wf_engine.setItemAttrText(itemType, itemKey, 'IS_ACCEPTED', 'N');

4727: l_pay_curr_invoice_amount,
4728: l_token,
4729: null);
4730:
4731: wf_engine.setItemAttrText(itemType, itemKey, 'IS_ACCEPTED', 'N');
4732: end if;
4733: end;
4734:
4735: PROCEDURE accept_invoice( itemtype IN VARCHAR2,

Line 4744: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4740: l_invoice_id number;
4741: l_org_id number;
4742: begin
4743: if(funcmode = 'RUN') then
4744: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4745: itemkey,
4746: 'INVOICE_ID');
4747: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4748: itemkey,

Line 4747: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4743: if(funcmode = 'RUN') then
4744: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4745: itemkey,
4746: 'INVOICE_ID');
4747: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4748: itemkey,
4749: 'ORG_ID');
4750:
4751: update ap_invoice_lines_all

Line 4760: wf_engine.setItemAttrText(itemType, itemKey, 'IS_ACCEPTED', 'Y');

4756: select ROLE_NAME
4757: from ap_apinv_approvers
4758: where invoice_id = l_invoice_id
4759: and notification_key = itemkey);
4760: wf_engine.setItemAttrText(itemType, itemKey, 'IS_ACCEPTED', 'Y');
4761: end if;
4762: end;
4763:
4764: PROCEDURE unwait_main_flow( itemtype IN VARCHAR2,

Line 4779: l_r := wf_engine.getItemAttrText(itemType, itemKey, 'IS_ACCEPTED');

4775: from ap_apinv_approvers
4776: where invoice_id = l_invoice_id
4777: and notification_key = itemkey;
4778: begin
4779: l_r := wf_engine.getItemAttrText(itemType, itemKey, 'IS_ACCEPTED');
4780:
4781: if l_r = 'Y' then
4782: l_r := 'N';
4783: else

Line 4786: l_invoice_id := wf_engine.getItemAttrNumber(itemType, itemKey, 'INVOICE_ID');

4782: l_r := 'N';
4783: else
4784: l_r := 'Y';
4785: end if;
4786: l_invoice_id := wf_engine.getItemAttrNumber(itemType, itemKey, 'INVOICE_ID');
4787:
4788: open notif_process;
4789: fetch notif_process into l_invoice_key;
4790: close notif_process;

Line 4792: wf_engine.CompleteActivity(

4788: open notif_process;
4789: fetch notif_process into l_invoice_key;
4790: close notif_process;
4791:
4792: wf_engine.CompleteActivity(
4793: itemType => 'APINVLDP',
4794: itemKey => l_invoice_key,
4795: activity => 'DISPUTE_MAIN:WAIT_COMPLETION',
4796: result => l_r);

Line 4808: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4804: l_num number;
4805: l_invoice_id number;
4806: l_org_id number;
4807: begin
4808: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4809: itemkey,
4810: 'INVOICE_ID');
4811: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4812: itemkey,

Line 4811: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4807: begin
4808: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4809: itemkey,
4810: 'INVOICE_ID');
4811: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4812: itemkey,
4813: 'ORG_ID');
4814:
4815: select count(*)

Line 4824: resultout := wf_engine.eng_completed||':'||'Y';

4820: and disputable_flag = 'Y'
4821: and line_type_lookup_code = 'ITEM';
4822:
4823: if l_num = 0 then
4824: resultout := wf_engine.eng_completed||':'||'Y';
4825: else
4826: resultout := wf_engine.eng_completed||':'||'N';
4827: end if;
4828: end;

Line 4826: resultout := wf_engine.eng_completed||':'||'N';

4822:
4823: if l_num = 0 then
4824: resultout := wf_engine.eng_completed||':'||'Y';
4825: else
4826: resultout := wf_engine.eng_completed||':'||'N';
4827: end if;
4828: end;
4829:
4830: PROCEDURE is_invoice_updated( itemtype IN VARCHAR2,

Line 4839: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4835: l_num number;
4836: l_invoice_id number;
4837: l_org_id number;
4838: begin
4839: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4840: itemkey,
4841: 'INVOICE_ID');
4842: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4843: itemkey,

Line 4842: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4838: begin
4839: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4840: itemkey,
4841: 'INVOICE_ID');
4842: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4843: itemkey,
4844: 'ORG_ID');
4845:
4846: select count(*)

Line 4855: resultout := wf_engine.eng_completed||':'||'N';

4851: and creation_date <> last_update_date
4852: and line_type_lookup_code = 'ITEM';
4853:
4854: if l_num = 0 then
4855: resultout := wf_engine.eng_completed||':'||'N';
4856: else
4857: resultout := wf_engine.eng_completed||':'||'Y';
4858: end if;
4859: end;

Line 4857: resultout := wf_engine.eng_completed||':'||'Y';

4853:
4854: if l_num = 0 then
4855: resultout := wf_engine.eng_completed||':'||'N';
4856: else
4857: resultout := wf_engine.eng_completed||':'||'Y';
4858: end if;
4859: end;
4860:
4861: PROCEDURE is_internal( itemtype IN VARCHAR2,

Line 4876: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4872: where invoice_id = l_invoice_id
4873: and notification_key = itemkey;
4874:
4875: begin
4876: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4877: itemkey,
4878: 'INVOICE_ID');
4879:
4880: open notif_process;

Line 4885: resultout := wf_engine.eng_completed||':'||'N';

4881: fetch notif_process into l_a;
4882: close notif_process;
4883:
4884: if l_a = 'E' then
4885: resultout := wf_engine.eng_completed||':'||'N';
4886: else
4887: resultout := wf_engine.eng_completed||':'||'Y';
4888: end if;
4889: end;

Line 4887: resultout := wf_engine.eng_completed||':'||'Y';

4883:
4884: if l_a = 'E' then
4885: resultout := wf_engine.eng_completed||':'||'N';
4886: else
4887: resultout := wf_engine.eng_completed||':'||'Y';
4888: end if;
4889: end;
4890:
4891: PROCEDURE is_invoice_request( itemtype IN VARCHAR2,

Line 4900: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4896: l_invoice_id number;
4897: l_org_id number;
4898: l_type varchar2(30);
4899: begin
4900: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4901: itemkey,
4902: 'INVOICE_ID');
4903: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4904: itemkey,

Line 4903: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4899: begin
4900: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4901: itemkey,
4902: 'INVOICE_ID');
4903: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4904: itemkey,
4905: 'ORG_ID');
4906: begin
4907: select invoice_type_lookup_code

Line 4917: resultout := wf_engine.eng_completed||':'||'Y';

4913: when no_data_found then
4914: null;
4915: end;
4916: if l_type = 'INVOICE REQUEST' or l_type = 'CREDIT MEMO REQUEST' then
4917: resultout := wf_engine.eng_completed||':'||'Y';
4918: else
4919: resultout := wf_engine.eng_completed||':'||'N';
4920: end if;
4921: end;

Line 4919: resultout := wf_engine.eng_completed||':'||'N';

4915: end;
4916: if l_type = 'INVOICE REQUEST' or l_type = 'CREDIT MEMO REQUEST' then
4917: resultout := wf_engine.eng_completed||':'||'Y';
4918: else
4919: resultout := wf_engine.eng_completed||':'||'N';
4920: end if;
4921: end;
4922:
4923: -- update invoice type after invoice request becomes legal document

Line 4932: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4928: resultout OUT NOCOPY VARCHAR2) as
4929: l_invoice_id number;
4930: l_org_id number;
4931: begin
4932: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4933: itemkey,
4934: 'INVOICE_ID');
4935: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4936: itemkey,

Line 4935: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4931: begin
4932: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4933: itemkey,
4934: 'INVOICE_ID');
4935: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4936: itemkey,
4937: 'ORG_ID');
4938: update ap_invoices_all
4939: set invoice_type_lookup_code =

Line 4954: resultout := wf_engine.eng_completed||':'||'Y';

4950: funcmode IN VARCHAR2,
4951: resultout OUT NOCOPY VARCHAR2) as
4952:
4953: begin
4954: resultout := wf_engine.eng_completed||':'||'Y';
4955: end;
4956:
4957: FUNCTION getRoleEmailAddress( p_role in varchar2) return varchar2 as
4958: display_name varchar2(320);

Line 5001: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

4997: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4998: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
4999: END IF;
5000:
5001: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
5002: itemkey,
5003: 'INVOICE_ID');
5004: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
5005: itemkey,

Line 5004: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

5000:
5001: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
5002: itemkey,
5003: 'INVOICE_ID');
5004: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
5005: itemkey,
5006: 'ORG_ID');
5007:
5008: SELECT

Line 5052: wf_engine.createProcess('APINVLPN', itemkey, 'SEND_NOTIFICATIONS');

5048: l_api_name,l_debug_info);
5049: END IF;
5050:
5051: if l_rowid is not null then
5052: wf_engine.createProcess('APINVLPN', itemkey, 'SEND_NOTIFICATIONS');
5053:
5054: l_debug_info := l_api_name || ': create APINVLPN process';
5055: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5056: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

Line 5060: WF_ENGINE.SetItemAttrNumber('APINVLPN', itemkey, 'ORG_ID',l_org_id);

5056: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5057: l_api_name,l_debug_info);
5058: END IF;
5059:
5060: WF_ENGINE.SetItemAttrNumber('APINVLPN', itemkey, 'ORG_ID',l_org_id);
5061: WF_ENGINE.SetItemAttrNumber('APINVLPN', itemkey, 'INVOICE_ID', l_invoice_id);
5062: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
5063: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_NUMBER',l_invoice_number);
5064: WF_ENGINE.SETITEMATTRDATE('APINVLPN', itemkey,'INVOICE_DATE',l_invoice_date);

Line 5061: WF_ENGINE.SetItemAttrNumber('APINVLPN', itemkey, 'INVOICE_ID', l_invoice_id);

5057: l_api_name,l_debug_info);
5058: END IF;
5059:
5060: WF_ENGINE.SetItemAttrNumber('APINVLPN', itemkey, 'ORG_ID',l_org_id);
5061: WF_ENGINE.SetItemAttrNumber('APINVLPN', itemkey, 'INVOICE_ID', l_invoice_id);
5062: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
5063: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_NUMBER',l_invoice_number);
5064: WF_ENGINE.SETITEMATTRDATE('APINVLPN', itemkey,'INVOICE_DATE',l_invoice_date);
5065: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_DESCRIPTION',l_invoice_description);

Line 5062: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);

5058: END IF;
5059:
5060: WF_ENGINE.SetItemAttrNumber('APINVLPN', itemkey, 'ORG_ID',l_org_id);
5061: WF_ENGINE.SetItemAttrNumber('APINVLPN', itemkey, 'INVOICE_ID', l_invoice_id);
5062: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
5063: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_NUMBER',l_invoice_number);
5064: WF_ENGINE.SETITEMATTRDATE('APINVLPN', itemkey,'INVOICE_DATE',l_invoice_date);
5065: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_DESCRIPTION',l_invoice_description);
5066: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'NOTIFICATION_KEY',l_notification_key);

Line 5063: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_NUMBER',l_invoice_number);

5059:
5060: WF_ENGINE.SetItemAttrNumber('APINVLPN', itemkey, 'ORG_ID',l_org_id);
5061: WF_ENGINE.SetItemAttrNumber('APINVLPN', itemkey, 'INVOICE_ID', l_invoice_id);
5062: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
5063: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_NUMBER',l_invoice_number);
5064: WF_ENGINE.SETITEMATTRDATE('APINVLPN', itemkey,'INVOICE_DATE',l_invoice_date);
5065: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_DESCRIPTION',l_invoice_description);
5066: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'NOTIFICATION_KEY',l_notification_key);
5067:

Line 5064: WF_ENGINE.SETITEMATTRDATE('APINVLPN', itemkey,'INVOICE_DATE',l_invoice_date);

5060: WF_ENGINE.SetItemAttrNumber('APINVLPN', itemkey, 'ORG_ID',l_org_id);
5061: WF_ENGINE.SetItemAttrNumber('APINVLPN', itemkey, 'INVOICE_ID', l_invoice_id);
5062: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
5063: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_NUMBER',l_invoice_number);
5064: WF_ENGINE.SETITEMATTRDATE('APINVLPN', itemkey,'INVOICE_DATE',l_invoice_date);
5065: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_DESCRIPTION',l_invoice_description);
5066: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'NOTIFICATION_KEY',l_notification_key);
5067:
5068: WF_ENGINE.setItemParent('APINVLPN', itemkey, 'APINVLDP', l_notification_key, null);

Line 5065: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_DESCRIPTION',l_invoice_description);

5061: WF_ENGINE.SetItemAttrNumber('APINVLPN', itemkey, 'INVOICE_ID', l_invoice_id);
5062: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
5063: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_NUMBER',l_invoice_number);
5064: WF_ENGINE.SETITEMATTRDATE('APINVLPN', itemkey,'INVOICE_DATE',l_invoice_date);
5065: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_DESCRIPTION',l_invoice_description);
5066: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'NOTIFICATION_KEY',l_notification_key);
5067:
5068: WF_ENGINE.setItemParent('APINVLPN', itemkey, 'APINVLDP', l_notification_key, null);
5069:

Line 5066: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'NOTIFICATION_KEY',l_notification_key);

5062: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
5063: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_NUMBER',l_invoice_number);
5064: WF_ENGINE.SETITEMATTRDATE('APINVLPN', itemkey,'INVOICE_DATE',l_invoice_date);
5065: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_DESCRIPTION',l_invoice_description);
5066: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'NOTIFICATION_KEY',l_notification_key);
5067:
5068: WF_ENGINE.setItemParent('APINVLPN', itemkey, 'APINVLDP', l_notification_key, null);
5069:
5070: wf_engine.startProcess('APINVLPN', itemkey);

Line 5068: WF_ENGINE.setItemParent('APINVLPN', itemkey, 'APINVLDP', l_notification_key, null);

5064: WF_ENGINE.SETITEMATTRDATE('APINVLPN', itemkey,'INVOICE_DATE',l_invoice_date);
5065: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'INVOICE_DESCRIPTION',l_invoice_description);
5066: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'NOTIFICATION_KEY',l_notification_key);
5067:
5068: WF_ENGINE.setItemParent('APINVLPN', itemkey, 'APINVLDP', l_notification_key, null);
5069:
5070: wf_engine.startProcess('APINVLPN', itemkey);
5071:
5072: l_debug_info := l_api_name || ': APINVLPN process started';

Line 5070: wf_engine.startProcess('APINVLPN', itemkey);

5066: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', itemkey,'NOTIFICATION_KEY',l_notification_key);
5067:
5068: WF_ENGINE.setItemParent('APINVLPN', itemkey, 'APINVLDP', l_notification_key, null);
5069:
5070: wf_engine.startProcess('APINVLPN', itemkey);
5071:
5072: l_debug_info := l_api_name || ': APINVLPN process started';
5073: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5074: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

Line 5080: wf_engine.createProcess('APINVLPN', l_notification_key, 'SEND_NOTIFICATIONS');

5076: END IF;
5077:
5078:
5079: /*
5080: wf_engine.createProcess('APINVLPN', l_notification_key, 'SEND_NOTIFICATIONS');
5081:
5082: WF_ENGINE.SetItemAttrNumber('APINVLPN', l_notification_key, 'ORG_ID',l_org_id);
5083: WF_ENGINE.SetItemAttrNumber('APINVLPN', l_notification_key, 'INVOICE_ID', l_invoice_id);
5084: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);

Line 5082: WF_ENGINE.SetItemAttrNumber('APINVLPN', l_notification_key, 'ORG_ID',l_org_id);

5078:
5079: /*
5080: wf_engine.createProcess('APINVLPN', l_notification_key, 'SEND_NOTIFICATIONS');
5081:
5082: WF_ENGINE.SetItemAttrNumber('APINVLPN', l_notification_key, 'ORG_ID',l_org_id);
5083: WF_ENGINE.SetItemAttrNumber('APINVLPN', l_notification_key, 'INVOICE_ID', l_invoice_id);
5084: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
5085: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);
5086: WF_ENGINE.SETITEMATTRDATE('APINVLPN', l_notification_key,'INVOICE_DATE',l_invoice_date);

Line 5083: WF_ENGINE.SetItemAttrNumber('APINVLPN', l_notification_key, 'INVOICE_ID', l_invoice_id);

5079: /*
5080: wf_engine.createProcess('APINVLPN', l_notification_key, 'SEND_NOTIFICATIONS');
5081:
5082: WF_ENGINE.SetItemAttrNumber('APINVLPN', l_notification_key, 'ORG_ID',l_org_id);
5083: WF_ENGINE.SetItemAttrNumber('APINVLPN', l_notification_key, 'INVOICE_ID', l_invoice_id);
5084: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
5085: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);
5086: WF_ENGINE.SETITEMATTRDATE('APINVLPN', l_notification_key,'INVOICE_DATE',l_invoice_date);
5087: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);

Line 5084: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);

5080: wf_engine.createProcess('APINVLPN', l_notification_key, 'SEND_NOTIFICATIONS');
5081:
5082: WF_ENGINE.SetItemAttrNumber('APINVLPN', l_notification_key, 'ORG_ID',l_org_id);
5083: WF_ENGINE.SetItemAttrNumber('APINVLPN', l_notification_key, 'INVOICE_ID', l_invoice_id);
5084: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
5085: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);
5086: WF_ENGINE.SETITEMATTRDATE('APINVLPN', l_notification_key,'INVOICE_DATE',l_invoice_date);
5087: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);
5088: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'NOTIFICATION_KEY',l_notification_key);

Line 5085: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);

5081:
5082: WF_ENGINE.SetItemAttrNumber('APINVLPN', l_notification_key, 'ORG_ID',l_org_id);
5083: WF_ENGINE.SetItemAttrNumber('APINVLPN', l_notification_key, 'INVOICE_ID', l_invoice_id);
5084: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
5085: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);
5086: WF_ENGINE.SETITEMATTRDATE('APINVLPN', l_notification_key,'INVOICE_DATE',l_invoice_date);
5087: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);
5088: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'NOTIFICATION_KEY',l_notification_key);
5089:

Line 5086: WF_ENGINE.SETITEMATTRDATE('APINVLPN', l_notification_key,'INVOICE_DATE',l_invoice_date);

5082: WF_ENGINE.SetItemAttrNumber('APINVLPN', l_notification_key, 'ORG_ID',l_org_id);
5083: WF_ENGINE.SetItemAttrNumber('APINVLPN', l_notification_key, 'INVOICE_ID', l_invoice_id);
5084: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
5085: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);
5086: WF_ENGINE.SETITEMATTRDATE('APINVLPN', l_notification_key,'INVOICE_DATE',l_invoice_date);
5087: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);
5088: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'NOTIFICATION_KEY',l_notification_key);
5089:
5090: wf_engine.startProcess('APINVLPN', l_notification_key);

Line 5087: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);

5083: WF_ENGINE.SetItemAttrNumber('APINVLPN', l_notification_key, 'INVOICE_ID', l_invoice_id);
5084: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
5085: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);
5086: WF_ENGINE.SETITEMATTRDATE('APINVLPN', l_notification_key,'INVOICE_DATE',l_invoice_date);
5087: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);
5088: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'NOTIFICATION_KEY',l_notification_key);
5089:
5090: wf_engine.startProcess('APINVLPN', l_notification_key);
5091: */

Line 5088: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'NOTIFICATION_KEY',l_notification_key);

5084: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_SUPPLIER_NAME',l_invoice_supplier_name);
5085: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_NUMBER',l_invoice_number);
5086: WF_ENGINE.SETITEMATTRDATE('APINVLPN', l_notification_key,'INVOICE_DATE',l_invoice_date);
5087: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);
5088: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'NOTIFICATION_KEY',l_notification_key);
5089:
5090: wf_engine.startProcess('APINVLPN', l_notification_key);
5091: */
5092:

Line 5090: wf_engine.startProcess('APINVLPN', l_notification_key);

5086: WF_ENGINE.SETITEMATTRDATE('APINVLPN', l_notification_key,'INVOICE_DATE',l_invoice_date);
5087: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'INVOICE_DESCRIPTION',l_invoice_description);
5088: WF_ENGINE.SETITEMATTRTEXT('APINVLPN', l_notification_key,'NOTIFICATION_KEY',l_notification_key);
5089:
5090: wf_engine.startProcess('APINVLPN', l_notification_key);
5091: */
5092:
5093: update ap_apinv_approvers
5094: set notification_status = 'STARTED'

Line 5125: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

5121: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5122: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
5123: END IF;
5124:
5125: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
5126: itemkey,
5127: 'INVOICE_ID');
5128: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
5129: itemkey,

Line 5128: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

5124:
5125: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
5126: itemkey,
5127: 'INVOICE_ID');
5128: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
5129: itemkey,
5130: 'ORG_ID');
5131: select vendor_id, set_of_books_id
5132: into l_vendor_id, l_set_of_books_id