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.POS_SPM_WF_PKG1 dependencies on WF_ITEMS

Line 406: l_itemtype wf_items.item_type%TYPE;

402: )
403: IS
404: l_supplier_name ap_suppliers.vendor_name%TYPE;
405: l_address_name hz_party_sites.party_site_name%TYPE;
406: l_itemtype wf_items.item_type%TYPE;
407: l_itemkey wf_items.item_key%TYPE;
408: l_receiver wf_roles.name%TYPE;
409: l_cur g_refcur;
410: l_count NUMBER;

Line 407: l_itemkey wf_items.item_key%TYPE;

403: IS
404: l_supplier_name ap_suppliers.vendor_name%TYPE;
405: l_address_name hz_party_sites.party_site_name%TYPE;
406: l_itemtype wf_items.item_type%TYPE;
407: l_itemkey wf_items.item_key%TYPE;
408: l_receiver wf_roles.name%TYPE;
409: l_cur g_refcur;
410: l_count NUMBER;
411: l_process wf_process_activities.process_name%TYPE;

Line 588: l_itemtype wf_items.item_type%TYPE;

584: x_receiver OUT nocopy VARCHAR2
585: )
586: IS
587: l_supplier_name ap_suppliers.vendor_name%TYPE;
588: l_itemtype wf_items.item_type%TYPE;
589: l_itemkey wf_items.item_key%TYPE;
590: l_receiver wf_roles.name%TYPE;
591: l_cur g_refcur;
592: l_count NUMBER;

Line 589: l_itemkey wf_items.item_key%TYPE;

585: )
586: IS
587: l_supplier_name ap_suppliers.vendor_name%TYPE;
588: l_itemtype wf_items.item_type%TYPE;
589: l_itemkey wf_items.item_key%TYPE;
590: l_receiver wf_roles.name%TYPE;
591: l_cur g_refcur;
592: l_count NUMBER;
593: l_step NUMBER;

Line 778: l_itemtype wf_items.item_type%TYPE;

774: )
775: IS
776: l_supplier_name ap_suppliers.vendor_name%TYPE;
777: l_contact_name hz_parties.party_name%TYPE;
778: l_itemtype wf_items.item_type%TYPE;
779: l_itemkey wf_items.item_key%TYPE;
780: l_receiver wf_roles.name%TYPE;
781: l_cur g_refcur;
782: l_count NUMBER;

Line 779: l_itemkey wf_items.item_key%TYPE;

775: IS
776: l_supplier_name ap_suppliers.vendor_name%TYPE;
777: l_contact_name hz_parties.party_name%TYPE;
778: l_itemtype wf_items.item_type%TYPE;
779: l_itemkey wf_items.item_key%TYPE;
780: l_receiver wf_roles.name%TYPE;
781: l_cur g_refcur;
782: l_count NUMBER;
783: l_process wf_process_activities.process_name%TYPE;

Line 927: l_itemtype wf_items.item_type%TYPE;

923: )
924: IS
925: l_supplier_name ap_suppliers.vendor_name%TYPE;
926: l_contact_name hz_parties.party_name%TYPE;
927: l_itemtype wf_items.item_type%TYPE;
928: l_itemkey wf_items.item_key%TYPE;
929: l_receiver wf_roles.name%TYPE;
930: l_cur g_refcur;
931: l_count NUMBER;

Line 928: l_itemkey wf_items.item_key%TYPE;

924: IS
925: l_supplier_name ap_suppliers.vendor_name%TYPE;
926: l_contact_name hz_parties.party_name%TYPE;
927: l_itemtype wf_items.item_type%TYPE;
928: l_itemkey wf_items.item_key%TYPE;
929: l_receiver wf_roles.name%TYPE;
930: l_cur g_refcur;
931: l_count NUMBER;
932: l_process wf_process_activities.process_name%TYPE;

Line 1064: l_itemtype wf_items.item_type%TYPE;

1060: x_receiver OUT nocopy VARCHAR2
1061: )
1062: IS
1063: l_supplier_name ap_suppliers.vendor_name%TYPE;
1064: l_itemtype wf_items.item_type%TYPE;
1065: l_itemkey wf_items.item_key%TYPE;
1066: l_receiver wf_roles.name%TYPE;
1067: l_cur g_refcur;
1068: l_count NUMBER;

Line 1065: l_itemkey wf_items.item_key%TYPE;

1061: )
1062: IS
1063: l_supplier_name ap_suppliers.vendor_name%TYPE;
1064: l_itemtype wf_items.item_type%TYPE;
1065: l_itemkey wf_items.item_key%TYPE;
1066: l_receiver wf_roles.name%TYPE;
1067: l_cur g_refcur;
1068: l_count NUMBER;
1069: l_step NUMBER;

Line 1351: l_itemtype wf_items.item_type%TYPE;

1347: IS
1348: PRAGMA autonomous_transaction;
1349: l_supplier_name ap_suppliers.vendor_name%TYPE;
1350: l_enterprise_name hz_parties.party_name%TYPE;
1351: l_itemtype wf_items.item_type%TYPE;
1352: l_itemkey wf_items.item_key%TYPE;
1353: l_receiver wf_roles.name%TYPE;
1354: l_cur g_refcur;
1355: l_count NUMBER;

Line 1352: l_itemkey wf_items.item_key%TYPE;

1348: PRAGMA autonomous_transaction;
1349: l_supplier_name ap_suppliers.vendor_name%TYPE;
1350: l_enterprise_name hz_parties.party_name%TYPE;
1351: l_itemtype wf_items.item_type%TYPE;
1352: l_itemkey wf_items.item_key%TYPE;
1353: l_receiver wf_roles.name%TYPE;
1354: l_cur g_refcur;
1355: l_count NUMBER;
1356: l_process wf_process_activities.process_name%TYPE;

Line 1490: l_itemtype wf_items.item_type%TYPE;

1486: x_receiver OUT nocopy VARCHAR2
1487: )
1488: IS
1489: l_supplier_name ap_suppliers.vendor_name%TYPE;
1490: l_itemtype wf_items.item_type%TYPE;
1491: l_itemkey wf_items.item_key%TYPE;
1492: l_receiver wf_roles.name%TYPE;
1493: l_cur g_refcur;
1494: l_count NUMBER;

Line 1491: l_itemkey wf_items.item_key%TYPE;

1487: )
1488: IS
1489: l_supplier_name ap_suppliers.vendor_name%TYPE;
1490: l_itemtype wf_items.item_type%TYPE;
1491: l_itemkey wf_items.item_key%TYPE;
1492: l_receiver wf_roles.name%TYPE;
1493: l_cur g_refcur;
1494: l_count NUMBER;
1495: l_process wf_process_activities.process_name%TYPE;

Line 1625: l_itemtype wf_items.item_type%TYPE;

1621: x_itemtype OUT nocopy VARCHAR2,
1622: x_itemkey OUT nocopy VARCHAR2
1623: )
1624: IS
1625: l_itemtype wf_items.item_type%TYPE;
1626: l_itemkey wf_items.item_key%TYPE;
1627: l_process wf_process_activities.process_name%TYPE;
1628: l_enterprise_name hz_parties.party_name%TYPE;
1629: l_step NUMBER;

Line 1626: l_itemkey wf_items.item_key%TYPE;

1622: x_itemkey OUT nocopy VARCHAR2
1623: )
1624: IS
1625: l_itemtype wf_items.item_type%TYPE;
1626: l_itemkey wf_items.item_key%TYPE;
1627: l_process wf_process_activities.process_name%TYPE;
1628: l_enterprise_name hz_parties.party_name%TYPE;
1629: l_step NUMBER;
1630: BEGIN

Line 1724: l_itemtype wf_items.item_type%TYPE;

1720: x_itemtype OUT nocopy VARCHAR2,
1721: x_itemkey OUT nocopy VARCHAR2
1722: )
1723: IS
1724: l_itemtype wf_items.item_type%TYPE;
1725: l_itemkey wf_items.item_key%TYPE;
1726: l_process wf_process_activities.process_name%TYPE;
1727: l_enterprise_name hz_parties.party_name%TYPE;
1728: l_step VARCHAR2(100);

Line 1725: l_itemkey wf_items.item_key%TYPE;

1721: x_itemkey OUT nocopy VARCHAR2
1722: )
1723: IS
1724: l_itemtype wf_items.item_type%TYPE;
1725: l_itemkey wf_items.item_key%TYPE;
1726: l_process wf_process_activities.process_name%TYPE;
1727: l_enterprise_name hz_parties.party_name%TYPE;
1728: l_step VARCHAR2(100);
1729: BEGIN

Line 1807: l_itemtype wf_items.item_type%TYPE;

1803: x_itemkey OUT nocopy VARCHAR2,
1804: x_receiver OUT nocopy VARCHAR2
1805: )
1806: IS
1807: l_itemtype wf_items.item_type%TYPE;
1808: l_itemkey wf_items.item_key%TYPE;
1809: l_process wf_process_activities.process_name%TYPE;
1810:
1811: CURSOR l_cur IS

Line 1808: l_itemkey wf_items.item_key%TYPE;

1804: x_receiver OUT nocopy VARCHAR2
1805: )
1806: IS
1807: l_itemtype wf_items.item_type%TYPE;
1808: l_itemkey wf_items.item_key%TYPE;
1809: l_process wf_process_activities.process_name%TYPE;
1810:
1811: CURSOR l_cur IS
1812: SELECT email_address, first_name, last_name

Line 2234: l_itemtype wf_items.item_type%TYPE;

2230: p_bank_account_number IN VARCHAR2,
2231: x_itemtype OUT nocopy VARCHAR2,
2232: x_itemkey OUT nocopy VARCHAR2)
2233: IS
2234: l_itemtype wf_items.item_type%TYPE;
2235: l_itemkey wf_items.item_key%TYPE;
2236: l_process wf_process_activities.process_name%TYPE;
2237: l_step NUMBER;
2238: l_supplier_name ap_suppliers.vendor_name%TYPE;

Line 2235: l_itemkey wf_items.item_key%TYPE;

2231: x_itemtype OUT nocopy VARCHAR2,
2232: x_itemkey OUT nocopy VARCHAR2)
2233: IS
2234: l_itemtype wf_items.item_type%TYPE;
2235: l_itemkey wf_items.item_key%TYPE;
2236: l_process wf_process_activities.process_name%TYPE;
2237: l_step NUMBER;
2238: l_supplier_name ap_suppliers.vendor_name%TYPE;
2239: l_first_name hz_parties.person_first_name%TYPE;

Line 2319: l_itemtype wf_items.item_type%TYPE;

2315: p_bank_account_number IN VARCHAR2,
2316: x_itemtype OUT nocopy VARCHAR2,
2317: x_itemkey OUT nocopy VARCHAR2)
2318: IS
2319: l_itemtype wf_items.item_type%TYPE;
2320: l_itemkey wf_items.item_key%TYPE;
2321: l_process wf_process_activities.process_name%TYPE;
2322: l_step NUMBER;
2323: l_supplier_name ap_suppliers.vendor_name%TYPE;

Line 2320: l_itemkey wf_items.item_key%TYPE;

2316: x_itemtype OUT nocopy VARCHAR2,
2317: x_itemkey OUT nocopy VARCHAR2)
2318: IS
2319: l_itemtype wf_items.item_type%TYPE;
2320: l_itemkey wf_items.item_key%TYPE;
2321: l_process wf_process_activities.process_name%TYPE;
2322: l_step NUMBER;
2323: l_supplier_name ap_suppliers.vendor_name%TYPE;
2324: l_enterprise_name hz_parties.party_name%TYPE;

