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 354: l_itemtype wf_items.item_type%TYPE;

350: )
351: IS
352: l_supplier_name ap_suppliers.vendor_name%TYPE;
353: l_address_name hz_party_sites.party_site_name%TYPE;
354: l_itemtype wf_items.item_type%TYPE;
355: l_itemkey wf_items.item_key%TYPE;
356: l_receiver wf_roles.name%TYPE;
357: l_cur g_refcur;
358: l_count NUMBER;

Line 355: l_itemkey wf_items.item_key%TYPE;

351: IS
352: l_supplier_name ap_suppliers.vendor_name%TYPE;
353: l_address_name hz_party_sites.party_site_name%TYPE;
354: l_itemtype wf_items.item_type%TYPE;
355: l_itemkey wf_items.item_key%TYPE;
356: l_receiver wf_roles.name%TYPE;
357: l_cur g_refcur;
358: l_count NUMBER;
359: l_process wf_process_activities.process_name%TYPE;

Line 536: l_itemtype wf_items.item_type%TYPE;

532: x_receiver OUT nocopy VARCHAR2
533: )
534: IS
535: l_supplier_name ap_suppliers.vendor_name%TYPE;
536: l_itemtype wf_items.item_type%TYPE;
537: l_itemkey wf_items.item_key%TYPE;
538: l_receiver wf_roles.name%TYPE;
539: l_cur g_refcur;
540: l_count NUMBER;

Line 537: l_itemkey wf_items.item_key%TYPE;

533: )
534: IS
535: l_supplier_name ap_suppliers.vendor_name%TYPE;
536: l_itemtype wf_items.item_type%TYPE;
537: l_itemkey wf_items.item_key%TYPE;
538: l_receiver wf_roles.name%TYPE;
539: l_cur g_refcur;
540: l_count NUMBER;
541: l_step NUMBER;

Line 726: l_itemtype wf_items.item_type%TYPE;

722: )
723: IS
724: l_supplier_name ap_suppliers.vendor_name%TYPE;
725: l_contact_name hz_parties.party_name%TYPE;
726: l_itemtype wf_items.item_type%TYPE;
727: l_itemkey wf_items.item_key%TYPE;
728: l_receiver wf_roles.name%TYPE;
729: l_cur g_refcur;
730: l_count NUMBER;

Line 727: l_itemkey wf_items.item_key%TYPE;

723: IS
724: l_supplier_name ap_suppliers.vendor_name%TYPE;
725: l_contact_name hz_parties.party_name%TYPE;
726: l_itemtype wf_items.item_type%TYPE;
727: l_itemkey wf_items.item_key%TYPE;
728: l_receiver wf_roles.name%TYPE;
729: l_cur g_refcur;
730: l_count NUMBER;
731: l_process wf_process_activities.process_name%TYPE;

Line 875: l_itemtype wf_items.item_type%TYPE;

871: )
872: IS
873: l_supplier_name ap_suppliers.vendor_name%TYPE;
874: l_contact_name hz_parties.party_name%TYPE;
875: l_itemtype wf_items.item_type%TYPE;
876: l_itemkey wf_items.item_key%TYPE;
877: l_receiver wf_roles.name%TYPE;
878: l_cur g_refcur;
879: l_count NUMBER;

Line 876: l_itemkey wf_items.item_key%TYPE;

872: IS
873: l_supplier_name ap_suppliers.vendor_name%TYPE;
874: l_contact_name hz_parties.party_name%TYPE;
875: l_itemtype wf_items.item_type%TYPE;
876: l_itemkey wf_items.item_key%TYPE;
877: l_receiver wf_roles.name%TYPE;
878: l_cur g_refcur;
879: l_count NUMBER;
880: l_process wf_process_activities.process_name%TYPE;

Line 1012: l_itemtype wf_items.item_type%TYPE;

1008: x_receiver OUT nocopy VARCHAR2
1009: )
1010: IS
1011: l_supplier_name ap_suppliers.vendor_name%TYPE;
1012: l_itemtype wf_items.item_type%TYPE;
1013: l_itemkey wf_items.item_key%TYPE;
1014: l_receiver wf_roles.name%TYPE;
1015: l_cur g_refcur;
1016: l_count NUMBER;

Line 1013: l_itemkey wf_items.item_key%TYPE;

