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 FND_USER_RESP_GROUPS

Line 678: -- |-------------------- < create_fnd_user_resp_groups > ----------------------|

674:
675: END create_fnd_responsibility;
676: --
677: -- ----------------------------------------------------------------------------
678: -- |-------------------- < create_fnd_user_resp_groups > ----------------------|
679: -- |NOTE: No savepoint will be issued here because business support internal |
680: -- | process is not supposed to issue any savepoint or rollback. |
681: -- ----------------------------------------------------------------------------
682: --

Line 683: PROCEDURE create_fnd_user_resp_groups

679: -- |NOTE: No savepoint will be issued here because business support internal |
680: -- | process is not supposed to issue any savepoint or rollback. |
681: -- ----------------------------------------------------------------------------
682: --
683: PROCEDURE create_fnd_user_resp_groups
684: (p_user_id in fnd_user.user_id%type
685: ,p_responsibility_id in fnd_responsibility.responsibility_id%type
686: ,p_application_id in
687: fnd_user_resp_groups.responsibility_application_id%type

Line 687: fnd_user_resp_groups.responsibility_application_id%type

683: PROCEDURE create_fnd_user_resp_groups
684: (p_user_id in fnd_user.user_id%type
685: ,p_responsibility_id in fnd_responsibility.responsibility_id%type
686: ,p_application_id in
687: fnd_user_resp_groups.responsibility_application_id%type
688: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type
689: ,p_start_date in fnd_user_resp_groups.start_date%type
690: ,p_end_date in fnd_user_resp_groups.end_date%type
691: default null

Line 688: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type

684: (p_user_id in fnd_user.user_id%type
685: ,p_responsibility_id in fnd_responsibility.responsibility_id%type
686: ,p_application_id in
687: fnd_user_resp_groups.responsibility_application_id%type
688: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type
689: ,p_start_date in fnd_user_resp_groups.start_date%type
690: ,p_end_date in fnd_user_resp_groups.end_date%type
691: default null
692: ,p_description in fnd_user_resp_groups.description%type

Line 689: ,p_start_date in fnd_user_resp_groups.start_date%type

685: ,p_responsibility_id in fnd_responsibility.responsibility_id%type
686: ,p_application_id in
687: fnd_user_resp_groups.responsibility_application_id%type
688: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type
689: ,p_start_date in fnd_user_resp_groups.start_date%type
690: ,p_end_date in fnd_user_resp_groups.end_date%type
691: default null
692: ,p_description in fnd_user_resp_groups.description%type
693: default null

Line 690: ,p_end_date in fnd_user_resp_groups.end_date%type

686: ,p_application_id in
687: fnd_user_resp_groups.responsibility_application_id%type
688: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type
689: ,p_start_date in fnd_user_resp_groups.start_date%type
690: ,p_end_date in fnd_user_resp_groups.end_date%type
691: default null
692: ,p_description in fnd_user_resp_groups.description%type
693: default null
694: ) IS

Line 692: ,p_description in fnd_user_resp_groups.description%type

688: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type
689: ,p_start_date in fnd_user_resp_groups.start_date%type
690: ,p_end_date in fnd_user_resp_groups.end_date%type
691: default null
692: ,p_description in fnd_user_resp_groups.description%type
693: default null
694: ) IS
695: --
696: CURSOR lc_get_user_id IS

Line 714: FROM fnd_user_resp_groups

710: --
711: --
712: CURSOR lc_unique_user_resp_groups IS
713: SELECT user_id
714: FROM fnd_user_resp_groups
715: WHERE user_id = p_user_id
716: AND responsibility_application_id = p_application_id
717: AND responsibility_id = p_responsibility_id
718: AND security_group_id = p_sec_group_id;

Line 720: l_proc varchar2(72) := g_package || 'create_fnd_user_resp_groups';

716: AND responsibility_application_id = p_application_id
717: AND responsibility_id = p_responsibility_id
718: AND security_group_id = p_sec_group_id;
719:
720: l_proc varchar2(72) := g_package || 'create_fnd_user_resp_groups';
721: l_dummy number default null;
722: --
723: BEGIN
724: hr_utility.set_location('Entering:' || l_proc, 10);

Line 823: -- Now call the fnd_user_resp_groups_api

819: hr_utility.raise_error;
820: END IF;
821: END IF;
822: --
823: -- Now call the fnd_user_resp_groups_api
824: --
825: hr_utility.set_location(l_proc ||
826: ' before fnd_user_resp_groups_api.insert_assignment', 30);
827: --

Line 826: ' before fnd_user_resp_groups_api.insert_assignment', 30);

822: --
823: -- Now call the fnd_user_resp_groups_api
824: --
825: hr_utility.set_location(l_proc ||
826: ' before fnd_user_resp_groups_api.insert_assignment', 30);
827: --
828: fnd_user_resp_groups_api.insert_assignment
829: (user_id => p_user_id
830: ,responsibility_id => p_responsibility_id

Line 828: fnd_user_resp_groups_api.insert_assignment

824: --
825: hr_utility.set_location(l_proc ||
826: ' before fnd_user_resp_groups_api.insert_assignment', 30);
827: --
828: fnd_user_resp_groups_api.insert_assignment
829: (user_id => p_user_id
830: ,responsibility_id => p_responsibility_id
831: ,responsibility_application_id => p_application_id
832: ,security_group_id => p_sec_group_id

Line 841: END create_fnd_user_resp_groups;

837:
838: --
839: hr_utility.set_location('Leaving:'||l_proc, 50);
840:
841: END create_fnd_user_resp_groups;
842: --
843: -- ----------------------------------------------------------------------------
844: -- |---------------------- < create_sec_profile_asg > ------------------------|
845: -- ----------------------------------------------------------------------------

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 2533: -- |-------------------- < update_fnd_user_resp_groups > ----------------------|

2529:
2530: END update_fnd_user;
2531: --
2532: -- ----------------------------------------------------------------------------
2533: -- |-------------------- < update_fnd_user_resp_groups > ----------------------|
2534: -- |NOTE: No savepoint will be issued here because business support internal |
2535: -- | process is not supposed to issue any savepoint or rollback. |
2536: -- ----------------------------------------------------------------------------
2537: --

Line 2538: PROCEDURE update_fnd_user_resp_groups

2534: -- |NOTE: No savepoint will be issued here because business support internal |
2535: -- | process is not supposed to issue any savepoint or rollback. |
2536: -- ----------------------------------------------------------------------------
2537: --
2538: PROCEDURE update_fnd_user_resp_groups
2539: (p_user_id in number
2540: ,p_responsibility_id in number
2541: ,p_resp_application_id in number
2542: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type

Line 2542: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type

2538: PROCEDURE update_fnd_user_resp_groups
2539: (p_user_id in number
2540: ,p_responsibility_id in number
2541: ,p_resp_application_id in number
2542: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
2543: ,p_start_date in date default hr_api.g_date
2544: ,p_end_date in date default hr_api.g_date
2545: ,p_description in varchar2 default hr_api.g_varchar2
2546: ) IS

Line 2565: -- fnd_user_resp_groups should function like R11 fnd_user_responsibility, the

2561: FROM fnd_application
2562: WHERE application_id = p_resp_application_id;
2563: --
2564: -- When ENABLED_SECURITY_GROUPS profile option = 'N', then the
2565: -- fnd_user_resp_groups should function like R11 fnd_user_responsibility, the
2566: -- security_group_id is 0 and there should not be more than 1 row for the
2567: -- combination of user_id, responsibility_id, application_id and
2568: -- security_group_id.
2569:

Line 2572: FROM fnd_user_resp_groups

2568: -- security_group_id.
2569:
2570: CURSOR lc_unique_user_resp IS
2571: SELECT count(*)
2572: FROM fnd_user_resp_groups
2573: WHERE user_id = p_user_id
2574: AND responsibility_id = p_responsibility_id
2575: AND responsibility_application_id = p_resp_application_id
2576: AND security_group_id = p_security_group_id;

Line 2584: FROM fnd_user_resp_groups

2580: ,responsibility_id
2581: ,start_date
2582: ,end_date
2583: ,description
2584: FROM fnd_user_resp_groups
2585: WHERE user_id = p_user_id
2586: AND responsibility_id = p_responsibility_id
2587: AND responsibility_application_id = p_resp_application_id
2588: AND security_group_id = p_security_group_id;

Line 2596: FROM fnd_user_resp_groups_direct

2592: ,responsibility_id
2593: ,start_date
2594: ,end_date
2595: ,description
2596: FROM fnd_user_resp_groups_direct
2597: WHERE user_id = p_user_id
2598: AND responsibility_id = p_responsibility_id
2599: AND responsibility_application_id = p_resp_application_id
2600: AND security_group_id = p_security_group_id;

Line 2602: l_proc varchar2(72) := g_package||'update_fnd_user_resp_groups';

2598: AND responsibility_id = p_responsibility_id
2599: AND responsibility_application_id = p_resp_application_id
2600: AND security_group_id = p_security_group_id;
2601:
2602: l_proc varchar2(72) := g_package||'update_fnd_user_resp_groups';
2603: l_count number default null;
2604: l_dummy number default null;
2605: l_start_date date default null;
2606: l_end_date date default null;

Line 2607: l_description fnd_user_resp_groups.description%type default null;

2603: l_count number default null;
2604: l_dummy number default null;
2605: l_start_date date default null;
2606: l_end_date date default null;
2607: l_description fnd_user_resp_groups.description%type default null;
2608: l_resp_key fnd_responsibility.responsibility_key%type default null;
2609: l_fnd_user_resp_data lc_user_resp_row%rowtype;
2610: --
2611: BEGIN

Line 2701: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');

2697: NULL;
2698: /*
2699: CLOSE lc_unique_user_resp;
2700: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2701: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2702: fnd_message.set_token('COLUMN', 'USER_ID');
2703: fnd_message.set_token('VALUE', to_char(p_user_id));
2704: hr_utility.raise_error;
2705: */

Line 2714: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');

2710: -- It's an error, the user responsibility record must exist before
2711: -- this program is invoked.
2712: -- CLOSE lc_unique_user_resp;
2713: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2714: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2715: fnd_message.set_token('COLUMN', 'USER_ID');
2716: fnd_message.set_token('VALUE', to_char(p_user_id));
2717: hr_utility.raise_error;
2718: END;

Line 2721: -- Get existing fnd_user_resp_groups data

2717: hr_utility.raise_error;
2718: END;
2719: --
2720: -- Bug #1341128 Fix
2721: -- Get existing fnd_user_resp_groups data
2722: /*
2723: Bug fix 8582264
2724: When 2 responsibilities have same responsibility_id , but different
2725: application_ids and one of those responsibility is end dated, l_dummy

Line 2727: FND_USER_RESP_GROUPS_DIRECT instead of FND_USER_RESP_GROUPS

2723: Bug fix 8582264
2724: When 2 responsibilities have same responsibility_id , but different
2725: application_ids and one of those responsibility is end dated, l_dummy
2726: will be 0. In this case, we will fetch the data from
2727: FND_USER_RESP_GROUPS_DIRECT instead of FND_USER_RESP_GROUPS
2728: */
2729:
2730: IF l_dummy = 0 OR l_dummy IS NULL THEN
2731: OPEN lc_user_resp_direct_row;

Line 2777: -- Now call the fnd_user_resp_groups_api

2773: l_description := p_description;
2774: END IF;
2775: --
2776: --
2777: -- Now call the fnd_user_resp_groups_api
2778: --
2779: hr_utility.set_location(l_proc ||
2780: ' before fnd_user_resp_groups_api.update_assignment', 30);
2781: hr_utility.set_location(l_proc || ' Passing p_user_id=' || p_user_id , 31);

Line 2780: ' before fnd_user_resp_groups_api.update_assignment', 30);

2776: --
2777: -- Now call the fnd_user_resp_groups_api
2778: --
2779: hr_utility.set_location(l_proc ||
2780: ' before fnd_user_resp_groups_api.update_assignment', 30);
2781: hr_utility.set_location(l_proc || ' Passing p_user_id=' || p_user_id , 31);
2782: hr_utility.set_location(l_proc || ' Security_group_id=' || p_security_group_id ,32);
2783: --
2784: fnd_user_resp_groups_api.update_assignment

Line 2784: fnd_user_resp_groups_api.update_assignment

2780: ' before fnd_user_resp_groups_api.update_assignment', 30);
2781: hr_utility.set_location(l_proc || ' Passing p_user_id=' || p_user_id , 31);
2782: hr_utility.set_location(l_proc || ' Security_group_id=' || p_security_group_id ,32);
2783: --
2784: fnd_user_resp_groups_api.update_assignment
2785: (user_id => p_user_id
2786: ,responsibility_id => p_responsibility_id
2787: ,responsibility_application_id => p_resp_application_id
2788: ,security_group_id =>p_security_group_id -- Fix 2978610

Line 2797: END update_fnd_user_resp_groups;

2793: --
2794: --
2795: hr_utility.set_location('Leaving:'||l_proc, 50);
2796:
2797: END update_fnd_user_resp_groups;
2798: --
2799: -- ----------------------------------------------------------------------------
2800: -- |---------------------- < update_sec_profile_asg > ------------------------|
2801: -- ----------------------------------------------------------------------------

Line 2811: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type

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
2815: ,p_end_date in per_sec_profile_assignments.end_date%type

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