APPS.FV_FLATFILES dependencies on DBMS_SQL

Line 555: v_cursor := DBMS_SQL.OPEN_CURSOR;

551: BEGIN
552: l_module_name := g_module_name || 'create_flat_file';
553:
554: BEGIN
555: v_cursor := DBMS_SQL.OPEN_CURSOR;
556: EXCEPTION WHEN OTHERS THEN
557: vp_errbuf := sqlerrm;
558: vp_retcode := sqlcode;
559: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.open_v_cursor',vp_errbuf);

Line 564: DBMS_SQL.PARSE(v_cursor, v_statement, DBMS_SQL.V7);

560: RETURN;
561: END;
562:
563: BEGIN
564: DBMS_SQL.PARSE(v_cursor, v_statement, DBMS_SQL.V7);
565: EXCEPTION WHEN OTHERS THEN
566: vp_retcode := sqlcode ;
567: VP_ERRBUF := sqlerrm ;
568: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.parse_v_cursor',vp_errbuf);

Line 572: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, col1, 2000);

568: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.parse_v_cursor',vp_errbuf);
569: RETURN ;
570: END ;
571:
572: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, col1, 2000);
573:
574: BEGIN
575: l_fetch_count := DBMS_SQL.EXECUTE(v_cursor);
576: EXCEPTION WHEN OTHERS THEN

Line 575: l_fetch_count := DBMS_SQL.EXECUTE(v_cursor);

571:
572: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, col1, 2000);
573:
574: BEGIN
575: l_fetch_count := DBMS_SQL.EXECUTE(v_cursor);
576: EXCEPTION WHEN OTHERS THEN
577: vp_retcode := sqlcode ;
578: VP_ERRBUF := sqlerrm ;
579: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.execute_v_cursor',vp_errbuf);

Line 586: l_fetch_count := DBMS_SQL.FETCH_ROWS(v_cursor);

582:
583: gbl_count := 0;
584:
585: LOOP
586: l_fetch_count := DBMS_SQL.FETCH_ROWS(v_cursor);
587: IF l_fetch_count = 0
588: THEN return;
589: END IF;
590: gbl_count := gbl_count + 1;

Line 591: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, col1);

587: IF l_fetch_count = 0
588: THEN return;
589: END IF;
590: gbl_count := gbl_count + 1;
591: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, col1);
592: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,col1);
593: END LOOP;
594: EXCEPTION
595: WHEN OTHERS THEN