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

Line 13: g_emtpy_fnd_prof_opt_val_tbl hr_user_acct_utility.fnd_profile_opt_val_tbl;

9: g_max_fax_length constant number := 80;
10: g_api_vers constant number := 1.0;
11: g_empty_fnd_user_rec hr_user_acct_utility.fnd_user_rec;
12: g_emtpy_fnd_resp_tbl hr_user_acct_utility.fnd_responsibility_tbl;
13: g_emtpy_fnd_prof_opt_val_tbl hr_user_acct_utility.fnd_profile_opt_val_tbl;
14: --
15: -- ----------------------------------------------------------------------------
16: -- |--------------------------- < generate_string > ---------------------------|
17: -- ----------------------------------------------------------------------------

Line 244: nvl(fnd_profile.value('SIGNON_PASSWORD_LENGTH'), '5')

240: -- profile option. If that profile option is null, the default is 5.
241: --
242: l_count := 0;
243: l_count := to_number(
244: nvl(fnd_profile.value('SIGNON_PASSWORD_LENGTH'), '5')
245: );
246:
247: IF l_count > 8 AND p_password IS NULL
248: THEN

Line 1011: -- |---------------------- < create_fnd_profile_values > ----------------------|

1007: END create_sec_profile_asg;
1008: --
1009: --
1010: -- ----------------------------------------------------------------------------
1011: -- |---------------------- < create_fnd_profile_values > ----------------------|
1012: -- |NOTE: No savepoint will be issued here because business support internal |
1013: -- | process is not supposed to issue any savepoint or rollback. |
1014: -- ----------------------------------------------------------------------------
1015: --

Line 1016: PROCEDURE create_fnd_profile_values

1012: -- |NOTE: No savepoint will be issued here because business support internal |
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

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 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 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 1044: l_proc varchar2(72) := g_package||'create_fnd_profile_values';

1040: l_sql_validation varchar2(2000) default null;
1041: l_num_data number default null;
1042: l_varchar2_data varchar2(2000) default null;
1043: l_profile_opt_value_valid boolean default null;
1044: l_proc varchar2(72) := g_package||'create_fnd_profile_values';
1045:
1046: BEGIN
1047: hr_utility.set_location('Entering:' || l_proc, 10);
1048: --

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 1101: hr_utility.set_location(l_proc || ' before fnd_profile.save', 30);

1097: ,p_varchar2_data => l_varchar2_data);
1098: END IF;
1099:
1100:
1101: hr_utility.set_location(l_proc || ' before fnd_profile.save', 30);
1102: --
1103: IF l_profile_opt_value_valid THEN
1104: l_profile_val_saved := fnd_profile.save
1105: (x_name => p_profile_opt_name

Line 1104: l_profile_val_saved := fnd_profile.save

1100:
1101: hr_utility.set_location(l_proc || ' before fnd_profile.save', 30);
1102: --
1103: IF l_profile_opt_value_valid THEN
1104: l_profile_val_saved := fnd_profile.save
1105: (x_name => p_profile_opt_name
1106: ,x_value => p_profile_opt_value
1107: ,x_level_name => p_profile_level_name
1108: ,x_level_value => p_profile_level_value

Line 1141: l_profile_val_saved := fnd_profile.save

1137: THEN
1138: -- Use the Business Group Id derived from the security profile to set
1139: -- the PER_BUSINESS_GROUP_ID profile option.
1140: l_profile_val_saved := null;
1141: l_profile_val_saved := fnd_profile.save
1142: (x_name => 'PER_BUSINESS_GROUP_ID'
1143: ,x_value => to_char(l_num_data)
1144: ,x_level_name => p_profile_level_name
1145: ,x_level_value => p_profile_level_value

Line 1158: END create_fnd_profile_values;

1154:
1155: hr_utility.set_location('Leaving:'||l_proc, 50);
1156:
1157:
1158: END create_fnd_profile_values;
1159:
1160: -- ----------------------------------------------------------------------------
1161: -- |--------------------- < validate_profile_opt_value > ----------------------|
1162: -- | Validate profile options which use SQL validation. The SQL validation |

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 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 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 1911: ,p_fnd_profile_opt_val_tbl in

1907: ,p_template_resp_app_id in fnd_responsibility.application_id%type
1908: default null
1909: ,p_new_resp_key in fnd_responsibility.responsibility_key%type
1910: ,p_new_resp_app_id in fnd_responsibility.application_id%type
1911: ,p_fnd_profile_opt_val_tbl in
1912: hr_user_acct_utility.fnd_profile_opt_val_tbl
1913: ,p_out_profile_opt_val_tbl out
1914: hr_user_acct_utility.fnd_profile_opt_val_tbl
1915: ) IS

Line 1912: hr_user_acct_utility.fnd_profile_opt_val_tbl

1908: default null
1909: ,p_new_resp_key in fnd_responsibility.responsibility_key%type
1910: ,p_new_resp_app_id in fnd_responsibility.application_id%type
1911: ,p_fnd_profile_opt_val_tbl in
1912: hr_user_acct_utility.fnd_profile_opt_val_tbl
1913: ,p_out_profile_opt_val_tbl out
1914: hr_user_acct_utility.fnd_profile_opt_val_tbl
1915: ) IS
1916: --

Line 1914: hr_user_acct_utility.fnd_profile_opt_val_tbl

1910: ,p_new_resp_app_id in fnd_responsibility.application_id%type
1911: ,p_fnd_profile_opt_val_tbl in
1912: hr_user_acct_utility.fnd_profile_opt_val_tbl
1913: ,p_out_profile_opt_val_tbl out
1914: hr_user_acct_utility.fnd_profile_opt_val_tbl
1915: ) IS
1916: --
1917: --
1918: -- Derive profile option values from the template responsibility id

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

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;

Line 1931: l_prof_opt_val_tbl hr_user_acct_utility.fnd_profile_opt_val_tbl;

1927: AND fpv.level_value = p_template_resp_id
1928: AND fpv.level_value_application_id = p_template_resp_app_id;
1929:
1930:
1931: l_prof_opt_val_tbl hr_user_acct_utility.fnd_profile_opt_val_tbl;
1932: l_found_sw boolean default false;
1933: l_index binary_integer := 0;
1934: l_count number default 0;
1935: l_proc varchar2(72) := g_package||'build_resp_profile_val';

Line 1941: -- Now copy the p_fnd_profile_opt_val_tbl to the local table for output

1937: BEGIN
1938: --
1939: hr_utility.set_location('Entering:' || l_proc, 10);
1940: --
1941: -- Now copy the p_fnd_profile_opt_val_tbl to the local table for output
1942: -- Only copy the profile option values for the passed in responsibility.
1943: FOR i in 1..p_fnd_profile_opt_val_tbl.count
1944: LOOP
1945: IF p_fnd_profile_opt_val_tbl(i).profile_level_name = 'RESP'

Line 1943: FOR i in 1..p_fnd_profile_opt_val_tbl.count

1939: hr_utility.set_location('Entering:' || l_proc, 10);
1940: --
1941: -- Now copy the p_fnd_profile_opt_val_tbl to the local table for output
1942: -- Only copy the profile option values for the passed in responsibility.
1943: FOR i in 1..p_fnd_profile_opt_val_tbl.count
1944: LOOP
1945: IF p_fnd_profile_opt_val_tbl(i).profile_level_name = 'RESP'
1946: AND
1947: p_fnd_profile_opt_val_tbl(i).profile_level_value = p_new_resp_key

Line 1945: IF p_fnd_profile_opt_val_tbl(i).profile_level_name = 'RESP'

1941: -- Now copy the p_fnd_profile_opt_val_tbl to the local table for output
1942: -- Only copy the profile option values for the passed in responsibility.
1943: FOR i in 1..p_fnd_profile_opt_val_tbl.count
1944: LOOP
1945: IF p_fnd_profile_opt_val_tbl(i).profile_level_name = 'RESP'
1946: AND
1947: p_fnd_profile_opt_val_tbl(i).profile_level_value = p_new_resp_key
1948: AND
1949: p_fnd_profile_opt_val_tbl(i).profile_level_value_app_id =

Line 1947: p_fnd_profile_opt_val_tbl(i).profile_level_value = p_new_resp_key

1943: FOR i in 1..p_fnd_profile_opt_val_tbl.count
1944: LOOP
1945: IF p_fnd_profile_opt_val_tbl(i).profile_level_name = 'RESP'
1946: AND
1947: p_fnd_profile_opt_val_tbl(i).profile_level_value = p_new_resp_key
1948: AND
1949: p_fnd_profile_opt_val_tbl(i).profile_level_value_app_id =
1950: p_new_resp_app_id
1951: THEN

Line 1949: p_fnd_profile_opt_val_tbl(i).profile_level_value_app_id =

1945: IF p_fnd_profile_opt_val_tbl(i).profile_level_name = 'RESP'
1946: AND
1947: p_fnd_profile_opt_val_tbl(i).profile_level_value = p_new_resp_key
1948: AND
1949: p_fnd_profile_opt_val_tbl(i).profile_level_value_app_id =
1950: p_new_resp_app_id
1951: THEN
1952: l_index := l_index + 1;
1953: l_prof_opt_val_tbl(l_index).profile_option_name :=

Line 1954: p_fnd_profile_opt_val_tbl(i).profile_option_name;

1950: p_new_resp_app_id
1951: THEN
1952: l_index := l_index + 1;
1953: l_prof_opt_val_tbl(l_index).profile_option_name :=
1954: p_fnd_profile_opt_val_tbl(i).profile_option_name;
1955: l_prof_opt_val_tbl(l_index).profile_option_value :=
1956: p_fnd_profile_opt_val_tbl(i).profile_option_value;
1957: l_prof_opt_val_tbl(l_index).profile_level_name :=
1958: p_fnd_profile_opt_val_tbl(i).profile_level_name;

Line 1956: p_fnd_profile_opt_val_tbl(i).profile_option_value;

1952: l_index := l_index + 1;
1953: l_prof_opt_val_tbl(l_index).profile_option_name :=
1954: p_fnd_profile_opt_val_tbl(i).profile_option_name;
1955: l_prof_opt_val_tbl(l_index).profile_option_value :=
1956: p_fnd_profile_opt_val_tbl(i).profile_option_value;
1957: l_prof_opt_val_tbl(l_index).profile_level_name :=
1958: p_fnd_profile_opt_val_tbl(i).profile_level_name;
1959: l_prof_opt_val_tbl(l_index).profile_level_value :=
1960: p_fnd_profile_opt_val_tbl(i).profile_level_value;

Line 1958: p_fnd_profile_opt_val_tbl(i).profile_level_name;

1954: p_fnd_profile_opt_val_tbl(i).profile_option_name;
1955: l_prof_opt_val_tbl(l_index).profile_option_value :=
1956: p_fnd_profile_opt_val_tbl(i).profile_option_value;
1957: l_prof_opt_val_tbl(l_index).profile_level_name :=
1958: p_fnd_profile_opt_val_tbl(i).profile_level_name;
1959: l_prof_opt_val_tbl(l_index).profile_level_value :=
1960: p_fnd_profile_opt_val_tbl(i).profile_level_value;
1961: l_prof_opt_val_tbl(l_index).profile_level_value_app_id :=
1962: p_fnd_profile_opt_val_tbl(i).profile_level_value_app_id;

Line 1960: p_fnd_profile_opt_val_tbl(i).profile_level_value;

1956: p_fnd_profile_opt_val_tbl(i).profile_option_value;
1957: l_prof_opt_val_tbl(l_index).profile_level_name :=
1958: p_fnd_profile_opt_val_tbl(i).profile_level_name;
1959: l_prof_opt_val_tbl(l_index).profile_level_value :=
1960: p_fnd_profile_opt_val_tbl(i).profile_level_value;
1961: l_prof_opt_val_tbl(l_index).profile_level_value_app_id :=
1962: p_fnd_profile_opt_val_tbl(i).profile_level_value_app_id;
1963: END IF;
1964: END LOOP;

Line 1962: p_fnd_profile_opt_val_tbl(i).profile_level_value_app_id;

1958: p_fnd_profile_opt_val_tbl(i).profile_level_name;
1959: l_prof_opt_val_tbl(l_index).profile_level_value :=
1960: p_fnd_profile_opt_val_tbl(i).profile_level_value;
1961: l_prof_opt_val_tbl(l_index).profile_level_value_app_id :=
1962: p_fnd_profile_opt_val_tbl(i).profile_level_value_app_id;
1963: END IF;
1964: END LOOP;
1965:
1966:

Line 2461: nvl(fnd_profile.value('SIGNON_PASSWORD_LENGTH'), '5')

2457: -- profile option. If that profile option is null, the default is 5.
2458: --
2459: l_count := 0;
2460: l_count := to_number(
2461: nvl(fnd_profile.value('SIGNON_PASSWORD_LENGTH'), '5')
2462: );
2463:
2464: IF p_new_password = hr_api.g_varchar2
2465: THEN