DBA Data[Home] [Help]

APPS.POS_SPM_WF_PKG1 dependencies on WF_DIRECTORY

Line 33: -- using the new procedure wf_directory.addUserToAdHocRle2

29: RETURN l_function_id;
30: END get_function_id;
31:
32: -- utility to add user to a workflow adhoc role
33: -- using the new procedure wf_directory.addUserToAdHocRle2
34: PROCEDURE addusertoadhocrole
35: (p_role_name IN VARCHAR2,
36: p_user_name IN VARCHAR2)
37: IS

Line 38: l_user_table wf_directory.usertable;

34: PROCEDURE addusertoadhocrole
35: (p_role_name IN VARCHAR2,
36: p_user_name IN VARCHAR2)
37: IS
38: l_user_table wf_directory.usertable;
39: BEGIN
40: l_user_table(1) := p_user_name;
41: wf_directory.adduserstoadhocrole2(p_role_name, l_user_table);
42: END addusertoadhocrole;

Line 41: wf_directory.adduserstoadhocrole2(p_role_name, l_user_table);

37: IS
38: l_user_table wf_directory.usertable;
39: BEGIN
40: l_user_table(1) := p_user_name;
41: wf_directory.adduserstoadhocrole2(p_role_name, l_user_table);
42: END addusertoadhocrole;
43:
44: PROCEDURE get_enterprise_name(x_name OUT nocopy VARCHAR2)
45: IS

Line 107: --WHILE(wf_directory.getroledisplayname(l_name) IS NOT NULL) LOOP

103: x_name := 'POSSPM1_' || p_process || '_' ||
104: To_char(Sysdate, 'MMDDYYYY_HH24MISS') || '_' || fnd_crypto.smallrandomnumber;
105: -- bug 3569374
106: --l_name := x_name;
107: --WHILE(wf_directory.getroledisplayname(l_name) IS NOT NULL) LOOP
108: -- l_name := x_name || '_' || l_index;
109: -- l_index := l_index + 1;
110: --END LOOP;
111: --x_name := l_name;

Line 119: wf_directory.CreateAdHocRole

115: (p_process IN VARCHAR2,
116: x_name OUT nocopy VARCHAR2) IS
117: BEGIN
118: get_adhoc_role_name(p_process,x_name);
119: wf_directory.CreateAdHocRole
120: (role_name => x_name,
121: role_display_name => x_name);
122: END create_adhoc_role;
123:

Line 1242: wf_directory.CreateAdHocUser