1009: )
1010: IS
1011: l_supplier_name ap_suppliers.vendor_name%TYPE;
1012: l_itemtype wf_items.item_type%TYPE;
1013: l_itemkey wf_items.item_key%TYPE;
1014: l_receiver wf_roles.name%TYPE;
1015: l_cur g_refcur;
1016: l_count NUMBER;
1017: l_step NUMBER;

Line 1299: l_itemtype wf_items.item_type%TYPE;

1295: IS
1296: PRAGMA autonomous_transaction;
1297: l_supplier_name ap_suppliers.vendor_name%TYPE;
1298: l_enterprise_name hz_parties.party_name%TYPE;
1299: l_itemtype wf_items.item_type%TYPE;
1300: l_itemkey wf_items.item_key%TYPE;
1301: l_receiver wf_roles.name%TYPE;
1302: l_cur g_refcur;
1303: l_count NUMBER;

Line 1300: l_itemkey wf_items.item_key%TYPE;

1296: PRAGMA autonomous_transaction;
1297: l_supplier_name ap_suppliers.vendor_name%TYPE;
1298: l_enterprise_name hz_parties.party_name%TYPE;
1299: l_itemtype wf_items.item_type%TYPE;
1300: l_itemkey wf_items.item_key%TYPE;
1301: l_receiver wf_roles.name%TYPE;
1302: l_cur g_refcur;
1303: l_count NUMBER;
1304: l_process wf_process_activities.process_name%TYPE;

Line 1438: l_itemtype wf_items.item_type%TYPE;

1434: x_receiver OUT nocopy VARCHAR2
1435: )
1436: IS
1437: l_supplier_name ap_suppliers.vendor_name%TYPE;
1438: l_itemtype wf_items.item_type%TYPE;
1439: l_itemkey wf_items.item_key%TYPE;
1440: l_receiver wf_roles.name%TYPE;
1441: l_cur g_refcur;
1442: l_count NUMBER;

Line 1439: l_itemkey wf_items.item_key%TYPE;

1435: )
1436: IS
1437: l_supplier_name ap_suppliers.vendor_name%TYPE;
1438: l_itemtype wf_items.item_type%TYPE;
1439: l_itemkey wf_items.item_key%TYPE;
1440: l_receiver wf_roles.name%TYPE;
1441: l_cur g_refcur;
1442: l_count NUMBER;
1443: l_process wf_process_activities.process_name%TYPE;

Line 1573: l_itemtype wf_items.item_type%TYPE;

1569: x_itemtype OUT nocopy VARCHAR2,
1570: x_itemkey OUT nocopy VARCHAR2
1571: )
1572: IS
1573: l_itemtype wf_items.item_type%TYPE;
1574: l_itemkey wf_items.item_key%TYPE;
1575: l_process wf_process_activities.process_name%TYPE;
1576: l_enterprise_name hz_parties.party_name%TYPE;
1577: l_step NUMBER;

Line 1574: l_itemkey wf_items.item_key%TYPE;

1570: x_itemkey OUT nocopy VARCHAR2
1571: )
1572: IS
1573: l_itemtype wf_items.item_type%TYPE;
1574: l_itemkey wf_items.item_key%TYPE;
1575: l_process wf_process_activities.process_name%TYPE;
1576: l_enterprise_name hz_parties.party_name%TYPE;
1577: l_step NUMBER;
1578: BEGIN

Line 1656: l_itemtype wf_items.item_type%TYPE;

1652: x_itemtype OUT nocopy VARCHAR2,
1653: x_itemkey OUT nocopy VARCHAR2
1654: )
1655: IS
1656: l_itemtype wf_items.item_type%TYPE;
1657: l_itemkey wf_items.item_key%TYPE;
1658: l_process wf_process_activities.process_name%TYPE;
1659: l_enterprise_name hz_parties.party_name%TYPE;
1660: l_step VARCHAR2(100);

Line 1657: l_itemkey wf_items.item_key%TYPE;

1653: x_itemkey OUT nocopy VARCHAR2
1654: )
1655: IS
1656: l_itemtype wf_items.item_type%TYPE;
1657: l_itemkey wf_items.item_key%TYPE;
1658: l_process wf_process_activities.process_name%TYPE;
1659: l_enterprise_name hz_parties.party_name%TYPE;
1660: l_step VARCHAR2(100);
1661: BEGIN

Line 1739: l_itemtype wf_items.item_type%TYPE;

1735: x_itemkey OUT nocopy VARCHAR2,
1736: x_receiver OUT nocopy VARCHAR2
1737: )
1738: IS
1739: l_itemtype wf_items.item_type%TYPE;
1740: l_itemkey wf_items.item_key%TYPE;
1741: l_process wf_process_activities.process_name%TYPE;
1742:
1743: CURSOR l_cur IS

Line 1740: l_itemkey wf_items.item_key%TYPE;

1736: x_receiver OUT nocopy VARCHAR2
1737: )
1738: IS
1739: l_itemtype wf_items.item_type%TYPE;
1740: l_itemkey wf_items.item_key%TYPE;
1741: l_process wf_process_activities.process_name%TYPE;
1742:
1743: CURSOR l_cur IS
1744: SELECT email_address, first_name, last_name

Line 2166: l_itemtype wf_items.item_type%TYPE;

2162: p_bank_account_number IN VARCHAR2,
2163: x_itemtype OUT nocopy VARCHAR2,
2164: x_itemkey OUT nocopy VARCHAR2)
2165: IS
2166: l_itemtype wf_items.item_type%TYPE;
2167: l_itemkey wf_items.item_key%TYPE;
2168: l_process wf_process_activities.process_name%TYPE;
2169: l_step NUMBER;
2170: l_supplier_name ap_suppliers.vendor_name%TYPE;

Line 2167: l_itemkey wf_items.item_key%TYPE;

2163: x_itemtype OUT nocopy VARCHAR2,
2164: x_itemkey OUT nocopy VARCHAR2)
2165: IS
2166: l_itemtype wf_items.item_type%TYPE;
2167: l_itemkey wf_items.item_key%TYPE;
2168: l_process wf_process_activities.process_name%TYPE;
2169: l_step NUMBER;
2170: l_supplier_name ap_suppliers.vendor_name%TYPE;
2171: l_first_name hz_parties.person_first_name%TYPE;

Line 2251: l_itemtype wf_items.item_type%TYPE;

2247: p_bank_account_number IN VARCHAR2,
2248: x_itemtype OUT nocopy VARCHAR2,
2249: x_itemkey OUT nocopy VARCHAR2)
2250: IS
2251: l_itemtype wf_items.item_type%TYPE;
2252: l_itemkey wf_items.item_key%TYPE;
2253: l_process wf_process_activities.process_name%TYPE;
2254: l_step NUMBER;
2255: l_supplier_name ap_suppliers.vendor_name%TYPE;

Line 2252: l_itemkey wf_items.item_key%TYPE;

2248: x_itemtype OUT nocopy VARCHAR2,
2249: x_itemkey OUT nocopy VARCHAR2)
2250: IS
2251: l_itemtype wf_items.item_type%TYPE;
2252: l_itemkey wf_items.item_key%TYPE;
2253: l_process wf_process_activities.process_name%TYPE;
2254: l_step NUMBER;
2255: l_supplier_name ap_suppliers.vendor_name%TYPE;
2256: l_enterprise_name hz_parties.party_name%TYPE;

Line 2349: l_itemtype wf_items.item_type%TYPE;

2345: p_bank_account_name IN VARCHAR2,
2346: x_itemtype OUT nocopy VARCHAR2,
2347: x_itemkey OUT nocopy VARCHAR2)
2348: IS
2349: l_itemtype wf_items.item_type%TYPE;
2350: l_itemkey wf_items.item_key%TYPE;
2351: l_process wf_process_activities.process_name%TYPE;
2352: l_step NUMBER;
2353: l_supplier_name ap_suppliers.vendor_name%TYPE;

Line 2350: l_itemkey wf_items.item_key%TYPE;

2346: x_itemtype OUT nocopy VARCHAR2,
2347: x_itemkey OUT nocopy VARCHAR2)
2348: IS
2349: l_itemtype wf_items.item_type%TYPE;
2350: l_itemkey wf_items.item_key%TYPE;
2351: l_process wf_process_activities.process_name%TYPE;
2352: l_step NUMBER;
2353: l_supplier_name ap_suppliers.vendor_name%TYPE;
2354: l_first_name hz_parties.person_first_name%TYPE;

Line 2451: l_itemtype wf_items.item_type%TYPE;

2447: p_bank_account_name IN VARCHAR2,
2448: x_itemtype OUT nocopy VARCHAR2,
2449: x_itemkey OUT nocopy VARCHAR2)
2450: IS
2451: l_itemtype wf_items.item_type%TYPE;
2452: l_itemkey wf_items.item_key%TYPE;
2453: l_process wf_process_activities.process_name%TYPE;
2454: l_step NUMBER;
2455: l_supplier_name ap_suppliers.vendor_name%TYPE;

Line 2452: l_itemkey wf_items.item_key%TYPE;

2448: x_itemtype OUT nocopy VARCHAR2,
2449: x_itemkey OUT nocopy VARCHAR2)
2450: IS
2451: l_itemtype wf_items.item_type%TYPE;
2452: l_itemkey wf_items.item_key%TYPE;
2453: l_process wf_process_activities.process_name%TYPE;
2454: l_step NUMBER;
2455: l_supplier_name ap_suppliers.vendor_name%TYPE;
2456: l_first_name hz_parties.person_first_name%TYPE;

Line 2555: l_itemtype wf_items.item_type%TYPE;

2551: x_itemtype OUT nocopy VARCHAR2,
2552: x_itemkey OUT nocopy VARCHAR2
2553: ) IS
2554:
2555: l_itemtype wf_items.item_type%TYPE;
2556: l_itemkey wf_items.item_key%TYPE;
2557: l_process wf_process_activities.process_name%TYPE;
2558: l_enterprise_name hz_parties.party_name%TYPE;
2559: l_step NUMBER;

Line 2556: l_itemkey wf_items.item_key%TYPE;

2552: x_itemkey OUT nocopy VARCHAR2
2553: ) IS
2554:
2555: l_itemtype wf_items.item_type%TYPE;
2556: l_itemkey wf_items.item_key%TYPE;
2557: l_process wf_process_activities.process_name%TYPE;
2558: l_enterprise_name hz_parties.party_name%TYPE;
2559: l_step NUMBER;
2560:

Line 2697: l_itemtype wf_items.item_type%TYPE;

2693: p_action IN VARCHAR2,
2694: x_itemtype OUT nocopy VARCHAR2,
2695: x_itemkey OUT nocopy VARCHAR2
2696: ) IS
2697: l_itemtype wf_items.item_type%TYPE;
2698: l_itemkey wf_items.item_key%TYPE;
2699: l_process wf_process_activities.process_name%TYPE;
2700: l_step NUMBER;
2701: l_count NUMBER;

Line 2698: l_itemkey wf_items.item_key%TYPE;

2694: x_itemtype OUT nocopy VARCHAR2,
2695: x_itemkey OUT nocopy VARCHAR2
2696: ) IS
2697: l_itemtype wf_items.item_type%TYPE;
2698: l_itemkey wf_items.item_key%TYPE;
2699: l_process wf_process_activities.process_name%TYPE;
2700: l_step NUMBER;
2701: l_count NUMBER;
2702:

Line 2880: l_itemtype wf_items.item_type%TYPE;

2876: PROCEDURE send_supplier_invite_reg_ntf
2877: (p_supplier_reg_id IN NUMBER
2878: )
2879: IS
2880: l_itemtype wf_items.item_type%TYPE;
2881: l_itemkey wf_items.item_key%TYPE;
2882: l_receiver wf_roles.name%TYPE;
2883: l_process wf_process_activities.process_name%TYPE;
2884:

Line 2881: l_itemkey wf_items.item_key%TYPE;

2877: (p_supplier_reg_id IN NUMBER
2878: )
2879: IS
2880: l_itemtype wf_items.item_type%TYPE;
2881: l_itemkey wf_items.item_key%TYPE;
2882: l_receiver wf_roles.name%TYPE;
2883: l_process wf_process_activities.process_name%TYPE;
2884:
2885: CURSOR l_cur IS

Line 2953: l_itemtype wf_items.item_type%TYPE;

2949: PROCEDURE send_supplier_reg_saved_ntf
2950: (p_supplier_reg_id IN NUMBER
2951: )
2952: IS
2953: l_itemtype wf_items.item_type%TYPE;
2954: l_itemkey wf_items.item_key%TYPE;
2955: l_receiver wf_roles.name%TYPE;
2956: l_process wf_process_activities.process_name%TYPE;
2957:

Line 2954: l_itemkey wf_items.item_key%TYPE;

2950: (p_supplier_reg_id IN NUMBER
2951: )
2952: IS
2953: l_itemtype wf_items.item_type%TYPE;
2954: l_itemkey wf_items.item_key%TYPE;
2955: l_receiver wf_roles.name%TYPE;
2956: l_process wf_process_activities.process_name%TYPE;
2957:
2958: CURSOR l_cur IS

Line 3055: l_itemtype wf_items.item_type%TYPE;

3051: x_receiver OUT nocopy VARCHAR2
3052: )
3053: IS
3054: l_supplier_name ap_suppliers.vendor_name%TYPE;
3055: l_itemtype wf_items.item_type%TYPE;
3056: l_itemkey wf_items.item_key%TYPE;
3057: l_receiver wf_roles.name%TYPE;
3058: l_cur g_refcur;
3059: l_count NUMBER;

Line 3056: l_itemkey wf_items.item_key%TYPE;

3052: )
3053: IS
3054: l_supplier_name ap_suppliers.vendor_name%TYPE;
3055: l_itemtype wf_items.item_type%TYPE;
3056: l_itemkey wf_items.item_key%TYPE;
3057: l_receiver wf_roles.name%TYPE;
3058: l_cur g_refcur;
3059: l_count NUMBER;
3060: l_process wf_process_activities.process_name%TYPE;

Line 3141: l_itemtype wf_items.item_type%TYPE;

3137: x_itemtype OUT nocopy VARCHAR2,
3138: x_itemkey OUT nocopy VARCHAR2
3139: )
3140: IS
3141: l_itemtype wf_items.item_type%TYPE;
3142: l_itemkey wf_items.item_key%TYPE;
3143: l_process wf_process_activities.process_name%TYPE;
3144: l_enterprise_name hz_parties.party_name%TYPE;
3145: l_step NUMBER;

Line 3142: l_itemkey wf_items.item_key%TYPE;

3138: x_itemkey OUT nocopy VARCHAR2
3139: )
3140: IS
3141: l_itemtype wf_items.item_type%TYPE;
3142: l_itemkey wf_items.item_key%TYPE;
3143: l_process wf_process_activities.process_name%TYPE;
3144: l_enterprise_name hz_parties.party_name%TYPE;
3145: l_step NUMBER;
3146: BEGIN

Line 3216: l_itemtype wf_items.item_type%TYPE;

3212: x_itemtype OUT nocopy VARCHAR2,
3213: x_itemkey OUT nocopy VARCHAR2
3214: )
3215: IS
3216: l_itemtype wf_items.item_type%TYPE;
3217: l_itemkey wf_items.item_key%TYPE;
3218: l_process wf_process_activities.process_name%TYPE;
3219: l_enterprise_name hz_parties.party_name%TYPE;
3220: l_step VARCHAR2(100);

Line 3217: l_itemkey wf_items.item_key%TYPE;

3213: x_itemkey OUT nocopy VARCHAR2
3214: )
3215: IS
3216: l_itemtype wf_items.item_type%TYPE;
3217: l_itemkey wf_items.item_key%TYPE;
3218: l_process wf_process_activities.process_name%TYPE;
3219: l_enterprise_name hz_parties.party_name%TYPE;
3220: l_step VARCHAR2(100);
3221: BEGIN

Line 3310: l_itemtype wf_items.item_type%TYPE;

3306: l_last_certification_date DATE;
3307: l_due_date DATE;
3308: l_expiration_date DATE;
3309:
3310: l_itemtype wf_items.item_type%TYPE;
3311: l_purge_itemkey wf_items.item_key%TYPE;
3312: l_itemkey wf_items.item_key%TYPE;
3313: l_purge_item_key_type wf_items.item_key%TYPE;
3314: l_process wf_process_activities.process_name%TYPE;

Line 3311: l_purge_itemkey wf_items.item_key%TYPE;

