DBA Data[Home] [Help]

APPS.IGS_PE_GEN_002 dependencies on IGS_PE_GEN_002

Line 1: PACKAGE BODY igs_pe_gen_002 AS

1: PACKAGE BODY igs_pe_gen_002 AS
2: /* $Header: IGSPE14B.pls 120.1 2006/01/18 22:32:51 skpandey noship $ */
3: /* Change Hisotry
4: Who When What
5: kumma 11-MAR-2003 2841566, Removed the statement close c_user from procedure Receive_External_Hold when the p_admin is passed null

Line 594: igs_pe_gen_002.apply_admin_hold

590:
591: -- initialize message variables.
592: l_message_name := NULL;
593: l_message_string := NULL;
594: igs_pe_gen_002.apply_admin_hold
595: (
596: p_person_id => l_student_rec.person_id,
597: p_encumbrance_type => l_hold_type,
598: p_start_dt => igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)),

Line 819: wf_core.context('IGS_PE_GEN_002', 'IGSPE003' , itemtype, itemkey, to_char(actid), funcmode,'ERROR');

815:
816:
817: EXCEPTION
818: WHEN OTHERS THEN
819: wf_core.context('IGS_PE_GEN_002', 'IGSPE003' , itemtype, itemkey, to_char(actid), funcmode,'ERROR');
820: RAISE ;
821: END Receive_External_Hold;
822:
823: FUNCTION get_hr_installed

Line 892: IF IGS_PE_GEN_002.GET_HR_INSTALLED = 'Y' THEN

888: WHERE person_id = cp_person_id;
889:
890: l_emplmnt_category_code igs_pe_typ_emp_cat_v.emplmnt_category_code%TYPE;
891: BEGIN
892: IF IGS_PE_GEN_002.GET_HR_INSTALLED = 'Y' THEN
893: OPEN hr_emp_cat(p_person_id);
894: FETCH hr_emp_cat INTO l_emplmnt_category_code;
895: CLOSE hr_emp_cat;
896: RETURN l_emplmnt_category_code;

Line 897: ELSIF IGS_PE_GEN_002.GET_HR_INSTALLED = 'N' THEN

893: OPEN hr_emp_cat(p_person_id);
894: FETCH hr_emp_cat INTO l_emplmnt_category_code;
895: CLOSE hr_emp_cat;
896: RETURN l_emplmnt_category_code;
897: ELSIF IGS_PE_GEN_002.GET_HR_INSTALLED = 'N' THEN
898: OPEN typ_emp_cat(p_person_id);
899: FETCH typ_emp_cat INTO l_emplmnt_category_code;
900: CLOSE typ_emp_cat;
901: RETURN l_emplmnt_category_code;

Line 905: END igs_pe_gen_002;

901: RETURN l_emplmnt_category_code;
902: END IF;
903: END get_active_emp_cat;
904:
905: END igs_pe_gen_002;