eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_SF133_NOYEAR dependencies on DBMS_SQL

Line 266: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);

262: parm_tsymbol_id := ts_rec.treasury_symbol_id;
263: populate_gtt_with_ccid(parm_tsymbol_id);
264: --determine_acct_flex_segments;
265:
266: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
267: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
268: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESSING TREASURY SYMBOL... '||PARM_TREASURY_VALUE_R1) ;
269: END IF;
270: build_report_lines;

Line 316: dbms_sql.close_cursor(v_cursor_id);

312: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
313: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,ERRBUF);
314: END IF;
315:
316: dbms_sql.close_cursor(v_cursor_id);
317: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
318: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- INSERT COUNT('||G_INSERT_COUNT||')');
319: END IF;
320: retcode := g_error_code;

Line 496: v_cursor_id := dbms_sql.open_cursor;

492: --
493: END LOOP;
494: */
495:
496: v_cursor_id := dbms_sql.open_cursor;
497: dbms_sql.parse(v_cursor_id, v_select, dbms_sql.v7);
498: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
499:
500: dbms_sql.bind_variable(v_cursor_id, ':cv_sob_id', parm_set_of_books_id);

Line 497: dbms_sql.parse(v_cursor_id, v_select, dbms_sql.v7);

493: END LOOP;
494: */
495:
496: v_cursor_id := dbms_sql.open_cursor;
497: dbms_sql.parse(v_cursor_id, v_select, dbms_sql.v7);
498: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
499:
500: dbms_sql.bind_variable(v_cursor_id, ':cv_sob_id', parm_set_of_books_id);
501: dbms_sql.bind_variable(v_cursor_id, ':cv_period_year', parm_gl_period_year);

Line 498: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);

494: */
495:
496: v_cursor_id := dbms_sql.open_cursor;
497: dbms_sql.parse(v_cursor_id, v_select, dbms_sql.v7);
498: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
499:
500: dbms_sql.bind_variable(v_cursor_id, ':cv_sob_id', parm_set_of_books_id);
501: dbms_sql.bind_variable(v_cursor_id, ':cv_period_year', parm_gl_period_year);
502: dbms_sql.bind_variable(v_cursor_id, ':cv_currency_code', g_currency_code);

Line 500: dbms_sql.bind_variable(v_cursor_id, ':cv_sob_id', parm_set_of_books_id);

496: v_cursor_id := dbms_sql.open_cursor;
497: dbms_sql.parse(v_cursor_id, v_select, dbms_sql.v7);
498: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
499:
500: dbms_sql.bind_variable(v_cursor_id, ':cv_sob_id', parm_set_of_books_id);
501: dbms_sql.bind_variable(v_cursor_id, ':cv_period_year', parm_gl_period_year);
502: dbms_sql.bind_variable(v_cursor_id, ':cv_currency_code', g_currency_code);
503: dbms_sql.bind_variable(v_cursor_id, ':cv_coa_id', g_chart_of_accounts_id);
504:

Line 501: dbms_sql.bind_variable(v_cursor_id, ':cv_period_year', parm_gl_period_year);

497: dbms_sql.parse(v_cursor_id, v_select, dbms_sql.v7);
498: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
499:
500: dbms_sql.bind_variable(v_cursor_id, ':cv_sob_id', parm_set_of_books_id);
501: dbms_sql.bind_variable(v_cursor_id, ':cv_period_year', parm_gl_period_year);
502: dbms_sql.bind_variable(v_cursor_id, ':cv_currency_code', g_currency_code);
503: dbms_sql.bind_variable(v_cursor_id, ':cv_coa_id', g_chart_of_accounts_id);
504:
505: --

Line 502: dbms_sql.bind_variable(v_cursor_id, ':cv_currency_code', g_currency_code);

498: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
499:
500: dbms_sql.bind_variable(v_cursor_id, ':cv_sob_id', parm_set_of_books_id);
501: dbms_sql.bind_variable(v_cursor_id, ':cv_period_year', parm_gl_period_year);
502: dbms_sql.bind_variable(v_cursor_id, ':cv_currency_code', g_currency_code);
503: dbms_sql.bind_variable(v_cursor_id, ':cv_coa_id', g_chart_of_accounts_id);
504:
505: --
506:

Line 503: dbms_sql.bind_variable(v_cursor_id, ':cv_coa_id', g_chart_of_accounts_id);

499:
500: dbms_sql.bind_variable(v_cursor_id, ':cv_sob_id', parm_set_of_books_id);
501: dbms_sql.bind_variable(v_cursor_id, ':cv_period_year', parm_gl_period_year);
502: dbms_sql.bind_variable(v_cursor_id, ':cv_currency_code', g_currency_code);
503: dbms_sql.bind_variable(v_cursor_id, ':cv_coa_id', g_chart_of_accounts_id);
504:
505: --
506:
507: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 624: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);

620: c_sf133_line_category := ts_report_line_entry.sf133_line_category;
621: c_sf133_report_line_number := ts_report_line_entry.sf133_report_line_number;
622: c_sf133_treasury_symbol_id := ts_report_line_entry.sf133_treasury_symbol_id; --added for 1575992
623:
624: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
625: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_category',c_sf133_line_category);
626: --
627: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
628: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_SF133_LINE_CATEGORY = '||C_SF133_LINE_CATEGORY);

Line 625: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_category',c_sf133_line_category);

621: c_sf133_report_line_number := ts_report_line_entry.sf133_report_line_number;
622: c_sf133_treasury_symbol_id := ts_report_line_entry.sf133_treasury_symbol_id; --added for 1575992
623:
624: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
625: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_category',c_sf133_line_category);
626: --
627: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
628: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_SF133_LINE_CATEGORY = '||C_SF133_LINE_CATEGORY);
629: END IF;

Line 717: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);

713: c_sf133_line_acct_id := balance_type_rec.sf133_line_acct_id;
714: c_sf133_balance_type := balance_type_rec.sf133_balance_type;
715: c_sf133_additional_info := balance_type_rec.sf133_additional_info;
716:
717: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
718:
719: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
720: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALANCE_TYPE = '||C_SF133_BALANCE_TYPE);
721: END IF;

Line 756: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','E');

752: END IF;
753: IF c_rescission_flag = 'TRUE' THEN
754: IF c_sf133_balance_type = 'E' THEN
755: -- ending balance type
756: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','E');
757: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
758: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
759: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
760: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);

Line 757: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);

753: IF c_rescission_flag = 'TRUE' THEN
754: IF c_sf133_balance_type = 'E' THEN
755: -- ending balance type
756: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','E');
757: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
758: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
759: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
760: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
761: END IF;

Line 758: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

754: IF c_sf133_balance_type = 'E' THEN
755: -- ending balance type
756: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','E');
757: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
758: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
759: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
760: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
761: END IF;
762: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

Line 762: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

758: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
759: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
760: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
761: END IF;
762: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
763: ELSIF c_sf133_balance_type = 'B' THEN
764: -- beginning balance type
765: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','B');
766: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);

Line 765: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','B');

761: END IF;
762: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
763: ELSIF c_sf133_balance_type = 'B' THEN
764: -- beginning balance type
765: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','B');
766: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
767: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
768: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
769: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);

Line 766: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);

762: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
763: ELSIF c_sf133_balance_type = 'B' THEN
764: -- beginning balance type
765: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','B');
766: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
767: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
768: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
769: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
770: END IF;

Line 767: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

763: ELSIF c_sf133_balance_type = 'B' THEN
764: -- beginning balance type
765: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','B');
766: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
767: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
768: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
769: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
770: END IF;
771: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

Line 771: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

767: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
768: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
769: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
770: END IF;
771: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
772: ELSIF c_sf133_balance_type = 'P' THEN
773: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','P');
774: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
775: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

Line 773: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','P');

769: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
770: END IF;
771: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
772: ELSIF c_sf133_balance_type = 'P' THEN
773: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','P');
774: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
775: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
776: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
777: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);

Line 774: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);

770: END IF;
771: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
772: ELSIF c_sf133_balance_type = 'P' THEN
773: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','P');
774: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
775: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
776: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
777: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
778: END IF;

Line 775: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

771: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
772: ELSIF c_sf133_balance_type = 'P' THEN
773: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','P');
774: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
775: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
776: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
777: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
778: END IF;
779: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

Line 779: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

