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_PS_OFR_OPT_PKG

Source


1 PACKAGE igs_ps_ofr_opt_pkg AS
2 /* $Header: IGSPI23S.pls 120.1 2005/10/04 00:36:02 appldev ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_COURSE_CD in VARCHAR2,
6   X_VERSION_NUMBER in NUMBER,
7   X_CAL_TYPE in VARCHAR2,
8   X_ATTENDANCE_MODE in VARCHAR2,
9   X_ATTENDANCE_TYPE in VARCHAR2,
10   X_LOCATION_CD in VARCHAR2,
11   X_COO_ID in NUMBER,
12   X_FORCED_LOCATION_IND in VARCHAR2,
13   X_FORCED_ATT_MODE_IND in VARCHAR2,
14   X_FORCED_ATT_TYPE_IND in VARCHAR2,
15   X_TIME_LIMITATION in NUMBER,
16   X_ENR_OFFICER_PERSON_ID in NUMBER,
17   X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
18   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
19   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
20   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
21   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
22   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
23   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
24   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
25   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
26   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
27   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
28   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
29   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
30   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
31   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
32   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
33   X_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
34   X_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
35   X_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
36   X_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
37   X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
38   X_MODE in VARCHAR2 default 'R' ,
39   X_ORG_ID IN NUMBER,
40   X_PROGRAM_LENGTH IN NUMBER DEFAULT NULL,
41   X_PROGRAM_LENGTH_MEASUREMENT IN VARCHAR2 DEFAULT NULL,
42   X_DELETE_FLAG IN VARCHAR2 DEFAULT 'N'
43   );
44 procedure LOCK_ROW (
45   X_ROWID in VARCHAR2,
46   X_COURSE_CD in VARCHAR2,
47   X_VERSION_NUMBER in NUMBER,
48   X_CAL_TYPE in VARCHAR2,
49   X_ATTENDANCE_MODE in VARCHAR2,
50   X_ATTENDANCE_TYPE in VARCHAR2,
51   X_LOCATION_CD in VARCHAR2,
52   X_COO_ID in NUMBER,
53   X_FORCED_LOCATION_IND in VARCHAR2,
54   X_FORCED_ATT_MODE_IND in VARCHAR2,
55   X_FORCED_ATT_TYPE_IND in VARCHAR2,
56   X_TIME_LIMITATION in NUMBER,
57   X_ENR_OFFICER_PERSON_ID in NUMBER,
58   X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
59   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
60   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
61   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
62   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
63   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
64   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
65   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
66   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
67   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
68   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
69   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
70   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
71   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
72   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
73   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
74   X_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
75   X_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
76   X_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
77   X_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
78   X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
79   X_PROGRAM_LENGTH IN NUMBER DEFAULT NULL,
80   X_PROGRAM_LENGTH_MEASUREMENT IN VARCHAR2 DEFAULT NULL,
81   X_DELETE_FLAG IN VARCHAR2 DEFAULT 'N'
82 );
83 procedure UPDATE_ROW (
84   X_ROWID in VARCHAR2,
85   X_COURSE_CD in VARCHAR2,
86   X_VERSION_NUMBER in NUMBER,
87   X_CAL_TYPE in VARCHAR2,
88   X_ATTENDANCE_MODE in VARCHAR2,
89   X_ATTENDANCE_TYPE in VARCHAR2,
90   X_LOCATION_CD in VARCHAR2,
91   X_COO_ID in NUMBER,
92   X_FORCED_LOCATION_IND in VARCHAR2,
93   X_FORCED_ATT_MODE_IND in VARCHAR2,
94   X_FORCED_ATT_TYPE_IND in VARCHAR2,
95   X_TIME_LIMITATION in NUMBER,
96   X_ENR_OFFICER_PERSON_ID in NUMBER,
97   X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
98   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
99   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
100   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
101   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
102   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
103   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
104   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
105   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
106   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
107   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
108   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
109   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
110   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
111   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
112   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
113   X_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
114   X_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
115   X_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
116   X_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
117   X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
118   X_MODE in VARCHAR2 default 'R',
119   X_PROGRAM_LENGTH IN NUMBER DEFAULT NULL,
120   X_PROGRAM_LENGTH_MEASUREMENT IN VARCHAR2 DEFAULT NULL,
121   X_DELETE_FLAG IN VARCHAR2 DEFAULT 'N'
122   );
123 procedure ADD_ROW (
124   X_ROWID in out NOCOPY VARCHAR2,
125   X_COURSE_CD in VARCHAR2,
126   X_VERSION_NUMBER in NUMBER,
127   X_CAL_TYPE in VARCHAR2,
128   X_ATTENDANCE_MODE in VARCHAR2,
129   X_ATTENDANCE_TYPE in VARCHAR2,
130   X_LOCATION_CD in VARCHAR2,
131   X_COO_ID in NUMBER,
132   X_FORCED_LOCATION_IND in VARCHAR2,
133   X_FORCED_ATT_MODE_IND in VARCHAR2,
134   X_FORCED_ATT_TYPE_IND in VARCHAR2,
135   X_TIME_LIMITATION in NUMBER,
136   X_ENR_OFFICER_PERSON_ID in NUMBER,
137   X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
138   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
139   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
140   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
141   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
142   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
143   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
144   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
145   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
146   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
147   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
148   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
149   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
150   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
151   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
152   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
153   X_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
154   X_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
155   X_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
156   X_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
157   X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
158   X_MODE in VARCHAR2 default 'R',
159   X_ORG_ID IN NUMBER,
160   X_PROGRAM_LENGTH IN NUMBER DEFAULT NULL,
161   X_PROGRAM_LENGTH_MEASUREMENT IN VARCHAR2 DEFAULT NULL,
162   X_DELETE_FLAG IN VARCHAR2 DEFAULT 'N'
163   );
164 procedure DELETE_ROW (
165   X_ROWID in VARCHAR2
166 );
167 
168   FUNCTION Get_PK_For_Validation (
169     x_course_cd IN VARCHAR2,
170     x_version_number IN NUMBER,
171     x_cal_type IN VARCHAR2,
172     x_location_cd IN VARCHAR2,
173     x_attendance_mode IN VARCHAR2,
174     x_attendance_type IN VARCHAR2
175     )
176   RETURN BOOLEAN;
177 
178   FUNCTION Get_UK_For_Validation (
179     x_coo_id IN NUMBER
180     )
181   RETURN BOOLEAN;
182 
183   PROCEDURE GET_FK_IGS_EN_ATD_MODE (
184     x_attendance_mode IN VARCHAR2
185     );
186 
187   PROCEDURE GET_FK_IGS_EN_ATD_TYPE (
188     x_attendance_type IN VARCHAR2
189     );
190 
191   PROCEDURE GET_FK_IGS_PS_OFR (
192     x_course_cd IN VARCHAR2,
193     x_version_number IN NUMBER,
194     x_cal_type IN VARCHAR2
195     );
196 
197   PROCEDURE GET_FK_IGS_AD_LOCATION (
198     x_location_cd IN VARCHAR2
199     );
200 
201   PROCEDURE GET_FK_IGS_PE_PERSON (
202     x_person_id IN VARCHAR2
203     );
204 
205 PROCEDURE Check_Constraints (
206     Column_Name	IN VARCHAR2	DEFAULT NULL,
207     Column_Value 	IN VARCHAR2	DEFAULT NULL
208 );
209 
210 PROCEDURE Before_DML (
211     p_action IN VARCHAR2,
212     x_rowid IN VARCHAR2 DEFAULT NULL,
213     x_course_cd IN VARCHAR2 DEFAULT NULL,
214     x_version_number IN NUMBER DEFAULT NULL,
215     x_cal_type IN VARCHAR2 DEFAULT NULL,
216     x_location_cd IN VARCHAR2 DEFAULT NULL,
217     x_attendance_mode IN VARCHAR2 DEFAULT NULL,
218     x_attendance_type IN VARCHAR2 DEFAULT NULL,
219     x_coo_id IN NUMBER DEFAULT NULL,
220     x_forced_location_ind IN VARCHAR2 DEFAULT NULL,
221     x_forced_att_mode_ind IN VARCHAR2 DEFAULT NULL,
222     x_forced_att_type_ind IN VARCHAR2 DEFAULT NULL,
223     x_time_limitation IN NUMBER DEFAULT NULL,
224     x_enr_officer_person_id IN NUMBER DEFAULT NULL,
225     X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
226     X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
227     X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
228     X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
229     X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
230     X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
231     X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
232     X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
233     X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
234     X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
235     X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
236     X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
237     X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
238     X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
239     X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
240     X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
241     X_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
242     X_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
243     X_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
244     X_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
245     X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
246     x_creation_date IN DATE DEFAULT NULL,
247     x_created_by IN NUMBER DEFAULT NULL,
248     x_last_update_date IN DATE DEFAULT NULL,
249     x_last_updated_by IN NUMBER DEFAULT NULL,
250     x_last_update_login IN NUMBER DEFAULT NULL,
251     x_org_id IN NUMBER DEFAULT NULL,
252     X_PROGRAM_LENGTH IN NUMBER DEFAULT NULL,
253     X_PROGRAM_LENGTH_MEASUREMENT IN VARCHAR2 DEFAULT NULL,
254     X_DELETE_FLAG IN VARCHAR2 DEFAULT 'N'
255   ) ;
256 
257 end IGS_PS_OFR_OPT_PKG;