Line 2417: l_itemtype wf_items.item_type%TYPE;

2413: p_bank_account_name IN VARCHAR2,
2414: x_itemtype OUT nocopy VARCHAR2,
2415: x_itemkey OUT nocopy VARCHAR2)
2416: IS
2417: l_itemtype wf_items.item_type%TYPE;
2418: l_itemkey wf_items.item_key%TYPE;
2419: l_process wf_process_activities.process_name%TYPE;
2420: l_step NUMBER;
2421: l_supplier_name ap_suppliers.vendor_name%TYPE;

Line 2418: l_itemkey wf_items.item_key%TYPE;

2414: x_itemtype OUT nocopy VARCHAR2,
2415: x_itemkey OUT nocopy VARCHAR2)
2416: IS
2417: l_itemtype wf_items.item_type%TYPE;
2418: l_itemkey wf_items.item_key%TYPE;
2419: l_process wf_process_activities.process_name%TYPE;
2420: l_step NUMBER;
2421: l_supplier_name ap_suppliers.vendor_name%TYPE;
2422: l_first_name hz_parties.person_first_name%TYPE;

Line 2519: l_itemtype wf_items.item_type%TYPE;

2515: p_bank_account_name IN VARCHAR2,
2516: x_itemtype OUT nocopy VARCHAR2,
2517: x_itemkey OUT nocopy VARCHAR2)
2518: IS
2519: l_itemtype wf_items.item_type%TYPE;
2520: l_itemkey wf_items.item_key%TYPE;
2521: l_process wf_process_activities.process_name%TYPE;
2522: l_step NUMBER;
2523: l_supplier_name ap_suppliers.vendor_name%TYPE;

Line 2520: l_itemkey wf_items.item_key%TYPE;

2516: x_itemtype OUT nocopy VARCHAR2,
2517: x_itemkey OUT nocopy VARCHAR2)
2518: IS
2519: l_itemtype wf_items.item_type%TYPE;
2520: l_itemkey wf_items.item_key%TYPE;
2521: l_process wf_process_activities.process_name%TYPE;
2522: l_step NUMBER;
2523: l_supplier_name ap_suppliers.vendor_name%TYPE;
2524: l_first_name hz_parties.person_first_name%TYPE;

Line 2623: l_itemtype wf_items.item_type%TYPE;

2619: x_itemtype OUT nocopy VARCHAR2,
2620: x_itemkey OUT nocopy VARCHAR2
2621: ) IS
2622:
2623: l_itemtype wf_items.item_type%TYPE;
2624: l_itemkey wf_items.item_key%TYPE;
2625: l_process wf_process_activities.process_name%TYPE;
2626: l_enterprise_name hz_parties.party_name%TYPE;
2627: l_step NUMBER;

Line 2624: l_itemkey wf_items.item_key%TYPE;

2620: x_itemkey OUT nocopy VARCHAR2
2621: ) IS
2622:
2623: l_itemtype wf_items.item_type%TYPE;
2624: l_itemkey wf_items.item_key%TYPE;
2625: l_process wf_process_activities.process_name%TYPE;
2626: l_enterprise_name hz_parties.party_name%TYPE;
2627: l_step NUMBER;
2628:

Line 2765: l_itemtype wf_items.item_type%TYPE;

2761: p_action IN VARCHAR2,
2762: x_itemtype OUT nocopy VARCHAR2,
2763: x_itemkey OUT nocopy VARCHAR2
2764: ) IS
2765: l_itemtype wf_items.item_type%TYPE;
2766: l_itemkey wf_items.item_key%TYPE;
2767: l_process wf_process_activities.process_name%TYPE;
2768: l_step NUMBER;
2769: l_count NUMBER;

Line 2766: l_itemkey wf_items.item_key%TYPE;

2762: x_itemtype OUT nocopy VARCHAR2,
2763: x_itemkey OUT nocopy VARCHAR2
2764: ) IS
2765: l_itemtype wf_items.item_type%TYPE;
2766: l_itemkey wf_items.item_key%TYPE;
2767: l_process wf_process_activities.process_name%TYPE;
2768: l_step NUMBER;
2769: l_count NUMBER;
2770:

