APPS.QP_DEBUG_UTIL dependencies on QP_DEBUG_UTIL

Line 1: PACKAGE BODY QP_DEBUG_UTIL AS

1: PACKAGE BODY QP_DEBUG_UTIL AS
2: /* $Header: QPXDUTLB.pls 120.3.12020000.2 2013/01/31 14:03:24 jputta ship $ */
3:
4: g_PkgStack t_CallStack;
5:

Line 351: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_CURSOR_DATA_CSV_PVT';

347: p_output_file IN utl_file.file_type,
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);

Line 442: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_CURSOR_DATA_CSV_PVT';

438: p_append IN BOOLEAN := FALSE,
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);

Line 614: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_TABLE_DATA_CSV';

610: p_append IN BOOLEAN := FALSE,
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

Line 670: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_QUERY_DATA_CSV';

666: p_append IN BOOLEAN := FALSE,
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:

Line 724: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_CURSOR_DATA_CSV';

720: p_cursor_id IN number,
721: p_file_id IN VARCHAR2
722: )
723: IS
724: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_CURSOR_DATA_CSV';
725:
726: BEGIN
727:
728: G_DEBUG := OE_DEBUG_PUB.G_DEBUG;

Line 763: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_BLANK_ROWS_CSV';

759: p_outputfile_id utl_file.file_type,
760: p_row_count number
761: )
762: IS
763: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_BLANK_ROWS_CSV';
764: BEGIN
765: FOR i IN 1..p_row_count
766: LOOP
767: utl_file.put_line(p_outputfile_id,' ');

Line 800: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_QUERYLIST_DATA_CSV';

796: l_output_file utl_file.file_type;
797: filePath varchar2(1000);
798: fileName varchar2(1000);
799:
800: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_QUERYLIST_DATA_CSV';
801:
802: l_cursor number;
803:
804: BEGIN

Line 888: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.print_development_csv';

884:
885: PROCEDURE print_development_csv AS
886:
887: l_sql_stmt VARCHAR2(10000);
888: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.print_development_csv';
889: BEGIN
890: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
891: IF G_DEBUG_LEVEL = 5 THEN
892: -- Printing table qp_npreq_line_patrns_tmp

Line 898: qp_debug_util.print_query_data_csv (p_query => l_sql_stmt,

894: || REPLACE(G_CURR_PRICE_EVENT,',','-')
895: || ''' PRICING_EVENT, PATTERN_ID, LINE_INDEX, HASH_KEY'
896: || ' FROM qp_npreq_line_patrns_tmp';
897:
898: qp_debug_util.print_query_data_csv (p_query => l_sql_stmt,
899: p_file_id => 'LINE_PATRNS_TMP',
900: p_append => TRUE,
901: p_prefix_event => FALSE
902: );

Line 941: qp_debug_util.print_query_data_csv (p_query => l_sql_stmt,

937: ||' break_uom_attribute , '
938: ||' pricing_status_text '
939: ||'FROM QP_PREQ_PATRN_QUAL_TMP';
940:
941: qp_debug_util.print_query_data_csv (p_query => l_sql_stmt,
942: p_file_id => 'PATRN_QUAL_TMP',
943: p_append => TRUE,
944: p_prefix_event => FALSE);
945:

Line 992: qp_debug_util.print_query_data_csv (p_query => l_sql_stmt,

988: || 'COMPARISON_OPERATOR_TYPE_CODE IN ('''
989: ||QP_PREQ_GRP.G_OPERATOR_BETWEEN ||''','''
990: ||G_OPERATOR_NOT_EQL ||''')) ';*/
991:
992: qp_debug_util.print_query_data_csv (p_query => l_sql_stmt,
993: p_file_id => 'LINE_ATTRS_TMP',
994: p_append => TRUE,
995: p_prefix_event => FALSE
996: );

Line 1024: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.print_support_csv';

1020: l_lines_stmt VARCHAR2(20000);
1021: l_ldets_stmt VARCHAR2(20000);
1022: l_attrs_stmt VARCHAR2(20000);
1023:
1024: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.print_support_csv';
1025:
1026: begin
1027: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
1028: IF G_DEBUG_LEVEL = 5 THEN

Line 1381: END QP_DEBUG_UTIL;

1377:
1378: begin
1379: g_csv_count := 0;
1380:
1381: END QP_DEBUG_UTIL;