69: srcview VARCHAR2(32760);
70: l_temp_stmt VARCHAR2(32760);
71: l_write_view_counter INTEGER:=0;
72: l_build_stmt_counter integer:=0;
73: v_col DBMS_SQL.VARCHAR2_TABLE;
74: v_colType DBMS_SQL.VARCHAR2_TABLE;
75: v_retCode INTEGER;
76: nColCount INTEGER := 0;
77: nOuterLoopCount INTEGER := 0;
70: l_temp_stmt VARCHAR2(32760);
71: l_write_view_counter INTEGER:=0;
72: l_build_stmt_counter integer:=0;
73: v_col DBMS_SQL.VARCHAR2_TABLE;
74: v_colType DBMS_SQL.VARCHAR2_TABLE;
75: v_retCode INTEGER;
76: nColCount INTEGER := 0;
77: nOuterLoopCount INTEGER := 0;
78: nInnerLoopCount INTEGER := 0;
153: ||''') AND owner = '''||edw_gen_view.g_apps_schema||'''';
154:
155:
156: BEGIN
157: cid := DBMS_SQL.open_cursor;
158:
159: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
160: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nColCount, 1);
161: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);
155:
156: BEGIN
157: cid := DBMS_SQL.open_cursor;
158:
159: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
160: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nColCount, 1);
161: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);
162: v_retCode := DBMS_SQL.EXECUTE_AND_FETCH(cid);
163: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
156: BEGIN
157: cid := DBMS_SQL.open_cursor;
158:
159: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
160: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nColCount, 1);
161: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);
162: v_retCode := DBMS_SQL.EXECUTE_AND_FETCH(cid);
163: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
164: DBMS_SQL.COLUMN_VALUE(cid, 2, v_colType);
157: cid := DBMS_SQL.open_cursor;
158:
159: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
160: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nColCount, 1);
161: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);
162: v_retCode := DBMS_SQL.EXECUTE_AND_FETCH(cid);
163: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
164: DBMS_SQL.COLUMN_VALUE(cid, 2, v_colType);
165: DBMS_SQL.CLOSE_CURSOR(cid);
158:
159: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
160: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nColCount, 1);
161: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);
162: v_retCode := DBMS_SQL.EXECUTE_AND_FETCH(cid);
163: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
164: DBMS_SQL.COLUMN_VALUE(cid, 2, v_colType);
165: DBMS_SQL.CLOSE_CURSOR(cid);
166:
159: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
160: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nColCount, 1);
161: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);
162: v_retCode := DBMS_SQL.EXECUTE_AND_FETCH(cid);
163: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
164: DBMS_SQL.COLUMN_VALUE(cid, 2, v_colType);
165: DBMS_SQL.CLOSE_CURSOR(cid);
166:
167:
160: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nColCount, 1);
161: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);
162: v_retCode := DBMS_SQL.EXECUTE_AND_FETCH(cid);
163: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
164: DBMS_SQL.COLUMN_VALUE(cid, 2, v_colType);
165: DBMS_SQL.CLOSE_CURSOR(cid);
166:
167:
168:
161: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);
162: v_retCode := DBMS_SQL.EXECUTE_AND_FETCH(cid);
163: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
164: DBMS_SQL.COLUMN_VALUE(cid, 2, v_colType);
165: DBMS_SQL.CLOSE_CURSOR(cid);
166:
167:
168:
169: edw_gen_view.getColumnMaps(fact_name, attColumns, multiAttList,
817: END IF;
818: END IF;
819: END IF;
820:
821: /* DBMS_SQL.CLOSE_CURSOR(cid); */
822:
823: IF (g_log) THEN
824: edw_gen_view.writelog('Completed getdecodeclauseforflexfk, returning '||sDecodeClause||newline||newline);
825: edw_gen_view.indentEnd;