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_RESOURCE_UTILS dependencies on PA_SECURITY_PVT

Line 713: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH');

709: x_frcst_aut_flag := 'N';
710: x_utl_aut_flag := 'N';
711: x_frcst_prim_ctct_flag := 'N';
712:
713: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH');
714: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
715: ,'INSTANCE'
716: ,l_role_id
717: ,p_org_id

Line 714: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'

710: x_utl_aut_flag := 'N';
711: x_frcst_prim_ctct_flag := 'N';
712:
713: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH');
714: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
715: ,'INSTANCE'
716: ,l_role_id
717: ,p_org_id
718: ,p_person_id

Line 723: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_PROJ_AUTH');

719: ) THEN
720: x_res_aut_flag := 'Y';
721: END IF;
722:
723: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_PROJ_AUTH');
724: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
725: ,'INSTANCE'
726: ,l_role_id
727: ,p_org_id

Line 724: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'

720: x_res_aut_flag := 'Y';
721: END IF;
722:
723: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_PROJ_AUTH');
724: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
725: ,'INSTANCE'
726: ,l_role_id
727: ,p_org_id
728: ,p_person_id

Line 735: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT');

731: x_proj_aut_flag := 'Y';
732: END IF;
733:
734: --changed role name to Resource Primary Contact
735: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT');
736: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
737: ,'INSTANCE'
738: ,l_role_id
739: ,p_org_id

Line 736: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'

732: END IF;
733:
734: --changed role name to Resource Primary Contact
735: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT');
736: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
737: ,'INSTANCE'
738: ,l_role_id
739: ,p_org_id
740: ,p_person_id

Line 748: /* l_role_id := pa_security_pvt.get_menu_id('PA_PRM_FCST_AUTH');

744: END IF;
745:
746:
747: /*6519194 for enhancement*/
748: /* l_role_id := pa_security_pvt.get_menu_id('PA_PRM_FCST_AUTH');
749: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
750: ,'INSTANCE'
751: ,l_role_id
752: ,p_org_id

Line 749: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'

745:
746:
747: /*6519194 for enhancement*/
748: /* l_role_id := pa_security_pvt.get_menu_id('PA_PRM_FCST_AUTH');
749: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
750: ,'INSTANCE'
751: ,l_role_id
752: ,p_org_id
753: ,p_person_id) THEN

Line 757: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_FCST_PRMRY_CONTACT');

753: ,p_person_id) THEN
754: x_frcst_aut_flag := 'Y';
755: END IF;
756:
757: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_FCST_PRMRY_CONTACT');
758: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
759: ,'INSTANCE'
760: ,l_role_id
761: ,p_org_id

Line 758: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'

754: x_frcst_aut_flag := 'Y';
755: END IF;
756:
757: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_FCST_PRMRY_CONTACT');
758: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
759: ,'INSTANCE'
760: ,l_role_id
761: ,p_org_id
762: ,p_person_id) THEN

Line 766: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_UTL_AUTH');

762: ,p_person_id) THEN
763: x_frcst_prim_ctct_flag := 'Y';
764: END IF;
765: */
766: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_UTL_AUTH');
767: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
768: ,'INSTANCE'
769: ,l_role_id
770: ,p_org_id

Line 767: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'

763: x_frcst_prim_ctct_flag := 'Y';
764: END IF;
765: */
766: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_UTL_AUTH');
767: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
768: ,'INSTANCE'
769: ,l_role_id
770: ,p_org_id
771: ,p_person_id) THEN

Line 837: l_role_id := PA_SECURITY_PVT.get_menu_id(p_role_name);

833: l_msg_count NUMBER;
834: l_set_name FND_OBJECT_INSTANCE_SETS.INSTANCE_SET_NAME%TYPE;
835: l_set_id FND_GRANTS.INSTANCE_SET_ID%TYPE;
836: BEGIN
837: l_role_id := PA_SECURITY_PVT.get_menu_id(p_role_name);
838: --
839: -- At this point, the global variable for person_id cannot be used,
840: -- because, the global variable is populated - when the FIND button is
841: -- pressed.

