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

Line 352: l_cols_desc dbms_sql.desc_tab;

348: p_cursor in INTEGER
349: )
350: IS
351: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_CURSOR_DATA_CSV_PVT';
352: l_cols_desc dbms_sql.desc_tab;
353: l_col_cnt number;
354: l_status number;
355: l_col_val varchar2(32767);
356: l_hdr_string VARCHAR2(32767);

Line 368: dbms_sql.describe_columns( p_cursor, l_col_cnt, l_cols_desc);

364:
365: l_output_file := p_output_file;
366:
367: --getting column details in l_cols_desc
368: dbms_sql.describe_columns( p_cursor, l_col_cnt, l_cols_desc);
369:
370: --defining holding variables for columns
371: l_hdr_string := '';
372:

Line 375: dbms_sql.define_column( p_cursor, i, l_col_val, 32765);

371: l_hdr_string := '';
372:
373: for i in 1 .. l_cols_desc.count LOOP
374:
375: dbms_sql.define_column( p_cursor, i, l_col_val, 32765);
376:
377: l_hdr_string := l_hdr_string || l_cols_desc(i).col_name;
378:
379: IF i <> l_cols_desc.COUNT THEN

Line 389: l_status := dbms_sql.execute(p_cursor);

385: utl_file.put_line(l_output_file,l_hdr_string);
386:
387: --printing rows
388:
389: l_status := dbms_sql.execute(p_cursor);
390:
391: LOOP
392:
393: EXIT WHEN (dbms_sql.fetch_rows(p_cursor) <= 0);

Line 393: EXIT WHEN (dbms_sql.fetch_rows(p_cursor) <= 0);

389: l_status := dbms_sql.execute(p_cursor);
390:
391: LOOP
392:
393: EXIT WHEN (dbms_sql.fetch_rows(p_cursor) <= 0);
394:
395: l_row_string := '';
396:
397: for i in 1 .. l_cols_desc.count LOOP

Line 399: dbms_sql.column_value(p_cursor, i, l_col_val );

395: l_row_string := '';
396:
397: for i in 1 .. l_cols_desc.count LOOP
398:
399: dbms_sql.column_value(p_cursor, i, l_col_val );
400:
401: l_row_string := l_row_string || l_col_val;
402:
403: IF i <> l_cols_desc.COUNT THEN

Line 443: l_cols_desc dbms_sql.desc_tab;

439: p_prefix_event IN BOOLEAN := TRUE
440: )
441: IS
442: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_CURSOR_DATA_CSV_PVT';
443: l_cols_desc dbms_sql.desc_tab;
444: l_col_cnt number;
445: l_status number;
446: l_col_val varchar2(32767);
447: l_hdr_string VARCHAR2(32767);

Line 521: dbms_sql.describe_columns( p_cursor, l_col_cnt, l_cols_desc);

517:
518:
519:
520: --getting column details in l_cols_desc
521: dbms_sql.describe_columns( p_cursor, l_col_cnt, l_cols_desc);
522:
523: --defining holding variables for columns
524:
525: IF G_CURR_PRICE_EVENT IS NOT NULL

Line 534: dbms_sql.define_column( p_cursor, i, l_col_val, 32765);

530: END IF;
531:
532: for i in 1 .. l_cols_desc.count LOOP
533:
534: dbms_sql.define_column( p_cursor, i, l_col_val, 32765);
535:
536: l_hdr_string := l_hdr_string || l_cols_desc(i).col_name;
537:
538: IF i <> l_cols_desc.COUNT THEN

Line 551: l_status := dbms_sql.execute(p_cursor);

547:
548: --printing rows
549:
550:
551: l_status := dbms_sql.execute(p_cursor);
552:
553: LOOP
554:
555: EXIT WHEN (dbms_sql.fetch_rows(p_cursor) <= 0);

Line 555: EXIT WHEN (dbms_sql.fetch_rows(p_cursor) <= 0);

551: l_status := dbms_sql.execute(p_cursor);
552:
553: LOOP
554:
555: EXIT WHEN (dbms_sql.fetch_rows(p_cursor) <= 0);
556:
557: IF G_CURR_PRICE_EVENT IS NOT NULL
558: AND p_prefix_event THEN
559: l_row_string := l_init_row_string;

Line 566: dbms_sql.column_value(p_cursor, i, l_col_val );

562: END IF;
563:
564: for i in 1 .. l_cols_desc.count LOOP
565:
566: dbms_sql.column_value(p_cursor, i, l_col_val );
567:
568: l_row_string := l_row_string || l_col_val;
569:
570: IF i <> l_cols_desc.COUNT THEN

Line 615: l_cursor number := dbms_sql.open_cursor;

611: p_prefix_event IN BOOLEAN := TRUE
612: )
613: IS
614: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_TABLE_DATA_CSV';
615: l_cursor number := dbms_sql.open_cursor;
616: l_query VARCHAR2(15000) := '';
617:
618: BEGIN
619:

