APPS.FND_PROFILE dependencies on FND_PROFILE_OPTION_VALUES

Line 655: from fnd_profile_option_values

651: -- and user levels (10001/10002/10004)
652: --
653: cursor value_uas(pid number, aid number, lid number, lval number) is
654: select profile_option_value
655: from fnd_profile_option_values
656: where profile_option_id = pid
657: and application_id = aid
658: and level_id = lid
659: and level_value = lval

Line 667: from fnd_profile_option_values

663: -- level (10003)
664: --
665: cursor value_resp(pid number, aid number, lval number, laid number) is
666: select profile_option_value
667: from fnd_profile_option_values
668: where profile_option_id = pid
669: and application_id = aid
670: and level_id = 10003
671: and level_value = lval

Line 681: from fnd_profile_option_values

677: --
678: cursor value_servresp(pid number, aid number, lval number, laid number,
679: lval2 number) is
680: select profile_option_value
681: from fnd_profile_option_values
682: where profile_option_id = pid
683: and application_id = aid
684: and level_id = 10007
685: and level_value = lval

Line 1365: from fnd_profile_option_values

1361: -- and user levels (10001/10002/10004)
1362: --
1363: cursor value_uas(pid number, aid number, lid number, lval number) is
1364: select profile_option_value
1365: from fnd_profile_option_values
1366: where profile_option_id = pid
1367: and application_id = aid
1368: and level_id = lid
1369: and level_value = lval

Line 1377: from fnd_profile_option_values

1373: -- level (10003)
1374: --
1375: cursor value_resp(pid number, aid number, lval number, laid number) is
1376: select profile_option_value
1377: from fnd_profile_option_values
1378: where profile_option_id = pid
1379: and application_id = aid
1380: and level_id = 10003
1381: and level_value = lval

Line 1391: from fnd_profile_option_values

1387: --
1388: cursor value_servresp(pid number, aid number, lval number, laid number,
1389: lval2 number) is
1390: select profile_option_value
1391: from fnd_profile_option_values
1392: where profile_option_id = pid
1393: and application_id = aid
1394: and level_id = 10007
1395: and level_value = lval

Line 3411: FND_PROFILE_OPTION_VALUES_PKG.DELETE_ROW(x_application_id,

3407: IF (X_VALUE is null) then
3408: -- If SERVRESP level, then take LEVEL_VALUE2 into consideration.
3409: if (x_level_id = 10007) then
3410: -- D E L E T E --
3411: FND_PROFILE_OPTION_VALUES_PKG.DELETE_ROW(x_application_id,
3412: x_profile_option_id, x_level_id, x_level_value_actual,
3413: X_LEVEL_VALUE_APP_ID, x_level_value2_actual);
3414: else
3415: -- D E L E T E --

Line 3416: FND_PROFILE_OPTION_VALUES_PKG.DELETE_ROW(x_application_id,

3412: x_profile_option_id, x_level_id, x_level_value_actual,
3413: X_LEVEL_VALUE_APP_ID, x_level_value2_actual);
3414: else
3415: -- D E L E T E --
3416: FND_PROFILE_OPTION_VALUES_PKG.DELETE_ROW(x_application_id,
3417: x_profile_option_id, x_level_id, x_level_value_actual,
3418: X_LEVEL_VALUE_APP_ID);
3419: end if;
3420:

Line 3438: FND_PROFILE_OPTION_VALUES_PKG.UPDATE_ROW(x_application_id,

3434: -- accordingly. If SERVRESP level, then take LEVEL_VALUE2 into
3435: -- consideration.
3436: if (x_level_id = 10007) then
3437: -- U P D A T E --
3438: FND_PROFILE_OPTION_VALUES_PKG.UPDATE_ROW(x_application_id,
3439: x_profile_option_id, x_level_id, x_level_value_actual,
3440: X_LEVEL_VALUE_APP_ID, x_level_value2_actual, X_VALUE,
3441: x_last_update_date, x_last_updated_by, x_last_update_login);
3442: else

Line 3444: FND_PROFILE_OPTION_VALUES_PKG.UPDATE_ROW(x_application_id,

3440: X_LEVEL_VALUE_APP_ID, x_level_value2_actual, X_VALUE,
3441: x_last_update_date, x_last_updated_by, x_last_update_login);
3442: else
3443: -- U P D A T E --
3444: FND_PROFILE_OPTION_VALUES_PKG.UPDATE_ROW(x_application_id,
3445: x_profile_option_id, x_level_id, x_level_value_actual,
3446: X_LEVEL_VALUE_APP_ID, X_VALUE, x_last_update_date,
3447: x_last_updated_by, x_last_update_login);
3448: end if;

Line 3890: -- FND_PROFILE_OPTION_VALUES table.

3886: -- CURRENT_ORG_CONTEXT is being introduced so that profiles code can
3887: -- provide similar functionality such that FND_GLOBAL.ORG_ID will be
3888: -- equivalent to FND_PROFILE.VALUE('CURRENT_ORG_CONTEXT').
3889: -- FND_GLOBAL.VALUE('ORG_ID') will return a value obtained in the
3890: -- FND_PROFILE_OPTION_VALUES table.
3891: PUT('CURRENT_ORG_CONTEXT', to_char(PROFILES_ORG_ID));
3892: end if;
3893:
3894: PUT('ORG_NAME', fnd_global.org_name);

Line 4245: -- physically deletes the row from fnd_profile_option_values.

4241:
4242: begin
4243:
4244: -- Call SAVE routine and pass NULL for the profile option value. This
4245: -- physically deletes the row from fnd_profile_option_values.
4246: l_deleted := SAVE(X_NAME,
4247: NULL,
4248: X_LEVEL_NAME,
4249: X_LEVEL_VALUE,