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_HIST

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 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 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 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 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 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 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 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;