1238: IF l_count = 0 then
1239: FOR l_rec IN l_cur LOOP
1240: l_count := l_count + 1;
1241: l_adhoc_user := l_receiver || '_' || l_count;
1242: wf_directory.CreateAdHocUser
1243: (name => l_adhoc_user,
1244: display_name => l_rec.email_address,
1245: language => l_rec.language,
1246: territory => l_rec.nls_territory ,

Line 1258: wf_directory.CreateAdHocUser

1254: IF l_count = 0 THEN
1255: FOR l_contact_rec IN l_contact_cur LOOP
1256: l_count := l_count + 1;
1257: l_adhoc_user := l_receiver || '_' || l_count;
1258: wf_directory.CreateAdHocUser
1259: (name => l_adhoc_user,
1260: display_name => l_contact_rec.email_address,
1261: email_address => l_contact_rec.email_address
1262: );

Line 1273: l_users wf_directory.usertable;

1269:
1270: -- return Y if the role has at least one active user; otherwise N
1271: FUNCTION wfrole_has_active_user
1272: (p_role IN VARCHAR2) RETURN VARCHAR2 IS
1273: l_users wf_directory.usertable;
1274: l_username wf_users.name%TYPE;
1275: BEGIN
1276: wf_directory.GetRoleUsers(p_role, l_users);
1277: FOR l_index IN 1..l_users.COUNT LOOP

Line 1276: wf_directory.GetRoleUsers(p_role, l_users);

1272: (p_role IN VARCHAR2) RETURN VARCHAR2 IS
1273: l_users wf_directory.usertable;
1274: l_username wf_users.name%TYPE;
1275: BEGIN
1276: wf_directory.GetRoleUsers(p_role, l_users);
1277: FOR l_index IN 1..l_users.COUNT LOOP
1278: IF l_users(l_index) IS NOT NULL
1279: AND wf_directory.UserActive(l_users(l_index)) THEN
1280: RETURN 'Y';

Line 1279: AND wf_directory.UserActive(l_users(l_index)) THEN

1275: BEGIN
1276: wf_directory.GetRoleUsers(p_role, l_users);
1277: FOR l_index IN 1..l_users.COUNT LOOP
1278: IF l_users(l_index) IS NOT NULL
1279: AND wf_directory.UserActive(l_users(l_index)) THEN
1280: RETURN 'Y';
1281: END IF;
1282: END LOOP;
1283: RETURN 'N';

Line 1773: wf_directory.CreateAdHocUser

1769: l_process := 'PSUPPLIER_REJECTED';
1770: get_adhoc_role_name(l_process, l_receiver);
1771:
1772: l_step := 3;
1773: wf_directory.CreateAdHocUser
1774: (name => l_receiver,
1775: display_name => l_display_name,
1776: email_address => l_rec.email_address
1777: );

Line 2912: wf_directory.createadhocuser

2908: l_process := 'SEND_SUPPLIER_INVITE_REG_NTF';
2909: get_wf_item_key(l_process, p_supplier_reg_id, l_itemkey);
2910: l_receiver := l_process || '_' || p_supplier_reg_id;
2911:
2912: wf_directory.createadhocuser
2913: ( name => l_receiver,
2914: display_name => l_receiver,
2915: email_address => l_rec.email_address
2916: );

Line 2972: l_wf_role_rec wf_directory.wf_local_roles_rec_type;

2968: l_rec l_cur%ROWTYPE;
2969:
2970: l_enterprise_name hz_parties.party_name%TYPE;
2971:
2972: l_wf_role_rec wf_directory.wf_local_roles_rec_type;
2973:
2974: BEGIN
2975: OPEN l_cur;
2976: FETCH l_cur INTO l_rec;

Line 2988: wf_directory.GetRoleInfo

2984: l_process := 'SEND_SUPPLIER_REG_SAVED_NTF';
2985: get_wf_item_key(l_process, p_supplier_reg_id, l_itemkey);
2986: l_receiver := l_process || '_' || p_supplier_reg_id;
2987:
2988: wf_directory.GetRoleInfo
2989: ( role => l_receiver,
2990: display_name => l_wf_role_rec.display_name,
2991: email_address => l_wf_role_rec.email_address,
2992: notification_preference => l_wf_role_rec.notification_preference,

Line 2999: wf_directory.CreateAdHocRole

2995: );
2996:
2997: if (l_wf_role_rec.email_address is null) then
2998: --ad hoc role doesn't exist, create a new one
2999: wf_directory.CreateAdHocRole
3000: ( role_name => l_receiver,
3001: role_display_name => l_receiver,
3002: email_address => l_rec.email_address
3003: );

Line 3008: wf_directory.SetAdHocRoleAttr

3004: else
3005: --ad hoc role already exist, check for email address
3006: if (l_wf_role_rec.email_address <> l_rec.email_address) then
3007: --if the contact email address has been changed, modify the role email
3008: wf_directory.SetAdHocRoleAttr
3009: ( role_name => l_receiver,
3010: email_address => l_rec.email_address
3011: );
3012: end if;

Line 3315: l_users WF_DIRECTORY.UserTable;

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
3319: FROM AP_SUPPLIERS APS

Line 3478: WF_DIRECTORY.CreateAdHocRole2(role_name => l_role_name,

3474: from ap_suppliers
3475: where vendor_id = l_vendor_id;
3476:
3477:
3478: WF_DIRECTORY.CreateAdHocRole2(role_name => l_role_name,
3479: role_display_name => l_role_display_name,
3480: notification_preference => 'MAILHTML',
3481: role_users => l_users,
3482: expiration_date => l_expiration_date