1 PACKAGE igs_ss_enroll_pkg AS
2 /* $Header: IGSSS04S.pls 120.0 2005/06/01 21:52:12 appldev noship $ */
3
4 PROCEDURE insert_into_enr_cart
5 (
6 p_return_status OUT NOCOPY VARCHAR2,
7 p_msg_count OUT NOCOPY NUMBER,
8 p_msg_data OUT NOCOPY VARCHAR2,
9 p_person_id IN VARCHAR2,
10 p_cal_type IN VARCHAR2,
11 p_ci_sequence_number IN VARCHAR2,
12 p_call_number IN VARCHAR2,
13 p_org_id IN NUMBER
14 ) ;
15
16 PROCEDURE insert_into_enr_cart
17 (
18 p_return_status OUT NOCOPY VARCHAR2,
19 p_msg_count OUT NOCOPY NUMBER,
20 p_msg_data OUT NOCOPY VARCHAR2,
21 p_insert_flag OUT NOCOPY VARCHAR2,
22 p_person_id IN VARCHAR2,
23 p_cal_type IN VARCHAR2,
24 p_ci_sequence_number IN VARCHAR2,
25 p_unit_cd IN VARCHAR2,
26 p_unit_class IN VARCHAR2,
27 p_org_id IN NUMBER
28 ) ;
29
30 PROCEDURE insert_into_enr_cart
31 (
32 p_return_status OUT NOCOPY VARCHAR2,
33 p_msg_count OUT NOCOPY NUMBER,
34 p_msg_data OUT NOCOPY VARCHAR2,
35 p_person_id IN VARCHAR2,
36 p_uoo_id IN VARCHAR2,
37 p_org_id IN NUMBER
38 ) ;
39
40 PROCEDURE remove_from_shopping_cart
41 (
42 p_return_status OUT NOCOPY VARCHAR2,
43 p_msg_count OUT NOCOPY NUMBER,
44 p_msg_data OUT NOCOPY VARCHAR2,
45 p_person_id IN VARCHAR2,
46 p_uoo_id IN VARCHAR2,
47 p_course_cd IN VARCHAR2
48 ) ;
49
50 PROCEDURE insert_into_su_attempt
51 (
52 p_return_status OUT NOCOPY VARCHAR2,
53 p_msg_count OUT NOCOPY NUMBER,
54 p_msg_data OUT NOCOPY VARCHAR2,
55 p_org_id IN NUMBER,
56 p_person_id IN VARCHAR2,
57 p_course_cd IN VARCHAR2,
58 p_uoo_id IN VARCHAR2,
59 p_grading_schema IN VARCHAR2,
60 p_enrolled_cp IN VARCHAR2
61 ) ;
62
63 PROCEDURE delete_from_su_attempt
64 (
65 p_return_status OUT NOCOPY VARCHAR2,
66 p_msg_count OUT NOCOPY NUMBER,
67 p_msg_data OUT NOCOPY VARCHAR2,
68 p_org_id IN NUMBER ,
69 p_person_id IN VARCHAR2,
70 p_course_cd IN VARCHAR2,
71 p_uoo_id IN VARCHAR2
72 ) ;
73
74 FUNCTION get_Sch_disp_acad(
75 p_person_id IN NUMBER ,
76 p_program_cd IN VARCHAR2)
77 RETURN VARCHAR2;
78
79 FUNCTION get_Sch_disp_term(
80 p_person_id IN NUMBER ,
81 p_program_cd IN VARCHAR2)
82 RETURN VARCHAR2;
83
84 FUNCTION get_Sch_disp_term_st_dt(
85 p_person_id IN NUMBER ,
86 p_program_cd IN VARCHAR2)
87 RETURN DATE;
88
89 FUNCTION enrf_get_lookup_meaning(
90 p_lookup_code IN VARCHAR2,
91 p_lookup_type IN VARCHAR2)
92 RETURN VARCHAR2;
93
94 FUNCTION enrf_get_sca_trans_ind(
95 p_person_id IN NUMBER ,
96 p_source_program_cd IN VARCHAR2,
97 p_dest_program_cd IN VARCHAR2)
98 RETURN VARCHAR2;
99
100 FUNCTION enrf_get_sua_trans_ind(
101 p_person_id IN NUMBER ,
102 p_program_cd IN VARCHAR2,
103 p_uoo_id IN NUMBER )
104 RETURN VARCHAR2;
105
106 FUNCTION enrf_get_susa_trans_ind(
107 p_person_id IN NUMBER ,
108 p_program_cd IN VARCHAR2,
109 p_unit_set_cd IN VARCHAR2,
110 p_us_version_number IN NUMBER)
111 RETURN VARCHAR2;
112
113 FUNCTION get_dup_sua_src_prog(
114 p_person_id IN NUMBER,
115 p_course_cd IN VARCHAR2,
116 p_uoo_id IN NUMBER)
117 RETURN VARCHAR2;
118
119 FUNCTION enrf_get_mark_grade(
120 p_person_id IN NUMBER,
121 p_course_cd IN VARCHAR2,
122 p_uoo_id IN NUMBER,
123 p_unit_attempt_Status IN VARCHAR2)
124 RETURN VARCHAR2;
125
126 FUNCTION enrf_get_cal_desc(
127 p_cal_type IN VARCHAR2,
128 p_sequence_number IN NUMBER)
129 RETURN VARCHAR2;
130
131 FUNCTION enrf_get_acad_cal_desc(
132 p_teach_cal_type IN VARCHAR2,
133 p_teach_seqeunce_number IN NUMBER)
134 RETURN VARCHAR2;
135
136 FUNCTION enrp_get_career_drop_dup(
137 p_person_id in NUMBER ,
138 p_program_cd in VARCHAR2,
139 p_uoo_id in NUMBER)
140 RETURN VARCHAR2;
141
142
143 end igs_ss_enroll_pkg ;