476: l_msg_cnt NUMBER;
477: l_msg_data VARCHAR2(2000);
478:
479: l_formatted_lines_cnt NUMBER;
480: l_formatted_name_tbl hz_format_pub.string_tbl_type;
481:
482: BEGIN
483:
484: hz_format_pub.format_name (
480: l_formatted_name_tbl hz_format_pub.string_tbl_type;
481:
482: BEGIN
483:
484: hz_format_pub.format_name (
485: -- input parameters
486: p_person_title => p_person_rec.person_title,
487: p_person_first_name => p_person_rec.person_first_name,
488: p_person_middle_name => p_person_rec.person_middle_name,