1 package IGS_AD_TER_EDU_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSAI54S.pls 115.4 2003/06/05 13:10:36 sarakshi ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_PERSON_ID in NUMBER,
7 X_SEQUENCE_NUMBER in NUMBER,
8 X_TERTIARY_EDU_LVL_COMP in VARCHAR2,
9 X_EXCLUSION_IND in VARCHAR2,
10 X_INSTITUTION_CD in VARCHAR2,
11 X_INSTITUTION_NAME in VARCHAR2,
12 X_ENROLMENT_FIRST_YR in NUMBER,
13 X_ENROLMENT_LATEST_YR in NUMBER,
14 X_COURSE_CD in VARCHAR2,
15 X_COURSE_TITLE in VARCHAR2,
16 X_FIELD_OF_STUDY in VARCHAR2,
17 X_LANGUAGE_COMPONENT in VARCHAR2,
18 X_STUDENT_ID in VARCHAR2,
19 X_EQUIV_FULL_TIME_YRS_ENR in NUMBER,
20 X_TERTIARY_EDU_LVL_QUAL in VARCHAR2,
21 X_QUALIFICATION in VARCHAR2,
22 X_HONOURS_LEVEL in VARCHAR2,
23 X_LEVEL_OF_ACHIEVEMENT_TYPE in VARCHAR2,
24 X_GRADE_POINT_AVERAGE in NUMBER,
25 X_LANGUAGE_OF_TUITION in VARCHAR2,
26 X_STATE_CD in VARCHAR2,
27 X_COUNTRY_CD in VARCHAR2,
28 X_NOTES in VARCHAR2,
29 X_MODE in VARCHAR2 default 'R'
30 );
31 procedure LOCK_ROW (
32 X_ROWID in VARCHAR2,
33 X_PERSON_ID in NUMBER,
34 X_SEQUENCE_NUMBER in NUMBER,
35 X_TERTIARY_EDU_LVL_COMP in VARCHAR2,
36 X_EXCLUSION_IND in VARCHAR2,
37 X_INSTITUTION_CD in VARCHAR2,
38 X_INSTITUTION_NAME in VARCHAR2,
39 X_ENROLMENT_FIRST_YR in NUMBER,
40 X_ENROLMENT_LATEST_YR in NUMBER,
41 X_COURSE_CD in VARCHAR2,
42 X_COURSE_TITLE in VARCHAR2,
43 X_FIELD_OF_STUDY in VARCHAR2,
44 X_LANGUAGE_COMPONENT in VARCHAR2,
45 X_STUDENT_ID in VARCHAR2,
46 X_EQUIV_FULL_TIME_YRS_ENR in NUMBER,
47 X_TERTIARY_EDU_LVL_QUAL in VARCHAR2,
48 X_QUALIFICATION in VARCHAR2,
49 X_HONOURS_LEVEL in VARCHAR2,
50 X_LEVEL_OF_ACHIEVEMENT_TYPE in VARCHAR2,
51 X_GRADE_POINT_AVERAGE in NUMBER,
52 X_LANGUAGE_OF_TUITION in VARCHAR2,
53 X_STATE_CD in VARCHAR2,
54 X_COUNTRY_CD in VARCHAR2,
55 X_NOTES in VARCHAR2
56 );
57 procedure UPDATE_ROW (
58 X_ROWID in VARCHAR2,
59 X_PERSON_ID in NUMBER,
60 X_SEQUENCE_NUMBER in NUMBER,
61 X_TERTIARY_EDU_LVL_COMP in VARCHAR2,
62 X_EXCLUSION_IND in VARCHAR2,
63 X_INSTITUTION_CD in VARCHAR2,
64 X_INSTITUTION_NAME in VARCHAR2,
65 X_ENROLMENT_FIRST_YR in NUMBER,
66 X_ENROLMENT_LATEST_YR in NUMBER,
67 X_COURSE_CD in VARCHAR2,
68 X_COURSE_TITLE in VARCHAR2,
69 X_FIELD_OF_STUDY in VARCHAR2,
70 X_LANGUAGE_COMPONENT in VARCHAR2,
71 X_STUDENT_ID in VARCHAR2,
72 X_EQUIV_FULL_TIME_YRS_ENR in NUMBER,
73 X_TERTIARY_EDU_LVL_QUAL in VARCHAR2,
74 X_QUALIFICATION in VARCHAR2,
75 X_HONOURS_LEVEL in VARCHAR2,
76 X_LEVEL_OF_ACHIEVEMENT_TYPE in VARCHAR2,
77 X_GRADE_POINT_AVERAGE in NUMBER,
78 X_LANGUAGE_OF_TUITION in VARCHAR2,
79 X_STATE_CD in VARCHAR2,
80 X_COUNTRY_CD in VARCHAR2,
81 X_NOTES in VARCHAR2,
82 X_MODE in VARCHAR2 default 'R'
83 );
84 procedure ADD_ROW (
85 X_ROWID in out NOCOPY VARCHAR2,
86 X_PERSON_ID in NUMBER,
87 X_SEQUENCE_NUMBER in NUMBER,
88 X_TERTIARY_EDU_LVL_COMP in VARCHAR2,
89 X_EXCLUSION_IND in VARCHAR2,
90 X_INSTITUTION_CD in VARCHAR2,
91 X_INSTITUTION_NAME in VARCHAR2,
92 X_ENROLMENT_FIRST_YR in NUMBER,
93 X_ENROLMENT_LATEST_YR in NUMBER,
94 X_COURSE_CD in VARCHAR2,
95 X_COURSE_TITLE in VARCHAR2,
96 X_FIELD_OF_STUDY in VARCHAR2,
97 X_LANGUAGE_COMPONENT in VARCHAR2,
98 X_STUDENT_ID in VARCHAR2,
99 X_EQUIV_FULL_TIME_YRS_ENR in NUMBER,
100 X_TERTIARY_EDU_LVL_QUAL in VARCHAR2,
101 X_QUALIFICATION in VARCHAR2,
102 X_HONOURS_LEVEL in VARCHAR2,
103 X_LEVEL_OF_ACHIEVEMENT_TYPE in VARCHAR2,
104 X_GRADE_POINT_AVERAGE in NUMBER,
105 X_LANGUAGE_OF_TUITION in VARCHAR2,
106 X_STATE_CD in VARCHAR2,
107 X_COUNTRY_CD in VARCHAR2,
108 X_NOTES in VARCHAR2,
109 X_MODE in VARCHAR2 default 'R'
110 );
111 procedure DELETE_ROW (
112 X_ROWID in VARCHAR2
113 );
114 function Get_PK_For_Validation (
115 x_person_id IN NUMBER,
116 x_sequence_number IN NUMBER
117 )return BOOLEAN;
118
119 procedure Check_Constraints (
120 Column_Name IN VARCHAR2 DEFAULT NULL,
121 Column_Value IN VARCHAR2 DEFAULT NULL
122 );
123
124 PROCEDURE GET_FK_IGS_PE_COUNTRY_CD (
125 x_country_cd IN VARCHAR2
126 );
127
128 PROCEDURE GET_FK_IGS_GR_HONOURS_LEVEL (
129 x_honours_level IN VARCHAR2
130 );
131
132 PROCEDURE GET_FK_IGS_OR_INSTITUTION (
133 x_institution_cd IN VARCHAR2
134 );
135
136 PROCEDURE GET_FK_IGS_PE_LANGUAGE_CD (
137 x_language_cd IN VARCHAR2
138 );
139
140 PROCEDURE GET_FK_IGS_PE_PERSON (
141 x_person_id IN NUMBER
142 );
143
144 PROCEDURE GET_FK_IGS_AD_TER_EDU_LV_COM (
145 x_tertiary_edu_lvl_comp IN VARCHAR2
146 );
147
148 PROCEDURE GET_FK_IGS_AD_TER_EDU_LVL_QF (
149 x_tertiary_edu_lvl_qual IN VARCHAR2
150 );
151
152 PROCEDURE Before_DML (
153 p_action IN VARCHAR2,
154 x_rowid IN VARCHAR2 DEFAULT NULL,
155 x_person_id IN NUMBER DEFAULT NULL,
156 x_sequence_number IN NUMBER DEFAULT NULL,
157 x_tertiary_edu_lvl_comp IN VARCHAR2 DEFAULT NULL,
158 x_exclusion_ind IN VARCHAR2 DEFAULT NULL,
159 x_institution_cd IN VARCHAR2 DEFAULT NULL,
160 x_institution_name IN VARCHAR2 DEFAULT NULL,
161 x_enrolment_first_yr IN NUMBER DEFAULT NULL,
162 x_enrolment_latest_yr IN NUMBER DEFAULT NULL,
163 x_course_cd IN VARCHAR2 DEFAULT NULL,
164 x_course_title IN VARCHAR2 DEFAULT NULL,
165 x_field_of_study IN VARCHAR2 DEFAULT NULL,
166 x_language_component IN VARCHAR2 DEFAULT NULL,
167 x_student_id IN VARCHAR2 DEFAULT NULL,
168 x_equiv_full_time_yrs_enr IN NUMBER DEFAULT NULL,
169 x_tertiary_edu_lvl_qual IN VARCHAR2 DEFAULT NULL,
170 x_qualification IN VARCHAR2 DEFAULT NULL,
171 x_honours_level IN VARCHAR2 DEFAULT NULL,
172 x_level_of_achievement_type IN VARCHAR2 DEFAULT NULL,
173 x_grade_point_average IN NUMBER DEFAULT NULL,
174 x_language_of_tuition IN VARCHAR2 DEFAULT NULL,
175 x_state_cd IN VARCHAR2 DEFAULT NULL,
176 x_country_cd IN VARCHAR2 DEFAULT NULL,
177 x_notes IN VARCHAR2 DEFAULT NULL,
178 x_creation_date IN DATE DEFAULT NULL,
179 x_created_by IN NUMBER DEFAULT NULL,
180 x_last_update_date IN DATE DEFAULT NULL,
181 x_last_updated_by IN NUMBER DEFAULT NULL,
182 x_last_update_login IN NUMBER DEFAULT NULL
183 );
184
185 end IGS_AD_TER_EDU_PKG;
[Home] [Help]