APPS.GHR_WF_PKG dependencies on GHR_FAMILIES

Line 742: l_noa_fam_desc ghr_families.name%TYPE;

738: l_description ghr_routing_groups.description%TYPE;
739: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
740: l_to_organization_name hr_organization_units.name%TYPE;
741: l_from_organization_name hr_organization_units.name%TYPE;
742: l_noa_fam_desc ghr_families.name%TYPE;
743: l_error_msg varchar2(1200);
744: l_action_taken1 ghr_pa_routing_history.action_taken%TYPE;
745: l_creation_date ghr_pa_routing_history.creation_date%TYPE;
746: l_date_notification_sent ghr_pa_routing_history.date_notification_sent%TYPE;

Line 764: cursor csr_ghr_families is

760: status, to_position_id
761: FROM ghr_pa_requests
762: WHERE pa_request_id = p_pa_request_id;
763: --
764: cursor csr_ghr_families is
765: SELECT name
766: FROM ghr_families
767: WHERE noa_family_code = l_noa_family_code;
768: --

Line 766: FROM ghr_families

762: WHERE pa_request_id = p_pa_request_id;
763: --
764: cursor csr_ghr_families is
765: SELECT name
766: FROM ghr_families
767: WHERE noa_family_code = l_noa_family_code;
768: --
769: cursor csr_routing_groups is
770: SELECT name, description

Line 849: open csr_ghr_families;

845: l_personnel_office_id := l_pos_ei_data.poei_information3;
846: end if;
847: --
848: --
849: open csr_ghr_families;
850: fetch csr_ghr_families into l_noa_fam_desc;
851: if csr_ghr_families%notfound then
852: null;
853: -- ?? Check with ****

Line 850: fetch csr_ghr_families into l_noa_fam_desc;

846: end if;
847: --
848: --
849: open csr_ghr_families;
850: fetch csr_ghr_families into l_noa_fam_desc;
851: if csr_ghr_families%notfound then
852: null;
853: -- ?? Check with ****
854: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');

Line 851: if csr_ghr_families%notfound then

847: --
848: --
849: open csr_ghr_families;
850: fetch csr_ghr_families into l_noa_fam_desc;
851: if csr_ghr_families%notfound then
852: null;
853: -- ?? Check with ****
854: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
855: -- hr_utility.raise_error;

Line 857: close csr_ghr_families;

853: -- ?? Check with ****
854: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
855: -- hr_utility.raise_error;
856: end if;
857: close csr_ghr_families;
858: if l_noa_fam_desc is Null then
859: l_noa_fam_desc := l_noa_family_code;
860: end if;
861: --