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 780: l_role_id FND_GRANTS.MENU_ID%TYPE;

776: ,x_frcst_prim_ctct_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
777: ,x_utl_aut_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
778: )
779: IS
780: l_role_id FND_GRANTS.MENU_ID%TYPE;
781: BEGIN
782: x_res_aut_flag := 'N';
783: x_proj_aut_flag := 'N';
784: x_prim_ctct_flag := 'N';

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

894: RAISE;
895: END get_organization_name;
896:
897: --
898: -- This procedure is used to insert a INSTANCE/SET into fnd_grants
899: --
900: PROCEDURE insert_grant( p_person_id IN NUMBER
901: ,p_org_id IN NUMBER
902: ,p_role_name IN VARCHAR2

Line 907: l_grant_id FND_GRANTS.GRANT_GUID%TYPE;

903: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
904: )
905: IS
906:
907: l_grant_id FND_GRANTS.GRANT_GUID%TYPE;
908: l_object_name FND_OBJECTS.OBJ_NAME%TYPE;
909: l_role_id FND_GRANTS.MENU_ID%TYPE;
910: l_return_status VARCHAR2(30);
911: l_msg_data VARCHAR2(2000); -- Changed from 30 to 2000 to avoid ora 6502 error

Line 909: l_role_id FND_GRANTS.MENU_ID%TYPE;

905: IS
906:
907: l_grant_id FND_GRANTS.GRANT_GUID%TYPE;
908: l_object_name FND_OBJECTS.OBJ_NAME%TYPE;
909: l_role_id FND_GRANTS.MENU_ID%TYPE;
910: l_return_status VARCHAR2(30);
911: l_msg_data VARCHAR2(2000); -- Changed from 30 to 2000 to avoid ora 6502 error
912: l_msg_count NUMBER;
913: l_set_name FND_OBJECT_INSTANCE_SETS.INSTANCE_SET_NAME%TYPE;

Line 914: l_set_id FND_GRANTS.INSTANCE_SET_ID%TYPE;

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

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

1029: RAISE;
1030: END insert_grant;
1031:
1032: --
1033: -- This procedure is used to delete a INSTANCE/SET from fnd_grants
1034: --
1035: PROCEDURE delete_grant( p_person_id IN NUMBER
1036: ,p_org_id IN NUMBER
1037: ,p_role_name IN VARCHAR2

Line 1042: l_set_id FND_GRANTS.INSTANCE_SET_ID%TYPE;

1038: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1039: )
1040: IS
1041:
1042: l_set_id FND_GRANTS.INSTANCE_SET_ID%TYPE;
1043: l_set_name FND_OBJECT_INSTANCE_SETS.INSTANCE_SET_NAME%TYPE;
1044: l_object_name FND_OBJECTS.OBJ_NAME%TYPE;
1045: l_role_id FND_GRANTS.MENU_ID%TYPE;
1046: l_return_status VARCHAR2(30);

Line 1045: l_role_id FND_GRANTS.MENU_ID%TYPE;

1041:
1042: l_set_id FND_GRANTS.INSTANCE_SET_ID%TYPE;
1043: l_set_name FND_OBJECT_INSTANCE_SETS.INSTANCE_SET_NAME%TYPE;
1044: l_object_name FND_OBJECTS.OBJ_NAME%TYPE;
1045: l_role_id FND_GRANTS.MENU_ID%TYPE;
1046: l_return_status VARCHAR2(30);
1047: l_msg_data VARCHAR2(2000); -- Changed from 30 to 2000 to avoid ora 6502 error
1048: l_msg_count NUMBER;
1049:

Line 1340: v_roleid fnd_grants.menu_id%TYPE;

1336: X_error_message_code OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
1337:
1338: v_validated VARCHAR2(1);
1339: v_orgid per_all_assignments_f.organization_id%TYPE;
1340: v_roleid fnd_grants.menu_id%TYPE;
1341: v_objid fnd_grants.object_id%TYPE;
1342: v_resid fnd_grants.grantee_key%TYPE;
1343: v_objname VARCHAR2(25) := 'ORGANIZATION';
1344: v_rolename VARCHAR2(30) := 'PA_PRM_RES_AUTH';

Line 1341: v_objid fnd_grants.object_id%TYPE;

1337:
1338: v_validated VARCHAR2(1);
1339: v_orgid per_all_assignments_f.organization_id%TYPE;
1340: v_roleid fnd_grants.menu_id%TYPE;
1341: v_objid fnd_grants.object_id%TYPE;
1342: v_resid fnd_grants.grantee_key%TYPE;
1343: v_objname VARCHAR2(25) := 'ORGANIZATION';
1344: v_rolename VARCHAR2(30) := 'PA_PRM_RES_AUTH';
1345: v_primrolename VARCHAR2(30) := 'PA_PRM_RES_PRMRY_CONTACT';

Line 1342: v_resid fnd_grants.grantee_key%TYPE;

1338: v_validated VARCHAR2(1);
1339: v_orgid per_all_assignments_f.organization_id%TYPE;
1340: v_roleid fnd_grants.menu_id%TYPE;
1341: v_objid fnd_grants.object_id%TYPE;
1342: v_resid fnd_grants.grantee_key%TYPE;
1343: v_objname VARCHAR2(25) := 'ORGANIZATION';
1344: v_rolename VARCHAR2(30) := 'PA_PRM_RES_AUTH';
1345: v_primrolename VARCHAR2(30) := 'PA_PRM_RES_PRMRY_CONTACT';
1346: v_primroleid fnd_grants.menu_id%TYPE;

Line 1346: v_primroleid fnd_grants.menu_id%TYPE;

1342: v_resid fnd_grants.grantee_key%TYPE;
1343: v_objname VARCHAR2(25) := 'ORGANIZATION';
1344: v_rolename VARCHAR2(30) := 'PA_PRM_RES_AUTH';
1345: v_primrolename VARCHAR2(30) := 'PA_PRM_RES_PRMRY_CONTACT';
1346: v_primroleid fnd_grants.menu_id%TYPE;
1347: PersonException EXCEPTION;
1348: missing_role EXCEPTION;
1349: j NUMBER;
1350:

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

1347: PersonException EXCEPTION;
1348: missing_role EXCEPTION;
1349: j NUMBER;
1350:
1351: cursor analystid(objid fnd_grants.object_id%TYPE,
1352: orgid per_all_assignments_f.organization_id%TYPE,
1353: roleid fnd_grants.menu_id%TYPE ) is
1354: SELECT distinct per.person_id
1355: FROM fnd_grants fg, wf_roles wfr, per_all_people_f per

Line 1353: roleid fnd_grants.menu_id%TYPE ) is

1349: j NUMBER;
1350:
1351: cursor analystid(objid fnd_grants.object_id%TYPE,
1352: orgid per_all_assignments_f.organization_id%TYPE,
1353: roleid fnd_grants.menu_id%TYPE ) is
1354: SELECT distinct per.person_id
1355: FROM fnd_grants fg, wf_roles wfr, per_all_people_f per
1356: WHERE fg.object_id = objid
1357: AND fg.instance_pk1_value = TO_CHAR(orgid)

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

1351: cursor analystid(objid fnd_grants.object_id%TYPE,
1352: orgid per_all_assignments_f.organization_id%TYPE,
1353: roleid fnd_grants.menu_id%TYPE ) is
1354: SELECT distinct per.person_id
1355: FROM fnd_grants fg, wf_roles wfr, per_all_people_f per
1356: WHERE fg.object_id = objid
1357: AND fg.instance_pk1_value = TO_CHAR(orgid)
1358: AND fg.menu_id = roleid
1359: AND fg.instance_type = 'INSTANCE'

Line 1427: FROM fnd_grants fg,

1423: SELECT pep.person_id,
1424: --distinct to_number(substr(fg.grantee_key,instr(fg.grantee_key,':')+1)),
1425: pep.full_name
1426: INTO P_PrimaryContactId,P_PrimaryContactName
1427: FROM fnd_grants fg,
1428: per_all_people_f pep, -- Bug 4684198 - use table
1429: wf_roles wfr
1430: WHERE fg.object_id = v_objid
1431: AND fg.instance_pk1_value = TO_CHAR(v_orgid)

Line 1559: FROM fnd_grants fg,

1555: SELECT distinct pep.person_id -- changes for 11.5.10 security
1556: -- to_number(substr(fg.grantee_key,instr(fg.grantee_key,':')+1))
1557: ,pep.full_name
1558: INTO x_PrimaryContactId,x_PrimaryContactName
1559: FROM fnd_grants fg,
1560: per_all_people_f pep, -- Bug 4684198 - use table
1561: wf_roles wfr
1562: WHERE fg.object_id = P_objid
1563: AND fg.instance_pk1_value = to_char(P_orgid)

Line 1903: v_objid fnd_grants.object_id%TYPE;

1899:
1900: v_personId NUMBER;
1901: v_numrows NUMBER;
1902: v_orgid per_all_assignments_f.organization_id%TYPE;
1903: v_objid fnd_grants.object_id%TYPE;
1904: --v_resid fnd_grants.grantee_key%TYPE;
1905: v_objname VARCHAR2(25) := 'ORGANIZATION';
1906: v_primrolename VARCHAR2(30) := 'PA_PRM_RES_PRMRY_CONTACT';
1907: v_primroleid fnd_grants.menu_id%TYPE;

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

1900: v_personId NUMBER;
1901: v_numrows NUMBER;
1902: v_orgid per_all_assignments_f.organization_id%TYPE;
1903: v_objid fnd_grants.object_id%TYPE;
1904: --v_resid fnd_grants.grantee_key%TYPE;
1905: v_objname VARCHAR2(25) := 'ORGANIZATION';
1906: v_primrolename VARCHAR2(30) := 'PA_PRM_RES_PRMRY_CONTACT';
1907: v_primroleid fnd_grants.menu_id%TYPE;
1908: v_error_message_code fnd_new_messages.message_name%TYPE;

Line 1907: v_primroleid fnd_grants.menu_id%TYPE;

1903: v_objid fnd_grants.object_id%TYPE;
1904: --v_resid fnd_grants.grantee_key%TYPE;
1905: v_objname VARCHAR2(25) := 'ORGANIZATION';
1906: v_primrolename VARCHAR2(30) := 'PA_PRM_RES_PRMRY_CONTACT';
1907: v_primroleid fnd_grants.menu_id%TYPE;
1908: v_error_message_code fnd_new_messages.message_name%TYPE;
1909: v_return_status VARCHAR2(1);
1910: v_msg_data VARCHAR2(2000);
1911: v_msg_count NUMBER;

Line 2946: FROM fnd_grants fg,

2942: SELECT pep.full_name,
2943: pep.person_id
2944: INTO l_primary_contact_name,
2945: l_primary_contact_id
2946: FROM fnd_grants fg,
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

Line 3614: fnd_grants fg,

3610: -- the resource
3611: CURSOR check_staff_mgr IS
3612: SELECT 'Y'
3613: FROM pa_resources_denorm res,
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