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.BSC_DBGEN_UTILS dependencies on DBMS_SQL

Line 233: FUNCTION get_measure_list(p_expression IN VARCHAR2) RETURN dbms_sql.varchar2_table IS

229: -- CamposExpresion(): array to be populated
230: -- Expresion: expression
231: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
232: --****************************************************************************
233: FUNCTION get_measure_list(p_expression IN VARCHAR2) RETURN dbms_sql.varchar2_table IS
234: i NUMBER;
235: l_measure_list_tmp dbms_sql.varchar2_table;
236: l_expression VARCHAR2(1000);
237: l_measure_list dbms_sql.varchar2_table ;

Line 235: l_measure_list_tmp dbms_sql.varchar2_table;

231: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
232: --****************************************************************************
233: FUNCTION get_measure_list(p_expression IN VARCHAR2) RETURN dbms_sql.varchar2_table IS
234: i NUMBER;
235: l_measure_list_tmp dbms_sql.varchar2_table;
236: l_expression VARCHAR2(1000);
237: l_measure_list dbms_sql.varchar2_table ;
238: BEGIN
239: IF (g_initialized=false) THEN

Line 237: l_measure_list dbms_sql.varchar2_table ;

233: FUNCTION get_measure_list(p_expression IN VARCHAR2) RETURN dbms_sql.varchar2_table IS
234: i NUMBER;
235: l_measure_list_tmp dbms_sql.varchar2_table;
236: l_expression VARCHAR2(1000);
237: l_measure_list dbms_sql.varchar2_table ;
238: BEGIN
239: IF (g_initialized=false) THEN
240: init;
241: END IF;

Line 380: FUNCTION get_source_table_names(p_table_name IN VARCHAR2) RETURN DBMS_SQL.VARCHAR2_TABLE IS

376: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_property_value:'||sqlerrm||', p_name='||p_name);
377: raise;
378: END;
379:
380: FUNCTION get_source_table_names(p_table_name IN VARCHAR2) RETURN DBMS_SQL.VARCHAR2_TABLE IS
381: CURSOR cList IS
382: select source_table_name from bsc_db_tables_rels
383: connect by table_name = prior source_table_name
384: start with table_name = p_table_name;

Line 385: l_list DBMS_SQL.VARCHAR2_TABLE;

381: CURSOR cList IS
382: select source_table_name from bsc_db_tables_rels
383: connect by table_name = prior source_table_name
384: start with table_name = p_table_name;
385: l_list DBMS_SQL.VARCHAR2_TABLE;
386: BEGIN
387: IF (g_initialized=false) THEN
388: init;
389: END IF;

Line 501: FUNCTION get_char_chunks(p_msg IN VARCHAR2, p_chunk_size IN NUMBER default 256) return DBMS_SQL.VARCHAR2_TABLE IS

497: RETURN 'OBJECTIVE';
498: END get_Objective_Type;
499:
500: -- Given a varchar2 string, chop it into chunks and return
501: FUNCTION get_char_chunks(p_msg IN VARCHAR2, p_chunk_size IN NUMBER default 256) return DBMS_SQL.VARCHAR2_TABLE IS
502: l_varchar2_Table DBMS_SQL.VARCHAR2_TABLE;
503: l_chunk VARCHAR2(2000);
504: l_msg VARCHAR2(32767);
505: l_chunk_size NUMBER;

Line 502: l_varchar2_Table DBMS_SQL.VARCHAR2_TABLE;

498: END get_Objective_Type;
499:
500: -- Given a varchar2 string, chop it into chunks and return
501: FUNCTION get_char_chunks(p_msg IN VARCHAR2, p_chunk_size IN NUMBER default 256) return DBMS_SQL.VARCHAR2_TABLE IS
502: l_varchar2_Table DBMS_SQL.VARCHAR2_TABLE;
503: l_chunk VARCHAR2(2000);
504: l_msg VARCHAR2(32767);
505: l_chunk_size NUMBER;
506: BEGIN

Line 712: PROCEDURE add_string(p_varchar2_table IN OUT NOCOPY DBMS_SQL.VARCHAR2A, p_string IN VARCHAR2) IS

708: END;
709:
710:
711: --New API for Bug 4902308
712: PROCEDURE add_string(p_varchar2_table IN OUT NOCOPY DBMS_SQL.VARCHAR2A, p_string IN VARCHAR2) IS
713: l_index number;
714: l_current_length number;
715: l_val varchar2(32767);
716: BEGIN

Line 734: PROCEDURE execute_immediate(p_varchar2_table IN DBMS_SQL.VARCHAR2A) IS