Line 851: l_set_id := pa_security_pvt.get_instance_set_id(l_set_name);

847: ELSIF p_role_name = 'PA_PRM_PROJ_AUTH' THEN
848: l_object_name := 'PA_PROJECTS';
849: l_set_name := 'PA_PROJECT_AUTHORITY';
850: END IF;
851: l_set_id := pa_security_pvt.get_instance_set_id(l_set_name);
852:
853: --
854: -- First, check whether there is a SET record this role in the table.
855: -- IF NO,

Line 868: pa_security_pvt.is_role_exists( 'ORGANIZATION'

864: -- check is necessary.
865: --
866: IF
867: --G_SELECTED_FLAG = 'O' AND
868: pa_security_pvt.is_role_exists( 'ORGANIZATION'
869: ,'INSTANCE'
870: ,l_role_id
871: ,p_org_id
872: ,p_person_id

Line 883: NOT pa_security_pvt.is_role_exists(p_object_name => l_object_name

879: IF p_role_name <> 'PA_PRM_RES_PRMRY_CONTACT' AND
880: /* p_role_name <> 'PA_PRM_FCST_AUTH' AND
881: p_role_name <> 'PA_PRM_FCST_PRMRY_CONTACT' AND*/ /*6519194 for enhancement*/
882: p_role_name <> 'PA_PRM_UTL_AUTH' AND
883: NOT pa_security_pvt.is_role_exists(p_object_name => l_object_name
884: ,p_object_key_type => 'INSTANCE_SET'
885: ,p_role_id => l_role_id
886: ,p_object_key => l_set_id
887: ,p_party_id => p_person_id)

Line 890: pa_security_pvt.grant_org_authority

886: ,p_object_key => l_set_id
887: ,p_party_id => p_person_id)
888: THEN
889: --Create the SET record.
890: pa_security_pvt.grant_org_authority
891: (
892: p_commit => NULL
893: ,p_debug_mode => NULL
894: ,p_project_role_id => NULL

Line 917: pa_security_pvt.grant_org_authority

913: END IF;
914: END IF;
915:
916: --Create the INSTANCE record.
917: pa_security_pvt.grant_org_authority
918: (
919: p_commit => NULL
920: ,p_debug_mode => NULL
921: ,p_project_role_id => NULL

Line 994: pa_security_pvt.revoke_role

990: --
991:
992: --Call API to delete INSTANCE record.
993:
994: pa_security_pvt.revoke_role
995: (
996: p_commit => FND_API.G_TRUE
997: ,p_debug_mode => NULL
998: ,p_project_role_id => NULL

Line 1023: l_role_id := PA_SECURITY_PVT.get_menu_id(p_role_name);

1019: --Added the check if role = Resource Authority or Project Authority
1020: --then delete the SET record if no more INSTANCE records exist.
1021:
1022: IF ((p_role_name = 'PA_PRM_RES_AUTH') or (p_role_name = 'PA_PRM_PROJ_AUTH')) THEN
1023: l_role_id := PA_SECURITY_PVT.get_menu_id(p_role_name);
1024: IF NOT pa_security_pvt.is_role_exists ( p_object_name => 'ORGANIZATION'
1025: ,p_object_key_type => 'INSTANCE'
1026: ,p_role_id => l_role_id
1027: ,p_object_key => NULL

Line 1024: IF NOT pa_security_pvt.is_role_exists ( p_object_name => 'ORGANIZATION'

1020: --then delete the SET record if no more INSTANCE records exist.
1021:
1022: IF ((p_role_name = 'PA_PRM_RES_AUTH') or (p_role_name = 'PA_PRM_PROJ_AUTH')) THEN
1023: l_role_id := PA_SECURITY_PVT.get_menu_id(p_role_name);
1024: IF NOT pa_security_pvt.is_role_exists ( p_object_name => 'ORGANIZATION'
1025: ,p_object_key_type => 'INSTANCE'
1026: ,p_role_id => l_role_id
1027: ,p_object_key => NULL
1028: ,p_party_id => p_person_id

Line 1032: l_set_id := pa_security_pvt.get_instance_set_id(l_set_name);

1028: ,p_party_id => p_person_id
1029: ) THEN
1030:
1031: -- Delete the INSTANCE_SET record.
1032: l_set_id := pa_security_pvt.get_instance_set_id(l_set_name);
1033: pa_security_pvt.revoke_role(
1034: p_commit => FND_API.G_TRUE
1035: ,p_debug_mode => NULL
1036: ,p_project_role_id => NULL

Line 1033: pa_security_pvt.revoke_role(

1029: ) THEN
1030:
1031: -- Delete the INSTANCE_SET record.
1032: l_set_id := pa_security_pvt.get_instance_set_id(l_set_name);
1033: pa_security_pvt.revoke_role(
1034: p_commit => FND_API.G_TRUE
1035: ,p_debug_mode => NULL
1036: ,p_project_role_id => NULL
1037: ,p_menu_name => p_role_name

Line 1336: v_roleid := pa_security_pvt.get_menu_id(v_rolename);

1332: FROM fnd_objects
1333: WHERE obj_name = v_objname;
1334:
1335: -- get the roleid for the Responsibility of type 'Resource Authority');
1336: v_roleid := pa_security_pvt.get_menu_id(v_rolename);
1337: v_Primroleid := pa_security_pvt.get_menu_id(v_primrolename);
1338:
1339: IF (v_Primroleid is NULL and v_roleid is NULL) then
1340: raise missing_role;

Line 1337: v_Primroleid := pa_security_pvt.get_menu_id(v_primrolename);

1333: WHERE obj_name = v_objname;
1334:
1335: -- get the roleid for the Responsibility of type 'Resource Authority');
1336: v_roleid := pa_security_pvt.get_menu_id(v_rolename);
1337: v_Primroleid := pa_security_pvt.get_menu_id(v_primrolename);
1338:
1339: IF (v_Primroleid is NULL and v_roleid is NULL) then
1340: raise missing_role;
1341: END IF;

Line 1863: v_Primroleid := pa_security_pvt.get_menu_id(v_primrolename);

1859: END IF;
1860:
1861:
1862: -- get the roleid for the Responsibility of type 'Primary Resource Contact'
1863: v_Primroleid := pa_security_pvt.get_menu_id(v_primrolename);
1864: -- get primary contact name and id
1865: get_prim_contact_id_name(v_objid
1866: ,v_orgid
1867: ,v_Primroleid

Line 2820: select pa_security_pvt.get_menu_id(p_prim_role_name)

2816: -- reset primary_contact_id before set it up again
2817: PA_RESOURCE_UTILS.G_PRIMARY_CONTACT_NAME:= NULL;
2818:
2819: /* Bug# 2499051 */
2820: select pa_security_pvt.get_menu_id(p_prim_role_name)
2821: into l_menu_id
2822: from dual;
2823: /* Bug# 2499051 */
2824:

Line 2834: (select pa_security_pvt.get_menu_id(p_prim_role_name) menu_id from dual) temp */

2830: fnd_objects fob,
2831: per_all_people_f pep, -- Bug 4684198 - use base table not secure view
2832: wf_roles wfr
2833: /* Bug# 2499051 - Moved the function call to fetch to a local variable at the start of the procedure
2834: (select pa_security_pvt.get_menu_id(p_prim_role_name) menu_id from dual) temp */
2835: WHERE fg.object_id = fob.object_id
2836: AND fob.obj_name = 'ORGANIZATION'
2837: AND fg.instance_pk1_value = to_char(p_org_id)
2838: /* AND fg.menu_id = temp.menu_id -- Bug# 2499051 - Using local variable */

Line 3356: (select pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH') menu_id

3352: fnd_grants fg,
3353: fnd_objects fob,
3354: per_all_people_f per,
3355: wf_roles wfr,
3356: (select pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH') menu_id
3357: from dual) res_auth_menu
3358: WHERE fob.obj_name = 'ORGANIZATION'
3359: and res.resource_id = l_resource_id
3360: and sysdate < res.resource_effective_end_date