APPS.HR_PERSON_NAME dependencies on HR_PERSON_NAME

Line 1: package body hr_person_name as

1: package body hr_person_name as
2: /* $Header: pepernam.pkb 120.6 2012/02/01 09:30:31 ktithy ship $ */
3: --
4: g_package CONSTANT varchar2(30) := 'hr_person_name.';
5: --

Line 4: g_package CONSTANT varchar2(30) := 'hr_person_name.';

1: package body hr_person_name as
2: /* $Header: pepernam.pkb 120.6 2012/02/01 09:30:31 ktithy ship $ */
3: --
4: g_package CONSTANT varchar2(30) := 'hr_person_name.';
5: --
6: g_format_name_cached hr_name_formats.format_name%TYPE := null;
7: g_format_mask_cached hr_name_formats.format_mask%TYPE := null;
8: g_user_format_choice_cached hr_name_formats.user_format_choice%TYPE := null;

Line 44: ,p_person_columns in hr_person_name.t_nameColumns_Rec

40: -- |-----------------------< get_token_value >--------------------------------|
41: -- ----------------------------------------------------------------------------
42: --
43: procedure get_token_value(p_token in varchar2
44: ,p_person_columns in hr_person_name.t_nameColumns_Rec
45: ,p_value out nocopy varchar2) is
46: --
47: l_value varchar2(240);
48: --

Line 147: procedure get_formatted_name(p_name_values in hr_person_name.t_nameColumns_Rec

143: -- ----------------------------------------------------------------------------
144: -- |---------------------< get_formatted_name >-------------------------------|
145: -- ----------------------------------------------------------------------------
146: --
147: procedure get_formatted_name(p_name_values in hr_person_name.t_nameColumns_Rec
148: ,p_formatted_name in out nocopy varchar2) is
149: --
150: l_formatted_name varchar2(2000);
151: l_token_start_pos number;

Line 247: l_person_names_rec hr_person_name.t_nameColumns_Rec;

243: return varchar2 is
244: --
245: l_proc CONSTANT varchar2(80) := g_package||'get_person_name_internal';
246: --
247: l_person_names_rec hr_person_name.t_nameColumns_Rec;
248: l_formatted_name varchar2(2000);
249: --
250: cursor csr_get_name_columns is
251: select rowid row_id

Line 736: ,p_name_column_rec IN hr_person_name.t_nameColumns_Rec

732: --
733: procedure derive_name_using_seeded_proc
734: (p_format_name IN varchar2
735: ,p_legislation_code IN varchar2
736: ,p_name_column_rec IN hr_person_name.t_nameColumns_Rec
737: ,p_package_name IN varchar2 default NULL
738: ,p_procedure_name IN varchar2 default NULL
739: ,p_formatted_name OUT nocopy varchar2
740: ) is

Line 919: l_person_names_rec hr_person_name.t_nameColumns_Rec;

915: ) is
916: --
917: l_proc CONSTANT varchar2(80) := g_package||'get_derive_person_names';
918: --
919: l_person_names_rec hr_person_name.t_nameColumns_Rec;
920: l_format_name hr_name_formats.format_name%TYPE;
921: l_legislation_code varchar2(30);
922: l_FULL_NAME_format_mask hr_name_formats.format_mask%TYPE;
923: l_ORDER_NAME_format_mask hr_name_formats.format_mask%TYPE;

Line 1332: (p_person_names_rec in hr_person_name.t_nameColumns_Rec

1328: -- ----------------------------------------------------------------------------
1329: -- Used within Conc Program
1330: --
1331: FUNCTION derive_formatted_name
1332: (p_person_names_rec in hr_person_name.t_nameColumns_Rec
1333: ,p_format_name in varchar2
1334: ,p_legislation_code in varchar2
1335: ,p_format_mask in varchar2
1336: ,p_seeded_pkg in varchar2 default NULL

Line 1784: l_person_names_rec hr_person_name.t_nameColumns_Rec;

1780: ) is
1781: --
1782: l_proc CONSTANT varchar2(80) := g_package||'get_derive_person_names';
1783: --
1784: l_person_names_rec hr_person_name.t_nameColumns_Rec;
1785: l_format_name hr_name_formats.format_name%TYPE;
1786: l_legislation_code varchar2(30);
1787: l_FULL_NAME_format_mask hr_name_formats.format_mask%TYPE;
1788: l_ORDER_NAME_format_mask hr_name_formats.format_mask%TYPE;

Line 2113: end hr_person_name;

2109: p_global_name := l_global_name_formatted;
2110: p_local_name := l_local_name_formatted;
2111: end derive_person_names;
2112: --
2113: end hr_person_name;
2114: --