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;
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;
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'
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
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: --
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);
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';
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;
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;
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
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: --
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);
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';
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:
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
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: --
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';
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;