APPS.PN_LOC_STATUS_CHANGE_PKG dependencies on PN_LOCATIONS

Line 75: FROM pn_locations loc /*sdm?? Location Code lies in a range*/

71: loc.common_area,
72: loc.common_area_flag,
73: loc.function_type_lookup_code,
74: loc.standard_type_lookup_code
75: FROM pn_locations loc /*sdm?? Location Code lies in a range*/
76: WHERE loc.location_type_lookup_code = p_loc_type
77: AND loc.location_code BETWEEN p_loc_code_low and p_loc_code_high;
78:
79:

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;