4: --
5: -- Package variables
6: --
7: --
8: g_FULL_NAME constant hr_name_formats.format_name%TYPE := 'FULL_NAME';
9: g_ORDER_NAME constant hr_name_formats.format_name%TYPE := 'ORDER_NAME';
10: g_DISPLAY_NAME constant hr_name_formats.format_name%TYPE := 'DISPLAY_NAME';
11: g_LIST_NAME constant hr_name_formats.format_name%TYPE := 'LIST_NAME';
12: --
5: -- Package variables
6: --
7: --
8: g_FULL_NAME constant hr_name_formats.format_name%TYPE := 'FULL_NAME';
9: g_ORDER_NAME constant hr_name_formats.format_name%TYPE := 'ORDER_NAME';
10: g_DISPLAY_NAME constant hr_name_formats.format_name%TYPE := 'DISPLAY_NAME';
11: g_LIST_NAME constant hr_name_formats.format_name%TYPE := 'LIST_NAME';
12: --
13: TYPE t_nameColumns_Rec IS RECORD
6: --
7: --
8: g_FULL_NAME constant hr_name_formats.format_name%TYPE := 'FULL_NAME';
9: g_ORDER_NAME constant hr_name_formats.format_name%TYPE := 'ORDER_NAME';
10: g_DISPLAY_NAME constant hr_name_formats.format_name%TYPE := 'DISPLAY_NAME';
11: g_LIST_NAME constant hr_name_formats.format_name%TYPE := 'LIST_NAME';
12: --
13: TYPE t_nameColumns_Rec IS RECORD
14: (
7: --
8: g_FULL_NAME constant hr_name_formats.format_name%TYPE := 'FULL_NAME';
9: g_ORDER_NAME constant hr_name_formats.format_name%TYPE := 'ORDER_NAME';
10: g_DISPLAY_NAME constant hr_name_formats.format_name%TYPE := 'DISPLAY_NAME';
11: g_LIST_NAME constant hr_name_formats.format_name%TYPE := 'LIST_NAME';
12: --
13: TYPE t_nameColumns_Rec IS RECORD
14: (
15: row_id rowid
137: --
138: -- Description:
139: -- This function generates a formatted name for a given person (at a given
140: -- effective date). This format could be any format already defined in
141: -- the HR_NAME_FORMATS table. In case, the function is called with an
142: -- invalid Format Name/Mask a null name is returned.
143: --
144: -- Pre Conditions:
145: -- Person exists in the system as of effective date.
151: -- table.
152: -- p_effective_date Yes date Effective date to determine
153: -- unique person row.
154: -- p_format_name Yes varchar2 Identifies format from
155: -- HR_NAME_FORMATS which will
156: -- determine the name construction.
157: -- p_user_format_choice No varchar2 User Format Choice to
158: -- identify correct format.
159: --
262: --
263: -- In Arguments:
264: -- Name Reqd Type Description
265: -- p_format_name Yes varchar2 Identifies format from
266: -- HR_NAME_FORMATS which will
267: -- determine the name
268: -- construction.
269: -- if NULL, then ALL format names
270: -- will be derived: full, order,
283: --
284: -- {End Of Comments}
285: --
286: procedure derive_person_names
287: (p_format_name hr_name_formats.format_name%TYPE,
288: p_business_group_id per_all_people_f.business_group_id%TYPE,
289: p_person_id per_all_people_f.person_id%TYPE,
290: p_first_name per_all_people_f.first_name%TYPE,
291: p_middle_names per_all_people_f.middle_names%TYPE,
368: );
369: --
370: --
371: procedure derive_person_names
372: (p_format_name hr_name_formats.format_name%TYPE,
373: p_business_group_id per_all_people_f.business_group_id%TYPE,
374: p_first_name per_all_people_f.first_name%TYPE,
375: p_middle_names per_all_people_f.middle_names%TYPE,
376: p_last_name per_all_people_f.last_name%TYPE,