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 611: v_cursor_id := dbms_sql.open_cursor;

607: --
608: END LOOP;
609: */
610:
611: v_cursor_id := dbms_sql.open_cursor;
612: dbms_sql.parse(v_cursor_id, v_select, dbms_sql.v7);
613: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
614:
615: /*dbms_sql.bind_variable(v_cursor_id, ':cv_sob_id', parm_set_of_books_id);

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

608: END LOOP;
609: */
610:
611: v_cursor_id := dbms_sql.open_cursor;
612: dbms_sql.parse(v_cursor_id, v_select, dbms_sql.v7);
613: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
614:
615: /*dbms_sql.bind_variable(v_cursor_id, ':cv_sob_id', parm_set_of_books_id);
616: dbms_sql.bind_variable(v_cursor_id, ':cv_period_year', parm_gl_period_year);

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

609: */
610:
611: v_cursor_id := dbms_sql.open_cursor;
612: dbms_sql.parse(v_cursor_id, v_select, dbms_sql.v7);
613: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
614:
615: /*dbms_sql.bind_variable(v_cursor_id, ':cv_sob_id', parm_set_of_books_id);
616: dbms_sql.bind_variable(v_cursor_id, ':cv_period_year', parm_gl_period_year);
617: dbms_sql.bind_variable(v_cursor_id, ':cv_currency_code', g_currency_code);

Line 615: /*dbms_sql.bind_variable(v_cursor_id, ':cv_sob_id', parm_set_of_books_id);

611: v_cursor_id := dbms_sql.open_cursor;
612: dbms_sql.parse(v_cursor_id, v_select, dbms_sql.v7);
613: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
614:
615: /*dbms_sql.bind_variable(v_cursor_id, ':cv_sob_id', parm_set_of_books_id);
616: dbms_sql.bind_variable(v_cursor_id, ':cv_period_year', parm_gl_period_year);
617: dbms_sql.bind_variable(v_cursor_id, ':cv_currency_code', g_currency_code);
618: dbms_sql.bind_variable(v_cursor_id, ':cv_coa_id', g_chart_of_accounts_id);*/
619:

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

612: dbms_sql.parse(v_cursor_id, v_select, dbms_sql.v7);
613: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
614:
615: /*dbms_sql.bind_variable(v_cursor_id, ':cv_sob_id', parm_set_of_books_id);
616: dbms_sql.bind_variable(v_cursor_id, ':cv_period_year', parm_gl_period_year);
617: dbms_sql.bind_variable(v_cursor_id, ':cv_currency_code', g_currency_code);
618: dbms_sql.bind_variable(v_cursor_id, ':cv_coa_id', g_chart_of_accounts_id);*/
619:
620: --

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

613: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
614:
615: /*dbms_sql.bind_variable(v_cursor_id, ':cv_sob_id', parm_set_of_books_id);
616: dbms_sql.bind_variable(v_cursor_id, ':cv_period_year', parm_gl_period_year);
617: dbms_sql.bind_variable(v_cursor_id, ':cv_currency_code', g_currency_code);
618: dbms_sql.bind_variable(v_cursor_id, ':cv_coa_id', g_chart_of_accounts_id);*/
619:
620: --
621:

Line 618: dbms_sql.bind_variable(v_cursor_id, ':cv_coa_id', g_chart_of_accounts_id);*/

614:
615: /*dbms_sql.bind_variable(v_cursor_id, ':cv_sob_id', parm_set_of_books_id);
616: dbms_sql.bind_variable(v_cursor_id, ':cv_period_year', parm_gl_period_year);
617: dbms_sql.bind_variable(v_cursor_id, ':cv_currency_code', g_currency_code);
618: dbms_sql.bind_variable(v_cursor_id, ':cv_coa_id', g_chart_of_accounts_id);*/
619:
620: --
621:
622: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1038: v_cursor_id := dbms_sql.open_cursor;

1034: end if;
1035:
1036: if (query_fetch_bal is not null) then
1037:
1038: v_cursor_id := dbms_sql.open_cursor;
1039: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1040: -- print query
1041: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1042:

Line 1043: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);

1039: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1040: -- print query
1041: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1042:
1043: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1044: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1045: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1046: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1047: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);

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

1040: -- print query
1041: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1042:
1043: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1044: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1045: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1046: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1047: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1048:

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

1041: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1042:
1043: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1044: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1045: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1046: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1047: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1048:
1049: --print bind variables

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

1042:
1043: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1044: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1045: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1046: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1047: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1048:
1049: --print bind variables
1050: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);

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

1043: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1044: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1045: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1046: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1047: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1048:
1049: --print bind variables
1050: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1051: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);

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

