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_STATUS_OF_FUNDS_PKG dependencies on FV_STATUS_FUNDS_FINAL

Line 878: INSERT INTO fv_status_funds_final

874: END LOOP;
875: FOR c_get_temptable_info_rec IN c_get_temptable_info LOOP
876:
877: -- modified to Fix Bug.1575992
878: INSERT INTO fv_status_funds_final
879: (set_of_books_id,treasury_symbol,fund,pagebreak_seg1,
880: pagebreak_seg2,pagebreak_seg3,
881: treasury_symbol_id,
882: budget_auth_total)

Line 907: INSERT INTO fv_status_funds_final

903: IF parent_flag = 'Y' then
904: FOR c_get_temptable_info_rec IN c_get_temptable_info LOOP
905:
906: --Modified to Fix bug.1575992
907: INSERT INTO fv_status_funds_final
908: (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
909: pagebreak_seg2,pagebreak_seg3,budget_auth_total)
910: VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
911: c_get_temptable_info_rec.pagebk1,

Line 1012: UPDATE fv_status_funds_final SET

1008: c_packets_spending_rec.pg3,c_packets_spending_rec.pac_spend);
1009: END LOOP;
1010: FOR c_get_temptable_info_rec IN c_get_temptable_info LOOP
1011: IF v_trans_type = 'TRANS_IN' THEN
1012: UPDATE fv_status_funds_final SET
1013: transfers_in_total = decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot)
1014: WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
1015: AND set_of_books_id = sob_id1
1016: AND pagebreak_seg2 = c_get_temptable_info_rec.pagebk2

Line 1026: INSERT INTO fv_status_funds_final

1022: END IF;
1023:
1024: -- Modified to fix Bug.1575992
1025: IF SQL%ROWCOUNT = 0 THEN
1026: INSERT INTO fv_status_funds_final
1027: (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
1028: pagebreak_seg2,pagebreak_seg3,transfers_in_total)
1029: VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
1030: c_get_temptable_info_rec.pagebk1,

Line 1040: UPDATE fv_status_funds_final SET

1036: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRANS_IN_2:C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);
1037: END IF;
1038: END IF;
1039: ELSIF v_trans_type = 'TRANS_OUT' THEN
1040: UPDATE fv_status_funds_final SET
1041: transfers_out_total =decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot)
1042: WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
1043: AND set_of_books_id = sob_id1
1044: AND pagebreak_seg2 = c_get_temptable_info_rec.pagebk2

Line 1050: INSERT INTO fv_status_funds_final

1046: AND fund = v_fund_value1;
1047:
1048: IF SQL%ROWCOUNT = 0 THEN
1049: --Modified to fix Bug.1575992
1050: INSERT INTO fv_status_funds_final
1051: (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
1052: pagebreak_seg2,pagebreak_seg3,transfers_out_total)
1053: VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
1054: c_get_temptable_info_rec.pagebk1,

Line 1070: UPDATE fv_status_funds_final SET

1066: CLOSE c_parent_value_transfers;
1067: IF parent_flag = 'Y' THEN
1068: FOR c_get_temptable_info_rec IN c_get_temptable_info LOOP
1069: IF v_trans_type = 'TRANS_IN' THEN
1070: UPDATE fv_status_funds_final SET
1071: transfers_in_total = decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot)
1072: WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
1073: AND set_of_books_id = sob_id1
1074: AND pagebreak_seg2 = c_get_temptable_info_rec.pagebk2

Line 1080: INSERT INTO fv_status_funds_final

1076: AND fund = v_fund_value1;
1077:
1078: IF SQL%ROWCOUNT = 0 THEN
1079: --Modified to Fix bug.1575992
1080: INSERT INTO fv_status_funds_final
1081: (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
1082: pagebreak_seg2,pagebreak_seg3,transfers_in_total)
1083: VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
1084: c_get_temptable_info_rec.pagebk1,

Line 1091: UPDATE fv_status_funds_final SET

1087: decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot));
1088:
1089: END IF;
1090: ELSIF v_trans_type = 'TRANS_OUT' THEN
1091: UPDATE fv_status_funds_final SET
1092: transfers_out_total = decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot)
1093: WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
1094: AND pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
1095: AND pagebreak_seg3 = c_get_temptable_info_rec.pagebk3

