1 PACKAGE IGS_AS_GEN_005 AUTHID CURRENT_USER AS
2 /* $Header: IGSAS05S.pls 120.0 2005/07/05 11:43:50 appldev noship $ */
3
4 FUNCTION assp_mnt_suaai_uap (
5 p_unit_cd IN VARCHAR2,
6 p_version_number IN NUMBER,
7 p_cal_type IN VARCHAR2,
8 p_ci_sequence_number IN NUMBER,
9 p_ass_pattern_id IN NUMBER,
10 p_location_cd IN VARCHAR2,
11 p_unit_class IN VARCHAR2,
12 p_unit_mode IN VARCHAR2,
13 p_s_log_type IN VARCHAR2,
14 p_key IN VARCHAR2,
15 p_sle_key IN OUT NOCOPY VARCHAR2,
16 p_error_count IN OUT NOCOPY NUMBER,
17 p_warning_count IN OUT NOCOPY NUMBER,
18 p_message_name OUT NOCOPY VARCHAR2
19 ) RETURN BOOLEAN;
20
21 FUNCTION assp_mnt_uapi_suaai (
22 p_person_id IN NUMBER,
23 p_course_cd IN VARCHAR2,
24 p_unit_cd IN VARCHAR2,
25 p_version_number IN NUMBER,
26 p_cal_type IN VARCHAR2,
27 p_ci_sequence_number IN NUMBER,
28 p_ass_pattern_id IN NUMBER,
29 p_location_cd IN VARCHAR2,
30 p_unit_class IN VARCHAR2,
31 p_s_log_type IN VARCHAR2,
32 p_key IN VARCHAR2,
33 p_sle_key IN VARCHAR2,
34 p_error_count IN OUT NOCOPY NUMBER,
35 p_warning_count IN OUT NOCOPY NUMBER,
36 p_message_name OUT NOCOPY VARCHAR2
37 ) RETURN BOOLEAN;
38
39 FUNCTION assp_set_suao_trans (
40 p_person_id IN NUMBER,
41 p_course_cd IN VARCHAR2,
42 p_unit_cd IN VARCHAR2,
43 p_cal_type IN VARCHAR2,
44 p_ci_sequence_number IN NUMBER,
45 p_outcome_dt IN DATE,
46 p_grade IN VARCHAR2,
47 p_grading_schema_cd IN VARCHAR2,
48 p_version_number IN NUMBER,
49 p_translated_grading_schema_cd IN OUT NOCOPY VARCHAR2,
50 p_translated_version_number IN OUT NOCOPY NUMBER,
51 p_translated_grade IN OUT NOCOPY VARCHAR2,
52 p_translated_dt IN OUT NOCOPY DATE,
53 p_message_name OUT NOCOPY VARCHAR2,
54 -- anilk, 22-Apr-2003, Bug# 2829262
55 p_uoo_id IN NUMBER
56 ) RETURN BOOLEAN;
57
58 FUNCTION assp_upd_suaai_dflt (
59 p_person_id IN NUMBER,
60 p_course_cd IN VARCHAR2,
61 p_unit_cd IN VARCHAR2,
62 p_cal_type IN VARCHAR2,
63 p_ci_sequence_number IN NUMBER,
64 p_version_number IN NUMBER,
65 p_location_cd IN VARCHAR2,
66 p_unit_class IN VARCHAR2,
67 p_unit_mode IN VARCHAR2,
68 p_s_log_type IN VARCHAR2,
69 p_key IN VARCHAR2,
70 p_sle_key IN VARCHAR2,
71 p_error_count IN OUT NOCOPY NUMBER,
72 p_warning_count IN OUT NOCOPY NUMBER,
73 p_message_name OUT NOCOPY VARCHAR2,
74 p_uoo_id IN NUMBER DEFAULT NULL
75 ) RETURN BOOLEAN;
76
77 FUNCTION assp_upd_suaap_dflt (
78 p_person_id IN NUMBER,
79 p_course_cd IN VARCHAR2,
80 p_unit_cd IN VARCHAR2,
81 p_cal_type IN VARCHAR2,
82 p_ci_sequence_number IN NUMBER,
83 p_version_number IN NUMBER,
84 p_location_cd IN VARCHAR2,
85 p_unit_class IN VARCHAR2,
86 p_s_log_type IN VARCHAR2,
87 p_key IN VARCHAR2,
88 p_sle_key IN VARCHAR2,
89 p_error_count IN OUT NOCOPY NUMBER,
90 p_warning_count IN OUT NOCOPY NUMBER,
91 p_message_name OUT NOCOPY VARCHAR2
92 ) RETURN BOOLEAN;
93
94 FUNCTION assp_upd_uai_action (p_ass_id IN igs_as_unitass_item_all.ass_id%TYPE, p_message_name OUT NOCOPY VARCHAR2)
95 RETURN BOOLEAN;
96
97 FUNCTION assp_upd_uap_uoo (
98 p_unit_cd IN VARCHAR2,
99 p_version_number IN NUMBER,
100 p_cal_type IN VARCHAR2,
101 p_ci_sequence_number IN NUMBER,
102 p_ass_pattern_id IN NUMBER,
103 p_location_cd IN VARCHAR2,
104 p_unit_class IN VARCHAR2,
105 p_unit_mode IN VARCHAR2,
106 p_call_by_db_trg IN VARCHAR2 DEFAULT 'N',
107 p_message_name OUT NOCOPY VARCHAR2
108 ) RETURN BOOLEAN;
109
110 FUNCTION assp_val_sca_comm (
111 p_person_id IN NUMBER,
112 p_course_cd IN VARCHAR2,
113 p_include_fail_grade_ind IN VARCHAR2 DEFAULT 'N',
114 p_enrolled_units_ind IN VARCHAR2 DEFAULT 'C',
115 p_exclude_research_units_ind IN VARCHAR2 DEFAULT 'N',
116 p_exclude_unit_category IN VARCHAR2,
117 p_include_related_crs_ind IN VARCHAR2 DEFAULT 'N'
118 ) RETURN VARCHAR2;
119
120 FUNCTION assp_val_sca_final (
121 p_person_id IN NUMBER,
122 p_course_cd IN VARCHAR2,
123 p_include_fail_grade_ind IN VARCHAR2 DEFAULT 'N',
124 p_enrolled_units_ind IN VARCHAR2 DEFAULT 'C',
125 p_exclude_research_units_ind IN VARCHAR2 DEFAULT 'N',
126 p_exclude_unit_category IN VARCHAR2,
127 p_include_related_crs_ind IN VARCHAR2 DEFAULT 'N'
128 ) RETURN VARCHAR2;
129
130 PRAGMA RESTRICT_REFERENCES (assp_val_sca_final, WNDS, WNPS);
131
132 FUNCTION assp_mnt_suaai_uai (
133 p_unit_cd IN VARCHAR2,
134 p_version_number IN NUMBER,
135 p_cal_type IN VARCHAR2,
136 p_ci_sequence_number IN NUMBER,
137 p_ass_id IN NUMBER,
138 p_location_cd IN VARCHAR2,
139 p_unit_class IN VARCHAR2,
140 p_unit_mode IN VARCHAR2,
141 p_s_log_type IN VARCHAR2,
142 p_key IN VARCHAR2,
143 p_sle_key IN OUT NOCOPY VARCHAR2,
144 p_error_count IN OUT NOCOPY NUMBER,
145 p_warning_count IN OUT NOCOPY NUMBER,
146 p_message_name OUT NOCOPY VARCHAR2,
147 p_ass_id_usec_unit_ind IN VARCHAR2 DEFAULT 'UNIT',
148 p_ass_item_id IN NUMBER DEFAULT NULL,
149 p_group_id IN NUMBER DEFAULT NULL,
150 p_midterm_mandatory_type_code IN VARCHAR2 DEFAULT NULL,
151 p_midterm_weight_qty IN NUMBER DEFAULT NULL,
152 p_final_mandatory_type_code IN VARCHAR2 DEFAULT NULL,
153 p_final_weight_qty IN NUMBER DEFAULT NULL,
154 p_grading_schema_cd IN VARCHAR2 DEFAULT NULL,
155 p_gs_version_number IN NUMBER DEFAULT NULL,
156 p_uoo_id IN NUMBER DEFAULT NULL
157 ) RETURN BOOLEAN;
158 --
159 -- Added by DDEY as a part of enhancement Bug # 2162831
160 --
161 FUNCTION assp_upd_usec_suaai_dflt (
162 p_person_id IN NUMBER,
163 p_course_cd IN VARCHAR2,
164 p_unit_cd IN VARCHAR2,
165 p_version_number IN NUMBER,
166 p_cal_type IN VARCHAR2,
167 p_ci_sequence_number IN NUMBER,
168 p_location_cd IN VARCHAR2,
169 p_unit_class IN VARCHAR2,
170 p_uoo_id IN NUMBER,
171 p_s_log_type IN VARCHAR2,
172 p_key IN VARCHAR2,
173 p_sle_key IN VARCHAR2,
174 p_error_count IN OUT NOCOPY NUMBER,
175 p_warning_count IN OUT NOCOPY NUMBER,
176 p_message_name OUT NOCOPY VARCHAR2
177 ) RETURN BOOLEAN;
178 --
179 END igs_as_gen_005;