APPS.FV_IPAC dependencies on DBMS_SQL

Line 2703: v_cursor_id := DBMS_SQL.OPEN_CURSOR;

2699: l_module_name VARCHAR2(200) ;
2700: BEGIN
2701: l_module_name := g_module_name || 'create_flat_file';
2702: BEGIN
2703: v_cursor_id := DBMS_SQL.OPEN_CURSOR;
2704: EXCEPTION
2705: WHEN OTHERS THEN
2706: errbuf := SQLERRM;
2707: retcode := SQLCODE;

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

2709: RAISE ;
2710: RETURN;
2711: END;
2712: BEGIN
2713: DBMS_SQL.PARSE(v_cursor_id, p_statement, DBMS_SQL.V7);
2714: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':b_set_of_books_id',
2715: p_set_of_books_id);
2716: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':b_customer_trx_id',
2717: p_customer_trx_id);

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

2710: RETURN;
2711: END;
2712: BEGIN
2713: DBMS_SQL.PARSE(v_cursor_id, p_statement, DBMS_SQL.V7);
2714: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':b_set_of_books_id',
2715: p_set_of_books_id);
2716: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':b_customer_trx_id',
2717: p_customer_trx_id);
2718: EXCEPTION

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

2712: BEGIN
2713: DBMS_SQL.PARSE(v_cursor_id, p_statement, DBMS_SQL.V7);
2714: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':b_set_of_books_id',
2715: p_set_of_books_id);
2716: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':b_customer_trx_id',
2717: p_customer_trx_id);
2718: EXCEPTION
2719: WHEN OTHERS THEN
2720: retcode := SQLCODE ;

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

2722: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
2723: l_module_name, errbuf) ;
2724: RAISE ;
2725: END ;
2726: DBMS_SQL.DEFINE_COLUMN(v_cursor_id, 1, col1, 2000);
2727: BEGIN
2728: l_fetch_count := DBMS_SQL.EXECUTE(v_cursor_id);
2729: EXCEPTION
2730: WHEN OTHERS THEN

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

2724: RAISE ;
2725: END ;
2726: DBMS_SQL.DEFINE_COLUMN(v_cursor_id, 1, col1, 2000);
2727: BEGIN
2728: l_fetch_count := DBMS_SQL.EXECUTE(v_cursor_id);
2729: EXCEPTION
2730: WHEN OTHERS THEN
2731: retcode := SQLCODE ;
2732: errbuf := SQLERRM ;

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

2736: errbuf) ;
2737: RAISE ;
2738: END;
2739: LOOP
2740: l_fetch_count := DBMS_SQL.FETCH_ROWS(v_cursor_id);
2741: IF l_fetch_count = 0 THEN
2742: RETURN;
2743: END IF;
2744: DBMS_SQL.COLUMN_VALUE(v_cursor_id, 1, col1);

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

2740: l_fetch_count := DBMS_SQL.FETCH_ROWS(v_cursor_id);
2741: IF l_fetch_count = 0 THEN
2742: RETURN;
2743: END IF;
2744: DBMS_SQL.COLUMN_VALUE(v_cursor_id, 1, col1);
2745: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, col1);
2746: END LOOP;
2747: EXCEPTION
2748: WHEN OTHERS THEN