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 FND_GRANTS

Line 704: l_role_id FND_GRANTS.MENU_ID%TYPE;

700: ,x_frcst_prim_ctct_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
701: ,x_utl_aut_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
702: )
703: IS
704: l_role_id FND_GRANTS.MENU_ID%TYPE;
705: BEGIN
706: x_res_aut_flag := 'N';
707: x_proj_aut_flag := 'N';
708: x_prim_ctct_flag := 'N';

Line 819: -- This procedure is used to insert a INSTANCE/SET into fnd_grants

815: RAISE;
816: END get_organization_name;
817:
818: --
819: -- This procedure is used to insert a INSTANCE/SET into fnd_grants
820: --
821: PROCEDURE insert_grant( p_person_id IN NUMBER
822: ,p_org_id IN NUMBER
823: ,p_role_name IN VARCHAR2

Line 828: l_grant_id FND_GRANTS.GRANT_GUID%TYPE;

824: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
825: )
826: IS
827:
828: l_grant_id FND_GRANTS.GRANT_GUID%TYPE;
829: l_object_name FND_OBJECTS.OBJ_NAME%TYPE;
830: l_role_id FND_GRANTS.MENU_ID%TYPE;
831: l_return_status VARCHAR2(30);
832: l_msg_data VARCHAR2(2000); -- Changed from 30 to 2000 to avoid ora 6502 error

Line 830: l_role_id FND_GRANTS.MENU_ID%TYPE;

826: IS
827:
828: l_grant_id FND_GRANTS.GRANT_GUID%TYPE;
829: l_object_name FND_OBJECTS.OBJ_NAME%TYPE;
830: l_role_id FND_GRANTS.MENU_ID%TYPE;
831: l_return_status VARCHAR2(30);
832: l_msg_data VARCHAR2(2000); -- Changed from 30 to 2000 to avoid ora 6502 error
833: l_msg_count NUMBER;
834: l_set_name FND_OBJECT_INSTANCE_SETS.INSTANCE_SET_NAME%TYPE;

Line 835: l_set_id FND_GRANTS.INSTANCE_SET_ID%TYPE;

831: l_return_status VARCHAR2(30);
832: l_msg_data VARCHAR2(2000); -- Changed from 30 to 2000 to avoid ora 6502 error
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,

Line 954: -- This procedure is used to delete a INSTANCE/SET from fnd_grants

950: RAISE;
951: END insert_grant;
952:
953: --
954: -- This procedure is used to delete a INSTANCE/SET from fnd_grants
955: --
956: PROCEDURE delete_grant( p_person_id IN NUMBER
957: ,p_org_id IN NUMBER
958: ,p_role_name IN VARCHAR2

Line 963: l_set_id FND_GRANTS.INSTANCE_SET_ID%TYPE;

959: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
960: )
961: IS
962:
963: l_set_id FND_GRANTS.INSTANCE_SET_ID%TYPE;
964: l_set_name FND_OBJECT_INSTANCE_SETS.INSTANCE_SET_NAME%TYPE;
965: l_object_name FND_OBJECTS.OBJ_NAME%TYPE;
966: l_role_id FND_GRANTS.MENU_ID%TYPE;
967: l_return_status VARCHAR2(30);

Line 966: l_role_id FND_GRANTS.MENU_ID%TYPE;

962:
963: l_set_id FND_GRANTS.INSTANCE_SET_ID%TYPE;
964: l_set_name FND_OBJECT_INSTANCE_SETS.INSTANCE_SET_NAME%TYPE;
965: l_object_name FND_OBJECTS.OBJ_NAME%TYPE;
966: l_role_id FND_GRANTS.MENU_ID%TYPE;
967: l_return_status VARCHAR2(30);
968: l_msg_data VARCHAR2(2000); -- Changed from 30 to 2000 to avoid ora 6502 error
969: l_msg_count NUMBER;
970:

Line 1261: v_roleid fnd_grants.menu_id%TYPE;

