APPS.FV_FLATFILES dependencies on DBMS_SQL

Line 668: v_cursor := DBMS_SQL.OPEN_CURSOR;

664: BEGIN
665: l_module_name := g_module_name || 'create_flat_file';
666:
667: BEGIN
668: v_cursor := DBMS_SQL.OPEN_CURSOR;
669: EXCEPTION WHEN OTHERS THEN
670: vp_errbuf := sqlerrm;
671: vp_retcode := sqlcode;
672: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.open_v_cursor',vp_errbuf);

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

673: RETURN;
674: END;
675:
676: BEGIN
677: DBMS_SQL.PARSE(v_cursor, v_statement, DBMS_SQL.V7);
678: EXCEPTION WHEN OTHERS THEN
679: vp_retcode := sqlcode ;
680: VP_ERRBUF := sqlerrm ;
681: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.parse_v_cursor',vp_errbuf);

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

681: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.parse_v_cursor',vp_errbuf);
682: RETURN ;
683: END ;
684:
685: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, col1, 2000);
686:
687: BEGIN
688: l_fetch_count := DBMS_SQL.EXECUTE(v_cursor);
689: EXCEPTION WHEN OTHERS THEN

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

684:
685: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, col1, 2000);
686:
687: BEGIN
688: l_fetch_count := DBMS_SQL.EXECUTE(v_cursor);
689: EXCEPTION WHEN OTHERS THEN
690: vp_retcode := sqlcode ;
691: VP_ERRBUF := sqlerrm ;
692: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.execute_v_cursor',vp_errbuf);

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

695:
696: gbl_count := 0;
697:
698: LOOP
699: l_fetch_count := DBMS_SQL.FETCH_ROWS(v_cursor);
700: IF l_fetch_count = 0
701: THEN return;
702: END IF;
703: gbl_count := gbl_count + 1;

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

700: IF l_fetch_count = 0
701: THEN return;
702: END IF;
703: gbl_count := gbl_count + 1;
704: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, col1);
705: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,col1);
706: END LOOP;
707: EXCEPTION
708: WHEN OTHERS THEN