APPS.PN_LOCATION_ALIAS_PKG dependencies on PN_LOCATIONS_ALL

Line 77: FROM pn_locations_all /*sdm14jul*/

73: SELECT location_id,
74: parent_location_id,
75: location_code,
76: location_alias
77: FROM pn_locations_all /*sdm14jul*/
78: WHERE NVL(TRUNC(ACTIVE_END_DATE), TRUNC(SYSDATE)) >= TRUNC(SYSDATE) /* Bug 6735518 */
79: START WITH location_id = (SELECT location_id FROM
80: (SELECT location_id
81: FROM pn_locations_all

Line 81: FROM pn_locations_all

77: FROM pn_locations_all /*sdm14jul*/
78: WHERE NVL(TRUNC(ACTIVE_END_DATE), TRUNC(SYSDATE)) >= TRUNC(SYSDATE) /* Bug 6735518 */
79: START WITH location_id = (SELECT location_id FROM
80: (SELECT location_id
81: FROM pn_locations_all
82: WHERE location_type_lookup_code = p_location_type
83: AND location_code = p_location_code
84: ORDER BY ACTIVE_START_DATE DESC)
85: WHERE ROWNUM = 1) /* Bug 6735518 */

Line 114: FROM pn_locations_all

110:
111: --Bug#5571818
112: SELECT COUNT(1)
113: INTO l_uniq_loc_count
114: FROM pn_locations_all
115: WHERE location_code = p_new_alias;
116:
117: IF l_uniq_loc_count <> 0 THEN
118: raise INVALID_LOC_CODE;

Line 153: UPDATE pn_locations_all /*sdm14jul*/

149: END LOOP;
150:
151: l_info := 'updating table with new values ';
152: FORALL i IN 0 .. loc_id_tbl.COUNT - 1
153: UPDATE pn_locations_all /*sdm14jul*/
154: SET location_code = new_cd_tbl(i),
155: location_alias = als_nm_tbl(i),
156: last_update_date = SYSDATE,
157: last_updated_by = nvl(fnd_profile.value('USER_ID'), -1),