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 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 2770: per_sec_profile_assignments.sec_profile_assignment_id%type default null

2766: -- ----------------------------------------------------------------------------
2767: --
2768: PROCEDURE update_sec_profile_asg
2769: (p_sec_profile_asg_id in
2770: per_sec_profile_assignments.sec_profile_assignment_id%type default null
2771: ,p_user_id in fnd_user.user_id%type default null
2772: ,p_responsibility_id in per_sec_profile_assignments.responsibility_id%type
2773: default null
2774: ,p_resp_app_id in

Line 2772: ,p_responsibility_id in per_sec_profile_assignments.responsibility_id%type

2768: PROCEDURE update_sec_profile_asg
2769: (p_sec_profile_asg_id in
2770: per_sec_profile_assignments.sec_profile_assignment_id%type default null
2771: ,p_user_id in fnd_user.user_id%type default null
2772: ,p_responsibility_id in per_sec_profile_assignments.responsibility_id%type
2773: default null
2774: ,p_resp_app_id in
2775: per_sec_profile_assignments.responsibility_application_id%type default null
2776: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type

Line 2775: per_sec_profile_assignments.responsibility_application_id%type default null

2771: ,p_user_id in fnd_user.user_id%type default null
2772: ,p_responsibility_id in per_sec_profile_assignments.responsibility_id%type
2773: default null
2774: ,p_resp_app_id in
2775: per_sec_profile_assignments.responsibility_application_id%type default null
2776: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
2777: default null
2778: ,p_start_date in per_sec_profile_assignments.start_date%type
2779: default null

Line 2778: ,p_start_date in per_sec_profile_assignments.start_date%type

2774: ,p_resp_app_id in
2775: per_sec_profile_assignments.responsibility_application_id%type default null
2776: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
2777: default null
2778: ,p_start_date in per_sec_profile_assignments.start_date%type
2779: default null
2780: ,p_end_date in per_sec_profile_assignments.end_date%type
2781: default null
2782: ,p_object_version_number in

Line 2780: ,p_end_date in per_sec_profile_assignments.end_date%type

2776: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
2777: default null
2778: ,p_start_date in per_sec_profile_assignments.start_date%type
2779: default null
2780: ,p_end_date in per_sec_profile_assignments.end_date%type
2781: default null
2782: ,p_object_version_number in
2783: per_sec_profile_assignments.object_version_number%type default null
2784: ) IS

Line 2783: per_sec_profile_assignments.object_version_number%type default null

2779: default null
2780: ,p_end_date in per_sec_profile_assignments.end_date%type
2781: default null
2782: ,p_object_version_number in
2783: per_sec_profile_assignments.object_version_number%type default null
2784: ) IS
2785: --
2786: --
2787:

Line 2798: FROM per_sec_profile_assignments

2794: CURSOR lc_get_sec_profile_asg_id IS
2795: SELECT sec_profile_assignment_id
2796: ,security_group_id
2797: ,business_group_id
2798: FROM per_sec_profile_assignments
2799: WHERE user_id = p_user_id
2800: AND responsibility_id = p_responsibility_id
2801: AND responsibility_application_id = p_resp_app_id
2802: AND security_group_id = p_security_group_id;

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

2809:
2810: l_dummy number default null;
2811: l_resp_key fnd_responsibility.responsibility_key%type default null;
2812: l_sec_prof_asg_id
2813: per_sec_profile_assignments.sec_profile_assignment_id%type := null;
2814: l_security_group_id per_sec_profile_assignments.security_group_id%type
2815: default null;
2816: l_bg_id per_sec_profile_assignments.business_group_id%type
2817: default null;

Line 2814: l_security_group_id per_sec_profile_assignments.security_group_id%type

2810: l_dummy number default null;
2811: l_resp_key fnd_responsibility.responsibility_key%type default null;
2812: l_sec_prof_asg_id
2813: per_sec_profile_assignments.sec_profile_assignment_id%type := null;
2814: l_security_group_id per_sec_profile_assignments.security_group_id%type
2815: default null;
2816: l_bg_id per_sec_profile_assignments.business_group_id%type
2817: default null;
2818: l_obj_vers_num

Line 2816: l_bg_id per_sec_profile_assignments.business_group_id%type

2812: l_sec_prof_asg_id
2813: per_sec_profile_assignments.sec_profile_assignment_id%type := null;
2814: l_security_group_id per_sec_profile_assignments.security_group_id%type
2815: default null;
2816: l_bg_id per_sec_profile_assignments.business_group_id%type
2817: default null;
2818: l_obj_vers_num
2819: per_sec_profile_assignments.object_version_number%type := null;
2820: l_proc varchar2(72) := g_package|| 'update_sec_profile_asg';

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

2815: default null;
2816: l_bg_id per_sec_profile_assignments.business_group_id%type
2817: default null;
2818: l_obj_vers_num
2819: per_sec_profile_assignments.object_version_number%type := null;
2820: l_proc varchar2(72) := g_package|| 'update_sec_profile_asg';
2821:
2822: BEGIN
2823: hr_utility.set_location('Entering:' || l_proc, 10);

Line 2918: -- per_sec_profile_assignments as well as fnd_user_resp_groups.

2914: END IF;
2915: --
2916: --
2917: -- Now call the per_asp_upd.upd which will update a row in
2918: -- per_sec_profile_assignments as well as fnd_user_resp_groups.
2919: --
2920: per_asp_upd.upd
2921: (p_sec_profile_assignment_id => l_sec_prof_asg_id
2922: ,p_object_version_number => l_obj_vers_num