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.FA_SORP_UPG_PKG dependencies on FA_SORP_UPG_CAGF

Line 959: FUNCTION fa_sorp_upg_cagf_mc_fn (p_book_type_code VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

955: ROLLBACK;
956: RETURN FALSE;
957: END fa_sorp_reval_chk_fn;
958:
959: FUNCTION fa_sorp_upg_cagf_mc_fn (p_book_type_code VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
960: RETURN BOOLEAN
961: IS
962: l_deprn_rsv NUMBER;
963: l_impairment_rsv NUMBER;

Line 1014: cursor c_fa_sorp_upg_cagf_hist_cur is

1010: ORDER BY SET_OF_BOOKS_ID ASC,period_counter;
1011:
1012: v_deprn_summary_cur c_deprn_summary_cur%ROWTYPE;
1013:
1014: cursor c_fa_sorp_upg_cagf_hist_cur is
1015: select book_type_code ,
1016: asset_id,
1017: asset_number ,
1018: asset_description,

Line 1027: from fa_sorp_upg_cagf;

1023: revaluation_reserve,
1024: impairment_reserve,
1025: capital_adjustment_acct_amount,
1026: general_fund_acct_amount
1027: from fa_sorp_upg_cagf;
1028:
1029: v_fa_sorp_upg_cagf_hist_cur c_fa_sorp_upg_cagf_hist_cur%rowtype;
1030:
1031: l_request_id number;

Line 1029: v_fa_sorp_upg_cagf_hist_cur c_fa_sorp_upg_cagf_hist_cur%rowtype;

1025: capital_adjustment_acct_amount,
1026: general_fund_acct_amount
1027: from fa_sorp_upg_cagf;
1028:
1029: v_fa_sorp_upg_cagf_hist_cur c_fa_sorp_upg_cagf_hist_cur%rowtype;
1030:
1031: l_request_id number;
1032: v_final_cnt number;
1033: v_period_name varchar2(25);

Line 1050: DELETE FROM fa_sorp_upg_cagf;

1046:
1047: l_old_sob_id NUMBER;
1048:
1049: BEGIN
1050: DELETE FROM fa_sorp_upg_cagf;
1051:
1052: COMMIT;
1053:
1054: l_request_id := fnd_global.conc_request_id;

Line 1056: p_from := 'fa_sorp_upg_cagf';

1052: COMMIT;
1053:
1054: l_request_id := fnd_global.conc_request_id;
1055:
1056: p_from := 'fa_sorp_upg_cagf';
1057: p_where := ' where 1=1';
1058: p_order_by := 'order by category_name'; -- Bug#7632825
1059: P_REQUEST_WHERE := ' AND REQUEST_ID <> '||l_request_id;
1060:

Line 1295: INSERT INTO fa_sorp_upg_cagf

1291:
1292: CLOSE c_deprn_summary_cur;
1293: END IF;
1294:
1295: INSERT INTO fa_sorp_upg_cagf
1296: (book_type_code, asset_id, asset_number,
1297: asset_description,
1298: date_placed_in_service,
1299: category_name, current_cost,

Line 1328: open c_fa_sorp_upg_cagf_hist_cur;

1324: from fa_deprn_periods
1325: where book_type_code = P_FA_BOOK
1326: and period_close_date is null;
1327:
1328: open c_fa_sorp_upg_cagf_hist_cur;
1329: loop
1330: fetch c_fa_sorp_upg_cagf_hist_cur into v_fa_sorp_upg_cagf_hist_cur;
1331: exit when c_fa_sorp_upg_cagf_hist_cur%notfound;
1332:

Line 1330: fetch c_fa_sorp_upg_cagf_hist_cur into v_fa_sorp_upg_cagf_hist_cur;

1326: and period_close_date is null;
1327:
1328: open c_fa_sorp_upg_cagf_hist_cur;
1329: loop
1330: fetch c_fa_sorp_upg_cagf_hist_cur into v_fa_sorp_upg_cagf_hist_cur;
1331: exit when c_fa_sorp_upg_cagf_hist_cur%notfound;
1332:
1333: INSERT INTO fa_sorp_upg_cagf_hist
1334: (book_type_code,

Line 1331: exit when c_fa_sorp_upg_cagf_hist_cur%notfound;

1327:
1328: open c_fa_sorp_upg_cagf_hist_cur;
1329: loop
1330: fetch c_fa_sorp_upg_cagf_hist_cur into v_fa_sorp_upg_cagf_hist_cur;
1331: exit when c_fa_sorp_upg_cagf_hist_cur%notfound;
1332:
1333: INSERT INTO fa_sorp_upg_cagf_hist
1334: (book_type_code,
1335: asset_id,

Line 1333: INSERT INTO fa_sorp_upg_cagf_hist

1329: loop
1330: fetch c_fa_sorp_upg_cagf_hist_cur into v_fa_sorp_upg_cagf_hist_cur;
1331: exit when c_fa_sorp_upg_cagf_hist_cur%notfound;
1332:
1333: INSERT INTO fa_sorp_upg_cagf_hist
1334: (book_type_code,
1335: asset_id,
1336: asset_number,
1337: asset_description,

Line 1351: (v_fa_sorp_upg_cagf_hist_cur.book_type_code,

1347: report_mode,
1348: period_name
1349: )
1350: VALUES
1351: (v_fa_sorp_upg_cagf_hist_cur.book_type_code,
1352: v_fa_sorp_upg_cagf_hist_cur.asset_id,
1353: v_fa_sorp_upg_cagf_hist_cur.asset_number,
1354: v_fa_sorp_upg_cagf_hist_cur.asset_description,
1355: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,

Line 1352: v_fa_sorp_upg_cagf_hist_cur.asset_id,

1348: period_name
1349: )
1350: VALUES
1351: (v_fa_sorp_upg_cagf_hist_cur.book_type_code,
1352: v_fa_sorp_upg_cagf_hist_cur.asset_id,
1353: v_fa_sorp_upg_cagf_hist_cur.asset_number,
1354: v_fa_sorp_upg_cagf_hist_cur.asset_description,
1355: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,
1356: v_fa_sorp_upg_cagf_hist_cur.category_name,

Line 1353: v_fa_sorp_upg_cagf_hist_cur.asset_number,

1349: )
1350: VALUES
1351: (v_fa_sorp_upg_cagf_hist_cur.book_type_code,
1352: v_fa_sorp_upg_cagf_hist_cur.asset_id,
1353: v_fa_sorp_upg_cagf_hist_cur.asset_number,
1354: v_fa_sorp_upg_cagf_hist_cur.asset_description,
1355: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,
1356: v_fa_sorp_upg_cagf_hist_cur.category_name,
1357: v_fa_sorp_upg_cagf_hist_cur.current_cost,

Line 1354: v_fa_sorp_upg_cagf_hist_cur.asset_description,

1350: VALUES
1351: (v_fa_sorp_upg_cagf_hist_cur.book_type_code,
1352: v_fa_sorp_upg_cagf_hist_cur.asset_id,
1353: v_fa_sorp_upg_cagf_hist_cur.asset_number,
1354: v_fa_sorp_upg_cagf_hist_cur.asset_description,
1355: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,
1356: v_fa_sorp_upg_cagf_hist_cur.category_name,
1357: v_fa_sorp_upg_cagf_hist_cur.current_cost,
1358: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,

Line 1355: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,

1351: (v_fa_sorp_upg_cagf_hist_cur.book_type_code,
1352: v_fa_sorp_upg_cagf_hist_cur.asset_id,
1353: v_fa_sorp_upg_cagf_hist_cur.asset_number,
1354: v_fa_sorp_upg_cagf_hist_cur.asset_description,
1355: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,
1356: v_fa_sorp_upg_cagf_hist_cur.category_name,
1357: v_fa_sorp_upg_cagf_hist_cur.current_cost,
1358: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,
1359: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,

Line 1356: v_fa_sorp_upg_cagf_hist_cur.category_name,

1352: v_fa_sorp_upg_cagf_hist_cur.asset_id,
1353: v_fa_sorp_upg_cagf_hist_cur.asset_number,
1354: v_fa_sorp_upg_cagf_hist_cur.asset_description,
1355: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,
1356: v_fa_sorp_upg_cagf_hist_cur.category_name,
1357: v_fa_sorp_upg_cagf_hist_cur.current_cost,
1358: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,
1359: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,
1360: v_fa_sorp_upg_cagf_hist_cur.impairment_reserve,

Line 1357: v_fa_sorp_upg_cagf_hist_cur.current_cost,

1353: v_fa_sorp_upg_cagf_hist_cur.asset_number,
1354: v_fa_sorp_upg_cagf_hist_cur.asset_description,
1355: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,
1356: v_fa_sorp_upg_cagf_hist_cur.category_name,
1357: v_fa_sorp_upg_cagf_hist_cur.current_cost,
1358: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,
1359: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,
1360: v_fa_sorp_upg_cagf_hist_cur.impairment_reserve,
1361: v_fa_sorp_upg_cagf_hist_cur.capital_adjustment_acct_amount,

Line 1358: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,

1354: v_fa_sorp_upg_cagf_hist_cur.asset_description,
1355: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,
1356: v_fa_sorp_upg_cagf_hist_cur.category_name,
1357: v_fa_sorp_upg_cagf_hist_cur.current_cost,
1358: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,
1359: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,
1360: v_fa_sorp_upg_cagf_hist_cur.impairment_reserve,
1361: v_fa_sorp_upg_cagf_hist_cur.capital_adjustment_acct_amount,
1362: v_fa_sorp_upg_cagf_hist_cur.general_fund_acct_amount,

Line 1359: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,

1355: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,
1356: v_fa_sorp_upg_cagf_hist_cur.category_name,
1357: v_fa_sorp_upg_cagf_hist_cur.current_cost,
1358: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,
1359: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,
1360: v_fa_sorp_upg_cagf_hist_cur.impairment_reserve,
1361: v_fa_sorp_upg_cagf_hist_cur.capital_adjustment_acct_amount,
1362: v_fa_sorp_upg_cagf_hist_cur.general_fund_acct_amount,
1363: l_request_id,

Line 1360: v_fa_sorp_upg_cagf_hist_cur.impairment_reserve,

1356: v_fa_sorp_upg_cagf_hist_cur.category_name,
1357: v_fa_sorp_upg_cagf_hist_cur.current_cost,
1358: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,
1359: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,
1360: v_fa_sorp_upg_cagf_hist_cur.impairment_reserve,
1361: v_fa_sorp_upg_cagf_hist_cur.capital_adjustment_acct_amount,
1362: v_fa_sorp_upg_cagf_hist_cur.general_fund_acct_amount,
1363: l_request_id,
1364: p_mode,

Line 1361: v_fa_sorp_upg_cagf_hist_cur.capital_adjustment_acct_amount,

1357: v_fa_sorp_upg_cagf_hist_cur.current_cost,
1358: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,
1359: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,
1360: v_fa_sorp_upg_cagf_hist_cur.impairment_reserve,
1361: v_fa_sorp_upg_cagf_hist_cur.capital_adjustment_acct_amount,
1362: v_fa_sorp_upg_cagf_hist_cur.general_fund_acct_amount,
1363: l_request_id,
1364: p_mode,
1365: v_period_name);

Line 1362: v_fa_sorp_upg_cagf_hist_cur.general_fund_acct_amount,

1358: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,
1359: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,
1360: v_fa_sorp_upg_cagf_hist_cur.impairment_reserve,
1361: v_fa_sorp_upg_cagf_hist_cur.capital_adjustment_acct_amount,
1362: v_fa_sorp_upg_cagf_hist_cur.general_fund_acct_amount,
1363: l_request_id,
1364: p_mode,
1365: v_period_name);
1366: end loop;

Line 1367: close c_fa_sorp_upg_cagf_hist_cur;

1363: l_request_id,
1364: p_mode,
1365: v_period_name);
1366: end loop;
1367: close c_fa_sorp_upg_cagf_hist_cur;
1368:
1369: END IF;
1370:
1371:

Line 1379: END fa_sorp_upg_cagf_mc_fn;

1375: WHEN OTHERS
1376: THEN
1377: ROLLBACK;
1378: RETURN FALSE;
1379: END fa_sorp_upg_cagf_mc_fn;
1380:
1381: FUNCTION fa_sorp_upg_cagf_fn (p_book_type_code VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1382: RETURN BOOLEAN
1383: IS

Line 1381: FUNCTION fa_sorp_upg_cagf_fn (p_book_type_code VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

1377: ROLLBACK;
1378: RETURN FALSE;
1379: END fa_sorp_upg_cagf_mc_fn;
1380:
1381: FUNCTION fa_sorp_upg_cagf_fn (p_book_type_code VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1382: RETURN BOOLEAN
1383: IS
1384: l_deprn_rsv NUMBER;
1385: l_impairment_rsv NUMBER;

Line 1438: cursor c_fa_sorp_upg_cagf_hist_cur is

1434: ORDER BY period_counter;
1435:
1436: v_deprn_summary_cur c_deprn_summary_cur%ROWTYPE;
1437:
1438: cursor c_fa_sorp_upg_cagf_hist_cur is
1439: select book_type_code ,
1440: asset_id,
1441: asset_number ,
1442: asset_description,

Line 1451: from fa_sorp_upg_cagf;

1447: revaluation_reserve,
1448: impairment_reserve,
1449: capital_adjustment_acct_amount,
1450: general_fund_acct_amount
1451: from fa_sorp_upg_cagf;
1452:
1453: v_fa_sorp_upg_cagf_hist_cur c_fa_sorp_upg_cagf_hist_cur%rowtype;
1454:
1455: l_request_id number;

Line 1453: v_fa_sorp_upg_cagf_hist_cur c_fa_sorp_upg_cagf_hist_cur%rowtype;

1449: capital_adjustment_acct_amount,
1450: general_fund_acct_amount
1451: from fa_sorp_upg_cagf;
1452:
1453: v_fa_sorp_upg_cagf_hist_cur c_fa_sorp_upg_cagf_hist_cur%rowtype;
1454:
1455: l_request_id number;
1456: v_final_cnt number;
1457: v_period_name varchar2(25);

Line 1475: fa_debug_pkg.add('fa_sorp_upg_cagf_fn', 'process calculation', 'BEGINs', p_log_level_rec => p_log_level_rec);

1471: BEGIN
1472:
1473: fa_srvr_msg.Init_Server_Message; -- Initialize server message stack
1474: fa_debug_pkg.Initialize; -- Initialize debug message stack
1475: fa_debug_pkg.add('fa_sorp_upg_cagf_fn', 'process calculation', 'BEGINs', p_log_level_rec => p_log_level_rec);
1476:
1477:
1478: DELETE FROM fa_sorp_upg_cagf;
1479:

Line 1478: DELETE FROM fa_sorp_upg_cagf;

1474: fa_debug_pkg.Initialize; -- Initialize debug message stack
1475: fa_debug_pkg.add('fa_sorp_upg_cagf_fn', 'process calculation', 'BEGINs', p_log_level_rec => p_log_level_rec);
1476:
1477:
1478: DELETE FROM fa_sorp_upg_cagf;
1479:
1480: COMMIT;
1481:
1482: l_request_id := fnd_global.conc_request_id;

Line 1484: p_from := 'fa_sorp_upg_cagf';

1480: COMMIT;
1481:
1482: l_request_id := fnd_global.conc_request_id;
1483:
1484: p_from := 'fa_sorp_upg_cagf';
1485: p_where := ' where 1=1';
1486: p_order_by := 'order by category_name'; -- Bug#7632825
1487: P_REQUEST_WHERE := ' AND REQUEST_ID <> '||l_request_id;
1488:

Line 1492: from fa_sorp_upg_cagf_hist

1488:
1489:
1490:
1491: select count(1) into v_final_cnt
1492: from fa_sorp_upg_cagf_hist
1493: where book_type_code = p_book_type_code
1494: and report_mode = p_mode;
1495:
1496: IF v_final_cnt = 0 then

Line 1714: INSERT INTO fa_sorp_upg_cagf

1710:
1711: CLOSE c_deprn_summary_cur;
1712: END IF;
1713:
1714: INSERT INTO fa_sorp_upg_cagf
1715: (book_type_code, asset_id, asset_number,
1716: asset_description,
1717: date_placed_in_service,
1718: category_name, current_cost,

Line 1747: open c_fa_sorp_upg_cagf_hist_cur;

1743: from fa_deprn_periods
1744: where book_type_code = P_FA_BOOK
1745: and period_close_date is null;
1746:
1747: open c_fa_sorp_upg_cagf_hist_cur;
1748: loop
1749: fetch c_fa_sorp_upg_cagf_hist_cur into v_fa_sorp_upg_cagf_hist_cur;
1750: exit when c_fa_sorp_upg_cagf_hist_cur%notfound;
1751:

Line 1749: fetch c_fa_sorp_upg_cagf_hist_cur into v_fa_sorp_upg_cagf_hist_cur;

1745: and period_close_date is null;
1746:
1747: open c_fa_sorp_upg_cagf_hist_cur;
1748: loop
1749: fetch c_fa_sorp_upg_cagf_hist_cur into v_fa_sorp_upg_cagf_hist_cur;
1750: exit when c_fa_sorp_upg_cagf_hist_cur%notfound;
1751:
1752: INSERT INTO fa_sorp_upg_cagf_hist
1753: (book_type_code,

Line 1750: exit when c_fa_sorp_upg_cagf_hist_cur%notfound;

1746:
1747: open c_fa_sorp_upg_cagf_hist_cur;
1748: loop
1749: fetch c_fa_sorp_upg_cagf_hist_cur into v_fa_sorp_upg_cagf_hist_cur;
1750: exit when c_fa_sorp_upg_cagf_hist_cur%notfound;
1751:
1752: INSERT INTO fa_sorp_upg_cagf_hist
1753: (book_type_code,
1754: asset_id,

Line 1752: INSERT INTO fa_sorp_upg_cagf_hist

1748: loop
1749: fetch c_fa_sorp_upg_cagf_hist_cur into v_fa_sorp_upg_cagf_hist_cur;
1750: exit when c_fa_sorp_upg_cagf_hist_cur%notfound;
1751:
1752: INSERT INTO fa_sorp_upg_cagf_hist
1753: (book_type_code,
1754: asset_id,
1755: asset_number,
1756: asset_description,

Line 1770: (v_fa_sorp_upg_cagf_hist_cur.book_type_code,

1766: report_mode,
1767: period_name
1768: )
1769: VALUES
1770: (v_fa_sorp_upg_cagf_hist_cur.book_type_code,
1771: v_fa_sorp_upg_cagf_hist_cur.asset_id,
1772: v_fa_sorp_upg_cagf_hist_cur.asset_number,
1773: v_fa_sorp_upg_cagf_hist_cur.asset_description,
1774: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,

Line 1771: v_fa_sorp_upg_cagf_hist_cur.asset_id,

1767: period_name
1768: )
1769: VALUES
1770: (v_fa_sorp_upg_cagf_hist_cur.book_type_code,
1771: v_fa_sorp_upg_cagf_hist_cur.asset_id,
1772: v_fa_sorp_upg_cagf_hist_cur.asset_number,
1773: v_fa_sorp_upg_cagf_hist_cur.asset_description,
1774: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,
1775: v_fa_sorp_upg_cagf_hist_cur.category_name,

Line 1772: v_fa_sorp_upg_cagf_hist_cur.asset_number,

1768: )
1769: VALUES
1770: (v_fa_sorp_upg_cagf_hist_cur.book_type_code,
1771: v_fa_sorp_upg_cagf_hist_cur.asset_id,
1772: v_fa_sorp_upg_cagf_hist_cur.asset_number,
1773: v_fa_sorp_upg_cagf_hist_cur.asset_description,
1774: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,
1775: v_fa_sorp_upg_cagf_hist_cur.category_name,
1776: v_fa_sorp_upg_cagf_hist_cur.current_cost,

Line 1773: v_fa_sorp_upg_cagf_hist_cur.asset_description,

1769: VALUES
1770: (v_fa_sorp_upg_cagf_hist_cur.book_type_code,
1771: v_fa_sorp_upg_cagf_hist_cur.asset_id,
1772: v_fa_sorp_upg_cagf_hist_cur.asset_number,
1773: v_fa_sorp_upg_cagf_hist_cur.asset_description,
1774: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,
1775: v_fa_sorp_upg_cagf_hist_cur.category_name,
1776: v_fa_sorp_upg_cagf_hist_cur.current_cost,
1777: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,

Line 1774: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,

1770: (v_fa_sorp_upg_cagf_hist_cur.book_type_code,
1771: v_fa_sorp_upg_cagf_hist_cur.asset_id,
1772: v_fa_sorp_upg_cagf_hist_cur.asset_number,
1773: v_fa_sorp_upg_cagf_hist_cur.asset_description,
1774: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,
1775: v_fa_sorp_upg_cagf_hist_cur.category_name,
1776: v_fa_sorp_upg_cagf_hist_cur.current_cost,
1777: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,
1778: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,

Line 1775: v_fa_sorp_upg_cagf_hist_cur.category_name,

1771: v_fa_sorp_upg_cagf_hist_cur.asset_id,
1772: v_fa_sorp_upg_cagf_hist_cur.asset_number,
1773: v_fa_sorp_upg_cagf_hist_cur.asset_description,
1774: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,
1775: v_fa_sorp_upg_cagf_hist_cur.category_name,
1776: v_fa_sorp_upg_cagf_hist_cur.current_cost,
1777: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,
1778: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,
1779: v_fa_sorp_upg_cagf_hist_cur.impairment_reserve,

Line 1776: v_fa_sorp_upg_cagf_hist_cur.current_cost,

1772: v_fa_sorp_upg_cagf_hist_cur.asset_number,
1773: v_fa_sorp_upg_cagf_hist_cur.asset_description,
1774: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,
1775: v_fa_sorp_upg_cagf_hist_cur.category_name,
1776: v_fa_sorp_upg_cagf_hist_cur.current_cost,
1777: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,
1778: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,
1779: v_fa_sorp_upg_cagf_hist_cur.impairment_reserve,
1780: v_fa_sorp_upg_cagf_hist_cur.capital_adjustment_acct_amount,

Line 1777: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,

1773: v_fa_sorp_upg_cagf_hist_cur.asset_description,
1774: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,
1775: v_fa_sorp_upg_cagf_hist_cur.category_name,
1776: v_fa_sorp_upg_cagf_hist_cur.current_cost,
1777: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,
1778: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,
1779: v_fa_sorp_upg_cagf_hist_cur.impairment_reserve,
1780: v_fa_sorp_upg_cagf_hist_cur.capital_adjustment_acct_amount,
1781: v_fa_sorp_upg_cagf_hist_cur.general_fund_acct_amount,

Line 1778: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,

1774: v_fa_sorp_upg_cagf_hist_cur.date_placed_in_service,
1775: v_fa_sorp_upg_cagf_hist_cur.category_name,
1776: v_fa_sorp_upg_cagf_hist_cur.current_cost,
1777: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,
1778: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,
1779: v_fa_sorp_upg_cagf_hist_cur.impairment_reserve,
1780: v_fa_sorp_upg_cagf_hist_cur.capital_adjustment_acct_amount,
1781: v_fa_sorp_upg_cagf_hist_cur.general_fund_acct_amount,
1782: l_request_id,

Line 1779: v_fa_sorp_upg_cagf_hist_cur.impairment_reserve,

1775: v_fa_sorp_upg_cagf_hist_cur.category_name,
1776: v_fa_sorp_upg_cagf_hist_cur.current_cost,
1777: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,
1778: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,
1779: v_fa_sorp_upg_cagf_hist_cur.impairment_reserve,
1780: v_fa_sorp_upg_cagf_hist_cur.capital_adjustment_acct_amount,
1781: v_fa_sorp_upg_cagf_hist_cur.general_fund_acct_amount,
1782: l_request_id,
1783: p_mode,

Line 1780: v_fa_sorp_upg_cagf_hist_cur.capital_adjustment_acct_amount,

1776: v_fa_sorp_upg_cagf_hist_cur.current_cost,
1777: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,
1778: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,
1779: v_fa_sorp_upg_cagf_hist_cur.impairment_reserve,
1780: v_fa_sorp_upg_cagf_hist_cur.capital_adjustment_acct_amount,
1781: v_fa_sorp_upg_cagf_hist_cur.general_fund_acct_amount,
1782: l_request_id,
1783: p_mode,
1784: v_period_name);

Line 1781: v_fa_sorp_upg_cagf_hist_cur.general_fund_acct_amount,

1777: v_fa_sorp_upg_cagf_hist_cur.depriciation_reserve,
1778: v_fa_sorp_upg_cagf_hist_cur.revaluation_reserve,
1779: v_fa_sorp_upg_cagf_hist_cur.impairment_reserve,
1780: v_fa_sorp_upg_cagf_hist_cur.capital_adjustment_acct_amount,
1781: v_fa_sorp_upg_cagf_hist_cur.general_fund_acct_amount,
1782: l_request_id,
1783: p_mode,
1784: v_period_name);
1785: end loop;

Line 1786: close c_fa_sorp_upg_cagf_hist_cur;

1782: l_request_id,
1783: p_mode,
1784: v_period_name);
1785: end loop;
1786: close c_fa_sorp_upg_cagf_hist_cur;
1787:
1788: END IF;
1789:
1790: COMMIT;

Line 1793: V_BOOLEAN := fa_sorp_upg_cagf_MC_FN(p_book_type_code,P_MODE);

1789:
1790: COMMIT;
1791:
1792: IF fa_sorp_upg_mc_flag(p_book_type_code) THEN
1793: V_BOOLEAN := fa_sorp_upg_cagf_MC_FN(p_book_type_code,P_MODE);
1794: IF V_BOOLEAN THEN RETURN TRUE;
1795: ELSE RETURN FALSE;
1796: END IF;
1797:

Line 1801: p_from := 'fa_sorp_upg_cagf_hist';

1797:
1798: END IF;
1799:
1800: ELSE -- v_final_cnt = 0
1801: p_from := 'fa_sorp_upg_cagf_hist';
1802: p_where := ' where book_type_code = '||''''||p_book_type_code||''''||' and report_mode ='||''''||p_mode||'''';
1803: END IF;
1804:
1805: RETURN TRUE;

Line 1812: END fa_sorp_upg_cagf_fn;

1808: WHEN OTHERS
1809: THEN
1810: ROLLBACK;
1811: RETURN FALSE;
1812: END fa_sorp_upg_cagf_fn;
1813:
1814: FUNCTION fa_sorp_upg_impreval_mc_fn(p_book VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1815: RETURN BOOLEAN
1816: IS