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 411: l_process wf_process_activities.process_name%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;
412: l_step NUMBER;
413: BEGIN
414: l_step := 0;
415: get_supplier_name(p_vendor_id, l_supplier_name);

Line 783: l_process wf_process_activities.process_name%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;
784: l_step NUMBER;
785: BEGIN
786: l_step := 0;
787: get_supplier_name(p_vendor_id, l_supplier_name);

Line 932: l_process wf_process_activities.process_name%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;
933: l_step NUMBER;
934: BEGIN
935: l_step := 0;
936: get_supplier_name(p_vendor_id, l_supplier_name);

Line 1356: l_process wf_process_activities.process_name%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;
1357: l_step NUMBER;
1358: BEGIN
1359: l_step := 0;
1360: get_supplier_name(p_vendor_id, l_supplier_name);

Line 1495: l_process wf_process_activities.process_name%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;
1496: l_ou_id NUMBER;
1497: l_step NUMBER;
1498: BEGIN
1499:

Line 1627: l_process wf_process_activities.process_name%TYPE;

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

Line 1726: l_process wf_process_activities.process_name%TYPE;

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

Line 1809: l_process wf_process_activities.process_name%TYPE;

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

Line 2236: l_process wf_process_activities.process_name%TYPE;

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

Line 2321: l_process wf_process_activities.process_name%TYPE;

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

Line 2419: l_process wf_process_activities.process_name%TYPE;

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

Line 2521: l_process wf_process_activities.process_name%TYPE;

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

Line 2625: l_process wf_process_activities.process_name%TYPE;

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

Line 2767: l_process wf_process_activities.process_name%TYPE;

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

Line 2951: l_process wf_process_activities.process_name%TYPE;

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

Line 3024: l_process wf_process_activities.process_name%TYPE;

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

Line 3129: l_process wf_process_activities.process_name%TYPE:='SUPP_REG_NOTIFY';

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';
3130: C_EMAIL_USER_LIST varchar2(30000);
3131: L_EMAIL_USER_COUNT number;
3132: L_ADHOC_USER VARCHAR2(400);
3133: L_DISPLAY_NAME VARCHAR2(200);

Line 3245: l_process wf_process_activities.process_name%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;
3246: l_step NUMBER;
3247: BEGIN
3248: l_step := 0;
3249: get_supplier_name(p_vendor_id, l_supplier_name);

Line 3328: l_process wf_process_activities.process_name%TYPE;

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

Line 3416: l_process wf_process_activities.process_name%TYPE;

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

Line 3512: l_process wf_process_activities.process_name%TYPE;

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 */
3516: CURSOR l_vendor_id_cur IS