APPS.ETRM_PNAV dependencies on DBA_CONSTRAINTS

Line 619: -- fk details from sys.cdef$ because dba_constraints id slow

615: return v_return_val;
616: end dba_object_info;
617:
618: procedure ls_table(n_object_id in dba_objects.object_id%type) is
619: -- fk details from sys.cdef$ because dba_constraints id slow
620:
621:
622: cursor cur_fk(n_object_id in dba_objects.object_id%type) is
623: select etrm_pnav.get_object_name(robj#, 'RAW') table_name

Line 831: cursor cur_primary_key(cv_table_name in dba_constraints.table_name%type

827: order by COLUMN_POSITION;
828:
829:
830: --
831: cursor cur_primary_key(cv_table_name in dba_constraints.table_name%type
832: , c_owner in dba_objects.owner%type)
833: -- List the primary key
834: is select uc.constraint_name
835: from dba_constraints uc

Line 835: from dba_constraints uc

831: cursor cur_primary_key(cv_table_name in dba_constraints.table_name%type
832: , c_owner in dba_objects.owner%type)
833: -- List the primary key
834: is select uc.constraint_name
835: from dba_constraints uc
836: where uc.table_name = cv_table_name
837: and uc.owner = c_owner
838: and uc.constraint_type = 'P'
839: order by uc.constraint_name;

Line 841: cursor cur_unique_keys(cv_table_name in dba_constraints.table_name%type

837: and uc.owner = c_owner
838: and uc.constraint_type = 'P'
839: order by uc.constraint_name;
840: --
841: cursor cur_unique_keys(cv_table_name in dba_constraints.table_name%type
842: , c_owner in dba_objects.owner%type)
843: -- List the unique key constraints
844: is select uc.constraint_name
845: from dba_constraints uc

Line 845: from dba_constraints uc

841: cursor cur_unique_keys(cv_table_name in dba_constraints.table_name%type
842: , c_owner in dba_objects.owner%type)
843: -- List the unique key constraints
844: is select uc.constraint_name
845: from dba_constraints uc
846: where uc.table_name = cv_table_name
847: and uc.constraint_type = 'U'
848: and uc.owner = c_owner
849: order by uc.constraint_name;

Line 873: v_pk_name dba_constraints.constraint_name%type;

869: unexpected_error EXCEPTION;
870: loop_counter INTEGER;
871: v_datetime varchar2(100);
872: v_user varchar2(30);
873: v_pk_name dba_constraints.constraint_name%type;
874: --
875: BEGIN
876: --
877: