Profile Option Values Load using API in Oracle Apps

BEGIN

FND_PROFILE_OPTION_VALUES_PKG.INSERT_ROW
(X_ROWID=>X_ROWID,
 X_APPLICATION_ID=>v_application_id,
 X_PROFILE_OPTION_ID=>v_profile_option_id,
 X_LEVEL_ID=>crec.level_id,
 X_LEVEL_VALUE =>L_LEVEL_VALUE,
 X_CREATION_DATE =>SYSDATE,
 X_CREATED_BY =>fnd_global.login_id,
 X_LAST_UPDATE_DATE =>SYSDATE,
 X_LAST_UPDATED_BY =>fnd_global.login_id,
 X_LAST_UPDATE_LOGIN=>fnd_global.login_id,
 X_PROFILE_OPTION_VALUE=>crec.profile_value,
 X_LEVEL_VALUE_APPLICATION_ID=>crec.level_value_application_id,
 X_LEVEL_VALUE2=>NULL
); 
END;
---
---
L_LEVEL_VALUE based on the Profile level.

IF profile_level ='site'
THENL_LEVEL_VALUE :=NULL;ELSIF
profile_level ='Appl'
THENL_LEVEL_VALUE :=l_application_id(from fnd_application);
ELSIF
profile_level ='Resp'THENL_LEVEL_VALUE :=v_responsibility_id(from FND_RESPONSIBILITY);
ELSIF
profile_level ='User'THENL_LEVEL_VALUE :=v_user_id;(from FND_USERS);
END IF;