eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.IGS_EN_ST_SNAPSHOT_PKG

Source


1 package IGS_EN_ST_SNAPSHOT_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSEI08S.pls 115.3 2002/11/28 23:33:09 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_ESS_ID in out NOCOPY NUMBER,
6   X_SNAPSHOT_DT_TIME in DATE,
7   X_CI_CAL_TYPE in VARCHAR2,
8   X_CI_SEQUENCE_NUMBER in NUMBER,
9   X_PERSON_ID in NUMBER,
10   X_COURSE_CD in VARCHAR2,
11   X_CRV_VERSION_NUMBER in NUMBER,
12   X_UNIT_CD in VARCHAR2,
13   X_UV_VERSION_NUMBER in NUMBER,
14   X_SUA_CAL_TYPE in VARCHAR2,
15   X_SUA_CI_SEQUENCE_NUMBER in NUMBER,
16   X_TR_ORG_UNIT_CD in VARCHAR2,
17   X_TR_OU_START_DT in DATE,
18   X_DISCIPLINE_GROUP_CD in VARCHAR2,
19   X_GOVT_DISCIPLINE_GROUP_CD in VARCHAR2,
20   X_CRV_ORG_UNIT_CD in VARCHAR2,
21   X_CRV_OU_START_DT in DATE,
22   X_COURSE_TYPE in VARCHAR2,
23   X_GOVT_COURSE_TYPE in NUMBER,
24   X_COURSE_TYPE_GROUP_CD in VARCHAR2,
25   X_SCA_LOCATION_CD in VARCHAR2,
26   X_ATTENDANCE_MODE in VARCHAR2,
27   X_GOVT_ATTENDANCE_MODE in VARCHAR2,
28   X_ATTENDANCE_TYPE in VARCHAR2,
29   X_GOVT_ATTENDANCE_TYPE in VARCHAR2,
30   X_FUNDING_SOURCE in VARCHAR2,
31   X_GOVT_FUNDING_SOURCE in NUMBER,
32   X_MAJOR_COURSE in NUMBER,
33   X_COMMENCING_STUDENT_IND in VARCHAR2,
34   X_SCHOOL_LEAVER in NUMBER,
35   X_NEW_TO_HIGHER_EDUCATION in NUMBER,
36   X_SUA_LOCATION_CD in VARCHAR2,
37   X_UNIT_CLASS in VARCHAR2,
38   X_UNIT_LEVEL in VARCHAR2,
39   X_ENROLLED_DT in DATE,
40   X_DISCONTINUED_DT in DATE,
41   X_EFTSU in NUMBER,
42   X_WEFTSU in NUMBER,
43   X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
44   X_GOVT_REPORTABLE_IND in VARCHAR2,
45   X_MODE in VARCHAR2 default 'R'
46   );
47 procedure LOCK_ROW (
48   x_rowid in VARCHAR2,
49   X_ESS_ID in NUMBER,
50   X_SNAPSHOT_DT_TIME in DATE,
51   X_CI_CAL_TYPE in VARCHAR2,
52   X_CI_SEQUENCE_NUMBER in NUMBER,
53   X_PERSON_ID in NUMBER,
54   X_COURSE_CD in VARCHAR2,
55   X_CRV_VERSION_NUMBER in NUMBER,
56   X_UNIT_CD in VARCHAR2,
57   X_UV_VERSION_NUMBER in NUMBER,
58   X_SUA_CAL_TYPE in VARCHAR2,
59   X_SUA_CI_SEQUENCE_NUMBER in NUMBER,
60   X_TR_ORG_UNIT_CD in VARCHAR2,
61   X_TR_OU_START_DT in DATE,
62   X_DISCIPLINE_GROUP_CD in VARCHAR2,
63   X_GOVT_DISCIPLINE_GROUP_CD in VARCHAR2,
64   X_CRV_ORG_UNIT_CD in VARCHAR2,
65   X_CRV_OU_START_DT in DATE,
66   X_COURSE_TYPE in VARCHAR2,
67   X_GOVT_COURSE_TYPE in NUMBER,
68   X_COURSE_TYPE_GROUP_CD in VARCHAR2,
69   X_SCA_LOCATION_CD in VARCHAR2,
70   X_ATTENDANCE_MODE in VARCHAR2,
71   X_GOVT_ATTENDANCE_MODE in VARCHAR2,
72   X_ATTENDANCE_TYPE in VARCHAR2,
73   X_GOVT_ATTENDANCE_TYPE in VARCHAR2,
74   X_FUNDING_SOURCE in VARCHAR2,
75   X_GOVT_FUNDING_SOURCE in NUMBER,
76   X_MAJOR_COURSE in NUMBER,
77   X_COMMENCING_STUDENT_IND in VARCHAR2,
78   X_SCHOOL_LEAVER in NUMBER,
79   X_NEW_TO_HIGHER_EDUCATION in NUMBER,
80   X_SUA_LOCATION_CD in VARCHAR2,
81   X_UNIT_CLASS in VARCHAR2,
82   X_UNIT_LEVEL in VARCHAR2,
83   X_ENROLLED_DT in DATE,
84   X_DISCONTINUED_DT in DATE,
85   X_EFTSU in NUMBER,
86   X_WEFTSU in NUMBER,
87   X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
88   X_GOVT_REPORTABLE_IND in VARCHAR2
89 );
90 procedure UPDATE_ROW (
91   x_rowid in VARCHAR2,
92   X_ESS_ID in NUMBER,
93   X_SNAPSHOT_DT_TIME in DATE,
94   X_CI_CAL_TYPE in VARCHAR2,
95   X_CI_SEQUENCE_NUMBER in NUMBER,
96   X_PERSON_ID in NUMBER,
97   X_COURSE_CD in VARCHAR2,
98   X_CRV_VERSION_NUMBER in NUMBER,
99   X_UNIT_CD in VARCHAR2,
100   X_UV_VERSION_NUMBER in NUMBER,
101   X_SUA_CAL_TYPE in VARCHAR2,
102   X_SUA_CI_SEQUENCE_NUMBER in NUMBER,
103   X_TR_ORG_UNIT_CD in VARCHAR2,
104   X_TR_OU_START_DT in DATE,
105   X_DISCIPLINE_GROUP_CD in VARCHAR2,
106   X_GOVT_DISCIPLINE_GROUP_CD in VARCHAR2,
107   X_CRV_ORG_UNIT_CD in VARCHAR2,
108   X_CRV_OU_START_DT in DATE,
109   X_COURSE_TYPE in VARCHAR2,
110   X_GOVT_COURSE_TYPE in NUMBER,
111   X_COURSE_TYPE_GROUP_CD in VARCHAR2,
112   X_SCA_LOCATION_CD in VARCHAR2,
113   X_ATTENDANCE_MODE in VARCHAR2,
114   X_GOVT_ATTENDANCE_MODE in VARCHAR2,
115   X_ATTENDANCE_TYPE in VARCHAR2,
116   X_GOVT_ATTENDANCE_TYPE in VARCHAR2,
117   X_FUNDING_SOURCE in VARCHAR2,
118   X_GOVT_FUNDING_SOURCE in NUMBER,
119   X_MAJOR_COURSE in NUMBER,
120   X_COMMENCING_STUDENT_IND in VARCHAR2,
121   X_SCHOOL_LEAVER in NUMBER,
122   X_NEW_TO_HIGHER_EDUCATION in NUMBER,
123   X_SUA_LOCATION_CD in VARCHAR2,
124   X_UNIT_CLASS in VARCHAR2,
125   X_UNIT_LEVEL in VARCHAR2,
126   X_ENROLLED_DT in DATE,
127   X_DISCONTINUED_DT in DATE,
128   X_EFTSU in NUMBER,
129   X_WEFTSU in NUMBER,
130   X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
131   X_GOVT_REPORTABLE_IND in VARCHAR2,
132   X_MODE in VARCHAR2 default 'R'
133   );
134 procedure ADD_ROW (
135   X_ROWID in out NOCOPY VARCHAR2,
136   X_ESS_ID in out NOCOPY NUMBER,
137   X_SNAPSHOT_DT_TIME in DATE,
138   X_CI_CAL_TYPE in VARCHAR2,
139   X_CI_SEQUENCE_NUMBER in NUMBER,
140   X_PERSON_ID in NUMBER,
141   X_COURSE_CD in VARCHAR2,
142   X_CRV_VERSION_NUMBER in NUMBER,
143   X_UNIT_CD in VARCHAR2,
144   X_UV_VERSION_NUMBER in NUMBER,
145   X_SUA_CAL_TYPE in VARCHAR2,
146   X_SUA_CI_SEQUENCE_NUMBER in NUMBER,
147   X_TR_ORG_UNIT_CD in VARCHAR2,
148   X_TR_OU_START_DT in DATE,
149   X_DISCIPLINE_GROUP_CD in VARCHAR2,
150   X_GOVT_DISCIPLINE_GROUP_CD in VARCHAR2,
151   X_CRV_ORG_UNIT_CD in VARCHAR2,
152   X_CRV_OU_START_DT in DATE,
153   X_COURSE_TYPE in VARCHAR2,
154   X_GOVT_COURSE_TYPE in NUMBER,
155   X_COURSE_TYPE_GROUP_CD in VARCHAR2,
156   X_SCA_LOCATION_CD in VARCHAR2,
157   X_ATTENDANCE_MODE in VARCHAR2,
158   X_GOVT_ATTENDANCE_MODE in VARCHAR2,
159   X_ATTENDANCE_TYPE in VARCHAR2,
160   X_GOVT_ATTENDANCE_TYPE in VARCHAR2,
161   X_FUNDING_SOURCE in VARCHAR2,
162   X_GOVT_FUNDING_SOURCE in NUMBER,
163   X_MAJOR_COURSE in NUMBER,
164   X_COMMENCING_STUDENT_IND in VARCHAR2,
165   X_SCHOOL_LEAVER in NUMBER,
166   X_NEW_TO_HIGHER_EDUCATION in NUMBER,
167   X_SUA_LOCATION_CD in VARCHAR2,
168   X_UNIT_CLASS in VARCHAR2,
169   X_UNIT_LEVEL in VARCHAR2,
170   X_ENROLLED_DT in DATE,
171   X_DISCONTINUED_DT in DATE,
172   X_EFTSU in NUMBER,
173   X_WEFTSU in NUMBER,
174   X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
175   X_GOVT_REPORTABLE_IND in VARCHAR2,
176   X_MODE in VARCHAR2 default 'R'
177   );
178 procedure DELETE_ROW (
179  x_rowid in VARCHAR2
180 );
181 
182 FUNCTION Get_PK_For_Validation (
183     x_ESS_ID IN NUMBER
184     ) RETURN BOOLEAN;
185 
186 PROCEDURE GET_FK_IGS_EN_ST_SPSHT_CTL (
187     x_snapshot_dt_time IN DATE
188     );
189 
190 
191 PROCEDURE Before_DML (
192     p_action IN VARCHAR2,
193     x_rowid IN VARCHAR2 DEFAULT NULL,
194     x_ESS_ID IN NUMBER DEFAULT NULL,
195     x_govt_attendance_type IN VARCHAR2 DEFAULT NULL,
196     x_funding_source IN VARCHAR2 DEFAULT NULL,
197     x_govt_funding_source IN NUMBER DEFAULT NULL,
198     x_major_course IN NUMBER DEFAULT NULL,
199     x_commencing_student_ind IN VARCHAR2 DEFAULT NULL,
200     x_school_leaver IN NUMBER DEFAULT NULL,
201     x_new_to_higher_education IN NUMBER DEFAULT NULL,
202     x_sua_location_cd IN VARCHAR2 DEFAULT NULL,
203     x_unit_class IN VARCHAR2 DEFAULT NULL,
204     x_unit_level IN VARCHAR2 DEFAULT NULL,
205     x_enrolled_dt IN DATE DEFAULT NULL,
206     x_discontinued_dt IN DATE DEFAULT NULL,
207     x_eftsu IN NUMBER DEFAULT NULL,
208     x_weftsu IN NUMBER DEFAULT NULL,
209     x_unit_int_course_level_cd IN VARCHAR2 DEFAULT NULL,
210     x_govt_reportable_ind IN VARCHAR2 DEFAULT NULL,
211     x_snapshot_dt_time IN DATE DEFAULT NULL,
212     x_ci_cal_type IN VARCHAR2 DEFAULT NULL,
213     x_ci_sequence_number IN NUMBER DEFAULT NULL,
214     x_person_id IN NUMBER DEFAULT NULL,
215     x_course_cd IN VARCHAR2 DEFAULT NULL,
216     x_crv_version_number IN NUMBER DEFAULT NULL,
217     x_unit_cd IN VARCHAR2 DEFAULT NULL,
218     x_uv_version_number IN NUMBER DEFAULT NULL,
219     x_sua_cal_type IN VARCHAR2 DEFAULT NULL,
220     x_sua_ci_sequence_number IN NUMBER DEFAULT NULL,
221     x_tr_org_unit_cd IN VARCHAR2 DEFAULT NULL,
222     x_tr_ou_start_dt IN DATE DEFAULT NULL,
223     x_discipline_group_cd IN VARCHAR2 DEFAULT NULL,
224     x_govt_discipline_group_cd IN VARCHAR2 DEFAULT NULL,
225     x_crv_org_unit_cd IN VARCHAR2 DEFAULT NULL,
226     x_crv_ou_start_dt IN DATE DEFAULT NULL,
227     x_course_type IN VARCHAR2 DEFAULT NULL,
228     x_govt_course_type IN NUMBER DEFAULT NULL,
229     x_course_type_group_cd IN VARCHAR2 DEFAULT NULL,
230     x_sca_location_cd IN VARCHAR2 DEFAULT NULL,
231     x_attendance_mode IN VARCHAR2 DEFAULT NULL,
232     x_govt_attendance_mode IN VARCHAR2 DEFAULT NULL,
233     x_attendance_type IN VARCHAR2 DEFAULT NULL,
234     x_creation_date IN DATE DEFAULT NULL,
235     x_created_by IN NUMBER DEFAULT NULL,
236     x_last_update_date IN DATE DEFAULT NULL,
237     x_last_updated_by IN NUMBER DEFAULT NULL,
238     x_last_update_login IN NUMBER DEFAULT NULL
239   );
240 
241 end IGS_EN_ST_SNAPSHOT_PKG;