1 PACKAGE IGS_AS_GEN_004 AS
2 /* $Header: IGSAS04S.pls 120.0 2005/07/05 11:30:26 appldev noship $ */
3 --
4 --
5 --
6 FUNCTION assp_get_uap_cd (
7 p_ass_pattern_id IN NUMBER
8 ) RETURN VARCHAR2;
9
10 PRAGMA RESTRICT_REFERENCES (assp_get_uap_cd, WNDS);
11
12 FUNCTION assp_ins_dflt_evsa (
13 p_venue_cd IN VARCHAR2,
14 p_exam_cal_type IN VARCHAR2,
15 p_exam_ci_sequence_number IN NUMBER,
16 p_message_name OUT NOCOPY VARCHAR2
17 ) RETURN BOOLEAN;
18
19 FUNCTION assp_ins_get (
20 p_keying_who IN VARCHAR2,
21 p_sheet_number IN NUMBER,
22 p_cal_type IN VARCHAR2,
23 p_sequence_number IN NUMBER,
24 p_unit_cd IN VARCHAR2,
25 p_location_cd IN VARCHAR2,
26 p_unit_mode IN VARCHAR2,
27 p_unit_class IN VARCHAR2,
28 p_include_discont_ind IN VARCHAR2,
29 p_sort_by IN VARCHAR2,
30 p_keying_time OUT NOCOPY DATE
31 ) RETURN BOOLEAN;
32
33 FUNCTION assp_ins_mark_sheet (
34 p_assess_cal_type IN VARCHAR2,
35 p_assess_sequence_number IN NUMBER,
36 p_teach_cal_type IN VARCHAR2,
37 p_teach_sequence_number IN NUMBER,
38 p_unit_org_unit_cd IN VARCHAR2,
39 p_unit_cd IN VARCHAR2,
40 p_location_cd IN VARCHAR2,
41 p_unit_mode IN VARCHAR2,
42 p_include_discont_ind IN VARCHAR2,
43 p_sort_by IN VARCHAR2,
44 p_group_sequence_number OUT NOCOPY NUMBER,
45 p_grading_period_cd IN VARCHAR2,
46 p_unit_class IN VARCHAR2,
47 p_call_number IN NUMBER
48 ) RETURN BOOLEAN;
49
50 FUNCTION assp_ins_scap_lovall (
51 p_person_id IN igs_as_spl_cons_appl.person_id%TYPE,
52 p_course_cd IN igs_as_spl_cons_appl.course_cd%TYPE,
53 p_unit_cd IN igs_as_spl_cons_appl.unit_cd%TYPE,
54 p_cal_type IN igs_as_spl_cons_appl.cal_type%TYPE,
55 p_ci_sequence_number IN NUMBER,
56 p_received_dt IN DATE,
57 p_spcl_consideration_cat IN VARCHAR2,
58 p_estimated_processing_days IN NUMBER,
59 p_sought_outcome IN VARCHAR2,
60 p_message_name OUT NOCOPY VARCHAR2,
61 -- anilk, 22-Apr-2003, Bug# 2829262
62 p_uoo_id IN NUMBER,
63 /*ijeddy, 19-June-2003 2884615*/
64 p_notified_date IN DATE
65 ) RETURN BOOLEAN;
66
67 FUNCTION assp_ins_suaai_dflt (
68 p_person_id IN NUMBER,
69 p_course_cd IN VARCHAR2,
70 p_unit_cd IN VARCHAR2,
71 p_version_number IN NUMBER,
72 p_cal_type IN VARCHAR2,
73 p_ci_sequence_number IN NUMBER,
74 p_location_cd IN VARCHAR2,
75 p_unit_class IN VARCHAR2,
76 p_ass_id IN NUMBER,
77 p_ass_pattern_id IN NUMBER,
78 p_ass_id_usec_unit_ind IN VARCHAR2 DEFAULT 'UNIT', -- Added by DDEY as a part of enhancement Bug # 2162831
79 p_creation_dt IN DATE,
80 p_s_log_type IN VARCHAR2,
81 p_key IN VARCHAR2,
82 p_sle_key IN VARCHAR2,
83 p_error_count IN OUT NOCOPY NUMBER,
84 p_warning_count IN OUT NOCOPY NUMBER,
85 p_message_name OUT NOCOPY VARCHAR2,
86 p_ass_item_id IN NUMBER DEFAULT NULL,
87 p_group_id IN NUMBER DEFAULT NULL,
88 p_midterm_mandatory_type_code IN VARCHAR2 DEFAULT NULL,
89 p_midterm_weight_qty IN NUMBER DEFAULT NULL,
90 p_final_mandatory_type_code IN VARCHAR2 DEFAULT NULL,
91 p_final_weight_qty IN NUMBER DEFAULT NULL,
92 p_grading_schema_cd IN VARCHAR2 DEFAULT NULL,
93 p_gs_version_number IN NUMBER DEFAULT NULL,
94 p_uoo_id IN NUMBER DEFAULT NULL
95 ) RETURN BOOLEAN;
96
97 FUNCTION assp_ins_suaap_dflt (
98 p_person_id IN NUMBER,
99 p_course_cd IN VARCHAR2,
100 p_unit_cd IN VARCHAR2,
101 p_version_number IN NUMBER,
102 p_cal_type IN VARCHAR2,
103 p_ci_sequence_number IN NUMBER,
104 p_location_cd IN VARCHAR2,
105 p_unit_class IN VARCHAR2,
106 p_ass_pattern_id IN NUMBER,
107 p_s_log_type IN VARCHAR2,
108 p_key IN VARCHAR2,
109 p_sle_key IN VARCHAR2,
110 p_error_count IN OUT NOCOPY NUMBER,
111 p_warning_count IN OUT NOCOPY NUMBER,
112 p_message_name OUT NOCOPY VARCHAR2
113 ) RETURN BOOLEAN;
114
115 FUNCTION assp_ins_suaap_suaai (
116 p_person_id IN NUMBER,
117 p_course_cd IN VARCHAR2,
118 p_unit_cd IN VARCHAR2,
119 p_version_number IN NUMBER,
120 p_cal_type IN VARCHAR2,
121 p_ci_sequence_number IN NUMBER,
122 p_ass_pattern_id IN NUMBER,
123 p_creation_dt IN DATE,
124 p_s_default_ind IN VARCHAR2 DEFAULT 'N',
125 p_call_from_db_trg IN VARCHAR2 DEFAULT 'N',
126 p_message_name OUT NOCOPY VARCHAR2,
127 -- anilk, 22-Apr-2003, Bug# 2829262
128 p_uoo_id IN NUMBER
129 ) RETURN BOOLEAN;
130
131 FUNCTION assp_ins_transcript (
132 p_course_org_unit_cd IN VARCHAR2,
133 p_course_group_cd IN VARCHAR2,
134 p_course_cd IN VARCHAR2,
135 p_course_location_cd IN VARCHAR2,
136 p_course_attendance_mode IN VARCHAR2,
137 p_course_award IN VARCHAR2 DEFAULT 'BOTH',
138 p_course_attempt_status IN VARCHAR2,
139 p_progression_status IN VARCHAR2,
140 p_graduand_status IN VARCHAR2,
141 p_person_id_group IN NUMBER,
142 p_person_id IN NUMBER,
143 p_transcript_type IN VARCHAR2,
144 p_include_fail_grades_ind IN VARCHAR2 DEFAULT 'N',
145 p_enrolled_units_ind IN VARCHAR2 DEFAULT 'C',
146 p_exclude_research_units_ind IN VARCHAR2 DEFAULT 'N',
147 p_exclude_unit_category IN VARCHAR2,
148 p_extract_course_cd IN VARCHAR2,
149 p_include_related_crs_ind IN VARCHAR2 DEFAULT 'N',
150 p_order_by IN VARCHAR2 DEFAULT 'YEAR',
151 p_external_order_by IN VARCHAR2 DEFAULT 'SURNAME',
152 p_correspondence_ind IN VARCHAR2 DEFAULT 'N',
153 p_message_name OUT NOCOPY VARCHAR2,
154 p_reference_number OUT NOCOPY NUMBER
155 ) RETURN BOOLEAN;
156
157 FUNCTION assp_get_uapi_ap (
158 p_ass_pattern_id IN NUMBER,
159 p_ass_id IN NUMBER
160 ) RETURN NUMBER;
161
162 PRAGMA RESTRICT_REFERENCES (assp_get_uapi_ap, WNDS, WNDS);
163
164 PROCEDURE asss_ins_transcript (
165 errbuf OUT NOCOPY VARCHAR2,
166 retcode OUT NOCOPY NUMBER,
167 p_course_org_unit_cd IN VARCHAR2,
168 p_course_group_cd IN VARCHAR2,
169 p_course_cd IN VARCHAR2,
170 p_course_location_cd IN VARCHAR2,
171 p_course_attendance_mode IN VARCHAR2,
172 p_course_award IN VARCHAR2 DEFAULT 'BOTH',
173 p_course_attempt_status IN VARCHAR2,
174 p_progression_status IN VARCHAR2,
175 p_graduand_status IN VARCHAR2,
176 p_person_id_group IN NUMBER,
177 p_person_id IN NUMBER,
178 p_transcript_type IN VARCHAR2,
179 p_include_fail_grades_ind IN VARCHAR2 DEFAULT 'N',
180 p_enrolled_units_ind IN VARCHAR2 DEFAULT 'C',
181 p_exclude_research_units_ind IN VARCHAR2 DEFAULT 'N',
182 p_exclude_unit_category IN VARCHAR2,
183 p_extract_course_cd IN VARCHAR2,
184 p_include_related_crs_ind IN VARCHAR2 DEFAULT 'N',
185 p_order_by IN VARCHAR2 DEFAULT 'YEAR',
186 p_external_order_by IN VARCHAR2 DEFAULT 'SURNAME',
187 p_correspondence_ind IN VARCHAR2 DEFAULT 'N',
188 p_org_id IN NUMBER
189 );
190
191 END igs_as_gen_004;