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 789: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH');

785: x_frcst_aut_flag := 'N';
786: x_utl_aut_flag := 'N';
787: x_frcst_prim_ctct_flag := 'N';
788:
789: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH');
790: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
791: ,'INSTANCE'
792: ,l_role_id
793: ,p_org_id

Line 790: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'

786: x_utl_aut_flag := 'N';
787: x_frcst_prim_ctct_flag := 'N';
788:
789: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH');
790: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
791: ,'INSTANCE'
792: ,l_role_id
793: ,p_org_id
794: ,p_person_id

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

795: ) THEN
796: x_res_aut_flag := 'Y';
797: END IF;
798:
799: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_PROJ_AUTH');
800: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
801: ,'INSTANCE'
802: ,l_role_id
803: ,p_org_id

Line 800: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'

796: x_res_aut_flag := 'Y';
797: END IF;
798:
799: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_PROJ_AUTH');
800: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
801: ,'INSTANCE'
802: ,l_role_id
803: ,p_org_id
804: ,p_person_id

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

807: x_proj_aut_flag := 'Y';
808: END IF;
809:
810: --changed role name to Resource Primary Contact
811: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT');
812: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
813: ,'INSTANCE'
814: ,l_role_id
815: ,p_org_id

Line 812: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'

808: END IF;
809:
810: --changed role name to Resource Primary Contact
811: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT');
812: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
813: ,'INSTANCE'
814: ,l_role_id
815: ,p_org_id
816: ,p_person_id

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

820: END IF;
821:
822:
823: /*6519194 for enhancement*/
824: /* l_role_id := pa_security_pvt.get_menu_id('PA_PRM_FCST_AUTH');
825: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
826: ,'INSTANCE'
827: ,l_role_id
828: ,p_org_id

Line 825: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'

821:
822:
823: /*6519194 for enhancement*/
824: /* l_role_id := pa_security_pvt.get_menu_id('PA_PRM_FCST_AUTH');
825: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
826: ,'INSTANCE'
827: ,l_role_id
828: ,p_org_id
829: ,p_person_id) THEN

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

829: ,p_person_id) THEN
830: x_frcst_aut_flag := 'Y';
831: END IF;
832:
833: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_FCST_PRMRY_CONTACT');
834: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
835: ,'INSTANCE'
836: ,l_role_id
837: ,p_org_id

Line 834: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'

830: x_frcst_aut_flag := 'Y';
831: END IF;
832:
833: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_FCST_PRMRY_CONTACT');
834: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
835: ,'INSTANCE'
836: ,l_role_id
837: ,p_org_id
838: ,p_person_id) THEN

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

838: ,p_person_id) THEN
839: x_frcst_prim_ctct_flag := 'Y';
840: END IF;
841: */
842: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_UTL_AUTH');
843: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
844: ,'INSTANCE'
845: ,l_role_id
846: ,p_org_id

Line 843: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'

839: x_frcst_prim_ctct_flag := 'Y';
840: END IF;
841: */
842: l_role_id := pa_security_pvt.get_menu_id('PA_PRM_UTL_AUTH');
843: IF pa_security_pvt.is_role_exists( 'ORGANIZATION'
844: ,'INSTANCE'
845: ,l_role_id
846: ,p_org_id
847: ,p_person_id) THEN

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

912: l_msg_count NUMBER;
913: l_set_name FND_OBJECT_INSTANCE_SETS.INSTANCE_SET_NAME%TYPE;
914: l_set_id FND_GRANTS.INSTANCE_SET_ID%TYPE;
915: BEGIN
916: l_role_id := PA_SECURITY_PVT.get_menu_id(p_role_name);
917: --
918: -- At this point, the global variable for person_id cannot be used,
919: -- because, the global variable is populated - when the FIND button is
920: -- pressed.

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

926: ELSIF p_role_name = 'PA_PRM_PROJ_AUTH' THEN
927: l_object_name := 'PA_PROJECTS';
928: l_set_name := 'PA_PROJECT_AUTHORITY';
929: END IF;
930: l_set_id := pa_security_pvt.get_instance_set_id(l_set_name);
931:
932: --
933: -- First, check whether there is a SET record this role in the table.
934: -- IF NO,

