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 700: v_cursor_id := DBMS_SQL.OPEN_CURSOR();

696: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
697: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,V_SELECT);
698: END IF;
699: --
700: v_cursor_id := DBMS_SQL.OPEN_CURSOR();
701: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
702: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T1');
703: END IF;
704:

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

703: END IF;
704:
705: fnd_file.put_line (fnd_file.log, v_select);
706:
707: dbms_sql.parse(v_cursor_id,v_select,dbms_sql.v7);
708:
709: dbms_sql.bind_variable(v_cursor_id,':cv_set_of_books_id',parm_set_of_books_id);
710: -- dbms_sql.bind_variable(v_cursor_id,':cv_chart_of_accounts_id',g_chart_of_accounts_id);
711: dbms_sql.bind_variable(v_cursor_id,':cv_currency_code',g_currency_code);

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

705: fnd_file.put_line (fnd_file.log, v_select);
706:
707: dbms_sql.parse(v_cursor_id,v_select,dbms_sql.v7);
708:
709: dbms_sql.bind_variable(v_cursor_id,':cv_set_of_books_id',parm_set_of_books_id);
710: -- dbms_sql.bind_variable(v_cursor_id,':cv_chart_of_accounts_id',g_chart_of_accounts_id);
711: dbms_sql.bind_variable(v_cursor_id,':cv_currency_code',g_currency_code);
712:
713: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

706:
707: dbms_sql.parse(v_cursor_id,v_select,dbms_sql.v7);
708:
709: dbms_sql.bind_variable(v_cursor_id,':cv_set_of_books_id',parm_set_of_books_id);
710: -- dbms_sql.bind_variable(v_cursor_id,':cv_chart_of_accounts_id',g_chart_of_accounts_id);
711: dbms_sql.bind_variable(v_cursor_id,':cv_currency_code',g_currency_code);
712:
713: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
714: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T2');

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

707: dbms_sql.parse(v_cursor_id,v_select,dbms_sql.v7);
708:
709: dbms_sql.bind_variable(v_cursor_id,':cv_set_of_books_id',parm_set_of_books_id);
710: -- dbms_sql.bind_variable(v_cursor_id,':cv_chart_of_accounts_id',g_chart_of_accounts_id);
711: dbms_sql.bind_variable(v_cursor_id,':cv_currency_code',g_currency_code);
712:
713: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
714: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T2');
715: END IF;

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

712:
713: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
714: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T2');
715: END IF;
716: dbms_sql.define_column(v_cursor_id,1,c_total_balance);
717: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
718: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T3');
719: END IF;
720:

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

927: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TREASURY SYMBOL IS '||C_SF133_TS_VALUE );
928: END IF;
929:
930: c_sf133_treasury_symbol_id := g_treasury_symbol_id;
931: -- dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',
932: -- g_treasury_symbol_id);
933: -- Derive the Amount Values for the Previous Year
934: build_fiscal_line_columns
935: (L_BEG_PERIOD_PREV, L_END_PERIOD_PREV, L_PROCESS_YEAR) ;

Line 1315: v_cursor_id := dbms_sql.open_cursor;

1311: end if;
1312:
1313: if (query_fetch_bal is not null) then
1314:
1315: v_cursor_id := dbms_sql.open_cursor;
1316: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1317: -- print query
1318: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1319:

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

1316: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1317: -- print query
1318: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1319:
1320: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1321: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1322: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1323: --dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',g_treasury_symbol_id);
1324: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);

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

1317: -- print query
1318: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1319:
1320: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1321: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1322: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1323: --dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',g_treasury_symbol_id);
1324: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1325: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);

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

1318: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1319:
1320: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1321: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1322: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1323: --dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',g_treasury_symbol_id);
1324: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1325: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1326:

Line 1323: --dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',g_treasury_symbol_id);

1319:
1320: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1321: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1322: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1323: --dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',g_treasury_symbol_id);
1324: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1325: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1326:
1327: --print bind variables

Line 1324: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);

1320: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1321: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1322: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1323: --dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',g_treasury_symbol_id);
1324: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1325: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1326:
1327: --print bind variables
1328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);

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

1321: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1322: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1323: --dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',g_treasury_symbol_id);
1324: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1325: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1326:
1327: --print bind variables
1328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);

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

1330: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1331: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1332:
1333:
1334: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1335:
1336: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1337: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1338: END IF;

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

1336: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1337: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1338: END IF;
1339:
1340: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1341: dbms_sql.close_cursor(v_cursor_id);
1342: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1343: end if;
1344:

Line 1341: dbms_sql.close_cursor(v_cursor_id);

1337: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1338: END IF;
1339:
1340: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1341: dbms_sql.close_cursor(v_cursor_id);
1342: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1343: end if;
1344:
1345: -- End the code for bal type beginning and ending

Line 1361: v_cursor_id := dbms_sql.open_cursor;

1357: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1358: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null
1359: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL'' ';
1360:
1361: v_cursor_id := dbms_sql.open_cursor;
1362:
1363: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1364:
1365: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);

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

1361: v_cursor_id := dbms_sql.open_cursor;
1362:
1363: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1364:
1365: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1366: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1367: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1368: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1369: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);

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

1362:
1363: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1364:
1365: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1366: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1367: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1368: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1369: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1370: -- print query

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

1363: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1364:
1365: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1366: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1367: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1368: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1369: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1370: -- print query
1371: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);

Line 1368: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);

1364:
1365: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1366: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1367: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1368: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1369: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1370: -- print query
1371: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1372:

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

1365: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1366: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1367: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1368: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1369: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1370: -- print query
1371: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1372:
1373: --print bind variables

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

1375: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1376: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1377: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1378:
1379: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1380:
1381: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1382: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1383: END IF;

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

1381: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1382: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1383: END IF;
1384:
1385: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1386: dbms_sql.close_cursor(v_cursor_id);
1387: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1388:
1389: elsif (( c_sf133_line_type_code = 'D' AND c_sf133_natural_bal_type ='C') or

Line 1386: dbms_sql.close_cursor(v_cursor_id);

1382: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1383: END IF;
1384:
1385: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1386: dbms_sql.close_cursor(v_cursor_id);
1387: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1388:
1389: elsif (( c_sf133_line_type_code = 'D' AND c_sf133_natural_bal_type ='C') or
1390: ( c_sf133_line_type_code = 'D2' AND c_sf133_natural_bal_type ='D'))then

Line 1401: v_cursor_id := dbms_sql.open_cursor;

1397: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1398: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null
1399: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL'' ';
1400:
1401: v_cursor_id := dbms_sql.open_cursor;
1402: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1403:
1404: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1405: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);

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

1400:
1401: v_cursor_id := dbms_sql.open_cursor;
1402: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1403:
1404: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1405: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1406: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1407: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1408: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);

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

1401: v_cursor_id := dbms_sql.open_cursor;
1402: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1403:
1404: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1405: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1406: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1407: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1408: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1409: -- print query

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

1402: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1403:
1404: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1405: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1406: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1407: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1408: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1409: -- print query
1410: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);

Line 1407: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);

1403:
1404: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1405: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1406: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1407: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1408: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1409: -- print query
1410: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1411:

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

1404: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1405: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1406: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1407: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1408: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1409: -- print query
1410: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1411:
1412: --print bind variables

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

1414: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1415: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1416: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1417:
1418: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1419:
1420: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1421: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1422: END IF;

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

1420: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1421: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1422: END IF;
1423:
1424: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1425: dbms_sql.close_cursor(v_cursor_id);
1426: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1427: END IF;
1428:

Line 1425: dbms_sql.close_cursor(v_cursor_id);

1421: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1422: END IF;
1423:
1424: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1425: dbms_sql.close_cursor(v_cursor_id);
1426: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1427: END IF;
1428:
1429: elsif (( c_sf133_balance_type= 'ED') or( c_sf133_balance_type= 'EC')) then -- bal type is ending debit or ending credit only

Line 1440: v_cursor_id := dbms_sql.open_cursor;

