1279: begin
1280:
1281: -- Delete profile option values first, so that there are no residual
1282: -- profile option values to a non-existent profile option. This introduces
1283: -- a dependency to FND_PROFILE_OPTION_VALUES_PKG.
1284: FND_PROFILE_OPTION_VALUES_PKG.DELETE_PROFILE_OPTION_VALUES(
1285: L_PROFILE_OPTION_NAME);
1286:
1287: delete from FND_PROFILE_OPTIONS
1280:
1281: -- Delete profile option values first, so that there are no residual
1282: -- profile option values to a non-existent profile option. This introduces
1283: -- a dependency to FND_PROFILE_OPTION_VALUES_PKG.
1284: FND_PROFILE_OPTION_VALUES_PKG.DELETE_PROFILE_OPTION_VALUES(
1285: L_PROFILE_OPTION_NAME);
1286:
1287: delete from FND_PROFILE_OPTIONS
1288: where PROFILE_OPTION_NAME = L_PROFILE_OPTION_NAME;