DBA Data[Home] [Help]

APPS.PN_LOC_STATUS_CHANGE_PKG dependencies on PNP_UTIL_FUNC

Line 218: (pnp_util_func.get_space_assigned_status(actdeact_main.location_id, actdeact_main.active_start_date)) THEN

214: pnp_debug_pkg.log(p_action||' Main Location: '||l_loc||' (+)');
215:
216: -- Check Main Loc has Active assignments.
217: IF p_action = 'DEACTIVATE' AND
218: (pnp_util_func.get_space_assigned_status(actdeact_main.location_id, actdeact_main.active_start_date)) THEN
219:
220: --If Active Assignment found, can't De-activate Bldg.
221: l_loc_active_status := 'Y';
222: