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,
255: POSITION_REF_CODE = l_position_ref_code
256: WHERE PATH_POSITION_ID = x_position_id
257: AND POSITION_REF_CODE IS NULL;
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,
255: POSITION_REF_CODE = l_position_ref_code
256: WHERE PATH_POSITION_ID = x_position_id
257: AND POSITION_REF_CODE IS NULL;
258: END IF;
305: l_position_id,
306: l_common_id,
307: 1,
308: sysdate,
309: fnd_global.user_id,
310: sysdate,
311: fnd_global.user_id,
312: fnd_global.login_id,
313: l_encoded_path,
307: 1,
308: sysdate,
309: fnd_global.user_id,
310: sysdate,
311: fnd_global.user_id,
312: fnd_global.login_id,
313: l_encoded_path,
314: l_position_ref_code,
315: l_ver_spec_score,
308: sysdate,
309: fnd_global.user_id,
310: sysdate,
311: fnd_global.user_id,
312: fnd_global.login_id,
313: l_encoded_path,
314: l_position_ref_code,
315: l_ver_spec_score,
316: NULL,
353: ) VALUES (
354: ahl_mc_path_position_nodes_s.nextval,
355: 1,
356: sysdate,
357: fnd_global.user_id,
358: sysdate,
359: fnd_global.user_id,
360: fnd_global.login_id,
361: x_position_id,
355: 1,
356: sysdate,
357: fnd_global.user_id,
358: sysdate,
359: fnd_global.user_id,
360: fnd_global.login_id,
361: x_position_id,
362: l_index,
363: p_path_position_tbl(i).mc_id,
356: sysdate,
357: fnd_global.user_id,
358: sysdate,
359: fnd_global.user_id,
360: fnd_global.login_id,
361: x_position_id,
362: l_index,
363: p_path_position_tbl(i).mc_id,
364: p_path_position_tbl(i).version_number,