Line 1101: INSERT INTO fv_status_funds_final

1097: AND fund = v_fund_value1;
1098:
1099: IF SQL%ROWCOUNT = 0 THEN
1100: --Modified to fix Bug.1575992
1101: INSERT INTO fv_status_funds_final
1102: (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
1103: pagebreak_seg2,pagebreak_seg3,transfers_out_total)
1104: VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
1105: c_get_temptable_info_rec.pagebk1,

Line 1199: UPDATE fv_status_funds_final SET

1195: c_packets_spending_rec.pg3,c_packets_spending_rec.pac_spend);
1196: END LOOP;
1197: FOR c_get_temptable_info_rec IN c_get_temptable_info LOOP
1198: IF v_spend_type = 'UNLIQ_COMM' THEN
1199: UPDATE fv_status_funds_final SET
1200: unliquid_comm_total = decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0))
1201: WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
1202: AND pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
1203: AND pagebreak_seg3 = c_get_temptable_info_rec.pagebk3

Line 1209: INSERT INTO fv_status_funds_final

1205: AND fund = v_fund_value1;
1206:
1207: IF SQL%ROWCOUNT = 0 THEN
1208: --Modified to Fix bug.1575992
1209: INSERT INTO fv_status_funds_final
1210: (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
1211: pagebreak_seg2,pagebreak_seg3,unliquid_comm_total)
1212: VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
1213: c_get_temptable_info_rec.pagebk1,

Line 1225: UPDATE fv_status_funds_final SET

1221: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK3 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK3);
1222: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);
1223: END IF;
1224: ELSIF v_spend_type = 'UNLIQ_OBLIG' THEN
1225: UPDATE fv_status_funds_final SET
1226: unliquid_oblig_total = decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0))
1227: WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
1228: AND pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
1229: AND pagebreak_seg3 = c_get_temptable_info_rec.pagebk3

Line 1235: INSERT INTO fv_status_funds_final

1231: AND fund = v_fund_value1;
1232:
1233: IF SQL%ROWCOUNT = 0 THEN
1234: --Modified to Fix bug.1575992
1235: INSERT INTO fv_status_funds_final
1236: (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
1237: pagebreak_seg2,pagebreak_seg3,unliquid_oblig_total)
1238: VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
1239: c_get_temptable_info_rec.pagebk1,

Line 1245: UPDATE fv_status_funds_final SET

1241: c_get_temptable_info_rec.pagebk3,
1242: decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0)));
1243: END IF;
1244: ELSIF v_spend_type = 'EXPEN_AMT' THEN
1245: UPDATE fv_status_funds_final SET
1246: expen_amt_total = decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0))
1247: WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
1248: AND pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
1249: AND pagebreak_seg3 = c_get_temptable_info_rec.pagebk3

Line 1255: INSERT INTO fv_status_funds_final

1251: AND fund = v_fund_value1;
1252:
1253: IF SQL%ROWCOUNT = 0 THEN
1254: --Modified to fix Bug.1575992
1255: INSERT INTO fv_status_funds_final
1256: (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
1257: pagebreak_seg2,pagebreak_seg3,expen_amt_total)
1258: VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
1259: c_get_temptable_info_rec.pagebk1,

Line 1274: UPDATE fv_status_funds_final SET

1270: CLOSE c_parent_value_spending;
1271: IF parent_flag = 'Y' THEN
1272: FOR c_get_temptable_info_rec IN c_get_temptable_info LOOP
1273: IF v_spend_type = 'UNLIQ_COMM' THEN
1274: UPDATE fv_status_funds_final SET
1275: unliquid_comm_total = decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0))
1276: WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
1277: AND pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
1278: AND pagebreak_seg3 = c_get_temptable_info_rec.pagebk3

Line 1284: INSERT INTO fv_status_funds_final

1280: AND fund = v_fund_value1;
1281:
1282: IF SQL%ROWCOUNT = 0 THEN
1283: --Modified to fix bug.1575992
1284: INSERT INTO fv_status_funds_final
1285: (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
1286: pagebreak_seg2,pagebreak_seg3,unliquid_comm_total)
1287: VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
1288: c_get_temptable_info_rec.pagebk1,

Line 1294: UPDATE fv_status_funds_final SET

1290: c_get_temptable_info_rec.pagebk3,
1291: decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0)));
1292: END IF;
1293: ELSIF v_spend_type = 'UNLIQ_OBLIG' THEN
1294: UPDATE fv_status_funds_final SET
1295: unliquid_oblig_total = decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0))
1296: WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
1297: AND pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
1298: AND pagebreak_seg3 = c_get_temptable_info_rec.pagebk3

Line 1304: INSERT INTO fv_status_funds_final

1300: AND fund = v_fund_value1;
1301:
1302: IF SQL%ROWCOUNT = 0 THEN
1303: --Modified to fix Bug.1575992
1304: INSERT INTO fv_status_funds_final
1305: (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
1306: pagebreak_seg2,pagebreak_seg3,unliquid_oblig_total)
1307: VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
1308: c_get_temptable_info_rec.pagebk1,

Line 1315: UPDATE fv_status_funds_final SET

1311: decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0)));
1312:
1313: END IF;
1314: ELSIF v_spend_type = 'EXPEN_AMT' THEN
1315: UPDATE fv_status_funds_final SET
1316: expen_amt_total = decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0))
1317: WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
1318: AND pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
1319: AND pagebreak_seg3 = c_get_temptable_info_rec.pagebk3

Line 1325: INSERT INTO fv_status_funds_final

1321: ANd fund = v_fund_value1;
1322:
1323: IF SQL%ROWCOUNT = 0 THEN
1324: --Modified to fix Bug.1575992
1325: INSERT INTO fv_status_funds_final
1326: (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
1327: pagebreak_seg2,pagebreak_seg3,expen_amt_total)
1328: VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
1329: c_get_temptable_info_rec.pagebk1,

Line 1377: /* This procedure deletes all the rows from the fv_status_funds_final table.*/

1373:
1374: END get_flex_value_id;
1375:
1376: /***************************************************************************/
1377: /* This procedure deletes all the rows from the fv_status_funds_final table.*/
1378: /***************************************************************************/
1379: PROCEDURE delete_from_final
1380: IS
1381: l_module_name varchar2(200) := g_module_name || 'delete_from_final';

Line 1384: delete from fv_status_funds_final;

1380: IS
1381: l_module_name varchar2(200) := g_module_name || 'delete_from_final';
1382: l_errbuf varchar2(300);
1383: BEGIN
1384: delete from fv_status_funds_final;
1385: commit;
1386: EXCEPTION
1387: WHEN OTHERS THEN
1388: l_errbuf := SQLERRM;

Line 1569: UPDATE fv_status_funds_final set

1565: END LOOP;
1566:
1567: -- Calculating the values for total_budgetary, total_actuals and funds_available
1568: --Update statement is modified as part of BE enhancement
1569: UPDATE fv_status_funds_final set
1570: --total_budgetary = (nvl(budget_Auth_total,0) + nvl(transfers_in_total,0)) - nvl(transfers_out_total,0),
1571: total_budgetary = (nvl(budget_Auth_total,0)) ,
1572: total_actuals = nvl(unliquid_comm_total,0) + nvl(unliquid_oblig_total,0) + nvl(expen_amt_total,0);
1573: UPDATE fv_status_funds_final set

Line 1573: UPDATE fv_status_funds_final set

1569: UPDATE fv_status_funds_final set
1570: --total_budgetary = (nvl(budget_Auth_total,0) + nvl(transfers_in_total,0)) - nvl(transfers_out_total,0),
1571: total_budgetary = (nvl(budget_Auth_total,0)) ,
1572: total_actuals = nvl(unliquid_comm_total,0) + nvl(unliquid_oblig_total,0) + nvl(expen_amt_total,0);
1573: UPDATE fv_status_funds_final set
1574: funds_available = nvl(total_budgetary,0) - nvl(total_actuals,0);
1575:
1576: EXCEPTION
1577: when others then