2: /* $Header: UMXVUPWB.pls 120.5 2006/07/20 23:56:53 kching noship $ */
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,
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
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
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
411: actid in number,
412: funcmode in varchar2,
413: resultout in out NOCOPY varchar2) is
414:
415: l_role_name wf_local_roles.name%type;
416: l_notification_preference wf_local_roles.notification_preference%type;
417: l_username fnd_user.user_name%type;
418: l_display_name varchar2(4000);
419: begin
412: funcmode in varchar2,
413: resultout in out NOCOPY varchar2) is
414:
415: l_role_name wf_local_roles.name%type;
416: l_notification_preference wf_local_roles.notification_preference%type;
417: l_username fnd_user.user_name%type;
418: l_display_name varchar2(4000);
419: begin
420:
554: x_message_data out NOCOPY varchar2) is
555:
556: l_user_name fnd_user.user_name%type := upper(p_username);
557: l_email_address varchar2(2000);
558: l_role_name wf_local_roles.name%type;
559: l_password varchar2(40);
560: l_notification_preference wf_local_roles.notification_preference%type;
561: l_result wf_item_activity_statuses.activity_result_code%type;
562: l_status wf_item_activity_statuses.activity_status%type;
556: l_user_name fnd_user.user_name%type := upper(p_username);
557: l_email_address varchar2(2000);
558: l_role_name wf_local_roles.name%type;
559: l_password varchar2(40);
560: l_notification_preference wf_local_roles.notification_preference%type;
561: l_result wf_item_activity_statuses.activity_result_code%type;
562: l_status wf_item_activity_statuses.activity_status%type;
563: l_itemkey wf_items.item_key%type;
564: l_pwdChangeable boolean := null;
755: actid in number,
756: funcmode in varchar2,
757: resultout in out NOCOPY varchar2) is
758:
759: l_role_name wf_local_roles.name%type;
760:
761: begin
762:
763: if (funcmode = 'RUN') then