eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERSON_NAME dependencies on HR_NAME_FORMATS

Line 6: g_format_name_cached hr_name_formats.format_name%TYPE := null;

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;
9: g_legislation_code_cached hr_name_formats.legislation_code%TYPE := null;
10: g_business_group_id_cached per_all_people_f.business_group_id%TYPE := null;

Line 7: g_format_mask_cached hr_name_formats.format_mask%TYPE := null;

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;
9: g_legislation_code_cached hr_name_formats.legislation_code%TYPE := null;
10: g_business_group_id_cached per_all_people_f.business_group_id%TYPE := null;
11: --

Line 8: g_user_format_choice_cached hr_name_formats.user_format_choice%TYPE := null;

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;
9: g_legislation_code_cached hr_name_formats.legislation_code%TYPE := null;
10: g_business_group_id_cached per_all_people_f.business_group_id%TYPE := null;
11: --
12: --

Line 9: g_legislation_code_cached hr_name_formats.legislation_code%TYPE := null;

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;
9: g_legislation_code_cached hr_name_formats.legislation_code%TYPE := null;
10: g_business_group_id_cached per_all_people_f.business_group_id%TYPE := null;
11: --
12: --
13: -- ----------------------------------------------------------------------------

Line 377: l_user_format_choice hr_name_formats.user_format_choice%TYPE;

