DBA Data[Home] [Help]

APPS.AMW_VALID_INSTANCE_SET_GRANTS dependencies on AMW_VALID_INSTANCE_SET_GRANTS

Line 1: PACKAGE BODY AMW_VALID_INSTANCE_SET_GRANTS as

1: PACKAGE BODY AMW_VALID_INSTANCE_SET_GRANTS as
2: /*$Header: amwisgrb.pls 120.3 2006/05/30 12:35:30 dpatel noship $*/
3:
4: PROCEDURE GET_VALID_INSTANCE_SETS(p_obj_name IN VARCHAR2,
5: p_grantee_type IN VARCHAR2,

Line 544: ' and 1 = AMW_VALID_INSTANCE_SET_GRANTS.check_grant_validity' ||

540: ' and gr.instance_type = '||''''||'SET'||'''' ||
541: ' and grantee_type = '||''''||'USER'||'''' ||
542: ' and nvl(end_date, sysdate+1) >= trunc(sysdate) ' ||
543: ' and gr.instance_set_id = inst.instance_set_id ' ||
544: ' and 1 = AMW_VALID_INSTANCE_SET_GRANTS.check_grant_validity' ||
545: '(gr.grant_guid, ' ||lp_pk1||', '||lp_pk2||', '||lp_pk3||', '||lp_pk4||', '||lp_pk5||','||
546: ' fo.obj_name) ';
547:
548: return sql_string;

Line 552: end AMW_VALID_INSTANCE_SET_GRANTS;

548: return sql_string;
549:
550: end;
551:
552: end AMW_VALID_INSTANCE_SET_GRANTS;