APPS.UMX_NOTIFICATION_UTIL dependencies on HZ_FORMAT_PUB

Line 241: l_formatted_name_tbl hz_format_pub.string_tbl_type;

237:
238: l_msg_count number;
239: l_msg_data varchar2 (280);
240: l_formatted_lines_cnt number;
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

Line 362: 'Before calling hz_format_pub.format_name (' ||

358:
359: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
360: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
361: 'fnd.plsql.UMXNTFSB.getnextapprover',
362: 'Before calling hz_format_pub.format_name (' ||
363: l_person_first_name || ',' || l_person_middle_name ||
364: l_person_last_name || ',' || l_prefix ||
365: l_suffix || ')');
366: end if;

Line 368: hz_format_pub.format_name (

364: l_person_last_name || ',' || l_prefix ||
365: l_suffix || ')');
366: end if;
367:
368: hz_format_pub.format_name (
369: p_person_first_name => l_person_first_name ,
370: p_person_middle_name => l_person_middle_name,
371: p_person_last_name => l_person_last_name,
372: p_person_title => l_prefix,

Line 384: 'After calling hz_format_pub.format_name (' ||

380:
381: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
382: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
383: 'fnd.plsql.UMXNTFSB.getnextapprover',
384: 'After calling hz_format_pub.format_name (' ||
385: l_return_status || ',' || l_msg_count ||
386: l_role_display_name || ',' || l_formatted_lines_cnt || ')');
387: end if;
388:

Line 498: x_formatted_name_tbl hz_format_pub.string_tbl_type;

494: x_msg_data varchar2 (280);
495: x_formatted_name varchar2 (300);
496: x_formatted_phone varchar2 (300);
497: x_formatted_lines_cnt number;
498: x_formatted_name_tbl hz_format_pub.string_tbl_type;
499:
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,

Line 600: hz_format_pub.format_name (

596: close get_username_from_userid;
597:
598: end if;
599:
600: hz_format_pub.format_name (
601: p_person_first_name =>l_first_name ,
602: p_person_middle_name => l_middle_name,
603: p_person_last_name => l_last_name,
604: p_person_title => l_prefix,

Line 631: x_formatted_name := hz_format_pub.format_name (p_party_id => l_person_party_id);

627: p_parameterlist => l_registration_data.getParameterList);
628: if (l_person_party_id is null) then
629: x_formatted_name := l_username;
630: else
631: x_formatted_name := hz_format_pub.format_name (p_party_id => l_person_party_id);
632: end if;
633: end if;
634:
635: wf_engine.setItemattrtext (