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_PROCESS_ACTIVITIES

Line 359: l_process wf_process_activities.process_name%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;
360: l_step NUMBER;
361: BEGIN
362: l_step := 0;
363: get_supplier_name(p_vendor_id, l_supplier_name);

Line 731: l_process wf_process_activities.process_name%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;
732: l_step NUMBER;
733: BEGIN
734: l_step := 0;
735: get_supplier_name(p_vendor_id, l_supplier_name);

Line 880: l_process wf_process_activities.process_name%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;
881: l_step NUMBER;
882: BEGIN
883: l_step := 0;
884: get_supplier_name(p_vendor_id, l_supplier_name);

Line 1304: l_process wf_process_activities.process_name%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;
1305: l_step NUMBER;
1306: BEGIN
1307: l_step := 0;
1308: get_supplier_name(p_vendor_id, l_supplier_name);

Line 1443: l_process wf_process_activities.process_name%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;
1444: l_ou_id NUMBER;
1445: l_step NUMBER;
1446: BEGIN
1447:

Line 1575: l_process wf_process_activities.process_name%TYPE;

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
1579: l_step := 0;

Line 1658: l_process wf_process_activities.process_name%TYPE;

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
1662: l_step := 1;

Line 1741: l_process wf_process_activities.process_name%TYPE;

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
1745: FROM pos_contact_requests

Line 2168: l_process wf_process_activities.process_name%TYPE;

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;
2172: l_last_name hz_parties.person_last_name%TYPE;

Line 2253: l_process wf_process_activities.process_name%TYPE;

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;
2257: l_first_name hz_parties.person_first_name%TYPE;

Line 2351: l_process wf_process_activities.process_name%TYPE;

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;
2355: l_last_name hz_parties.person_last_name%TYPE;

Line 2453: l_process wf_process_activities.process_name%TYPE;

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;
2457: l_last_name hz_parties.person_last_name%TYPE;

Line 2557: l_process wf_process_activities.process_name%TYPE;

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:
2561: BEGIN

Line 2699: l_process wf_process_activities.process_name%TYPE;

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:
2703: l_supplier_name ap_suppliers.vendor_name%TYPE;

Line 2883: l_process wf_process_activities.process_name%TYPE;

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
2886: SELECT psr.reg_key, pcr.first_name, pcr.last_name, pcr.email_address
2887: FROM pos_supplier_registrations psr,

Line 2956: l_process wf_process_activities.process_name%TYPE;

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
2959: SELECT psr.reg_key, pcr.first_name, pcr.last_name, pcr.email_address
2960: FROM pos_supplier_registrations psr,

Line 3060: l_process wf_process_activities.process_name%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;
3061: l_step NUMBER;
3062: BEGIN
3063: l_step := 0;
3064: get_supplier_name(p_vendor_id, l_supplier_name);

Line 3143: l_process wf_process_activities.process_name%TYPE;

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
3147: l_step := 0;

Line 3218: l_process wf_process_activities.process_name%TYPE;

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
3222: l_step := 1;

Line 3314: l_process wf_process_activities.process_name%TYPE;

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
3318: SELECT APS.VENDOR_ID