775: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
776: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
777: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
778: END IF;
779: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
780: ELSIF c_sf133_balance_type = 'N' THEN
781: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','N');
782: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
783: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

Line 781: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','N');

777: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
778: END IF;
779: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
780: ELSIF c_sf133_balance_type = 'N' THEN
781: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','N');
782: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
783: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
784: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'l_ignore := '||l_ignore);

Line 782: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);

778: END IF;
779: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
780: ELSIF c_sf133_balance_type = 'N' THEN
781: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','N');
782: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
783: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
784: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'l_ignore := '||l_ignore);
786: END IF;

Line 783: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

779: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
780: ELSIF c_sf133_balance_type = 'N' THEN
781: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','N');
782: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
783: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
784: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'l_ignore := '||l_ignore);
786: END IF;
787: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

Line 787: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

783: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
784: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'l_ignore := '||l_ignore);
786: END IF;
787: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
788: ELSIF c_sf133_balance_type in ('D','S') THEN
789: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','E');
790: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
791: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

Line 789: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','E');

785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'l_ignore := '||l_ignore);
786: END IF;
787: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
788: ELSIF c_sf133_balance_type in ('D','S') THEN
789: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','E');
790: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
791: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
792: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);

Line 790: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);

786: END IF;
787: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
788: ELSIF c_sf133_balance_type in ('D','S') THEN
789: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','E');
790: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
791: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
792: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
794: END IF;

Line 791: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

787: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
788: ELSIF c_sf133_balance_type in ('D','S') THEN
789: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','E');
790: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
791: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
792: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
794: END IF;
795: dbms_sql.column_value(v_cursor_id, 1, c_ending_balance);

Line 795: dbms_sql.column_value(v_cursor_id, 1, c_ending_balance);

791: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
792: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
794: END IF;
795: dbms_sql.column_value(v_cursor_id, 1, c_ending_balance);
796: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','B');
797: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
798: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
799: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 796: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','B');

792: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
794: END IF;
795: dbms_sql.column_value(v_cursor_id, 1, c_ending_balance);
796: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','B');
797: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
798: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
799: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
800: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);

Line 797: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);

793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
794: END IF;
795: dbms_sql.column_value(v_cursor_id, 1, c_ending_balance);
796: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','B');
797: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
798: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
799: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
800: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
801: END IF;

Line 798: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

794: END IF;
795: dbms_sql.column_value(v_cursor_id, 1, c_ending_balance);
796: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','B');
797: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
798: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
799: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
800: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
801: END IF;
802: dbms_sql.column_value(v_cursor_id, 1, c_begin_balance);

Line 802: dbms_sql.column_value(v_cursor_id, 1, c_begin_balance);

798: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
799: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
800: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
801: END IF;
802: dbms_sql.column_value(v_cursor_id, 1, c_begin_balance);
803:
804: IF c_sf133_balance_type = 'D' THEN
805: c_total_balance := c_ending_balance - c_begin_balance;
806: ELSIF c_sf133_balance_type = 'S' THEN

Line 822: --dbms_sql.close_cursor(v_cursor_id);

818: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT NOT SHOWN = '||C_SF133_AMOUNT_NOT_SHOWN);
819: END IF;
820:
821: END LOOP;
822: --dbms_sql.close_cursor(v_cursor_id);
823: --
824: -- set up correct display sign
825: --
826: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 875: ELSIF dbms_sql.is_open(v_cursor_id) THEN

871: g_error_message := SQLERRM;
872:
873: IF balance_type_cursor%ISOPEN THEN
874: close balance_type_cursor;
875: ELSIF dbms_sql.is_open(v_cursor_id) THEN
876: dbms_sql.close_cursor(v_cursor_id);
877: END IF;
878:
879: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_FISCAL_LINE_COLUMNS:'||G_ERROR_MESSAGE);

Line 876: dbms_sql.close_cursor(v_cursor_id);

872:
873: IF balance_type_cursor%ISOPEN THEN
874: close balance_type_cursor;
875: ELSIF dbms_sql.is_open(v_cursor_id) THEN
876: dbms_sql.close_cursor(v_cursor_id);
877: END IF;
878:
879: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_FISCAL_LINE_COLUMNS:'||G_ERROR_MESSAGE);
880: --