Line 947: pa_security_pvt.is_role_exists( 'ORGANIZATION'

943: -- check is necessary.
944: --
945: IF
946: --G_SELECTED_FLAG = 'O' AND
947: pa_security_pvt.is_role_exists( 'ORGANIZATION'
948: ,'INSTANCE'
949: ,l_role_id
950: ,p_org_id
951: ,p_person_id

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

958: IF p_role_name <> 'PA_PRM_RES_PRMRY_CONTACT' AND
959: /* p_role_name <> 'PA_PRM_FCST_AUTH' AND
960: p_role_name <> 'PA_PRM_FCST_PRMRY_CONTACT' AND*/ /*6519194 for enhancement*/
961: p_role_name <> 'PA_PRM_UTL_AUTH' AND
962: NOT pa_security_pvt.is_role_exists(p_object_name => l_object_name
963: ,p_object_key_type => 'INSTANCE_SET'
964: ,p_role_id => l_role_id
965: ,p_object_key => l_set_id
966: ,p_party_id => p_person_id)

Line 969: pa_security_pvt.grant_org_authority

965: ,p_object_key => l_set_id
966: ,p_party_id => p_person_id)
967: THEN
968: --Create the SET record.
969: pa_security_pvt.grant_org_authority
970: (
971: p_commit => NULL
972: ,p_debug_mode => NULL
973: ,p_project_role_id => NULL

Line 996: pa_security_pvt.grant_org_authority

992: END IF;
993: END IF;
994:
995: --Create the INSTANCE record.
996: pa_security_pvt.grant_org_authority
997: (
998: p_commit => NULL
999: ,p_debug_mode => NULL
1000: ,p_project_role_id => NULL

Line 1073: pa_security_pvt.revoke_role

1069: --
1070:
1071: --Call API to delete INSTANCE record.
1072:
1073: pa_security_pvt.revoke_role
1074: (
1075: p_commit => FND_API.G_TRUE
1076: ,p_debug_mode => NULL
1077: ,p_project_role_id => NULL

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

1098: --Added the check if role = Resource Authority or Project Authority
1099: --then delete the SET record if no more INSTANCE records exist.
1100:
1101: IF ((p_role_name = 'PA_PRM_RES_AUTH') or (p_role_name = 'PA_PRM_PROJ_AUTH')) THEN
1102: l_role_id := PA_SECURITY_PVT.get_menu_id(p_role_name);
1103: IF NOT pa_security_pvt.is_role_exists ( p_object_name => 'ORGANIZATION'
1104: ,p_object_key_type => 'INSTANCE'
1105: ,p_role_id => l_role_id
1106: ,p_object_key => NULL

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

1099: --then delete the SET record if no more INSTANCE records exist.
1100:
1101: IF ((p_role_name = 'PA_PRM_RES_AUTH') or (p_role_name = 'PA_PRM_PROJ_AUTH')) THEN
1102: l_role_id := PA_SECURITY_PVT.get_menu_id(p_role_name);
1103: IF NOT pa_security_pvt.is_role_exists ( p_object_name => 'ORGANIZATION'
1104: ,p_object_key_type => 'INSTANCE'
1105: ,p_role_id => l_role_id
1106: ,p_object_key => NULL
1107: ,p_party_id => p_person_id

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

1107: ,p_party_id => p_person_id
1108: ) THEN
1109:
1110: -- Delete the INSTANCE_SET record.
1111: l_set_id := pa_security_pvt.get_instance_set_id(l_set_name);
1112: pa_security_pvt.revoke_role(
1113: p_commit => FND_API.G_TRUE
1114: ,p_debug_mode => NULL
1115: ,p_project_role_id => NULL

Line 1112: pa_security_pvt.revoke_role(

1108: ) THEN
1109:
1110: -- Delete the INSTANCE_SET record.
1111: l_set_id := pa_security_pvt.get_instance_set_id(l_set_name);
1112: pa_security_pvt.revoke_role(
1113: p_commit => FND_API.G_TRUE
1114: ,p_debug_mode => NULL
1115: ,p_project_role_id => NULL
1116: ,p_menu_name => p_role_name

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

1411: FROM fnd_objects
1412: WHERE obj_name = v_objname;
1413:
1414: -- get the roleid for the Responsibility of type 'Resource Authority');
1415: v_roleid := pa_security_pvt.get_menu_id(v_rolename);
1416: v_Primroleid := pa_security_pvt.get_menu_id(v_primrolename);
1417:
1418: IF (v_Primroleid is NULL and v_roleid is NULL) then
1419: raise missing_role;

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

1412: WHERE obj_name = v_objname;
1413:
1414: -- get the roleid for the Responsibility of type 'Resource Authority');
1415: v_roleid := pa_security_pvt.get_menu_id(v_rolename);
1416: v_Primroleid := pa_security_pvt.get_menu_id(v_primrolename);
1417:
1418: IF (v_Primroleid is NULL and v_roleid is NULL) then
1419: raise missing_role;
1420: END IF;

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

1976: END IF;
1977:
1978:
1979: -- get the roleid for the Responsibility of type 'Primary Resource Contact'
1980: v_Primroleid := pa_security_pvt.get_menu_id(v_primrolename);
1981: -- get primary contact name and id
1982: get_prim_contact_id_name(v_objid
1983: ,v_orgid
1984: ,v_Primroleid

Line 2937: select pa_security_pvt.get_menu_id(p_prim_role_name)

2933: -- reset primary_contact_id before set it up again
2934: PA_RESOURCE_UTILS.G_PRIMARY_CONTACT_NAME:= NULL;
2935:
2936: /* Bug# 2499051 */
2937: select pa_security_pvt.get_menu_id(p_prim_role_name)
2938: into l_menu_id
2939: from dual;
2940: /* Bug# 2499051 */
2941:

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

2947: fnd_objects fob,
2948: per_all_people_f pep, -- Bug 4684198 - use base table not secure view
2949: wf_roles wfr
2950: /* Bug# 2499051 - Moved the function call to fetch to a local variable at the start of the procedure
2951: (select pa_security_pvt.get_menu_id(p_prim_role_name) menu_id from dual) temp */
2952: WHERE fg.object_id = fob.object_id
2953: AND fob.obj_name = 'ORGANIZATION'
2954: AND fg.instance_pk1_value = to_char(p_org_id)
2955: /* AND fg.menu_id = temp.menu_id -- Bug# 2499051 - Using local variable */

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

3614: fnd_grants fg,
3615: fnd_objects fob,
3616: per_all_people_f per,
3617: wf_roles wfr,
3618: (select pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH') menu_id
3619: from dual) res_auth_menu
3620: WHERE fob.obj_name = 'ORGANIZATION'
3621: and res.resource_id = l_resource_id
3622: and trunc(sysdate) < res.resource_effective_end_date --Bug 9403051