DBA Data[Home] [Help]

APPS.POS_SUPPLIER_NOTIFY_PKG dependencies on WF_DIRECTORY

Line 95: l_contact_users_tbl wf_directory.UserTable;

91: l_email_address hz_contact_points.email_address%TYPE;
92: l_user_name fnd_user.user_name%TYPE;
93: l_user_email_address fnd_user.email_address%TYPE;
94:
95: l_contact_users_tbl wf_directory.UserTable;
96: l_contact_emails_tbl wf_directory.UserTable;
97:
98: l_contact_users_role wf_roles.name%TYPE;
99: l_contact_emails_role wf_roles.name%TYPE;

Line 96: l_contact_emails_tbl wf_directory.UserTable;

92: l_user_name fnd_user.user_name%TYPE;
93: l_user_email_address fnd_user.email_address%TYPE;
94:
95: l_contact_users_tbl wf_directory.UserTable;
96: l_contact_emails_tbl wf_directory.UserTable;
97:
98: l_contact_users_role wf_roles.name%TYPE;
99: l_contact_emails_role wf_roles.name%TYPE;
100:

Line 175: WF_DIRECTORY.CreateAdHocUser(name => l_adhoc_user,

171: TO_CHAR(SYSDATE, 'MMDDYYYY_HH24MISS') ||
172: fnd_crypto.smallrandomnumber;
173: l_display_name := l_last_name || ',' || l_first_name;
174:
175: WF_DIRECTORY.CreateAdHocUser(name => l_adhoc_user,
176: display_name => l_display_name,
177: notification_preference => 'MAILTEXT',
178: email_address => l_email_address);
179:

Line 201: WF_DIRECTORY.CreateAdHocRole(role_name => l_contact_users_role,

197: l_contact_users_role := 'POS_' || l_process_user || '_USERROLE' ||
198: TO_CHAR(SYSDATE, 'MMDDYYYY_HH24MISS') || '_' ||
199: fnd_crypto.smallrandomnumber;
200:
201: WF_DIRECTORY.CreateAdHocRole(role_name => l_contact_users_role,
202: role_display_name => l_contact_users_role,
203: expiration_date => SYSDATE + 1);
204:
205: WF_DIRECTORY.AddUsersToAdHocRole2(role_name => l_contact_users_role,

Line 205: WF_DIRECTORY.AddUsersToAdHocRole2(role_name => l_contact_users_role,

201: WF_DIRECTORY.CreateAdHocRole(role_name => l_contact_users_role,
202: role_display_name => l_contact_users_role,
203: expiration_date => SYSDATE + 1);
204:
205: WF_DIRECTORY.AddUsersToAdHocRole2(role_name => l_contact_users_role,
206: role_users => l_contact_users_tbl);
207:
208: wf_process(p_process => 'SUPP_NOTIFY',
209: p_role => l_contact_users_role,

Line 223: WF_DIRECTORY.CreateAdHocRole(role_name => l_contact_emails_role,

219: l_contact_emails_role := 'POS_' || l_process_email || '_EMAILROLE' ||
220: TO_CHAR(SYSDATE, 'MMDDYYYY_HH24MISS') || '_' ||
221: fnd_crypto.smallrandomnumber;
222:
223: WF_DIRECTORY.CreateAdHocRole(role_name => l_contact_emails_role,
224: role_display_name => l_contact_emails_role,
225: expiration_date => SYSDATE + 1);
226:
227: WF_DIRECTORY.AddUsersToAdHocRole2(role_name => l_contact_emails_role,

Line 227: WF_DIRECTORY.AddUsersToAdHocRole2(role_name => l_contact_emails_role,

223: WF_DIRECTORY.CreateAdHocRole(role_name => l_contact_emails_role,
224: role_display_name => l_contact_emails_role,
225: expiration_date => SYSDATE + 1);
226:
227: WF_DIRECTORY.AddUsersToAdHocRole2(role_name => l_contact_emails_role,
228: role_users => l_contact_emails_tbl);
229:
230: wf_process(p_process => 'SUPP_NOTIFY_EMAIL',
231: p_role => l_contact_emails_role,