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_UNIT_SET_PKG

Source


1 package IGS_EN_UNIT_SET_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSEI01S.pls 115.10 2003/06/06 11:41:58 myoganat ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_UNIT_SET_CD in VARCHAR2,
7   X_VERSION_NUMBER in NUMBER,
8   X_UNIT_SET_STATUS in VARCHAR2,
9   X_UNIT_SET_CAT in VARCHAR2,
10   X_START_DT in DATE,
11   X_REVIEW_DT in DATE,
12   X_EXPIRY_DT in DATE,
13   X_END_DT in DATE,
14   X_TITLE in VARCHAR2,
15   X_SHORT_TITLE in VARCHAR2,
16   X_ABBREVIATION in VARCHAR2,
17   X_RESPONSIBLE_ORG_UNIT_CD in VARCHAR2,
18   X_RESPONSIBLE_OU_START_DT in DATE,
19   X_ADMINISTRATIVE_IND in VARCHAR2,
20   X_AUTHORISATION_RQRD_IND in VARCHAR2,
21   X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
22   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
23   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
24   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
25   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
26   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
27   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
28   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
29   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
30   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
31   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
32   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
33   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
34   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
35   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
36   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
37   X_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
38   X_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
39   X_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
40   X_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
41   X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
42   X_MODE in VARCHAR2 default 'R' ,
43   x_org_id IN NUMBER
44   );
45 procedure LOCK_ROW (
46   X_ROWID IN VARCHAR2,
47   X_UNIT_SET_CD in VARCHAR2,
48   X_VERSION_NUMBER in NUMBER,
49   X_UNIT_SET_STATUS in VARCHAR2,
50   X_UNIT_SET_CAT in VARCHAR2,
51   X_START_DT in DATE,
52   X_REVIEW_DT in DATE,
53   X_EXPIRY_DT in DATE,
54   X_END_DT in DATE,
55   X_TITLE in VARCHAR2,
56   X_SHORT_TITLE in VARCHAR2,
57   X_ABBREVIATION in VARCHAR2,
58   X_RESPONSIBLE_ORG_UNIT_CD in VARCHAR2,
59   X_RESPONSIBLE_OU_START_DT in DATE,
60   X_ADMINISTRATIVE_IND in VARCHAR2,
61   X_AUTHORISATION_RQRD_IND in VARCHAR2,
62   X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
63   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
64   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
65   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
66   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
67   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
68   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
69   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
70   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
71   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
72   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
73   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
74   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
75   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
76   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
77   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
78   X_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
79   X_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
80   X_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
81   X_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
82   X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL
83 );
84 procedure UPDATE_ROW (
85   X_ROWID IN VARCHAR2,
86   X_UNIT_SET_CD in VARCHAR2,
87   X_VERSION_NUMBER in NUMBER,
88   X_UNIT_SET_STATUS in VARCHAR2,
89   X_UNIT_SET_CAT in VARCHAR2,
90   X_START_DT in DATE,
91   X_REVIEW_DT in DATE,
92   X_EXPIRY_DT in DATE,
93   X_END_DT in DATE,
94   X_TITLE in VARCHAR2,
95   X_SHORT_TITLE in VARCHAR2,
96   X_ABBREVIATION in VARCHAR2,
97   X_RESPONSIBLE_ORG_UNIT_CD in VARCHAR2,
98   X_RESPONSIBLE_OU_START_DT in DATE,
99   X_ADMINISTRATIVE_IND in VARCHAR2,
100   X_AUTHORISATION_RQRD_IND in VARCHAR2,
101   X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
102   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
103   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
104   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
105   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
106   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
107   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
108   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
109   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
110   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
111   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
112   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
113   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
114   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
115   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
116   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
117   X_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
118   X_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
119   X_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
120   X_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
121   X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
122   X_MODE in VARCHAR2 default 'R'
123   );
124 procedure ADD_ROW (
125   X_ROWID in out NOCOPY VARCHAR2,
126   X_UNIT_SET_CD in VARCHAR2,
127   X_VERSION_NUMBER in NUMBER,
128   X_UNIT_SET_STATUS in VARCHAR2,
129   X_UNIT_SET_CAT in VARCHAR2,
130   X_START_DT in DATE,
131   X_REVIEW_DT in DATE,
132   X_EXPIRY_DT in DATE,
133   X_END_DT in DATE,
134   X_TITLE in VARCHAR2,
135   X_SHORT_TITLE in VARCHAR2,
136   X_ABBREVIATION in VARCHAR2,
137   X_RESPONSIBLE_ORG_UNIT_CD in VARCHAR2,
138   X_RESPONSIBLE_OU_START_DT in DATE,
139   X_ADMINISTRATIVE_IND in VARCHAR2,
140   X_AUTHORISATION_RQRD_IND in VARCHAR2,
141   X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
142   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
143   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
144   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
145   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
146   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
147   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
148   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
149   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
150   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
151   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
152   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
153   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
154   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
155   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
156   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
157   X_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
158   X_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
159   X_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
160   X_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
161   X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
162   X_MODE in VARCHAR2 default 'R',
163   x_org_id IN NUMBER
164   );
165 procedure DELETE_ROW (
166   X_ROWID IN VARCHAR2
167   );
168 
169   FUNCTION Get_PK_For_Validation (
170     x_unit_set_cd IN VARCHAR2,
171     x_version_number IN NUMBER
172     ) RETURN BOOLEAN;
173 
174   PROCEDURE GET_FK_IGS_OR_UNIT (
175     x_org_unit_cd IN VARCHAR2,
176     x_start_dt IN DATE
177     );
178 
179   PROCEDURE GET_FK_IGS_EN_UNIT_SET_CAT (
180     x_unit_set_cat IN VARCHAR2
181     );
182 
183   PROCEDURE GET_FK_IGS_EN_UNIT_SET_STAT (
184     x_unit_set_status IN VARCHAR2
185     );
186 
187  PROCEDURE Check_Constraints (
188  Column_Name	IN	VARCHAR2	DEFAULT NULL,
189  Column_Value 	IN	VARCHAR2	DEFAULT NULL
190  );
191 
192 PROCEDURE Before_DML (
193     p_action IN VARCHAR2,
194     x_rowid IN VARCHAR2 DEFAULT NULL,
195     x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
196     x_version_number IN NUMBER DEFAULT NULL,
197     x_unit_set_status IN VARCHAR2 DEFAULT NULL,
198     x_unit_set_cat IN VARCHAR2 DEFAULT NULL,
199     x_start_dt IN DATE DEFAULT NULL,
200     x_review_dt IN DATE DEFAULT NULL,
201     x_expiry_dt IN DATE DEFAULT NULL,
202     x_end_dt IN DATE DEFAULT NULL,
203     x_title IN VARCHAR2 DEFAULT NULL,
204     x_short_title IN VARCHAR2 DEFAULT NULL,
205     x_abbreviation IN VARCHAR2 DEFAULT NULL,
206     x_responsible_org_unit_cd IN VARCHAR2 DEFAULT NULL,
207     x_responsible_ou_start_dt IN DATE DEFAULT NULL,
208     x_administrative_ind IN VARCHAR2 DEFAULT NULL,
209     x_authorisation_rqrd_ind IN VARCHAR2 DEFAULT NULL,
210     x_attribute_category in VARCHAR2 DEFAULT NULL,
211     x_attribute1 in VARCHAR2 DEFAULT NULL,
212     x_attribute2 in VARCHAR2 DEFAULT NULL,
213     x_attribute3 in VARCHAR2 DEFAULT NULL,
214     x_attribute4 in VARCHAR2 DEFAULT NULL,
215     x_attribute5 in VARCHAR2 DEFAULT NULL,
216     x_attribute6 in VARCHAR2 DEFAULT NULL,
217     x_attribute7 in VARCHAR2 DEFAULT NULL,
218     x_attribute8 in VARCHAR2 DEFAULT NULL,
219     x_attribute9 in VARCHAR2 DEFAULT NULL,
220     x_attribute10 in VARCHAR2 DEFAULT NULL,
221     x_attribute11 in VARCHAR2 DEFAULT NULL,
222     x_attribute12 in VARCHAR2 DEFAULT NULL,
223     x_attribute13 in VARCHAR2 DEFAULT NULL,
224     x_attribute14 in VARCHAR2 DEFAULT NULL,
225     x_attribute15 in VARCHAR2 DEFAULT NULL,
226     x_attribute16 in VARCHAR2 DEFAULT NULL,
227     x_attribute17 in VARCHAR2 DEFAULT NULL,
228     x_attribute18 in VARCHAR2 DEFAULT NULL,
229     x_attribute19 in VARCHAR2 DEFAULT NULL,
230     x_attribute20 in VARCHAR2 DEFAULT NULL,
231     x_creation_date IN DATE DEFAULT NULL,
232     x_created_by IN NUMBER DEFAULT NULL,
233     x_last_update_date IN DATE DEFAULT NULL,
234     x_last_updated_by IN NUMBER DEFAULT NULL,
235     x_last_update_login IN NUMBER DEFAULT NULL ,
236   x_org_id IN NUMBER DEFAULT NULL
237   );
238 end IGS_EN_UNIT_SET_PKG;