APPS.HR_USER_ACCT_INTERNAL dependencies on HR_USER_ACCT_UTILITY

Line 11: g_empty_fnd_user_rec hr_user_acct_utility.fnd_user_rec;

7: g_max_user_name_length constant number := 100;
8: g_max_email_address_length constant number := 240;
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: -- ----------------------------------------------------------------------------

Line 12: g_emtpy_fnd_resp_tbl hr_user_acct_utility.fnd_responsibility_tbl;

8: g_max_email_address_length constant number := 240;
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 > ---------------------------|

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 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 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 2021: (p_func_sec_excl_tbl in hr_user_acct_utility.fnd_resp_functions_tbl

2017: -- ----------------------------------------------------------------------------
2018: -- |-------------------- < build_func_sec_exclusion_rules > -------------------|
2019: -- ----------------------------------------------------------------------------
2020: PROCEDURE build_func_sec_exclusion_rules
2021: (p_func_sec_excl_tbl in hr_user_acct_utility.fnd_resp_functions_tbl
2022: ,p_out_func_sec_excl_tbl out nocopy hr_user_acct_utility.func_sec_excl_tbl)
2023: IS
2024: --
2025: CURSOR lc_get_resp_id (p_resp_key in

Line 2022: ,p_out_func_sec_excl_tbl out nocopy hr_user_acct_utility.func_sec_excl_tbl)

2018: -- |-------------------- < build_func_sec_exclusion_rules > -------------------|
2019: -- ----------------------------------------------------------------------------
2020: PROCEDURE build_func_sec_exclusion_rules
2021: (p_func_sec_excl_tbl in hr_user_acct_utility.fnd_resp_functions_tbl
2022: ,p_out_func_sec_excl_tbl out nocopy hr_user_acct_utility.func_sec_excl_tbl)
2023: IS
2024: --
2025: CURSOR lc_get_resp_id (p_resp_key in
2026: fnd_responsibility.responsibility_key%TYPE)

Line 2062: l_out_func_sec_excl_tbl hr_user_acct_utility.func_sec_excl_tbl;

2058: l_resp_rec lc_get_resp_id%rowtype;
2059: l_resp_func_rec lc_get_resp_func%rowtype;
2060: l_index binary_integer default 0;
2061: l_func_sec_excl_tbl_count integer default 0;
2062: l_out_func_sec_excl_tbl hr_user_acct_utility.func_sec_excl_tbl;
2063: l_rule_name fnd_menus.menu_name%type;
2064: l_func_sec_excl_err exception;
2065: --
2066: BEGIN