483: l_msg_cnt NUMBER;
484: l_msg_data VARCHAR2(2000);
485:
486: l_formatted_lines_cnt NUMBER;
487: l_formatted_name_tbl hz_format_pub.string_tbl_type;
488:
489: BEGIN
490:
491: hz_format_pub.format_name (
487: l_formatted_name_tbl hz_format_pub.string_tbl_type;
488:
489: BEGIN
490:
491: hz_format_pub.format_name (
492: -- input parameters
493: p_person_title => p_person_rec.person_title,
494: p_person_first_name => p_person_rec.person_first_name,
495: p_person_middle_name => p_person_rec.person_middle_name,