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,
247: POSITION_REF_CODE = l_position_ref_code
248: WHERE PATH_POSITION_ID = x_position_id;
249: END IF;
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,
247: POSITION_REF_CODE = l_position_ref_code
248: WHERE PATH_POSITION_ID = x_position_id;
249: END IF;
250: ELSE
296: l_position_id,
297: l_common_id,
298: 1,
299: sysdate,
300: fnd_global.user_id,
301: sysdate,
302: fnd_global.user_id,
303: fnd_global.login_id,
304: l_encoded_path,
298: 1,
299: sysdate,
300: fnd_global.user_id,
301: sysdate,
302: fnd_global.user_id,
303: fnd_global.login_id,
304: l_encoded_path,
305: l_position_ref_code,
306: l_ver_spec_score,
299: sysdate,
300: fnd_global.user_id,
301: sysdate,
302: fnd_global.user_id,
303: fnd_global.login_id,
304: l_encoded_path,
305: l_position_ref_code,
306: l_ver_spec_score,
307: NULL,
344: ) VALUES (
345: ahl_mc_path_position_nodes_s.nextval,
346: 1,
347: sysdate,
348: fnd_global.user_id,
349: sysdate,
350: fnd_global.user_id,
351: fnd_global.login_id,
352: x_position_id,
346: 1,
347: sysdate,
348: fnd_global.user_id,
349: sysdate,
350: fnd_global.user_id,
351: fnd_global.login_id,
352: x_position_id,
353: l_index,
354: p_path_position_tbl(i).mc_id,
347: sysdate,
348: fnd_global.user_id,
349: sysdate,
350: fnd_global.user_id,
351: fnd_global.login_id,
352: x_position_id,
353: l_index,
354: p_path_position_tbl(i).mc_id,
355: p_path_position_tbl(i).version_number,