1 PACKAGE IGS_EN_ELGBL_PERSON AS
2 /* $Header: IGSEN78S.pls 120.2 2006/09/19 12:14:56 amuthu noship $ */
3
4 ------------------------------------------------------------------------------------
5 --Created by : smanglm ( Oracle IDC)
6 --Date created: 19-JUN-2001
7 --
8 --Purpose: Created as part of the build for DLD Enrollment Setup : Eligibility and Validation
9 -- This package deals with the holds and person step validation. It has following
10 -- functions:
11 -- i) eval_deny_all_hold - Validate Deny All Enrollment Hold
12 -- one local function vald_deny_all_hold
13 -- ii) eval_person_steps - Validate Person Steps
14 -- one local function vald_person_steps
15 -- iii) eval_timeslot - Validate Time Slot - Person Level
16 -- one local function - vald_timeslot
17 --
18 --
19 --Known limitations/enhancements and/or remarks:
20 --
21 --Change History:
22 --Who When What
23 --kkillams 20-01-2003 New procedure eval_ss_deny_all_hold and get_enrl_comm_type are added,
24 -- eval_ss_deny_all_hold is a wrapper procedure to eval_deny_all_hold function
25 -- for self service purpose
26 -- get_enrl_comm_type procedure will derives the enrollment category type and
27 -- enrollment commencement type w.r.t bug 2737703
28 --rvangala 16 Jun 2005 Added parameters p_calling_obj and p_create_warning
29 -- in function eval_person_steps
30 -- amuthu 18-Sep-2006 Added new function eval_rev_sus_all_hold
31 -------------------------------------------------------------------------------------
32
33 FUNCTION eval_deny_all_hold(
34 p_person_id IN NUMBER,
35 p_person_type IN VARCHAR2,
36 p_load_calendar_type IN VARCHAR2,
37 p_load_cal_sequence_number IN NUMBER,
38 p_enrollment_category IN VARCHAR2,
39 p_comm_type IN VARCHAR2,
40 p_enrl_method IN VARCHAR2,
41 p_message OUT NOCOPY VARCHAR2
42 )
43 RETURN BOOLEAN;
44
45 FUNCTION eval_ss_rev_sus_all_hold (
46 p_person_id IN NUMBER,
47 p_course_cd IN VARCHAR2,
48 p_person_type IN VARCHAR2,
49 p_load_calendar_type IN VARCHAR2,
50 p_load_cal_sequence_number IN NUMBER,
51 p_message OUT NOCOPY VARCHAR2
52 )
53 RETURN BOOLEAN;
54
55 FUNCTION eval_person_steps (
56 p_person_id IN NUMBER,
57 p_person_type IN VARCHAR2,
58 p_load_calendar_type IN VARCHAR2,
59 p_load_cal_sequence_number IN NUMBER,
60 p_program_cd IN VARCHAR2,
61 p_program_version IN NUMBER,
62 p_enrollment_category IN VARCHAR2,
63 p_comm_type IN VARCHAR2,
64 p_enrl_method IN VARCHAR2,
65 p_message OUT NOCOPY VARCHAR2,
66 p_deny_warn OUT NOCOPY VARCHAR2,
67 p_calling_obj IN VARCHAR2 ,
68 p_create_warning IN VARCHAR2
69 )
70 RETURN BOOLEAN;
71
72 FUNCTION eval_timeslot (
73 p_person_id IN NUMBER,
74 p_person_type IN VARCHAR2,
75 p_load_calendar_type IN VARCHAR2,
76 p_load_cal_sequence_number IN NUMBER,
77 p_uoo_id IN NUMBER,
78 p_enrollment_category IN VARCHAR2,
79 p_comm_type IN VARCHAR2,
80 p_enrl_method IN VARCHAR2,
81 p_message OUT NOCOPY VARCHAR2,
82 p_notification_flag IN VARCHAR2
83 )
84 RETURN BOOLEAN;
85
86 PROCEDURE eval_ss_deny_all_hold(
87 p_person_id IN NUMBER,
88 p_person_type IN VARCHAR2,
89 p_course_cd IN VARCHAR2,
90 p_load_calendar_type IN VARCHAR2,
91 p_load_cal_sequence_number IN NUMBER,
92 p_status OUT NOCOPY VARCHAR2,
93 p_message OUT NOCOPY VARCHAR2);
94 PROCEDURE get_enrl_comm_type(
95 p_person_id IN NUMBER,
96 p_course_cd IN VARCHAR2,
97 p_cal_type IN VARCHAR2,
98 p_cal_seq_number IN NUMBER,
99 p_enrolment_cat OUT NOCOPY VARCHAR2,
100 p_commencement_type OUT NOCOPY VARCHAR2,
101 p_message OUT NOCOPY VARCHAR2
102 );
103
104
105 END IGS_EN_ELGBL_PERSON;