APPS.AP_WEB_ACCTG_PKG dependencies on DBMS_SQL

Line 627: c := dbms_sql.open_cursor;

623:
624: -----------------
625: -- Now execute it
626: -----------------
627: c := dbms_sql.open_cursor;
628: -----------------------------------------------------
629: l_debug_info := 'parse cursor';
630: -----------------------------------------------------
631: dbms_sql.parse(c, sqlstmt, dbms_sql.native);

Line 631: dbms_sql.parse(c, sqlstmt, dbms_sql.native);

627: c := dbms_sql.open_cursor;
628: -----------------------------------------------------
629: l_debug_info := 'parse cursor';
630: -----------------------------------------------------
631: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
632:
633: -----------------------------------------------------
634: l_debug_info := 'bind values to the placeholder';
635: -----------------------------------------------------

Line 636: dbms_sql.bind_variable(c, ':report_distribution_id', p_report_distribution_id);

632:
633: -----------------------------------------------------
634: l_debug_info := 'bind values to the placeholder';
635: -----------------------------------------------------
636: dbms_sql.bind_variable(c, ':report_distribution_id', p_report_distribution_id);
637:
638: -----------------------------------------------------
639: l_debug_info := 'setup output';
640: -----------------------------------------------------

Line 641: dbms_sql.define_column(c, 1, l_concat_segments, 1000);

637:
638: -----------------------------------------------------
639: l_debug_info := 'setup output';
640: -----------------------------------------------------
641: dbms_sql.define_column(c, 1, l_concat_segments, 1000);
642:
643: -----------------------------------------------------
644: l_debug_info := 'execute cursor';
645: -----------------------------------------------------

Line 646: rows := dbms_sql.execute(c);

642:
643: -----------------------------------------------------
644: l_debug_info := 'execute cursor';
645: -----------------------------------------------------
646: rows := dbms_sql.execute(c);
647:
648: -----------------------------------------------------
649: l_debug_info := 'fetch a row';
650: -----------------------------------------------------

Line 651: IF dbms_sql.fetch_rows(c) > 0 then

647:
648: -----------------------------------------------------
649: l_debug_info := 'fetch a row';
650: -----------------------------------------------------
651: IF dbms_sql.fetch_rows(c) > 0 then
652: -- fetch columns from the row
653: dbms_sql.column_value(c, 1, l_concat_segments);
654: END IF;
655:

Line 653: dbms_sql.column_value(c, 1, l_concat_segments);

649: l_debug_info := 'fetch a row';
650: -----------------------------------------------------
651: IF dbms_sql.fetch_rows(c) > 0 then
652: -- fetch columns from the row
653: dbms_sql.column_value(c, 1, l_concat_segments);
654: END IF;
655:
656: dbms_sql.column_value(c, 1, l_concat_segments);
657:

Line 656: dbms_sql.column_value(c, 1, l_concat_segments);

652: -- fetch columns from the row
653: dbms_sql.column_value(c, 1, l_concat_segments);
654: END IF;
655:
656: dbms_sql.column_value(c, 1, l_concat_segments);
657:
658: dbms_sql.close_cursor(c);
659:
660:

Line 658: dbms_sql.close_cursor(c);

654: END IF;
655:
656: dbms_sql.column_value(c, 1, l_concat_segments);
657:
658: dbms_sql.close_cursor(c);
659:
660:
661: IF cflex%isopen THEN
662: CLOSE cflex;

Line 688: IF dbms_sql.is_open(c) THEN

684: WHEN OTHERS THEN
685: IF cflex%isopen THEN
686: close cflex;
687: END IF;
688: IF dbms_sql.is_open(c) THEN
689: dbms_sql.close_cursor(c);
690: END IF;
691:
692: IF (SQLCODE <> -20001) THEN

Line 689: dbms_sql.close_cursor(c);

685: IF cflex%isopen THEN
686: close cflex;
687: END IF;
688: IF dbms_sql.is_open(c) THEN
689: dbms_sql.close_cursor(c);
690: END IF;
691:
692: IF (SQLCODE <> -20001) THEN
693: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');