APPS.UMX_PASSWORD_PVT dependencies on WF_LOCAL_ROLES

Line 6: -- 1) WF local roles

2: /* $Header: UMXVUPWB.pls 120.5.12020000.2 2012/07/18 14:34:53 avelu ship $ */
3:
4: g_itemtype wf_item_types.name%type := 'UMXUPWD';
5: -- Private function to get the email address of the active user from
6: -- 1) WF local roles
7: -- 2) FND User
8: -- 3) The first TCA party
9: procedure get_email_address (p_user_name in fnd_user.user_name%type,
10: x_role_name out nocopy varchar2,

Line 18: l_role_display_name wf_local_roles.display_name%type;

14: x_message_data out nocopy varchar2) is
15:
16: -- TCA Party declares email address as varchar2 2000, largest amount the
17: -- three schema.
18: l_role_display_name wf_local_roles.display_name%type;
19: l_language wf_local_roles.language%type;
20: l_territory wf_local_roles.territory%type;
21:
22: cursor get_fnd_email (p_user_name in fnd_user.user_name%type) is

Line 19: l_language wf_local_roles.language%type;

15:
16: -- TCA Party declares email address as varchar2 2000, largest amount the
17: -- three schema.
18: l_role_display_name wf_local_roles.display_name%type;
19: l_language wf_local_roles.language%type;
20: l_territory wf_local_roles.territory%type;
21:
22: cursor get_fnd_email (p_user_name in fnd_user.user_name%type) is
23: SELECT email_address

Line 20: l_territory wf_local_roles.territory%type;

16: -- TCA Party declares email address as varchar2 2000, largest amount the
17: -- three schema.
18: l_role_display_name wf_local_roles.display_name%type;
19: l_language wf_local_roles.language%type;
20: l_territory wf_local_roles.territory%type;
21:
22: cursor get_fnd_email (p_user_name in fnd_user.user_name%type) is
23: SELECT email_address
24: FROM fnd_user

Line 422: l_role_name wf_local_roles.name%type;

418: actid in number,
419: funcmode in varchar2,
420: resultout in out NOCOPY varchar2) is
421:
422: l_role_name wf_local_roles.name%type;
423: l_notification_preference wf_local_roles.notification_preference%type;
424: l_username fnd_user.user_name%type;
425: l_display_name varchar2(4000);
426: begin

Line 423: l_notification_preference wf_local_roles.notification_preference%type;

419: funcmode in varchar2,
420: resultout in out NOCOPY varchar2) is
421:
422: l_role_name wf_local_roles.name%type;
423: l_notification_preference wf_local_roles.notification_preference%type;
424: l_username fnd_user.user_name%type;
425: l_display_name varchar2(4000);
426: begin
427:

Line 575: l_role_name wf_local_roles.name%type;

571: x_message_data out NOCOPY varchar2) is
572:
573: l_user_name fnd_user.user_name%type := upper(p_username);
574: l_email_address varchar2(2000);
575: l_role_name wf_local_roles.name%type;
576: l_password varchar2(40);
577: l_notification_preference wf_local_roles.notification_preference%type;
578: l_result wf_item_activity_statuses.activity_result_code%type;
579: l_status wf_item_activity_statuses.activity_status%type;

Line 577: l_notification_preference wf_local_roles.notification_preference%type;

573: l_user_name fnd_user.user_name%type := upper(p_username);
574: l_email_address varchar2(2000);
575: l_role_name wf_local_roles.name%type;
576: l_password varchar2(40);
577: l_notification_preference wf_local_roles.notification_preference%type;
578: l_result wf_item_activity_statuses.activity_result_code%type;
579: l_status wf_item_activity_statuses.activity_status%type;
580: l_itemkey wf_items.item_key%type;
581: l_pwdChangeable boolean := null;

Line 783: l_role_name wf_local_roles.name%type;

779: actid in number,
780: funcmode in varchar2,
781: resultout in out NOCOPY varchar2) is
782:
783: l_role_name wf_local_roles.name%type;
784:
785: begin
786:
787: if (funcmode = 'RUN') then