Line 2948: l_itemtype wf_items.item_type%TYPE;

2944: PROCEDURE send_supplier_invite_reg_ntf
2945: (p_supplier_reg_id IN NUMBER
2946: )
2947: IS
2948: l_itemtype wf_items.item_type%TYPE;
2949: l_itemkey wf_items.item_key%TYPE;
2950: l_receiver wf_roles.name%TYPE;
2951: l_process wf_process_activities.process_name%TYPE;
2952:

Line 2949: l_itemkey wf_items.item_key%TYPE;

2945: (p_supplier_reg_id IN NUMBER
2946: )
2947: IS
2948: l_itemtype wf_items.item_type%TYPE;
2949: l_itemkey wf_items.item_key%TYPE;
2950: l_receiver wf_roles.name%TYPE;
2951: l_process wf_process_activities.process_name%TYPE;
2952:
2953: CURSOR l_cur IS

Line 3021: l_itemtype wf_items.item_type%TYPE;

3017: PROCEDURE send_supplier_reg_saved_ntf
3018: (p_supplier_reg_id IN NUMBER
3019: )
3020: IS
3021: l_itemtype wf_items.item_type%TYPE;
3022: l_itemkey wf_items.item_key%TYPE;
3023: l_receiver wf_roles.name%TYPE;
3024: l_process wf_process_activities.process_name%TYPE;
3025:

Line 3022: l_itemkey wf_items.item_key%TYPE;

3018: (p_supplier_reg_id IN NUMBER
3019: )
3020: IS
3021: l_itemtype wf_items.item_type%TYPE;
3022: l_itemkey wf_items.item_key%TYPE;
3023: l_receiver wf_roles.name%TYPE;
3024: l_process wf_process_activities.process_name%TYPE;
3025:
3026: CURSOR l_cur IS

Line 3124: l_itemtype wf_items.item_type%TYPE:='POSNOTIF';

3120: p_msg_subject in varchar2,
3121: p_msg_body in varchar2
3122: )
3123: IS
3124: l_itemtype wf_items.item_type%TYPE:='POSNOTIF';
3125: l_itemkey wf_items.item_key%TYPE;
3126: l_receiver wf_roles.name%TYPE;
3127: --Bug 10113987 unable to configure the notification messages in the oracle slm in html format
3128: --Use the new process SUPP_REG_NOTIFY

Line 3125: l_itemkey wf_items.item_key%TYPE;

3121: p_msg_body in varchar2
3122: )
3123: IS
3124: l_itemtype wf_items.item_type%TYPE:='POSNOTIF';
3125: l_itemkey wf_items.item_key%TYPE;
3126: l_receiver wf_roles.name%TYPE;
3127: --Bug 10113987 unable to configure the notification messages in the oracle slm in html format
3128: --Use the new process SUPP_REG_NOTIFY
3129: l_process wf_process_activities.process_name%TYPE:='SUPP_REG_NOTIFY';

Line 3240: l_itemtype wf_items.item_type%TYPE;

3236: x_receiver OUT nocopy VARCHAR2
3237: )
3238: IS
3239: l_supplier_name ap_suppliers.vendor_name%TYPE;
3240: l_itemtype wf_items.item_type%TYPE;
3241: l_itemkey wf_items.item_key%TYPE;
3242: l_receiver wf_roles.name%TYPE;
3243: l_cur g_refcur;
3244: l_count NUMBER;

Line 3241: l_itemkey wf_items.item_key%TYPE;

3237: )
3238: IS
3239: l_supplier_name ap_suppliers.vendor_name%TYPE;
3240: l_itemtype wf_items.item_type%TYPE;
3241: l_itemkey wf_items.item_key%TYPE;
3242: l_receiver wf_roles.name%TYPE;
3243: l_cur g_refcur;
3244: l_count NUMBER;
3245: l_process wf_process_activities.process_name%TYPE;

Line 3326: l_itemtype wf_items.item_type%TYPE;

3322: x_itemtype OUT nocopy VARCHAR2,
3323: x_itemkey OUT nocopy VARCHAR2
3324: )
3325: IS
3326: l_itemtype wf_items.item_type%TYPE;
3327: l_itemkey wf_items.item_key%TYPE;
3328: l_process wf_process_activities.process_name%TYPE;
3329: l_enterprise_name hz_parties.party_name%TYPE;
3330: l_step NUMBER;

Line 3327: l_itemkey wf_items.item_key%TYPE;

3323: x_itemkey OUT nocopy VARCHAR2
3324: )
3325: IS
3326: l_itemtype wf_items.item_type%TYPE;
3327: l_itemkey wf_items.item_key%TYPE;
3328: l_process wf_process_activities.process_name%TYPE;
3329: l_enterprise_name hz_parties.party_name%TYPE;
3330: l_step NUMBER;
3331: BEGIN

Line 3414: l_itemtype wf_items.item_type%TYPE;

3410: x_itemtype OUT nocopy VARCHAR2,
3411: x_itemkey OUT nocopy VARCHAR2
3412: )
3413: IS
3414: l_itemtype wf_items.item_type%TYPE;
3415: l_itemkey wf_items.item_key%TYPE;
3416: l_process wf_process_activities.process_name%TYPE;
3417: l_enterprise_name hz_parties.party_name%TYPE;
3418: l_step VARCHAR2(100);

Line 3415: l_itemkey wf_items.item_key%TYPE;

3411: x_itemkey OUT nocopy VARCHAR2
3412: )
3413: IS
3414: l_itemtype wf_items.item_type%TYPE;
3415: l_itemkey wf_items.item_key%TYPE;
3416: l_process wf_process_activities.process_name%TYPE;
3417: l_enterprise_name hz_parties.party_name%TYPE;
3418: l_step VARCHAR2(100);
3419: BEGIN

Line 3508: l_itemtype wf_items.item_type%TYPE;

3504: l_last_certification_date DATE;
3505: l_due_date DATE;
3506: l_expiration_date DATE;
3507:
3508: l_itemtype wf_items.item_type%TYPE;
3509: l_purge_itemkey wf_items.item_key%TYPE;
3510: l_itemkey wf_items.item_key%TYPE;
3511: l_purge_item_key_type wf_items.item_key%TYPE;
3512: l_process wf_process_activities.process_name%TYPE;

Line 3509: l_purge_itemkey wf_items.item_key%TYPE;

3505: l_due_date DATE;
3506: l_expiration_date DATE;
3507:
3508: l_itemtype wf_items.item_type%TYPE;
3509: l_purge_itemkey wf_items.item_key%TYPE;
3510: l_itemkey wf_items.item_key%TYPE;
3511: l_purge_item_key_type wf_items.item_key%TYPE;
3512: l_process wf_process_activities.process_name%TYPE;
3513: l_users WF_DIRECTORY.UserTable;

Line 3510: l_itemkey wf_items.item_key%TYPE;

3506: l_expiration_date DATE;
3507:
3508: l_itemtype wf_items.item_type%TYPE;
3509: l_purge_itemkey wf_items.item_key%TYPE;
3510: l_itemkey wf_items.item_key%TYPE;
3511: l_purge_item_key_type wf_items.item_key%TYPE;
3512: l_process wf_process_activities.process_name%TYPE;
3513: l_users WF_DIRECTORY.UserTable;
3514:

Line 3511: l_purge_item_key_type wf_items.item_key%TYPE;

3507:
3508: l_itemtype wf_items.item_type%TYPE;
3509: l_purge_itemkey wf_items.item_key%TYPE;
3510: l_itemkey wf_items.item_key%TYPE;
3511: l_purge_item_key_type wf_items.item_key%TYPE;
3512: l_process wf_process_activities.process_name%TYPE;
3513: l_users WF_DIRECTORY.UserTable;
3514:
3515: /* bug 8647019 */

