64: employee`s FULL NAME for Chinese Character Set.*/
65: if l_name_CN_char ='Y' then
66: l_full_name := p_last_name||p_first_name||' '||p_title;
67: else
68: l_full_name := HR_US_UTILITY.per_us_full_name
69: (
70: p_first_name => p_first_name
71: ,p_middle_names => p_middle_names
72: ,p_last_name => p_last_name
76: ,p_pre_name_adjunct => p_pre_name_adjunct
77: );
78: end if;
79: ELSE
80: l_full_name := HR_US_UTILITY.per_us_full_name
81: (
82: p_first_name => p_first_name
83: ,p_middle_names => p_middle_names
84: ,p_last_name => p_last_name
138: THEN
139: /*Changed the order_name construction w.r.t bug 3075230*/
140: l_order_name := p_last_name||p_first_name;
141: ELSE
142: l_order_name := HR_US_UTILITY.per_us_full_name
143: (
144: p_first_name => p_first_name
145: ,p_middle_names => p_middle_names
146: ,p_last_name => p_last_name