APPS.FV_IPAC dependencies on DBMS_SQL

Line 2632: v_cursor_id := DBMS_SQL.OPEN_CURSOR;

2628: l_module_name VARCHAR2(200) ;
2629: BEGIN
2630: l_module_name := g_module_name || 'create_flat_file';
2631: BEGIN
2632: v_cursor_id := DBMS_SQL.OPEN_CURSOR;
2633: EXCEPTION
2634: WHEN OTHERS THEN
2635: errbuf := SQLERRM;
2636: retcode := SQLCODE;

Line 2642: DBMS_SQL.PARSE(v_cursor_id, p_statement, DBMS_SQL.V7);

2638: RAISE ;
2639: RETURN;
2640: END;
2641: BEGIN
2642: DBMS_SQL.PARSE(v_cursor_id, p_statement, DBMS_SQL.V7);
2643: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':b_set_of_books_id',
2644: p_set_of_books_id);
2645: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':b_customer_trx_id',
2646: p_customer_trx_id);

Line 2643: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':b_set_of_books_id',

2639: RETURN;
2640: END;
2641: BEGIN
2642: DBMS_SQL.PARSE(v_cursor_id, p_statement, DBMS_SQL.V7);
2643: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':b_set_of_books_id',
2644: p_set_of_books_id);
2645: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':b_customer_trx_id',
2646: p_customer_trx_id);
2647: EXCEPTION

Line 2645: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':b_customer_trx_id',

2641: BEGIN
2642: DBMS_SQL.PARSE(v_cursor_id, p_statement, DBMS_SQL.V7);
2643: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':b_set_of_books_id',
2644: p_set_of_books_id);
2645: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':b_customer_trx_id',
2646: p_customer_trx_id);
2647: EXCEPTION
2648: WHEN OTHERS THEN
2649: retcode := SQLCODE ;

Line 2655: DBMS_SQL.DEFINE_COLUMN(v_cursor_id, 1, col1, 2000);

2651: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
2652: l_module_name, errbuf) ;
2653: RAISE ;
2654: END ;
2655: DBMS_SQL.DEFINE_COLUMN(v_cursor_id, 1, col1, 2000);
2656: BEGIN
2657: l_fetch_count := DBMS_SQL.EXECUTE(v_cursor_id);
2658: EXCEPTION
2659: WHEN OTHERS THEN

Line 2657: l_fetch_count := DBMS_SQL.EXECUTE(v_cursor_id);

2653: RAISE ;
2654: END ;
2655: DBMS_SQL.DEFINE_COLUMN(v_cursor_id, 1, col1, 2000);
2656: BEGIN
2657: l_fetch_count := DBMS_SQL.EXECUTE(v_cursor_id);
2658: EXCEPTION
2659: WHEN OTHERS THEN
2660: retcode := SQLCODE ;
2661: errbuf := SQLERRM ;

Line 2669: l_fetch_count := DBMS_SQL.FETCH_ROWS(v_cursor_id);

2665: errbuf) ;
2666: RAISE ;
2667: END;
2668: LOOP
2669: l_fetch_count := DBMS_SQL.FETCH_ROWS(v_cursor_id);
2670: IF l_fetch_count = 0 THEN
2671: RETURN;
2672: END IF;
2673: DBMS_SQL.COLUMN_VALUE(v_cursor_id, 1, col1);

Line 2673: DBMS_SQL.COLUMN_VALUE(v_cursor_id, 1, col1);

2669: l_fetch_count := DBMS_SQL.FETCH_ROWS(v_cursor_id);
2670: IF l_fetch_count = 0 THEN
2671: RETURN;
2672: END IF;
2673: DBMS_SQL.COLUMN_VALUE(v_cursor_id, 1, col1);
2674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, col1);
2675: END LOOP;
2676: EXCEPTION
2677: WHEN OTHERS THEN