eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_DIM_SV dependencies on DBMS_SQL

Line 173: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;

169:
170:
171: edw_gen_view.writelog('Querying for columns : '||stmt);
172:
173: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
174: DBMS_SQL.parse(l_cursor_id, stmt, DBMS_SQL.V7);
175: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':table_name', l_table, 50);
176:
177: DBMS_SQL.define_column(l_cursor_id, 1, l_column, 40);

Line 174: DBMS_SQL.parse(l_cursor_id, stmt, DBMS_SQL.V7);

170:
171: edw_gen_view.writelog('Querying for columns : '||stmt);
172:
173: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
174: DBMS_SQL.parse(l_cursor_id, stmt, DBMS_SQL.V7);
175: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':table_name', l_table, 50);
176:
177: DBMS_SQL.define_column(l_cursor_id, 1, l_column, 40);
178: l_count :=DBMS_SQL.execute(l_cursor_id);

Line 175: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':table_name', l_table, 50);

171: edw_gen_view.writelog('Querying for columns : '||stmt);
172:
173: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
174: DBMS_SQL.parse(l_cursor_id, stmt, DBMS_SQL.V7);
175: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':table_name', l_table, 50);
176:
177: DBMS_SQL.define_column(l_cursor_id, 1, l_column, 40);
178: l_count :=DBMS_SQL.execute(l_cursor_id);
179:

Line 177: DBMS_SQL.define_column(l_cursor_id, 1, l_column, 40);

173: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
174: DBMS_SQL.parse(l_cursor_id, stmt, DBMS_SQL.V7);
175: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':table_name', l_table, 50);
176:
177: DBMS_SQL.define_column(l_cursor_id, 1, l_column, 40);
178: l_count :=DBMS_SQL.execute(l_cursor_id);
179:
180: loop
181: if DBMS_SQL.fetch_rows(l_cursor_id)=0 then

Line 178: l_count :=DBMS_SQL.execute(l_cursor_id);

174: DBMS_SQL.parse(l_cursor_id, stmt, DBMS_SQL.V7);
175: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':table_name', l_table, 50);
176:
177: DBMS_SQL.define_column(l_cursor_id, 1, l_column, 40);
178: l_count :=DBMS_SQL.execute(l_cursor_id);
179:
180: loop
181: if DBMS_SQL.fetch_rows(l_cursor_id)=0 then
182: exit;

Line 181: if DBMS_SQL.fetch_rows(l_cursor_id)=0 then

177: DBMS_SQL.define_column(l_cursor_id, 1, l_column, 40);
178: l_count :=DBMS_SQL.execute(l_cursor_id);
179:
180: loop
181: if DBMS_SQL.fetch_rows(l_cursor_id)=0 then
182: exit;
183: end if;
184:
185: DBMS_SQL.column_value (l_cursor_id, 1, l_column);

Line 185: DBMS_SQL.column_value (l_cursor_id, 1, l_column);

181: if DBMS_SQL.fetch_rows(l_cursor_id)=0 then
182: exit;
183: end if;
184:
185: DBMS_SQL.column_value (l_cursor_id, 1, l_column);
186: IF (l_column = 'LAST_UPDATE_DATE') THEN
187: g_last_update_date_exists := true;
188: ELSIF (l_column = 'CREATION_DATE') THEN
189: g_creation_date_exists := true;

Line 195: DBMS_SQL.close_cursor(l_cursor_id);

191: g_description_exists := true;
192: END IF;
193: end loop;
194:
195: DBMS_SQL.close_cursor(l_cursor_id);
196:
197: IF (g_log) THEN
198: edw_gen_view.writelog('Completed checkColumnsPresent');
199: edw_gen_view.indentEnd;

Line 341: valueCol DBMS_SQL.VARCHAR2_TABLE;

337: Function getTableValClause(dim_name in varchar2) RETURN varchar2 IS
338: clause varchar2(32000) := null;
339: stmt1 varchar2(2000);
340: stmt2 varchar2(2000);
341: valueCol DBMS_SQL.VARCHAR2_TABLE;
342:
343: l_singleClause varchar2(2000);
344: l_dummy_int number;
345: l_count number := 1;

Line 932: v_col DBMS_SQL.VARCHAR2_TABLE;

928: nOuterLoopCount INTEGER := 0;
929: nInnerLoopCount INTEGER := 0;
930: srcview VARCHAR2(32000) := null;
931: l_temp_stmt VARCHAR2(32000) := null;
932: v_col DBMS_SQL.VARCHAR2_TABLE;
933: v_colType DBMS_SQL.VARCHAR2_TABLE;
934: decodeClause VARCHAR2(3000);
935:
936: Cursor C_Skip_Columns(p_object_short_name VARCHAR2, p_level_name VARCHAR2) IS

Line 933: v_colType DBMS_SQL.VARCHAR2_TABLE;

929: nInnerLoopCount INTEGER := 0;
930: srcview VARCHAR2(32000) := null;
931: l_temp_stmt VARCHAR2(32000) := null;
932: v_col DBMS_SQL.VARCHAR2_TABLE;
933: v_colType DBMS_SQL.VARCHAR2_TABLE;
934: decodeClause VARCHAR2(3000);
935:
936: Cursor C_Skip_Columns(p_object_short_name VARCHAR2, p_level_name VARCHAR2) IS
937: select attribute_name, attribute_type

Line 975: cid := DBMS_SQL.open_cursor;

971:
972: stmt := 'SELECT distinct column_name, data_type FROM all_tab_columns@'||edw_gen_view.g_source_db_link;
973: stmt := stmt||' WHERE table_name = :view_name and owner = :owner';
974:
975: cid := DBMS_SQL.open_cursor;
976:
977: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
978: DBMS_SQL.BIND_VARIABLE(cid, ':view_name', upper(view_name), 50);
979: DBMS_SQL.BIND_VARIABLE(cid, ':owner', edw_gen_view.g_apps_schema, 50);

Line 977: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);

973: stmt := stmt||' WHERE table_name = :view_name and owner = :owner';
974:
975: cid := DBMS_SQL.open_cursor;
976:
977: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
978: DBMS_SQL.BIND_VARIABLE(cid, ':view_name', upper(view_name), 50);
979: DBMS_SQL.BIND_VARIABLE(cid, ':owner', edw_gen_view.g_apps_schema, 50);
980:
981: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nColCount, 1);

Line 978: DBMS_SQL.BIND_VARIABLE(cid, ':view_name', upper(view_name), 50);

974:
975: cid := DBMS_SQL.open_cursor;
976:
977: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
978: DBMS_SQL.BIND_VARIABLE(cid, ':view_name', upper(view_name), 50);
979: DBMS_SQL.BIND_VARIABLE(cid, ':owner', edw_gen_view.g_apps_schema, 50);
980:
981: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nColCount, 1);
982: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);

Line 979: DBMS_SQL.BIND_VARIABLE(cid, ':owner', edw_gen_view.g_apps_schema, 50);

975: cid := DBMS_SQL.open_cursor;
976:
977: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
978: DBMS_SQL.BIND_VARIABLE(cid, ':view_name', upper(view_name), 50);
979: DBMS_SQL.BIND_VARIABLE(cid, ':owner', edw_gen_view.g_apps_schema, 50);
980:
981: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nColCount, 1);
982: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);
983: v_retCode := DBMS_SQL.EXECUTE(cid);

Line 981: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nColCount, 1);

977: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
978: DBMS_SQL.BIND_VARIABLE(cid, ':view_name', upper(view_name), 50);
979: DBMS_SQL.BIND_VARIABLE(cid, ':owner', edw_gen_view.g_apps_schema, 50);
980:
981: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nColCount, 1);
982: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);
983: v_retCode := DBMS_SQL.EXECUTE(cid);
984: v_retCode := DBMS_SQL.FETCH_ROWS(cid);
985: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);

Line 982: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);

978: DBMS_SQL.BIND_VARIABLE(cid, ':view_name', upper(view_name), 50);
979: DBMS_SQL.BIND_VARIABLE(cid, ':owner', edw_gen_view.g_apps_schema, 50);
980:
981: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nColCount, 1);
982: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);
983: v_retCode := DBMS_SQL.EXECUTE(cid);
984: v_retCode := DBMS_SQL.FETCH_ROWS(cid);
985: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
986: DBMS_SQL.COLUMN_VALUE(cid, 2, v_colType);

Line 983: v_retCode := DBMS_SQL.EXECUTE(cid);

979: DBMS_SQL.BIND_VARIABLE(cid, ':owner', edw_gen_view.g_apps_schema, 50);
980:
981: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nColCount, 1);
982: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);
983: v_retCode := DBMS_SQL.EXECUTE(cid);
984: v_retCode := DBMS_SQL.FETCH_ROWS(cid);
985: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
986: DBMS_SQL.COLUMN_VALUE(cid, 2, v_colType);
987: DBMS_SQL.close_cursor(cid);

Line 984: v_retCode := DBMS_SQL.FETCH_ROWS(cid);

980:
981: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nColCount, 1);
982: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);
983: v_retCode := DBMS_SQL.EXECUTE(cid);
984: v_retCode := DBMS_SQL.FETCH_ROWS(cid);
985: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
986: DBMS_SQL.COLUMN_VALUE(cid, 2, v_colType);
987: DBMS_SQL.close_cursor(cid);
988:

Line 985: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);

981: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nColCount, 1);
982: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);
983: v_retCode := DBMS_SQL.EXECUTE(cid);
984: v_retCode := DBMS_SQL.FETCH_ROWS(cid);
985: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
986: DBMS_SQL.COLUMN_VALUE(cid, 2, v_colType);
987: DBMS_SQL.close_cursor(cid);
988:
989: edw_gen_view.getColumnMaps(dim_name, attColumns, multiAttList,

Line 986: DBMS_SQL.COLUMN_VALUE(cid, 2, v_colType);

982: DBMS_SQL.DEFINE_ARRAY(cid, 2, v_colType, nColCount, 1);
983: v_retCode := DBMS_SQL.EXECUTE(cid);
984: v_retCode := DBMS_SQL.FETCH_ROWS(cid);
985: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
986: DBMS_SQL.COLUMN_VALUE(cid, 2, v_colType);
987: DBMS_SQL.close_cursor(cid);
988:
989: edw_gen_view.getColumnMaps(dim_name, attColumns, multiAttList,
990: flexColumns, fkColumns, level_name);

Line 987: DBMS_SQL.close_cursor(cid);

983: v_retCode := DBMS_SQL.EXECUTE(cid);
984: v_retCode := DBMS_SQL.FETCH_ROWS(cid);
985: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
986: DBMS_SQL.COLUMN_VALUE(cid, 2, v_colType);
987: DBMS_SQL.close_cursor(cid);
988:
989: edw_gen_view.getColumnMaps(dim_name, attColumns, multiAttList,
990: flexColumns, fkColumns, level_name);
991: