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.

[Home] [Help]

APPS.POS_SPM_WF_PKG1 dependencies on WF_DIRECTORY

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

81: RETURN l_function_id;
82: END get_function_id;
83:
84: -- utility to add user to a workflow adhoc role
85: -- using the new procedure wf_directory.addUserToAdHocRle2
86: PROCEDURE addusertoadhocrole
87: (p_role_name IN VARCHAR2,
88: p_user_name IN VARCHAR2)
89: IS

Line 90: l_user_table wf_directory.usertable;

86: PROCEDURE addusertoadhocrole
87: (p_role_name IN VARCHAR2,
88: p_user_name IN VARCHAR2)
89: IS
90: l_user_table wf_directory.usertable;
91: BEGIN
92: l_user_table(1) := p_user_name;
93: wf_directory.adduserstoadhocrole2(p_role_name, l_user_table);
94: END addusertoadhocrole;

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

89: IS
90: l_user_table wf_directory.usertable;
91: BEGIN
92: l_user_table(1) := p_user_name;
93: wf_directory.adduserstoadhocrole2(p_role_name, l_user_table);
94: END addusertoadhocrole;
95:
96: PROCEDURE get_enterprise_name(x_name OUT nocopy VARCHAR2)
97: IS

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

155: x_name := 'POSSPM1_' || p_process || '_' ||
156: To_char(Sysdate, 'MMDDYYYY_HH24MISS') || '_' || fnd_crypto.smallrandomnumber;
157: -- bug 3569374
158: --l_name := x_name;
159: --WHILE(wf_directory.getroledisplayname(l_name) IS NOT NULL) LOOP
160: -- l_name := x_name || '_' || l_index;
161: -- l_index := l_index + 1;
162: --END LOOP;
163: --x_name := l_name;

Line 171: wf_directory.CreateAdHocRole

167: (p_process IN VARCHAR2,
168: x_name OUT nocopy VARCHAR2) IS
169: BEGIN
170: get_adhoc_role_name(p_process,x_name);
171: wf_directory.CreateAdHocRole
172: (role_name => x_name,
173: role_display_name => x_name);
174: END create_adhoc_role;
175:

Line 1294: wf_directory.CreateAdHocUser

1290: IF l_count = 0 then
1291: FOR l_rec IN l_cur LOOP
1292: l_count := l_count + 1;
1293: l_adhoc_user := l_receiver || '_' || l_count;
1294: wf_directory.CreateAdHocUser
1295: (name => l_adhoc_user,
1296: display_name => l_rec.email_address,
1297: language => l_rec.language,
1298: territory => l_rec.nls_territory ,

Line 1310: wf_directory.CreateAdHocUser

1306: IF l_count = 0 THEN
1307: FOR l_contact_rec IN l_contact_cur LOOP
1308: l_count := l_count + 1;
1309: l_adhoc_user := l_receiver || '_' || l_count;
1310: wf_directory.CreateAdHocUser
1311: (name => l_adhoc_user,
1312: display_name => l_contact_rec.email_address,
1313: email_address => l_contact_rec.email_address
1314: );

Line 1325: l_users wf_directory.usertable;

1321:
1322: -- return Y if the role has at least one active user; otherwise N
1323: FUNCTION wfrole_has_active_user
1324: (p_role IN VARCHAR2) RETURN VARCHAR2 IS
1325: l_users wf_directory.usertable;
1326: l_username wf_users.name%TYPE;
1327: BEGIN
1328: wf_directory.GetRoleUsers(p_role, l_users);
1329: FOR l_index IN 1..l_users.COUNT LOOP

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

1324: (p_role IN VARCHAR2) RETURN VARCHAR2 IS
1325: l_users wf_directory.usertable;
1326: l_username wf_users.name%TYPE;
1327: BEGIN
1328: wf_directory.GetRoleUsers(p_role, l_users);
1329: FOR l_index IN 1..l_users.COUNT LOOP
1330: IF l_users(l_index) IS NOT NULL
1331: AND wf_directory.UserActive(l_users(l_index)) THEN
1332: RETURN 'Y';

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

1327: BEGIN
1328: wf_directory.GetRoleUsers(p_role, l_users);
1329: FOR l_index IN 1..l_users.COUNT LOOP
1330: IF l_users(l_index) IS NOT NULL
1331: AND wf_directory.UserActive(l_users(l_index)) THEN
1332: RETURN 'Y';
1333: END IF;
1334: END LOOP;
1335: RETURN 'N';

Line 1841: wf_directory.CreateAdHocUser

1837: l_process := 'PSUPPLIER_REJECTED';
1838: get_adhoc_role_name(l_process, l_receiver);
1839:
1840: l_step := 3;
1841: wf_directory.CreateAdHocUser
1842: (name => l_receiver,
1843: display_name => l_display_name,
1844: email_address => l_rec.email_address
1845: );

Line 2980: wf_directory.createadhocuser

2976: l_process := 'SEND_SUPPLIER_INVITE_REG_NTF';
2977: get_wf_item_key(l_process, p_supplier_reg_id, l_itemkey);
2978: l_receiver := l_process || '_' || p_supplier_reg_id;
2979:
2980: wf_directory.createadhocuser
2981: ( name => l_receiver,
2982: display_name => l_receiver,
2983: email_address => l_rec.email_address
2984: );

Line 3040: l_wf_role_rec wf_directory.wf_local_roles_rec_type;

3036: l_rec l_cur%ROWTYPE;
3037:
3038: l_enterprise_name hz_parties.party_name%TYPE;
3039:
3040: l_wf_role_rec wf_directory.wf_local_roles_rec_type;
3041:
3042: BEGIN
3043: OPEN l_cur;
3044: FETCH l_cur INTO l_rec;

Line 3059: wf_directory.GetRoleInfo

3055: -- bug 10112371 - changing the value of l_receiver so that it reflects supplier_name in the notification
3056: -- l_receiver := l_process || '_' || p_supplier_reg_id;
3057: l_receiver := l_rec.supplier_name;
3058:
3059: wf_directory.GetRoleInfo
3060: ( role => l_receiver,
3061: display_name => l_wf_role_rec.display_name,
3062: email_address => l_wf_role_rec.email_address,
3063: notification_preference => l_wf_role_rec.notification_preference,

Line 3070: wf_directory.CreateAdHocRole

3066: );
3067:
3068: if (l_wf_role_rec.email_address is null) then
3069: --ad hoc role doesn't exist, create a new one
3070: wf_directory.CreateAdHocRole
3071: ( role_name => l_receiver,
3072: role_display_name => l_receiver,
3073: email_address => l_rec.email_address
3074: );

Line 3079: wf_directory.SetAdHocRoleAttr

3075: else
3076: --ad hoc role already exist, check for email address
3077: if (l_wf_role_rec.email_address <> l_rec.email_address) then
3078: --if the contact email address has been changed, modify the role email
3079: wf_directory.SetAdHocRoleAttr
3080: ( role_name => l_receiver,
3081: email_address => l_rec.email_address
3082: );
3083: end if;

Line 3147: l_wf_role_rec wf_directory.wf_local_roles_rec_type;

3143: AND pcr.mapping_id = psm.mapping_id
3144: AND pcr.do_not_delete = 'Y';
3145:
3146: l_rec l_cur%ROWTYPE;
3147: l_wf_role_rec wf_directory.wf_local_roles_rec_type;
3148:
3149: BEGIN
3150:
3151: L_EMAIL_USER_COUNT:=0;

Line 3166: WF_DIRECTORY.CREATEADHOCUSER(

3162: L_ADHOC_USER:='ADHOC_USER_'||l_rec.first_name||'_'||TO_CHAR(SYSDATE, 'MMDDYYYY_HH24MISS')||FND_CRYPTO.SMALLRANDOMNUMBER;
3163: L_DISPLAY_NAME:=l_rec.last_name||','||l_rec.first_name;
3164: -- CREATING ADHOC USER
3165: --Bug 10113987 Don't need to set the NOTIFICATION_PREFERENCE here
3166: WF_DIRECTORY.CREATEADHOCUSER(
3167: NAME => L_ADHOC_USER,
3168: DISPLAY_NAME => L_DISPLAY_NAME,
3169: EMAIL_ADDRESS => l_rec.email_address
3170: );

Line 3513: l_users WF_DIRECTORY.UserTable;

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

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

3698: from ap_suppliers
3699: where vendor_id = l_vendor_id;
3700: */
3701:
3702: WF_DIRECTORY.CreateAdHocRole2(role_name => l_role_name,
3703: role_display_name => l_role_display_name,
3704: notification_preference => 'MAILHTML',
3705: role_users => l_users,
3706: expiration_date => l_expiration_date