APPS.PN_LOCATION_ALIAS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 80

    SELECT location_id,
           parent_location_id,
           location_code,
           location_alias
    FROM pn_locations_all           /*sdm14jul*/
    START WITH location_id =  (SELECT location_id FROM
                              (SELECT location_id
                               FROM pn_locations_all
                               WHERE location_type_lookup_code = p_location_type
                               AND location_code = p_location_code
                               ORDER BY ACTIVE_START_DATE DESC)
                               WHERE ROWNUM = 1)
	CONNECT BY PRIOR location_id = parent_location_id
    ORDER BY 3;

Line: 111

   loc_id_tbl.delete;

Line: 112

   als_nm_tbl.delete;

Line: 113

   old_cd_tbl.delete;

Line: 114

   new_cd_tbl.delete;

Line: 151

   SELECT COUNT(1)
   INTO   l_uniq_loc_count
   FROM   pn_locations_all
   WHERE  location_code =  l_new_loc_code
   and    location_code <> p_location_code; --Bug#16098151

Line: 165

      UPDATE pn_locations_all                   /*Bug 9767441 */
         SET location_code = new_cd_tbl(i),
             location_alias = als_nm_tbl(i),
             last_update_date = SYSDATE,
             last_updated_by = nvl(fnd_profile.value('USER_ID'), -1),
             last_update_login = nvl(fnd_profile.value('USER_ID'), -1)
       WHERE location_id = loc_id_tbl(i);