APPS.FND_PROFILE dependencies on FND_PROFILE_OPTION_VALUES_PKG

Line 1947: ** level using the FND_PROFILE_OPTION_VALUES_PKG. This routine can be used

1943:
1944: /*
1945: ** save
1946: ** Saves the value of a profile option permanently to the database, at any
1947: ** level using the FND_PROFILE_OPTION_VALUES_PKG. This routine can be used
1948: ** at runtime or during patching. This routine will not actually commit
1949: ** the changes; the caller must commit.
1950: **
1951: ** ('SITE', 'APPL', 'RESP', 'USER', 'SERVER', 'ORG', or 'SERVRESP').

Line 2183: fnd_profile_option_values_pkg.delete_row(applicationId,

2179: IF (x_value IS NULL) THEN
2180: -- If SERVRESP level, then take LEVEL_VALUE2 into consideration.
2181: IF (levelId = SERVRESP_LEVEL_ID) THEN
2182: -- DELETE
2183: fnd_profile_option_values_pkg.delete_row(applicationId,
2184: profileOptionId,
2185: levelId,
2186: levelValueActual,
2187: x_level_value_app_id,

Line 2198: fnd_profile_option_values_pkg.delete_row(applicationId,

2194: x_level_value_app_id,
2195: levelValue2Actual);
2196: ELSE
2197: -- DELETE
2198: fnd_profile_option_values_pkg.delete_row(applicationId,
2199: profileOptionId,
2200: levelId,
2201: levelValueActual,
2202: x_level_value_app_id);

Line 2212: -- accordingly. FND_PROFILE_OPTION_VALUES_PKG.UPDATE_ROW() will call

2208: x_level_value_app_id);
2209: END IF;
2210: ELSE
2211: -- If profile option value passed in is NOT NULL, then update
2212: -- accordingly. FND_PROFILE_OPTION_VALUES_PKG.UPDATE_ROW() will call
2213: -- FND_PROFILE_OPTION_VALUES_PKG.INSERT_ROW(), if needed. There is no
2214: -- need to call FND_PROFILE_OPTION_VALUES_PKG.INSERT_ROW(), explicitly,
2215: -- from here. If SERVRESP level, then take LEVEL_VALUE2 into
2216: -- consideration.

Line 2213: -- FND_PROFILE_OPTION_VALUES_PKG.INSERT_ROW(), if needed. There is no

2209: END IF;
2210: ELSE
2211: -- If profile option value passed in is NOT NULL, then update
2212: -- accordingly. FND_PROFILE_OPTION_VALUES_PKG.UPDATE_ROW() will call
2213: -- FND_PROFILE_OPTION_VALUES_PKG.INSERT_ROW(), if needed. There is no
2214: -- need to call FND_PROFILE_OPTION_VALUES_PKG.INSERT_ROW(), explicitly,
2215: -- from here. If SERVRESP level, then take LEVEL_VALUE2 into
2216: -- consideration.
2217: IF (levelId = SERVRESP_LEVEL_ID) THEN

Line 2214: -- need to call FND_PROFILE_OPTION_VALUES_PKG.INSERT_ROW(), explicitly,

2210: ELSE
2211: -- If profile option value passed in is NOT NULL, then update
2212: -- accordingly. FND_PROFILE_OPTION_VALUES_PKG.UPDATE_ROW() will call
2213: -- FND_PROFILE_OPTION_VALUES_PKG.INSERT_ROW(), if needed. There is no
2214: -- need to call FND_PROFILE_OPTION_VALUES_PKG.INSERT_ROW(), explicitly,
2215: -- from here. If SERVRESP level, then take LEVEL_VALUE2 into
2216: -- consideration.
2217: IF (levelId = SERVRESP_LEVEL_ID) THEN
2218: fnd_profile_option_values_pkg.update_row(applicationId,

Line 2218: fnd_profile_option_values_pkg.update_row(applicationId,

2214: -- need to call FND_PROFILE_OPTION_VALUES_PKG.INSERT_ROW(), explicitly,
2215: -- from here. If SERVRESP level, then take LEVEL_VALUE2 into
2216: -- consideration.
2217: IF (levelId = SERVRESP_LEVEL_ID) THEN
2218: fnd_profile_option_values_pkg.update_row(applicationId,
2219: profileOptionId,
2220: levelId,
2221: levelValueActual,
2222: x_level_value_app_id,

Line 2238: fnd_profile_option_values_pkg.update_row(applicationId,

2234: levelValueActual,
2235: x_level_value_app_id,
2236: levelValue2Actual);
2237: ELSE
2238: fnd_profile_option_values_pkg.update_row(applicationId,
2239: profileOptionId,
2240: levelId,
2241: levelValueActual,
2242: x_level_value_app_id,

Line 2343: -- FND_PROFILE_OPTION_VALUES_PKG.DELETE_ROW would be called. However, all

2339: deleted BOOLEAN;
2340: BEGIN
2341: -- Call SAVE() and pass NULL for the profile option value. This
2342: -- physically deletes the row from FND_PROFILE_OPTION_VALUES. Ideally,
2343: -- FND_PROFILE_OPTION_VALUES_PKG.DELETE_ROW would be called. However, all
2344: -- validation/conversion performed in SAVE() would have to be written here
2345: -- as well OR writing a completely separate API just to validate the data
2346: -- so that both SAVE and DELETE can use it.
2347: deleted := SAVE(x_name,