APPS.CZ_MIGRATE dependencies on ALL_CONSTRAINTS

Line 789: pkName all_constraints.constraint_name%type;

785: return integer is
786: cdyn integer;
787: rdyn integer;
788: xerr boolean;
789: pkName all_constraints.constraint_name%type;
790: ColumnName dbms_sql.varchar2_table;
791: cursor c_getpkname is
792: SELECT constraint_name FROM all_constraints
793: WHERE table_name = upper(inTableName)

Line 792: SELECT constraint_name FROM all_constraints

788: xerr boolean;
789: pkName all_constraints.constraint_name%type;
790: ColumnName dbms_sql.varchar2_table;
791: cursor c_getpkname is
792: SELECT constraint_name FROM all_constraints
793: WHERE table_name = upper(inTableName)
794: AND owner = CONFIGURATOR_SCHEMA
795: AND constraint_type = 'P';
796: begin

Line 863: (SELECT constraint_name FROM all_constraints

859: cursor c_getpkcolumns is
860: SELECT column_name FROM all_cons_columns
861: WHERE owner = CONFIGURATOR_SCHEMA
862: AND constraint_name =
863: (SELECT constraint_name FROM all_constraints
864: WHERE table_name = upper(inTableName)
865: AND owner = CONFIGURATOR_SCHEMA
866: AND constraint_type='P');
867: nCounter integer := 1;