APPS.PN_LOCATION_ALIAS_PKG SQL Statements

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

Line: 73

    SELECT location_id,
           parent_location_id,
           location_code,
           location_alias
    FROM pn_locations_all           /*sdm14jul*/
    WHERE NVL(TRUNC(ACTIVE_END_DATE), TRUNC(SYSDATE)) >= TRUNC(SYSDATE)  /* Bug 6735518 */
    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)                 /* Bug 6735518 */
    CONNECT BY PRIOR location_id = parent_location_id
    ORDER BY 3;

Line: 104

   loc_id_tbl.delete;

Line: 105

   als_nm_tbl.delete;

Line: 106

   old_cd_tbl.delete;

Line: 107

   new_cd_tbl.delete;

Line: 112

   SELECT COUNT(1)
   INTO   l_uniq_loc_count
   FROM   pn_locations_all
   WHERE  location_code = p_new_alias;

Line: 153

      UPDATE pn_locations_all                   /*sdm14jul*/
         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)
       AND NVL(TRUNC(ACTIVE_END_DATE), TRUNC(SYSDATE)) >= TRUNC(SYSDATE);  /* Bug 6735518 */