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 152: --l_name wf_roles.name%TYPE;

148:
149: PROCEDURE get_adhoc_role_name
150: (p_process IN VARCHAR2,
151: x_name OUT nocopy VARCHAR2) IS
152: --l_name wf_roles.name%TYPE;
153: --l_index NUMBER := 1;
154: BEGIN
155: x_name := 'POSSPM1_' || p_process || '_' ||
156: To_char(Sysdate, 'MMDDYYYY_HH24MISS') || '_' || fnd_crypto.smallrandomnumber;

Line 182: l_name wf_roles.name%TYPE;

178: p_role IN VARCHAR2,
179: x_count OUT nocopy NUMBER
180: ) IS
181: l_count NUMBER;
182: l_name wf_roles.name%TYPE;
183: BEGIN
184: l_count := 0;
185: WHILE TRUE LOOP
186: FETCH p_refcur INTO l_name;

Line 408: l_receiver wf_roles.name%TYPE;

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

Line 590: l_receiver wf_roles.name%TYPE;

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

Line 780: l_receiver wf_roles.name%TYPE;

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

Line 929: l_receiver wf_roles.name%TYPE;

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

Line 1066: l_receiver wf_roles.name%TYPE;

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

Line 1215: l_receiver wf_roles.name%TYPE;

1211: p_vendor_id IN NUMBER,
1212: x_receiver OUT nocopy VARCHAR2
1213: )
1214: IS
1215: l_receiver wf_roles.name%TYPE;
1216: l_adhoc_user wf_roles.name%TYPE;
1217:
1218: CURSOR l_user_name_cur IS
1219: SELECT fu.user_name

Line 1216: l_adhoc_user wf_roles.name%TYPE;

1212: x_receiver OUT nocopy VARCHAR2
1213: )
1214: IS
1215: l_receiver wf_roles.name%TYPE;
1216: l_adhoc_user wf_roles.name%TYPE;
1217:
1218: CURSOR l_user_name_cur IS
1219: SELECT fu.user_name
1220: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua

Line 1353: l_receiver wf_roles.name%TYPE;

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

Line 1492: l_receiver wf_roles.name%TYPE;

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

Line 1818: l_receiver wf_roles.name%TYPE;

1814: WHERE mapping_id IN (SELECT mapping_id FROM pos_supplier_mappings WHERE supplier_reg_id = p_supplier_reg_id)
1815: AND do_not_delete = 'Y';
1816:
1817: l_rec l_cur%ROWTYPE;
1818: l_receiver wf_roles.name%TYPE;
1819: l_enterprise_name hz_parties.party_name%TYPE;
1820: l_display_name wf_roles.display_name%TYPE;
1821: l_step NUMBER;
1822: BEGIN

Line 1820: l_display_name wf_roles.display_name%TYPE;

1816:
1817: l_rec l_cur%ROWTYPE;
1818: l_receiver wf_roles.name%TYPE;
1819: l_enterprise_name hz_parties.party_name%TYPE;
1820: l_display_name wf_roles.display_name%TYPE;
1821: l_step NUMBER;
1822: BEGIN
1823: l_step := 0;
1824: get_enterprise_name(l_enterprise_name);

Line 1988: l_receiver wf_roles.name%TYPE;

1984: actid IN NUMBER,
1985: funcmode IN VARCHAR2,
1986: resultout OUT nocopy VARCHAR2)
1987: IS
1988: l_receiver wf_roles.name%TYPE;
1989: l_vendor_id NUMBER;
1990: l_function_id NUMBER;
1991:
1992: CURSOR l_receiver_cur IS

Line 2058: l_receiver wf_roles.name%TYPE;

2054: actid IN NUMBER,
2055: funcmode IN VARCHAR2,
2056: resultout OUT nocopy VARCHAR2)
2057: IS
2058: l_receiver wf_roles.name%TYPE;
2059: l_cur g_refcur;
2060: l_count NUMBER;
2061: l_vendor_id NUMBER;
2062: l_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;

Line 2164: l_receiver wf_roles.name%TYPE;

2160: actid IN NUMBER,
2161: funcmode IN VARCHAR2,
2162: resultout OUT nocopy VARCHAR2)
2163: IS
2164: l_receiver wf_roles.name%TYPE;
2165: l_cur g_refcur;
2166: l_count NUMBER;
2167: l_vendor_id NUMBER;
2168: l_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;

Line 2699: l_receiver wf_roles.name%TYPE;

2695: actid IN NUMBER,
2696: funcmode IN VARCHAR2,
2697: resultout OUT nocopy VARCHAR2)
2698: IS
2699: l_receiver wf_roles.name%TYPE;
2700: l_cur g_refcur;
2701: l_count NUMBER;
2702: l_vendor_id NUMBER;
2703: l_bank_branch_id NUMBER;

Line 2950: l_receiver wf_roles.name%TYPE;

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

Line 3023: l_receiver wf_roles.name%TYPE;

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

Line 3126: l_receiver wf_roles.name%TYPE;

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';
3130: C_EMAIL_USER_LIST varchar2(30000);

Line 3242: l_receiver wf_roles.name%TYPE;

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