DBA Data[Home] [Help]

APPS.WF_XML dependencies on WF_ROLES

Line 135: l_display_name wf_roles.display_name%TYPE;

131: procedure GetRecipients(p_role in varchar2,
132: p_recipient_list in out NOCOPY WF_DIRECTORY.wf_local_roles_tbl_type)
133: is
134:
135: l_display_name wf_roles.display_name%TYPE;
136: l_description wf_roles.description%TYPE;
137: l_email_address wf_roles.email_address%TYPE;
138: l_notification_preference wf_roles.notification_preference%TYPE;
139: l_language wf_roles.language%TYPE;

Line 136: l_description wf_roles.description%TYPE;

132: p_recipient_list in out NOCOPY WF_DIRECTORY.wf_local_roles_tbl_type)
133: is
134:
135: l_display_name wf_roles.display_name%TYPE;
136: l_description wf_roles.description%TYPE;
137: l_email_address wf_roles.email_address%TYPE;
138: l_notification_preference wf_roles.notification_preference%TYPE;
139: l_language wf_roles.language%TYPE;
140: l_territory wf_roles.territory%TYPE;

Line 137: l_email_address wf_roles.email_address%TYPE;

133: is
134:
135: l_display_name wf_roles.display_name%TYPE;
136: l_description wf_roles.description%TYPE;
137: l_email_address wf_roles.email_address%TYPE;
138: l_notification_preference wf_roles.notification_preference%TYPE;
139: l_language wf_roles.language%TYPE;
140: l_territory wf_roles.territory%TYPE;
141:

Line 138: l_notification_preference wf_roles.notification_preference%TYPE;

134:
135: l_display_name wf_roles.display_name%TYPE;
136: l_description wf_roles.description%TYPE;
137: l_email_address wf_roles.email_address%TYPE;
138: l_notification_preference wf_roles.notification_preference%TYPE;
139: l_language wf_roles.language%TYPE;
140: l_territory wf_roles.territory%TYPE;
141:
142: cursor urc1(role varchar2, colon binary_integer) is

Line 139: l_language wf_roles.language%TYPE;

135: l_display_name wf_roles.display_name%TYPE;
136: l_description wf_roles.description%TYPE;
137: l_email_address wf_roles.email_address%TYPE;
138: l_notification_preference wf_roles.notification_preference%TYPE;
139: l_language wf_roles.language%TYPE;
140: l_territory wf_roles.territory%TYPE;
141:
142: cursor urc1(role varchar2, colon binary_integer) is
143: select name

Line 140: l_territory wf_roles.territory%TYPE;

136: l_description wf_roles.description%TYPE;
137: l_email_address wf_roles.email_address%TYPE;
138: l_notification_preference wf_roles.notification_preference%TYPE;
139: l_language wf_roles.language%TYPE;
140: l_territory wf_roles.territory%TYPE;
141:
142: cursor urc1(role varchar2, colon binary_integer) is
143: select name
144: from wf_users