APPS.PN_CAD_IMPORT dependencies on PN_LOCATIONS_ALL

Line 164: PN_LOCATIONS_ALL pnl

160:
161: CURSOR loccur IS
162: SELECT pli.*, pli.rowid,occupancy_status_code
163: FROM PN_LOCATIONS_ITF pli,
164: PN_LOCATIONS_ALL pnl
165: WHERE pli.parent_location_id = pnl.location_id(+)
166: AND pli.batch_name = p_batch_name
167: AND pli.transferred_to_pn IS NULL
168: ORDER BY pli.location_type_lookup_code, pli.active_start_date;

Line 189: l_pn_locations_rec PN_LOCATIONS_ALL%ROWTYPE;

185: l_loc_id NUMBER;
186: v_loc_rec PN_LOCATIONS%ROWTYPE;
187: v_addr_rec PN_ADDRESSES%ROWTYPE;
188: l_act_str_dt DATE;
189: l_pn_locations_rec PN_LOCATIONS_ALL%ROWTYPE;
190: l_pn_addresses_rec PN_ADDRESSES_ALL%ROWTYPE;
191: l_active_start_date DATE;
192: l_active_end_date DATE;
193: l_filename VARCHAR2(50) := 'IMPORT_'||to_char(sysdate,'DDMMYYYYHHMMSS');

Line 418: from pn_locations_all where location_id = loc.PARENT_LOCATION_ID

414: -------------------------------------------------------------------------
415: if loc.LOCATION_TYPE_LOOKUP_CODE in ('FLOOR', 'OFFICE', 'PARCEL', 'SECTION') then
416: select min(active_start_date), nvl(max(active_end_date),PNT_LOCATIONS_PKG.G_END_OF_TIME)
417: into l_active_start_date, l_active_end_date
418: from pn_locations_all where location_id = loc.PARENT_LOCATION_ID
419: group by location_id;
420:
421: if trunc(loc.active_start_date) < trunc(l_active_start_date) then
422: fnd_message.set_name('PN', 'PN_CAFM_LOC_CHILD_ST_DT');

Line 779: from PN_LOCATIONS_ALL

775: --------------------------------------
776: BEGIN
777: select *
778: into v_loc_rec
779: from PN_LOCATIONS_ALL
780: where LOCATION_ID = loc.location_id
781: and location_code = loc.location_code
782: and active_Start_date = trunc(loc.active_start_date)
783: and active_End_date = trunc(nvl(loc.active_end_date, PNT_LOCATIONS_PKG.G_END_OF_TIME));

Line 1479: FROM PN_LOCATIONS_ALL loc

1475:
1476: CURSOR locCodeCur IS
1477:
1478: SELECT loc.LOCATION_CODE
1479: FROM PN_LOCATIONS_ALL loc
1480: WHERE loc.LOCATION_ID = p_Loc_Id;
1481:
1482: CURSOR locIdCur is
1483: SELECT loc.LOCATION_ID

Line 1484: FROM PN_LOCATIONS_ALL loc

1480: WHERE loc.LOCATION_ID = p_Loc_Id;
1481:
1482: CURSOR locIdCur is
1483: SELECT loc.LOCATION_ID
1484: FROM PN_LOCATIONS_ALL loc
1485: WHERE loc.LOCATION_CODE = p_Loc_Code
1486: AND org_id = p_org_id;
1487:
1488: BEGIN

Line 1539: from PN_LOCATIONS_ALL

1535: BEGIN
1536:
1537: Select distinct location_type_lookup_code
1538: into l_lookup_type
1539: from PN_LOCATIONS_ALL
1540: where location_id = p_location_id ;
1541:
1542: Return l_lookup_type ;
1543: