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_STDNT_PS_INTM_PKG

Source


1 package  IGS_EN_STDNT_PS_INTM_PKG AS
2 /* $Header: IGSEI18S.pls 120.1 2006/04/13 01:30:10 smaddali noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_PERSON_ID in NUMBER,
6   X_COURSE_CD in VARCHAR2,
7   X_START_DT in DATE,
8   X_LOGICAL_DELETE_DATE in DATE,
9   X_END_DT in DATE,
10   X_VOLUNTARY_IND in VARCHAR2,
11   X_COMMENTS in VARCHAR2,
12   X_INTERMISSION_TYPE in VARCHAR2 DEFAULT NULL,
13   X_APPROVED in  VARCHAR2 DEFAULT NULL,
14   X_INSTITUTION_NAME  in VARCHAR2 DEFAULT NULL,
15   X_MAX_CREDIT_PTS  in  NUMBER DEFAULT NULL,
16   X_MAX_TERMS in   NUMBER DEFAULT NULL,
17   X_ANTICIPATED_CREDIT_POINTS in  NUMBER DEFAULT NULL,
18   X_APPROVER_ID  in  NUMBER DEFAULT NULL,
19   X_MODE in VARCHAR2 default 'R',
20   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
21   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
22   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
23   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
24   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
25   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
26   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
27   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
28   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
29   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
30   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
31   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
32   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
33   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
34   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
35   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
36   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
37   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
38   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
39   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
40   X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
41   X_COND_RETURN_FLAG IN VARCHAR2
42   );
43 procedure LOCK_ROW (
44   X_ROWID in VARCHAR2,
45   X_PERSON_ID in NUMBER,
46   X_COURSE_CD in VARCHAR2,
47   X_START_DT in DATE,
48   X_LOGICAL_DELETE_DATE in DATE,
49   X_END_DT in DATE,
50   X_VOLUNTARY_IND in VARCHAR2,
51   X_COMMENTS in VARCHAR2,
52   X_INTERMISSION_TYPE in VARCHAR2 DEFAULT NULL,
53   X_APPROVED in  VARCHAR2 DEFAULT NULL,
54   X_INSTITUTION_NAME  in VARCHAR2 DEFAULT NULL,
55   X_MAX_CREDIT_PTS  in  NUMBER DEFAULT NULL,
56   X_MAX_TERMS in   NUMBER DEFAULT NULL,
57   X_ANTICIPATED_CREDIT_POINTS in  NUMBER DEFAULT NULL,
58   X_APPROVER_ID  in  NUMBER DEFAULT NULL,
59   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
60   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
61   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
62   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
63   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
64   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
65   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
66   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
67   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
68   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
69   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
70   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
71   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
72   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
73   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
74   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
75   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
76   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
77   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
78   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
79   X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
80   X_COND_RETURN_FLAG IN VARCHAR2
81 );
82 procedure UPDATE_ROW (
83   X_ROWID in VARCHAR2,
84   X_PERSON_ID in NUMBER,
85   X_COURSE_CD in VARCHAR2,
86   X_START_DT in DATE,
87   X_LOGICAL_DELETE_DATE in DATE,
88   X_END_DT in DATE,
89   X_VOLUNTARY_IND in VARCHAR2,
90   X_COMMENTS in VARCHAR2,
91   X_INTERMISSION_TYPE in VARCHAR2 DEFAULT NULL,
92   X_APPROVED in  VARCHAR2 DEFAULT NULL,
93   X_INSTITUTION_NAME  in VARCHAR2 DEFAULT NULL,
94   X_MAX_CREDIT_PTS  in  NUMBER DEFAULT NULL,
95   X_MAX_TERMS in   NUMBER DEFAULT NULL,
96   X_ANTICIPATED_CREDIT_POINTS in  NUMBER DEFAULT NULL,
97   X_APPROVER_ID  in  NUMBER DEFAULT NULL,
98   X_MODE in VARCHAR2 default 'R',
99   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
100   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
101   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
102   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
103   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
104   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
105   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
106   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
107   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
108   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
109   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
110   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
111   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
112   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
113   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
114   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
115   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
116   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
117   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
118   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
119   X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
120   X_COND_RETURN_FLAG IN VARCHAR2
121   );
122 procedure ADD_ROW (
123   X_ROWID in out NOCOPY VARCHAR2,
124   X_PERSON_ID in NUMBER,
125   X_COURSE_CD in VARCHAR2,
126   X_START_DT in DATE,
127   X_LOGICAL_DELETE_DATE in DATE,
128   X_END_DT in DATE,
129   X_VOLUNTARY_IND in VARCHAR2,
130   X_COMMENTS in VARCHAR2,
131   X_INTERMISSION_TYPE in VARCHAR2 DEFAULT NULL,
132   X_APPROVED in  VARCHAR2 DEFAULT NULL,
133   X_INSTITUTION_NAME  in VARCHAR2 DEFAULT NULL,
134   X_MAX_CREDIT_PTS  in  NUMBER DEFAULT NULL,
135   X_MAX_TERMS in   NUMBER DEFAULT NULL,
136   X_ANTICIPATED_CREDIT_POINTS in  NUMBER DEFAULT NULL,
137   X_APPROVER_ID  in  NUMBER DEFAULT NULL,
138   X_MODE in VARCHAR2 default 'R',
139   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
140   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
141   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
142   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
143   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
144   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
145   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
146   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
147   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
148   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
149   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
150   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
151   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
152   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
153   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
154   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
155   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
156   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
157   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
158   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
159   X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
160   X_COND_RETURN_FLAG IN VARCHAR2
161   );
162 procedure DELETE_ROW (
163  X_ROWID in VARCHAR2,
164   x_mode IN VARCHAR2 DEFAULT 'R'
165 );
166  FUNCTION Get_PK_For_Validation (
167     x_person_id IN NUMBER,
168     x_course_cd IN VARCHAR2,
169     x_start_dt IN DATE,
170     x_logical_delete_date IN DATE
171     )
172   RETURN BOOLEAN;
173 
174   PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (
175     x_person_id IN NUMBER,
176     x_course_cd IN VARCHAR2
177     );
178 
179   PROCEDURE Check_constraints(
180 	column_name IN VARCHAR2 DEFAULT NULL,
181 	column_value IN VARCHAR2 DEFAULT NULL
182    );
183  PROCEDURE Before_DML (
184   p_action IN VARCHAR2,
185   x_rowid IN  VARCHAR2 DEFAULT NULL,
186   x_person_id IN NUMBER DEFAULT NULL,
187   x_course_cd IN VARCHAR2 DEFAULT NULL,
188   x_start_dt IN DATE DEFAULT NULL,
189   x_logical_delete_date IN DATE DEFAULT NULL,
190   x_end_dt IN DATE DEFAULT NULL,
191   x_voluntary_ind IN VARCHAR2 DEFAULT NULL,
192   x_comments IN VARCHAR2 DEFAULT NULL,
193   X_INTERMISSION_TYPE in VARCHAR2 DEFAULT NULL,
194   X_APPROVED in  VARCHAR2 DEFAULT NULL,
195   X_INSTITUTION_NAME  in VARCHAR2 DEFAULT NULL,
196   X_MAX_CREDIT_PTS  in  NUMBER DEFAULT NULL,
197   X_MAX_TERMS in   NUMBER DEFAULT NULL,
198   X_ANTICIPATED_CREDIT_POINTS in  NUMBER DEFAULT NULL,
199   X_APPROVER_ID  in  NUMBER DEFAULT NULL,
200   x_creation_date IN DATE  DEFAULT NULL,
201   x_created_by IN NUMBER  DEFAULT NULL,
202   x_last_update_date IN DATE  DEFAULT NULL,
203   x_last_updated_by IN NUMBER  DEFAULT NULL,
204   x_last_update_login IN NUMBER  DEFAULT NULL,
205   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
206   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
207   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
208   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
209   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
210   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
211   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
212   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
213   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
214   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
215   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
216   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
217   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
218   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
219   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
220   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
221   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
222   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
223   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
224   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
225   x_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
226   X_COND_RETURN_FLAG IN VARCHAR2 DEFAULT 'N'
227   ) ;
228 END IGS_EN_STDNT_PS_INTM_PKG;