730: raise;
731: END;
732:
733:
734: PROCEDURE execute_immediate(p_varchar2_table IN DBMS_SQL.VARCHAR2A) IS
735: l_dummy dbms_sql.varchar2_table;
736: BEGIN
737: execute_immediate(p_varchar2_table, l_dummy, 0);
738: END;

Line 735: l_dummy dbms_sql.varchar2_table;

731: END;
732:
733:
734: PROCEDURE execute_immediate(p_varchar2_table IN DBMS_SQL.VARCHAR2A) IS
735: l_dummy dbms_sql.varchar2_table;
736: BEGIN
737: execute_immediate(p_varchar2_table, l_dummy, 0);
738: END;
739:

Line 746: PROCEDURE execute_immediate(p_varchar2_table IN DBMS_SQL.VARCHAR2A,

742: --the bind variables sequentially
743: --ie assume is that all parameters are bound as :1, :2, :3 etc
744: --currently this is not the case. this requires change in bsc_update_base_v2
745: ---------------------------------------------------------------
746: PROCEDURE execute_immediate(p_varchar2_table IN DBMS_SQL.VARCHAR2A,
747: p_bind_vars_values dbms_sql.varchar2_table,
748: p_num_bind_vars number) IS
749: e_max_bind_vars_exceeded exception;
750:

Line 747: p_bind_vars_values dbms_sql.varchar2_table,

743: --ie assume is that all parameters are bound as :1, :2, :3 etc
744: --currently this is not the case. this requires change in bsc_update_base_v2
745: ---------------------------------------------------------------
746: PROCEDURE execute_immediate(p_varchar2_table IN DBMS_SQL.VARCHAR2A,
747: p_bind_vars_values dbms_sql.varchar2_table,
748: p_num_bind_vars number) IS
749: e_max_bind_vars_exceeded exception;
750:
751: l_sql dbms_sql.varchar2a;

Line 751: l_sql dbms_sql.varchar2a;

747: p_bind_vars_values dbms_sql.varchar2_table,
748: p_num_bind_vars number) IS
749: e_max_bind_vars_exceeded exception;
750:
751: l_sql dbms_sql.varchar2a;
752:
753: l_cur number;
754: dummy NUMBER;
755: BEGIN

Line 766: l_cur := dbms_sql.open_cursor;

762: for i in p_varchar2_table.count+1..50 loop
763: l_sql(i) := null;
764: end loop;
765: if nvl(p_num_bind_vars,0) = 0 then
766: l_cur := dbms_sql.open_cursor;
767: dbms_sql.parse(
768: c => l_cur,
769: statement => l_sql,
770: lb => l_sql.first,

Line 767: dbms_sql.parse(

763: l_sql(i) := null;
764: end loop;
765: if nvl(p_num_bind_vars,0) = 0 then
766: l_cur := dbms_sql.open_cursor;
767: dbms_sql.parse(
768: c => l_cur,
769: statement => l_sql,
770: lb => l_sql.first,
771: ub => l_sql.last,

Line 773: language_flag => dbms_sql.native );

769: statement => l_sql,
770: lb => l_sql.first,
771: ub => l_sql.last,
772: lfflg => TRUE,
773: language_flag => dbms_sql.native );
774:
775: dummy := dbms_sql.execute(l_cur);
776: dbms_sql.close_cursor(l_cur);
777: fnd_file.put_line(FND_FILE.LOG, 'Chk 4');

Line 775: dummy := dbms_sql.execute(l_cur);

771: ub => l_sql.last,
772: lfflg => TRUE,
773: language_flag => dbms_sql.native );
774:
775: dummy := dbms_sql.execute(l_cur);
776: dbms_sql.close_cursor(l_cur);
777: fnd_file.put_line(FND_FILE.LOG, 'Chk 4');
778: elsif p_num_bind_vars = 1 then
779: execute immediate l_sql(1) ||l_sql(2) ||l_sql(3) ||l_sql(4) ||l_sql(5) ||l_sql(6) ||l_sql(7) ||l_sql(8) ||l_sql(9) ||l_sql(10)||

Line 776: dbms_sql.close_cursor(l_cur);

772: lfflg => TRUE,
773: language_flag => dbms_sql.native );
774:
775: dummy := dbms_sql.execute(l_cur);
776: dbms_sql.close_cursor(l_cur);
777: fnd_file.put_line(FND_FILE.LOG, 'Chk 4');
778: elsif p_num_bind_vars = 1 then
779: execute immediate l_sql(1) ||l_sql(2) ||l_sql(3) ||l_sql(4) ||l_sql(5) ||l_sql(6) ||l_sql(7) ||l_sql(8) ||l_sql(9) ||l_sql(10)||
780: l_sql(11)||l_sql(12)||l_sql(13)||l_sql(14)||l_sql(15)||l_sql(16)||l_sql(17)||l_sql(18)||l_sql(19)||l_sql(20)||