3307: l_due_date DATE;
3308: l_expiration_date DATE;
3309:
3310: l_itemtype wf_items.item_type%TYPE;
3311: l_purge_itemkey wf_items.item_key%TYPE;
3312: l_itemkey wf_items.item_key%TYPE;
3313: l_purge_item_key_type wf_items.item_key%TYPE;
3314: l_process wf_process_activities.process_name%TYPE;
3315: l_users WF_DIRECTORY.UserTable;

Line 3312: l_itemkey wf_items.item_key%TYPE;

3308: l_expiration_date DATE;
3309:
3310: l_itemtype wf_items.item_type%TYPE;
3311: l_purge_itemkey wf_items.item_key%TYPE;
3312: l_itemkey wf_items.item_key%TYPE;
3313: l_purge_item_key_type wf_items.item_key%TYPE;
3314: l_process wf_process_activities.process_name%TYPE;
3315: l_users WF_DIRECTORY.UserTable;
3316:

Line 3313: l_purge_item_key_type wf_items.item_key%TYPE;

3309:
3310: l_itemtype wf_items.item_type%TYPE;
3311: l_purge_itemkey wf_items.item_key%TYPE;
3312: l_itemkey wf_items.item_key%TYPE;
3313: l_purge_item_key_type wf_items.item_key%TYPE;
3314: l_process wf_process_activities.process_name%TYPE;
3315: l_users WF_DIRECTORY.UserTable;
3316:
3317: CURSOR l_vendor_id_cur IS

Line 3356: CURSOR l_purge_wf_items_cur(l_purge_item_key_type VARCHAR2) IS

3352: AND hpua.status_flag = 'A'
3353: AND hpua.party_usage_code = 'SUPPLIER_CONTACT'
3354: AND (hpua.effective_end_date IS NULL OR hpua.effective_end_date > Sysdate);
3355:
3356: CURSOR l_purge_wf_items_cur(l_purge_item_key_type VARCHAR2) IS
3357: SELECT item_key
3358: FROM wf_items
3359: WHERE item_key LIKE l_purge_item_key_type;
3360:

Line 3358: FROM wf_items

3354: AND (hpua.effective_end_date IS NULL OR hpua.effective_end_date > Sysdate);
3355:
3356: CURSOR l_purge_wf_items_cur(l_purge_item_key_type VARCHAR2) IS
3357: SELECT item_key
3358: FROM wf_items
3359: WHERE item_key LIKE l_purge_item_key_type;
3360:
3361: BEGIN
3362: l_supplier_count := 0;

Line 3393: OPEN l_purge_wf_items_cur(l_purge_item_key_type);

3389: get_wf_item_type (l_itemtype);
3390:
3391: l_purge_item_key_type := l_itemtype||'_'||l_process||'_%_VENDOR_ID_'||to_char(l_vendor_id);
3392:
3393: OPEN l_purge_wf_items_cur(l_purge_item_key_type);
3394: LOOP
3395:
3396: FETCH l_purge_wf_items_cur INTO l_purge_itemkey;
3397: EXIT WHEN l_purge_wf_items_cur%NOTFOUND;

Line 3396: FETCH l_purge_wf_items_cur INTO l_purge_itemkey;

3392:
3393: OPEN l_purge_wf_items_cur(l_purge_item_key_type);
3394: LOOP
3395:
3396: FETCH l_purge_wf_items_cur INTO l_purge_itemkey;
3397: EXIT WHEN l_purge_wf_items_cur%NOTFOUND;
3398:
3399: WF_PURGE.ITEMS (itemtype => l_itemtype,
3400: itemkey => l_purge_itemkey,

Line 3397: EXIT WHEN l_purge_wf_items_cur%NOTFOUND;

3393: OPEN l_purge_wf_items_cur(l_purge_item_key_type);
3394: LOOP
3395:
3396: FETCH l_purge_wf_items_cur INTO l_purge_itemkey;
3397: EXIT WHEN l_purge_wf_items_cur%NOTFOUND;
3398:
3399: WF_PURGE.ITEMS (itemtype => l_itemtype,
3400: itemkey => l_purge_itemkey,
3401: enddate => SYSDATE,

Line 3406: CLOSE l_purge_wf_items_cur;

3402: docommit => true,
3403: force => TRUE
3404: );
3405: END LOOP;
3406: CLOSE l_purge_wf_items_cur;
3407:
3408: ul := 0;
3409:
3410: OPEN l_supplier_users_cur;