APPS.WF_NOTIFICATION dependencies on WF_ROLES

Line 990: -- or multiple users found in the WF_ROLES table, then convert the

986: end if;
987: found := false;
988:
989: -- Bug 8802669: If the user is not found for the given email address
990: -- or multiple users found in the WF_ROLES table, then convert the
991: -- username and displaname i.e email address here (username) to
992: -- upper case so that correct username will be used in the case where
993: -- the user name is same as email address
994: user_name := upper(l_email);

Line 1643: from WF_ROLES WR

1639: colon := instr(not_attr_row.text_value, ':');
1640: if (colon = 0) then
1641: select WR.DISPLAY_NAME
1642: into value
1643: from WF_ROLES WR
1644: where WR.NAME = not_attr_row.text_value
1645: and WR.ORIG_SYSTEM NOT IN ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
1646: 'HZ_GROUP','CUST_CONT');
1647: else

Line 1650: from WF_ROLES WR

1646: 'HZ_GROUP','CUST_CONT');
1647: else
1648: select WR.DISPLAY_NAME
1649: into value
1650: from WF_ROLES WR
1651: where WR.ORIG_SYSTEM = substr(not_attr_row.text_value, 1, colon-1)
1652: and WR.ORIG_SYSTEM_ID = substr(not_attr_row.text_value, colon+1)
1653: and WR.NAME = not_attr_row.text_value;
1654: end if;

Line 9495: -- Get recipient information using Dir Service API. Select from WF_ROLES

9491: wf_core.token('NID', to_char(p_nid));
9492: wf_core.raise('WFNTF_NID');
9493: end;
9494:
9495: -- Get recipient information using Dir Service API. Select from WF_ROLES
9496: -- may not give the right information
9497: Wf_Directory.GetRoleInfoMail(l_recipient_role, l_display_name, l_email_address,
9498: l_notification_pref, l_language, l_territory,
9499: l_orig_system, l_orig_system_id, l_installed);