APPS.AHL_MC_PATH_POSITION_PVT dependencies on AHL_MC_PATH_POSITIONS_S

Line 93: SELECT ahl_mc_path_positions_s.nextval

89: AND p_size = (select COUNT(path_position_node_id) from
90: AHL_MC_PATH_POSITION_NODES where path_position_id = pos.path_position_id);
91: --
92: CURSOR get_next_path_pos_id_csr IS
93: SELECT ahl_mc_path_positions_s.nextval
94: FROM dual;
95: --
96: l_junk VARCHAR2(1);
97: l_api_version CONSTANT NUMBER := 1.0;

Line 250: UPDATE ahl_mc_path_positions SET

246: IF (l_position_ref_code <> FND_API.G_MISS_CHAR OR
247: l_position_ref_code IS NULL) THEN
248: */
249: IF (l_position_ref_code IS NOT NULL) THEN
250: UPDATE ahl_mc_path_positions SET
251: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
252: LAST_UPDATE_DATE = sysdate,
253: LAST_UPDATED_BY = fnd_global.USER_ID,
254: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,