APPS.PA_ROLE_UTILS dependencies on PA_PROJECT_PARTIES

Line 459: --1.Roles in pa_project_parties table can not be deleted

455:
456: --- PROCEDURE Check_delete_role_OK
457: ---This procedure will check if the role can be deleted or not.
458: -- Here are the rules:
459: --1.Roles in pa_project_parties table can not be deleted
460: --2.Roles in pa_project_assignments table can not be deleted
461: --3.Roles in any contracts team table (?) can not be deleted
462: --4 Pre-seeded roles can not be deleted. We decide the pre-seeded roles by
463: -- the project_role_id. All pre-seeded roles should have project_role_id <1000

Line 515: ---pa_project_parties in a certain way

511: -- for the role
512: ---Business rules:
513: ---The user is not allowed to remove any of the controls if
514: ---the role is in use and the role control matches the object_type in
515: ---pa_project_parties in a certain way
516: --If the x_return_status is 'S', then the role control can not be removed
517: --If the x_return_status is 'E', then the role control can not be removed
518: --If the x_return_status is 'U', then unexpected error happen
519: --x_error_message_code is the fnd message code if the x_return_status is 'E'

Line 549: ------consider the object_type in pa_project_parties

545:
546: Begin
547:
548: ------The following logic need be modified later to
549: ------consider the object_type in pa_project_parties
550:
551: open c_seed_roles;
552: fetch c_seed_roles into v_dummy;
553: if c_seed_roles%FOUND then

Line 648: ---If a role has a menu and the role is used in pa_project_parties (fnd_grants)then

644: /*---PROCEDURE Check_change_role_menu_OK
645: ---This procedure check if the user can change the menu for the role
646: ---Here, 'change' means changing the menu_id by choosing another menu for the role,
647: --- instead of changing functions for the same menu in the menu form
648: ---If a role has a menu and the role is used in pa_project_parties (fnd_grants)then
649: ---the menu can not be changed in the role
650: PROCEDURE Check_change_role_menu_OK(p_role_id in number
651: ,x_return_status out varchar2
652: ,x_error_message_code out varchar2) IS

Line 695: from pa_project_parties

691:
692: begin
693: select count(*)
694: into l_count
695: from pa_project_parties
696: where project_role_id = p_role_id;
697:
698: IF l_count > 0 THEN
699:

Line 743: from pa_project_parties

739:
740: begin
741: select count(*)
742: into l_count
743: from pa_project_parties
744: where project_role_id = p_role_id;
745:
746: IF l_count > 0 THEN
747:

Line 775: ----This procedure upgrades existing records in pa_project_parties

771: x_error_message_code:=SQLCODE;
772: end ;
773:
774: ----PROCEDURE Enable_role_based_sec
775: ----This procedure upgrades existing records in pa_project_parties
776: -----to fnd_grants in case the user enables role based security from
777: ----role form
778: PROCEDURE Enable_role_based_sec(p_role_id in number
779: ,x_return_status out NOCOPY varchar2 --File.Sql.39 bug 4440895

Line 790: from pa_project_parties

786:
787: begin
788: select count(*)
789: into l_count
790: from pa_project_parties
791: where project_role_id = p_role_id;
792: -- and parties.grant_id is null;
793:
794: -- hr_utility.trace('before call to grant_role_based_sec');

Line 840: FROM pa_project_parties ppp

836: cursor c_role_in_use is
837: SELECT '1'
838: FROM dual
839: WHERE EXISTS (SELECT 'Y'
840: FROM pa_project_parties ppp
841: WHERE ppp.project_role_id=p_role_id)
842: OR EXISTS
843: (SELECT 'Y'
844: FROM pa_project_assignments ppa