1052: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1053: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1054:
1055:
1056: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1057:
1058: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1059: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1060: END IF;

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

1058: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1059: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1060: END IF;
1061:
1062: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1063: dbms_sql.close_cursor(v_cursor_id);
1064: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1065: end if;
1066:

Line 1063: dbms_sql.close_cursor(v_cursor_id);

1059: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1060: END IF;
1061:
1062: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1063: dbms_sql.close_cursor(v_cursor_id);
1064: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1065: end if;
1066:
1067: -- End the code for bal type beginning and ending

Line 1083: v_cursor_id := dbms_sql.open_cursor;

1079: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1080: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null
1081: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL'' ';
1082:
1083: v_cursor_id := dbms_sql.open_cursor;
1084:
1085: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1086:
1087: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);

Line 1087: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);

1083: v_cursor_id := dbms_sql.open_cursor;
1084:
1085: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1086:
1087: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1088: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1089: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1090: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1091: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);

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

1084:
1085: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1086:
1087: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1088: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1089: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1090: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1091: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1092: -- print query

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

1085: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1086:
1087: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1088: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1089: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1090: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1091: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1092: -- print query
1093: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);

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

1086:
1087: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1088: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1089: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1090: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1091: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1092: -- print query
1093: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1094:

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

1087: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1088: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1089: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1090: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1091: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1092: -- print query
1093: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1094:
1095: --print bind variables

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

1097: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1098: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1099: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1100:
1101: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1102:
1103: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1104: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1105: END IF;

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

1103: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1104: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1105: END IF;
1106:
1107: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1108: dbms_sql.close_cursor(v_cursor_id);
1109: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1110:
1111: elsif (( c_sf133_line_type_code = 'D' AND c_sf133_natural_bal_type ='C') or

Line 1108: dbms_sql.close_cursor(v_cursor_id);

1104: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1105: END IF;
1106:
1107: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1108: dbms_sql.close_cursor(v_cursor_id);
1109: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1110:
1111: elsif (( c_sf133_line_type_code = 'D' AND c_sf133_natural_bal_type ='C') or
1112: ( c_sf133_line_type_code = 'D2' AND c_sf133_natural_bal_type ='D'))then

Line 1123: v_cursor_id := dbms_sql.open_cursor;

1119: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1120: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null
1121: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL'' ';
1122:
1123: v_cursor_id := dbms_sql.open_cursor;
1124: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1125:
1126: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1127: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);

Line 1126: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);

1122:
1123: v_cursor_id := dbms_sql.open_cursor;
1124: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1125:
1126: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1127: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1128: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1129: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1130: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);

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

1123: v_cursor_id := dbms_sql.open_cursor;
1124: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1125:
1126: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1127: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1128: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1129: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1130: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1131: -- print query

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

1124: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1125:
1126: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1127: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1128: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1129: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1130: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1131: -- print query
1132: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);

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

1125:
1126: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1127: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1128: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1129: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1130: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1131: -- print query
1132: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1133:

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

1126: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1127: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1128: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1129: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1130: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1131: -- print query
1132: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1133:
1134: --print bind variables

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

1136: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1137: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1138: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1139:
1140: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1141:
1142: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1143: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1144: END IF;

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

1142: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1143: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1144: END IF;
1145:
1146: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1147: dbms_sql.close_cursor(v_cursor_id);
1148: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1149: END IF;
1150:

Line 1147: dbms_sql.close_cursor(v_cursor_id);

1143: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1144: END IF;
1145:
1146: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1147: dbms_sql.close_cursor(v_cursor_id);
1148: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1149: END IF;
1150:
1151: elsif (( c_sf133_balance_type= 'ED') or( c_sf133_balance_type= 'EC')) then -- bal type is ending debit or ending credit only

Line 1162: v_cursor_id := dbms_sql.open_cursor;