1436: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL''
1437: AND begin_end = ''E''';
1438:
1439: if (query_fetch_bal is not null) then
1440: v_cursor_id := dbms_sql.open_cursor;
1441: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1442:
1443: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1444: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);

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

1439: if (query_fetch_bal is not null) then
1440: v_cursor_id := dbms_sql.open_cursor;
1441: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1442:
1443: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1444: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1445: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1446: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1447: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);

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

1440: v_cursor_id := dbms_sql.open_cursor;
1441: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1442:
1443: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1444: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1445: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1446: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1447: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1448:

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

1441: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1442:
1443: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1444: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1445: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1446: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1447: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1448:
1449: -- print query

Line 1446: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);

1442:
1443: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1444: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1445: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1446: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1447: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1448:
1449: -- print query
1450: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);

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

1443: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1444: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1445: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1446: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1447: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1448:
1449: -- print query
1450: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1451: --print bind variables

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

1453: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||c_sf133_treasury_symbol_id);
1454: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1455: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1456:
1457: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1458:
1459: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1461: END IF;

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

1459: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1461: END IF;
1462:
1463: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1464: dbms_sql.close_cursor(v_cursor_id);
1465: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1466:
1467: if ( c_sf133_balance_type = 'ED')then

Line 1464: dbms_sql.close_cursor(v_cursor_id);

1460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1461: END IF;
1462:
1463: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1464: dbms_sql.close_cursor(v_cursor_id);
1465: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1466:
1467: if ( c_sf133_balance_type = 'ED')then
1468: if (c_total_balance < 0) then

Line 1500: v_cursor_id := dbms_sql.open_cursor;

1496: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1497: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null
1498: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL'' ';
1499:
1500: v_cursor_id := dbms_sql.open_cursor;
1501:
1502: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1503:
1504: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);

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

1500: v_cursor_id := dbms_sql.open_cursor;
1501:
1502: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1503:
1504: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1505: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1506: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1507: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1508: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);

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

1501:
1502: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1503:
1504: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1505: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1506: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1507: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1508: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1509: -- print query

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

1502: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1503:
1504: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1505: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1506: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1507: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1508: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1509: -- print query
1510: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);

Line 1507: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);

1503:
1504: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1505: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1506: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1507: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1508: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1509: -- print query
1510: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1511:

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

1504: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1505: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1506: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1507: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1508: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1509: -- print query
1510: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1511:
1512: --print bind variables

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

1514: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1515: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1516: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1517:
1518: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1519:
1520: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1522: END IF;

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

1520: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1522: END IF;
1523:
1524: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1525: dbms_sql.close_cursor(v_cursor_id);
1526: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1527:
1528: if (c_sf133_balance_type= 'E-BD') then

Line 1525: dbms_sql.close_cursor(v_cursor_id);

1521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1522: END IF;
1523:
1524: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1525: dbms_sql.close_cursor(v_cursor_id);
1526: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1527:
1528: if (c_sf133_balance_type= 'E-BD') then
1529: if (c_total_balance > 0) then

Line 2197: v_cursor_id_ind := dbms_sql.open_cursor;

2193: 'AND acct.sf133_line_acct_id = '||c_sf133_line_acct_id||
2194: 'and acct_number like facE.sgl_acct_number||''%'' and facE.sgl_acct_number is not null
2195: and facE.begin_end=''E''' ;
2196:
2197: v_cursor_id_ind := dbms_sql.open_cursor;
2198: dbms_sql.parse(v_cursor_id_ind, query_Ending_Indicator, dbms_sql.v7);
2199: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_E);
2200: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_E);
2201:

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

2194: 'and acct_number like facE.sgl_acct_number||''%'' and facE.sgl_acct_number is not null
2195: and facE.begin_end=''E''' ;
2196:
2197: v_cursor_id_ind := dbms_sql.open_cursor;
2198: dbms_sql.parse(v_cursor_id_ind, query_Ending_Indicator, dbms_sql.v7);
2199: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_E);
2200: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_E);
2201:
2202: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);

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

2195: and facE.begin_end=''E''' ;
2196:
2197: v_cursor_id_ind := dbms_sql.open_cursor;
2198: dbms_sql.parse(v_cursor_id_ind, query_Ending_Indicator, dbms_sql.v7);
2199: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_E);
2200: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_E);
2201:
2202: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
2203: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2196:
2197: v_cursor_id_ind := dbms_sql.open_cursor;
2198: dbms_sql.parse(v_cursor_id_ind, query_Ending_Indicator, dbms_sql.v7);
2199: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_E);
2200: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_E);
2201:
2202: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
2203: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2204: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);

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

2198: dbms_sql.parse(v_cursor_id_ind, query_Ending_Indicator, dbms_sql.v7);
2199: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_E);
2200: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_E);
2201:
2202: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
2203: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2204: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
2205: END IF;
2206: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_E);

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

2202: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
2203: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2204: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
2205: END IF;
2206: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_E);
2207: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_E);
2208: --dbms_sql.close_cursor(v_cursor_id_ind);
2209:
2210: if DSum_E >= CSum_E then

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

2203: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2204: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
2205: END IF;
2206: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_E);
2207: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_E);
2208: --dbms_sql.close_cursor(v_cursor_id_ind);
2209:
2210: if DSum_E >= CSum_E then
2211: e_bal_indicator:='D';

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

2204: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
2205: END IF;
2206: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_E);
2207: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_E);
2208: --dbms_sql.close_cursor(v_cursor_id_ind);
2209:
2210: if DSum_E >= CSum_E then
2211: e_bal_indicator:='D';
2212: else

Line 2226: v_cursor_id_ind := dbms_sql.open_cursor;

2222: 'AND acct.sf133_line_acct_id = '||c_sf133_line_acct_id||
2223: 'and acct_number like facB.sgl_acct_number||''%'' and facB.sgl_acct_number is not null
2224: and facB.begin_end=''B''' ;
2225:
2226: v_cursor_id_ind := dbms_sql.open_cursor;
2227: dbms_sql.parse(v_cursor_id_ind, query_Beg_Indicator, dbms_sql.v7);
2228: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_B);
2229: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_B);
2230:

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

2223: 'and acct_number like facB.sgl_acct_number||''%'' and facB.sgl_acct_number is not null
2224: and facB.begin_end=''B''' ;
2225:
2226: v_cursor_id_ind := dbms_sql.open_cursor;
2227: dbms_sql.parse(v_cursor_id_ind, query_Beg_Indicator, dbms_sql.v7);
2228: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_B);
2229: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_B);
2230:
2231: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);

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

2224: and facB.begin_end=''B''' ;
2225:
2226: v_cursor_id_ind := dbms_sql.open_cursor;
2227: dbms_sql.parse(v_cursor_id_ind, query_Beg_Indicator, dbms_sql.v7);
2228: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_B);
2229: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_B);
2230:
2231: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
2232: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2225:
2226: v_cursor_id_ind := dbms_sql.open_cursor;
2227: dbms_sql.parse(v_cursor_id_ind, query_Beg_Indicator, dbms_sql.v7);
2228: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_B);
2229: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_B);
2230:
2231: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
2232: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2233: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);

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

2227: dbms_sql.parse(v_cursor_id_ind, query_Beg_Indicator, dbms_sql.v7);
2228: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_B);
2229: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_B);
2230:
2231: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
2232: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2233: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
2234: END IF;
2235: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_B);

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

2231: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
2232: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2233: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
2234: END IF;
2235: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_B);
2236: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_B);
2237: --dbms_sql.close_cursor(v_cursor_id_ind);
2238:
2239: if DSum_B >= CSum_B then

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

2232: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2233: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
2234: END IF;
2235: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_B);
2236: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_B);
2237: --dbms_sql.close_cursor(v_cursor_id_ind);
2238:
2239: if DSum_B >= CSum_B then
2240: b_bal_indicator:='D';

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

2233: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
2234: END IF;
2235: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_B);
2236: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_B);
2237: --dbms_sql.close_cursor(v_cursor_id_ind);
2238:
2239: if DSum_B >= CSum_B then
2240: b_bal_indicator:='D';
2241: else

Line 2244: DBMS_SQL.CLOSE_CURSOR(v_cursor_id_ind);

2240: b_bal_indicator:='D';
2241: else
2242: b_bal_indicator:='C';
2243: end if;
2244: DBMS_SQL.CLOSE_CURSOR(v_cursor_id_ind);
2245: EXCEPTION
2246: WHEN OTHERS THEN
2247: g_error_code := SQLCODE;
2248: g_error_message := SQLERRM;