Line 636: dbms_sql.parse( l_cursor,

632: qp_preq_grp.engine_debug(' p_file_id - ' || p_file_id);
633: qp_preq_grp.engine_debug(' l_query - ' || l_query);
634:
635:
636: dbms_sql.parse( l_cursor,
637: l_query
638: ,dbms_sql.native );
639:
640: print_cursor_data_csv_pvt(

Line 638: ,dbms_sql.native );

634:
635:
636: dbms_sql.parse( l_cursor,
637: l_query
638: ,dbms_sql.native );
639:
640: print_cursor_data_csv_pvt(
641: p_file_id => p_file_id ,
642: p_cursor => l_cursor,

Line 647: dbms_sql.close_cursor( l_cursor );

643: p_append => p_append,
644: p_prefix_event => p_prefix_event);
645:
646: end if;
647: dbms_sql.close_cursor( l_cursor );
648:
649: EXCEPTION
650:
651: WHEN OTHERS THEN

Line 653: IF DBMS_SQL.IS_OPEN (l_cursor) THEN

649: EXCEPTION
650:
651: WHEN OTHERS THEN
652:
653: IF DBMS_SQL.IS_OPEN (l_cursor) THEN
654: dbms_sql.close_cursor( l_cursor );
655: END IF;
656:
657: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

Line 654: dbms_sql.close_cursor( l_cursor );

650:
651: WHEN OTHERS THEN
652:
653: IF DBMS_SQL.IS_OPEN (l_cursor) THEN
654: dbms_sql.close_cursor( l_cursor );
655: END IF;
656:
657: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
658: qp_preq_grp.engine_debug('Exception occured - '||l_routine);

Line 671: l_cursor number := dbms_sql.open_cursor;

667: p_prefix_event IN BOOLEAN := TRUE
668: )
669: IS
670: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_QUERY_DATA_CSV';
671: l_cursor number := dbms_sql.open_cursor;
672:
673: BEGIN
674:
675: G_DEBUG := OE_DEBUG_PUB.G_DEBUG;

Line 680: dbms_sql.parse( l_cursor,

676: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
677:
678: IF G_DEBUG = FND_API.G_TRUE AND G_DEBUG_LEVEL = 5 THEN
679:
680: dbms_sql.parse( l_cursor,
681: p_query,
682: dbms_sql.native );
683:
684: print_cursor_data_csv_pvt(

Line 682: dbms_sql.native );

678: IF G_DEBUG = FND_API.G_TRUE AND G_DEBUG_LEVEL = 5 THEN
679:
680: dbms_sql.parse( l_cursor,
681: p_query,
682: dbms_sql.native );
683:
684: print_cursor_data_csv_pvt(
685: p_file_id => p_file_id ,
686: p_cursor => l_cursor,

Line 692: dbms_sql.close_cursor( l_cursor );

688: p_prefix_event => p_prefix_event);
689:
690: END IF;
691:
692: dbms_sql.close_cursor( l_cursor );
693:
694:
695: EXCEPTION
696: WHEN OTHERS THEN

Line 698: IF DBMS_SQL.IS_OPEN (l_cursor) THEN

694:
695: EXCEPTION
696: WHEN OTHERS THEN
697:
698: IF DBMS_SQL.IS_OPEN (l_cursor) THEN
699: dbms_sql.close_cursor( l_cursor );
700: END IF;
701:
702: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

Line 699: dbms_sql.close_cursor( l_cursor );

695: EXCEPTION
696: WHEN OTHERS THEN
697:
698: IF DBMS_SQL.IS_OPEN (l_cursor) THEN
699: dbms_sql.close_cursor( l_cursor );
700: END IF;
701:
702: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
703: qp_preq_grp.engine_debug('Exception occured - '||l_routine);

Line 832: l_cursor := dbms_sql.open_cursor;

828:
829: FOR i IN p_query_list.first..p_query_list.last
830: LOOP
831:
832: l_cursor := dbms_sql.open_cursor;
833:
834: dbms_sql.parse( l_cursor,
835: p_query_list(i),
836: dbms_sql.native );

Line 834: dbms_sql.parse( l_cursor,

830: LOOP
831:
832: l_cursor := dbms_sql.open_cursor;
833:
834: dbms_sql.parse( l_cursor,
835: p_query_list(i),
836: dbms_sql.native );
837:
838: print_cursor_data_csv_pvt(

Line 836: dbms_sql.native );

832: l_cursor := dbms_sql.open_cursor;
833:
834: dbms_sql.parse( l_cursor,
835: p_query_list(i),
836: dbms_sql.native );
837:
838: print_cursor_data_csv_pvt(
839: p_output_file => l_output_file ,
840: p_cursor => l_cursor);

Line 844: dbms_sql.close_cursor( l_cursor );

840: p_cursor => l_cursor);
841:
842: print_blank_rows_csv(l_output_file,5);
843:
844: dbms_sql.close_cursor( l_cursor );
845:
846: END LOOP;
847:
848: utl_file.fclose( l_output_file );

Line 859: IF DBMS_SQL.IS_OPEN (l_cursor) THEN

855: IF utl_file.is_open(l_output_file) THEN
856: utl_file.fclose( l_output_file );
857: END IF;
858:
859: IF DBMS_SQL.IS_OPEN (l_cursor) THEN
860: dbms_sql.close_cursor( l_cursor );
861: END IF;
862:
863: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

Line 860: dbms_sql.close_cursor( l_cursor );

856: utl_file.fclose( l_output_file );
857: END IF;
858:
859: IF DBMS_SQL.IS_OPEN (l_cursor) THEN
860: dbms_sql.close_cursor( l_cursor );
861: END IF;
862:
863: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
864: qp_preq_grp.engine_debug('Exception occured - '||l_routine);