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_ONEYEAR dependencies on DBMS_SQL

Line 307: -- dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_treasury_symbol_id);

303: INTO g_established_year, g_cancellation_year
304: FROM fv_treasury_symbols
305: WHERE treasury_symbol = parm_treasury_value_r1
306: AND set_of_books_id = parm_set_of_books_id ;
307: -- dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_treasury_symbol_id);
308: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
309: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROCESSING FOR TREASURY SYMBOL .......'|| PARM_TREASURY_VALUE_R1);
310: END IF;
311:

Line 351: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

347: IF g_error_code <> 0 THEN
348: RAISE abort_error;
349: END IF;
350: --
351: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
352: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
353: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- INSERT COUNT('||G_INSERT_COUNT||')');
354: END IF;
355: IF errbuf IS NOT null THEN

Line 529: v_cursor_id := DBMS_SQL.OPEN_CURSOR();

525: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
526: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,V_SELECT);
527: END IF;
528: --
529: v_cursor_id := DBMS_SQL.OPEN_CURSOR();
530: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
531: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T1');
532: END IF;
533:

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

532: END IF;
533:
534: fnd_file.put_line (fnd_file.log, v_select);
535:
536: dbms_sql.parse(v_cursor_id,v_select,dbms_sql.v7);
537:
538: dbms_sql.bind_variable(v_cursor_id,':cv_set_of_books_id',parm_set_of_books_id);
539: -- dbms_sql.bind_variable(v_cursor_id,':cv_chart_of_accounts_id',g_chart_of_accounts_id);
540: dbms_sql.bind_variable(v_cursor_id,':cv_currency_code',g_currency_code);

Line 538: dbms_sql.bind_variable(v_cursor_id,':cv_set_of_books_id',parm_set_of_books_id);

534: fnd_file.put_line (fnd_file.log, v_select);
535:
536: dbms_sql.parse(v_cursor_id,v_select,dbms_sql.v7);
537:
538: dbms_sql.bind_variable(v_cursor_id,':cv_set_of_books_id',parm_set_of_books_id);
539: -- dbms_sql.bind_variable(v_cursor_id,':cv_chart_of_accounts_id',g_chart_of_accounts_id);
540: dbms_sql.bind_variable(v_cursor_id,':cv_currency_code',g_currency_code);
541:
542: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 539: -- dbms_sql.bind_variable(v_cursor_id,':cv_chart_of_accounts_id',g_chart_of_accounts_id);

535:
536: dbms_sql.parse(v_cursor_id,v_select,dbms_sql.v7);
537:
538: dbms_sql.bind_variable(v_cursor_id,':cv_set_of_books_id',parm_set_of_books_id);
539: -- dbms_sql.bind_variable(v_cursor_id,':cv_chart_of_accounts_id',g_chart_of_accounts_id);
540: dbms_sql.bind_variable(v_cursor_id,':cv_currency_code',g_currency_code);
541:
542: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
543: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T2');

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

536: dbms_sql.parse(v_cursor_id,v_select,dbms_sql.v7);
537:
538: dbms_sql.bind_variable(v_cursor_id,':cv_set_of_books_id',parm_set_of_books_id);
539: -- dbms_sql.bind_variable(v_cursor_id,':cv_chart_of_accounts_id',g_chart_of_accounts_id);
540: dbms_sql.bind_variable(v_cursor_id,':cv_currency_code',g_currency_code);
541:
542: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
543: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T2');
544: END IF;

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

541:
542: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
543: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T2');
544: END IF;
545: dbms_sql.define_column(v_cursor_id,1,c_total_balance);
546: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
547: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T3');
548: END IF;
549:

Line 687: -- dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',

683: c_sf133_treasury_symbol_id := ts_report_line_entry.sf133_treasury_symbol_id; --Bug 1575992
684: --
685: -- fv_utility.debug_mesg('c_sf133_line_category = '||
686: -- c_sf133_line_category);
687: -- dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',
688: -- parm_treasury_symbol_id);
689: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
690: -- dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_category',
691: -- c_sf133_line_category);

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

685: -- fv_utility.debug_mesg('c_sf133_line_category = '||
686: -- c_sf133_line_category);
687: -- dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',
688: -- parm_treasury_symbol_id);
689: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
690: -- dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_category',
691: -- c_sf133_line_category);
692: g_column_number := 1;
693: IF g_error_code = 0 THEN

Line 690: -- dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_category',

686: -- c_sf133_line_category);
687: -- dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',
688: -- parm_treasury_symbol_id);
689: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
690: -- dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_category',
691: -- c_sf133_line_category);
692: g_column_number := 1;
693: IF g_error_code = 0 THEN
694: IF c_sf133_line_type_code = 'D' THEN

Line 767: -- dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',

763:
764: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
765: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TREASURY SYMBOL IS '||C_SF133_TS_VALUE );
766: END IF;
767: -- dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',
768: -- g_treasury_symbol_id);
769: -- Derive the Amount Values for the Previous Year
770: build_fiscal_line_columns
771: (L_BEG_PERIOD_PREV, L_END_PERIOD_PREV, L_PROCESS_YEAR) ;

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

936: c_sf133_additional_info := balance_type_rec.sf133_additional_info;
937: -- c_zero_drcr_flag := balance_type_rec.zero_drcr_flag;
938:
939: -- fv_utility.debug_mesg('balance_type = '||c_sf133_balance_type);
940: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
941: -- New code added written by Narsimha Balakkari to solve the Rescission
942: -- problem.
943: c_rescission_flag := 'FALSE';
944: IF upper(c_sf133_additional_info) = 'RESCISSION' THEN

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

984: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
985: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LINE_ACCT_ID = '||C_SF133_LINE_ACCT_ID);
986: END IF;
987: /*Used Dynamice SQL instead of balance_cursor */
988: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','E');
989: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
990: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
991: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
992: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

985: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LINE_ACCT_ID = '||C_SF133_LINE_ACCT_ID);
986: END IF;
987: /*Used Dynamice SQL instead of balance_cursor */
988: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','E');
989: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
990: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
991: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
992: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
993: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);

Line 990: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);

986: END IF;
987: /*Used Dynamice SQL instead of balance_cursor */
988: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','E');
989: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
990: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
991: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
992: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
993: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
994: END IF;

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

987: /*Used Dynamice SQL instead of balance_cursor */
988: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','E');
989: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
990: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
991: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
992: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
993: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
994: END IF;
995: dbms_sql.column_value(v_cursor_id,1,c_total_balance);

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

991: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
992: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
993: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
994: END IF;
995: dbms_sql.column_value(v_cursor_id,1,c_total_balance);
996:
997: ELSIF c_sf133_balance_type = 'B' THEN
998: -- beginning balance type
999: /*Used Dynamice SQL instead of balance_cursor */

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

996:
997: ELSIF c_sf133_balance_type = 'B' THEN
998: -- beginning balance type
999: /*Used Dynamice SQL instead of balance_cursor */
1000: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','B');
1001: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
1002: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1003: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1004: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

997: ELSIF c_sf133_balance_type = 'B' THEN
998: -- beginning balance type
999: /*Used Dynamice SQL instead of balance_cursor */
1000: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','B');
1001: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
1002: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1003: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1004: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1005: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);

Line 1002: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);

998: -- beginning balance type
999: /*Used Dynamice SQL instead of balance_cursor */
1000: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','B');
1001: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
1002: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1003: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1004: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1005: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1006: END IF;

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

999: /*Used Dynamice SQL instead of balance_cursor */
1000: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','B');
1001: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
1002: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1003: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1004: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1005: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1006: END IF;
1007: dbms_sql.column_value(v_cursor_id,1,c_total_balance);

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

1003: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1004: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1005: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1006: END IF;
1007: dbms_sql.column_value(v_cursor_id,1,c_total_balance);
1008:
1009:
1010: ELSIF c_sf133_balance_type = 'P' THEN
1011:

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

1009:
1010: ELSIF c_sf133_balance_type = 'P' THEN
1011:
1012: /*Used Dynamice SQL instead of balance_cursor */
1013: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','P');
1014: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
1015: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1016: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1017: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1010: ELSIF c_sf133_balance_type = 'P' THEN
1011:
1012: /*Used Dynamice SQL instead of balance_cursor */
1013: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','P');
1014: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
1015: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1016: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1017: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1018: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);

Line 1015: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);

1011:
1012: /*Used Dynamice SQL instead of balance_cursor */
1013: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','P');
1014: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
1015: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1016: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1017: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1018: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1019: END IF;

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

1012: /*Used Dynamice SQL instead of balance_cursor */
1013: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','P');
1014: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
1015: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1016: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1017: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1018: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1019: END IF;
1020: dbms_sql.column_value(v_cursor_id,1,c_total_balance);

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

1016: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1017: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1018: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1019: END IF;
1020: dbms_sql.column_value(v_cursor_id,1,c_total_balance);
1021:
1022: ELSIF c_sf133_balance_type = 'N' THEN
1023:
1024: /*Used Dynamice SQL instead of balance_cursor */

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

1021:
1022: ELSIF c_sf133_balance_type = 'N' THEN
1023:
1024: /*Used Dynamice SQL instead of balance_cursor */
1025: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','N');
1026: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
1027: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1028: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1029: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1022: ELSIF c_sf133_balance_type = 'N' THEN
1023:
1024: /*Used Dynamice SQL instead of balance_cursor */
1025: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','N');
1026: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
1027: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1028: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1029: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1030: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);

Line 1027: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);

1023:
1024: /*Used Dynamice SQL instead of balance_cursor */
1025: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','N');
1026: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
1027: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1028: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1029: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1030: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1031: END IF;

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

1024: /*Used Dynamice SQL instead of balance_cursor */
1025: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','N');
1026: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
1027: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1028: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1029: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1030: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1031: END IF;
1032: dbms_sql.column_value(v_cursor_id,1,c_total_balance);

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

1028: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1029: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1030: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1031: END IF;
1032: dbms_sql.column_value(v_cursor_id,1,c_total_balance);
1033:
1034: ELSIF c_sf133_balance_type in ('D','S') THEN
1035: -- ending - beginning balance type = D (Difference)
1036: -- beginning - ending balance type = S (Subsequent)

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

1035: -- ending - beginning balance type = D (Difference)
1036: -- beginning - ending balance type = S (Subsequent)
1037:
1038: /*Used Dynamice SQL instead of balance_cursor */
1039: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','E');
1040: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
1041: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1042: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1043: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1036: -- beginning - ending balance type = S (Subsequent)
1037:
1038: /*Used Dynamice SQL instead of balance_cursor */
1039: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','E');
1040: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
1041: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1042: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1043: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1044: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);

Line 1041: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);

1037:
1038: /*Used Dynamice SQL instead of balance_cursor */
1039: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','E');
1040: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
1041: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1042: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1043: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1044: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1045: END IF;

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

1038: /*Used Dynamice SQL instead of balance_cursor */
1039: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','E');
1040: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
1041: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1042: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1043: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1044: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1045: END IF;
1046: --Fixed bug # 2433012. Modified the following statement(dbms_sql.column_value) with column value c_ending_balance

Line 1046: --Fixed bug # 2433012. Modified the following statement(dbms_sql.column_value) with column value c_ending_balance

1042: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1043: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1044: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1045: END IF;
1046: --Fixed bug # 2433012. Modified the following statement(dbms_sql.column_value) with column value c_ending_balance
1047: --in place of c_total_balance.
1048: dbms_sql.column_value(v_cursor_id,1,c_ending_balance);
1049: /*Used Dynamice SQL instead of balance_cursor */
1050: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','B');

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

1044: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1045: END IF;
1046: --Fixed bug # 2433012. Modified the following statement(dbms_sql.column_value) with column value c_ending_balance
1047: --in place of c_total_balance.
1048: dbms_sql.column_value(v_cursor_id,1,c_ending_balance);
1049: /*Used Dynamice SQL instead of balance_cursor */
1050: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','B');
1051: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
1052: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);

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

1046: --Fixed bug # 2433012. Modified the following statement(dbms_sql.column_value) with column value c_ending_balance
1047: --in place of c_total_balance.
1048: dbms_sql.column_value(v_cursor_id,1,c_ending_balance);
1049: /*Used Dynamice SQL instead of balance_cursor */
1050: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','B');
1051: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
1052: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1053: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1054: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1047: --in place of c_total_balance.
1048: dbms_sql.column_value(v_cursor_id,1,c_ending_balance);
1049: /*Used Dynamice SQL instead of balance_cursor */
1050: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','B');
1051: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
1052: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1053: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1054: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1055: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);

Line 1052: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);

1048: dbms_sql.column_value(v_cursor_id,1,c_ending_balance);
1049: /*Used Dynamice SQL instead of balance_cursor */
1050: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','B');
1051: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
1052: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1053: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1054: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1055: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1056: END IF;

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

1049: /*Used Dynamice SQL instead of balance_cursor */
1050: dbms_sql.bind_variable(v_cursor_id,':cv_balance_type','B');
1051: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
1052: dbms_sql.bind_variable(v_cursor_id,':cv_fiscal_year',c_fiscal_year);
1053: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1054: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1055: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1056: END IF;
1057: --Fixed bug # 2433012. Modified the following statement(dbms_sql.column_value) with column value c_begin_balance

Line 1057: --Fixed bug # 2433012. Modified the following statement(dbms_sql.column_value) with column value c_begin_balance

1053: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1054: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1055: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1056: END IF;
1057: --Fixed bug # 2433012. Modified the following statement(dbms_sql.column_value) with column value c_begin_balance
1058: --in place of c_total_balance.
1059: dbms_sql.column_value(v_cursor_id,1,c_begin_balance);
1060: IF c_sf133_balance_type = 'D' THEN
1061: c_total_balance := c_ending_balance - c_begin_balance;

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

1055: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_IGNORE := '|| L_IGNORE);
1056: END IF;
1057: --Fixed bug # 2433012. Modified the following statement(dbms_sql.column_value) with column value c_begin_balance
1058: --in place of c_total_balance.
1059: dbms_sql.column_value(v_cursor_id,1,c_begin_balance);
1060: IF c_sf133_balance_type = 'D' THEN
1061: c_total_balance := c_ending_balance - c_begin_balance;
1062: ELSIF c_sf133_balance_type = 'S' THEN
1063: c_total_balance := c_begin_balance - c_ending_balance;