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.

[Home] [Help]

APPS.HR_USER_ACCT_INTERNAL dependencies on PER_SEC_PROFILE_ASSIGNMENTS

Line 853: per_sec_profile_assignments.responsibility_application_id%type

849: ,p_sec_group_id in fnd_security_groups.security_group_id%type
850: ,p_sec_profile_id in per_security_profiles.security_profile_id%type
851: ,p_resp_key in fnd_responsibility.responsibility_key%type
852: ,p_resp_app_id in
853: per_sec_profile_assignments.responsibility_application_id%type
854: ,p_start_date in per_sec_profile_assignments.start_date%type
855: ,p_end_date in per_sec_profile_assignments.end_date%type
856: default null
857: ,p_business_group_id in per_sec_profile_assignments.business_group_id%type

Line 854: ,p_start_date in per_sec_profile_assignments.start_date%type

850: ,p_sec_profile_id in per_security_profiles.security_profile_id%type
851: ,p_resp_key in fnd_responsibility.responsibility_key%type
852: ,p_resp_app_id in
853: per_sec_profile_assignments.responsibility_application_id%type
854: ,p_start_date in per_sec_profile_assignments.start_date%type
855: ,p_end_date in per_sec_profile_assignments.end_date%type
856: default null
857: ,p_business_group_id in per_sec_profile_assignments.business_group_id%type
858: default null

Line 855: ,p_end_date in per_sec_profile_assignments.end_date%type

851: ,p_resp_key in fnd_responsibility.responsibility_key%type
852: ,p_resp_app_id in
853: per_sec_profile_assignments.responsibility_application_id%type
854: ,p_start_date in per_sec_profile_assignments.start_date%type
855: ,p_end_date in per_sec_profile_assignments.end_date%type
856: default null
857: ,p_business_group_id in per_sec_profile_assignments.business_group_id%type
858: default null
859: ) IS

Line 857: ,p_business_group_id in per_sec_profile_assignments.business_group_id%type

853: per_sec_profile_assignments.responsibility_application_id%type
854: ,p_start_date in per_sec_profile_assignments.start_date%type
855: ,p_end_date in per_sec_profile_assignments.end_date%type
856: default null
857: ,p_business_group_id in per_sec_profile_assignments.business_group_id%type
858: default null
859: ) IS
860: --
861: --

Line 889: per_sec_profile_assignments.sec_profile_assignment_id%type := null;

885: l_bg_id per_security_profiles.business_group_id%type := null;
886: l_resp_id fnd_responsibility.responsibility_id%type := null;
887: l_dummy number default null;
888: l_sec_prof_asg_id
889: per_sec_profile_assignments.sec_profile_assignment_id%type := null;
890: l_obj_vers_num
891: per_sec_profile_assignments.object_version_number%type := null;
892: l_proc varchar2(72) := g_package|| 'create_sec_profile_asg';
893:

Line 891: per_sec_profile_assignments.object_version_number%type := null;

887: l_dummy number default null;
888: l_sec_prof_asg_id
889: per_sec_profile_assignments.sec_profile_assignment_id%type := null;
890: l_obj_vers_num
891: per_sec_profile_assignments.object_version_number%type := null;
892: l_proc varchar2(72) := g_package|| 'create_sec_profile_asg';
893:
894: BEGIN
895: hr_utility.set_location('Entering:' || l_proc, 10);

Line 989: -- per_sec_profile_assignments as well as fnd_user_resp_groups.

