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_ROLES

Line 100: --l_name wf_roles.name%TYPE;

96:
97: PROCEDURE get_adhoc_role_name
98: (p_process IN VARCHAR2,
99: x_name OUT nocopy VARCHAR2) IS
100: --l_name wf_roles.name%TYPE;
101: --l_index NUMBER := 1;
102: BEGIN
103: x_name := 'POSSPM1_' || p_process || '_' ||
104: To_char(Sysdate, 'MMDDYYYY_HH24MISS') || '_' || fnd_crypto.smallrandomnumber;

Line 130: l_name wf_roles.name%TYPE;

126: p_role IN VARCHAR2,
127: x_count OUT nocopy NUMBER
128: ) IS
129: l_count NUMBER;
130: l_name wf_roles.name%TYPE;
131: BEGIN
132: l_count := 0;
133: WHILE TRUE LOOP
134: FETCH p_refcur INTO l_name;

Line 356: l_receiver wf_roles.name%TYPE;

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;
360: l_step NUMBER;

Line 538: l_receiver wf_roles.name%TYPE;

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;
542: l_bus_class_name fnd_lookup_values.meaning%TYPE;

Line 728: l_receiver wf_roles.name%TYPE;

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;
732: l_step NUMBER;

Line 877: l_receiver wf_roles.name%TYPE;

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;
881: l_step NUMBER;

Line 1014: l_receiver wf_roles.name%TYPE;

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;
1018: BEGIN

Line 1163: l_receiver wf_roles.name%TYPE;

1159: p_vendor_id IN NUMBER,
1160: x_receiver OUT nocopy VARCHAR2
1161: )
1162: IS
1163: l_receiver wf_roles.name%TYPE;
1164: l_adhoc_user wf_roles.name%TYPE;
1165:
1166: CURSOR l_user_name_cur IS
1167: SELECT fu.user_name

Line 1164: l_adhoc_user wf_roles.name%TYPE;

1160: x_receiver OUT nocopy VARCHAR2
1161: )
1162: IS
1163: l_receiver wf_roles.name%TYPE;
1164: l_adhoc_user wf_roles.name%TYPE;
1165:
1166: CURSOR l_user_name_cur IS
1167: SELECT fu.user_name
1168: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua

Line 1301: l_receiver wf_roles.name%TYPE;

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;
1305: l_step NUMBER;

Line 1440: l_receiver wf_roles.name%TYPE;

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;
1444: l_ou_id NUMBER;

Line 1750: l_receiver wf_roles.name%TYPE;

1746: WHERE mapping_id IN (SELECT mapping_id FROM pos_supplier_mappings WHERE supplier_reg_id = p_supplier_reg_id)
1747: AND do_not_delete = 'Y';
1748:
1749: l_rec l_cur%ROWTYPE;
1750: l_receiver wf_roles.name%TYPE;
1751: l_enterprise_name hz_parties.party_name%TYPE;
1752: l_display_name wf_roles.display_name%TYPE;
1753: l_step NUMBER;
1754: BEGIN

Line 1752: l_display_name wf_roles.display_name%TYPE;

1748:
1749: l_rec l_cur%ROWTYPE;
1750: l_receiver wf_roles.name%TYPE;
1751: l_enterprise_name hz_parties.party_name%TYPE;
1752: l_display_name wf_roles.display_name%TYPE;
1753: l_step NUMBER;
1754: BEGIN
1755: l_step := 0;
1756: get_enterprise_name(l_enterprise_name);

Line 1920: l_receiver wf_roles.name%TYPE;

1916: actid IN NUMBER,
1917: funcmode IN VARCHAR2,
1918: resultout OUT nocopy VARCHAR2)
1919: IS
1920: l_receiver wf_roles.name%TYPE;
1921: l_vendor_id NUMBER;
1922: l_function_id NUMBER;
1923:
1924: CURSOR l_receiver_cur IS

Line 1990: l_receiver wf_roles.name%TYPE;

1986: actid IN NUMBER,
1987: funcmode IN VARCHAR2,
1988: resultout OUT nocopy VARCHAR2)
1989: IS
1990: l_receiver wf_roles.name%TYPE;
1991: l_cur g_refcur;
1992: l_count NUMBER;
1993: l_vendor_id NUMBER;
1994: l_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;

Line 2096: l_receiver wf_roles.name%TYPE;

2092: actid IN NUMBER,
2093: funcmode IN VARCHAR2,
2094: resultout OUT nocopy VARCHAR2)
2095: IS
2096: l_receiver wf_roles.name%TYPE;
2097: l_cur g_refcur;
2098: l_count NUMBER;
2099: l_vendor_id NUMBER;
2100: l_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;

Line 2631: l_receiver wf_roles.name%TYPE;

2627: actid IN NUMBER,
2628: funcmode IN VARCHAR2,
2629: resultout OUT nocopy VARCHAR2)
2630: IS
2631: l_receiver wf_roles.name%TYPE;
2632: l_cur g_refcur;
2633: l_count NUMBER;
2634: l_vendor_id NUMBER;
2635: l_bank_branch_id NUMBER;

Line 2882: l_receiver wf_roles.name%TYPE;

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

Line 2955: l_receiver wf_roles.name%TYPE;

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

Line 3057: l_receiver wf_roles.name%TYPE;

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;
3061: l_step NUMBER;