APPS.PN_LOC_STATUS_CHANGE_PKG dependencies on PN_LOCATIONS_ALL

Line 145: FROM pn_locations_all cld /*sdm14jul*/

141: cld.common_area,
142: cld.common_area_flag,
143: cld.function_type_lookup_code,
144: cld.standard_type_lookup_code
145: FROM pn_locations_all cld /*sdm14jul*/
146: WHERE cld.location_id <> p_location_id
147: AND cld.location_id IN (SELECT location_id
148: FROM pn_locations_all /*sdm14jul*/
149: START WITH location_id = p_location_id

Line 148: FROM pn_locations_all /*sdm14jul*/

144: cld.standard_type_lookup_code
145: FROM pn_locations_all cld /*sdm14jul*/
146: WHERE cld.location_id <> p_location_id
147: AND cld.location_id IN (SELECT location_id
148: FROM pn_locations_all /*sdm14jul*/
149: START WITH location_id = p_location_id
150: CONNECT BY PRIOR location_id = parent_location_id
151: );
152:

Line 231: UPDATE pn_locations_all

227: LOOP
228:
229: -- Activate/De-Activate Child Loc
230: IF child_loc.status <> l_loc_status THEN
231: UPDATE pn_locations_all
232: SET status = l_loc_status
233: WHERE ROWID = child_loc.row_id; /*sdm14jul*/
234: l_rowcount := l_rowcount + 1;
235: END IF;

Line 251: UPDATE pn_locations_all /*sdm14jul*/

247:
248:
249: ELSE
250: IF actdeact_main.status <> l_loc_status THEN
251: UPDATE pn_locations_all /*sdm14jul*/
252: SET status = l_loc_status
253: WHERE ROWID = actdeact_main.row_id;
254: l_rowcount := l_rowcount + 1;
255: END IF;