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_DEI_BUS dependencies on HR_DOCUMENT_EXTRA_INFO

Line 32: , hr_document_extra_info dei

28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , hr_document_extra_info dei
33: , per_all_people_f ppf
34: where dei.document_extra_info_id = p_document_extra_info_id
35: and ppf.person_id = dei.person_id
36: and pbg.business_group_id = ppf.business_group_id;

Line 104: , hr_document_extra_info dei

100: --
101: cursor csr_leg_code is
102: select pbg.legislation_code
103: from per_business_groups_perf pbg
104: , hr_document_extra_info dei
105: , per_all_people_f ppf
106: where dei.document_extra_info_id = p_document_extra_info_id
107: and ppf.person_id = dei.person_id
108: and pbg.business_group_id = ppf.business_group_id;

Line 523: ,p_descflex_name => 'HR_DOCUMENT_EXTRA_INFO'

519: -- b) During insert.
520: --
521: hr_dflex_utility.ins_or_upd_descflex_attribs
522: (p_appl_short_name => 'HR'
523: ,p_descflex_name => 'HR_DOCUMENT_EXTRA_INFO'
524: ,p_attribute_category => p_rec.dei_attribute_category
525: ,p_attribute1_name => 'DEI_ATTRIBUTE1'
526: ,p_attribute1_value => p_rec.dei_attribute1
527: ,p_attribute2_name => 'DEI_ATTRIBUTE2'

Line 713: (p_document_extra_info_id in hr_document_extra_info.document_extra_info_id%type

709: --
710: -- {End Of Comments}
711: -- ----------------------------------------------------------------------------
712: procedure chk_date_from
713: (p_document_extra_info_id in hr_document_extra_info.document_extra_info_id%type
714: ,p_date_from in hr_document_extra_info.date_from%TYPE
715: ,p_date_to in hr_document_extra_info.date_to%TYPE
716: ,p_object_version_number in hr_document_extra_info.object_version_number%TYPE)
717: is

Line 714: ,p_date_from in hr_document_extra_info.date_from%TYPE

710: -- {End Of Comments}
711: -- ----------------------------------------------------------------------------
712: procedure chk_date_from
713: (p_document_extra_info_id in hr_document_extra_info.document_extra_info_id%type
714: ,p_date_from in hr_document_extra_info.date_from%TYPE
715: ,p_date_to in hr_document_extra_info.date_to%TYPE
716: ,p_object_version_number in hr_document_extra_info.object_version_number%TYPE)
717: is
718: --

Line 715: ,p_date_to in hr_document_extra_info.date_to%TYPE

711: -- ----------------------------------------------------------------------------
712: procedure chk_date_from
713: (p_document_extra_info_id in hr_document_extra_info.document_extra_info_id%type
714: ,p_date_from in hr_document_extra_info.date_from%TYPE
715: ,p_date_to in hr_document_extra_info.date_to%TYPE
716: ,p_object_version_number in hr_document_extra_info.object_version_number%TYPE)
717: is
718: --
719: l_exists varchar2(1);

Line 716: ,p_object_version_number in hr_document_extra_info.object_version_number%TYPE)

712: procedure chk_date_from
713: (p_document_extra_info_id in hr_document_extra_info.document_extra_info_id%type
714: ,p_date_from in hr_document_extra_info.date_from%TYPE
715: ,p_date_to in hr_document_extra_info.date_to%TYPE
716: ,p_object_version_number in hr_document_extra_info.object_version_number%TYPE)
717: is
718: --
719: l_exists varchar2(1);
720: l_proc varchar2(72) := g_package||'chk_date_from';

Line 751: (p_associated_column1 => 'HR_DOCUMENT_EXTRA_INFO.DATE_FROM'

747: hr_utility.set_location(' Leaving:'|| l_proc, 2);
748: exception
749: when app_exception.application_exception then
750: if hr_multi_message.exception_add
751: (p_associated_column1 => 'HR_DOCUMENT_EXTRA_INFO.DATE_FROM'
752: ,p_associated_column2 => 'HR_DOCUMENT_EXTRA_INFO.DATE_TO'
753: ) then
754: hr_utility.set_location(' Leaving:'||l_proc,3);
755: raise;

Line 752: ,p_associated_column2 => 'HR_DOCUMENT_EXTRA_INFO.DATE_TO'

748: exception
749: when app_exception.application_exception then
750: if hr_multi_message.exception_add
751: (p_associated_column1 => 'HR_DOCUMENT_EXTRA_INFO.DATE_FROM'
752: ,p_associated_column2 => 'HR_DOCUMENT_EXTRA_INFO.DATE_TO'
753: ) then
754: hr_utility.set_location(' Leaving:'||l_proc,3);
755: raise;
756: end if;

Line 792: (p_document_extra_info_id in hr_document_extra_info.document_extra_info_id%TYPE

788: --
789: -- {End Of Comments}
790: -- ----------------------------------------------------------------------------
791: procedure chk_date_to
792: (p_document_extra_info_id in hr_document_extra_info.document_extra_info_id%TYPE
793: ,p_date_from in hr_document_extra_info.date_from%TYPE
794: ,p_date_to in hr_document_extra_info.date_to%TYPE
795: ,p_object_version_number in hr_document_extra_info.object_version_number%TYPE)
796: is

Line 793: ,p_date_from in hr_document_extra_info.date_from%TYPE

789: -- {End Of Comments}
790: -- ----------------------------------------------------------------------------
791: procedure chk_date_to
792: (p_document_extra_info_id in hr_document_extra_info.document_extra_info_id%TYPE
793: ,p_date_from in hr_document_extra_info.date_from%TYPE
794: ,p_date_to in hr_document_extra_info.date_to%TYPE
795: ,p_object_version_number in hr_document_extra_info.object_version_number%TYPE)
796: is
797: --

Line 794: ,p_date_to in hr_document_extra_info.date_to%TYPE

790: -- ----------------------------------------------------------------------------
791: procedure chk_date_to
792: (p_document_extra_info_id in hr_document_extra_info.document_extra_info_id%TYPE
793: ,p_date_from in hr_document_extra_info.date_from%TYPE
794: ,p_date_to in hr_document_extra_info.date_to%TYPE
795: ,p_object_version_number in hr_document_extra_info.object_version_number%TYPE)
796: is
797: --
798: l_exists varchar2(1);

Line 795: ,p_object_version_number in hr_document_extra_info.object_version_number%TYPE)

791: procedure chk_date_to
792: (p_document_extra_info_id in hr_document_extra_info.document_extra_info_id%TYPE
793: ,p_date_from in hr_document_extra_info.date_from%TYPE
794: ,p_date_to in hr_document_extra_info.date_to%TYPE
795: ,p_object_version_number in hr_document_extra_info.object_version_number%TYPE)
796: is
797: --
798: l_exists varchar2(1);
799: l_proc varchar2(72) := g_package||'chk_date_to';

Line 874: p_document_type_id in hr_document_extra_info.document_type_id%TYPE

870: -- {End Of Comments}
871: -- ----------------------------------------------------------------------------
872: procedure chk_document_type_id
873: (
874: p_document_type_id in hr_document_extra_info.document_type_id%TYPE
875: )
876: is
877: --
878:

Line 968: (p_document_extra_info_id in hr_document_extra_info.document_extra_info_id%TYPE

964: --
965: -- {End Of Comments}
966: -- ----------------------------------------------------------------------------
967: procedure chk_person_id
968: (p_document_extra_info_id in hr_document_extra_info.document_extra_info_id%TYPE
969: ,p_object_version_number in hr_document_extra_info.object_version_number%TYPE
970: ,p_person_id in hr_document_extra_info.person_id%TYPE
971: )
972: is

Line 969: ,p_object_version_number in hr_document_extra_info.object_version_number%TYPE

965: -- {End Of Comments}
966: -- ----------------------------------------------------------------------------
967: procedure chk_person_id
968: (p_document_extra_info_id in hr_document_extra_info.document_extra_info_id%TYPE
969: ,p_object_version_number in hr_document_extra_info.object_version_number%TYPE
970: ,p_person_id in hr_document_extra_info.person_id%TYPE
971: )
972: is
973: --

Line 970: ,p_person_id in hr_document_extra_info.person_id%TYPE

966: -- ----------------------------------------------------------------------------
967: procedure chk_person_id
968: (p_document_extra_info_id in hr_document_extra_info.document_extra_info_id%TYPE
969: ,p_object_version_number in hr_document_extra_info.object_version_number%TYPE
970: ,p_person_id in hr_document_extra_info.person_id%TYPE
971: )
972: is
973: --
974: l_proc varchar2(72) := g_package||'chk_person_id';

Line 1022: (p_associated_column1 => 'HR_DOCUMENT_EXTRA_INFO.PERSON_ID'

1018:
1019: exception
1020: when app_exception.application_exception then
1021: if hr_multi_message.exception_add
1022: (p_associated_column1 => 'HR_DOCUMENT_EXTRA_INFO.PERSON_ID'
1023: ) then
1024: hr_utility.set_location(' Leaving:'||l_proc,60);
1025: raise;
1026: end if;