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.IGI_IAC_RECLASS_PKG dependencies on IGI_IAC_ADJUSTMENTS

Line 537: IGI_IAC_ADJUSTMENTS_PKG.insert_row (

533: and asset_id = fp_det_balances.asset_id
534: and distribution_id = fp_det_balances.distribution_id
535: ;
536:
537: IGI_IAC_ADJUSTMENTS_PKG.insert_row (
538: x_rowid => l_rowid,
539: x_adjustment_id => fp_det_balances.adjustment_id,
540: x_book_type_code => fp_det_balances.book_type_code,
541: x_code_combination_id => l_ccid,

Line 1493: CURSOR c_closing_det_balances( p_old_dist IGI_IAC_ADJUSTMENTS.distribution_id%TYPE,

1489: FROM fa_additions
1490: WHERE asset_id=l_asset_hdr_rec.asset_id;
1491:
1492: /* get the closing det balances record */
1493: CURSOR c_closing_det_balances( p_old_dist IGI_IAC_ADJUSTMENTS.distribution_id%TYPE,
1494: p_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE)IS
1495: SELECT *
1496: FROM igi_iac_det_balances
1497: WHERE asset_id=l_asset_hdr_rec.asset_id

Line 1494: p_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE)IS

1490: WHERE asset_id=l_asset_hdr_rec.asset_id;
1491:
1492: /* get the closing det balances record */
1493: CURSOR c_closing_det_balances( p_old_dist IGI_IAC_ADJUSTMENTS.distribution_id%TYPE,
1494: p_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE)IS
1495: SELECT *
1496: FROM igi_iac_det_balances
1497: WHERE asset_id=l_asset_hdr_rec.asset_id
1498: AND book_type_code = l_asset_hdr_rec.book_type_code

Line 1538: l_adj_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;

1534: l_prd_rec IGI_IAC_TYPES.prd_rec;
1535: l_prd_rec_prior IGI_IAC_TYPES.prd_rec;
1536:
1537: l_prev_data c_prev_data%ROWTYPE;
1538: l_adj_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;
1539: l_current_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;
1540: l_start_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;
1541:
1542: l_asset_num FA_ADDITIONS.asset_number%TYPE;

Line 1557: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

1553: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1554: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;
1555: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;
1556: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;
1557: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1558: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1559: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1560: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1561: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

Line 1558: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

1554: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;
1555: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;
1556: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;
1557: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1558: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1559: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1560: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1561: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1562: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;

Line 1559: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

1555: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;
1556: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;
1557: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1558: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1559: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1560: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1561: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1562: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;
1563: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;

Line 1560: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

1556: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;
1557: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1558: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1559: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1560: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1561: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1562: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;
1563: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;
1564: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;

Line 1561: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

1557: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1558: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1559: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1560: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1561: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1562: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;
1563: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;
1564: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1565: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

Line 1565: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

1561: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1562: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;
1563: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;
1564: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1565: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1566: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
1567: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;
1568: l_get_all_prev_dist get_all_prev_inactive_dist%ROWTYPE;
1569:

Line 1567: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;

1563: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;
1564: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1565: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1566: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
1567: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;
1568: l_get_all_prev_dist get_all_prev_inactive_dist%ROWTYPE;
1569:
1570: l_rowid ROWID;
1571: l_return_value BOOLEAN;

Line 1801: -- Call to TBH for insert into IGI_IAC_ADJUSTMENTS

1797: l_closing_det_balances.distribution_id ,
1798: l_adjustment_id_out );
1799: FETCH c_get_deprn_dist INTO l_get_deprn_dist;
1800: IF c_get_deprn_dist%FOUND THEN
1801: -- Call to TBH for insert into IGI_IAC_ADJUSTMENTS
1802: IGI_IAC_FA_DEPRN_PKG.insert_row(
1803: x_rowid =>l_rowid,
1804: x_adjustment_id =>l_adj_id,
1805: x_book_type_code =>l_asset_hdr_rec.book_type_code,

Line 1858: /* Call to TBH for insert into IGI_IAC_ADJUSTMENTS */

1854: l_old_dist.distribution_id ,
1855: l_adjustment_id_out );
1856: FETCH c_get_deprn_dist INTO l_get_deprn_dist;
1857: IF c_get_deprn_dist%FOUND THEN
1858: /* Call to TBH for insert into IGI_IAC_ADJUSTMENTS */
1859: IGI_IAC_FA_DEPRN_PKG.insert_row(
1860: x_rowid =>l_rowid,
1861: x_adjustment_id =>l_adj_id,
1862: x_book_type_code =>l_asset_hdr_rec.book_type_code,

Line 1939: /* Call to TBH for insert into IGI_IAC_ADJUSTMENTS */

1935: l_get_all_prev_dist.distribution_id ,
1936: l_adjustment_id_out );
1937: Fetch c_get_deprn_dist into l_get_deprn_dist;
1938: IF c_get_deprn_dist%FOUND THEN
1939: /* Call to TBH for insert into IGI_IAC_ADJUSTMENTS */
1940: IGI_IAC_FA_DEPRN_PKG.insert_row(
1941: x_rowid =>l_rowid,
1942: x_adjustment_id =>l_adj_id,
1943: x_book_type_code =>l_asset_hdr_rec.book_type_code,

Line 2172: CURSOR c_closing_det_balances( p_old_dist IGI_IAC_ADJUSTMENTS.distribution_id%type,

2168: FROM fa_additions
2169: WHERE asset_id=l_asset_hdr_rec.asset_id;
2170:
2171: /* get the closing det balances record */
2172: CURSOR c_closing_det_balances( p_old_dist IGI_IAC_ADJUSTMENTS.distribution_id%type,
2173: p_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type)is
2174: SELECT *
2175: FROM igi_iac_det_balances
2176: WHERE asset_id=l_asset_hdr_rec.asset_id

Line 2173: p_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type)is

2169: WHERE asset_id=l_asset_hdr_rec.asset_id;
2170:
2171: /* get the closing det balances record */
2172: CURSOR c_closing_det_balances( p_old_dist IGI_IAC_ADJUSTMENTS.distribution_id%type,
2173: p_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type)is
2174: SELECT *
2175: FROM igi_iac_det_balances
2176: WHERE asset_id=l_asset_hdr_rec.asset_id
2177: AND book_type_code = l_asset_hdr_rec.book_type_code

Line 2216: l_adj_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;

2212: l_prd_rec IGI_IAC_TYPES.prd_rec;
2213: l_prd_rec_prior IGI_IAC_TYPES.prd_rec;
2214:
2215: l_prev_data c_prev_data%rowtype;
2216: l_adj_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;
2217: l_current_period_counter FA_DEPRN_PERIODS.period_counter%type;
2218: l_start_period_counter FA_DEPRN_PERIODS.period_counter%type;
2219:
2220: l_asset_num FA_ADDITIONS.asset_number%type;

Line 2235: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

2231: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2232: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
2233: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
2234: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
2235: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2236: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2237: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2238: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2239: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

Line 2236: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

2232: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
2233: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
2234: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
2235: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2236: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2237: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2238: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2239: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2240: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;

Line 2237: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

2233: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
2234: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
2235: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2236: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2237: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2238: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2239: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2240: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;
2241: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;

Line 2238: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

2234: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
2235: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2236: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2237: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2238: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2239: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2240: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;
2241: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2242: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;

Line 2239: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

2235: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2236: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2237: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2238: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2239: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2240: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;
2241: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2242: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;
2243: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

Line 2243: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

2239: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2240: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;
2241: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2242: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;
2243: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2244: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
2245: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;
2246: l_get_all_prev_dist get_all_prev_inactive_dist%ROWTYPE;
2247:

Line 2245: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;

2241: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2242: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;
2243: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2244: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
2245: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;
2246: l_get_all_prev_dist get_all_prev_inactive_dist%ROWTYPE;
2247:
2248: l_rowid rowid;
2249: l_return_value boolean;

Line 2526: /* Call to TBH for insert into IGI_IAC_ADJUSTMENTS */

2522: l_closing_det_balances.distribution_id ,
2523: l_adjustment_id_out );
2524: Fetch c_get_deprn_dist into l_get_deprn_dist;
2525: IF c_get_deprn_dist%FOUND THEN
2526: /* Call to TBH for insert into IGI_IAC_ADJUSTMENTS */
2527: IGI_IAC_FA_DEPRN_PKG.insert_row(
2528: x_rowid =>l_rowid,
2529: x_adjustment_id =>l_adj_id,
2530: x_book_type_code =>l_asset_hdr_rec.book_type_code,

Line 2660: /* Call to TBH for insert into IGI_IAC_ADJUSTMENTS */

2656: l_old_dist.distribution_id ,
2657: l_adjustment_id_out );
2658: Fetch c_get_deprn_dist into l_get_deprn_dist;
2659: IF c_get_deprn_dist%FOUND THEN
2660: /* Call to TBH for insert into IGI_IAC_ADJUSTMENTS */
2661: IGI_IAC_FA_DEPRN_PKG.insert_row(
2662: x_rowid =>l_rowid,
2663: x_adjustment_id =>l_adj_id,
2664: x_book_type_code =>l_asset_hdr_rec.book_type_code,

Line 2811: /* Call to TBH for insert into IGI_IAC_ADJUSTMENTS */

2807: l_get_all_prev_dist.distribution_id ,
2808: l_adjustment_id_out );
2809: Fetch c_get_deprn_dist into l_get_deprn_dist;
2810: IF c_get_deprn_dist%FOUND THEN
2811: /* Call to TBH for insert into IGI_IAC_ADJUSTMENTS */
2812: IGI_IAC_FA_DEPRN_PKG.insert_row(
2813: x_rowid =>l_rowid,
2814: x_adjustment_id =>l_adj_id,
2815: x_book_type_code =>l_asset_hdr_rec.book_type_code,

Line 3580: UPDATE IGI_IAC_ADJUSTMENTS

3576: END IF;
3577:
3578: -- Code added by Venkat Gadde
3579: BEGIN
3580: UPDATE IGI_IAC_ADJUSTMENTS
3581: SET EVENT_ID = P_EVENT_ID
3582: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
3583: AND ASSET_ID = P_ASSET_ID
3584: AND PERIOD_COUNTER = l_open_period.period_counter