DBA Data[Home] [Help]

APPS.HR_USER_ACCT_INTERNAL dependencies on FND_RESP_FUNCTIONS

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 2038: FROM fnd_resp_functions

2034: ,p_app_id in
2035: fnd_responsibility.application_id%TYPE)
2036: IS
2037: SELECT action_id, rule_type
2038: FROM fnd_resp_functions
2039: WHERE application_id = p_app_id
2040: AND responsibility_id = p_resp_id;
2041: --
2042:

Line 2180: -- |--------------------- < create_fnd_resp_functions > -----------------------|

2176: END build_func_sec_exclusion_rules;
2177: --
2178: --
2179: -- ----------------------------------------------------------------------------
2180: -- |--------------------- < create_fnd_resp_functions > -----------------------|
2181: -- |NOTE: No savepoint will be issued here because business support internal |
2182: -- | process is not supposed to issue any savepoint or rollback. |
2183: -- ----------------------------------------------------------------------------
2184: --

Line 2185: PROCEDURE create_fnd_resp_functions

2181: -- |NOTE: No savepoint will be issued here because business support internal |
2182: -- | process is not supposed to issue any savepoint or rollback. |
2183: -- ----------------------------------------------------------------------------
2184: --
2185: PROCEDURE create_fnd_resp_functions
2186: (p_resp_key in fnd_responsibility.responsibility_key%type
2187: ,p_rule_type in fnd_resp_functions.rule_type%type
2188: ,p_rule_name in varchar2
2189: ,p_delete_flag in varchar2 default 'N')

Line 2187: ,p_rule_type in fnd_resp_functions.rule_type%type

2183: -- ----------------------------------------------------------------------------
2184: --
2185: PROCEDURE create_fnd_resp_functions
2186: (p_resp_key in fnd_responsibility.responsibility_key%type
2187: ,p_rule_type in fnd_resp_functions.rule_type%type
2188: ,p_rule_name in varchar2
2189: ,p_delete_flag in varchar2 default 'N')
2190: IS
2191: --

Line 2211: 'create_fnd_resp_functions';

2207: FROM fnd_menus
2208: WHERE menu_name = p_rule_name;
2209: --
2210: l_proc varchar2(72) := g_package ||
2211: 'create_fnd_resp_functions';
2212:
2213: l_temp_id number default null;
2214: --
2215: --

Line 2290: END create_fnd_resp_functions;

2286: --
2287: hr_utility.set_location('Leaving:'|| l_proc, 50);
2288: --
2289: --
2290: END create_fnd_resp_functions;
2291: --
2292: -- ----------------------------------------------------------------------------
2293: -- |-------------------------- < update_fnd_user > ----------------------------|
2294: -- |NOTE: No savepoint will be issued here because business support internal |