DBA Data[Home] [Help]

APPS.HR_USER_ACCT_INTERNAL dependencies on FND_RESPONSIBILITY

Line 36: -- |---------------------- < create_fnd_responsibility > ----------------------|

32: );
33:
34: --
35: -- ----------------------------------------------------------------------------
36: -- |---------------------- < create_fnd_responsibility > ----------------------|
37: -- ----------------------------------------------------------------------------
38: --
39: PROCEDURE create_fnd_responsibility
40: (p_resp_key in fnd_responsibility.responsibility_key%type

Line 39: PROCEDURE create_fnd_responsibility

35: -- ----------------------------------------------------------------------------
36: -- |---------------------- < create_fnd_responsibility > ----------------------|
37: -- ----------------------------------------------------------------------------
38: --
39: PROCEDURE create_fnd_responsibility
40: (p_resp_key in fnd_responsibility.responsibility_key%type
41: ,p_resp_name in fnd_responsibility_tl.responsibility_name%type
42: ,p_resp_app_id in fnd_responsibility.application_id%type
43: ,p_resp_description in fnd_responsibility_tl.description%type

Line 40: (p_resp_key in fnd_responsibility.responsibility_key%type

36: -- |---------------------- < create_fnd_responsibility > ----------------------|
37: -- ----------------------------------------------------------------------------
38: --
39: PROCEDURE create_fnd_responsibility
40: (p_resp_key in fnd_responsibility.responsibility_key%type
41: ,p_resp_name in fnd_responsibility_tl.responsibility_name%type
42: ,p_resp_app_id in fnd_responsibility.application_id%type
43: ,p_resp_description in fnd_responsibility_tl.description%type
44: default null

Line 41: ,p_resp_name in fnd_responsibility_tl.responsibility_name%type

37: -- ----------------------------------------------------------------------------
38: --
39: PROCEDURE create_fnd_responsibility
40: (p_resp_key in fnd_responsibility.responsibility_key%type
41: ,p_resp_name in fnd_responsibility_tl.responsibility_name%type
42: ,p_resp_app_id in fnd_responsibility.application_id%type
43: ,p_resp_description in fnd_responsibility_tl.description%type
44: default null
45: ,p_start_date in fnd_responsibility.start_date%type

Line 42: ,p_resp_app_id in fnd_responsibility.application_id%type

38: --
39: PROCEDURE create_fnd_responsibility
40: (p_resp_key in fnd_responsibility.responsibility_key%type
41: ,p_resp_name in fnd_responsibility_tl.responsibility_name%type
42: ,p_resp_app_id in fnd_responsibility.application_id%type
43: ,p_resp_description in fnd_responsibility_tl.description%type
44: default null
45: ,p_start_date in fnd_responsibility.start_date%type
46: ,p_end_date in fnd_responsibility.end_date%type default null

Line 43: ,p_resp_description in fnd_responsibility_tl.description%type

39: PROCEDURE create_fnd_responsibility
40: (p_resp_key in fnd_responsibility.responsibility_key%type
41: ,p_resp_name in fnd_responsibility_tl.responsibility_name%type
42: ,p_resp_app_id in fnd_responsibility.application_id%type
43: ,p_resp_description in fnd_responsibility_tl.description%type
44: default null
45: ,p_start_date in fnd_responsibility.start_date%type
46: ,p_end_date in fnd_responsibility.end_date%type default null
47: ,p_data_group_name in fnd_data_groups_standard_view.data_group_name%type

Line 45: ,p_start_date in fnd_responsibility.start_date%type

41: ,p_resp_name in fnd_responsibility_tl.responsibility_name%type
42: ,p_resp_app_id in fnd_responsibility.application_id%type
43: ,p_resp_description in fnd_responsibility_tl.description%type
44: default null
45: ,p_start_date in fnd_responsibility.start_date%type
46: ,p_end_date in fnd_responsibility.end_date%type default null
47: ,p_data_group_name in fnd_data_groups_standard_view.data_group_name%type
48: ,p_data_group_app_id in fnd_responsibility.data_group_application_id%type
49: ,p_menu_name in fnd_menus.menu_name%type

Line 46: ,p_end_date in fnd_responsibility.end_date%type default null

42: ,p_resp_app_id in fnd_responsibility.application_id%type
43: ,p_resp_description in fnd_responsibility_tl.description%type
44: default null
45: ,p_start_date in fnd_responsibility.start_date%type
46: ,p_end_date in fnd_responsibility.end_date%type default null
47: ,p_data_group_name in fnd_data_groups_standard_view.data_group_name%type
48: ,p_data_group_app_id in fnd_responsibility.data_group_application_id%type
49: ,p_menu_name in fnd_menus.menu_name%type
50: ,p_request_group_name in fnd_request_groups.request_group_name%type

Line 48: ,p_data_group_app_id in fnd_responsibility.data_group_application_id%type

44: default null
45: ,p_start_date in fnd_responsibility.start_date%type
46: ,p_end_date in fnd_responsibility.end_date%type default null
47: ,p_data_group_name in fnd_data_groups_standard_view.data_group_name%type
48: ,p_data_group_app_id in fnd_responsibility.data_group_application_id%type
49: ,p_menu_name in fnd_menus.menu_name%type
50: ,p_request_group_name in fnd_request_groups.request_group_name%type
51: default null
52: ,p_request_group_app_id in fnd_responsibility.group_application_id%type

Line 52: ,p_request_group_app_id in fnd_responsibility.group_application_id%type

48: ,p_data_group_app_id in fnd_responsibility.data_group_application_id%type
49: ,p_menu_name in fnd_menus.menu_name%type
50: ,p_request_group_name in fnd_request_groups.request_group_name%type
51: default null
52: ,p_request_group_app_id in fnd_responsibility.group_application_id%type
53: default null
54: ,p_version in fnd_responsibility.version%type default '4'
55: ,p_web_host_name in fnd_responsibility.web_host_name%type default null
56: ,p_web_agent_name in fnd_responsibility.web_agent_name%type

Line 54: ,p_version in fnd_responsibility.version%type default '4'

50: ,p_request_group_name in fnd_request_groups.request_group_name%type
51: default null
52: ,p_request_group_app_id in fnd_responsibility.group_application_id%type
53: default null
54: ,p_version in fnd_responsibility.version%type default '4'
55: ,p_web_host_name in fnd_responsibility.web_host_name%type default null
56: ,p_web_agent_name in fnd_responsibility.web_agent_name%type
57: default null
58: ,p_responsibility_id out nocopy number

Line 55: ,p_web_host_name in fnd_responsibility.web_host_name%type default null

51: default null
52: ,p_request_group_app_id in fnd_responsibility.group_application_id%type
53: default null
54: ,p_version in fnd_responsibility.version%type default '4'
55: ,p_web_host_name in fnd_responsibility.web_host_name%type default null
56: ,p_web_agent_name in fnd_responsibility.web_agent_name%type
57: default null
58: ,p_responsibility_id out nocopy number
59: );

Line 56: ,p_web_agent_name in fnd_responsibility.web_agent_name%type

52: ,p_request_group_app_id in fnd_responsibility.group_application_id%type
53: default null
54: ,p_version in fnd_responsibility.version%type default '4'
55: ,p_web_host_name in fnd_responsibility.web_host_name%type default null
56: ,p_web_agent_name in fnd_responsibility.web_agent_name%type
57: default null
58: ,p_responsibility_id out nocopy number
59: );
60: --

Line 68: ,p_responsibility_id in fnd_responsibility.responsibility_id%type

64: -- ----------------------------------------------------------------------------
65: --
66: PROCEDURE create_fnd_user_resp_groups
67: (p_user_id in fnd_user.user_id%type
68: ,p_responsibility_id in fnd_responsibility.responsibility_id%type
69: ,p_application_id in
70: fnd_user_resp_groups.responsibility_application_id%type
71: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type
72: ,p_start_date in fnd_user_resp_groups.start_date%type

Line 87: ,p_resp_key in fnd_responsibility.responsibility_key%type

83: PROCEDURE create_sec_profile_asg
84: (p_user_id in fnd_user.user_id%type
85: ,p_sec_group_id in fnd_security_groups.security_group_id%type
86: ,p_sec_profile_id in per_security_profiles.security_profile_id%type
87: ,p_resp_key in fnd_responsibility.responsibility_key%type
88: ,p_resp_app_id in
89: per_sec_profile_assignments.responsibility_application_id%type
90: ,p_start_date in per_sec_profile_assignments.start_date%type
91: ,p_end_date in per_sec_profile_assignments.end_date%type

Line 189: (p_template_resp_id in fnd_responsibility.responsibility_id%type

185: -- ----------------------------------------------------------------------------
186: -- |----------------------- < build_resp_profile_val > -----------------------|
187: -- ----------------------------------------------------------------------------
188: PROCEDURE build_resp_profile_val
189: (p_template_resp_id in fnd_responsibility.responsibility_id%type
190: default null
191: ,p_template_resp_app_id in fnd_responsibility.application_id%type
192: default null
193: ,p_new_resp_key in fnd_responsibility.responsibility_key%type

Line 191: ,p_template_resp_app_id in fnd_responsibility.application_id%type

187: -- ----------------------------------------------------------------------------
188: PROCEDURE build_resp_profile_val
189: (p_template_resp_id in fnd_responsibility.responsibility_id%type
190: default null
191: ,p_template_resp_app_id in fnd_responsibility.application_id%type
192: default null
193: ,p_new_resp_key in fnd_responsibility.responsibility_key%type
194: ,p_new_resp_app_id in fnd_responsibility.application_id%type
195: ,p_fnd_profile_opt_val_tbl in

Line 193: ,p_new_resp_key in fnd_responsibility.responsibility_key%type

189: (p_template_resp_id in fnd_responsibility.responsibility_id%type
190: default null
191: ,p_template_resp_app_id in fnd_responsibility.application_id%type
192: default null
193: ,p_new_resp_key in fnd_responsibility.responsibility_key%type
194: ,p_new_resp_app_id in fnd_responsibility.application_id%type
195: ,p_fnd_profile_opt_val_tbl in
196: hr_user_acct_utility.fnd_profile_opt_val_tbl
197: ,p_out_profile_opt_val_tbl out

Line 194: ,p_new_resp_app_id in fnd_responsibility.application_id%type

190: default null
191: ,p_template_resp_app_id in fnd_responsibility.application_id%type
192: default null
193: ,p_new_resp_key in fnd_responsibility.responsibility_key%type
194: ,p_new_resp_app_id in fnd_responsibility.application_id%type
195: ,p_fnd_profile_opt_val_tbl in
196: hr_user_acct_utility.fnd_profile_opt_val_tbl
197: ,p_out_profile_opt_val_tbl out
198: hr_user_acct_utility.fnd_profile_opt_val_tbl

Line 214: (p_resp_key in fnd_responsibility.responsibility_key%type

210: -- |--------------------- < create_fnd_resp_functions > ----------------------|
211: -- ----------------------------------------------------------------------------
212: --
213: PROCEDURE create_fnd_resp_functions
214: (p_resp_key in fnd_responsibility.responsibility_key%type
215: ,p_rule_type in fnd_resp_functions.rule_type%type
216: ,p_rule_name in varchar2
217: ,p_delete_flag in varchar2 default 'N');
218: --