175: p_parent_instance_pk3_value IN VARCHAR2 DEFAULT NULL,
176: p_parent_instance_pk4_value IN VARCHAR2 DEFAULT NULL,
177: p_parent_instance_pk5_value IN VARCHAR2 DEFAULT NULL,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE
180: ) ;
181:
182: ----------------------------------------------------------------
183: PROCEDURE get_security_predicate
350: p_pk3_alias IN VARCHAR2 DEFAULT NULL,
351: p_pk4_alias IN VARCHAR2 DEFAULT NULL,
352: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
353: p_object_type IN VARCHAR2 default null,
354: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
355: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
356: p_parent_obj_alias_tbl IN EGO_VARCHAR_TBL_TYPE,
357: x_predicate OUT NOCOPY VARCHAR2,
358: x_return_status OUT NOCOPY VARCHAR2
351: p_pk4_alias IN VARCHAR2 DEFAULT NULL,
352: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
353: p_object_type IN VARCHAR2 default null,
354: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
355: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
356: p_parent_obj_alias_tbl IN EGO_VARCHAR_TBL_TYPE,
357: x_predicate OUT NOCOPY VARCHAR2,
358: x_return_status OUT NOCOPY VARCHAR2
359: ) ;
352: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
353: p_object_type IN VARCHAR2 default null,
354: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
355: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
356: p_parent_obj_alias_tbl IN EGO_VARCHAR_TBL_TYPE,
357: x_predicate OUT NOCOPY VARCHAR2,
358: x_return_status OUT NOCOPY VARCHAR2
359: ) ;
360:
374: p_pk3_alias IN VARCHAR2 DEFAULT NULL,
375: p_pk4_alias IN VARCHAR2 DEFAULT NULL,
376: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
377: p_object_type IN VARCHAR2 default null,
378: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
379: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
380: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,
381: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,
382: x_predicate OUT NOCOPY VARCHAR2,
375: p_pk4_alias IN VARCHAR2 DEFAULT NULL,
376: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
377: p_object_type IN VARCHAR2 default null,
378: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
379: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
380: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,
381: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,
382: x_predicate OUT NOCOPY VARCHAR2,
383: x_return_status OUT NOCOPY VARCHAR2
376: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
377: p_object_type IN VARCHAR2 default null,
378: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
379: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
380: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,
381: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,
382: x_predicate OUT NOCOPY VARCHAR2,
383: x_return_status OUT NOCOPY VARCHAR2
384: ) ;
377: p_object_type IN VARCHAR2 default null,
378: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
379: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
380: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,
381: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,
382: x_predicate OUT NOCOPY VARCHAR2,
383: x_return_status OUT NOCOPY VARCHAR2
384: ) ;
385:
399: p_pk3_alias IN VARCHAR2 DEFAULT NULL,
400: p_pk4_alias IN VARCHAR2 DEFAULT NULL,
401: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
402: p_object_type IN VARCHAR2 default null,
403: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
404: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
405: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,
406: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,
407: x_predicate OUT NOCOPY varchar2,
400: p_pk4_alias IN VARCHAR2 DEFAULT NULL,
401: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
402: p_object_type IN VARCHAR2 default null,
403: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
404: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
405: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,
406: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,
407: x_predicate OUT NOCOPY varchar2,
408: x_clob_predicate OUT NOCOPY CLOB,
401: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
402: p_object_type IN VARCHAR2 default null,
403: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
404: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
405: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,
406: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,
407: x_predicate OUT NOCOPY varchar2,
408: x_clob_predicate OUT NOCOPY CLOB,
409: x_return_status OUT NOCOPY varchar2
402: p_object_type IN VARCHAR2 default null,
403: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
404: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
405: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,
406: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,
407: x_predicate OUT NOCOPY varchar2,
408: x_clob_predicate OUT NOCOPY CLOB,
409: x_return_status OUT NOCOPY varchar2
410: );
618: (
619: p_api_version IN NUMBER,
620: p_role_name IN VARCHAR2,
621: x_return_status OUT NOCOPY VARCHAR2,
622: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE
623: ) ;
624:
625: ----------------------------------------------------------------
626:
634: p_instance_pk4_value IN VARCHAR2 DEFAULT NULL,
635: p_instance_pk5_value IN VARCHAR2 DEFAULT NULL,
636: p_user_name IN VARCHAR2 DEFAULT NULL,
637: p_object_type IN VARCHAR2 DEFAULT NULL,
638: p_parent_object_name_tbl IN EGO_VARCHAR_TBL_TYPE,
639: p_parent_object_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
640: x_return_status OUT NOCOPY VARCHAR2,
641: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE
642: ) ;
635: p_instance_pk5_value IN VARCHAR2 DEFAULT NULL,
636: p_user_name IN VARCHAR2 DEFAULT NULL,
637: p_object_type IN VARCHAR2 DEFAULT NULL,
638: p_parent_object_name_tbl IN EGO_VARCHAR_TBL_TYPE,
639: p_parent_object_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
640: x_return_status OUT NOCOPY VARCHAR2,
641: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE
642: ) ;
643:
637: p_object_type IN VARCHAR2 DEFAULT NULL,
638: p_parent_object_name_tbl IN EGO_VARCHAR_TBL_TYPE,
639: p_parent_object_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
640: x_return_status OUT NOCOPY VARCHAR2,
641: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE
642: ) ;
643:
644:
645: FUNCTION check_inherited_function
651: p_instance_pk2_value IN VARCHAR2 DEFAULT NULL,
652: p_instance_pk3_value IN VARCHAR2 DEFAULT NULL,
653: p_instance_pk4_value IN VARCHAR2 DEFAULT NULL,
654: p_instance_pk5_value IN VARCHAR2 DEFAULT NULL,
655: p_parent_object_name_tbl IN EGO_VARCHAR_TBL_TYPE,
656: p_parent_object_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
657: p_user_name IN VARCHAR2 DEFAULT NULL,
658: p_object_type IN VARCHAR2 DEFAULT NULL
659: )
652: p_instance_pk3_value IN VARCHAR2 DEFAULT NULL,
653: p_instance_pk4_value IN VARCHAR2 DEFAULT NULL,
654: p_instance_pk5_value IN VARCHAR2 DEFAULT NULL,
655: p_parent_object_name_tbl IN EGO_VARCHAR_TBL_TYPE,
656: p_parent_object_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
657: p_user_name IN VARCHAR2 DEFAULT NULL,
658: p_object_type IN VARCHAR2 DEFAULT NULL
659: )
660: RETURN VARCHAR2;