APPS.OKC_REP_UTIL_PVT dependencies on FND_GRANTS

Line 467: 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

463: contract_type
464: FROM okc_rep_contracts_all
465: WHERE contract_id = p_contract_id;
466:
467: 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
468: SELECT
469: NULL
470: FROM
471: jtf_rs_groups_denorm d

Line 474: ,fnd_grants g

470: FROM
471: jtf_rs_groups_denorm d
472: ,jtf_rs_group_members m
473: ,jtf_rs_resource_extns e
474: ,fnd_grants g
475: ,fnd_objects o
476: WHERE d.parent_group_id = g.parameter2
477: AND TRUNC(SYSDATE)
478: BETWEEN d.start_date_active

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

485: AND g.grantee_type = G_FND_GRANTEE_TYPE_GROUP
486: AND g.instance_pk1_value = p_contract_id1
487: AND e.user_id = FND_GLOBAL.user_id()
488: AND (
489: (g.parameter3 = G_FND_GRANTS_UPDATE_ACCESS AND p_function_name IN (G_SELECT_ACCESS_LEVEL, G_UPDATE_ACCESS_LEVEL))
490: OR (g.parameter3 = G_FND_GRANTS_VIEW_ACCESS AND p_function_name = G_SELECT_ACCESS_LEVEL)
491: )
492: UNION ALL
493: SELECT

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

486: AND g.instance_pk1_value = p_contract_id1
487: AND e.user_id = FND_GLOBAL.user_id()
488: AND (
489: (g.parameter3 = G_FND_GRANTS_UPDATE_ACCESS AND p_function_name IN (G_SELECT_ACCESS_LEVEL, G_UPDATE_ACCESS_LEVEL))
490: OR (g.parameter3 = G_FND_GRANTS_VIEW_ACCESS AND p_function_name = G_SELECT_ACCESS_LEVEL)
491: )
492: UNION ALL
493: SELECT
494: NULL

Line 496: fnd_grants g

492: UNION ALL
493: SELECT
494: NULL
495: FROM
496: fnd_grants g
497: ,fnd_objects o
498: WHERE g.object_id = o.object_id
499: AND o.obj_name = G_OBJECT_NAME
500: AND g.grantee_type = G_FND_GRANTEE_TYPE_USER

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

503: (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
504: OR (g.grantee_key = FND_GLOBAL.user_name() AND g.grantee_orig_system = 'PER') -- for 11.5 backward compatibility
505: )
506: AND (
507: (g.parameter3 = G_FND_GRANTS_UPDATE_ACCESS AND p_function_name IN (G_SELECT_ACCESS_LEVEL, G_UPDATE_ACCESS_LEVEL))
508: OR (g.parameter3 = G_FND_GRANTS_VIEW_ACCESS AND p_function_name = G_SELECT_ACCESS_LEVEL)
509: );
510:
511: -- Cursor to get current user's JTF resource id

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

504: OR (g.grantee_key = FND_GLOBAL.user_name() AND g.grantee_orig_system = 'PER') -- for 11.5 backward compatibility
505: )
506: AND (
507: (g.parameter3 = G_FND_GRANTS_UPDATE_ACCESS AND p_function_name IN (G_SELECT_ACCESS_LEVEL, G_UPDATE_ACCESS_LEVEL))
508: OR (g.parameter3 = G_FND_GRANTS_VIEW_ACCESS AND p_function_name = G_SELECT_ACCESS_LEVEL)
509: );
510:
511: -- Cursor to get current user's JTF resource id
512: CURSOR cur_user_jtf_resource_csr IS

Line 518: l_grantee_key FND_GRANTS.grantee_key%TYPE;

514: FROM jtf_rs_resource_extns
515: WHERE user_id = FND_GLOBAL.user_id();
516:
517: l_resource_id JTF_RS_RESOURCE_EXTNS.resource_id%TYPE;
518: l_grantee_key FND_GRANTS.grantee_key%TYPE;
519: l_grantee_orig_system FND_GRANTS.grantee_orig_system%TYPE;
520: l_grantee_orig_system_id FND_GRANTS.grantee_orig_system_id%TYPE;
521:
522: BEGIN

Line 519: l_grantee_orig_system FND_GRANTS.grantee_orig_system%TYPE;

515: WHERE user_id = FND_GLOBAL.user_id();
516:
517: l_resource_id JTF_RS_RESOURCE_EXTNS.resource_id%TYPE;
518: l_grantee_key FND_GRANTS.grantee_key%TYPE;
519: l_grantee_orig_system FND_GRANTS.grantee_orig_system%TYPE;
520: l_grantee_orig_system_id FND_GRANTS.grantee_orig_system_id%TYPE;
521:
522: BEGIN
523:

Line 520: l_grantee_orig_system_id FND_GRANTS.grantee_orig_system_id%TYPE;

516:
517: l_resource_id JTF_RS_RESOURCE_EXTNS.resource_id%TYPE;
518: l_grantee_key FND_GRANTS.grantee_key%TYPE;
519: l_grantee_orig_system FND_GRANTS.grantee_orig_system%TYPE;
520: l_grantee_orig_system_id FND_GRANTS.grantee_orig_system_id%TYPE;
521:
522: BEGIN
523:
524: l_api_name := 'check_contract_access';