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.OKC_REP_UTIL_PVT dependencies on FND_GRANTS

Line 487: CURSOR grants_csr(p_contract_id1 in number, p_contract_id2 in number, p_grantee_key in FND_GRANTS.grantee_key%TYPE, p_grantee_orig_system in FND_GRANTS.grantee_orig_system%TYPE) IS

483: WHERE c.contract_id = p_contract_id
484: AND c.esignature_type = 'SELF'
485: AND usr.employee_id = c.contact_id;
486:
487: CURSOR grants_csr(p_contract_id1 in number, p_contract_id2 in number, p_grantee_key in FND_GRANTS.grantee_key%TYPE, p_grantee_orig_system in FND_GRANTS.grantee_orig_system%TYPE) IS
488: SELECT
489: NULL
490: FROM
491: jtf_rs_groups_denorm d

Line 494: ,fnd_grants g

490: FROM
491: jtf_rs_groups_denorm d
492: ,jtf_rs_group_members m
493: ,jtf_rs_resource_extns e
494: ,fnd_grants g
495: ,fnd_objects o
496: WHERE d.parent_group_id = g.parameter2
497: AND TRUNC(SYSDATE)
498: BETWEEN d.start_date_active

Line 509: (g.parameter3 = G_FND_GRANTS_UPDATE_ACCESS AND p_function_name IN (G_SELECT_ACCESS_LEVEL, G_UPDATE_ACCESS_LEVEL))

505: AND g.grantee_type = G_FND_GRANTEE_TYPE_GROUP
506: AND g.instance_pk1_value = p_contract_id1
507: AND e.user_id = FND_GLOBAL.user_id()
508: AND (
509: (g.parameter3 = G_FND_GRANTS_UPDATE_ACCESS AND p_function_name IN (G_SELECT_ACCESS_LEVEL, G_UPDATE_ACCESS_LEVEL))
510: OR (g.parameter3 = G_FND_GRANTS_VIEW_ACCESS AND p_function_name = G_SELECT_ACCESS_LEVEL)
511: )
512: UNION ALL
513: SELECT

Line 510: OR (g.parameter3 = G_FND_GRANTS_VIEW_ACCESS AND p_function_name = G_SELECT_ACCESS_LEVEL)

506: AND g.instance_pk1_value = p_contract_id1
507: AND e.user_id = FND_GLOBAL.user_id()
508: AND (
509: (g.parameter3 = G_FND_GRANTS_UPDATE_ACCESS AND p_function_name IN (G_SELECT_ACCESS_LEVEL, G_UPDATE_ACCESS_LEVEL))
510: OR (g.parameter3 = G_FND_GRANTS_VIEW_ACCESS AND p_function_name = G_SELECT_ACCESS_LEVEL)
511: )
512: UNION ALL
513: SELECT
514: NULL

Line 516: fnd_grants g

512: UNION ALL
513: SELECT
514: NULL
515: FROM
516: fnd_grants g
517: ,fnd_objects o
518: WHERE g.object_id = o.object_id
519: AND o.obj_name = G_OBJECT_NAME
520: AND g.grantee_type = G_FND_GRANTEE_TYPE_USER

Line 527: (g.parameter3 = G_FND_GRANTS_UPDATE_ACCESS AND p_function_name IN (G_SELECT_ACCESS_LEVEL, G_UPDATE_ACCESS_LEVEL))

523: (g.grantee_key = p_grantee_key AND (g.grantee_orig_system = p_grantee_orig_system OR g.grantee_orig_system = 'JRES_IND')) -- for R12 functionality
524: OR (g.grantee_key = FND_GLOBAL.user_name() AND g.grantee_orig_system = 'PER') -- for 11.5 backward compatibility
525: )
526: AND (
527: (g.parameter3 = G_FND_GRANTS_UPDATE_ACCESS AND p_function_name IN (G_SELECT_ACCESS_LEVEL, G_UPDATE_ACCESS_LEVEL))
528: OR (g.parameter3 = G_FND_GRANTS_VIEW_ACCESS AND p_function_name = G_SELECT_ACCESS_LEVEL)
529: );
530:
531: -- Cursor to get current user's JTF resource id

Line 528: OR (g.parameter3 = G_FND_GRANTS_VIEW_ACCESS AND p_function_name = G_SELECT_ACCESS_LEVEL)

524: OR (g.grantee_key = FND_GLOBAL.user_name() AND g.grantee_orig_system = 'PER') -- for 11.5 backward compatibility
525: )
526: AND (
527: (g.parameter3 = G_FND_GRANTS_UPDATE_ACCESS AND p_function_name IN (G_SELECT_ACCESS_LEVEL, G_UPDATE_ACCESS_LEVEL))
528: OR (g.parameter3 = G_FND_GRANTS_VIEW_ACCESS AND p_function_name = G_SELECT_ACCESS_LEVEL)
529: );
530:
531: -- Cursor to get current user's JTF resource id
532: CURSOR cur_user_jtf_resource_csr IS

Line 538: l_grantee_key FND_GRANTS.grantee_key%TYPE;

534: FROM jtf_rs_resource_extns
535: WHERE user_id = FND_GLOBAL.user_id();
536:
537: l_resource_id JTF_RS_RESOURCE_EXTNS.resource_id%TYPE;
538: l_grantee_key FND_GRANTS.grantee_key%TYPE;
539: l_grantee_orig_system FND_GRANTS.grantee_orig_system%TYPE;
540: l_grantee_orig_system_id FND_GRANTS.grantee_orig_system_id%TYPE;
541:
542: BEGIN

Line 539: l_grantee_orig_system FND_GRANTS.grantee_orig_system%TYPE;

535: WHERE user_id = FND_GLOBAL.user_id();
536:
537: l_resource_id JTF_RS_RESOURCE_EXTNS.resource_id%TYPE;
538: l_grantee_key FND_GRANTS.grantee_key%TYPE;
539: l_grantee_orig_system FND_GRANTS.grantee_orig_system%TYPE;
540: l_grantee_orig_system_id FND_GRANTS.grantee_orig_system_id%TYPE;
541:
542: BEGIN
543:

Line 540: l_grantee_orig_system_id FND_GRANTS.grantee_orig_system_id%TYPE;

536:
537: l_resource_id JTF_RS_RESOURCE_EXTNS.resource_id%TYPE;
538: l_grantee_key FND_GRANTS.grantee_key%TYPE;
539: l_grantee_orig_system FND_GRANTS.grantee_orig_system%TYPE;
540: l_grantee_orig_system_id FND_GRANTS.grantee_orig_system_id%TYPE;
541:
542: BEGIN
543:
544: l_api_name := 'check_contract_access';