[Home] [Help]
PACKAGE: APPS.PNT_LOCATIONS_PKG
Source
1 PACKAGE PNT_LOCATIONS_PKG AS
2 -- $Header: PNTLOCNS.pls 120.4 2006/01/10 03:51:35 appldev ship $
3
4 -- Global Variables
5
6 G_START_OF_TIME DATE := to_date('01/01/0001','MM/DD/YYYY');
7 G_END_OF_TIME DATE := to_date('12/31/4712','MM/DD/YYYY');
8 G_PN_LOCATIONS_ROWID ROWID; -- Global rowid which will be save during lock row and used during update
9 G_LOC_RECINFO pn_locations_all%rowtype; -- Delclare global record type for lock row which will be used
10 -- by correct_update_row procedure
11 g_loc_recinfo_tmp pn_locations_all%ROWTYPE;
12 g_loc_adrinfo_tmp pn_addresses_all%ROWTYPE;
13
14
15 Procedure check_location_overlap (
16 p_org_id IN NUMBER,
17 p_location_id IN NUMBER DEFAULT NULL,
18 p_location_code IN VARCHAR2,
19 p_location_type_lookup_code IN VARCHAR2,
20 p_active_start_date IN DATE,
21 p_active_end_date IN DATE,
22 p_active_start_date_old IN DATE,
23 p_active_end_date_old IN DATE,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_return_message OUT NOCOPY VARCHAR2
26 );
27
28 Procedure check_location_gaps (
29 p_org_id IN NUMBER,
30 p_location_id IN NUMBER DEFAULT NULL,
31 p_location_code IN VARCHAR2,
32 p_location_type_lookup_code IN VARCHAR2,
33 p_active_start_date IN DATE,
34 p_active_end_date IN DATE,
35 p_active_start_date_old IN DATE,
36 p_active_end_date_old IN DATE,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_return_message OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE SET_ROWID (
42 p_location_id IN NUMBER,
43 p_active_start_date IN DATE,
44 p_active_end_Date IN DATE,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_return_message OUT NOCOPY VARCHAR2) ;
47
48 PROCEDURE correct_update_row(
49 p_pn_locations_rec IN pn_locations_all%ROWTYPE
50 ,p_pn_addresses_rec IN pn_addresses_all%ROWTYPE
51 ,p_change_mode IN VARCHAR2
52 ,p_as_of_date IN DATE
53 ,p_active_start_date_old IN DATE
54 ,p_active_end_date_old IN DATE DEFAULT g_end_of_time
55 ,p_assgn_area_chgd_flag IN VARCHAR2 DEFAULT NULL
56 ,p_validate IN BOOLEAN DEFAULT TRUE
57 ,p_cascade IN VARCHAR2 DEFAULT NULL
58 ,x_return_status OUT NOCOPY VARCHAR2
59 ,x_return_message OUT NOCOPY VARCHAR2
60 );
61
62 PROCEDURE insert_row (
63 x_rowid IN OUT NOCOPY ROWID
64 ,x_org_id IN NUMBER
65 ,x_LOCATION_ID IN OUT NOCOPY NUMBER
66 ,x_LAST_UPDATE_DATE DATE
67 ,x_LAST_UPDATED_BY NUMBER
68 ,x_CREATION_DATE DATE
69 ,x_CREATED_BY NUMBER
70 ,x_LAST_UPDATE_LOGIN NUMBER
71 ,x_LOCATION_PARK_ID NUMBER
72 ,x_LOCATION_TYPE_LOOKUP_CODE VARCHAR2
73 ,x_SPACE_TYPE_LOOKUP_CODE VARCHAR2
74 ,x_FUNCTION_TYPE_LOOKUP_CODE VARCHAR2
75 ,x_STANDARD_TYPE_LOOKUP_CODE VARCHAR2
76 ,x_LOCATION_ALIAS VARCHAR2
77 ,x_LOCATION_CODE VARCHAR2
78 ,x_BUILDING VARCHAR2
79 ,x_LEASE_OR_OWNED VARCHAR2
80 ,x_CLASS VARCHAR2
81 ,x_STATUS_TYPE VARCHAR2
82 ,x_FLOOR VARCHAR2
83 ,x_OFFICE VARCHAR2
84 ,x_ADDRESS_ID IN OUT NOCOPY NUMBER
85 ,x_MAX_CAPACITY NUMBER
86 ,x_OPTIMUM_CAPACITY NUMBER
87 ,x_GROSS_AREA NUMBER
88 ,x_RENTABLE_AREA NUMBER
89 ,x_USABLE_AREA NUMBER
90 ,x_ASSIGNABLE_AREA NUMBER
91 ,x_COMMON_AREA NUMBER
92 ,x_SUITE VARCHAR2
93 ,x_ALLOCATE_COST_CENTER_CODE VARCHAR2
94 ,x_UOM_CODE VARCHAR2
95 ,x_DESCRIPTION VARCHAR2
96 ,x_PARENT_LOCATION_ID NUMBER
97 ,x_INTERFACE_FLAG VARCHAR2
98 ,x_REQUEST_ID NUMBER
99 ,x_PROGRAM_APPLICATION_ID NUMBER
100 ,x_PROGRAM_ID NUMBER
101 ,x_PROGRAM_UPDATE_DATE DATE
102 ,x_STATUS VARCHAR2
103 ,x_PROPERTY_ID NUMBER
104 ,x_ATTRIBUTE_CATEGORY VARCHAR2
105 ,x_ATTRIBUTE1 VARCHAR2
106 ,x_ATTRIBUTE2 VARCHAR2
107 ,x_ATTRIBUTE3 VARCHAR2
108 ,x_ATTRIBUTE4 VARCHAR2
109 ,x_ATTRIBUTE5 VARCHAR2
110 ,x_ATTRIBUTE6 VARCHAR2
111 ,x_ATTRIBUTE7 VARCHAR2
112 ,x_ATTRIBUTE8 VARCHAR2
113 ,x_ATTRIBUTE9 VARCHAR2
114 ,x_ATTRIBUTE10 VARCHAR2
115 ,x_ATTRIBUTE11 VARCHAR2
116 ,x_ATTRIBUTE12 VARCHAR2
117 ,x_ATTRIBUTE13 VARCHAR2
118 ,x_ATTRIBUTE14 VARCHAR2
119 ,x_ATTRIBUTE15 VARCHAR2
120 ,x_address_line1 VARCHAR2
121 ,x_address_line2 VARCHAR2
122 ,x_address_line3 VARCHAR2
123 ,x_address_line4 VARCHAR2
124 ,x_county VARCHAR2
125 ,x_city VARCHAR2
126 ,x_state VARCHAR2
127 ,x_province VARCHAR2
128 ,x_zip_code VARCHAR2
129 ,x_country VARCHAR2
130 ,x_territory_id NUMBER
131 ,x_addr_last_update_date DATE
132 ,x_addr_last_updated_by NUMBER
133 ,x_addr_creation_date DATE
134 ,x_addr_created_by NUMBER
135 ,x_addr_last_update_login NUMBER
136 ,x_addr_attribute_category VARCHAR2
137 ,x_addr_attribute1 VARCHAR2
138 ,x_addr_attribute2 VARCHAR2
139 ,x_addr_attribute3 VARCHAR2
140 ,x_addr_attribute4 VARCHAR2
141 ,x_addr_attribute5 VARCHAR2
142 ,x_addr_attribute6 VARCHAR2
143 ,x_addr_attribute7 VARCHAR2
144 ,x_addr_attribute8 VARCHAR2
145 ,x_addr_attribute9 VARCHAR2
146 ,x_addr_attribute10 VARCHAR2
147 ,x_addr_attribute11 VARCHAR2
148 ,x_addr_attribute12 VARCHAR2
149 ,x_addr_attribute13 VARCHAR2
150 ,x_addr_attribute14 VARCHAR2
151 ,x_addr_attribute15 VARCHAR2
152 ,x_COMMON_AREA_FLAG VARCHAR2
153 ,x_ACTIVE_START_DATE DATE
154 ,x_ACTIVE_END_DATE DATE
155 ,x_return_status OUT NOCOPY varchar2
156 ,x_return_message OUT NOCOPY varchar2
157 ,x_bookable_flag VARCHAR2
158 ,x_change_mode IN VARCHAR2 DEFAULT NULL
159 ,x_occupancy_status_code VARCHAR2 DEFAULT 'Y'
160 ,x_assignable_emp VARCHAR2 DEFAULT 'Y'
161 ,x_assignable_cc VARCHAR2 DEFAULT 'Y'
162 ,x_assignable_cust VARCHAR2 DEFAULT 'Y'
163 ,x_disposition_code VARCHAR2 DEFAULT NULL
164 ,x_acc_treatment_code VARCHAR2 DEFAULT NULL
165 ,x_source VARCHAR2 DEFAULT NULL
166 );
167
168 PROCEDURE UPDATE_ROW (
169 x_LOCATION_ID NUMBER
170 ,x_LAST_UPDATE_DATE DATE
171 ,x_LAST_UPDATED_BY NUMBER
172 ,x_LAST_UPDATE_LOGIN NUMBER
173 ,x_LOCATION_PARK_ID NUMBER
174 ,x_LOCATION_TYPE_LOOKUP_CODE VARCHAR2
175 ,x_SPACE_TYPE_LOOKUP_CODE VARCHAR2
176 ,x_FUNCTION_TYPE_LOOKUP_CODE VARCHAR2
177 ,x_STANDARD_TYPE_LOOKUP_CODE VARCHAR2
178 ,x_BUILDING VARCHAR2
179 ,x_LEASE_OR_OWNED VARCHAR2
180 ,x_CLASS VARCHAR2
181 ,x_STATUS_TYPE VARCHAR2
182 ,x_FLOOR VARCHAR2
183 ,x_OFFICE VARCHAR2
184 ,x_ADDRESS_ID NUMBER
185 ,x_MAX_CAPACITY NUMBER
186 ,x_OPTIMUM_CAPACITY NUMBER
187 ,x_GROSS_AREA NUMBER
188 ,x_RENTABLE_AREA NUMBER
189 ,x_USABLE_AREA NUMBER
190 ,x_ASSIGNABLE_AREA NUMBER
191 ,x_COMMON_AREA NUMBER
192 ,x_SUITE VARCHAR2
193 ,x_ALLOCATE_COST_CENTER_CODE VARCHAR2
194 ,x_UOM_CODE VARCHAR2
195 ,x_DESCRIPTION VARCHAR2
196 ,x_PARENT_LOCATION_ID NUMBER
197 ,x_INTERFACE_FLAG VARCHAR2
198 ,x_STATUS VARCHAR2
199 ,x_PROPERTY_ID NUMBER
200 ,x_ATTRIBUTE_CATEGORY VARCHAR2
201 ,x_ATTRIBUTE1 VARCHAR2
202 ,x_ATTRIBUTE2 VARCHAR2
203 ,x_ATTRIBUTE3 VARCHAR2
204 ,x_ATTRIBUTE4 VARCHAR2
205 ,x_ATTRIBUTE5 VARCHAR2
206 ,x_ATTRIBUTE6 VARCHAR2
207 ,x_ATTRIBUTE7 VARCHAR2
208 ,x_ATTRIBUTE8 VARCHAR2
209 ,x_ATTRIBUTE9 VARCHAR2
210 ,x_ATTRIBUTE10 VARCHAR2
211 ,x_ATTRIBUTE11 VARCHAR2
212 ,x_ATTRIBUTE12 VARCHAR2
213 ,x_ATTRIBUTE13 VARCHAR2
214 ,x_ATTRIBUTE14 VARCHAR2
215 ,x_ATTRIBUTE15 VARCHAR2
216 ,x_address_line1 VARCHAR2
217 ,x_address_line2 VARCHAR2
218 ,x_address_line3 VARCHAR2
219 ,x_address_line4 VARCHAR2
220 ,x_county VARCHAR2
221 ,x_city VARCHAR2
222 ,x_state VARCHAR2
223 ,x_province VARCHAR2
224 ,x_zip_code VARCHAR2
225 ,x_country VARCHAR2
226 ,x_territory_id NUMBER
227 ,x_addr_last_update_date DATE
228 ,x_addr_last_updated_by NUMBER
229 ,x_addr_last_update_login NUMBER
230 ,x_addr_attribute_category VARCHAR2
231 ,x_addr_attribute1 VARCHAR2
232 ,x_addr_attribute2 VARCHAR2
233 ,x_addr_attribute3 VARCHAR2
234 ,x_addr_attribute4 VARCHAR2
235 ,x_addr_attribute5 VARCHAR2
236 ,x_addr_attribute6 VARCHAR2
237 ,x_addr_attribute7 VARCHAR2
241 ,x_addr_attribute11 VARCHAR2
238 ,x_addr_attribute8 VARCHAR2
239 ,x_addr_attribute9 VARCHAR2
240 ,x_addr_attribute10 VARCHAR2
242 ,x_addr_attribute12 VARCHAR2
243 ,x_addr_attribute13 VARCHAR2
244 ,x_addr_attribute14 VARCHAR2
245 ,x_addr_attribute15 VARCHAR2
246 ,x_COMMON_AREA_FLAG VARCHAR2
247 ,x_assgn_area_chgd_flag VARCHAR2 DEFAULT NULL
248 ,x_ACTIVE_START_DATE DATE
249 ,x_ACTIVE_END_DATE DATE
250 ,x_return_status OUT NOCOPY varchar2
251 ,x_return_message OUT NOCOPY varchar2
252 ,x_bookable_flag VARCHAR2
253 ,x_occupancy_status_code VARCHAR2 DEFAULT 'Y'
254 ,x_assignable_emp VARCHAR2 DEFAULT 'Y'
255 ,x_assignable_cc VARCHAR2 DEFAULT 'Y'
256 ,x_assignable_cust VARCHAR2 DEFAULT 'Y'
257 ,x_disposition_code VARCHAR2 DEFAULT NULL
258 ,x_acc_treatment_code VARCHAR2 DEFAULT NULL
259 ,x_source VARCHAR2 DEFAULT NULL
260 );
261
262 PROCEDURE lock_row (
263 x_LOCATION_ID NUMBER
264 ,x_LOCATION_PARK_ID NUMBER
265 ,x_LOCATION_TYPE_LOOKUP_CODE VARCHAR2
266 ,x_SPACE_TYPE_LOOKUP_CODE VARCHAR2
267 ,x_FUNCTION_TYPE_LOOKUP_CODE VARCHAR2
268 ,x_STANDARD_TYPE_LOOKUP_CODE VARCHAR2
269 ,x_LOCATION_ALIAS VARCHAR2
270 ,x_LOCATION_CODE VARCHAR2
271 ,x_BUILDING VARCHAR2
272 ,x_LEASE_OR_OWNED VARCHAR2
273 ,x_CLASS VARCHAR2
274 ,x_STATUS_TYPE VARCHAR2
275 ,x_FLOOR VARCHAR2
276 ,x_OFFICE VARCHAR2
277 ,x_ADDRESS_ID NUMBER
278 ,x_MAX_CAPACITY NUMBER
279 ,x_OPTIMUM_CAPACITY NUMBER
280 ,x_GROSS_AREA NUMBER
281 ,x_RENTABLE_AREA NUMBER
282 ,x_USABLE_AREA NUMBER
283 ,x_ASSIGNABLE_AREA NUMBER
284 ,x_COMMON_AREA NUMBER
285 ,x_SUITE VARCHAR2
286 ,x_ALLOCATE_COST_CENTER_CODE VARCHAR2
287 ,x_UOM_CODE VARCHAR2
288 ,x_DESCRIPTION VARCHAR2
289 ,x_PARENT_LOCATION_ID NUMBER
290 ,x_INTERFACE_FLAG VARCHAR2
291 ,x_STATUS VARCHAR2
292 ,x_PROPERTY_ID NUMBER
293 ,x_ATTRIBUTE_CATEGORY VARCHAR2
294 ,x_ATTRIBUTE1 VARCHAR2
295 ,x_ATTRIBUTE2 VARCHAR2
296 ,x_ATTRIBUTE3 VARCHAR2
297 ,x_ATTRIBUTE4 VARCHAR2
298 ,x_ATTRIBUTE5 VARCHAR2
299 ,x_ATTRIBUTE6 VARCHAR2
300 ,x_ATTRIBUTE7 VARCHAR2
301 ,x_ATTRIBUTE8 VARCHAR2
302 ,x_ATTRIBUTE9 VARCHAR2
303 ,x_ATTRIBUTE10 VARCHAR2
304 ,x_ATTRIBUTE11 VARCHAR2
305 ,x_ATTRIBUTE12 VARCHAR2
306 ,x_ATTRIBUTE13 VARCHAR2
307 ,x_ATTRIBUTE14 VARCHAR2
308 ,x_ATTRIBUTE15 VARCHAR2
309 ,x_address_line1 VARCHAR2
310 ,x_address_line2 VARCHAR2
311 ,x_address_line3 VARCHAR2
312 ,x_address_line4 VARCHAR2
313 ,x_county VARCHAR2
314 ,x_city VARCHAR2
315 ,x_state VARCHAR2
316 ,x_province VARCHAR2
317 ,x_zip_code VARCHAR2
318 ,x_country VARCHAR2
319 ,x_territory_id NUMBER
320 ,x_addr_attribute_category VARCHAR2
321 ,x_addr_attribute1 VARCHAR2
325 ,x_addr_attribute5 VARCHAR2
322 ,x_addr_attribute2 VARCHAR2
323 ,x_addr_attribute3 VARCHAR2
324 ,x_addr_attribute4 VARCHAR2
326 ,x_addr_attribute6 VARCHAR2
327 ,x_addr_attribute7 VARCHAR2
328 ,x_addr_attribute8 VARCHAR2
329 ,x_addr_attribute9 VARCHAR2
330 ,x_addr_attribute10 VARCHAR2
331 ,x_addr_attribute11 VARCHAR2
332 ,x_addr_attribute12 VARCHAR2
333 ,x_addr_attribute13 VARCHAR2
334 ,x_addr_attribute14 VARCHAR2
335 ,x_addr_attribute15 VARCHAR2
336 ,x_COMMON_AREA_FLAG VARCHAR2
337 ,x_ACTIVE_START_DATE DATE
338 ,x_ACTIVE_END_DATE DATE
339 ,x_ACTIVE_START_DATE_OLD DATE
340 ,x_ACTIVE_END_DATE_OLD DATE
341 ,x_bookable_flag VARCHAR2
342 ,x_occupancy_status_code VARCHAR2 DEFAULT NULL
343 ,x_assignable_emp VARCHAR2 DEFAULT NULL
344 ,x_assignable_cc VARCHAR2 DEFAULT NULL
345 ,x_assignable_cust VARCHAR2 DEFAULT NULL
346 ,x_disposition_code VARCHAR2 DEFAULT NULL
347 ,x_acc_treatment_code VARCHAR2 DEFAULT NULL
348 );
349
350 Procedure Update_child_for_dates (
351 p_location_id IN NUMBER,
352 p_active_start_date IN DATE,
353 p_active_end_date IN DATE,
354 p_active_start_date_old IN DATE,
355 p_active_end_date_old IN DATE ,
356 p_location_type_lookup_code IN VARCHAR2,
357 x_return_status OUT NOCOPY VARCHAR2,
358 x_return_message OUT NOCOPY VARCHAR2) ;
359
360 Procedure check_for_popup (
361 p_pn_locations_rec pn_locations_all%rowtype,
362 p_start_date_old IN DATE,
363 p_end_date_old IN DATE,
364 x_flag OUT NOCOPY VARCHAR2,
365 x_return_status OUT NOCOPY VARCHAR2,
366 x_return_message OUT NOCOPY VARCHAR2);
367
368
369 ---------------------------------------------------------------------------------------
370 -- Procedure Update_Status ( Fix for bug 707274 )
371 ---------------------------------------------------------------------------------------
372 Procedure Update_Status ( p_Location_Id Number ) ;
373
374 ---------------------------------------------------------------------------------------
375 -- Procedure update_assignments ( Fix for bug 2722698 )
376 ---------------------------------------------------------------------------------------
377 Procedure update_assignments (
378 p_location_id IN NUMBER,
379 p_active_start_date IN DATE,
380 p_active_end_date IN DATE,
381 p_active_start_date_old IN DATE,
382 p_active_end_date_old IN DATE ,
383 x_return_status OUT NOCOPY VARCHAR2,
384 x_return_message OUT NOCOPY VARCHAR2) ;
385
386 ---------------------------------------------------------------------------------------
387 -- Function validate_gross_area
388 ---------------------------------------------------------------------------------------
389
390 FUNCTION validate_gross_area(p_loc_id IN NUMBER,
391 p_area IN NUMBER,
392 p_lkp_code IN VARCHAR2,
393 p_act_str_dt IN DATE,
394 p_act_end_dt IN DATE,
395 p_change_mode IN VARCHAR2 DEFAULT NULL)
396 RETURN BOOLEAN;
397
398 ---------------------------------------------------------------------------------------
399 -- PROCEDURE Check_Location_Gaps
400 ---------------------------------------------------------------------------------------
401 PROCEDURE check_location_gaps (
402 p_loc_id IN NUMBER
403 ,p_str_dt IN DATE
404 ,p_end_dt IN DATE
405 ,p_asgn_mode IN VARCHAR2 DEFAULT 'NONE'
406 ,p_err_msg OUT NOCOPY VARCHAR2
407 );
408
409 PROCEDURE Get_Location_Span (
410 p_loc_id IN NUMBER
411 ,p_asgn_mode IN VARCHAR2 DEFAULT 'NONE'
412 ,p_min_str_dt OUT NOCOPY DATE
413 ,p_max_end_dt OUT NOCOPY DATE
414 );
415
416 PROCEDURE Cascade_Child_Locn (
420 ,p_cascade IN VARCHAR2
417 p_location_id IN NUMBER
418 ,p_start_date IN DATE
419 ,p_end_date IN DATE
421 ,p_change_mode IN VARCHAR2
422 ,x_return_status OUT NOCOPY VARCHAR2
423 ,x_return_message OUT NOCOPY VARCHAR2
424 );
425
426 FUNCTION Check_Locn_Assgn (
427 p_location_id IN NUMBER
428 ,p_location_type IN VARCHAR2
429 ,p_str_date IN DATE
430 ,p_end_date IN DATE
431 ,p_asgn_mode IN VARCHAR2
432 )
433 RETURN BOOLEAN;
434
435 FUNCTION Parent_Not_Occpble_Asgnble (
436 p_parent_location_id IN NUMBER
437 ,p_str_date IN DATE
438 ,p_end_date IN DATE
439 ,p_status_mode IN VARCHAR2
440 )
441 RETURN BOOLEAN;
442
443 PROCEDURE Insert_Locn_Row (
444 p_loc_recinfo IN pn_locations_all%ROWTYPE
445 ,p_adr_recinfo IN pn_addresses_all%ROWTYPE
446 ,p_change_mode IN VARCHAR2
447 ,x_return_status IN OUT NOCOPY VARCHAR2
448 ,x_return_message IN OUT NOCOPY VARCHAR2
449 );
450
451 PROCEDURE Update_Locn_Row (
452 p_loc_recinfo IN pn_locations_all%ROWTYPE
453 ,p_adr_recinfo IN pn_addresses_all%ROWTYPE
454 ,p_assgn_area_chgd_flag IN VARCHAR2
455 ,x_return_status IN OUT NOCOPY VARCHAR2
456 ,x_return_message IN OUT NOCOPY VARCHAR2
457 );
458
459 -------------------------------------------------------------------------------
460 -- FUNCTION to return location id for location code and lookup code
461 -------------------------------------------------------------------------------
462 FUNCTION get_location_id (
463 p_location_code IN VARCHAR2,
464 p_loctn_type_lookup_code IN VARCHAR2,
465 p_org_id IN NUMBER
466 ) RETURN number;
467
468 -------------------------------------------------------------------------------
469 -- PROCEDURE to check if location code is unique
470 -------------------------------------------------------------------------------
471 PROCEDURE check_unique_location_code (
472 x_return_status IN OUT NOCOPY VARCHAR2,
473 x_location_id NUMBER,
474 x_location_code VARCHAR2,
475 x_active_start_date DATE,
476 x_active_end_date DATE,
477 x_org_id NUMBER
478 );
479
480 -------------------------------------------------------------------------------
481 -- PROCEDURE to check if building is unique
482 -------------------------------------------------------------------------------
483 PROCEDURE check_unique_building (
484 x_return_status IN OUT NOCOPY VARCHAR2,
485 x_location_id NUMBER,
486 x_building VARCHAR2,
490 );
487 x_active_start_date DATE,
488 x_active_end_date DATE,
489 x_org_id NUMBER
491
492 -------------------------------------------------------------------------------
493 -- FUNCTION to check if building has unique alias
494 -------------------------------------------------------------------------------
495 FUNCTION check_unique_building_alias
496 ( p_location_id NUMBER,
497 p_location_alias VARCHAR2,
498 p_location_type_lookup_code VARCHAR2,
499 p_org_id NUMBER)
500 RETURN BOOLEAN;
501
502 -------------------------------------------------------------------------------
503 -- FUNCTION to check if location has unique alias
504 -------------------------------------------------------------------------------
505 PROCEDURE check_unique_location_alias (
506 x_return_status IN OUT NOCOPY VARCHAR2,
507 x_location_id NUMBER,
508 x_parent_location_id NUMBER,
509 x_location_type_lookup_code VARCHAR2,
510 x_location_alias VARCHAR2,
511 x_active_start_date DATE,
512 x_active_end_date DATE,
513 x_org_id NUMBER
514 );
515 ---------------------------------------------------------------------------------------
516 -- End of Pkg
517 ---------------------------------------------------------------------------------------
518 END PNT_LOCATIONS_PKG;