APPS.ETRM_RPT dependencies on DBA_CONSTRAINTS

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

228: where ic.index_name = cv_index_name
229: and ic.index_owner = c_owner
230: order by ic.column_position;
231: --
232: cursor cur_primary_key(cv_table_name in dba_constraints.table_name%type
233: , c_owner in dba_objects.owner%type)
234: -- List the primary key
235: is select uc.constraint_name
236: from dba_constraints uc

Line 236: from dba_constraints uc

232: cursor cur_primary_key(cv_table_name in dba_constraints.table_name%type
233: , c_owner in dba_objects.owner%type)
234: -- List the primary key
235: is select uc.constraint_name
236: from dba_constraints uc
237: where uc.table_name = cv_table_name
238: and uc.owner = c_owner
239: and uc.constraint_type = 'P'
240: order by uc.constraint_name;

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

238: and uc.owner = c_owner
239: and uc.constraint_type = 'P'
240: order by uc.constraint_name;
241: --
242: cursor cur_unique_keys(cv_table_name in dba_constraints.table_name%type
243: , c_owner in dba_objects.owner%type)
244: -- List the unique key constraints
245: is select uc.constraint_name
246: from dba_constraints uc

Line 246: from dba_constraints uc

242: cursor cur_unique_keys(cv_table_name in dba_constraints.table_name%type
243: , c_owner in dba_objects.owner%type)
244: -- List the unique key constraints
245: is select uc.constraint_name
246: from dba_constraints uc
247: where uc.table_name = cv_table_name
248: and uc.constraint_type = 'U'
249: and uc.owner = c_owner
250: order by uc.constraint_name;

Line 274: v_pk_name dba_constraints.constraint_name%type;

270: unexpected_error EXCEPTION;
271: loop_counter INTEGER;
272: v_datetime varchar2(100);
273: v_user varchar2(30);
274: v_pk_name dba_constraints.constraint_name%type;
275: --
276: BEGIN
277: --
278: