APPS.CZ_MIGRATE dependencies on ALL_CONS_COLUMNS

Line 807: '(SELECT column_name FROM all_cons_columns ' ||

803:
804: if(xerr)then
805: cdyn := dbms_sql.open_cursor;
806: dbms_sql.parse(cdyn,
807: '(SELECT column_name FROM all_cons_columns ' ||
808: ' WHERE constraint_name = ''' || pkName || '''' ||
809: ' AND owner = ''' || CONFIGURATOR_SCHEMA || '''' ||
810: ' MINUS '||
811: 'SELECT column_name FROM all_cons_columns@' || dbLinkName ||

Line 811: 'SELECT column_name FROM all_cons_columns@' || dbLinkName ||

807: '(SELECT column_name FROM all_cons_columns ' ||
808: ' WHERE constraint_name = ''' || pkName || '''' ||
809: ' AND owner = ''' || CONFIGURATOR_SCHEMA || '''' ||
810: ' MINUS '||
811: 'SELECT column_name FROM all_cons_columns@' || dbLinkName ||
812: ' WHERE constraint_name = ''' || pkName || '''' ||
813: ' AND owner = ''' || CONFIGURATOR_SCHEMA || ''')' ||
814: ' UNION '||
815: '(SELECT column_name FROM all_cons_columns@' || dbLinkName ||

Line 815: '(SELECT column_name FROM all_cons_columns@' || dbLinkName ||

811: 'SELECT column_name FROM all_cons_columns@' || dbLinkName ||
812: ' WHERE constraint_name = ''' || pkName || '''' ||
813: ' AND owner = ''' || CONFIGURATOR_SCHEMA || ''')' ||
814: ' UNION '||
815: '(SELECT column_name FROM all_cons_columns@' || dbLinkName ||
816: ' WHERE constraint_name = ''' || pkName || '''' ||
817: ' AND owner = ''' || CONFIGURATOR_SCHEMA || '''' ||
818: ' MINUS '||
819: 'SELECT column_name FROM all_cons_columns ' ||

Line 819: 'SELECT column_name FROM all_cons_columns ' ||

815: '(SELECT column_name FROM all_cons_columns@' || dbLinkName ||
816: ' WHERE constraint_name = ''' || pkName || '''' ||
817: ' AND owner = ''' || CONFIGURATOR_SCHEMA || '''' ||
818: ' MINUS '||
819: 'SELECT column_name FROM all_cons_columns ' ||
820: ' WHERE constraint_name = ''' || pkName || '''' ||
821: ' AND owner = ''' || CONFIGURATOR_SCHEMA || ''')',
822: dbms_sql.native);
823: dbms_sql.define_array(cdyn,1,ColumnName,100,1);

Line 860: SELECT column_name FROM all_cons_columns

856: ------------------------------------------------------------------------------------------------------------
857: function get_table_pk_columns(inTableName in varchar2, outNamesArray OUT NOCOPY PkColumnNameArray)
858: return integer is
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)