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 570: IGI_IAC_ADJUSTMENTS_PKG.insert_row (

566: and asset_id = fp_det_balances.asset_id
567: and distribution_id = fp_det_balances.distribution_id
568: ;
569:
570: IGI_IAC_ADJUSTMENTS_PKG.insert_row (
571: x_rowid => l_rowid,
572: x_adjustment_id => fp_det_balances.adjustment_id,
573: x_book_type_code => fp_det_balances.book_type_code,
574: x_code_combination_id => l_ccid,

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

1522: FROM fa_additions
1523: WHERE asset_id=l_asset_hdr_rec.asset_id;
1524:
1525: /* get the closing det balances record */
1526: CURSOR c_closing_det_balances( p_old_dist IGI_IAC_ADJUSTMENTS.distribution_id%TYPE,
1527: p_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE)IS
1528: SELECT *
1529: FROM igi_iac_det_balances
1530: WHERE asset_id=l_asset_hdr_rec.asset_id

Line 1527: p_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE)IS

1523: WHERE asset_id=l_asset_hdr_rec.asset_id;
1524:
1525: /* get the closing det balances record */
1526: CURSOR c_closing_det_balances( p_old_dist IGI_IAC_ADJUSTMENTS.distribution_id%TYPE,
1527: p_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE)IS
1528: SELECT *
1529: FROM igi_iac_det_balances
1530: WHERE asset_id=l_asset_hdr_rec.asset_id
1531: AND book_type_code = l_asset_hdr_rec.book_type_code

Line 1571: l_adj_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;

1567: l_prd_rec IGI_IAC_TYPES.prd_rec;
1568: l_prd_rec_prior IGI_IAC_TYPES.prd_rec;
1569:
1570: l_prev_data c_prev_data%ROWTYPE;
1571: l_adj_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;
1572: l_current_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;
1573: l_start_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;
1574:
1575: l_asset_num FA_ADDITIONS.asset_number%TYPE;

Line 1590: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

1586: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1587: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;
1588: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;
1589: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;
1590: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1591: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1592: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1593: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1594: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

Line 1591: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

1587: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;
1588: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;
1589: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;
1590: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1591: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1592: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1593: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1594: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1595: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;

Line 1592: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

1588: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;
1589: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;
1590: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1591: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1592: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1593: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1594: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1595: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;
1596: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;

Line 1593: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

1589: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;
1590: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1591: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1592: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1593: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1594: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1595: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;
1596: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;
1597: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;

Line 1594: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

1590: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1591: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1592: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1593: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1594: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1595: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;
1596: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;
1597: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1598: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

Line 1598: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

1594: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1595: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;
1596: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;
1597: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1598: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1599: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
1600: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;
1601: l_get_all_prev_dist get_all_prev_inactive_dist%ROWTYPE;
1602:

Line 1600: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;

1596: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;
1597: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1598: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1599: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
1600: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;
1601: l_get_all_prev_dist get_all_prev_inactive_dist%ROWTYPE;
1602:
1603: l_rowid ROWID;
1604: l_return_value BOOLEAN;

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

1830: l_closing_det_balances.distribution_id ,
1831: l_adjustment_id_out );
1832: FETCH c_get_deprn_dist INTO l_get_deprn_dist;
1833: IF c_get_deprn_dist%FOUND THEN
1834: -- Call to TBH for insert into IGI_IAC_ADJUSTMENTS
1835: IGI_IAC_FA_DEPRN_PKG.insert_row(
1836: x_rowid =>l_rowid,
1837: x_adjustment_id =>l_adj_id,
1838: x_book_type_code =>l_asset_hdr_rec.book_type_code,

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

1887: l_old_dist.distribution_id ,
1888: l_adjustment_id_out );
1889: FETCH c_get_deprn_dist INTO l_get_deprn_dist;
1890: IF c_get_deprn_dist%FOUND THEN
1891: /* Call to TBH for insert into IGI_IAC_ADJUSTMENTS */
1892: IGI_IAC_FA_DEPRN_PKG.insert_row(
1893: x_rowid =>l_rowid,
1894: x_adjustment_id =>l_adj_id,
1895: x_book_type_code =>l_asset_hdr_rec.book_type_code,

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

1968: l_get_all_prev_dist.distribution_id ,
1969: l_adjustment_id_out );
1970: Fetch c_get_deprn_dist into l_get_deprn_dist;
1971: IF c_get_deprn_dist%FOUND THEN
1972: /* Call to TBH for insert into IGI_IAC_ADJUSTMENTS */
1973: IGI_IAC_FA_DEPRN_PKG.insert_row(
1974: x_rowid =>l_rowid,
1975: x_adjustment_id =>l_adj_id,
1976: x_book_type_code =>l_asset_hdr_rec.book_type_code,

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

2201: FROM fa_additions
2202: WHERE asset_id=l_asset_hdr_rec.asset_id;
2203:
2204: /* get the closing det balances record */
2205: CURSOR c_closing_det_balances( p_old_dist IGI_IAC_ADJUSTMENTS.distribution_id%type,
2206: p_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type)is
2207: SELECT *
2208: FROM igi_iac_det_balances
2209: WHERE asset_id=l_asset_hdr_rec.asset_id

Line 2206: p_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type)is

2202: WHERE asset_id=l_asset_hdr_rec.asset_id;
2203:
2204: /* get the closing det balances record */
2205: CURSOR c_closing_det_balances( p_old_dist IGI_IAC_ADJUSTMENTS.distribution_id%type,
2206: p_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type)is
2207: SELECT *
2208: FROM igi_iac_det_balances
2209: WHERE asset_id=l_asset_hdr_rec.asset_id
2210: AND book_type_code = l_asset_hdr_rec.book_type_code

Line 2249: l_adj_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;

2245: l_prd_rec IGI_IAC_TYPES.prd_rec;
2246: l_prd_rec_prior IGI_IAC_TYPES.prd_rec;
2247:
2248: l_prev_data c_prev_data%rowtype;
2249: l_adj_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;
2250: l_current_period_counter FA_DEPRN_PERIODS.period_counter%type;
2251: l_start_period_counter FA_DEPRN_PERIODS.period_counter%type;
2252:
2253: l_asset_num FA_ADDITIONS.asset_number%type;

Line 2268: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

2264: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2265: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
2266: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
2267: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
2268: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2269: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2270: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2271: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2272: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

Line 2269: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

2265: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
2266: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
2267: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
2268: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2269: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2270: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2271: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2272: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2273: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;

Line 2270: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

2266: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
2267: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
2268: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2269: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2270: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2271: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2272: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2273: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;
2274: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;

Line 2271: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

2267: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
2268: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2269: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2270: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2271: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2272: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2273: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;
2274: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2275: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;

Line 2272: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

2268: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2269: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2270: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2271: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2272: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2273: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;
2274: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2275: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;
2276: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

Line 2276: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

2272: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2273: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;
2274: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2275: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;
2276: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2277: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
2278: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;
2279: l_get_all_prev_dist get_all_prev_inactive_dist%ROWTYPE;
2280:

Line 2278: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;

2274: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2275: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;
2276: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2277: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
2278: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;
2279: l_get_all_prev_dist get_all_prev_inactive_dist%ROWTYPE;
2280:
2281: l_rowid rowid;
2282: l_return_value boolean;

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

2555: l_closing_det_balances.distribution_id ,
2556: l_adjustment_id_out );
2557: Fetch c_get_deprn_dist into l_get_deprn_dist;
2558: IF c_get_deprn_dist%FOUND THEN
2559: /* Call to TBH for insert into IGI_IAC_ADJUSTMENTS */
2560: IGI_IAC_FA_DEPRN_PKG.insert_row(
2561: x_rowid =>l_rowid,
2562: x_adjustment_id =>l_adj_id,
2563: x_book_type_code =>l_asset_hdr_rec.book_type_code,

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

2689: l_old_dist.distribution_id ,
2690: l_adjustment_id_out );
2691: Fetch c_get_deprn_dist into l_get_deprn_dist;
2692: IF c_get_deprn_dist%FOUND THEN
2693: /* Call to TBH for insert into IGI_IAC_ADJUSTMENTS */
2694: IGI_IAC_FA_DEPRN_PKG.insert_row(
2695: x_rowid =>l_rowid,
2696: x_adjustment_id =>l_adj_id,
2697: x_book_type_code =>l_asset_hdr_rec.book_type_code,

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

2840: l_get_all_prev_dist.distribution_id ,
2841: l_adjustment_id_out );
2842: Fetch c_get_deprn_dist into l_get_deprn_dist;
2843: IF c_get_deprn_dist%FOUND THEN
2844: /* Call to TBH for insert into IGI_IAC_ADJUSTMENTS */
2845: IGI_IAC_FA_DEPRN_PKG.insert_row(
2846: x_rowid =>l_rowid,
2847: x_adjustment_id =>l_adj_id,
2848: x_book_type_code =>l_asset_hdr_rec.book_type_code,

Line 3613: UPDATE IGI_IAC_ADJUSTMENTS

3609: END IF;
3610:
3611: -- Code added by Venkat Gadde
3612: BEGIN
3613: UPDATE IGI_IAC_ADJUSTMENTS
3614: SET EVENT_ID = P_EVENT_ID
3615: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
3616: AND ASSET_ID = P_ASSET_ID
3617: AND PERIOD_COUNTER = l_open_period.period_counter