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 242: UPDATE ahl_mc_path_positions SET

238: FETCH get_position_id_csr INTO x_position_id;
239: IF (get_position_id_csr%FOUND) THEN
240: IF (l_position_ref_code <> FND_API.G_MISS_CHAR OR
241: l_position_ref_code IS NULL) THEN
242: UPDATE ahl_mc_path_positions SET
243: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
244: LAST_UPDATE_DATE = sysdate,
245: LAST_UPDATED_BY = fnd_global.USER_ID,
246: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,