APPS.PON_FORMS_UTIL_PVT dependencies on WF_LOCAL_ROLES

Line 4328: from WF_LOCAL_ROLES

4324: into l_item_key from dual;
4325:
4326: --get sender email
4327: select email_address into l_buyer_email
4328: from WF_LOCAL_ROLES
4329: where NAME = p_from_role_name;
4330:
4331: -- get send to email from fnd_lookups
4332: select meaning, enabled_flag, start_date_active, end_date_active

Line 4356: FROM wf_local_roles

4352:
4353:
4354: SELECT COUNT(*)
4355: INTO l_count_role
4356: FROM wf_local_roles
4357: WHERE NAME = l_to_role_name;
4358:
4359: IF l_count_role = 0
4360: /*Role is not exists, create a new role*/

Line 4362: --If the sender does not exist in WF Local Roles, then create one on the fly

4358:
4359: IF l_count_role = 0
4360: /*Role is not exists, create a new role*/
4361: THEN
4362: --If the sender does not exist in WF Local Roles, then create one on the fly
4363: wf_directory.createadhocrole(role_name => l_to_role_name
4364: ,role_display_name => l_to_role_name
4365: ,role_description => l_to_role_name
4366: ,notification_preference => 'MAILTEXT'

Line 4375: FROM wf_local_roles

4371:
4372: ELSE --role already exists, check whether email has been changed
4373: SELECT EMAIL_ADDRESS, notification_preference
4374: INTO l_fed_email, l_notification_preference
4375: FROM wf_local_roles
4376: WHERE NAME = l_to_role_name;
4377:
4378: IF l_fed_email <> l_email_to or l_notification_preference <> 'MAILTEXT' THEN
4379: /*Role exists, but email address is not up to date*/