DBA Data[Home] [Help]

APPS.UMX_NOTIFICATION_UTIL dependencies on FND_USER

Line 31: l_requested_username fnd_user.user_name%type;

27: l_context varchar2 (30);
28: i number;
29: l_parameter_list wf_parameter_list_t := null;
30: l_event wf_event_t;
31: l_requested_username fnd_user.user_name%type;
32: l_return_status pls_integer;
33: l_registration_data wf_event_t;
34:
35: BEGIN

Line 77: -- We have to call the fnd_user_pkg.testusername api to find out

73: elsif l_context = 'APPROVAL_REQUIRED' then
74: resultout := 'COMPLETE:APPROVAL_REQUIRED';
75:
76: elsif l_context = 'APPROVAL_CONFIRMATION' then
77: -- We have to call the fnd_user_pkg.testusername api to find out
78: -- whether oid is enable. If that is the case, then we have to
79: -- send a differnet notification.
80: l_requested_username := wf_engine.getitemattrtext (itemtype => item_type,
81: itemkey => item_key,

Line 95: if (l_return_status = fnd_user_pkg.user_synched) then

91: p_name => 'TESTUSERNAME_RET_STATUS',
92: p_parameterlist => l_parameter_list);
93:
94:
95: if (l_return_status = fnd_user_pkg.user_synched) then
96: resultout := 'COMPLETE:APPROVAL_CONFIRMATION_SYNCHED';
97: else
98: resultout := 'COMPLETE:APPROVAL_CONFIRMATION';
99: end if;

Line 221: l_approver_name fnd_user.USER_NAME%TYPE;

217:
218: l_ame_transaction_type_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
219: l_ame_application_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
220: l_reg_request_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
221: l_approver_name fnd_user.USER_NAME%TYPE;
222: l_display_name wf_users.display_name%type;
223: l_next_approver ame_util.approverRecord2;
224: l_requested_for_user_id fnd_user.user_id%type;
225: l_registration_data wf_event_t;

Line 224: l_requested_for_user_id fnd_user.user_id%type;

220: l_reg_request_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
221: l_approver_name fnd_user.USER_NAME%TYPE;
222: l_display_name wf_users.display_name%type;
223: l_next_approver ame_util.approverRecord2;
224: l_requested_for_user_id fnd_user.user_id%type;
225: l_registration_data wf_event_t;
226: l_requested_for_party_id hz_parties.party_id%type;
227: l_user_role_name wf_local_roles.name%type;
228: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

Line 234: l_requester_email_address fnd_user.email_address%type;

230: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
231: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
232: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
233: l_return_status varchar2 (10);
234: l_requester_email_address fnd_user.email_address%type;
235: l_role_display_name wf_local_roles.display_name%type;
236: l_reg_service_type WF_ACTIVITY_ATTRIBUTES.text_default%type;
237:
238: l_msg_count number;

Line 245: cursor getusername (l_user_id in fnd_user.user_id%type) is

241: l_formatted_name_tbl hz_format_pub.string_tbl_type;
242: l_event wf_event_t;
243: l_status varchar2 (15);
244:
245: cursor getusername (l_user_id in fnd_user.user_id%type) is
246: select user_name
247: from fnd_user where user_id = l_user_id;
248:
249: BEGIN

Line 247: from fnd_user where user_id = l_user_id;

243: l_status varchar2 (15);
244:
245: cursor getusername (l_user_id in fnd_user.user_id%type) is
246: select user_name
247: from fnd_user where user_id = l_user_id;
248:
249: BEGIN
250:
251: if (command = 'RUN') then

Line 504: from fnd_user fu, hz_parties hzp

500: cursor get_username_from_userid (p_user_id in number) is
501: select fu.user_name, fu.email_address, hzp.Person_first_name,
502: hzp.Person_last_name, hzp.Person_middle_name, hzp.person_Name_suffix,
503: hzp.person_pre_name_adjunct
504: from fnd_user fu, hz_parties hzp
505: where fu.user_id = p_user_id
506: and hzp.party_id(+) = fu.person_party_id;
507:
508: