APPS.EDW_UPDATE_ATTRIBUTES dependencies on DBMS_SQL

Line 39: g_where_clause dbms_sql.varchar2_table;

35: ---+==========================================================================*
36:
37:
38:
39: g_where_clause dbms_sql.varchar2_table;
40:
41: g_total_seconds number := 0;
42: g_time_start date;
43: g_time_end date;

Line 77: Procedure drop_temp_tables(l_table_list in dbms_sql.varchar2_table) IS

73: utl_file.fflush(g_file);
74:
75: end;
76:
77: Procedure drop_temp_tables(l_table_list in dbms_sql.varchar2_table) IS
78:
79: l_count number := 0;
80: BEGIN
81:

Line 135: l_tables dbms_sql.varchar2_table;

131: l_count number := 0;
132:
133: l_input_table varchar2(3000);
134:
135: l_tables dbms_sql.varchar2_table;
136: l_alias dbms_sql.varchar2_table;
137:
138: l_output_table varchar2(3000);
139:

Line 136: l_alias dbms_sql.varchar2_table;

132:
133: l_input_table varchar2(3000);
134:
135: l_tables dbms_sql.varchar2_table;
136: l_alias dbms_sql.varchar2_table;
137:
138: l_output_table varchar2(3000);
139:
140: BEGIN

Line 326: l_cursor:=dbms_sql.open_cursor;

322: p_link||' where flex_value_set_id = :vsid';
323:
324: writelog(l_stmt);
325:
326: l_cursor:=dbms_sql.open_cursor;
327: dbms_sql.parse(l_cursor, l_stmt, dbms_sql.native);
328: dbms_sql.bind_variable(l_cursor, ':vsid', p_value_set_id);
329: dbms_sql.define_column_long(l_cursor,1);
330:

Line 327: dbms_sql.parse(l_cursor, l_stmt, dbms_sql.native);

323:
324: writelog(l_stmt);
325:
326: l_cursor:=dbms_sql.open_cursor;
327: dbms_sql.parse(l_cursor, l_stmt, dbms_sql.native);
328: dbms_sql.bind_variable(l_cursor, ':vsid', p_value_set_id);
329: dbms_sql.define_column_long(l_cursor,1);
330:
331: l_dummy:=dbms_sql.execute(l_cursor);

Line 328: dbms_sql.bind_variable(l_cursor, ':vsid', p_value_set_id);

324: writelog(l_stmt);
325:
326: l_cursor:=dbms_sql.open_cursor;
327: dbms_sql.parse(l_cursor, l_stmt, dbms_sql.native);
328: dbms_sql.bind_variable(l_cursor, ':vsid', p_value_set_id);
329: dbms_sql.define_column_long(l_cursor,1);
330:
331: l_dummy:=dbms_sql.execute(l_cursor);
332: l_rows:=dbms_sql.fetch_rows(l_cursor);

Line 329: dbms_sql.define_column_long(l_cursor,1);

325:
326: l_cursor:=dbms_sql.open_cursor;
327: dbms_sql.parse(l_cursor, l_stmt, dbms_sql.native);
328: dbms_sql.bind_variable(l_cursor, ':vsid', p_value_set_id);
329: dbms_sql.define_column_long(l_cursor,1);
330:
331: l_dummy:=dbms_sql.execute(l_cursor);
332: l_rows:=dbms_sql.fetch_rows(l_cursor);
333:

Line 331: l_dummy:=dbms_sql.execute(l_cursor);

327: dbms_sql.parse(l_cursor, l_stmt, dbms_sql.native);
328: dbms_sql.bind_variable(l_cursor, ':vsid', p_value_set_id);
329: dbms_sql.define_column_long(l_cursor,1);
330:
331: l_dummy:=dbms_sql.execute(l_cursor);
332: l_rows:=dbms_sql.fetch_rows(l_cursor);
333:
334: loop
335: -- fetch 'chunks' of the long until we have got the lot

Line 332: l_rows:=dbms_sql.fetch_rows(l_cursor);

328: dbms_sql.bind_variable(l_cursor, ':vsid', p_value_set_id);
329: dbms_sql.define_column_long(l_cursor,1);
330:
331: l_dummy:=dbms_sql.execute(l_cursor);
332: l_rows:=dbms_sql.fetch_rows(l_cursor);
333:
334: loop
335: -- fetch 'chunks' of the long until we have got the lot
336:

Line 338: dbms_sql.column_value_long(l_cursor,1,l_chunk_size,l_cur_pos,l_data_chunk,l_chunk_size_returned);

334: loop
335: -- fetch 'chunks' of the long until we have got the lot
336:
337:
338: dbms_sql.column_value_long(l_cursor,1,l_chunk_size,l_cur_pos,l_data_chunk,l_chunk_size_returned);
339:
340: IF (upper(l_data_chunk) like '%$FLEX$' OR l_data_chunk like '%$PROFILE$%') THEN
341: return false;
342: END IF;

Line 376: dbms_sql.close_cursor(l_cursor);

372:
373: g_where_clause(0) := ' where '||g_where_clause(0);
374: END IF;
375:
376: dbms_sql.close_cursor(l_cursor);
377:
378: return true;
379:
380: END;

Line 751: l_drop_these dbms_sql.varchar2_table;

747:
748: b_idFlag boolean := true;
749: l_ignorable_attributes varchar2(1000);
750:
751: l_drop_these dbms_sql.varchar2_table;
752:
753:
754: l_object_id number := 0;
755: