APPS.HR_USER_ACCT_INTERNAL dependencies on FND_PROFILE_OPTION_VALUES

Line 1018: ,p_profile_opt_value in fnd_profile_option_values.profile_option_value%type

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
1022: fnd_profile_option_values.level_value_application_id%type default null

Line 1020: ,p_profile_level_value in fnd_profile_option_values.level_value%type

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
1022: fnd_profile_option_values.level_value_application_id%type default null
1023: ,p_profile_value_saved out nocopy boolean
1024: ) IS

Line 1022: fnd_profile_option_values.level_value_application_id%type default null

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
1022: fnd_profile_option_values.level_value_application_id%type default null
1023: ,p_profile_value_saved out nocopy boolean
1024: ) IS
1025: --
1026: --

Line 1338: fnd_profile_option_values.profile_option_value%type

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
1341: ,p_sql_validation in fnd_profile_options.sql_validation%type
1342: ,p_profile_opt_value_valid out nocopy boolean

Line 1340: ,p_profile_level_value in fnd_profile_option_values.level_value%type

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
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

Line 1924: ,fnd_profile_option_values fpv

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
1928: AND fpv.level_value_application_id = p_template_resp_app_id;