Line 3567: CURSOR l_purge_wf_items_cur(l_purge_item_key_type VARCHAR2) IS

3563: --AND (hpua.effective_end_date IS NULL OR hpua.effective_end_date > Sysdate); /* bug 8647019 */
3564: AND Nvl(hpua.effective_end_date, SYSDATE) >= SYSDATE;
3565:
3566: /* bug 8647019 */
3567: CURSOR l_purge_wf_items_cur(l_purge_item_key_type VARCHAR2) IS
3568: SELECT item_key
3569: FROM wf_items
3570: WHERE item_key LIKE l_purge_item_key_type
3571: and item_type like l_itemtype;

Line 3569: FROM wf_items

3565:
3566: /* bug 8647019 */
3567: CURSOR l_purge_wf_items_cur(l_purge_item_key_type VARCHAR2) IS
3568: SELECT item_key
3569: FROM wf_items
3570: WHERE item_key LIKE l_purge_item_key_type
3571: and item_type like l_itemtype;
3572:
3573: BEGIN

Line 3617: OPEN l_purge_wf_items_cur(l_purge_item_key_type);

3613: get_wf_item_type (l_itemtype);
3614:
3615: l_purge_item_key_type := l_itemtype||'_'||l_process||'_%_VENDOR_ID_'||to_char(l_vendor_id);
3616:
3617: OPEN l_purge_wf_items_cur(l_purge_item_key_type);
3618: LOOP
3619:
3620: FETCH l_purge_wf_items_cur INTO l_purge_itemkey;
3621: EXIT WHEN l_purge_wf_items_cur%NOTFOUND;

Line 3620: FETCH l_purge_wf_items_cur INTO l_purge_itemkey;

3616:
3617: OPEN l_purge_wf_items_cur(l_purge_item_key_type);
3618: LOOP
3619:
3620: FETCH l_purge_wf_items_cur INTO l_purge_itemkey;
3621: EXIT WHEN l_purge_wf_items_cur%NOTFOUND;
3622:
3623: WF_PURGE.ITEMS (itemtype => l_itemtype,
3624: itemkey => l_purge_itemkey,

Line 3621: EXIT WHEN l_purge_wf_items_cur%NOTFOUND;

3617: OPEN l_purge_wf_items_cur(l_purge_item_key_type);
3618: LOOP
3619:
3620: FETCH l_purge_wf_items_cur INTO l_purge_itemkey;
3621: EXIT WHEN l_purge_wf_items_cur%NOTFOUND;
3622:
3623: WF_PURGE.ITEMS (itemtype => l_itemtype,
3624: itemkey => l_purge_itemkey,
3625: enddate => SYSDATE,

Line 3630: CLOSE l_purge_wf_items_cur;

3626: docommit => true,
3627: force => TRUE
3628: );
3629: END LOOP;
3630: CLOSE l_purge_wf_items_cur;
3631:
3632: ul := 0;
3633:
3634: OPEN l_supplier_users_cur;

Line 3826: l_itemtype wf_items.item_type%TYPE;

3822: l_username VARCHAR2(500) := '';
3823: l_password VARCHAR2(100) := '';
3824: l_supplier_reg_id NUMBER;
3825: l_disp_type VARCHAR2(20) := 'text/plain';
3826: l_itemtype wf_items.item_type%TYPE;
3827: l_itemkey wf_items.item_key%TYPE;
3828:
3829: BEGIN
3830:

Line 3827: l_itemkey wf_items.item_key%TYPE;

3823: l_password VARCHAR2(100) := '';
3824: l_supplier_reg_id NUMBER;
3825: l_disp_type VARCHAR2(20) := 'text/plain';
3826: l_itemtype wf_items.item_type%TYPE;
3827: l_itemkey wf_items.item_key%TYPE;
3828:
3829: BEGIN
3830:
3831: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN