APPS.FND_PROFILE_OPTIONS_PKG dependencies on DUAL

Line 1236: from dual;

1232: exception
1233: when no_data_found then
1234: select fnd_profile_options_s.nextval
1235: into profo_id
1236: from dual;
1237:
1238: fnd_profile_options_pkg.insert_row (
1239: x_rowid => row_id,
1240: x_profile_option_name => L_PROFILE_OPTION_NAME,

Line 1281: -- Delete profile option values first, so that there are no residual

1277: ) is
1278: L_PROFILE_OPTION_NAME VARCHAR2(80):= UPPER(X_PROFILE_OPTION_NAME);
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);