APPS.FND_PROFILE_OPTION_VALUES_PKG dependencies on FND_PROFILE_OPTIONS

Line 13: from FND_PROFILE_OPTIONS

9: begin
10:
11: select HIERARCHY_TYPE
12: into L_HIERARCHY_TYPE
13: from FND_PROFILE_OPTIONS
14: where PROFILE_OPTION_ID = X_PROFILE_OPTION_ID
15: and APPLICATION_ID = X_APPLICATION_ID;
16:
17: if SQL%NOTFOUND then

Line 264: from FND_PROFILE_OPTIONS

260: when profile_option_value_too_large then
261:
262: select PROFILE_OPTION_NAME
263: into L_PROFILE_OPTION_NAME
264: from FND_PROFILE_OPTIONS
265: where APPLICATION_ID = X_APPLICATION_ID
266: and PROFILE_OPTION_ID = X_PROFILE_OPTION_ID;
267:
268: fnd_message.set_name('FND', 'FND_PROFILE_OPTION_VAL_TOO_LRG');

Line 366: from FND_PROFILE_OPTIONS

362: when profile_option_value_too_large then
363:
364: select PROFILE_OPTION_NAME
365: into L_PROFILE_OPTION_NAME
366: from FND_PROFILE_OPTIONS
367: where APPLICATION_ID = X_APPLICATION_ID
368: and PROFILE_OPTION_ID = X_PROFILE_OPTION_ID;
369:
370: fnd_message.set_name('FND', 'FND_PROFILE_OPTION_VAL_TOO_LRG');

Line 500: * FND_PROFILE_OPTIONS_PKG.DELETE_ROW which deletes profile option

496:
497: end DELETE_ROW;
498:
499: /* This procedure is only going to be called from
500: * FND_PROFILE_OPTIONS_PKG.DELETE_ROW which deletes profile option
501: * definitions. This procedure ensures that there will be no dangling
502: * references in FND_PROFILE_OPTION_VALUES to the profile option being
503: * deleted, i.e. if a profile is being deleted, it should have no rows
504: * for profile option values.

Line 514: from fnd_profile_options

510: -- Obtain the profile_option_id and application_id of the profile
511: -- option being deleted using the profile option name.
512: select profile_option_id, application_id
513: into L_PROFILE_OPTION_ID, L_APPLICATION_ID
514: from fnd_profile_options
515: where profile_option_name = X_PROFILE_OPTION_NAME;
516:
517: -- If the given profile option does not exist, then raise no_data_found;
518: if (SQL%NOTFOUND) then