APPS.PN_CAD_IMPORT dependencies on PN_ADDRESSES_ALL

Line 119: | statements to update pn_addresses_all. Bug #

115: | 4. Changed several messages
116: | 07-AUG-03 Kiran o Populated the Addresses %ROWTYPE variable
117: | before passing it to PNT_LOCATIONS_PKG.
118: | correct_update_row. Removd explicit update
119: | statements to update pn_addresses_all. Bug #
120: | 3079433. Changed 'IF' condition for calling
121: | validate_gross_area in 'COrrect' and 'Update'
122: | mode.
123: | 07-JAN-04 Daniel Thota o Added OUT param l_total_allocated_area_pct

Line 187: v_addr_rec PN_ADDRESSES_ALL%ROWTYPE; --bug 9652624

183: l_last_update_date DATE;
184: l_location_id NUMBER;
185: l_loc_id NUMBER;
186: v_loc_rec PN_LOCATIONS_ALL%ROWTYPE; --bug 9652624
187: v_addr_rec PN_ADDRESSES_ALL%ROWTYPE; --bug 9652624
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;

Line 190: l_pn_addresses_rec PN_ADDRESSES_ALL%ROWTYPE;

186: v_loc_rec PN_LOCATIONS_ALL%ROWTYPE; --bug 9652624
187: v_addr_rec PN_ADDRESSES_ALL%ROWTYPE; --bug 9652624
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');
194: l_org_id NUMBER;

Line 804: from pn_addresses_all

800:
801: BEGIN
802: select *
803: into v_addr_rec
804: from pn_addresses_all
805: where address_id = v_loc_rec.address_id;
806: l_address_id := v_addr_rec.address_id;
807: EXCEPTION
808: WHEN no_data_found THEN