eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_USER_ACCT_INTERNAL dependencies on FND_PROFILE_OPTIONS

Line 1017: (p_profile_opt_name in fnd_profile_options.profile_option_name%type

1013: -- | process is not supposed to issue any savepoint or rollback. |
1014: -- ----------------------------------------------------------------------------
1015: --
1016: PROCEDURE create_fnd_profile_values
1017: (p_profile_opt_name in fnd_profile_options.profile_option_name%type
1018: ,p_profile_opt_value in fnd_profile_option_values.profile_option_value%type
1019: ,p_profile_level_name in varchar2
1020: ,p_profile_level_value in fnd_profile_option_values.level_value%type
1021: ,p_profile_lvl_val_app_id in

Line 1032: FROM fnd_profile_options

1028: IS
1029: SELECT resp_update_allowed_flag
1030: ,user_update_allowed_flag
1031: ,sql_validation
1032: FROM fnd_profile_options
1033: WHERE profile_option_name = p_profile_opt_name;
1034: --
1035: l_resp_update_allowed_flag fnd_profile_options.resp_update_allowed_flag%type
1036: default null;

Line 1035: l_resp_update_allowed_flag fnd_profile_options.resp_update_allowed_flag%type

1031: ,sql_validation
1032: FROM fnd_profile_options
1033: WHERE profile_option_name = p_profile_opt_name;
1034: --
1035: l_resp_update_allowed_flag fnd_profile_options.resp_update_allowed_flag%type
1036: default null;
1037: l_user_update_allowed_flag fnd_profile_options.user_update_allowed_flag%type
1038: default null;
1039: l_profile_val_saved boolean default null;

Line 1037: l_user_update_allowed_flag fnd_profile_options.user_update_allowed_flag%type

1033: WHERE profile_option_name = p_profile_opt_name;
1034: --
1035: l_resp_update_allowed_flag fnd_profile_options.resp_update_allowed_flag%type
1036: default null;
1037: l_user_update_allowed_flag fnd_profile_options.user_update_allowed_flag%type
1038: default null;
1039: l_profile_val_saved boolean default null;
1040: l_sql_validation varchar2(2000) default null;
1041: l_num_data number default null;

Line 1061: fnd_message.set_token('TABLE', 'FND_PROFILE_OPTIONS');

1057: ,l_sql_validation;
1058: IF lc_get_update_flag%NOTFOUND THEN
1059: CLOSE lc_get_update_flag;
1060: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1061: fnd_message.set_token('TABLE', 'FND_PROFILE_OPTIONS');
1062: fnd_message.set_token('COLUMN', 'PROFILE_OPTION_NAME');
1063: fnd_message.set_token('VALUE', p_profile_opt_name);
1064: hr_utility.raise_error;
1065: END IF;

Line 1336: (p_profile_opt_name in fnd_profile_options.profile_option_name%type

1332: -- Bug 2825757 : Added validation for ICX_LANGUAGE
1333: -- ----------------------------------------------------------------------------
1334: --
1335: PROCEDURE validate_profile_opt_value
1336: (p_profile_opt_name in fnd_profile_options.profile_option_name%type
1337: ,p_profile_opt_value in
1338: fnd_profile_option_values.profile_option_value%type
1339: ,p_profile_level_name in varchar2
1340: ,p_profile_level_value in fnd_profile_option_values.level_value%type

Line 1341: ,p_sql_validation in fnd_profile_options.sql_validation%type

1337: ,p_profile_opt_value in
1338: fnd_profile_option_values.profile_option_value%type
1339: ,p_profile_level_name in varchar2
1340: ,p_profile_level_value in fnd_profile_option_values.level_value%type
1341: ,p_sql_validation in fnd_profile_options.sql_validation%type
1342: ,p_profile_opt_value_valid out nocopy boolean
1343: ,p_num_data out nocopy number
1344: ,p_varchar2_data out nocopy varchar2
1345: ) IS

Line 1591: l_sql_validation fnd_profile_options.sql_validation%type default null;

1587: -- Fix 2288014 End
1588:
1589: --
1590:
1591: l_sql_validation fnd_profile_options.sql_validation%type default null;
1592: l_num_data number default null;
1593: l_varchar2_data varchar2(2000) default null;
1594: l_lookup_type varchar2(2000) default null;
1595: l_opt_value_valid boolean default null;

Line 1923: FROM fnd_profile_options fp

1919: CURSOR lc_get_resp_lvl_profile_val IS
1920: SELECT fpv.profile_option_id
1921: ,fpv.profile_option_value
1922: ,fp.profile_option_name
1923: FROM fnd_profile_options fp
1924: ,fnd_profile_option_values fpv
1925: WHERE fpv.profile_option_id = fp.profile_option_id
1926: AND fpv.level_id = 10003
1927: AND fpv.level_value = p_template_resp_id