1257: X_error_message_code OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
1258:
1259: v_validated VARCHAR2(1);
1260: v_orgid per_all_assignments_f.organization_id%TYPE;
1261: v_roleid fnd_grants.menu_id%TYPE;
1262: v_objid fnd_grants.object_id%TYPE;
1263: v_resid fnd_grants.grantee_key%TYPE;
1264: v_objname VARCHAR2(25) := 'ORGANIZATION';
1265: v_rolename VARCHAR2(30) := 'PA_PRM_RES_AUTH';

Line 1262: v_objid fnd_grants.object_id%TYPE;

1258:
1259: v_validated VARCHAR2(1);
1260: v_orgid per_all_assignments_f.organization_id%TYPE;
1261: v_roleid fnd_grants.menu_id%TYPE;
1262: v_objid fnd_grants.object_id%TYPE;
1263: v_resid fnd_grants.grantee_key%TYPE;
1264: v_objname VARCHAR2(25) := 'ORGANIZATION';
1265: v_rolename VARCHAR2(30) := 'PA_PRM_RES_AUTH';
1266: v_primrolename VARCHAR2(30) := 'PA_PRM_RES_PRMRY_CONTACT';

Line 1263: v_resid fnd_grants.grantee_key%TYPE;

1259: v_validated VARCHAR2(1);
1260: v_orgid per_all_assignments_f.organization_id%TYPE;
1261: v_roleid fnd_grants.menu_id%TYPE;
1262: v_objid fnd_grants.object_id%TYPE;
1263: v_resid fnd_grants.grantee_key%TYPE;
1264: v_objname VARCHAR2(25) := 'ORGANIZATION';
1265: v_rolename VARCHAR2(30) := 'PA_PRM_RES_AUTH';
1266: v_primrolename VARCHAR2(30) := 'PA_PRM_RES_PRMRY_CONTACT';
1267: v_primroleid fnd_grants.menu_id%TYPE;

Line 1267: v_primroleid fnd_grants.menu_id%TYPE;

1263: v_resid fnd_grants.grantee_key%TYPE;
1264: v_objname VARCHAR2(25) := 'ORGANIZATION';
1265: v_rolename VARCHAR2(30) := 'PA_PRM_RES_AUTH';
1266: v_primrolename VARCHAR2(30) := 'PA_PRM_RES_PRMRY_CONTACT';
1267: v_primroleid fnd_grants.menu_id%TYPE;
1268: PersonException EXCEPTION;
1269: missing_role EXCEPTION;
1270: j NUMBER;
1271:

Line 1272: cursor analystid(objid fnd_grants.object_id%TYPE,

1268: PersonException EXCEPTION;
1269: missing_role EXCEPTION;
1270: j NUMBER;
1271:
1272: cursor analystid(objid fnd_grants.object_id%TYPE,
1273: orgid per_all_assignments_f.organization_id%TYPE,
1274: roleid fnd_grants.menu_id%TYPE ) is
1275: SELECT distinct per.person_id
1276: FROM fnd_grants fg, wf_roles wfr, per_all_people_f per

Line 1274: roleid fnd_grants.menu_id%TYPE ) is

1270: j NUMBER;
1271:
1272: cursor analystid(objid fnd_grants.object_id%TYPE,
1273: orgid per_all_assignments_f.organization_id%TYPE,
1274: roleid fnd_grants.menu_id%TYPE ) is
1275: SELECT distinct per.person_id
1276: FROM fnd_grants fg, wf_roles wfr, per_all_people_f per
1277: WHERE fg.object_id = objid
1278: AND fg.instance_pk1_value = TO_CHAR(orgid)

Line 1276: FROM fnd_grants fg, wf_roles wfr, per_all_people_f per

1272: cursor analystid(objid fnd_grants.object_id%TYPE,
1273: orgid per_all_assignments_f.organization_id%TYPE,
1274: roleid fnd_grants.menu_id%TYPE ) is
1275: SELECT distinct per.person_id
1276: FROM fnd_grants fg, wf_roles wfr, per_all_people_f per
1277: WHERE fg.object_id = objid
1278: AND fg.instance_pk1_value = TO_CHAR(orgid)
1279: AND fg.menu_id = roleid
1280: AND fg.instance_type = 'INSTANCE'

Line 1348: FROM fnd_grants fg,

1344: SELECT pep.person_id,
1345: --distinct to_number(substr(fg.grantee_key,instr(fg.grantee_key,':')+1)),
1346: pep.full_name
1347: INTO P_PrimaryContactId,P_PrimaryContactName
1348: FROM fnd_grants fg,
1349: per_all_people_f pep, -- Bug 4684198 - use table
1350: wf_roles wfr
1351: WHERE fg.object_id = v_objid
1352: AND fg.instance_pk1_value = TO_CHAR(v_orgid)

Line 1480: FROM fnd_grants fg,

1476: SELECT distinct pep.person_id -- changes for 11.5.10 security
1477: -- to_number(substr(fg.grantee_key,instr(fg.grantee_key,':')+1))
1478: ,pep.full_name
1479: INTO x_PrimaryContactId,x_PrimaryContactName
1480: FROM fnd_grants fg,
1481: per_all_people_f pep, -- Bug 4684198 - use table
1482: wf_roles wfr
1483: WHERE fg.object_id = P_objid
1484: AND fg.instance_pk1_value = to_char(P_orgid)

Line 1791: v_objid fnd_grants.object_id%TYPE;

1787:
1788: v_personId NUMBER;
1789: v_numrows NUMBER;
1790: v_orgid per_all_assignments_f.organization_id%TYPE;
1791: v_objid fnd_grants.object_id%TYPE;
1792: --v_resid fnd_grants.grantee_key%TYPE;
1793: v_objname VARCHAR2(25) := 'ORGANIZATION';
1794: v_primrolename VARCHAR2(30) := 'PA_PRM_RES_PRMRY_CONTACT';
1795: v_primroleid fnd_grants.menu_id%TYPE;

Line 1792: --v_resid fnd_grants.grantee_key%TYPE;

1788: v_personId NUMBER;
1789: v_numrows NUMBER;
1790: v_orgid per_all_assignments_f.organization_id%TYPE;
1791: v_objid fnd_grants.object_id%TYPE;
1792: --v_resid fnd_grants.grantee_key%TYPE;
1793: v_objname VARCHAR2(25) := 'ORGANIZATION';
1794: v_primrolename VARCHAR2(30) := 'PA_PRM_RES_PRMRY_CONTACT';
1795: v_primroleid fnd_grants.menu_id%TYPE;
1796: v_error_message_code fnd_new_messages.message_name%TYPE;

Line 1795: v_primroleid fnd_grants.menu_id%TYPE;

1791: v_objid fnd_grants.object_id%TYPE;
1792: --v_resid fnd_grants.grantee_key%TYPE;
1793: v_objname VARCHAR2(25) := 'ORGANIZATION';
1794: v_primrolename VARCHAR2(30) := 'PA_PRM_RES_PRMRY_CONTACT';
1795: v_primroleid fnd_grants.menu_id%TYPE;
1796: v_error_message_code fnd_new_messages.message_name%TYPE;
1797: v_return_status VARCHAR2(1);
1798: v_msg_data VARCHAR2(2000);
1799: v_msg_count NUMBER;

Line 2829: FROM fnd_grants fg,

2825: SELECT pep.full_name,
2826: pep.person_id
2827: INTO l_primary_contact_name,
2828: l_primary_contact_id
2829: FROM fnd_grants fg,
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

Line 3352: fnd_grants fg,

3348: -- the resource
3349: CURSOR check_staff_mgr IS
3350: SELECT 'Y'
3351: FROM pa_resources_denorm res,
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