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_AD_LOCATION_PKG

Source


1 package IGS_AD_LOCATION_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSAI46S.pls 115.10 2003/10/30 13:12:59 akadam ship $ */
3 
4   /*******************************************************************************
5   Created by  : Oracle IDC
6   Date created:
7 
8   Purpose:
9      1.
10 
11   Usage: (e.g. restricted, unrestricted, where to call from)
12      1.
13 
14   Known limitations/enhancements/remarks:
15      -
16 
17   Change History: (who, when, what: NO CREATION RECORDS HERE!)
18   Who             When            What
19   msrinivi        18 Jul,2001     Added a new col : revenue_account_cd
20   *******************************************************************************/
21 
22 PROCEDURE INSERT_ROW (
23   X_ROWID in out NOCOPY VARCHAR2,
24   X_ORG_ID in NUMBER,
25   X_LOCATION_CD in VARCHAR2,
26   X_DESCRIPTION in VARCHAR2,
27   X_LOCATION_TYPE in VARCHAR2,
28   X_MAIL_DLVRY_WRK_DAYS in NUMBER,
29   X_COORD_PERSON_ID in igs_pe_person.person_id%type,
30     x_attribute_category IN VARCHAR2 DEFAULT NULL,
31     x_attribute1 IN VARCHAR2 DEFAULT NULL,
32     x_attribute2 IN VARCHAR2 DEFAULT NULL,
33     x_attribute3 IN VARCHAR2 DEFAULT NULL,
34     x_attribute4 IN VARCHAR2 DEFAULT NULL,
35     x_attribute5 IN VARCHAR2 DEFAULT NULL,
36     x_attribute6 IN VARCHAR2 DEFAULT NULL,
37     x_attribute7 IN VARCHAR2 DEFAULT NULL,
38     x_attribute8 IN VARCHAR2 DEFAULT NULL,
39     x_attribute9 IN VARCHAR2 DEFAULT NULL,
40     x_attribute10 IN VARCHAR2 DEFAULT NULL,
41     x_attribute11 IN VARCHAR2 DEFAULT NULL,
42     x_attribute12 IN VARCHAR2 DEFAULT NULL,
43     x_attribute13 IN VARCHAR2 DEFAULT NULL,
44     x_attribute14 IN VARCHAR2 DEFAULT NULL,
45     x_attribute15 IN VARCHAR2 DEFAULT NULL,
46     x_attribute16 IN VARCHAR2 DEFAULT NULL,
47     x_attribute17 IN VARCHAR2 DEFAULT NULL,
48     x_attribute18 IN VARCHAR2 DEFAULT NULL,
49     x_attribute19 IN VARCHAR2 DEFAULT NULL,
50     x_attribute20 IN VARCHAR2 DEFAULT NULL,
51   X_CLOSED_IND in VARCHAR2,
52   X_MODE in VARCHAR2 default 'R',
53   x_rev_account_cd IN VARCHAR2 DEFAULT NULL
54   );
55 
56   /*******************************************************************************
57   Created by  : Oracle IDC
58   Date created:
59 
60   Purpose:
61      1.
62 
63   Usage: (e.g. restricted, unrestricted, where to call from)
64      1.
65 
66   Known limitations/enhancements/remarks:
67      -
68 
69   Change History: (who, when, what: NO CREATION RECORDS HERE!)
70   Who             When            What
71   msrinivi        18 Jul,2001     Added a new col : revenue_account_cd
72   *******************************************************************************/
73   PROCEDURE LOCK_ROW (
74   X_ROWID  in VARCHAR2,
75   X_LOCATION_CD in VARCHAR2,
76   X_DESCRIPTION in VARCHAR2,
77   X_LOCATION_TYPE in VARCHAR2,
78   X_MAIL_DLVRY_WRK_DAYS in NUMBER,
79   X_COORD_PERSON_ID in igs_pe_person.person_id%type,
80     x_attribute_category IN VARCHAR2 DEFAULT NULL,
81     x_attribute1 IN VARCHAR2 DEFAULT NULL,
82     x_attribute2 IN VARCHAR2 DEFAULT NULL,
83     x_attribute3 IN VARCHAR2 DEFAULT NULL,
84     x_attribute4 IN VARCHAR2 DEFAULT NULL,
85     x_attribute5 IN VARCHAR2 DEFAULT NULL,
86     x_attribute6 IN VARCHAR2 DEFAULT NULL,
87     x_attribute7 IN VARCHAR2 DEFAULT NULL,
88     x_attribute8 IN VARCHAR2 DEFAULT NULL,
89     x_attribute9 IN VARCHAR2 DEFAULT NULL,
90     x_attribute10 IN VARCHAR2 DEFAULT NULL,
91     x_attribute11 IN VARCHAR2 DEFAULT NULL,
92     x_attribute12 IN VARCHAR2 DEFAULT NULL,
93     x_attribute13 IN VARCHAR2 DEFAULT NULL,
94     x_attribute14 IN VARCHAR2 DEFAULT NULL,
95     x_attribute15 IN VARCHAR2 DEFAULT NULL,
96     x_attribute16 IN VARCHAR2 DEFAULT NULL,
97     x_attribute17 IN VARCHAR2 DEFAULT NULL,
98     x_attribute18 IN VARCHAR2 DEFAULT NULL,
99     x_attribute19 IN VARCHAR2 DEFAULT NULL,
100     x_attribute20 IN VARCHAR2 DEFAULT NULL,
101   X_CLOSED_IND in VARCHAR2,
102   x_rev_account_cd IN VARCHAR2 DEFAULT NULL
103 );
104 
105   /*******************************************************************************
106   Created by  : Oracle IDC
107   Date created:
108   Purpose:
109      1.
110   Usage: (e.g. restricted, unrestricted, where to call from)
111      1.
112   Known limitations/enhancements/remarks:
113      -
114   Change History: (who, when, what: NO CREATION RECORDS HERE!)
115   Who             When            What
116   msrinivi        18 Jul,2001     Added a new col : revenue_account_cd
117   *******************************************************************************/
118   PROCEDURE UPDATE_ROW (
119   X_ROWID  in VARCHAR2,
120   X_LOCATION_CD in VARCHAR2,
121   X_DESCRIPTION in VARCHAR2,
122   X_LOCATION_TYPE in VARCHAR2,
123   X_MAIL_DLVRY_WRK_DAYS in NUMBER,
124   X_COORD_PERSON_ID in igs_pe_person.person_id%type,
125   X_CLOSED_IND in VARCHAR2,
126     x_attribute_category IN VARCHAR2 DEFAULT NULL,
127     x_attribute1 IN VARCHAR2 DEFAULT NULL,
128     x_attribute2 IN VARCHAR2 DEFAULT NULL,
129     x_attribute3 IN VARCHAR2 DEFAULT NULL,
130     x_attribute4 IN VARCHAR2 DEFAULT NULL,
131     x_attribute5 IN VARCHAR2 DEFAULT NULL,
132     x_attribute6 IN VARCHAR2 DEFAULT NULL,
133     x_attribute7 IN VARCHAR2 DEFAULT NULL,
134     x_attribute8 IN VARCHAR2 DEFAULT NULL,
135     x_attribute9 IN VARCHAR2 DEFAULT NULL,
136     x_attribute10 IN VARCHAR2 DEFAULT NULL,
137     x_attribute11 IN VARCHAR2 DEFAULT NULL,
138     x_attribute12 IN VARCHAR2 DEFAULT NULL,
139     x_attribute13 IN VARCHAR2 DEFAULT NULL,
140     x_attribute14 IN VARCHAR2 DEFAULT NULL,
141     x_attribute15 IN VARCHAR2 DEFAULT NULL,
142     x_attribute16 IN VARCHAR2 DEFAULT NULL,
143     x_attribute17 IN VARCHAR2 DEFAULT NULL,
144     x_attribute18 IN VARCHAR2 DEFAULT NULL,
145     x_attribute19 IN VARCHAR2 DEFAULT NULL,
146     x_attribute20 IN VARCHAR2 DEFAULT NULL,
147   X_MODE in VARCHAR2 default 'R',
148   x_rev_account_cd IN VARCHAR2 DEFAULT NULL
149   );
150 
151   /*******************************************************************************
152   Created by  : Oracle IDC
153   Date created:
154   Purpose:
155      1.
156   Usage: (e.g. restricted, unrestricted, where to call from)
157      1.
158   Known limitations/enhancements/remarks:
159      -
160   Change History: (who, when, what: NO CREATION RECORDS HERE!)
161   Who             When            What
162   msrinivi        18 Jul,2001     Added a new col : revenue_account_cd
163   *******************************************************************************/
164   PROCEDURE ADD_ROW (
165   X_ROWID in out NOCOPY VARCHAR2,
166   X_ORG_ID in NUMBER,
167   X_LOCATION_CD in VARCHAR2,
168   X_DESCRIPTION in VARCHAR2,
169   X_LOCATION_TYPE in VARCHAR2,
170   X_MAIL_DLVRY_WRK_DAYS in NUMBER,
171   X_COORD_PERSON_ID in igs_pe_person.person_id%type,
172   X_CLOSED_IND in VARCHAR2,
173     x_attribute_category IN VARCHAR2 DEFAULT NULL,
174     x_attribute1 IN VARCHAR2 DEFAULT NULL,
175     x_attribute2 IN VARCHAR2 DEFAULT NULL,
176     x_attribute3 IN VARCHAR2 DEFAULT NULL,
177     x_attribute4 IN VARCHAR2 DEFAULT NULL,
178     x_attribute5 IN VARCHAR2 DEFAULT NULL,
179     x_attribute6 IN VARCHAR2 DEFAULT NULL,
180     x_attribute7 IN VARCHAR2 DEFAULT NULL,
181     x_attribute8 IN VARCHAR2 DEFAULT NULL,
182     x_attribute9 IN VARCHAR2 DEFAULT NULL,
183     x_attribute10 IN VARCHAR2 DEFAULT NULL,
184     x_attribute11 IN VARCHAR2 DEFAULT NULL,
185     x_attribute12 IN VARCHAR2 DEFAULT NULL,
186     x_attribute13 IN VARCHAR2 DEFAULT NULL,
187     x_attribute14 IN VARCHAR2 DEFAULT NULL,
188     x_attribute15 IN VARCHAR2 DEFAULT NULL,
189     x_attribute16 IN VARCHAR2 DEFAULT NULL,
190     x_attribute17 IN VARCHAR2 DEFAULT NULL,
191     x_attribute18 IN VARCHAR2 DEFAULT NULL,
192     x_attribute19 IN VARCHAR2 DEFAULT NULL,
193     x_attribute20 IN VARCHAR2 DEFAULT NULL,
194   X_MODE in VARCHAR2 default 'R',
195   x_rev_account_cd IN VARCHAR2 DEFAULT NULL
196   );
197 
198   /*******************************************************************************
199   Created by  : Oracle IDC
200   Date created:
201   Purpose:
202      1.
203   Usage: (e.g. restricted, unrestricted, where to call from)
204      1.
205   Known limitations/enhancements/remarks:
206      -
207   Change History: (who, when, what: NO CREATION RECORDS HERE!)
208   Who             When            What
209   *******************************************************************************/
210   PROCEDURE DELETE_ROW (
211    X_ROWID  in VARCHAR2
212   );
213 
214   /*******************************************************************************
215   Created by  : Oracle IDC
216   Date created:
217   Purpose:
218      1.
219   Usage: (e.g. restricted, unrestricted, where to call from)
220      1.
221   Known limitations/enhancements/remarks:
222      -
223   Change History: (who, when, what: NO CREATION RECORDS HERE!)
224   Who             When            What
225   *******************************************************************************/
226   FUNCTION Get_PK_For_Validation (
227     x_location_cd IN VARCHAR2,
228     x_closed_ind IN VARCHAR2 DEFAULT NULL
229     )
230 RETURN BOOLEAN ;
231 
232   /*******************************************************************************
233   Created by  : Oracle IDC
234   Date created:
235   Purpose:
236      1.
237   Usage: (e.g. restricted, unrestricted, where to call from)
238      1.
239   Known limitations/enhancements/remarks:
240      -
241   Change History: (who, when, what: NO CREATION RECORDS HERE!)
242   Who             When            What
243   *******************************************************************************/
244   PROCEDURE GET_FK_IGS_AD_LOCATION_TYPE (
245     x_location_type IN VARCHAR2
246     );
247 
248   /*******************************************************************************
249   Created by  : Oracle IDC
250   Date created:
251   Purpose:
252      1.
253   Usage: (e.g. restricted, unrestricted, where to call from)
254      1.
255   Known limitations/enhancements/remarks:
256      -
257   Change History: (who, when, what: NO CREATION RECORDS HERE!)
258   Who             When            What
259   *******************************************************************************/
260   PROCEDURE GET_FK_IGS_PE_PERSON (
261     x_person_id IN igs_pe_person.person_id%type
262     );
263 
264   /*******************************************************************************
265   Created by  : Oracle IDC
266   Date created:
267   Purpose:
268      1.
269   Usage: (e.g. restricted, unrestricted, where to call from)
270      1.
271   Known limitations/enhancements/remarks:
272      -
273   Change History: (who, when, what: NO CREATION RECORDS HERE!)
274   Who             When            What
275   *******************************************************************************/
276   PROCEDURE Check_Constraints (
277   Column_Name IN VARCHAR2 DEFAULT NULL,
278   Column_Value IN VARCHAR2 DEFAULT NULL
279   );
280 
281   /*******************************************************************************
282   Created by  : Oracle IDC
283   Date created:
284   Purpose:
285      1.
286   Usage: (e.g. restricted, unrestricted, where to call from)
287      1.
288   Known limitations/enhancements/remarks:
289      -
290   Change History: (who, when, what: NO CREATION RECORDS HERE!)
291   Who             When            What
292   msrinivi        18 Jul,2001     Added a new col : revenue_account_cd
293   *******************************************************************************/
294   PROCEDURE Before_DML (
295     p_action IN VARCHAR2,
296     x_rowid IN  VARCHAR2 DEFAULT NULL,
297     x_org_id IN  NUMBER DEFAULT NULL,
298     x_location_cd IN VARCHAR2 DEFAULT NULL,
299     x_description IN VARCHAR2 DEFAULT NULL,
300     x_location_type IN VARCHAR2 DEFAULT NULL,
301     x_closed_ind IN VARCHAR2 DEFAULT NULL,
302     x_coord_person_id IN igs_pe_person.person_id%type DEFAULT NULL,
303     x_mail_dlvry_wrk_days IN NUMBER DEFAULT NULL,
304     x_attribute_category IN VARCHAR2 DEFAULT NULL,
305     x_attribute1 IN VARCHAR2 DEFAULT NULL,
306     x_attribute2 IN VARCHAR2 DEFAULT NULL,
307     x_attribute3 IN VARCHAR2 DEFAULT NULL,
308     x_attribute4 IN VARCHAR2 DEFAULT NULL,
309     x_attribute5 IN VARCHAR2 DEFAULT NULL,
310     x_attribute6 IN VARCHAR2 DEFAULT NULL,
311     x_attribute7 IN VARCHAR2 DEFAULT NULL,
312     x_attribute8 IN VARCHAR2 DEFAULT NULL,
313     x_attribute9 IN VARCHAR2 DEFAULT NULL,
314     x_attribute10 IN VARCHAR2 DEFAULT NULL,
315     x_attribute11 IN VARCHAR2 DEFAULT NULL,
316     x_attribute12 IN VARCHAR2 DEFAULT NULL,
317     x_attribute13 IN VARCHAR2 DEFAULT NULL,
318     x_attribute14 IN VARCHAR2 DEFAULT NULL,
319     x_attribute15 IN VARCHAR2 DEFAULT NULL,
320     x_attribute16 IN VARCHAR2 DEFAULT NULL,
321     x_attribute17 IN VARCHAR2 DEFAULT NULL,
322     x_attribute18 IN VARCHAR2 DEFAULT NULL,
323     x_attribute19 IN VARCHAR2 DEFAULT NULL,
324     x_attribute20 IN VARCHAR2 DEFAULT NULL,
325     x_creation_date IN DATE DEFAULT NULL,
326     x_created_by IN NUMBER DEFAULT NULL,
327     x_last_update_date IN DATE DEFAULT NULL,
328     x_last_updated_by IN NUMBER DEFAULT NULL,
329     x_last_update_login IN NUMBER DEFAULT NULL,
330     x_rev_account_cd IN VARCHAR2 DEFAULT NULL
331     ) ;
332 
333 end IGS_AD_LOCATION_PKG;