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.

APPS.PNT_LOCATIONS_PKG dependencies on PN_LOCATIONS

Line 5: RECORD (active_start_date pn_locations.active_start_date%TYPE,

1: PACKAGE BODY PNT_LOCATIONS_PKG AS
2: -- $Header: PNTLOCNB.pls 120.8.12010000.3 2008/11/27 04:42:30 rthumma ship $
3:
4: TYPE loc_info_rec IS
5: RECORD (active_start_date pn_locations.active_start_date%TYPE,
6: active_end_date pn_locations.active_end_date%TYPE,
7: area pn_locations.assignable_area%TYPE);
8:
9: TYPE loc_info_type IS

Line 6: active_end_date pn_locations.active_end_date%TYPE,

2: -- $Header: PNTLOCNB.pls 120.8.12010000.3 2008/11/27 04:42:30 rthumma ship $
3:
4: TYPE loc_info_rec IS
5: RECORD (active_start_date pn_locations.active_start_date%TYPE,
6: active_end_date pn_locations.active_end_date%TYPE,
7: area pn_locations.assignable_area%TYPE);
8:
9: TYPE loc_info_type IS
10: TABLE OF loc_info_rec

Line 7: area pn_locations.assignable_area%TYPE);

3:
4: TYPE loc_info_rec IS
5: RECORD (active_start_date pn_locations.active_start_date%TYPE,
6: active_end_date pn_locations.active_end_date%TYPE,
7: area pn_locations.assignable_area%TYPE);
8:
9: TYPE loc_info_type IS
10: TABLE OF loc_info_rec
11: INDEX BY BINARY_INTEGER;

Line 25: FROM pn_locations_all

21:
22: CURSOR For_Insert_Cur (p_loc_cd VARCHAR2, p_loc_type_cd VARCHAR2, p_org_id NUMBER)
23: IS
24: SELECT MIN(active_start_date), MAX(active_end_date)
25: FROM pn_locations_all
26: WHERE location_code = p_loc_cd
27: AND location_type_lookup_code = p_loc_type_cd
28: AND org_id = p_org_id;
29:

Line 33: FROM pn_locations_all

29:
30: CURSOR For_Update_St_Cur (p_loc_id NUMBER, p_str_dt DATE, p_str_dt_old DATE)
31: IS
32: SELECT TO_NUMBER(MIN(p_str_dt - active_end_date)) start_date_diff
33: FROM pn_locations_all
34: WHERE location_id = p_loc_id
35: AND ROWID <> g_pn_locations_rowid
36: AND active_end_date < p_str_dt_old;
37:

Line 35: AND ROWID <> g_pn_locations_rowid

31: IS
32: SELECT TO_NUMBER(MIN(p_str_dt - active_end_date)) start_date_diff
33: FROM pn_locations_all
34: WHERE location_id = p_loc_id
35: AND ROWID <> g_pn_locations_rowid
36: AND active_end_date < p_str_dt_old;
37:
38: CURSOR For_Update_End_Cur (p_loc_id NUMBER, p_end_dt DATE, p_end_dt_old DATE)
39: IS

Line 41: FROM pn_locations_all

37:
38: CURSOR For_Update_End_Cur (p_loc_id NUMBER, p_end_dt DATE, p_end_dt_old DATE)
39: IS
40: SELECT TO_NUMBER(MAX(p_end_dt - active_start_date)) end_date_diff
41: FROM pn_locations_all
42: WHERE location_id = p_loc_id
43: AND ROWID <> g_pn_locations_rowid
44: AND active_start_date > p_end_dt_old;
45:

Line 43: AND ROWID <> g_pn_locations_rowid

39: IS
40: SELECT TO_NUMBER(MAX(p_end_dt - active_start_date)) end_date_diff
41: FROM pn_locations_all
42: WHERE location_id = p_loc_id
43: AND ROWID <> g_pn_locations_rowid
44: AND active_start_date > p_end_dt_old;
45:
46:
47: PROCEDURE Put_Log(p_String VarChar2) IS

Line 76: FROM pn_locations_all

72: p_lkp_code IN VARCHAR2,
73: p_act_str_dt IN DATE,
74: p_act_end_dt IN DATE) IS
75: SELECT location_id, active_start_date, active_end_date, NVL(rentable_area,0) rentable_area
76: FROM pn_locations_all
77: WHERE location_type_lookup_code = p_lkp_code
78: AND active_start_date <= NVL(p_act_end_dt, TO_DATE('12/31/4712','MM/DD/YYYY'))
79: AND active_end_date >= p_act_str_dt
80: START WITH location_id = p_loc_id

Line 364: FROM pn_locations_all

360: -- Location ID, Active Start Date, Active End Date are the old values retrived by the query
361:
362: SELECT ROWID
363: INTO l_rowid
364: FROM pn_locations_all
365: WHERE location_id = p_location_id
366: AND active_start_date = p_active_start_date
367: AND active_end_date = NVL(p_active_end_date,g_end_of_time);
368:

Line 369: g_pn_locations_rowid := l_rowid;

365: WHERE location_id = p_location_id
366: AND active_start_date = p_active_start_date
367: AND active_end_date = NVL(p_active_end_date,g_end_of_time);
368:
369: g_pn_locations_rowid := l_rowid;
370:
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372:
373: pnp_debug_pkg.debug(' PntLocnPkg.SetRowid (-) ReturnStatus: '||x_return_status);

Line 414: FROM pn_locations_all

410: l_cascade_cust VARCHAR2(30) := SUBSTR(p_cascade, 4, 1);
411:
412: CURSOR parent_location_cursor IS
413: SELECT *
414: FROM pn_locations_all
415: WHERE location_id = g_loc_recinfo_tmp.parent_location_id
416: AND active_start_date <= g_loc_recinfo_tmp.active_end_date
417: AND active_end_date >= g_loc_recinfo_tmp.active_start_date;
418:

Line 519: p_pn_locations_rec IN pn_locations_all%ROWTYPE

515: -- 21-JAN-2008 acprakas o Bug#6755579: Commented code which sets g_loc_recinfo_tmp.common_area_flag
516: -- to NULL.
517: -------------------------------------------------------------------------------
518: PROCEDURE Correct_Update_Row(
519: p_pn_locations_rec IN pn_locations_all%ROWTYPE
520: ,p_pn_addresses_rec IN pn_addresses_all%ROWTYPE
521: ,p_change_mode IN VARCHAR2
522: ,p_as_of_date IN DATE
523: ,p_active_start_date_old IN DATE

Line 544: FROM pn_locations_all

540: l_as_of_date DATE := NULL;
541:
542: CURSOR location_cursor_old is
543: SELECT *
544: FROM pn_locations_all
545: WHERE location_id = p_pn_locations_rec.location_id
546: AND active_start_date = NVL(p_active_start_date_old, g_start_of_time)
547: AND active_end_date = NVL(p_active_end_date_old, g_end_of_time);
548:

Line 545: WHERE location_id = p_pn_locations_rec.location_id

541:
542: CURSOR location_cursor_old is
543: SELECT *
544: FROM pn_locations_all
545: WHERE location_id = p_pn_locations_rec.location_id
546: AND active_start_date = NVL(p_active_start_date_old, g_start_of_time)
547: AND active_end_date = NVL(p_active_end_date_old, g_end_of_time);
548:
549: BEGIN

Line 554: pnp_debug_pkg.debug(' CorUpdRow=> LocId: '||p_pn_locations_rec.location_id||', LocCd: '||p_pn_locations_rec.location_code

550:
551:
552: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Correct_Update_Row (+) Mode: '||p_change_mode||', Cascade: '||p_cascade
553: ||', AsofDt: '||p_as_of_date);
554: pnp_debug_pkg.debug(' CorUpdRow=> LocId: '||p_pn_locations_rec.location_id||', LocCd: '||p_pn_locations_rec.location_code
555: ||', Type: '||p_pn_locations_rec.location_type_lookup_code
556: ||', StrDt: '||TO_CHAR(p_pn_locations_rec.active_start_date, 'MM/DD/YYYY')
557: ||', EndDt: '||TO_CHAR(p_pn_locations_rec.active_end_date, 'MM/DD/YYYY'));
558:

Line 555: ||', Type: '||p_pn_locations_rec.location_type_lookup_code

551:
552: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Correct_Update_Row (+) Mode: '||p_change_mode||', Cascade: '||p_cascade
553: ||', AsofDt: '||p_as_of_date);
554: pnp_debug_pkg.debug(' CorUpdRow=> LocId: '||p_pn_locations_rec.location_id||', LocCd: '||p_pn_locations_rec.location_code
555: ||', Type: '||p_pn_locations_rec.location_type_lookup_code
556: ||', StrDt: '||TO_CHAR(p_pn_locations_rec.active_start_date, 'MM/DD/YYYY')
557: ||', EndDt: '||TO_CHAR(p_pn_locations_rec.active_end_date, 'MM/DD/YYYY'));
558:
559: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 556: ||', StrDt: '||TO_CHAR(p_pn_locations_rec.active_start_date, 'MM/DD/YYYY')

552: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Correct_Update_Row (+) Mode: '||p_change_mode||', Cascade: '||p_cascade
553: ||', AsofDt: '||p_as_of_date);
554: pnp_debug_pkg.debug(' CorUpdRow=> LocId: '||p_pn_locations_rec.location_id||', LocCd: '||p_pn_locations_rec.location_code
555: ||', Type: '||p_pn_locations_rec.location_type_lookup_code
556: ||', StrDt: '||TO_CHAR(p_pn_locations_rec.active_start_date, 'MM/DD/YYYY')
557: ||', EndDt: '||TO_CHAR(p_pn_locations_rec.active_end_date, 'MM/DD/YYYY'));
558:
559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560:

Line 557: ||', EndDt: '||TO_CHAR(p_pn_locations_rec.active_end_date, 'MM/DD/YYYY'));

553: ||', AsofDt: '||p_as_of_date);
554: pnp_debug_pkg.debug(' CorUpdRow=> LocId: '||p_pn_locations_rec.location_id||', LocCd: '||p_pn_locations_rec.location_code
555: ||', Type: '||p_pn_locations_rec.location_type_lookup_code
556: ||', StrDt: '||TO_CHAR(p_pn_locations_rec.active_start_date, 'MM/DD/YYYY')
557: ||', EndDt: '||TO_CHAR(p_pn_locations_rec.active_end_date, 'MM/DD/YYYY'));
558:
559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560:
561: PNT_LOCATIONS_PKG.SET_ROWID(

Line 562: p_location_id => p_pn_locations_rec.location_id,

558:
559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560:
561: PNT_LOCATIONS_PKG.SET_ROWID(
562: p_location_id => p_pn_locations_rec.location_id,
563: p_active_start_date => p_active_start_date_old,
564: p_active_end_date => p_active_end_date_old,
565: x_return_status => x_return_status,
566: x_return_message => x_return_message);

Line 572: l_str_dt := p_pn_locations_rec.active_start_date;

568: IF ( p_validate) THEN
569: pnp_debug_pkg.put_log_msg('Calling validate_assignable_area');
570:
571: IF p_change_mode = 'CORRECT' THEN
572: l_str_dt := p_pn_locations_rec.active_start_date;
573: l_end_dt := p_pn_locations_rec.active_end_date;
574: ELSIF p_change_mode = 'UPDATE' THEN
575: l_str_dt := p_as_of_date;
576: l_end_dt := p_pn_locations_rec.active_end_date;

Line 573: l_end_dt := p_pn_locations_rec.active_end_date;

569: pnp_debug_pkg.put_log_msg('Calling validate_assignable_area');
570:
571: IF p_change_mode = 'CORRECT' THEN
572: l_str_dt := p_pn_locations_rec.active_start_date;
573: l_end_dt := p_pn_locations_rec.active_end_date;
574: ELSIF p_change_mode = 'UPDATE' THEN
575: l_str_dt := p_as_of_date;
576: l_end_dt := p_pn_locations_rec.active_end_date;
577: END IF;

Line 576: l_end_dt := p_pn_locations_rec.active_end_date;

572: l_str_dt := p_pn_locations_rec.active_start_date;
573: l_end_dt := p_pn_locations_rec.active_end_date;
574: ELSIF p_change_mode = 'UPDATE' THEN
575: l_str_dt := p_as_of_date;
576: l_end_dt := p_pn_locations_rec.active_end_date;
577: END IF;
578:
579: PNP_UTIL_FUNC.Validate_date_assignable_area
580: (p_location_id => p_pn_locations_rec.location_id,

Line 580: (p_location_id => p_pn_locations_rec.location_id,

576: l_end_dt := p_pn_locations_rec.active_end_date;
577: END IF;
578:
579: PNP_UTIL_FUNC.Validate_date_assignable_area
580: (p_location_id => p_pn_locations_rec.location_id,
581: p_location_type => p_pn_locations_rec.location_type_lookup_code,
582: p_start_date => l_str_dt,
583: p_end_date => l_end_dt,
584: p_active_start_date_old => p_active_start_date_old,

Line 581: p_location_type => p_pn_locations_rec.location_type_lookup_code,

577: END IF;
578:
579: PNP_UTIL_FUNC.Validate_date_assignable_area
580: (p_location_id => p_pn_locations_rec.location_id,
581: p_location_type => p_pn_locations_rec.location_type_lookup_code,
582: p_start_date => l_str_dt,
583: p_end_date => l_end_dt,
584: p_active_start_date_old => p_active_start_date_old,
585: p_active_end_date_old => p_active_end_date_old,

Line 587: p_assignable_area => p_pn_locations_rec.assignable_area,

583: p_end_date => l_end_dt,
584: p_active_start_date_old => p_active_start_date_old,
585: p_active_end_date_old => p_active_end_date_old,
586: p_change_mode => p_change_mode,
587: p_assignable_area => p_pn_locations_rec.assignable_area,
588: x_return_status => x_return_status,
589: x_return_message => x_return_message
590: );
591:

Line 600: p_location_id => p_pn_locations_rec.location_id,

596:
597: -- Added redwin Fix for Bug 2722698
598:
599: PNT_LOCATIONS_PKG.update_assignments (
600: p_location_id => p_pn_locations_rec.location_id,
601: p_active_start_date => p_pn_locations_Rec.active_start_date,
602: p_active_end_date => p_pn_locations_rec.active_end_date,
603: p_active_start_date_old => p_active_start_date_old,
604: p_active_end_date_old => p_active_end_date_old,

Line 601: p_active_start_date => p_pn_locations_Rec.active_start_date,

597: -- Added redwin Fix for Bug 2722698
598:
599: PNT_LOCATIONS_PKG.update_assignments (
600: p_location_id => p_pn_locations_rec.location_id,
601: p_active_start_date => p_pn_locations_Rec.active_start_date,
602: p_active_end_date => p_pn_locations_rec.active_end_date,
603: p_active_start_date_old => p_active_start_date_old,
604: p_active_end_date_old => p_active_end_date_old,
605: x_return_status => x_return_status,

Line 602: p_active_end_date => p_pn_locations_rec.active_end_date,

598:
599: PNT_LOCATIONS_PKG.update_assignments (
600: p_location_id => p_pn_locations_rec.location_id,
601: p_active_start_date => p_pn_locations_Rec.active_start_date,
602: p_active_end_date => p_pn_locations_rec.active_end_date,
603: p_active_start_date_old => p_active_start_date_old,
604: p_active_end_date_old => p_active_end_date_old,
605: x_return_status => x_return_status,
606: x_return_message => x_return_message);

Line 616: G_LOC_RECINFO.location_id <> p_pn_locations_rec.location_id OR

612:
613: END IF; -- if p_validate
614:
615: IF G_LOC_RECINFO.location_id IS NULL OR
616: G_LOC_RECINFO.location_id <> p_pn_locations_rec.location_id OR
617: NVL(G_LOC_RECINFO.active_start_date, G_START_OF_TIME)
618: <> NVL(p_active_start_date_old, G_START_OF_TIME) OR
619: NVL(G_LOC_RECINFO.active_end_date, G_END_OF_TIME)
620: <> NVL(p_active_end_date_old, G_END_OF_TIME) THEN

Line 635: nvl(p_pn_locations_rec.active_end_date,G_END_OF_TIME) OR

631:
632: -- The following is called if dates are brought in, then we need to update the children
633:
634: IF G_LOC_RECINFO.active_end_date >
635: nvl(p_pn_locations_rec.active_end_date,G_END_OF_TIME) OR
636: G_LOC_RECINFO.active_start_date
637: < nvl(p_pn_locations_rec.active_start_date,G_START_OF_TIME) THEN
638:
639: PNT_LOCATIONS_PKG.Update_child_for_dates (

Line 637: < nvl(p_pn_locations_rec.active_start_date,G_START_OF_TIME) THEN

633:
634: IF G_LOC_RECINFO.active_end_date >
635: nvl(p_pn_locations_rec.active_end_date,G_END_OF_TIME) OR
636: G_LOC_RECINFO.active_start_date
637: < nvl(p_pn_locations_rec.active_start_date,G_START_OF_TIME) THEN
638:
639: PNT_LOCATIONS_PKG.Update_child_for_dates (
640: p_location_id => p_pn_locations_rec.location_id,
641: p_active_start_date => p_pn_locations_Rec.active_start_date,

Line 640: p_location_id => p_pn_locations_rec.location_id,

636: G_LOC_RECINFO.active_start_date
637: < nvl(p_pn_locations_rec.active_start_date,G_START_OF_TIME) THEN
638:
639: PNT_LOCATIONS_PKG.Update_child_for_dates (
640: p_location_id => p_pn_locations_rec.location_id,
641: p_active_start_date => p_pn_locations_Rec.active_start_date,
642: p_active_end_date => p_pn_locations_rec.active_end_date,
643: p_active_start_date_old => p_active_start_date_old,
644: p_active_end_date_old => p_active_end_date_old,

Line 641: p_active_start_date => p_pn_locations_Rec.active_start_date,

637: < nvl(p_pn_locations_rec.active_start_date,G_START_OF_TIME) THEN
638:
639: PNT_LOCATIONS_PKG.Update_child_for_dates (
640: p_location_id => p_pn_locations_rec.location_id,
641: p_active_start_date => p_pn_locations_Rec.active_start_date,
642: p_active_end_date => p_pn_locations_rec.active_end_date,
643: p_active_start_date_old => p_active_start_date_old,
644: p_active_end_date_old => p_active_end_date_old,
645: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,

Line 642: p_active_end_date => p_pn_locations_rec.active_end_date,

638:
639: PNT_LOCATIONS_PKG.Update_child_for_dates (
640: p_location_id => p_pn_locations_rec.location_id,
641: p_active_start_date => p_pn_locations_Rec.active_start_date,
642: p_active_end_date => p_pn_locations_rec.active_end_date,
643: p_active_start_date_old => p_active_start_date_old,
644: p_active_end_date_old => p_active_end_date_old,
645: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,
646: x_return_status => x_return_status,

Line 645: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,

641: p_active_start_date => p_pn_locations_Rec.active_start_date,
642: p_active_end_date => p_pn_locations_rec.active_end_date,
643: p_active_start_date_old => p_active_start_date_old,
644: p_active_end_date_old => p_active_end_date_old,
645: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,
646: x_return_status => x_return_status,
647: x_return_message => x_return_message);
648:
649: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 668: p_org_id => p_pn_locations_rec.org_id,

664: -- of dates for the same location
665: ------------------------------------------------
666: pnp_debug_pkg.put_log_msg('Calling check_location_overlap');
667: PNT_LOCATIONS_PKG.check_location_overlap (
668: p_org_id => p_pn_locations_rec.org_id,
669: p_location_id => p_pn_locations_rec.location_id,
670: p_location_code => p_pn_locations_rec.location_code,
671: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,
672: p_active_start_date => p_pn_locations_rec.active_start_date,

Line 669: p_location_id => p_pn_locations_rec.location_id,

665: ------------------------------------------------
666: pnp_debug_pkg.put_log_msg('Calling check_location_overlap');
667: PNT_LOCATIONS_PKG.check_location_overlap (
668: p_org_id => p_pn_locations_rec.org_id,
669: p_location_id => p_pn_locations_rec.location_id,
670: p_location_code => p_pn_locations_rec.location_code,
671: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,
672: p_active_start_date => p_pn_locations_rec.active_start_date,
673: p_active_end_date => p_pn_locations_rec.active_end_date,

Line 670: p_location_code => p_pn_locations_rec.location_code,

666: pnp_debug_pkg.put_log_msg('Calling check_location_overlap');
667: PNT_LOCATIONS_PKG.check_location_overlap (
668: p_org_id => p_pn_locations_rec.org_id,
669: p_location_id => p_pn_locations_rec.location_id,
670: p_location_code => p_pn_locations_rec.location_code,
671: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,
672: p_active_start_date => p_pn_locations_rec.active_start_date,
673: p_active_end_date => p_pn_locations_rec.active_end_date,
674: p_active_start_date_old => p_active_start_date_old,

Line 671: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,

667: PNT_LOCATIONS_PKG.check_location_overlap (
668: p_org_id => p_pn_locations_rec.org_id,
669: p_location_id => p_pn_locations_rec.location_id,
670: p_location_code => p_pn_locations_rec.location_code,
671: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,
672: p_active_start_date => p_pn_locations_rec.active_start_date,
673: p_active_end_date => p_pn_locations_rec.active_end_date,
674: p_active_start_date_old => p_active_start_date_old,
675: p_active_end_date_old => p_active_end_date_old,

Line 672: p_active_start_date => p_pn_locations_rec.active_start_date,

668: p_org_id => p_pn_locations_rec.org_id,
669: p_location_id => p_pn_locations_rec.location_id,
670: p_location_code => p_pn_locations_rec.location_code,
671: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,
672: p_active_start_date => p_pn_locations_rec.active_start_date,
673: p_active_end_date => p_pn_locations_rec.active_end_date,
674: p_active_start_date_old => p_active_start_date_old,
675: p_active_end_date_old => p_active_end_date_old,
676: x_return_status => x_return_status,

Line 673: p_active_end_date => p_pn_locations_rec.active_end_date,

669: p_location_id => p_pn_locations_rec.location_id,
670: p_location_code => p_pn_locations_rec.location_code,
671: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,
672: p_active_start_date => p_pn_locations_rec.active_start_date,
673: p_active_end_date => p_pn_locations_rec.active_end_date,
674: p_active_start_date_old => p_active_start_date_old,
675: p_active_end_date_old => p_active_end_date_old,
676: x_return_status => x_return_status,
677: x_return_message => x_return_message);

Line 686: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') THEN

682: x_return_status := FND_API.G_RET_STS_ERROR;
683: APP_EXCEPTION.Raise_Exception;
684: END IF;
685:
686: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') THEN
687: pnp_debug_pkg.put_log_msg('Calling check_location_gaps');
688: PNT_LOCATIONS_PKG.check_location_gaps (
689: p_org_id => p_pn_locations_rec.org_id,
690: p_location_id => p_pn_locations_rec.location_id,

Line 689: p_org_id => p_pn_locations_rec.org_id,

685:
686: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') THEN
687: pnp_debug_pkg.put_log_msg('Calling check_location_gaps');
688: PNT_LOCATIONS_PKG.check_location_gaps (
689: p_org_id => p_pn_locations_rec.org_id,
690: p_location_id => p_pn_locations_rec.location_id,
691: p_location_code => p_pn_locations_rec.location_code,
692: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,
693: p_active_start_date => p_pn_locations_rec.active_start_date,

Line 690: p_location_id => p_pn_locations_rec.location_id,

686: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') THEN
687: pnp_debug_pkg.put_log_msg('Calling check_location_gaps');
688: PNT_LOCATIONS_PKG.check_location_gaps (
689: p_org_id => p_pn_locations_rec.org_id,
690: p_location_id => p_pn_locations_rec.location_id,
691: p_location_code => p_pn_locations_rec.location_code,
692: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,
693: p_active_start_date => p_pn_locations_rec.active_start_date,
694: p_active_end_date => p_pn_locations_rec.active_end_date,

Line 691: p_location_code => p_pn_locations_rec.location_code,

687: pnp_debug_pkg.put_log_msg('Calling check_location_gaps');
688: PNT_LOCATIONS_PKG.check_location_gaps (
689: p_org_id => p_pn_locations_rec.org_id,
690: p_location_id => p_pn_locations_rec.location_id,
691: p_location_code => p_pn_locations_rec.location_code,
692: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,
693: p_active_start_date => p_pn_locations_rec.active_start_date,
694: p_active_end_date => p_pn_locations_rec.active_end_date,
695: p_active_start_date_old => p_active_start_date_old,

Line 692: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,

688: PNT_LOCATIONS_PKG.check_location_gaps (
689: p_org_id => p_pn_locations_rec.org_id,
690: p_location_id => p_pn_locations_rec.location_id,
691: p_location_code => p_pn_locations_rec.location_code,
692: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,
693: p_active_start_date => p_pn_locations_rec.active_start_date,
694: p_active_end_date => p_pn_locations_rec.active_end_date,
695: p_active_start_date_old => p_active_start_date_old,
696: p_active_end_date_old => p_active_end_date_old,

Line 693: p_active_start_date => p_pn_locations_rec.active_start_date,

689: p_org_id => p_pn_locations_rec.org_id,
690: p_location_id => p_pn_locations_rec.location_id,
691: p_location_code => p_pn_locations_rec.location_code,
692: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,
693: p_active_start_date => p_pn_locations_rec.active_start_date,
694: p_active_end_date => p_pn_locations_rec.active_end_date,
695: p_active_start_date_old => p_active_start_date_old,
696: p_active_end_date_old => p_active_end_date_old,
697: x_return_status => x_return_status,

Line 694: p_active_end_date => p_pn_locations_rec.active_end_date,

690: p_location_id => p_pn_locations_rec.location_id,
691: p_location_code => p_pn_locations_rec.location_code,
692: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,
693: p_active_start_date => p_pn_locations_rec.active_start_date,
694: p_active_end_date => p_pn_locations_rec.active_end_date,
695: p_active_start_date_old => p_active_start_date_old,
696: p_active_end_date_old => p_active_end_date_old,
697: x_return_status => x_return_status,
698: x_return_message => x_return_message);

Line 712: g_loc_recinfo_tmp := p_pn_locations_rec;

708: END IF; -- endif for p_validate
709:
710: PNP_DEBUG_PKG.put_log_msg('call update row ');
711:
712: g_loc_recinfo_tmp := p_pn_locations_rec;
713: g_loc_adrinfo_tmp := p_pn_addresses_rec;
714: pnt_locations_pkg.Set_Cascade(p_cascade);
715: pnt_locations_pkg.Update_Locn_Row(
716: p_loc_recinfo => g_loc_recinfo_tmp

Line 728: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') AND

724: x_return_status := FND_API.G_RET_STS_ERROR;
725: APP_EXCEPTION.Raise_Exception;
726: END IF;
727:
728: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') AND
729: LTRIM(RTRIM(p_cascade)) IS NOT NULL THEN
730: pnt_locations_pkg.cascade_child_locn(
731: p_location_id => p_pn_locations_rec.location_id
732: ,p_start_date => p_pn_locations_rec.active_start_date

Line 731: p_location_id => p_pn_locations_rec.location_id

727:
728: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') AND
729: LTRIM(RTRIM(p_cascade)) IS NOT NULL THEN
730: pnt_locations_pkg.cascade_child_locn(
731: p_location_id => p_pn_locations_rec.location_id
732: ,p_start_date => p_pn_locations_rec.active_start_date
733: ,p_end_date => p_pn_locations_rec.active_end_date
734: ,p_cascade => p_cascade
735: ,p_change_mode => p_change_mode

Line 732: ,p_start_date => p_pn_locations_rec.active_start_date

728: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') AND
729: LTRIM(RTRIM(p_cascade)) IS NOT NULL THEN
730: pnt_locations_pkg.cascade_child_locn(
731: p_location_id => p_pn_locations_rec.location_id
732: ,p_start_date => p_pn_locations_rec.active_start_date
733: ,p_end_date => p_pn_locations_rec.active_end_date
734: ,p_cascade => p_cascade
735: ,p_change_mode => p_change_mode
736: ,x_return_status => x_return_status

Line 733: ,p_end_date => p_pn_locations_rec.active_end_date

729: LTRIM(RTRIM(p_cascade)) IS NOT NULL THEN
730: pnt_locations_pkg.cascade_child_locn(
731: p_location_id => p_pn_locations_rec.location_id
732: ,p_start_date => p_pn_locations_rec.active_start_date
733: ,p_end_date => p_pn_locations_rec.active_end_date
734: ,p_cascade => p_cascade
735: ,p_change_mode => p_change_mode
736: ,x_return_status => x_return_status
737: ,x_return_message => x_return_message

Line 749: IF p_pn_locations_rec.active_start_date <> G_LOC_RECINFO.active_start_date THEN

745:
746: l_active_start_date_new := G_LOC_RECINFO.active_start_date;
747: l_active_end_date_new := G_LOC_RECINFO.active_end_date;
748:
749: IF p_pn_locations_rec.active_start_date <> G_LOC_RECINFO.active_start_date THEN
750: -- this means user had changed the start date with update option.
751: l_active_start_date_new := p_pn_locations_rec.active_start_date;
752: END IF;
753: IF p_pn_locations_rec.active_end_date <> G_LOC_RECINFO.active_end_date THEN

Line 751: l_active_start_date_new := p_pn_locations_rec.active_start_date;

747: l_active_end_date_new := G_LOC_RECINFO.active_end_date;
748:
749: IF p_pn_locations_rec.active_start_date <> G_LOC_RECINFO.active_start_date THEN
750: -- this means user had changed the start date with update option.
751: l_active_start_date_new := p_pn_locations_rec.active_start_date;
752: END IF;
753: IF p_pn_locations_rec.active_end_date <> G_LOC_RECINFO.active_end_date THEN
754: -- this means user had changed the start date with update option.
755: l_active_end_date_new := p_pn_locations_rec.active_end_date;

Line 753: IF p_pn_locations_rec.active_end_date <> G_LOC_RECINFO.active_end_date THEN

749: IF p_pn_locations_rec.active_start_date <> G_LOC_RECINFO.active_start_date THEN
750: -- this means user had changed the start date with update option.
751: l_active_start_date_new := p_pn_locations_rec.active_start_date;
752: END IF;
753: IF p_pn_locations_rec.active_end_date <> G_LOC_RECINFO.active_end_date THEN
754: -- this means user had changed the start date with update option.
755: l_active_end_date_new := p_pn_locations_rec.active_end_date;
756: END IF;
757:

Line 755: l_active_end_date_new := p_pn_locations_rec.active_end_date;

751: l_active_start_date_new := p_pn_locations_rec.active_start_date;
752: END IF;
753: IF p_pn_locations_rec.active_end_date <> G_LOC_RECINFO.active_end_date THEN
754: -- this means user had changed the start date with update option.
755: l_active_end_date_new := p_pn_locations_rec.active_end_date;
756: END IF;
757:
758: g_loc_recinfo_tmp := p_pn_locations_rec;
759: g_loc_adrinfo_tmp := p_pn_addresses_rec;

Line 758: g_loc_recinfo_tmp := p_pn_locations_rec;

754: -- this means user had changed the start date with update option.
755: l_active_end_date_new := p_pn_locations_rec.active_end_date;
756: END IF;
757:
758: g_loc_recinfo_tmp := p_pn_locations_rec;
759: g_loc_adrinfo_tmp := p_pn_addresses_rec;
760: g_loc_recinfo_tmp.active_start_date := p_as_of_date;
761: g_loc_recinfo_tmp.active_end_date := l_active_end_date_new;
762: pnt_locations_pkg.Set_Cascade(p_cascade);

Line 799: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') AND

795: x_return_status := FND_API.G_RET_STS_ERROR;
796: APP_EXCEPTION.Raise_Exception;
797: END IF;
798:
799: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') AND
800: LTRIM(RTRIM(p_cascade)) IS NOT NULL THEN
801: pnt_locations_pkg.cascade_child_locn(
802: p_location_id => p_pn_locations_rec.location_id
803: ,p_start_date => p_as_of_date

Line 802: p_location_id => p_pn_locations_rec.location_id

798:
799: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') AND
800: LTRIM(RTRIM(p_cascade)) IS NOT NULL THEN
801: pnt_locations_pkg.cascade_child_locn(
802: p_location_id => p_pn_locations_rec.location_id
803: ,p_start_date => p_as_of_date
804: ,p_end_date => l_active_end_date_new
805: ,p_cascade => p_cascade
806: ,p_change_mode => p_change_mode

Line 857: FROM pn_locations_all

853: l_cascade_cust VARCHAR2(30) := SUBSTR(p_cascade, 4, 1);
854:
855: CURSOR location_cursor IS
856: SELECT *
857: FROM pn_locations_all
858: START WITH ( parent_location_id = p_location_id
859: AND active_start_date <= NVL(p_end_date, TO_DATE('12/31/4712','MM/DD/YYYY'))
860: AND active_end_date >= p_start_date
861: )

Line 879: g_pn_locations_rowid := NULL;

875:
876: FOR locn_rec IN location_cursor
877: LOOP
878: g_loc_recinfo_tmp := NULL;
879: g_pn_locations_rowid := NULL;
880: l_split := 'N';
881: IF l_cascade_occ IN ('Y', 'N') THEN
882: IF locn_rec.occupancy_status_code <> l_cascade_occ OR
883: locn_rec.assignable_emp <> l_cascade_occ OR

Line 1032: FROM pn_locations_all

1028: SELECT 'TRUE'
1029: FROM DUAL
1030: WHERE EXISTS (SELECT NULL
1031: FROM pn_space_assign_cust_all, (SELECT location_id loc_id
1032: FROM pn_locations_all
1033: WHERE active_start_date <= l_end_date
1034: AND active_end_date >= l_str_date
1035: START WITH location_id = p_location_id
1036: CONNECT BY PRIOR location_id = parent_location_id

Line 1050: FROM pn_locations_all

1046: AND cust_assign_start_date <= l_end_date
1047: AND NVL(cust_assign_end_date, TO_DATE('12/31/4712','MM/DD/YYYY')) >= l_str_date)
1048: OR EXISTS (SELECT NULL
1049: FROM pn_space_assign_emp_all, (SELECT location_id loc_id
1050: FROM pn_locations_all
1051: WHERE active_start_date <= l_end_date
1052: AND active_end_date >= l_str_date
1053: START WITH location_id = p_location_id
1054: CONNECT BY PRIOR location_id = parent_location_id

Line 1118: FROM pn_locations_all

1114: CURSOR check_loc_status_csr IS
1115: SELECT 'TRUE'
1116: FROM DUAL
1117: WHERE EXISTS (SELECT NULL
1118: FROM pn_locations_all
1119: WHERE location_id = p_parent_location_id
1120: AND active_start_date <= l_end_date
1121: AND active_end_date >= l_str_date
1122: AND ((p_status_mode IN ('OCC') AND NVL(occupancy_status_code, 'Y') = 'N')

Line 1169: -- from pn_locations_all instead of pn_locations

1165: -- Added parameters occupancy_status_code,
1166: -- assignable_emp, assignable_cc, assignable_cust,
1167: -- disposition, acc_treatment.
1168: -- 28-APR-05 piagrawa o Modified the select statements to retrieve values
1169: -- from pn_locations_all instead of pn_locations
1170: -- Also passed org_id as parameter to
1171: -- PNT_ADDR_PKG.insert_row
1172: -- 19-JUL-05 SatyaDeep o Added argument x_source to insert the source
1173: -- product from pn_locations_itf for bug#4468893

Line 1173: -- product from pn_locations_itf for bug#4468893

1169: -- from pn_locations_all instead of pn_locations
1170: -- Also passed org_id as parameter to
1171: -- PNT_ADDR_PKG.insert_row
1172: -- 19-JUL-05 SatyaDeep o Added argument x_source to insert the source
1173: -- product from pn_locations_itf for bug#4468893
1174: -- 28-NOV-05 pikhar o fetched org_id using cursor
1175: -- 21-AUG-08 rthumma o Bug 7273859 : Modified call to pnt_addr_pkg.insert_row
1176: -- to pass NULL for ATTRIBUTE_CATEGORY,attribute1..15
1177: -------------------------------------------------------------------------------

Line 1287: FROM pn_locations_all

1283: IS
1284:
1285: CURSOR c IS
1286: SELECT ROWID
1287: FROM pn_locations_all
1288: WHERE location_id = x_location_id
1289: AND active_start_date = NVL(x_active_start_date, g_start_of_time)
1290: AND active_end_date = NVL(x_active_end_date, g_end_of_time);
1291:

Line 1402: -- PN_LOCATIONS table. This will only be called when we insert the

1398:
1399: -----------------------------------------------------------------
1400: -- Call the PN_ADDRESSES insert table handler to create an address
1401: -- row and also return the address_id (OUT parameter) for
1402: -- PN_LOCATIONS table. This will only be called when we insert the
1403: -- building record.
1404: -----------------------------------------------------------------
1405:
1406: pnp_debug_pkg.put_log_msg('Calling address insert address =' || x_address_id);

Line 1468: SELECT pn_locations_s.NEXTVAL

1464: -- Allocate the sequence to the primary key loction_id
1465: -- Do not get a new location_id in case of UPDATE
1466: -----------------------------------------------------------------
1467: IF x_change_mode IS NULL and x_location_id is null THEN
1468: SELECT pn_locations_s.NEXTVAL
1469: INTO x_location_id
1470: FROM DUAL;
1471: END IF;
1472:

Line 1475: INSERT INTO pn_locations_all (

1471: END IF;
1472:
1473: pnp_debug_pkg.debug(' InsRow> before insert' || x_change_mode);
1474: BEGIN
1475: INSERT INTO pn_locations_all (
1476: LOCATION_ID
1477: ,LAST_UPDATE_DATE
1478: ,LAST_UPDATED_BY
1479: ,CREATION_DATE

Line 1647: -- product from pn_locations_itf for bug#4468893

1643: -- Added parameters occupancy_status_code,
1644: -- assignable_emp,assignable_cc, assignable_cust,
1645: -- disposition, acc_treatment.
1646: -- 19-JUL-05 SatyaDeep o Added argument x_source to update the source
1647: -- product from pn_locations_itf for bug#4468893
1648: -- 12-SEP-05 Hareesha o Modified update statement to include row_id
1649: -- in Where clause.
1650: -- 27-feb-06 piagrawa o Bug#5015429 - Modified to make a call to
1651: -- loctn_assgn_area_update when x_assgn_area_chgd_flag

Line 1785: UPDATE PN_LOCATIONS_ALL

1781: END IF;
1782:
1783: pnp_debug_pkg.put_log_msg('update locations');
1784:
1785: UPDATE PN_LOCATIONS_ALL
1786: SET
1787: LAST_UPDATE_DATE = x_LAST_UPDATE_DATE
1788: ,LAST_UPDATED_BY = x_LAST_UPDATED_BY
1789: ,LAST_UPDATE_LOGIN = x_LAST_UPDATE_LOGIN

Line 1844: WHERE ROWID = g_pn_locations_rowid;

1840: ,assignable_cust = x_assignable_cust
1841: ,disposition_code = x_disposition_code
1842: ,acc_treatment_code = x_acc_treatment_code
1843: ,source = x_source
1844: WHERE ROWID = g_pn_locations_rowid;
1845:
1846: IF (SQL%NOTFOUND) THEN
1847: RAISE NO_DATA_FOUND;
1848: END IF;

Line 2020: FROM pn_locations_all

2016:
2017:
2018: CURSOR c IS
2019: SELECT *
2020: FROM pn_locations_all
2021: WHERE location_id = x_location_id
2022: AND active_start_date = NVL(x_active_start_date_old, g_start_of_time)
2023: AND active_end_date = NVL(x_active_end_date_old, g_end_of_time)
2024: FOR UPDATE OF location_id NOWAIT;

Line 2438: FROM pn_locations_all

2434: CURSOR check_tenancy IS
2435: SELECT 'Y'
2436: FROM pn_tenancies_all pt
2437: WHERE location_id IN (SELECT location_id
2438: FROM pn_locations_all
2439: WHERE active_start_date > p_active_end_date
2440: START WITH location_id = p_location_id
2441: CONNECT BY PRIOR location_id = parent_location_id)
2442: AND NOT EXISTS (SELECT '1'

Line 2443: FROM pn_locations_all pl1

2439: WHERE active_start_date > p_active_end_date
2440: START WITH location_id = p_location_id
2441: CONNECT BY PRIOR location_id = parent_location_id)
2442: AND NOT EXISTS (SELECT '1'
2443: FROM pn_locations_all pl1
2444: where pl1.location_id = pt.location_id
2445: AND active_start_date <= p_active_end_date)
2446: AND ROWNUM < 2;
2447:

Line 2452: FROM pn_locations_all

2448: CURSOR check_start_tenancy IS
2449: SELECT 'Y'
2450: FROM pn_tenancies_all pt
2451: WHERE location_id IN (SELECT location_id
2452: FROM pn_locations_all
2453: WHERE active_end_date < p_active_start_date
2454: START WITH location_id = p_location_id
2455: CONNECT BY PRIOR location_id = parent_location_id)
2456: AND NOT EXISTS (SELECT '1'

Line 2457: FROM pn_locations_all pl1

2453: WHERE active_end_date < p_active_start_date
2454: START WITH location_id = p_location_id
2455: CONNECT BY PRIOR location_id = parent_location_id)
2456: AND NOT EXISTS (SELECT '1'
2457: FROM pn_locations_all pl1
2458: WHERE pl1.location_id = pt.location_id
2459: AND active_end_date >= p_active_start_date)
2460: AND ROWNUM < 2;
2461:

Line 2488: DELETE FROM pn_locations_all

2484: x_return_status := 'E';
2485: RETURN;
2486: END IF;
2487:
2488: DELETE FROM pn_locations_all
2489: WHERE (location_id, active_start_date,active_end_date) IN
2490: (SELECT location_id, active_start_date,active_end_date
2491: FROM pn_locations_all pl
2492: WHERE active_start_date > p_active_end_date

Line 2491: FROM pn_locations_all pl

2487:
2488: DELETE FROM pn_locations_all
2489: WHERE (location_id, active_start_date,active_end_date) IN
2490: (SELECT location_id, active_start_date,active_end_date
2491: FROM pn_locations_all pl
2492: WHERE active_start_date > p_active_end_date
2493: AND NOT EXISTS (SELECT '1'
2494: FROM pn_space_assign_emp_all
2495: WHERE location_id = pl.location_id

Line 2507: UPDATE pn_locations_all

2503: START WITH location_id = p_location_id
2504: CONNECT BY PRIOR location_id = parent_location_id);
2505:
2506:
2507: UPDATE pn_locations_all
2508: SET active_end_date = p_active_end_date
2509: WHERE active_start_date <= p_active_end_date
2510: AND active_end_date > p_active_end_date
2511: AND location_id IN (SELECT location_id

Line 2512: FROM pn_locations_all

2508: SET active_end_date = p_active_end_date
2509: WHERE active_start_date <= p_active_end_date
2510: AND active_end_date > p_active_end_date
2511: AND location_id IN (SELECT location_id
2512: FROM pn_locations_all
2513: START WITH location_id = p_location_id
2514: CONNECT BY PRIOR location_id = parent_location_id);
2515:
2516: END IF;

Line 2533: DELETE FROM pn_locations_all

2529: x_return_status := 'E';
2530: RETURN;
2531: END IF;
2532:
2533: DELETE FROM pn_locations_all
2534: WHERE (location_id, active_start_date,active_end_date) IN
2535: (SELECT location_id, active_start_date,active_end_date
2536: FROM pn_locations_all pl
2537: WHERE active_end_date < p_active_start_date

Line 2536: FROM pn_locations_all pl

2532:
2533: DELETE FROM pn_locations_all
2534: WHERE (location_id, active_start_date,active_end_date) IN
2535: (SELECT location_id, active_start_date,active_end_date
2536: FROM pn_locations_all pl
2537: WHERE active_end_date < p_active_start_date
2538: AND NOT EXISTS (SELECT '1'
2539: FROM pn_space_assign_emp_all
2540: WHERE location_id = pl.location_id

Line 2551: UPDATE pn_locations_all

2547: AND cust_assign_end_date)
2548: START WITH location_id = p_location_id
2549: CONNECT BY PRIOR location_id = parent_location_id);
2550:
2551: UPDATE pn_locations_all
2552: SET active_start_date = p_active_start_date
2553: WHERE active_start_date < p_active_start_date
2554: AND active_end_date >= p_active_start_date
2555: AND location_id IN (SELECT location_id

Line 2556: FROM pn_locations_all

2552: SET active_start_date = p_active_start_date
2553: WHERE active_start_date < p_active_start_date
2554: AND active_end_date >= p_active_start_date
2555: AND location_id IN (SELECT location_id
2556: FROM pn_locations_all
2557: START WITH location_id = p_location_id
2558: CONNECT BY PRIOR location_id = parent_location_id);
2559:
2560: END IF;

Line 2582: PROCEDURE check_for_popup (p_pn_locations_rec pn_locations_all%rowtype,

2578: -- 01-DEC-2004 Satish Tripathi o Modified for Portfolio Status Enh BUG# 4030816.
2579: -- Added code to condider columns occupancy_status_code, assignable_emp,
2580: -- assignable_cc, assignable_cust.
2581: -------------------------------------------------------------------------------
2582: PROCEDURE check_for_popup (p_pn_locations_rec pn_locations_all%rowtype,
2583: p_start_date_old IN DATE,
2584: p_end_date_old IN DATE,
2585: x_flag OUT NOCOPY VARCHAR2,
2586: x_return_status OUT NOCOPY VARCHAR2,

Line 2591: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_for_popup (+) LocId: '||p_pn_locations_rec.location_id

2587: x_return_message OUT NOCOPY VARCHAR2) IS
2588:
2589: BEGIN
2590:
2591: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_for_popup (+) LocId: '||p_pn_locations_rec.location_id
2592: ||', LocCd: '||p_pn_locations_rec.location_code
2593: ||', Type: '||p_pn_locations_rec.location_type_lookup_code);
2594: x_flag := 'N';
2595:

Line 2592: ||', LocCd: '||p_pn_locations_rec.location_code

2588:
2589: BEGIN
2590:
2591: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_for_popup (+) LocId: '||p_pn_locations_rec.location_id
2592: ||', LocCd: '||p_pn_locations_rec.location_code
2593: ||', Type: '||p_pn_locations_rec.location_type_lookup_code);
2594: x_flag := 'N';
2595:
2596: -- Compare the form field values in p_pn_locations_rec with

Line 2593: ||', Type: '||p_pn_locations_rec.location_type_lookup_code);

2589: BEGIN
2590:
2591: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_for_popup (+) LocId: '||p_pn_locations_rec.location_id
2592: ||', LocCd: '||p_pn_locations_rec.location_code
2593: ||', Type: '||p_pn_locations_rec.location_type_lookup_code);
2594: x_flag := 'N';
2595:
2596: -- Compare the form field values in p_pn_locations_rec with
2597: -- the row locked by the lock_row procedure

Line 2596: -- Compare the form field values in p_pn_locations_rec with

2592: ||', LocCd: '||p_pn_locations_rec.location_code
2593: ||', Type: '||p_pn_locations_rec.location_type_lookup_code);
2594: x_flag := 'N';
2595:
2596: -- Compare the form field values in p_pn_locations_rec with
2597: -- the row locked by the lock_row procedure
2598: -- and return 'Y' if the values are different
2599:
2600: IF ((G_LOC_RECINFO.ATTRIBUTE_CATEGORY <> p_pn_locations_rec.attribute_category)

Line 2600: IF ((G_LOC_RECINFO.ATTRIBUTE_CATEGORY <> p_pn_locations_rec.attribute_category)

2596: -- Compare the form field values in p_pn_locations_rec with
2597: -- the row locked by the lock_row procedure
2598: -- and return 'Y' if the values are different
2599:
2600: IF ((G_LOC_RECINFO.ATTRIBUTE_CATEGORY <> p_pn_locations_rec.attribute_category)
2601: OR ((G_LOC_RECINFO.ATTRIBUTE_CATEGORY is NULL) AND (p_pn_locations_rec.attribute_category is NOT NULL))
2602: OR ((G_LOC_RECINFO.ATTRIBUTE_CATEGORY is NOT NULL) AND (p_pn_locations_rec.attribute_category is NULL))) THEN
2603: x_flag := 'Y';
2604: return;

Line 2601: OR ((G_LOC_RECINFO.ATTRIBUTE_CATEGORY is NULL) AND (p_pn_locations_rec.attribute_category is NOT NULL))

2597: -- the row locked by the lock_row procedure
2598: -- and return 'Y' if the values are different
2599:
2600: IF ((G_LOC_RECINFO.ATTRIBUTE_CATEGORY <> p_pn_locations_rec.attribute_category)
2601: OR ((G_LOC_RECINFO.ATTRIBUTE_CATEGORY is NULL) AND (p_pn_locations_rec.attribute_category is NOT NULL))
2602: OR ((G_LOC_RECINFO.ATTRIBUTE_CATEGORY is NOT NULL) AND (p_pn_locations_rec.attribute_category is NULL))) THEN
2603: x_flag := 'Y';
2604: return;
2605: END IF;

Line 2602: OR ((G_LOC_RECINFO.ATTRIBUTE_CATEGORY is NOT NULL) AND (p_pn_locations_rec.attribute_category is NULL))) THEN

2598: -- and return 'Y' if the values are different
2599:
2600: IF ((G_LOC_RECINFO.ATTRIBUTE_CATEGORY <> p_pn_locations_rec.attribute_category)
2601: OR ((G_LOC_RECINFO.ATTRIBUTE_CATEGORY is NULL) AND (p_pn_locations_rec.attribute_category is NOT NULL))
2602: OR ((G_LOC_RECINFO.ATTRIBUTE_CATEGORY is NOT NULL) AND (p_pn_locations_rec.attribute_category is NULL))) THEN
2603: x_flag := 'Y';
2604: return;
2605: END IF;
2606:

Line 2607: IF ((G_LOC_RECINFO.ATTRIBUTE1 <> p_pn_locations_rec.attribute1)

2603: x_flag := 'Y';
2604: return;
2605: END IF;
2606:
2607: IF ((G_LOC_RECINFO.ATTRIBUTE1 <> p_pn_locations_rec.attribute1)
2608: OR ((G_LOC_RECINFO.ATTRIBUTE1 is NULL) AND (p_pn_locations_rec.attribute1 is NOT NULL))
2609: OR ((G_LOC_RECINFO.ATTRIBUTE1 is NOT NULL) AND (p_pn_locations_rec.attribute1 is NULL))) THEN
2610: x_flag := 'Y';
2611: return;

Line 2608: OR ((G_LOC_RECINFO.ATTRIBUTE1 is NULL) AND (p_pn_locations_rec.attribute1 is NOT NULL))

2604: return;
2605: END IF;
2606:
2607: IF ((G_LOC_RECINFO.ATTRIBUTE1 <> p_pn_locations_rec.attribute1)
2608: OR ((G_LOC_RECINFO.ATTRIBUTE1 is NULL) AND (p_pn_locations_rec.attribute1 is NOT NULL))
2609: OR ((G_LOC_RECINFO.ATTRIBUTE1 is NOT NULL) AND (p_pn_locations_rec.attribute1 is NULL))) THEN
2610: x_flag := 'Y';
2611: return;
2612: END IF;

Line 2609: OR ((G_LOC_RECINFO.ATTRIBUTE1 is NOT NULL) AND (p_pn_locations_rec.attribute1 is NULL))) THEN

2605: END IF;
2606:
2607: IF ((G_LOC_RECINFO.ATTRIBUTE1 <> p_pn_locations_rec.attribute1)
2608: OR ((G_LOC_RECINFO.ATTRIBUTE1 is NULL) AND (p_pn_locations_rec.attribute1 is NOT NULL))
2609: OR ((G_LOC_RECINFO.ATTRIBUTE1 is NOT NULL) AND (p_pn_locations_rec.attribute1 is NULL))) THEN
2610: x_flag := 'Y';
2611: return;
2612: END IF;
2613:

Line 2614: IF ((G_LOC_RECINFO.ATTRIBUTE2 <> p_pn_locations_rec.attribute2)

2610: x_flag := 'Y';
2611: return;
2612: END IF;
2613:
2614: IF ((G_LOC_RECINFO.ATTRIBUTE2 <> p_pn_locations_rec.attribute2)
2615: OR ((G_LOC_RECINFO.ATTRIBUTE2 is NULL) AND (p_pn_locations_rec.attribute2 is NOT NULL))
2616: OR ((G_LOC_RECINFO.ATTRIBUTE2 is NOT NULL) AND (p_pn_locations_rec.attribute2 is NULL))) THEN
2617: x_flag := 'Y';
2618: return;

Line 2615: OR ((G_LOC_RECINFO.ATTRIBUTE2 is NULL) AND (p_pn_locations_rec.attribute2 is NOT NULL))

2611: return;
2612: END IF;
2613:
2614: IF ((G_LOC_RECINFO.ATTRIBUTE2 <> p_pn_locations_rec.attribute2)
2615: OR ((G_LOC_RECINFO.ATTRIBUTE2 is NULL) AND (p_pn_locations_rec.attribute2 is NOT NULL))
2616: OR ((G_LOC_RECINFO.ATTRIBUTE2 is NOT NULL) AND (p_pn_locations_rec.attribute2 is NULL))) THEN
2617: x_flag := 'Y';
2618: return;
2619: END IF;

Line 2616: OR ((G_LOC_RECINFO.ATTRIBUTE2 is NOT NULL) AND (p_pn_locations_rec.attribute2 is NULL))) THEN

2612: END IF;
2613:
2614: IF ((G_LOC_RECINFO.ATTRIBUTE2 <> p_pn_locations_rec.attribute2)
2615: OR ((G_LOC_RECINFO.ATTRIBUTE2 is NULL) AND (p_pn_locations_rec.attribute2 is NOT NULL))
2616: OR ((G_LOC_RECINFO.ATTRIBUTE2 is NOT NULL) AND (p_pn_locations_rec.attribute2 is NULL))) THEN
2617: x_flag := 'Y';
2618: return;
2619: END IF;
2620:

Line 2621: IF ((G_LOC_RECINFO.ATTRIBUTE3 <> p_pn_locations_rec.attribute3)

2617: x_flag := 'Y';
2618: return;
2619: END IF;
2620:
2621: IF ((G_LOC_RECINFO.ATTRIBUTE3 <> p_pn_locations_rec.attribute3)
2622: OR ((G_LOC_RECINFO.ATTRIBUTE3 is NULL) AND (p_pn_locations_rec.attribute3 is NOT NULL))
2623: OR ((G_LOC_RECINFO.ATTRIBUTE3 is NOT NULL) AND (p_pn_locations_rec.attribute3 is NULL))) THEN
2624: x_flag := 'Y';
2625: return;

Line 2622: OR ((G_LOC_RECINFO.ATTRIBUTE3 is NULL) AND (p_pn_locations_rec.attribute3 is NOT NULL))

2618: return;
2619: END IF;
2620:
2621: IF ((G_LOC_RECINFO.ATTRIBUTE3 <> p_pn_locations_rec.attribute3)
2622: OR ((G_LOC_RECINFO.ATTRIBUTE3 is NULL) AND (p_pn_locations_rec.attribute3 is NOT NULL))
2623: OR ((G_LOC_RECINFO.ATTRIBUTE3 is NOT NULL) AND (p_pn_locations_rec.attribute3 is NULL))) THEN
2624: x_flag := 'Y';
2625: return;
2626: END IF;

Line 2623: OR ((G_LOC_RECINFO.ATTRIBUTE3 is NOT NULL) AND (p_pn_locations_rec.attribute3 is NULL))) THEN

2619: END IF;
2620:
2621: IF ((G_LOC_RECINFO.ATTRIBUTE3 <> p_pn_locations_rec.attribute3)
2622: OR ((G_LOC_RECINFO.ATTRIBUTE3 is NULL) AND (p_pn_locations_rec.attribute3 is NOT NULL))
2623: OR ((G_LOC_RECINFO.ATTRIBUTE3 is NOT NULL) AND (p_pn_locations_rec.attribute3 is NULL))) THEN
2624: x_flag := 'Y';
2625: return;
2626: END IF;
2627: IF ((G_LOC_RECINFO.ATTRIBUTE4 <> p_pn_locations_rec.attribute4)

Line 2627: IF ((G_LOC_RECINFO.ATTRIBUTE4 <> p_pn_locations_rec.attribute4)

2623: OR ((G_LOC_RECINFO.ATTRIBUTE3 is NOT NULL) AND (p_pn_locations_rec.attribute3 is NULL))) THEN
2624: x_flag := 'Y';
2625: return;
2626: END IF;
2627: IF ((G_LOC_RECINFO.ATTRIBUTE4 <> p_pn_locations_rec.attribute4)
2628: OR ((G_LOC_RECINFO.ATTRIBUTE4 is NULL) AND (p_pn_locations_rec.attribute4 is NOT NULL))
2629: OR ((G_LOC_RECINFO.ATTRIBUTE4 is NOT NULL) AND (p_pn_locations_rec.attribute4 is NULL))) THEN
2630: x_flag := 'Y';
2631: return;

Line 2628: OR ((G_LOC_RECINFO.ATTRIBUTE4 is NULL) AND (p_pn_locations_rec.attribute4 is NOT NULL))

2624: x_flag := 'Y';
2625: return;
2626: END IF;
2627: IF ((G_LOC_RECINFO.ATTRIBUTE4 <> p_pn_locations_rec.attribute4)
2628: OR ((G_LOC_RECINFO.ATTRIBUTE4 is NULL) AND (p_pn_locations_rec.attribute4 is NOT NULL))
2629: OR ((G_LOC_RECINFO.ATTRIBUTE4 is NOT NULL) AND (p_pn_locations_rec.attribute4 is NULL))) THEN
2630: x_flag := 'Y';
2631: return;
2632: END IF;

Line 2629: OR ((G_LOC_RECINFO.ATTRIBUTE4 is NOT NULL) AND (p_pn_locations_rec.attribute4 is NULL))) THEN

2625: return;
2626: END IF;
2627: IF ((G_LOC_RECINFO.ATTRIBUTE4 <> p_pn_locations_rec.attribute4)
2628: OR ((G_LOC_RECINFO.ATTRIBUTE4 is NULL) AND (p_pn_locations_rec.attribute4 is NOT NULL))
2629: OR ((G_LOC_RECINFO.ATTRIBUTE4 is NOT NULL) AND (p_pn_locations_rec.attribute4 is NULL))) THEN
2630: x_flag := 'Y';
2631: return;
2632: END IF;
2633: IF ((G_LOC_RECINFO.ATTRIBUTE5 <> p_pn_locations_rec.attribute5)

Line 2633: IF ((G_LOC_RECINFO.ATTRIBUTE5 <> p_pn_locations_rec.attribute5)

2629: OR ((G_LOC_RECINFO.ATTRIBUTE4 is NOT NULL) AND (p_pn_locations_rec.attribute4 is NULL))) THEN
2630: x_flag := 'Y';
2631: return;
2632: END IF;
2633: IF ((G_LOC_RECINFO.ATTRIBUTE5 <> p_pn_locations_rec.attribute5)
2634: OR ((G_LOC_RECINFO.ATTRIBUTE5 is NULL) AND (p_pn_locations_rec.attribute5 is NOT NULL))
2635: OR ((G_LOC_RECINFO.ATTRIBUTE5 is NOT NULL) AND (p_pn_locations_rec.attribute5 is NULL))) THEN
2636: x_flag := 'Y';
2637: return;

Line 2634: OR ((G_LOC_RECINFO.ATTRIBUTE5 is NULL) AND (p_pn_locations_rec.attribute5 is NOT NULL))

2630: x_flag := 'Y';
2631: return;
2632: END IF;
2633: IF ((G_LOC_RECINFO.ATTRIBUTE5 <> p_pn_locations_rec.attribute5)
2634: OR ((G_LOC_RECINFO.ATTRIBUTE5 is NULL) AND (p_pn_locations_rec.attribute5 is NOT NULL))
2635: OR ((G_LOC_RECINFO.ATTRIBUTE5 is NOT NULL) AND (p_pn_locations_rec.attribute5 is NULL))) THEN
2636: x_flag := 'Y';
2637: return;
2638: END IF;

Line 2635: OR ((G_LOC_RECINFO.ATTRIBUTE5 is NOT NULL) AND (p_pn_locations_rec.attribute5 is NULL))) THEN

2631: return;
2632: END IF;
2633: IF ((G_LOC_RECINFO.ATTRIBUTE5 <> p_pn_locations_rec.attribute5)
2634: OR ((G_LOC_RECINFO.ATTRIBUTE5 is NULL) AND (p_pn_locations_rec.attribute5 is NOT NULL))
2635: OR ((G_LOC_RECINFO.ATTRIBUTE5 is NOT NULL) AND (p_pn_locations_rec.attribute5 is NULL))) THEN
2636: x_flag := 'Y';
2637: return;
2638: END IF;
2639: IF ((G_LOC_RECINFO.ATTRIBUTE6 <> p_pn_locations_rec.attribute6)

Line 2639: IF ((G_LOC_RECINFO.ATTRIBUTE6 <> p_pn_locations_rec.attribute6)

2635: OR ((G_LOC_RECINFO.ATTRIBUTE5 is NOT NULL) AND (p_pn_locations_rec.attribute5 is NULL))) THEN
2636: x_flag := 'Y';
2637: return;
2638: END IF;
2639: IF ((G_LOC_RECINFO.ATTRIBUTE6 <> p_pn_locations_rec.attribute6)
2640: OR ((G_LOC_RECINFO.ATTRIBUTE6 is NULL) AND (p_pn_locations_rec.attribute6 is NOT NULL))
2641: OR ((G_LOC_RECINFO.ATTRIBUTE6 is NOT NULL) AND (p_pn_locations_rec.attribute6 is NULL))) THEN
2642: x_flag := 'Y';
2643: return;

Line 2640: OR ((G_LOC_RECINFO.ATTRIBUTE6 is NULL) AND (p_pn_locations_rec.attribute6 is NOT NULL))

2636: x_flag := 'Y';
2637: return;
2638: END IF;
2639: IF ((G_LOC_RECINFO.ATTRIBUTE6 <> p_pn_locations_rec.attribute6)
2640: OR ((G_LOC_RECINFO.ATTRIBUTE6 is NULL) AND (p_pn_locations_rec.attribute6 is NOT NULL))
2641: OR ((G_LOC_RECINFO.ATTRIBUTE6 is NOT NULL) AND (p_pn_locations_rec.attribute6 is NULL))) THEN
2642: x_flag := 'Y';
2643: return;
2644: END IF;

Line 2641: OR ((G_LOC_RECINFO.ATTRIBUTE6 is NOT NULL) AND (p_pn_locations_rec.attribute6 is NULL))) THEN

2637: return;
2638: END IF;
2639: IF ((G_LOC_RECINFO.ATTRIBUTE6 <> p_pn_locations_rec.attribute6)
2640: OR ((G_LOC_RECINFO.ATTRIBUTE6 is NULL) AND (p_pn_locations_rec.attribute6 is NOT NULL))
2641: OR ((G_LOC_RECINFO.ATTRIBUTE6 is NOT NULL) AND (p_pn_locations_rec.attribute6 is NULL))) THEN
2642: x_flag := 'Y';
2643: return;
2644: END IF;
2645: IF ((G_LOC_RECINFO.ATTRIBUTE7 <> p_pn_locations_rec.attribute7)

Line 2645: IF ((G_LOC_RECINFO.ATTRIBUTE7 <> p_pn_locations_rec.attribute7)

2641: OR ((G_LOC_RECINFO.ATTRIBUTE6 is NOT NULL) AND (p_pn_locations_rec.attribute6 is NULL))) THEN
2642: x_flag := 'Y';
2643: return;
2644: END IF;
2645: IF ((G_LOC_RECINFO.ATTRIBUTE7 <> p_pn_locations_rec.attribute7)
2646: OR ((G_LOC_RECINFO.ATTRIBUTE7 is NULL) AND (p_pn_locations_rec.attribute7 is NOT NULL))
2647: OR ((G_LOC_RECINFO.ATTRIBUTE7 is NOT NULL) AND (p_pn_locations_rec.attribute7 is NULL))) THEN
2648: x_flag := 'Y';
2649: return;

Line 2646: OR ((G_LOC_RECINFO.ATTRIBUTE7 is NULL) AND (p_pn_locations_rec.attribute7 is NOT NULL))

2642: x_flag := 'Y';
2643: return;
2644: END IF;
2645: IF ((G_LOC_RECINFO.ATTRIBUTE7 <> p_pn_locations_rec.attribute7)
2646: OR ((G_LOC_RECINFO.ATTRIBUTE7 is NULL) AND (p_pn_locations_rec.attribute7 is NOT NULL))
2647: OR ((G_LOC_RECINFO.ATTRIBUTE7 is NOT NULL) AND (p_pn_locations_rec.attribute7 is NULL))) THEN
2648: x_flag := 'Y';
2649: return;
2650: END IF;

Line 2647: OR ((G_LOC_RECINFO.ATTRIBUTE7 is NOT NULL) AND (p_pn_locations_rec.attribute7 is NULL))) THEN

2643: return;
2644: END IF;
2645: IF ((G_LOC_RECINFO.ATTRIBUTE7 <> p_pn_locations_rec.attribute7)
2646: OR ((G_LOC_RECINFO.ATTRIBUTE7 is NULL) AND (p_pn_locations_rec.attribute7 is NOT NULL))
2647: OR ((G_LOC_RECINFO.ATTRIBUTE7 is NOT NULL) AND (p_pn_locations_rec.attribute7 is NULL))) THEN
2648: x_flag := 'Y';
2649: return;
2650: END IF;
2651: IF ((G_LOC_RECINFO.ATTRIBUTE8 <> p_pn_locations_rec.attribute8)

Line 2651: IF ((G_LOC_RECINFO.ATTRIBUTE8 <> p_pn_locations_rec.attribute8)

2647: OR ((G_LOC_RECINFO.ATTRIBUTE7 is NOT NULL) AND (p_pn_locations_rec.attribute7 is NULL))) THEN
2648: x_flag := 'Y';
2649: return;
2650: END IF;
2651: IF ((G_LOC_RECINFO.ATTRIBUTE8 <> p_pn_locations_rec.attribute8)
2652: OR ((G_LOC_RECINFO.ATTRIBUTE8 is NULL) AND (p_pn_locations_rec.attribute8 is NOT NULL))
2653: OR ((G_LOC_RECINFO.ATTRIBUTE8 is NOT NULL) AND (p_pn_locations_rec.attribute8 is NULL))) THEN
2654: x_flag := 'Y';
2655: return;

Line 2652: OR ((G_LOC_RECINFO.ATTRIBUTE8 is NULL) AND (p_pn_locations_rec.attribute8 is NOT NULL))

2648: x_flag := 'Y';
2649: return;
2650: END IF;
2651: IF ((G_LOC_RECINFO.ATTRIBUTE8 <> p_pn_locations_rec.attribute8)
2652: OR ((G_LOC_RECINFO.ATTRIBUTE8 is NULL) AND (p_pn_locations_rec.attribute8 is NOT NULL))
2653: OR ((G_LOC_RECINFO.ATTRIBUTE8 is NOT NULL) AND (p_pn_locations_rec.attribute8 is NULL))) THEN
2654: x_flag := 'Y';
2655: return;
2656: END IF;

Line 2653: OR ((G_LOC_RECINFO.ATTRIBUTE8 is NOT NULL) AND (p_pn_locations_rec.attribute8 is NULL))) THEN

2649: return;
2650: END IF;
2651: IF ((G_LOC_RECINFO.ATTRIBUTE8 <> p_pn_locations_rec.attribute8)
2652: OR ((G_LOC_RECINFO.ATTRIBUTE8 is NULL) AND (p_pn_locations_rec.attribute8 is NOT NULL))
2653: OR ((G_LOC_RECINFO.ATTRIBUTE8 is NOT NULL) AND (p_pn_locations_rec.attribute8 is NULL))) THEN
2654: x_flag := 'Y';
2655: return;
2656: END IF;
2657: IF ((G_LOC_RECINFO.ATTRIBUTE9 <> p_pn_locations_rec.attribute9)

Line 2657: IF ((G_LOC_RECINFO.ATTRIBUTE9 <> p_pn_locations_rec.attribute9)

2653: OR ((G_LOC_RECINFO.ATTRIBUTE8 is NOT NULL) AND (p_pn_locations_rec.attribute8 is NULL))) THEN
2654: x_flag := 'Y';
2655: return;
2656: END IF;
2657: IF ((G_LOC_RECINFO.ATTRIBUTE9 <> p_pn_locations_rec.attribute9)
2658: OR ((G_LOC_RECINFO.ATTRIBUTE9 is NULL) AND (p_pn_locations_rec.attribute9 is NOT NULL))
2659: OR ((G_LOC_RECINFO.ATTRIBUTE9 is NOT NULL) AND (p_pn_locations_rec.attribute9 is NULL))) THEN
2660: x_flag := 'Y';
2661: return;

Line 2658: OR ((G_LOC_RECINFO.ATTRIBUTE9 is NULL) AND (p_pn_locations_rec.attribute9 is NOT NULL))

2654: x_flag := 'Y';
2655: return;
2656: END IF;
2657: IF ((G_LOC_RECINFO.ATTRIBUTE9 <> p_pn_locations_rec.attribute9)
2658: OR ((G_LOC_RECINFO.ATTRIBUTE9 is NULL) AND (p_pn_locations_rec.attribute9 is NOT NULL))
2659: OR ((G_LOC_RECINFO.ATTRIBUTE9 is NOT NULL) AND (p_pn_locations_rec.attribute9 is NULL))) THEN
2660: x_flag := 'Y';
2661: return;
2662: END IF;

Line 2659: OR ((G_LOC_RECINFO.ATTRIBUTE9 is NOT NULL) AND (p_pn_locations_rec.attribute9 is NULL))) THEN

2655: return;
2656: END IF;
2657: IF ((G_LOC_RECINFO.ATTRIBUTE9 <> p_pn_locations_rec.attribute9)
2658: OR ((G_LOC_RECINFO.ATTRIBUTE9 is NULL) AND (p_pn_locations_rec.attribute9 is NOT NULL))
2659: OR ((G_LOC_RECINFO.ATTRIBUTE9 is NOT NULL) AND (p_pn_locations_rec.attribute9 is NULL))) THEN
2660: x_flag := 'Y';
2661: return;
2662: END IF;
2663: IF ((G_LOC_RECINFO.ATTRIBUTE10 <> p_pn_locations_rec.attribute10)

Line 2663: IF ((G_LOC_RECINFO.ATTRIBUTE10 <> p_pn_locations_rec.attribute10)

2659: OR ((G_LOC_RECINFO.ATTRIBUTE9 is NOT NULL) AND (p_pn_locations_rec.attribute9 is NULL))) THEN
2660: x_flag := 'Y';
2661: return;
2662: END IF;
2663: IF ((G_LOC_RECINFO.ATTRIBUTE10 <> p_pn_locations_rec.attribute10)
2664: OR ((G_LOC_RECINFO.ATTRIBUTE10 is NULL) AND (p_pn_locations_rec.attribute10 is NOT NULL))
2665: OR ((G_LOC_RECINFO.ATTRIBUTE10 is NOT NULL) AND (p_pn_locations_rec.attribute10 is NULL))) THEN
2666: x_flag := 'Y';
2667: return;

Line 2664: OR ((G_LOC_RECINFO.ATTRIBUTE10 is NULL) AND (p_pn_locations_rec.attribute10 is NOT NULL))

2660: x_flag := 'Y';
2661: return;
2662: END IF;
2663: IF ((G_LOC_RECINFO.ATTRIBUTE10 <> p_pn_locations_rec.attribute10)
2664: OR ((G_LOC_RECINFO.ATTRIBUTE10 is NULL) AND (p_pn_locations_rec.attribute10 is NOT NULL))
2665: OR ((G_LOC_RECINFO.ATTRIBUTE10 is NOT NULL) AND (p_pn_locations_rec.attribute10 is NULL))) THEN
2666: x_flag := 'Y';
2667: return;
2668: END IF;

Line 2665: OR ((G_LOC_RECINFO.ATTRIBUTE10 is NOT NULL) AND (p_pn_locations_rec.attribute10 is NULL))) THEN

2661: return;
2662: END IF;
2663: IF ((G_LOC_RECINFO.ATTRIBUTE10 <> p_pn_locations_rec.attribute10)
2664: OR ((G_LOC_RECINFO.ATTRIBUTE10 is NULL) AND (p_pn_locations_rec.attribute10 is NOT NULL))
2665: OR ((G_LOC_RECINFO.ATTRIBUTE10 is NOT NULL) AND (p_pn_locations_rec.attribute10 is NULL))) THEN
2666: x_flag := 'Y';
2667: return;
2668: END IF;
2669: IF ((G_LOC_RECINFO.ATTRIBUTE11 <> p_pn_locations_rec.attribute11)

Line 2669: IF ((G_LOC_RECINFO.ATTRIBUTE11 <> p_pn_locations_rec.attribute11)

2665: OR ((G_LOC_RECINFO.ATTRIBUTE10 is NOT NULL) AND (p_pn_locations_rec.attribute10 is NULL))) THEN
2666: x_flag := 'Y';
2667: return;
2668: END IF;
2669: IF ((G_LOC_RECINFO.ATTRIBUTE11 <> p_pn_locations_rec.attribute11)
2670: OR ((G_LOC_RECINFO.ATTRIBUTE11 is NULL) AND (p_pn_locations_rec.attribute11 is NOT NULL))
2671: OR ((G_LOC_RECINFO.ATTRIBUTE11 is NOT NULL) AND (p_pn_locations_rec.attribute11 is NULL))) THEN
2672: x_flag := 'Y';
2673: return;

Line 2670: OR ((G_LOC_RECINFO.ATTRIBUTE11 is NULL) AND (p_pn_locations_rec.attribute11 is NOT NULL))

2666: x_flag := 'Y';
2667: return;
2668: END IF;
2669: IF ((G_LOC_RECINFO.ATTRIBUTE11 <> p_pn_locations_rec.attribute11)
2670: OR ((G_LOC_RECINFO.ATTRIBUTE11 is NULL) AND (p_pn_locations_rec.attribute11 is NOT NULL))
2671: OR ((G_LOC_RECINFO.ATTRIBUTE11 is NOT NULL) AND (p_pn_locations_rec.attribute11 is NULL))) THEN
2672: x_flag := 'Y';
2673: return;
2674: END IF;

Line 2671: OR ((G_LOC_RECINFO.ATTRIBUTE11 is NOT NULL) AND (p_pn_locations_rec.attribute11 is NULL))) THEN

2667: return;
2668: END IF;
2669: IF ((G_LOC_RECINFO.ATTRIBUTE11 <> p_pn_locations_rec.attribute11)
2670: OR ((G_LOC_RECINFO.ATTRIBUTE11 is NULL) AND (p_pn_locations_rec.attribute11 is NOT NULL))
2671: OR ((G_LOC_RECINFO.ATTRIBUTE11 is NOT NULL) AND (p_pn_locations_rec.attribute11 is NULL))) THEN
2672: x_flag := 'Y';
2673: return;
2674: END IF;
2675: IF ((G_LOC_RECINFO.ATTRIBUTE12 <> p_pn_locations_rec.attribute12)

Line 2675: IF ((G_LOC_RECINFO.ATTRIBUTE12 <> p_pn_locations_rec.attribute12)

2671: OR ((G_LOC_RECINFO.ATTRIBUTE11 is NOT NULL) AND (p_pn_locations_rec.attribute11 is NULL))) THEN
2672: x_flag := 'Y';
2673: return;
2674: END IF;
2675: IF ((G_LOC_RECINFO.ATTRIBUTE12 <> p_pn_locations_rec.attribute12)
2676: OR ((G_LOC_RECINFO.ATTRIBUTE12 is NULL) AND (p_pn_locations_rec.attribute12 is NOT NULL))
2677: OR ((G_LOC_RECINFO.ATTRIBUTE12 is NOT NULL) AND (p_pn_locations_rec.attribute12 is NULL))) THEN
2678: x_flag := 'Y';
2679: return;

Line 2676: OR ((G_LOC_RECINFO.ATTRIBUTE12 is NULL) AND (p_pn_locations_rec.attribute12 is NOT NULL))

2672: x_flag := 'Y';
2673: return;
2674: END IF;
2675: IF ((G_LOC_RECINFO.ATTRIBUTE12 <> p_pn_locations_rec.attribute12)
2676: OR ((G_LOC_RECINFO.ATTRIBUTE12 is NULL) AND (p_pn_locations_rec.attribute12 is NOT NULL))
2677: OR ((G_LOC_RECINFO.ATTRIBUTE12 is NOT NULL) AND (p_pn_locations_rec.attribute12 is NULL))) THEN
2678: x_flag := 'Y';
2679: return;
2680: END IF;

Line 2677: OR ((G_LOC_RECINFO.ATTRIBUTE12 is NOT NULL) AND (p_pn_locations_rec.attribute12 is NULL))) THEN

2673: return;
2674: END IF;
2675: IF ((G_LOC_RECINFO.ATTRIBUTE12 <> p_pn_locations_rec.attribute12)
2676: OR ((G_LOC_RECINFO.ATTRIBUTE12 is NULL) AND (p_pn_locations_rec.attribute12 is NOT NULL))
2677: OR ((G_LOC_RECINFO.ATTRIBUTE12 is NOT NULL) AND (p_pn_locations_rec.attribute12 is NULL))) THEN
2678: x_flag := 'Y';
2679: return;
2680: END IF;
2681: IF ((G_LOC_RECINFO.ATTRIBUTE13 <> p_pn_locations_rec.attribute13)

Line 2681: IF ((G_LOC_RECINFO.ATTRIBUTE13 <> p_pn_locations_rec.attribute13)

2677: OR ((G_LOC_RECINFO.ATTRIBUTE12 is NOT NULL) AND (p_pn_locations_rec.attribute12 is NULL))) THEN
2678: x_flag := 'Y';
2679: return;
2680: END IF;
2681: IF ((G_LOC_RECINFO.ATTRIBUTE13 <> p_pn_locations_rec.attribute13)
2682: OR ((G_LOC_RECINFO.ATTRIBUTE13 is NULL) AND (p_pn_locations_rec.attribute13 is NOT NULL))
2683: OR ((G_LOC_RECINFO.ATTRIBUTE13 is NOT NULL) AND (p_pn_locations_rec.attribute13 is NULL))) THEN
2684: x_flag := 'Y';
2685: return;

Line 2682: OR ((G_LOC_RECINFO.ATTRIBUTE13 is NULL) AND (p_pn_locations_rec.attribute13 is NOT NULL))

2678: x_flag := 'Y';
2679: return;
2680: END IF;
2681: IF ((G_LOC_RECINFO.ATTRIBUTE13 <> p_pn_locations_rec.attribute13)
2682: OR ((G_LOC_RECINFO.ATTRIBUTE13 is NULL) AND (p_pn_locations_rec.attribute13 is NOT NULL))
2683: OR ((G_LOC_RECINFO.ATTRIBUTE13 is NOT NULL) AND (p_pn_locations_rec.attribute13 is NULL))) THEN
2684: x_flag := 'Y';
2685: return;
2686: END IF;

Line 2683: OR ((G_LOC_RECINFO.ATTRIBUTE13 is NOT NULL) AND (p_pn_locations_rec.attribute13 is NULL))) THEN

2679: return;
2680: END IF;
2681: IF ((G_LOC_RECINFO.ATTRIBUTE13 <> p_pn_locations_rec.attribute13)
2682: OR ((G_LOC_RECINFO.ATTRIBUTE13 is NULL) AND (p_pn_locations_rec.attribute13 is NOT NULL))
2683: OR ((G_LOC_RECINFO.ATTRIBUTE13 is NOT NULL) AND (p_pn_locations_rec.attribute13 is NULL))) THEN
2684: x_flag := 'Y';
2685: return;
2686: END IF;
2687: IF ((G_LOC_RECINFO.ATTRIBUTE14 <> p_pn_locations_rec.attribute14)

Line 2687: IF ((G_LOC_RECINFO.ATTRIBUTE14 <> p_pn_locations_rec.attribute14)

2683: OR ((G_LOC_RECINFO.ATTRIBUTE13 is NOT NULL) AND (p_pn_locations_rec.attribute13 is NULL))) THEN
2684: x_flag := 'Y';
2685: return;
2686: END IF;
2687: IF ((G_LOC_RECINFO.ATTRIBUTE14 <> p_pn_locations_rec.attribute14)
2688: OR ((G_LOC_RECINFO.ATTRIBUTE14 is NULL) AND (p_pn_locations_rec.attribute14 is NOT NULL))
2689: OR ((G_LOC_RECINFO.ATTRIBUTE14 is NOT NULL) AND (p_pn_locations_rec.attribute14 is NULL))) THEN
2690: x_flag := 'Y';
2691: return;

Line 2688: OR ((G_LOC_RECINFO.ATTRIBUTE14 is NULL) AND (p_pn_locations_rec.attribute14 is NOT NULL))

2684: x_flag := 'Y';
2685: return;
2686: END IF;
2687: IF ((G_LOC_RECINFO.ATTRIBUTE14 <> p_pn_locations_rec.attribute14)
2688: OR ((G_LOC_RECINFO.ATTRIBUTE14 is NULL) AND (p_pn_locations_rec.attribute14 is NOT NULL))
2689: OR ((G_LOC_RECINFO.ATTRIBUTE14 is NOT NULL) AND (p_pn_locations_rec.attribute14 is NULL))) THEN
2690: x_flag := 'Y';
2691: return;
2692: END IF;

Line 2689: OR ((G_LOC_RECINFO.ATTRIBUTE14 is NOT NULL) AND (p_pn_locations_rec.attribute14 is NULL))) THEN

2685: return;
2686: END IF;
2687: IF ((G_LOC_RECINFO.ATTRIBUTE14 <> p_pn_locations_rec.attribute14)
2688: OR ((G_LOC_RECINFO.ATTRIBUTE14 is NULL) AND (p_pn_locations_rec.attribute14 is NOT NULL))
2689: OR ((G_LOC_RECINFO.ATTRIBUTE14 is NOT NULL) AND (p_pn_locations_rec.attribute14 is NULL))) THEN
2690: x_flag := 'Y';
2691: return;
2692: END IF;
2693: IF ((G_LOC_RECINFO.ATTRIBUTE15 <> p_pn_locations_rec.attribute15)

Line 2693: IF ((G_LOC_RECINFO.ATTRIBUTE15 <> p_pn_locations_rec.attribute15)

2689: OR ((G_LOC_RECINFO.ATTRIBUTE14 is NOT NULL) AND (p_pn_locations_rec.attribute14 is NULL))) THEN
2690: x_flag := 'Y';
2691: return;
2692: END IF;
2693: IF ((G_LOC_RECINFO.ATTRIBUTE15 <> p_pn_locations_rec.attribute15)
2694: OR ((G_LOC_RECINFO.ATTRIBUTE15 is NULL) AND (p_pn_locations_rec.attribute15 is NOT NULL))
2695: OR ((G_LOC_RECINFO.ATTRIBUTE15 is NOT NULL) AND (p_pn_locations_rec.attribute15 is NULL))) THEN
2696: x_flag := 'Y';
2697: return;

Line 2694: OR ((G_LOC_RECINFO.ATTRIBUTE15 is NULL) AND (p_pn_locations_rec.attribute15 is NOT NULL))

2690: x_flag := 'Y';
2691: return;
2692: END IF;
2693: IF ((G_LOC_RECINFO.ATTRIBUTE15 <> p_pn_locations_rec.attribute15)
2694: OR ((G_LOC_RECINFO.ATTRIBUTE15 is NULL) AND (p_pn_locations_rec.attribute15 is NOT NULL))
2695: OR ((G_LOC_RECINFO.ATTRIBUTE15 is NOT NULL) AND (p_pn_locations_rec.attribute15 is NULL))) THEN
2696: x_flag := 'Y';
2697: return;
2698: END IF;

Line 2695: OR ((G_LOC_RECINFO.ATTRIBUTE15 is NOT NULL) AND (p_pn_locations_rec.attribute15 is NULL))) THEN

2691: return;
2692: END IF;
2693: IF ((G_LOC_RECINFO.ATTRIBUTE15 <> p_pn_locations_rec.attribute15)
2694: OR ((G_LOC_RECINFO.ATTRIBUTE15 is NULL) AND (p_pn_locations_rec.attribute15 is NOT NULL))
2695: OR ((G_LOC_RECINFO.ATTRIBUTE15 is NOT NULL) AND (p_pn_locations_rec.attribute15 is NULL))) THEN
2696: x_flag := 'Y';
2697: return;
2698: END IF;
2699:

Line 2700: IF NOT ((nvl(G_LOC_RECINFO.COMMON_AREA_FLAG,'x') = p_pn_locations_rec.COMMON_AREA_FLAG)

2696: x_flag := 'Y';
2697: return;
2698: END IF;
2699:
2700: IF NOT ((nvl(G_LOC_RECINFO.COMMON_AREA_FLAG,'x') = p_pn_locations_rec.COMMON_AREA_FLAG)
2701: OR ((G_LOC_RECINFO.COMMON_AREA_FLAG is null) AND (p_pn_locations_rec.COMMON_AREA_FLAG is null))) THEN
2702: x_flag := 'Y';
2703: return;
2704: END IF;

Line 2701: OR ((G_LOC_RECINFO.COMMON_AREA_FLAG is null) AND (p_pn_locations_rec.COMMON_AREA_FLAG is null))) THEN

2697: return;
2698: END IF;
2699:
2700: IF NOT ((nvl(G_LOC_RECINFO.COMMON_AREA_FLAG,'x') = p_pn_locations_rec.COMMON_AREA_FLAG)
2701: OR ((G_LOC_RECINFO.COMMON_AREA_FLAG is null) AND (p_pn_locations_rec.COMMON_AREA_FLAG is null))) THEN
2702: x_flag := 'Y';
2703: return;
2704: END IF;
2705:

Line 2706: IF NOT (nvl(G_LOC_RECINFO.LOCATION_TYPE_LOOKUP_CODE,'x') = p_pn_locations_rec.LOCATION_TYPE_LOOKUP_CODE) THEN

2702: x_flag := 'Y';
2703: return;
2704: END IF;
2705:
2706: IF NOT (nvl(G_LOC_RECINFO.LOCATION_TYPE_LOOKUP_CODE,'x') = p_pn_locations_rec.LOCATION_TYPE_LOOKUP_CODE) THEN
2707: x_flag := 'Y';
2708: return;
2709: END IF;
2710:

Line 2711: IF ((G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE <> p_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE)

2707: x_flag := 'Y';
2708: return;
2709: END IF;
2710:
2711: IF ((G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE <> p_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE)
2712: OR ((G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE is NULL) AND (p_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE is NOT NULL))
2713: OR ((G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE is NOT NULL) AND (p_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE is NULL))) THEN
2714: x_flag := 'Y';
2715: return;

Line 2712: OR ((G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE is NULL) AND (p_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE is NOT NULL))

2708: return;
2709: END IF;
2710:
2711: IF ((G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE <> p_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE)
2712: OR ((G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE is NULL) AND (p_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE is NOT NULL))
2713: OR ((G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE is NOT NULL) AND (p_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE is NULL))) THEN
2714: x_flag := 'Y';
2715: return;
2716: END IF;

Line 2713: OR ((G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE is NOT NULL) AND (p_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE is NULL))) THEN

2709: END IF;
2710:
2711: IF ((G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE <> p_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE)
2712: OR ((G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE is NULL) AND (p_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE is NOT NULL))
2713: OR ((G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE is NOT NULL) AND (p_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE is NULL))) THEN
2714: x_flag := 'Y';
2715: return;
2716: END IF;
2717:

Line 2718: IF ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE <> p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE)

2714: x_flag := 'Y';
2715: return;
2716: END IF;
2717:
2718: IF ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE <> p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE)
2719: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is NULL) AND (p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE is NOT NULL))
2720: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is NOT NULL) AND (p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE is NULL))) THEN
2721: x_flag := 'Y';
2722: return;

Line 2719: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is NULL) AND (p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE is NOT NULL))

2715: return;
2716: END IF;
2717:
2718: IF ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE <> p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE)
2719: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is NULL) AND (p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE is NOT NULL))
2720: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is NOT NULL) AND (p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE is NULL))) THEN
2721: x_flag := 'Y';
2722: return;
2723: END IF;

Line 2720: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is NOT NULL) AND (p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE is NULL))) THEN

2716: END IF;
2717:
2718: IF ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE <> p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE)
2719: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is NULL) AND (p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE is NOT NULL))
2720: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is NOT NULL) AND (p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE is NULL))) THEN
2721: x_flag := 'Y';
2722: return;
2723: END IF;
2724:

Line 2725: IF ((G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE <> p_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE)

2721: x_flag := 'Y';
2722: return;
2723: END IF;
2724:
2725: IF ((G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE <> p_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE)
2726: OR ((G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE is NULL) AND (p_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE is NOT NULL))
2727: OR ((G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE is NOT NULL) AND (p_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE is NULL))) THEN
2728: x_flag := 'Y';
2729: return;

Line 2726: OR ((G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE is NULL) AND (p_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE is NOT NULL))

2722: return;
2723: END IF;
2724:
2725: IF ((G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE <> p_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE)
2726: OR ((G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE is NULL) AND (p_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE is NOT NULL))
2727: OR ((G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE is NOT NULL) AND (p_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE is NULL))) THEN
2728: x_flag := 'Y';
2729: return;
2730: END IF;

Line 2727: OR ((G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE is NOT NULL) AND (p_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE is NULL))) THEN

2723: END IF;
2724:
2725: IF ((G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE <> p_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE)
2726: OR ((G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE is NULL) AND (p_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE is NOT NULL))
2727: OR ((G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE is NOT NULL) AND (p_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE is NULL))) THEN
2728: x_flag := 'Y';
2729: return;
2730: END IF;
2731:

Line 2732: IF NOT (nvl(G_LOC_RECINFO.LOCATION_CODE,'x') = p_pn_locations_rec.LOCATION_CODE) THEN

2728: x_flag := 'Y';
2729: return;
2730: END IF;
2731:
2732: IF NOT (nvl(G_LOC_RECINFO.LOCATION_CODE,'x') = p_pn_locations_rec.LOCATION_CODE) THEN
2733: x_flag := 'Y';
2734: return;
2735: END IF;
2736:

Line 2737: IF NOT ((nvl(G_LOC_RECINFO.BUILDING,'x') = p_pn_locations_rec.BUILDING)

2733: x_flag := 'Y';
2734: return;
2735: END IF;
2736:
2737: IF NOT ((nvl(G_LOC_RECINFO.BUILDING,'x') = p_pn_locations_rec.BUILDING)
2738: OR ((G_LOC_RECINFO.BUILDING is null) AND (p_pn_locations_rec.BUILDING is null))) THEN
2739: x_flag := 'Y';
2740: return;
2741: END IF;

Line 2738: OR ((G_LOC_RECINFO.BUILDING is null) AND (p_pn_locations_rec.BUILDING is null))) THEN

2734: return;
2735: END IF;
2736:
2737: IF NOT ((nvl(G_LOC_RECINFO.BUILDING,'x') = p_pn_locations_rec.BUILDING)
2738: OR ((G_LOC_RECINFO.BUILDING is null) AND (p_pn_locations_rec.BUILDING is null))) THEN
2739: x_flag := 'Y';
2740: return;
2741: END IF;
2742:

Line 2743: IF NOT ((nvl(G_LOC_RECINFO.FLOOR,'x') = p_pn_locations_rec.FLOOR)

2739: x_flag := 'Y';
2740: return;
2741: END IF;
2742:
2743: IF NOT ((nvl(G_LOC_RECINFO.FLOOR,'x') = p_pn_locations_rec.FLOOR)
2744: OR ((G_LOC_RECINFO.FLOOR is null) AND (p_pn_locations_rec.FLOOR is null))) THEN
2745: x_flag := 'Y';
2746: return;
2747: END IF;

Line 2744: OR ((G_LOC_RECINFO.FLOOR is null) AND (p_pn_locations_rec.FLOOR is null))) THEN

2740: return;
2741: END IF;
2742:
2743: IF NOT ((nvl(G_LOC_RECINFO.FLOOR,'x') = p_pn_locations_rec.FLOOR)
2744: OR ((G_LOC_RECINFO.FLOOR is null) AND (p_pn_locations_rec.FLOOR is null))) THEN
2745: x_flag := 'Y';
2746: return;
2747: END IF;
2748:

Line 2749: IF NOT ((nvl(G_LOC_RECINFO.LOCATION_ALIAS,'x') = p_pn_locations_rec.LOCATION_ALIAS)

2745: x_flag := 'Y';
2746: return;
2747: END IF;
2748:
2749: IF NOT ((nvl(G_LOC_RECINFO.LOCATION_ALIAS,'x') = p_pn_locations_rec.LOCATION_ALIAS)
2750: OR ((G_LOC_RECINFO.LOCATION_ALIAS is null) AND (p_pn_locations_rec.LOCATION_ALIAS is null))) THEN
2751: x_flag := 'Y';
2752: return;
2753: END IF;

Line 2750: OR ((G_LOC_RECINFO.LOCATION_ALIAS is null) AND (p_pn_locations_rec.LOCATION_ALIAS is null))) THEN

2746: return;
2747: END IF;
2748:
2749: IF NOT ((nvl(G_LOC_RECINFO.LOCATION_ALIAS,'x') = p_pn_locations_rec.LOCATION_ALIAS)
2750: OR ((G_LOC_RECINFO.LOCATION_ALIAS is null) AND (p_pn_locations_rec.LOCATION_ALIAS is null))) THEN
2751: x_flag := 'Y';
2752: return;
2753: END IF;
2754:

Line 2755: IF NOT ((nvl(G_LOC_RECINFO.PROPERTY_ID,-9.99) = nvl(p_pn_locations_rec.PROPERTY_ID,-9.99))) THEN

2751: x_flag := 'Y';
2752: return;
2753: END IF;
2754:
2755: IF NOT ((nvl(G_LOC_RECINFO.PROPERTY_ID,-9.99) = nvl(p_pn_locations_rec.PROPERTY_ID,-9.99))) THEN
2756: x_flag := 'Y';
2757: return;
2758: END IF;
2759:

Line 2760: IF NOT ((nvl(G_LOC_RECINFO.PARENT_LOCATION_ID,9.99) = p_pn_locations_rec.PARENT_LOCATION_ID)

2756: x_flag := 'Y';
2757: return;
2758: END IF;
2759:
2760: IF NOT ((nvl(G_LOC_RECINFO.PARENT_LOCATION_ID,9.99) = p_pn_locations_rec.PARENT_LOCATION_ID)
2761: OR ((G_LOC_RECINFO.PARENT_LOCATION_ID is null) AND (p_pn_locations_rec.PARENT_LOCATION_ID is null))) THEN
2762: x_flag := 'Y';
2763: return;
2764: END IF;

Line 2761: OR ((G_LOC_RECINFO.PARENT_LOCATION_ID is null) AND (p_pn_locations_rec.PARENT_LOCATION_ID is null))) THEN

2757: return;
2758: END IF;
2759:
2760: IF NOT ((nvl(G_LOC_RECINFO.PARENT_LOCATION_ID,9.99) = p_pn_locations_rec.PARENT_LOCATION_ID)
2761: OR ((G_LOC_RECINFO.PARENT_LOCATION_ID is null) AND (p_pn_locations_rec.PARENT_LOCATION_ID is null))) THEN
2762: x_flag := 'Y';
2763: return;
2764: END IF;
2765:

Line 2766: IF NOT ((nvl(G_LOC_RECINFO.INTERFACE_FLAG,'x') = p_pn_locations_rec.INTERFACE_FLAG)

2762: x_flag := 'Y';
2763: return;
2764: END IF;
2765:
2766: IF NOT ((nvl(G_LOC_RECINFO.INTERFACE_FLAG,'x') = p_pn_locations_rec.INTERFACE_FLAG)
2767: OR ((G_LOC_RECINFO.INTERFACE_FLAG is null) AND (p_pn_locations_rec.INTERFACE_FLAG is null))) THEN
2768: x_flag := 'Y';
2769: return;
2770: END IF;

Line 2767: OR ((G_LOC_RECINFO.INTERFACE_FLAG is null) AND (p_pn_locations_rec.INTERFACE_FLAG is null))) THEN

2763: return;
2764: END IF;
2765:
2766: IF NOT ((nvl(G_LOC_RECINFO.INTERFACE_FLAG,'x') = p_pn_locations_rec.INTERFACE_FLAG)
2767: OR ((G_LOC_RECINFO.INTERFACE_FLAG is null) AND (p_pn_locations_rec.INTERFACE_FLAG is null))) THEN
2768: x_flag := 'Y';
2769: return;
2770: END IF;
2771:

Line 2772: IF NOT ((nvl(G_LOC_RECINFO.STATUS,'x') = p_pn_locations_rec.STATUS)

2768: x_flag := 'Y';
2769: return;
2770: END IF;
2771:
2772: IF NOT ((nvl(G_LOC_RECINFO.STATUS,'x') = p_pn_locations_rec.STATUS)
2773: OR ((G_LOC_RECINFO.STATUS is null) AND (p_pn_locations_rec.STATUS is null))) THEN
2774: x_flag := 'Y';
2775: return;
2776: END IF;

Line 2773: OR ((G_LOC_RECINFO.STATUS is null) AND (p_pn_locations_rec.STATUS is null))) THEN

2769: return;
2770: END IF;
2771:
2772: IF NOT ((nvl(G_LOC_RECINFO.STATUS,'x') = p_pn_locations_rec.STATUS)
2773: OR ((G_LOC_RECINFO.STATUS is null) AND (p_pn_locations_rec.STATUS is null))) THEN
2774: x_flag := 'Y';
2775: return;
2776: END IF;
2777:

Line 2778: IF ((g_loc_recinfo.occupancy_status_code <> p_pn_locations_rec.occupancy_status_code) OR

2774: x_flag := 'Y';
2775: return;
2776: END IF;
2777:
2778: IF ((g_loc_recinfo.occupancy_status_code <> p_pn_locations_rec.occupancy_status_code) OR
2779: ((g_loc_recinfo.occupancy_status_code IS NULL) AND (p_pn_locations_rec.occupancy_status_code IS NOT NULL)) OR
2780: ((g_loc_recinfo.occupancy_status_code IS NOT NULL) AND (p_pn_locations_rec.occupancy_status_code IS NULL)))
2781: THEN
2782: x_flag := 'Y';

Line 2779: ((g_loc_recinfo.occupancy_status_code IS NULL) AND (p_pn_locations_rec.occupancy_status_code IS NOT NULL)) OR

2775: return;
2776: END IF;
2777:
2778: IF ((g_loc_recinfo.occupancy_status_code <> p_pn_locations_rec.occupancy_status_code) OR
2779: ((g_loc_recinfo.occupancy_status_code IS NULL) AND (p_pn_locations_rec.occupancy_status_code IS NOT NULL)) OR
2780: ((g_loc_recinfo.occupancy_status_code IS NOT NULL) AND (p_pn_locations_rec.occupancy_status_code IS NULL)))
2781: THEN
2782: x_flag := 'Y';
2783: RETURN;

Line 2780: ((g_loc_recinfo.occupancy_status_code IS NOT NULL) AND (p_pn_locations_rec.occupancy_status_code IS NULL)))

2776: END IF;
2777:
2778: IF ((g_loc_recinfo.occupancy_status_code <> p_pn_locations_rec.occupancy_status_code) OR
2779: ((g_loc_recinfo.occupancy_status_code IS NULL) AND (p_pn_locations_rec.occupancy_status_code IS NOT NULL)) OR
2780: ((g_loc_recinfo.occupancy_status_code IS NOT NULL) AND (p_pn_locations_rec.occupancy_status_code IS NULL)))
2781: THEN
2782: x_flag := 'Y';
2783: RETURN;
2784: END IF;

Line 2786: IF ((g_loc_recinfo.assignable_emp <> p_pn_locations_rec.assignable_emp) OR

2782: x_flag := 'Y';
2783: RETURN;
2784: END IF;
2785:
2786: IF ((g_loc_recinfo.assignable_emp <> p_pn_locations_rec.assignable_emp) OR
2787: ((g_loc_recinfo.assignable_emp IS NULL) AND (p_pn_locations_rec.assignable_emp IS NOT NULL)) OR
2788: ((g_loc_recinfo.assignable_emp IS NOT NULL) AND (p_pn_locations_rec.assignable_emp IS NULL)))
2789: THEN
2790: x_flag := 'Y';

Line 2787: ((g_loc_recinfo.assignable_emp IS NULL) AND (p_pn_locations_rec.assignable_emp IS NOT NULL)) OR

2783: RETURN;
2784: END IF;
2785:
2786: IF ((g_loc_recinfo.assignable_emp <> p_pn_locations_rec.assignable_emp) OR
2787: ((g_loc_recinfo.assignable_emp IS NULL) AND (p_pn_locations_rec.assignable_emp IS NOT NULL)) OR
2788: ((g_loc_recinfo.assignable_emp IS NOT NULL) AND (p_pn_locations_rec.assignable_emp IS NULL)))
2789: THEN
2790: x_flag := 'Y';
2791: RETURN;

Line 2788: ((g_loc_recinfo.assignable_emp IS NOT NULL) AND (p_pn_locations_rec.assignable_emp IS NULL)))

2784: END IF;
2785:
2786: IF ((g_loc_recinfo.assignable_emp <> p_pn_locations_rec.assignable_emp) OR
2787: ((g_loc_recinfo.assignable_emp IS NULL) AND (p_pn_locations_rec.assignable_emp IS NOT NULL)) OR
2788: ((g_loc_recinfo.assignable_emp IS NOT NULL) AND (p_pn_locations_rec.assignable_emp IS NULL)))
2789: THEN
2790: x_flag := 'Y';
2791: RETURN;
2792: END IF;

Line 2794: IF ((g_loc_recinfo.assignable_cc <> p_pn_locations_rec.assignable_cc) OR

2790: x_flag := 'Y';
2791: RETURN;
2792: END IF;
2793:
2794: IF ((g_loc_recinfo.assignable_cc <> p_pn_locations_rec.assignable_cc) OR
2795: ((g_loc_recinfo.assignable_cc IS NULL) AND (p_pn_locations_rec.assignable_cc IS NOT NULL)) OR
2796: ((g_loc_recinfo.assignable_cc IS NOT NULL) AND (p_pn_locations_rec.assignable_cc IS NULL)))
2797: THEN
2798: x_flag := 'Y';

Line 2795: ((g_loc_recinfo.assignable_cc IS NULL) AND (p_pn_locations_rec.assignable_cc IS NOT NULL)) OR

2791: RETURN;
2792: END IF;
2793:
2794: IF ((g_loc_recinfo.assignable_cc <> p_pn_locations_rec.assignable_cc) OR
2795: ((g_loc_recinfo.assignable_cc IS NULL) AND (p_pn_locations_rec.assignable_cc IS NOT NULL)) OR
2796: ((g_loc_recinfo.assignable_cc IS NOT NULL) AND (p_pn_locations_rec.assignable_cc IS NULL)))
2797: THEN
2798: x_flag := 'Y';
2799: RETURN;

Line 2796: ((g_loc_recinfo.assignable_cc IS NOT NULL) AND (p_pn_locations_rec.assignable_cc IS NULL)))

2792: END IF;
2793:
2794: IF ((g_loc_recinfo.assignable_cc <> p_pn_locations_rec.assignable_cc) OR
2795: ((g_loc_recinfo.assignable_cc IS NULL) AND (p_pn_locations_rec.assignable_cc IS NOT NULL)) OR
2796: ((g_loc_recinfo.assignable_cc IS NOT NULL) AND (p_pn_locations_rec.assignable_cc IS NULL)))
2797: THEN
2798: x_flag := 'Y';
2799: RETURN;
2800: END IF;

Line 2802: IF ((g_loc_recinfo.assignable_cust <> p_pn_locations_rec.assignable_cust) OR

2798: x_flag := 'Y';
2799: RETURN;
2800: END IF;
2801:
2802: IF ((g_loc_recinfo.assignable_cust <> p_pn_locations_rec.assignable_cust) OR
2803: ((g_loc_recinfo.assignable_cust IS NULL) AND (p_pn_locations_rec.assignable_cust IS NOT NULL)) OR
2804: ((g_loc_recinfo.assignable_cust IS NOT NULL) AND (p_pn_locations_rec.assignable_cust IS NULL)))
2805: THEN
2806: x_flag := 'Y';

Line 2803: ((g_loc_recinfo.assignable_cust IS NULL) AND (p_pn_locations_rec.assignable_cust IS NOT NULL)) OR

2799: RETURN;
2800: END IF;
2801:
2802: IF ((g_loc_recinfo.assignable_cust <> p_pn_locations_rec.assignable_cust) OR
2803: ((g_loc_recinfo.assignable_cust IS NULL) AND (p_pn_locations_rec.assignable_cust IS NOT NULL)) OR
2804: ((g_loc_recinfo.assignable_cust IS NOT NULL) AND (p_pn_locations_rec.assignable_cust IS NULL)))
2805: THEN
2806: x_flag := 'Y';
2807: RETURN;

Line 2804: ((g_loc_recinfo.assignable_cust IS NOT NULL) AND (p_pn_locations_rec.assignable_cust IS NULL)))

2800: END IF;
2801:
2802: IF ((g_loc_recinfo.assignable_cust <> p_pn_locations_rec.assignable_cust) OR
2803: ((g_loc_recinfo.assignable_cust IS NULL) AND (p_pn_locations_rec.assignable_cust IS NOT NULL)) OR
2804: ((g_loc_recinfo.assignable_cust IS NOT NULL) AND (p_pn_locations_rec.assignable_cust IS NULL)))
2805: THEN
2806: x_flag := 'Y';
2807: RETURN;
2808: END IF;

Line 2814: IF NOT ((nvl(G_LOC_RECINFO.LOCATION_PARK_ID,9.99) = p_pn_locations_rec.LOCATION_PARK_ID)

2810:
2811: -- DO SPECIAL CHECKS FOR PARTICULAR KINDS
2812:
2813: IF (NVL(G_LOC_RECINFO.LOCATION_TYPE_LOOKUP_CODE, ' ') IN ('BUILDING','LAND')) THEN
2814: IF NOT ((nvl(G_LOC_RECINFO.LOCATION_PARK_ID,9.99) = p_pn_locations_rec.LOCATION_PARK_ID)
2815: OR ((G_LOC_RECINFO.LOCATION_PARK_ID is null) AND (p_pn_locations_rec.LOCATION_PARK_ID is null))) THEN
2816: x_flag := 'Y';
2817: return;
2818: END IF;

Line 2815: OR ((G_LOC_RECINFO.LOCATION_PARK_ID is null) AND (p_pn_locations_rec.LOCATION_PARK_ID is null))) THEN

2811: -- DO SPECIAL CHECKS FOR PARTICULAR KINDS
2812:
2813: IF (NVL(G_LOC_RECINFO.LOCATION_TYPE_LOOKUP_CODE, ' ') IN ('BUILDING','LAND')) THEN
2814: IF NOT ((nvl(G_LOC_RECINFO.LOCATION_PARK_ID,9.99) = p_pn_locations_rec.LOCATION_PARK_ID)
2815: OR ((G_LOC_RECINFO.LOCATION_PARK_ID is null) AND (p_pn_locations_rec.LOCATION_PARK_ID is null))) THEN
2816: x_flag := 'Y';
2817: return;
2818: END IF;
2819:

Line 2820: IF NOT ((nvl(G_LOC_RECINFO.LEASE_OR_OWNED,'x') = p_pn_locations_rec.LEASE_OR_OWNED)

2816: x_flag := 'Y';
2817: return;
2818: END IF;
2819:
2820: IF NOT ((nvl(G_LOC_RECINFO.LEASE_OR_OWNED,'x') = p_pn_locations_rec.LEASE_OR_OWNED)
2821: OR ((G_LOC_RECINFO.LEASE_OR_OWNED is null) AND (p_pn_locations_rec.LEASE_OR_OWNED is null))) THEN
2822: x_flag := 'Y';
2823: return;
2824: END IF;

Line 2821: OR ((G_LOC_RECINFO.LEASE_OR_OWNED is null) AND (p_pn_locations_rec.LEASE_OR_OWNED is null))) THEN

2817: return;
2818: END IF;
2819:
2820: IF NOT ((nvl(G_LOC_RECINFO.LEASE_OR_OWNED,'x') = p_pn_locations_rec.LEASE_OR_OWNED)
2821: OR ((G_LOC_RECINFO.LEASE_OR_OWNED is null) AND (p_pn_locations_rec.LEASE_OR_OWNED is null))) THEN
2822: x_flag := 'Y';
2823: return;
2824: END IF;
2825:

Line 2826: IF ((G_LOC_RECINFO.CLASS <> p_pn_locations_rec.CLASS)

2822: x_flag := 'Y';
2823: return;
2824: END IF;
2825:
2826: IF ((G_LOC_RECINFO.CLASS <> p_pn_locations_rec.CLASS)
2827: OR ((G_LOC_RECINFO.CLASS is NULL) AND (p_pn_locations_rec.CLASS is NOT NULL))
2828: OR ((G_LOC_RECINFO.CLASS is NOT NULL) AND (p_pn_locations_rec.CLASS is NULL))) THEN
2829: x_flag := 'Y';
2830: return;

Line 2827: OR ((G_LOC_RECINFO.CLASS is NULL) AND (p_pn_locations_rec.CLASS is NOT NULL))

2823: return;
2824: END IF;
2825:
2826: IF ((G_LOC_RECINFO.CLASS <> p_pn_locations_rec.CLASS)
2827: OR ((G_LOC_RECINFO.CLASS is NULL) AND (p_pn_locations_rec.CLASS is NOT NULL))
2828: OR ((G_LOC_RECINFO.CLASS is NOT NULL) AND (p_pn_locations_rec.CLASS is NULL))) THEN
2829: x_flag := 'Y';
2830: return;
2831: END IF;

Line 2828: OR ((G_LOC_RECINFO.CLASS is NOT NULL) AND (p_pn_locations_rec.CLASS is NULL))) THEN

2824: END IF;
2825:
2826: IF ((G_LOC_RECINFO.CLASS <> p_pn_locations_rec.CLASS)
2827: OR ((G_LOC_RECINFO.CLASS is NULL) AND (p_pn_locations_rec.CLASS is NOT NULL))
2828: OR ((G_LOC_RECINFO.CLASS is NOT NULL) AND (p_pn_locations_rec.CLASS is NULL))) THEN
2829: x_flag := 'Y';
2830: return;
2831: END IF;
2832:

Line 2833: IF NOT ((nvl(G_LOC_RECINFO.STATUS_TYPE,'x') = p_pn_locations_rec.STATUS_TYPE)

2829: x_flag := 'Y';
2830: return;
2831: END IF;
2832:
2833: IF NOT ((nvl(G_LOC_RECINFO.STATUS_TYPE,'x') = p_pn_locations_rec.STATUS_TYPE)
2834: OR ((G_LOC_RECINFO.STATUS_TYPE is null) AND (p_pn_locations_rec.STATUS_TYPE is null))) THEN
2835: x_flag := 'Y';
2836: return;
2837: END IF;

Line 2834: OR ((G_LOC_RECINFO.STATUS_TYPE is null) AND (p_pn_locations_rec.STATUS_TYPE is null))) THEN

2830: return;
2831: END IF;
2832:
2833: IF NOT ((nvl(G_LOC_RECINFO.STATUS_TYPE,'x') = p_pn_locations_rec.STATUS_TYPE)
2834: OR ((G_LOC_RECINFO.STATUS_TYPE is null) AND (p_pn_locations_rec.STATUS_TYPE is null))) THEN
2835: x_flag := 'Y';
2836: return;
2837: END IF;
2838:

Line 2839: IF NOT ((nvl(G_LOC_RECINFO.OFFICE,'x') = p_pn_locations_rec.OFFICE)

2835: x_flag := 'Y';
2836: return;
2837: END IF;
2838:
2839: IF NOT ((nvl(G_LOC_RECINFO.OFFICE,'x') = p_pn_locations_rec.OFFICE)
2840: OR ((G_LOC_RECINFO.OFFICE is null) AND (p_pn_locations_rec.OFFICE is null))) THEN
2841: x_flag := 'Y';
2842: return;
2843: END IF;

Line 2840: OR ((G_LOC_RECINFO.OFFICE is null) AND (p_pn_locations_rec.OFFICE is null))) THEN

2836: return;
2837: END IF;
2838:
2839: IF NOT ((nvl(G_LOC_RECINFO.OFFICE,'x') = p_pn_locations_rec.OFFICE)
2840: OR ((G_LOC_RECINFO.OFFICE is null) AND (p_pn_locations_rec.OFFICE is null))) THEN
2841: x_flag := 'Y';
2842: return;
2843: END IF;
2844:

Line 2845: IF NOT ((nvl(G_LOC_RECINFO.ADDRESS_ID,9.99) = p_pn_locations_rec.ADDRESS_ID)

2841: x_flag := 'Y';
2842: return;
2843: END IF;
2844:
2845: IF NOT ((nvl(G_LOC_RECINFO.ADDRESS_ID,9.99) = p_pn_locations_rec.ADDRESS_ID)
2846: OR ((G_LOC_RECINFO.ADDRESS_ID is null) AND (p_pn_locations_rec.ADDRESS_ID is null))) THEN
2847: x_flag := 'Y';
2848: return;
2849: END IF;

Line 2846: OR ((G_LOC_RECINFO.ADDRESS_ID is null) AND (p_pn_locations_rec.ADDRESS_ID is null))) THEN

2842: return;
2843: END IF;
2844:
2845: IF NOT ((nvl(G_LOC_RECINFO.ADDRESS_ID,9.99) = p_pn_locations_rec.ADDRESS_ID)
2846: OR ((G_LOC_RECINFO.ADDRESS_ID is null) AND (p_pn_locations_rec.ADDRESS_ID is null))) THEN
2847: x_flag := 'Y';
2848: return;
2849: END IF;
2850:

Line 2851: IF NOT ((nvl(G_LOC_RECINFO.GROSS_AREA,-9.99) = nvl(p_pn_locations_rec.GROSS_AREA,-9.99))) THEN

2847: x_flag := 'Y';
2848: return;
2849: END IF;
2850:
2851: IF NOT ((nvl(G_LOC_RECINFO.GROSS_AREA,-9.99) = nvl(p_pn_locations_rec.GROSS_AREA,-9.99))) THEN
2852: x_flag := 'Y';
2853: return;
2854: END IF;
2855:

Line 2856: IF NOT ((nvl(G_LOC_RECINFO.SUITE,'x') = p_pn_locations_rec.SUITE)

2852: x_flag := 'Y';
2853: return;
2854: END IF;
2855:
2856: IF NOT ((nvl(G_LOC_RECINFO.SUITE,'x') = p_pn_locations_rec.SUITE)
2857: OR ((G_LOC_RECINFO.SUITE is null) AND (p_pn_locations_rec.SUITE is null))) THEN
2858: x_flag := 'Y';
2859: return;
2860: END IF;

Line 2857: OR ((G_LOC_RECINFO.SUITE is null) AND (p_pn_locations_rec.SUITE is null))) THEN

2853: return;
2854: END IF;
2855:
2856: IF NOT ((nvl(G_LOC_RECINFO.SUITE,'x') = p_pn_locations_rec.SUITE)
2857: OR ((G_LOC_RECINFO.SUITE is null) AND (p_pn_locations_rec.SUITE is null))) THEN
2858: x_flag := 'Y';
2859: return;
2860: END IF;
2861:

Line 2862: IF NOT ((nvl(G_LOC_RECINFO.ALLOCATE_COST_CENTER_CODE,'x') = p_pn_locations_rec.ALLOCATE_COST_CENTER_CODE)

2858: x_flag := 'Y';
2859: return;
2860: END IF;
2861:
2862: IF NOT ((nvl(G_LOC_RECINFO.ALLOCATE_COST_CENTER_CODE,'x') = p_pn_locations_rec.ALLOCATE_COST_CENTER_CODE)
2863: OR ((G_LOC_RECINFO.ALLOCATE_COST_CENTER_CODE is null) AND (p_pn_locations_rec.ALLOCATE_COST_CENTER_CODE is null))) THEN
2864: x_flag := 'Y';
2865: return;
2866: END IF;

Line 2863: OR ((G_LOC_RECINFO.ALLOCATE_COST_CENTER_CODE is null) AND (p_pn_locations_rec.ALLOCATE_COST_CENTER_CODE is null))) THEN

2859: return;
2860: END IF;
2861:
2862: IF NOT ((nvl(G_LOC_RECINFO.ALLOCATE_COST_CENTER_CODE,'x') = p_pn_locations_rec.ALLOCATE_COST_CENTER_CODE)
2863: OR ((G_LOC_RECINFO.ALLOCATE_COST_CENTER_CODE is null) AND (p_pn_locations_rec.ALLOCATE_COST_CENTER_CODE is null))) THEN
2864: x_flag := 'Y';
2865: return;
2866: END IF;
2867:

Line 2868: IF NOT ((G_LOC_RECINFO.UOM_CODE = p_pn_locations_rec.UOM_CODE)

2864: x_flag := 'Y';
2865: return;
2866: END IF;
2867:
2868: IF NOT ((G_LOC_RECINFO.UOM_CODE = p_pn_locations_rec.UOM_CODE)
2869: OR ((G_LOC_RECINFO.UOM_CODE is null) AND (p_pn_locations_rec.UOM_CODE is null))) THEN
2870: x_flag := 'Y';
2871: return;
2872: END IF;

Line 2869: OR ((G_LOC_RECINFO.UOM_CODE is null) AND (p_pn_locations_rec.UOM_CODE is null))) THEN

2865: return;
2866: END IF;
2867:
2868: IF NOT ((G_LOC_RECINFO.UOM_CODE = p_pn_locations_rec.UOM_CODE)
2869: OR ((G_LOC_RECINFO.UOM_CODE is null) AND (p_pn_locations_rec.UOM_CODE is null))) THEN
2870: x_flag := 'Y';
2871: return;
2872: END IF;
2873:

Line 2874: IF NOT ((nvl(G_LOC_RECINFO.DESCRIPTION,'x') = p_pn_locations_rec.DESCRIPTION)

2870: x_flag := 'Y';
2871: return;
2872: END IF;
2873:
2874: IF NOT ((nvl(G_LOC_RECINFO.DESCRIPTION,'x') = p_pn_locations_rec.DESCRIPTION)
2875: OR ((G_LOC_RECINFO.DESCRIPTION is null) AND (p_pn_locations_rec.DESCRIPTION is null))) THEN
2876: x_flag := 'Y';
2877: return;
2878: END IF;

Line 2875: OR ((G_LOC_RECINFO.DESCRIPTION is null) AND (p_pn_locations_rec.DESCRIPTION is null))) THEN

2871: return;
2872: END IF;
2873:
2874: IF NOT ((nvl(G_LOC_RECINFO.DESCRIPTION,'x') = p_pn_locations_rec.DESCRIPTION)
2875: OR ((G_LOC_RECINFO.DESCRIPTION is null) AND (p_pn_locations_rec.DESCRIPTION is null))) THEN
2876: x_flag := 'Y';
2877: return;
2878: END IF;
2879:

Line 2882: IF NOT ((nvl(G_LOC_RECINFO.OFFICE,'x') = p_pn_locations_rec.OFFICE)

2878: END IF;
2879:
2880: ELSIF (NVL(G_LOC_RECINFO.LOCATION_TYPE_LOOKUP_CODE, ' ') IN ('OFFICE','SECTION')) THEN
2881:
2882: IF NOT ((nvl(G_LOC_RECINFO.OFFICE,'x') = p_pn_locations_rec.OFFICE)
2883: OR ((G_LOC_RECINFO.OFFICE is null) AND (p_pn_locations_rec.OFFICE is null))) THEN
2884: x_flag := 'Y';
2885: return;
2886: END IF;

Line 2883: OR ((G_LOC_RECINFO.OFFICE is null) AND (p_pn_locations_rec.OFFICE is null))) THEN

2879:
2880: ELSIF (NVL(G_LOC_RECINFO.LOCATION_TYPE_LOOKUP_CODE, ' ') IN ('OFFICE','SECTION')) THEN
2881:
2882: IF NOT ((nvl(G_LOC_RECINFO.OFFICE,'x') = p_pn_locations_rec.OFFICE)
2883: OR ((G_LOC_RECINFO.OFFICE is null) AND (p_pn_locations_rec.OFFICE is null))) THEN
2884: x_flag := 'Y';
2885: return;
2886: END IF;
2887:

Line 2888: IF NOT ((nvl(G_LOC_RECINFO.MAX_CAPACITY,-9.99) = nvl(p_pn_locations_rec.MAX_CAPACITY,-9.99))) THEN

2884: x_flag := 'Y';
2885: return;
2886: END IF;
2887:
2888: IF NOT ((nvl(G_LOC_RECINFO.MAX_CAPACITY,-9.99) = nvl(p_pn_locations_rec.MAX_CAPACITY,-9.99))) THEN
2889: x_flag := 'Y';
2890: return;
2891: END IF;
2892:

Line 2893: IF NOT ((nvl(G_LOC_RECINFO.OPTIMUM_CAPACITY,-9.99) = nvl(p_pn_locations_rec.OPTIMUM_CAPACITY,-9.99))) THEN

2889: x_flag := 'Y';
2890: return;
2891: END IF;
2892:
2893: IF NOT ((nvl(G_LOC_RECINFO.OPTIMUM_CAPACITY,-9.99) = nvl(p_pn_locations_rec.OPTIMUM_CAPACITY,-9.99))) THEN
2894: x_flag := 'Y';
2895: return;
2896: END IF;
2897:

Line 2898: IF NOT ((nvl(G_LOC_RECINFO.RENTABLE_AREA,-9.99) = nvl(p_pn_locations_rec.RENTABLE_AREA,-9.99))) THEN

2894: x_flag := 'Y';
2895: return;
2896: END IF;
2897:
2898: IF NOT ((nvl(G_LOC_RECINFO.RENTABLE_AREA,-9.99) = nvl(p_pn_locations_rec.RENTABLE_AREA,-9.99))) THEN
2899: x_flag := 'Y';
2900: return;
2901: END IF;
2902:

Line 2903: IF NOT ((nvl(G_LOC_RECINFO.USABLE_AREA,-9.99) = nvl(p_pn_locations_rec.USABLE_AREA,-9.99))) THEN

2899: x_flag := 'Y';
2900: return;
2901: END IF;
2902:
2903: IF NOT ((nvl(G_LOC_RECINFO.USABLE_AREA,-9.99) = nvl(p_pn_locations_rec.USABLE_AREA,-9.99))) THEN
2904: x_flag := 'Y';
2905: return;
2906: END IF;
2907:

Line 2908: IF NOT ((nvl(G_LOC_RECINFO.ASSIGNABLE_AREA,9.99) = p_pn_locations_rec.ASSIGNABLE_AREA)

2904: x_flag := 'Y';
2905: return;
2906: END IF;
2907:
2908: IF NOT ((nvl(G_LOC_RECINFO.ASSIGNABLE_AREA,9.99) = p_pn_locations_rec.ASSIGNABLE_AREA)
2909: OR ((G_LOC_RECINFO.ASSIGNABLE_AREA is null) AND (p_pn_locations_rec.ASSIGNABLE_AREA is null))) THEN
2910: x_flag := 'Y';
2911: return;
2912: END IF;

Line 2909: OR ((G_LOC_RECINFO.ASSIGNABLE_AREA is null) AND (p_pn_locations_rec.ASSIGNABLE_AREA is null))) THEN

2905: return;
2906: END IF;
2907:
2908: IF NOT ((nvl(G_LOC_RECINFO.ASSIGNABLE_AREA,9.99) = p_pn_locations_rec.ASSIGNABLE_AREA)
2909: OR ((G_LOC_RECINFO.ASSIGNABLE_AREA is null) AND (p_pn_locations_rec.ASSIGNABLE_AREA is null))) THEN
2910: x_flag := 'Y';
2911: return;
2912: END IF;
2913:

Line 2914: IF NOT ((nvl(G_LOC_RECINFO.COMMON_AREA,9.99) = p_pn_locations_rec.COMMON_AREA)

2910: x_flag := 'Y';
2911: return;
2912: END IF;
2913:
2914: IF NOT ((nvl(G_LOC_RECINFO.COMMON_AREA,9.99) = p_pn_locations_rec.COMMON_AREA)
2915: OR ((G_LOC_RECINFO.COMMON_AREA is null) AND (p_pn_locations_rec.COMMON_AREA is null))) THEN
2916: x_flag := 'Y';
2917: return;
2918: END IF;

Line 2915: OR ((G_LOC_RECINFO.COMMON_AREA is null) AND (p_pn_locations_rec.COMMON_AREA is null))) THEN

2911: return;
2912: END IF;
2913:
2914: IF NOT ((nvl(G_LOC_RECINFO.COMMON_AREA,9.99) = p_pn_locations_rec.COMMON_AREA)
2915: OR ((G_LOC_RECINFO.COMMON_AREA is null) AND (p_pn_locations_rec.COMMON_AREA is null))) THEN
2916: x_flag := 'Y';
2917: return;
2918: END IF;
2919:

Line 2920: IF ((G_LOC_RECINFO.SUITE <> p_pn_locations_rec.SUITE)

2916: x_flag := 'Y';
2917: return;
2918: END IF;
2919:
2920: IF ((G_LOC_RECINFO.SUITE <> p_pn_locations_rec.SUITE)
2921: OR ((G_LOC_RECINFO.SUITE is NULL) AND (p_pn_locations_rec.SUITE is NOT NULL))
2922: OR ((G_LOC_RECINFO.SUITE is NOT NULL) AND (p_pn_locations_rec.SUITE is NULL))) THEN
2923: x_flag := 'Y';
2924: return;

Line 2921: OR ((G_LOC_RECINFO.SUITE is NULL) AND (p_pn_locations_rec.SUITE is NOT NULL))

2917: return;
2918: END IF;
2919:
2920: IF ((G_LOC_RECINFO.SUITE <> p_pn_locations_rec.SUITE)
2921: OR ((G_LOC_RECINFO.SUITE is NULL) AND (p_pn_locations_rec.SUITE is NOT NULL))
2922: OR ((G_LOC_RECINFO.SUITE is NOT NULL) AND (p_pn_locations_rec.SUITE is NULL))) THEN
2923: x_flag := 'Y';
2924: return;
2925: END IF;

Line 2922: OR ((G_LOC_RECINFO.SUITE is NOT NULL) AND (p_pn_locations_rec.SUITE is NULL))) THEN

2918: END IF;
2919:
2920: IF ((G_LOC_RECINFO.SUITE <> p_pn_locations_rec.SUITE)
2921: OR ((G_LOC_RECINFO.SUITE is NULL) AND (p_pn_locations_rec.SUITE is NOT NULL))
2922: OR ((G_LOC_RECINFO.SUITE is NOT NULL) AND (p_pn_locations_rec.SUITE is NULL))) THEN
2923: x_flag := 'Y';
2924: return;
2925: END IF;
2926:

Line 2927: IF NOT ((nvl(G_LOC_RECINFO.BOOKABLE_FLAG,'x') = p_pn_locations_rec.BOOKABLE_FLAG)

2923: x_flag := 'Y';
2924: return;
2925: END IF;
2926:
2927: IF NOT ((nvl(G_LOC_RECINFO.BOOKABLE_FLAG,'x') = p_pn_locations_rec.BOOKABLE_FLAG)
2928: OR ((G_LOC_RECINFO.BOOKABLE_FLAG is null) AND (p_pn_locations_rec.BOOKABLE_FLAG is null))) THEN
2929: x_flag := 'Y';
2930: return;
2931: END IF;

Line 2928: OR ((G_LOC_RECINFO.BOOKABLE_FLAG is null) AND (p_pn_locations_rec.BOOKABLE_FLAG is null))) THEN

2924: return;
2925: END IF;
2926:
2927: IF NOT ((nvl(G_LOC_RECINFO.BOOKABLE_FLAG,'x') = p_pn_locations_rec.BOOKABLE_FLAG)
2928: OR ((G_LOC_RECINFO.BOOKABLE_FLAG is null) AND (p_pn_locations_rec.BOOKABLE_FLAG is null))) THEN
2929: x_flag := 'Y';
2930: return;
2931: END IF;
2932:

Line 2951: UPDATE pn_locations_all

2947: PROCEDURE Update_Status (p_Location_Id Number) IS
2948:
2949: BEGIN
2950:
2951: UPDATE pn_locations_all
2952: SET Status = 'I'
2953: WHERE Location_Id IN (SELECT Location_Id
2954: FROM pn_locations_all
2955: START WITH Location_Id = p_Location_Id

Line 2954: FROM pn_locations_all

2950:
2951: UPDATE pn_locations_all
2952: SET Status = 'I'
2953: WHERE Location_Id IN (SELECT Location_Id
2954: FROM pn_locations_all
2955: START WITH Location_Id = p_Location_Id
2956: CONNECT BY PRIOR Location_Id = Parent_Location_id);
2957:
2958: End Update_Status ;

Line 2976: FROM pn_locations_all

2972: IS
2973:
2974: CURSOR location_cursor IS
2975: SELECT *
2976: FROM pn_locations_all
2977: START WITH location_id = p_location_id
2978: CONNECT BY PRIOR location_id = parent_location_id;
2979:
2980: BEGIN

Line 3100: FROM pn_locations_all

3096:
3097: CURSOR get_min_gross_area IS
3098: SELECT MIN(gross_area) min_gross_area,
3099: location_id location_id
3100: FROM pn_locations_all
3101: WHERE parent_location_id IS NULL
3102: AND active_start_date <= l_act_end_dt
3103: AND active_end_date >= p_act_str_dt
3104: START WITH location_id = p_loc_id

Line 3110: FROM pn_locations_all

3106: GROUP BY location_id;
3107:
3108: CURSOR get_old_rent_area IS
3109: SELECT rentable_area
3110: FROM pn_locations_all
3111: WHERE location_id = p_loc_id
3112: AND location_type_lookup_code = p_lkp_code
3113: AND active_start_date <= NVL(p_act_end_dt, TO_DATE('12/31/4712','MM/DD/YYYY'))
3114: AND active_end_date >= p_act_str_dt;

Line 3208: location_id pn_locations.location_id%TYPE,

3204: )
3205: IS
3206:
3207: TYPE loctn_rec IS RECORD(
3208: location_id pn_locations.location_id%TYPE,
3209: active_start_date DATE,
3210: active_end_date DATE);
3211:
3212: TYPE loc_type IS

Line 3227: FROM pn_locations_all

3223: CURSOR get_loctn_dates IS
3224: SELECT location_id,
3225: active_start_date,
3226: active_end_date
3227: FROM pn_locations_all
3228: WHERE active_end_date >= p_str_dt
3229: AND active_start_date <= p_end_dt
3230: AND location_id = p_loc_id
3231: AND ((p_asgn_mode = 'NONE') OR

Line 3242: FROM pn_locations_all

3238: CURSOR check_loctn_gap(l_date IN DATE) IS
3239: SELECT 'Y'
3240: FROM DUAL
3241: WHERE NOT EXISTS (SELECT NULL
3242: FROM pn_locations_all
3243: WHERE l_date BETWEEN active_start_date AND active_end_date
3244: AND location_id = p_loc_id
3245: AND ((p_asgn_mode = 'NONE') OR
3246: (p_asgn_mode = 'EMP' AND NVL(assignable_emp, 'Y') = 'Y' AND NVL(assignable_cc, 'Y') = 'Y') OR

Line 3337: FROM pn_locations_all

3333:
3334: CURSOR get_loctn_span IS
3335: SELECT MIN(active_start_date)
3336: ,MAX(active_end_date)
3337: FROM pn_locations_all
3338: WHERE location_id = p_loc_id
3339: AND ((p_asgn_mode = 'NONE') OR
3340: (p_asgn_mode = 'EMP' AND NVL(assignable_emp, 'Y') = 'Y' AND NVL(assignable_cc, 'Y') = 'Y') OR
3341: (p_asgn_mode = 'CC' AND NVL(assignable_cc, 'Y') = 'Y') OR

Line 3361: -- pn_locations_all%ROWTYPE passed to it. Called from

3357:
3358: -----------------------------------------------------------------------
3359: -- PROCEDURE : Update_Locn_Row
3360: -- PURPOSE : This procedure calls pnt_locations_pkg.Update_Row for the
3361: -- pn_locations_all%ROWTYPE passed to it. Called from
3362: -- Correct_Update_Row and Cascade_Child_Locn
3363: -- IN PARAM :
3364: -- History :
3365: -- 01-DEC-2004 Satish Tripathi o Created for Portfolio Status Enh BUG# 4030816.

Line 3370: p_loc_recinfo IN pn_locations_all%ROWTYPE

3366: -- 02-AUG-2005 Satya Deep o Added X_SOURCE in the call to
3367: -- pnt_locations_pkg.Update_Row
3368: -----------------------------------------------------------------------
3369: PROCEDURE Update_Locn_Row (
3370: p_loc_recinfo IN pn_locations_all%ROWTYPE
3371: ,p_adr_recinfo IN pn_addresses_all%ROWTYPE
3372: ,p_assgn_area_chgd_flag IN VARCHAR2
3373: ,x_return_status IN OUT NOCOPY VARCHAR2
3374: ,x_return_message IN OUT NOCOPY VARCHAR2

Line 3378: l_location_id pn_locations_all.location_id%TYPE;

3374: ,x_return_message IN OUT NOCOPY VARCHAR2
3375: )
3376: IS
3377: l_rowid ROWID;
3378: l_location_id pn_locations_all.location_id%TYPE;
3379: l_address_id pn_locations_all.address_id%TYPE;
3380: BEGIN
3381:
3382: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Update_Locn_Row (+) LocId: '||p_loc_recinfo.location_id

Line 3379: l_address_id pn_locations_all.address_id%TYPE;

3375: )
3376: IS
3377: l_rowid ROWID;
3378: l_location_id pn_locations_all.location_id%TYPE;
3379: l_address_id pn_locations_all.address_id%TYPE;
3380: BEGIN
3381:
3382: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Update_Locn_Row (+) LocId: '||p_loc_recinfo.location_id
3383: ||', LocCd: '||p_loc_recinfo.location_code

Line 3388: IF g_pn_locations_rowid IS NULL THEN

3384: ||', Type: '||p_loc_recinfo.location_type_lookup_code);
3385: l_location_id := p_loc_recinfo.location_id;
3386: l_address_id := p_loc_recinfo.address_id;
3387:
3388: IF g_pn_locations_rowid IS NULL THEN
3389: pnt_locations_pkg.Set_ROWID(
3390: p_location_id => p_loc_recinfo.location_id
3391: ,p_active_start_date => p_loc_recinfo.active_start_date
3392: ,p_active_end_date => p_loc_recinfo.active_end_date

Line 3504: -- pn_locations_all%ROWTYPE passed to it. Called from

3500:
3501: -----------------------------------------------------------------------
3502: -- PROCEDURE : Insert_Locn_Row
3503: -- PURPOSE : This procedure calls pnt_locations_pkg.Insert_Row for the
3504: -- pn_locations_all%ROWTYPE passed to it. Called from
3505: -- Correct_Update_Row and Cascade_Child_Locn
3506: -- IN PARAM :
3507: -- History :
3508: -- 01-DEC-2004 Satish Tripathi o Created for Portfolio Status Enh BUG# 4030816.

Line 3513: p_loc_recinfo IN pn_locations_all%ROWTYPE

3509: -- 02-AUG-2005 Satya Deep o Added X_SOURCE in the call to
3510: -- pnt_locations_pkg.Insert_Row
3511: -----------------------------------------------------------------------
3512: PROCEDURE Insert_Locn_Row (
3513: p_loc_recinfo IN pn_locations_all%ROWTYPE
3514: ,p_adr_recinfo IN pn_addresses_all%ROWTYPE
3515: ,p_change_mode IN VARCHAR2
3516: ,x_return_status IN OUT NOCOPY VARCHAR2
3517: ,x_return_message IN OUT NOCOPY VARCHAR2

Line 3521: l_location_id pn_locations_all.location_id%TYPE;

3517: ,x_return_message IN OUT NOCOPY VARCHAR2
3518: )
3519: IS
3520: l_rowid ROWID;
3521: l_location_id pn_locations_all.location_id%TYPE;
3522: l_address_id pn_locations_all.address_id%TYPE;
3523: BEGIN
3524: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Insert_Locn_Row (+) LocId: '||p_loc_recinfo.location_id
3525: ||', LocCd: '||p_loc_recinfo.location_code

Line 3522: l_address_id pn_locations_all.address_id%TYPE;

3518: )
3519: IS
3520: l_rowid ROWID;
3521: l_location_id pn_locations_all.location_id%TYPE;
3522: l_address_id pn_locations_all.address_id%TYPE;
3523: BEGIN
3524: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Insert_Locn_Row (+) LocId: '||p_loc_recinfo.location_id
3525: ||', LocCd: '||p_loc_recinfo.location_code
3526: ||', Type: '||p_loc_recinfo.location_type_lookup_code);

Line 3674: FROM pn_locations_all

3670:
3671:
3672: SELECT location_id
3673: INTO l_location_id
3674: FROM pn_locations_all
3675: WHERE location_code = p_location_code
3676: AND location_type_lookup_code = p_loctn_type_lookup_code
3677: AND org_id = p_org_id
3678: AND ROWNUM = 1;

Line 3717: FROM pn_locations_all pnl

3713: CURSOR loc_code_cur IS
3714: SELECT 1
3715: FROM DUAL
3716: WHERE EXISTS (SELECT 1
3717: FROM pn_locations_all pnl
3718: WHERE pnl.location_code = x_location_code
3719: AND pnl.active_start_date = x_active_start_date
3720: AND pnl.active_end_date = NVL(x_active_end_date,g_end_of_time)
3721: AND ((x_location_id IS NULL) OR (pnl.location_id <> x_location_id))

Line 3768: FROM pn_locations_all pnl

3764: CURSOR building_cur IS
3765: SELECT 1
3766: FROM DUAL
3767: WHERE EXISTS (SELECT 1
3768: FROM pn_locations_all pnl
3769: WHERE UPPER(pnl.building) = UPPER(x_building)
3770: AND ((x_location_id IS NULL) OR (pnl.location_id <> x_location_id))
3771: AND pnl.active_start_date <= x_active_start_date
3772: AND pnl.active_end_date >= x_active_end_date

Line 3817: FROM pn_locations_all loc

3813: l_token VARCHAR2(30);
3814:
3815: CURSOR dupAlias IS
3816: SELECT loc.location_id AS location_id
3817: FROM pn_locations_all loc
3818: WHERE loc.LOCATION_TYPE_LOOKUP_CODE = p_location_type_lookup_code
3819: AND loc.location_alias = p_location_alias
3820: AND loc.location_id <> NVL(p_location_id,-1)
3821: AND loc.org_id = p_org_id;

Line 3870: FROM pn_locations_all pnl

3866: CURSOR loc_alias_cur IS
3867: SELECT 1
3868: FROM DUAL
3869: WHERE EXISTS (SELECT 1
3870: FROM pn_locations_all pnl
3871: WHERE pnl.location_alias = x_location_alias
3872: AND location_type_lookup_code = x_location_type_lookup_code
3873: AND ((x_location_id IS NULL) OR (pnl.location_id <> x_location_id))
3874: AND pnl.parent_location_id = x_parent_location_id