985: END IF;
986: END IF;
987: --
988: -- Now call the per_asp_ins.ins which will insert a row into
989: -- per_sec_profile_assignments as well as fnd_user_resp_groups.
990: per_asp_ins.ins
991: (p_user_id => p_user_id
992: ,p_security_group_id => p_sec_group_id
993: ,p_business_group_id => l_bg_id

Line 2805: per_sec_profile_assignments.sec_profile_assignment_id%type default null

2801: -- ----------------------------------------------------------------------------
2802: --
2803: PROCEDURE update_sec_profile_asg
2804: (p_sec_profile_asg_id in
2805: per_sec_profile_assignments.sec_profile_assignment_id%type default null
2806: ,p_user_id in fnd_user.user_id%type default null
2807: ,p_responsibility_id in per_sec_profile_assignments.responsibility_id%type
2808: default null
2809: ,p_resp_app_id in

Line 2807: ,p_responsibility_id in per_sec_profile_assignments.responsibility_id%type

2803: PROCEDURE update_sec_profile_asg
2804: (p_sec_profile_asg_id in
2805: per_sec_profile_assignments.sec_profile_assignment_id%type default null
2806: ,p_user_id in fnd_user.user_id%type default null
2807: ,p_responsibility_id in per_sec_profile_assignments.responsibility_id%type
2808: default null
2809: ,p_resp_app_id in
2810: per_sec_profile_assignments.responsibility_application_id%type default null
2811: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type

Line 2810: per_sec_profile_assignments.responsibility_application_id%type default null

2806: ,p_user_id in fnd_user.user_id%type default null
2807: ,p_responsibility_id in per_sec_profile_assignments.responsibility_id%type
2808: default null
2809: ,p_resp_app_id in
2810: per_sec_profile_assignments.responsibility_application_id%type default null
2811: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
2812: default null
2813: ,p_start_date in per_sec_profile_assignments.start_date%type
2814: default null

Line 2813: ,p_start_date in per_sec_profile_assignments.start_date%type

2809: ,p_resp_app_id in
2810: per_sec_profile_assignments.responsibility_application_id%type default null
2811: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
2812: default null
2813: ,p_start_date in per_sec_profile_assignments.start_date%type
2814: default null
2815: ,p_end_date in per_sec_profile_assignments.end_date%type
2816: default null
2817: ,p_object_version_number in

Line 2815: ,p_end_date in per_sec_profile_assignments.end_date%type

2811: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
2812: default null
2813: ,p_start_date in per_sec_profile_assignments.start_date%type
2814: default null
2815: ,p_end_date in per_sec_profile_assignments.end_date%type
2816: default null
2817: ,p_object_version_number in
2818: per_sec_profile_assignments.object_version_number%type default null
2819: ) IS

Line 2818: per_sec_profile_assignments.object_version_number%type default null

2814: default null
2815: ,p_end_date in per_sec_profile_assignments.end_date%type
2816: default null
2817: ,p_object_version_number in
2818: per_sec_profile_assignments.object_version_number%type default null
2819: ) IS
2820: --
2821: --
2822:

Line 2833: FROM per_sec_profile_assignments

2829: CURSOR lc_get_sec_profile_asg_id IS
2830: SELECT sec_profile_assignment_id
2831: ,security_group_id
2832: ,business_group_id
2833: FROM per_sec_profile_assignments
2834: WHERE user_id = p_user_id
2835: AND responsibility_id = p_responsibility_id
2836: AND responsibility_application_id = p_resp_app_id
2837: AND security_group_id = p_security_group_id;

Line 2848: per_sec_profile_assignments.sec_profile_assignment_id%type := null;

2844:
2845: l_dummy number default null;
2846: l_resp_key fnd_responsibility.responsibility_key%type default null;
2847: l_sec_prof_asg_id
2848: per_sec_profile_assignments.sec_profile_assignment_id%type := null;
2849: l_security_group_id per_sec_profile_assignments.security_group_id%type
2850: default null;
2851: l_bg_id per_sec_profile_assignments.business_group_id%type
2852: default null;

Line 2849: l_security_group_id per_sec_profile_assignments.security_group_id%type

2845: l_dummy number default null;
2846: l_resp_key fnd_responsibility.responsibility_key%type default null;
2847: l_sec_prof_asg_id
2848: per_sec_profile_assignments.sec_profile_assignment_id%type := null;
2849: l_security_group_id per_sec_profile_assignments.security_group_id%type
2850: default null;
2851: l_bg_id per_sec_profile_assignments.business_group_id%type
2852: default null;
2853: l_obj_vers_num

Line 2851: l_bg_id per_sec_profile_assignments.business_group_id%type

2847: l_sec_prof_asg_id
2848: per_sec_profile_assignments.sec_profile_assignment_id%type := null;
2849: l_security_group_id per_sec_profile_assignments.security_group_id%type
2850: default null;
2851: l_bg_id per_sec_profile_assignments.business_group_id%type
2852: default null;
2853: l_obj_vers_num
2854: per_sec_profile_assignments.object_version_number%type := null;
2855: l_proc varchar2(72) := g_package|| 'update_sec_profile_asg';

Line 2854: per_sec_profile_assignments.object_version_number%type := null;

2850: default null;
2851: l_bg_id per_sec_profile_assignments.business_group_id%type
2852: default null;
2853: l_obj_vers_num
2854: per_sec_profile_assignments.object_version_number%type := null;
2855: l_proc varchar2(72) := g_package|| 'update_sec_profile_asg';
2856:
2857: BEGIN
2858: hr_utility.set_location('Entering:' || l_proc, 10);

Line 2953: -- per_sec_profile_assignments as well as fnd_user_resp_groups.

2949: END IF;
2950: --
2951: --
2952: -- Now call the per_asp_upd.upd which will update a row in
2953: -- per_sec_profile_assignments as well as fnd_user_resp_groups.
2954: --
2955: per_asp_upd.upd
2956: (p_sec_profile_assignment_id => l_sec_prof_asg_id
2957: ,p_object_version_number => l_obj_vers_num