1158: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL''
1159: AND begin_end = ''E''';
1160:
1161: if (query_fetch_bal is not null) then
1162: v_cursor_id := dbms_sql.open_cursor;
1163: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1164:
1165: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1166: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);

Line 1165: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);

1161: if (query_fetch_bal is not null) then
1162: v_cursor_id := dbms_sql.open_cursor;
1163: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1164:
1165: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1166: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1167: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1168: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1169: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);

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

1162: v_cursor_id := dbms_sql.open_cursor;
1163: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1164:
1165: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1166: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1167: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1168: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1169: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1170:

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

1163: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1164:
1165: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1166: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1167: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1168: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1169: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1170:
1171: -- print query

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

1164:
1165: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1166: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1167: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1168: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1169: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1170:
1171: -- print query
1172: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);

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

1165: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1166: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1167: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1168: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1169: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1170:
1171: -- print query
1172: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1173: --print bind variables

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

1175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||parm_tsymbol_id);
1176: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1178:
1179: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1180:
1181: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1182: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1183: END IF;

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

1181: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1182: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1183: END IF;
1184:
1185: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1186: dbms_sql.close_cursor(v_cursor_id);
1187: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1188:
1189: if ( c_sf133_balance_type = 'ED')then

Line 1186: dbms_sql.close_cursor(v_cursor_id);

1182: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1183: END IF;
1184:
1185: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1186: dbms_sql.close_cursor(v_cursor_id);
1187: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1188:
1189: if ( c_sf133_balance_type = 'ED')then
1190: if (c_total_balance < 0) then

Line 1222: v_cursor_id := dbms_sql.open_cursor;

1218: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1219: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null
1220: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL'' ';
1221:
1222: v_cursor_id := dbms_sql.open_cursor;
1223:
1224: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1225:
1226: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);

Line 1226: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);

1222: v_cursor_id := dbms_sql.open_cursor;
1223:
1224: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1225:
1226: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1227: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1228: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1229: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1230: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);

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

1223:
1224: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1225:
1226: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1227: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1228: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1229: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1230: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1231: -- print query

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

1224: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1225:
1226: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1227: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1228: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1229: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1230: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1231: -- print query
1232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);

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

1225:
1226: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1227: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1228: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1229: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1230: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1231: -- print query
1232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1233:

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

1226: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1227: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1228: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1229: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1230: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1231: -- print query
1232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1233:
1234: --print bind variables

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

1236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1237: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1238: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1239:
1240: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1241:
1242: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1243: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1244: END IF;

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

1242: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1243: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1244: END IF;
1245:
1246: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1247: dbms_sql.close_cursor(v_cursor_id);
1248: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1249:
1250: if (c_sf133_balance_type= 'E-BD') then

Line 1247: dbms_sql.close_cursor(v_cursor_id);

1243: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1244: END IF;
1245:
1246: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1247: dbms_sql.close_cursor(v_cursor_id);
1248: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1249:
1250: if (c_sf133_balance_type= 'E-BD') then
1251: if (c_total_balance > 0) then

Line 1350: ELSIF dbms_sql.is_open(v_cursor_id) THEN

1346: g_error_message := SQLERRM;
1347:
1348: IF balance_type_cursor%ISOPEN THEN
1349: close balance_type_cursor;
1350: ELSIF dbms_sql.is_open(v_cursor_id) THEN
1351: dbms_sql.close_cursor(v_cursor_id);
1352: END IF;
1353:
1354: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_FISCAL_LINE_COLUMNS:'||G_ERROR_MESSAGE);

Line 1351: dbms_sql.close_cursor(v_cursor_id);

1347:
1348: IF balance_type_cursor%ISOPEN THEN
1349: close balance_type_cursor;
1350: ELSIF dbms_sql.is_open(v_cursor_id) THEN
1351: dbms_sql.close_cursor(v_cursor_id);
1352: END IF;
1353:
1354: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_FISCAL_LINE_COLUMNS:'||G_ERROR_MESSAGE);
1355: --

Line 1812: v_cursor_id_ind := dbms_sql.open_cursor;

1808: 'AND acct.sf133_line_acct_id = '||c_sf133_line_acct_id||
1809: 'and acct_number like facE.sgl_acct_number||''%'' and facE.sgl_acct_number is not null
1810: and facE.begin_end=''E''' ;
1811:
1812: v_cursor_id_ind := dbms_sql.open_cursor;
1813: dbms_sql.parse(v_cursor_id_ind, query_Ending_Indicator, dbms_sql.v7);
1814: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_E);
1815: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_E);
1816:

Line 1813: dbms_sql.parse(v_cursor_id_ind, query_Ending_Indicator, dbms_sql.v7);

1809: 'and acct_number like facE.sgl_acct_number||''%'' and facE.sgl_acct_number is not null
1810: and facE.begin_end=''E''' ;
1811:
1812: v_cursor_id_ind := dbms_sql.open_cursor;
1813: dbms_sql.parse(v_cursor_id_ind, query_Ending_Indicator, dbms_sql.v7);
1814: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_E);
1815: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_E);
1816:
1817: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);

Line 1814: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_E);

1810: and facE.begin_end=''E''' ;
1811:
1812: v_cursor_id_ind := dbms_sql.open_cursor;
1813: dbms_sql.parse(v_cursor_id_ind, query_Ending_Indicator, dbms_sql.v7);
1814: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_E);
1815: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_E);
1816:
1817: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
1818: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1815: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_E);

1811:
1812: v_cursor_id_ind := dbms_sql.open_cursor;
1813: dbms_sql.parse(v_cursor_id_ind, query_Ending_Indicator, dbms_sql.v7);
1814: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_E);
1815: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_E);
1816:
1817: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
1818: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1819: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);

Line 1817: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);

1813: dbms_sql.parse(v_cursor_id_ind, query_Ending_Indicator, dbms_sql.v7);
1814: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_E);
1815: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_E);
1816:
1817: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
1818: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1819: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
1820: END IF;
1821: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_E);

Line 1821: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_E);

1817: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
1818: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1819: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
1820: END IF;
1821: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_E);
1822: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_E);
1823: -- dbms_sql.close_cursor(v_cursor_id_ind);
1824:
1825: if DSum_E >= CSum_E then

Line 1822: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_E);

1818: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1819: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
1820: END IF;
1821: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_E);
1822: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_E);
1823: -- dbms_sql.close_cursor(v_cursor_id_ind);
1824:
1825: if DSum_E >= CSum_E then
1826: e_bal_indicator:='D';

Line 1823: -- dbms_sql.close_cursor(v_cursor_id_ind);

1819: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
1820: END IF;
1821: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_E);
1822: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_E);
1823: -- dbms_sql.close_cursor(v_cursor_id_ind);
1824:
1825: if DSum_E >= CSum_E then
1826: e_bal_indicator:='D';
1827: else

Line 1841: v_cursor_id_ind := dbms_sql.open_cursor;

1837: 'AND acct.sf133_line_acct_id = '||c_sf133_line_acct_id||
1838: 'and acct_number like facB.sgl_acct_number||''%'' and facB.sgl_acct_number is not null
1839: and facB.begin_end=''B''' ;
1840:
1841: v_cursor_id_ind := dbms_sql.open_cursor;
1842: dbms_sql.parse(v_cursor_id_ind, query_Beg_Indicator, dbms_sql.v7);
1843: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_B);
1844: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_B);
1845:

Line 1842: dbms_sql.parse(v_cursor_id_ind, query_Beg_Indicator, dbms_sql.v7);

1838: 'and acct_number like facB.sgl_acct_number||''%'' and facB.sgl_acct_number is not null
1839: and facB.begin_end=''B''' ;
1840:
1841: v_cursor_id_ind := dbms_sql.open_cursor;
1842: dbms_sql.parse(v_cursor_id_ind, query_Beg_Indicator, dbms_sql.v7);
1843: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_B);
1844: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_B);
1845:
1846: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);

Line 1843: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_B);

1839: and facB.begin_end=''B''' ;
1840:
1841: v_cursor_id_ind := dbms_sql.open_cursor;
1842: dbms_sql.parse(v_cursor_id_ind, query_Beg_Indicator, dbms_sql.v7);
1843: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_B);
1844: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_B);
1845:
1846: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
1847: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1844: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_B);

1840:
1841: v_cursor_id_ind := dbms_sql.open_cursor;
1842: dbms_sql.parse(v_cursor_id_ind, query_Beg_Indicator, dbms_sql.v7);
1843: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_B);
1844: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_B);
1845:
1846: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
1847: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1848: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);

Line 1846: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);

1842: dbms_sql.parse(v_cursor_id_ind, query_Beg_Indicator, dbms_sql.v7);
1843: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_B);
1844: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_B);
1845:
1846: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
1847: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1848: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
1849: END IF;
1850: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_B);

Line 1850: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_B);

1846: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
1847: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1848: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
1849: END IF;
1850: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_B);
1851: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_B);
1852: --dbms_sql.close_cursor(v_cursor_id_ind);
1853:
1854: if DSum_B >= CSum_B then

Line 1851: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_B);

1847: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1848: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
1849: END IF;
1850: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_B);
1851: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_B);
1852: --dbms_sql.close_cursor(v_cursor_id_ind);
1853:
1854: if DSum_B >= CSum_B then
1855: b_bal_indicator:='D';

Line 1852: --dbms_sql.close_cursor(v_cursor_id_ind);

1848: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
1849: END IF;
1850: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_B);
1851: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_B);
1852: --dbms_sql.close_cursor(v_cursor_id_ind);
1853:
1854: if DSum_B >= CSum_B then
1855: b_bal_indicator:='D';
1856: else

Line 1859: DBMS_SQL.CLOSE_CURSOR(v_cursor_id_ind);

1855: b_bal_indicator:='D';
1856: else
1857: b_bal_indicator:='C';
1858: end if;
1859: DBMS_SQL.CLOSE_CURSOR(v_cursor_id_ind);
1860: EXCEPTION
1861: WHEN OTHERS THEN
1862: g_error_code := SQLCODE;
1863: g_error_message := SQLERRM;