1 PACKAGE IGS_PR_RU_APPL_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSQI10S.pls 115.6 2003/06/05 13:02:24 sarakshi ship $ */
3
4 PROCEDURE INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_PROGRESSION_RULE_CAT in VARCHAR2,
7 X_SEQUENCE_NUMBER in NUMBER,
8 X_S_RELATION_TYPE in VARCHAR2,
9 X_PROGRESSION_RULE_CD in VARCHAR2,
10 X_REFERENCE_CD in VARCHAR2,
11 X_RUL_SEQUENCE_NUMBER in NUMBER,
12 X_ATTENDANCE_TYPE in VARCHAR2,
13 X_OU_ORG_UNIT_CD in VARCHAR2,
14 X_OU_START_DT in DATE,
15 X_COURSE_TYPE in VARCHAR2,
16 X_CRV_COURSE_CD in VARCHAR2,
17 X_CRV_VERSION_NUMBER in NUMBER,
18 X_SCA_PERSON_ID in NUMBER,
19 X_SCA_COURSE_CD in VARCHAR2,
20 X_PRO_PROGRESSION_RULE_CAT in VARCHAR2,
21 X_PRO_PRA_SEQUENCE_NUMBER in NUMBER,
22 X_PRO_SEQUENCE_NUMBER in NUMBER,
23 X_SPO_PERSON_ID in NUMBER,
24 X_SPO_COURSE_CD in VARCHAR2,
25 X_SPO_SEQUENCE_NUMBER in NUMBER,
26 X_LOGICAL_DELETE_DT in DATE,
27 X_MESSAGE in VARCHAR2,
28 X_MODE in VARCHAR2 default 'R',
29 X_ORG_ID in NUMBER,
30 X_MIN_CP IN NUMBER DEFAULT NULL,
31 X_MAX_CP IN NUMBER DEFAULT NULL,
32 X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL
33 );
34
35 PROCEDURE LOCK_ROW (
36 X_ROWID in VARCHAR2,
37 X_PROGRESSION_RULE_CAT in VARCHAR2,
38 X_SEQUENCE_NUMBER in NUMBER,
39 X_S_RELATION_TYPE in VARCHAR2,
40 X_PROGRESSION_RULE_CD in VARCHAR2,
41 X_REFERENCE_CD in VARCHAR2,
42 X_RUL_SEQUENCE_NUMBER in NUMBER,
43 X_ATTENDANCE_TYPE in VARCHAR2,
44 X_OU_ORG_UNIT_CD in VARCHAR2,
45 X_OU_START_DT in DATE,
46 X_COURSE_TYPE in VARCHAR2,
47 X_CRV_COURSE_CD in VARCHAR2,
48 X_CRV_VERSION_NUMBER in NUMBER,
49 X_SCA_PERSON_ID in NUMBER,
50 X_SCA_COURSE_CD in VARCHAR2,
51 X_PRO_PROGRESSION_RULE_CAT in VARCHAR2,
52 X_PRO_PRA_SEQUENCE_NUMBER in NUMBER,
53 X_PRO_SEQUENCE_NUMBER in NUMBER,
54 X_SPO_PERSON_ID in NUMBER,
55 X_SPO_COURSE_CD in VARCHAR2,
56 X_SPO_SEQUENCE_NUMBER in NUMBER,
57 X_LOGICAL_DELETE_DT in DATE,
58 X_MESSAGE in VARCHAR2,
59 X_MIN_CP IN NUMBER DEFAULT NULL,
60 X_MAX_CP IN NUMBER DEFAULT NULL,
61 X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL
62 );
63
64 PROCEDURE UPDATE_ROW (
65 X_ROWID in VARCHAR2,
66 X_PROGRESSION_RULE_CAT in VARCHAR2,
67 X_SEQUENCE_NUMBER in NUMBER,
68 X_S_RELATION_TYPE in VARCHAR2,
69 X_PROGRESSION_RULE_CD in VARCHAR2,
70 X_REFERENCE_CD in VARCHAR2,
71 X_RUL_SEQUENCE_NUMBER in NUMBER,
72 X_ATTENDANCE_TYPE in VARCHAR2,
73 X_OU_ORG_UNIT_CD in VARCHAR2,
74 X_OU_START_DT in DATE,
75 X_COURSE_TYPE in VARCHAR2,
76 X_CRV_COURSE_CD in VARCHAR2,
77 X_CRV_VERSION_NUMBER in NUMBER,
78 X_SCA_PERSON_ID in NUMBER,
79 X_SCA_COURSE_CD in VARCHAR2,
80 X_PRO_PROGRESSION_RULE_CAT in VARCHAR2,
81 X_PRO_PRA_SEQUENCE_NUMBER in NUMBER,
82 X_PRO_SEQUENCE_NUMBER in NUMBER,
83 X_SPO_PERSON_ID in NUMBER,
84 X_SPO_COURSE_CD in VARCHAR2,
85 X_SPO_SEQUENCE_NUMBER in NUMBER,
86 X_LOGICAL_DELETE_DT in DATE,
87 X_MESSAGE in VARCHAR2,
88 X_MODE in VARCHAR2 default 'R',
89 X_MIN_CP IN NUMBER DEFAULT NULL,
90 X_MAX_CP IN NUMBER DEFAULT NULL,
91 X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL
92 );
93
94 PROCEDURE ADD_ROW (
95 X_ROWID in out NOCOPY VARCHAR2,
96 X_PROGRESSION_RULE_CAT in VARCHAR2,
97 X_SEQUENCE_NUMBER in NUMBER,
98 X_S_RELATION_TYPE in VARCHAR2,
99 X_PROGRESSION_RULE_CD in VARCHAR2,
100 X_REFERENCE_CD in VARCHAR2,
101 X_RUL_SEQUENCE_NUMBER in NUMBER,
102 X_ATTENDANCE_TYPE in VARCHAR2,
103 X_OU_ORG_UNIT_CD in VARCHAR2,
104 X_OU_START_DT in DATE,
105 X_COURSE_TYPE in VARCHAR2,
106 X_CRV_COURSE_CD in VARCHAR2,
107 X_CRV_VERSION_NUMBER in NUMBER,
108 X_SCA_PERSON_ID in NUMBER,
109 X_SCA_COURSE_CD in VARCHAR2,
110 X_PRO_PROGRESSION_RULE_CAT in VARCHAR2,
111 X_PRO_PRA_SEQUENCE_NUMBER in NUMBER,
112 X_PRO_SEQUENCE_NUMBER in NUMBER,
113 X_SPO_PERSON_ID in NUMBER,
114 X_SPO_COURSE_CD in VARCHAR2,
115 X_SPO_SEQUENCE_NUMBER in NUMBER,
116 X_LOGICAL_DELETE_DT in DATE,
117 X_MESSAGE in VARCHAR2,
118 X_MODE in VARCHAR2 default 'R',
119 X_ORG_ID in NUMBER,
120 X_MIN_CP IN NUMBER DEFAULT NULL,
121 X_MAX_CP IN NUMBER DEFAULT NULL,
122 X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL
123 );
124
125 PROCEDURE DELETE_ROW (
126 X_ROWID in VARCHAR2
127 );
128
129 FUNCTION Get_PK_For_Validation (
130 x_progression_rule_cat IN VARCHAR2,
131 x_sequence_number IN NUMBER
132 ) RETURN BOOLEAN;
133
134 PROCEDURE GET_FK_IGS_PR_CLASS_STD (
135 x_igs_pr_class_std_id IN NUMBER
136 );
137
138 PROCEDURE GET_FK_IGS_EN_ATD_TYPE (
139 x_attendance_type IN VARCHAR2
140 );
141
142 PROCEDURE GET_FK_IGS_PS_VER (
143 x_course_cd IN VARCHAR2,
144 x_version_number IN NUMBER
145 );
146
147 PROCEDURE GET_FK_IGS_OR_UNIT (
148 x_org_unit_cd IN VARCHAR2,
149 x_start_dt IN VARCHAR2
150 );
151
152 PROCEDURE GET_FK_IGS_PR_RU_CAT (
153 x_progression_rule_cat IN VARCHAR2
154 );
155
156 PROCEDURE GET_FK_IGS_PR_RU_OU (
157 x_progression_rule_cat IN VARCHAR2,
158 x_pra_sequence_number IN NUMBER,
159 x_sequence_number IN NUMBER
160 );
161
162 PROCEDURE GET_FK_IGS_PR_RULE (
163 x_progression_rule_cat IN VARCHAR2,
164 x_progression_rule_cd IN VARCHAR2
165 );
166
167 PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (
168 x_person_id IN VARCHAR2,
169 x_course_cd IN VARCHAR2
170 );
171
172 PROCEDURE GET_FK_IGS_PR_STDNT_PR_OU (
173 x_person_id IN VARCHAR2,
174 x_course_cd IN VARCHAR2,
175 x_sequence_number IN NUMBER
176 );
177
178 PROCEDURE Before_DML (
179 p_action IN VARCHAR2,
180 x_rowid IN VARCHAR2 DEFAULT NULL,
181 x_sca_course_cd IN VARCHAR2 DEFAULT NULL,
182 x_pro_progression_rule_cat IN VARCHAR2 DEFAULT NULL,
183 x_pro_pra_sequence_number IN NUMBER DEFAULT NULL,
184 x_pro_sequence_number IN NUMBER DEFAULT NULL,
185 x_spo_person_id IN NUMBER DEFAULT NULL,
186 x_spo_course_cd IN VARCHAR2 DEFAULT NULL,
187 x_spo_sequence_number IN NUMBER DEFAULT NULL,
188 x_logical_delete_dt IN DATE DEFAULT NULL,
189 x_message IN VARCHAR2 DEFAULT NULL,
190 x_progression_rule_cat IN VARCHAR2 DEFAULT NULL,
191 x_sequence_number IN NUMBER DEFAULT NULL,
192 x_s_relation_type IN VARCHAR2 DEFAULT NULL,
193 x_progression_rule_cd IN VARCHAR2 DEFAULT NULL,
194 x_reference_cd IN VARCHAR2 DEFAULT NULL,
195 x_rul_sequence_number IN NUMBER DEFAULT NULL,
196 x_attendance_type IN VARCHAR2 DEFAULT NULL,
197 x_ou_org_unit_cd IN VARCHAR2 DEFAULT NULL,
198 x_ou_start_dt IN DATE DEFAULT NULL,
199 x_course_type IN VARCHAR2 DEFAULT NULL,
200 x_crv_course_cd IN VARCHAR2 DEFAULT NULL,
201 x_crv_version_number IN NUMBER DEFAULT NULL,
202 x_sca_person_id IN NUMBER DEFAULT NULL,
203 x_creation_date IN DATE DEFAULT NULL,
204 x_created_by IN NUMBER DEFAULT NULL,
205 x_last_update_date IN DATE DEFAULT NULL,
206 x_last_updated_by IN NUMBER DEFAULT NULL,
207 x_last_update_login IN NUMBER DEFAULT NULL,
208 X_ORG_ID in NUMBER DEFAULT NULL,
209 X_MIN_CP IN NUMBER DEFAULT NULL,
210 X_MAX_CP IN NUMBER DEFAULT NULL,
211 X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL
212 );
213
214 PROCEDURE Check_Constraints(
215 Column_Name IN VARCHAR2 DEFAULT NULL,
216 Column_Value IN VARCHAR2 DEFAULT NULL
217 );
218
219 END IGS_PR_RU_APPL_PKG;