373: l_proc CONSTANT varchar2(80) := g_package||'get_person_name';
374: --
375: l_retrieve_flag varchar2(10);
376: l_legislation_code varchar2(30);
377: l_user_format_choice hr_name_formats.user_format_choice%TYPE;
378: l_format_mask hr_name_formats.format_mask%TYPE;
379: l_person_name varchar2(240);
380: --
381: cursor csr_get_format_mask(cp_format_name varchar2

Line 378: l_format_mask hr_name_formats.format_mask%TYPE;

374: --
375: l_retrieve_flag varchar2(10);
376: l_legislation_code varchar2(30);
377: l_user_format_choice hr_name_formats.user_format_choice%TYPE;
378: l_format_mask hr_name_formats.format_mask%TYPE;
379: l_person_name varchar2(240);
380: --
381: cursor csr_get_format_mask(cp_format_name varchar2
382: ,cp_user_format_choice varchar2

Line 385: from hr_name_formats

381: cursor csr_get_format_mask(cp_format_name varchar2
382: ,cp_user_format_choice varchar2
383: ,cp_legislation_code varchar2) is
384: select format_mask
385: from hr_name_formats
386: where format_name = cp_format_name
387: and user_format_choice = cp_user_format_choice
388: and ((cp_legislation_code is not null
389: and legislation_code = cp_legislation_code)

Line 485: from hr_name_formats

481: l_valid varchar2(10);
482: --
483: cursor csr_validate_name is
484: select 'TRUE'
485: from hr_name_formats
486: where format_name = p_format_name
487: and ((p_legislation is not null and legislation_code = p_legislation)
488: or legislation_code is null);
489: --

Line 516: l_format_name hr_name_formats.format_name%TYPE;

512: p_effective_date in date default null,
513: p_format in varchar2 default null) return varchar2 is
514: --
515: l_formatted_name varchar2(240);
516: l_format_name hr_name_formats.format_name%TYPE;
517: l_legislation varchar2(30);
518: --
519: cursor csr_get_leg is
520: select bg.legislation_code

Line 834: (p_format_name hr_name_formats.format_name%TYPE,

830: -- |------------------------< derive_person_names >---------------------------|
831: -- ----------------------------------------------------------------------------
832: --
833: procedure derive_person_names
834: (p_format_name hr_name_formats.format_name%TYPE,
835: p_business_group_id per_all_people_f.business_group_id%TYPE,
836: p_person_id per_all_people_f.person_id%TYPE,
837: p_first_name per_all_people_f.first_name%TYPE,
838: p_middle_names per_all_people_f.middle_names%TYPE,

Line 920: l_format_name hr_name_formats.format_name%TYPE;

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;
924: l_GLOBAL_NAME_format_mask hr_name_formats.format_mask%TYPE;

Line 922: l_FULL_NAME_format_mask hr_name_formats.format_mask%TYPE;

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;
924: l_GLOBAL_NAME_format_mask hr_name_formats.format_mask%TYPE;
925: l_LOCAL_NAME_format_mask hr_name_formats.format_mask%TYPE;
926: l_full_name_formatted varchar2(2000);

Line 923: l_ORDER_NAME_format_mask hr_name_formats.format_mask%TYPE;

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;
924: l_GLOBAL_NAME_format_mask hr_name_formats.format_mask%TYPE;
925: l_LOCAL_NAME_format_mask hr_name_formats.format_mask%TYPE;
926: l_full_name_formatted varchar2(2000);
927: l_order_name_formatted varchar2(2000);

Line 924: l_GLOBAL_NAME_format_mask hr_name_formats.format_mask%TYPE;

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;
924: l_GLOBAL_NAME_format_mask hr_name_formats.format_mask%TYPE;
925: l_LOCAL_NAME_format_mask hr_name_formats.format_mask%TYPE;
926: l_full_name_formatted varchar2(2000);
927: l_order_name_formatted varchar2(2000);
928: l_global_name_formatted varchar2(2000);

Line 925: l_LOCAL_NAME_format_mask hr_name_formats.format_mask%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;
924: l_GLOBAL_NAME_format_mask hr_name_formats.format_mask%TYPE;
925: l_LOCAL_NAME_format_mask hr_name_formats.format_mask%TYPE;
926: l_full_name_formatted varchar2(2000);
927: l_order_name_formatted varchar2(2000);
928: l_global_name_formatted varchar2(2000);
929: l_local_name_formatted varchar2(2000);

Line 950: from HR_NAME_FORMATS nmf

946: (cp_format_name varchar2
947: ,cp_legcode varchar2
948: ,cp_user_format_choice varchar2 ) is
949: select nmf.format_mask
950: from HR_NAME_FORMATS nmf
951: where nmf.format_name = cp_format_name
952: and (cp_legcode is not null and nmf.legislation_code = cp_legcode
953: or
954: cp_legcode is null and nmf.legislation_code is null)

Line 1560: l_mask hr_name_formats.format_mask%type;

1556: --
1557: l_token_start_pos number;
1558: l_token_end_pos number;
1559: l_token fnd_lookup_values.lookup_code%type;
1560: l_mask hr_name_formats.format_mask%type;
1561: l_total number;
1562: l_count number;
1563: --
1564: begin

Line 1701: (p_format_name hr_name_formats.format_name%TYPE,

1697: -- The procedure computes the global_name and return full_name,local_name and order_name.
1698: --
1699: --
1700: procedure derive_person_names
1701: (p_format_name hr_name_formats.format_name%TYPE,
1702: p_business_group_id per_all_people_f.business_group_id%TYPE,
1703: p_first_name per_all_people_f.first_name%TYPE,
1704: p_middle_names per_all_people_f.middle_names%TYPE,
1705: p_last_name per_all_people_f.last_name%TYPE,

Line 1785: l_format_name hr_name_formats.format_name%TYPE;

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;
1789: l_GLOBAL_NAME_format_mask hr_name_formats.format_mask%TYPE;

Line 1787: l_FULL_NAME_format_mask hr_name_formats.format_mask%TYPE;

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;
1789: l_GLOBAL_NAME_format_mask hr_name_formats.format_mask%TYPE;
1790: l_LOCAL_NAME_format_mask hr_name_formats.format_mask%TYPE;
1791: l_full_name_formatted varchar2(2000);

Line 1788: l_ORDER_NAME_format_mask hr_name_formats.format_mask%TYPE;

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;
1789: l_GLOBAL_NAME_format_mask hr_name_formats.format_mask%TYPE;
1790: l_LOCAL_NAME_format_mask hr_name_formats.format_mask%TYPE;
1791: l_full_name_formatted varchar2(2000);
1792: l_order_name_formatted varchar2(2000);

Line 1789: l_GLOBAL_NAME_format_mask hr_name_formats.format_mask%TYPE;

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;
1789: l_GLOBAL_NAME_format_mask hr_name_formats.format_mask%TYPE;
1790: l_LOCAL_NAME_format_mask hr_name_formats.format_mask%TYPE;
1791: l_full_name_formatted varchar2(2000);
1792: l_order_name_formatted varchar2(2000);
1793: l_global_name_formatted varchar2(2000);

Line 1790: l_LOCAL_NAME_format_mask hr_name_formats.format_mask%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;
1789: l_GLOBAL_NAME_format_mask hr_name_formats.format_mask%TYPE;
1790: l_LOCAL_NAME_format_mask hr_name_formats.format_mask%TYPE;
1791: l_full_name_formatted varchar2(2000);
1792: l_order_name_formatted varchar2(2000);
1793: l_global_name_formatted varchar2(2000);
1794: l_local_name_formatted varchar2(2000);

Line 1815: from HR_NAME_FORMATS nmf

1811: (cp_format_name varchar2
1812: ,cp_legcode varchar2
1813: ,cp_user_format_choice varchar2 ) is
1814: select nmf.format_mask
1815: from HR_NAME_FORMATS nmf
1816: where nmf.format_name = cp_format_name
1817: and (cp_legcode is not null and nmf.legislation_code = cp_legcode
1818: or
1819: cp_legcode is null and nmf.legislation_code is null)