APPS.GHR_WF_PKG dependencies on GHR_FAMILIES

Line 738: l_noa_fam_desc ghr_families.name%TYPE;

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

Line 760: cursor csr_ghr_families is

756: status, to_position_id
757: FROM ghr_pa_requests
758: WHERE pa_request_id = p_pa_request_id;
759: --
760: cursor csr_ghr_families is
761: SELECT name
762: FROM ghr_families
763: WHERE noa_family_code = l_noa_family_code;
764: --

Line 762: FROM ghr_families

758: WHERE pa_request_id = p_pa_request_id;
759: --
760: cursor csr_ghr_families is
761: SELECT name
762: FROM ghr_families
763: WHERE noa_family_code = l_noa_family_code;
764: --
765: cursor csr_routing_groups is
766: SELECT name, description

Line 845: open csr_ghr_families;

841: l_personnel_office_id := l_pos_ei_data.poei_information3;
842: end if;
843: --
844: --
845: open csr_ghr_families;
846: fetch csr_ghr_families into l_noa_fam_desc;
847: if csr_ghr_families%notfound then
848: null;
849: -- ?? Check with ****

Line 846: fetch csr_ghr_families into l_noa_fam_desc;

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

Line 847: if csr_ghr_families%notfound then

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

Line 853: close csr_ghr_families;

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