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.PA_ROLE_UTILS dependencies on PA_PROJECT_ASSIGNMENTS

Line 460: --2.Roles in pa_project_assignments table can not be deleted

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
464: --If the x_return_status is 'S', then the role can be deleted

Line 844: FROM pa_project_assignments ppa

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
845: WHERE ppa.project_role_id=p_role_id)
846: OR EXISTS
847: (SELECT 'Y'
848: FROM pa_rbs_elements