DBA Data[Home] [Help]

APPS.EGO_DATA_SECURITY dependencies on EGO_VARCHAR_TBL_TYPE

Line 179: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE

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

Line 354: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,

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

Line 355: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,

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: ) ;

Line 356: p_parent_obj_alias_tbl IN EGO_VARCHAR_TBL_TYPE,

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:

Line 378: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,

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,

Line 379: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,

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

Line 380: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,

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: ) ;

Line 381: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,

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:

Line 403: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,

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,

Line 404: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,

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,

Line 405: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,

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

Line 406: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,

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: );

Line 622: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE

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:

Line 638: p_parent_object_name_tbl IN EGO_VARCHAR_TBL_TYPE,

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: ) ;

Line 639: p_parent_object_sql_tbl IN EGO_VARCHAR_TBL_TYPE,

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:

Line 641: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE

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

Line 655: p_parent_object_name_tbl IN EGO_VARCHAR_TBL_TYPE,

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: )

Line 656: p_parent_object_sql_tbl IN EGO_VARCHAR_TBL_TYPE,

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;