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_ADJ_COST_REVAL_PKG dependencies on IGI_IAC_ASSET_BALANCES

Line 371: CURSOR c_iac_asset_bal(cp_asset_id igi_iac_asset_balances.asset_id%TYPE,

367: IS
368: -- local cursors
369:
370: -- cursor to get iac asset balance information
371: CURSOR c_iac_asset_bal(cp_asset_id igi_iac_asset_balances.asset_id%TYPE,
372: cp_book_type_code igi_iac_asset_balances.book_type_code%TYPE,
373: cp_period_counter igi_iac_asset_balances.period_counter%TYPE)
374: IS
375: SELECT period_counter,

Line 372: cp_book_type_code igi_iac_asset_balances.book_type_code%TYPE,

368: -- local cursors
369:
370: -- cursor to get iac asset balance information
371: CURSOR c_iac_asset_bal(cp_asset_id igi_iac_asset_balances.asset_id%TYPE,
372: cp_book_type_code igi_iac_asset_balances.book_type_code%TYPE,
373: cp_period_counter igi_iac_asset_balances.period_counter%TYPE)
374: IS
375: SELECT period_counter,
376: net_book_value,

Line 373: cp_period_counter igi_iac_asset_balances.period_counter%TYPE)

369:
370: -- cursor to get iac asset balance information
371: CURSOR c_iac_asset_bal(cp_asset_id igi_iac_asset_balances.asset_id%TYPE,
372: cp_book_type_code igi_iac_asset_balances.book_type_code%TYPE,
373: cp_period_counter igi_iac_asset_balances.period_counter%TYPE)
374: IS
375: SELECT period_counter,
376: net_book_value,
377: adjusted_cost,

Line 387: FROM igi_iac_asset_balances

383: general_fund,
384: last_reval_date,
385: current_reval_factor,
386: cumulative_reval_factor
387: FROM igi_iac_asset_balances
388: WHERE asset_id = cp_asset_id
389: AND book_type_code = cp_book_type_code
390: AND period_counter = cp_period_counter;
391:

Line 475: l_iac_new_reval_cost igi_iac_asset_balances.adjusted_cost%TYPE;

471: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
472: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;
473: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
474: l_prd_rec IGI_IAC_TYPES.prd_rec;
475: l_iac_new_reval_cost igi_iac_asset_balances.adjusted_cost%TYPE;
476: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
477: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;
478: l_iac_new_op igi_iac_asset_balances.operating_acct%TYPE;
479:

Line 476: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;

472: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;
473: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
474: l_prd_rec IGI_IAC_TYPES.prd_rec;
475: l_iac_new_reval_cost igi_iac_asset_balances.adjusted_cost%TYPE;
476: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
477: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;
478: l_iac_new_op igi_iac_asset_balances.operating_acct%TYPE;
479:
480: l_diff_cost igi_iac_asset_balances.adjusted_cost%TYPE;

Line 477: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;

473: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
474: l_prd_rec IGI_IAC_TYPES.prd_rec;
475: l_iac_new_reval_cost igi_iac_asset_balances.adjusted_cost%TYPE;
476: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
477: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;
478: l_iac_new_op igi_iac_asset_balances.operating_acct%TYPE;
479:
480: l_diff_cost igi_iac_asset_balances.adjusted_cost%TYPE;
481: l_ret BOOLEAN;

Line 478: l_iac_new_op igi_iac_asset_balances.operating_acct%TYPE;

474: l_prd_rec IGI_IAC_TYPES.prd_rec;
475: l_iac_new_reval_cost igi_iac_asset_balances.adjusted_cost%TYPE;
476: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
477: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;
478: l_iac_new_op igi_iac_asset_balances.operating_acct%TYPE;
479:
480: l_diff_cost igi_iac_asset_balances.adjusted_cost%TYPE;
481: l_ret BOOLEAN;
482: l_det_table IGI_IAC_TYPES.dist_amt_tab;

Line 480: l_diff_cost igi_iac_asset_balances.adjusted_cost%TYPE;

476: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
477: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;
478: l_iac_new_op igi_iac_asset_balances.operating_acct%TYPE;
479:
480: l_diff_cost igi_iac_asset_balances.adjusted_cost%TYPE;
481: l_ret BOOLEAN;
482: l_det_table IGI_IAC_TYPES.dist_amt_tab;
483: l_det_bal c_det_bal%ROWTYPE;
484:

Line 613: the 'igi_iac_asset_balances' table, the cursor c_iac_asset_bal raises

609: a fully reserved asset and then a cost and life adjustment is made
610: in a single transaction. In this scenario, as the asset is not fully
611: reserved, the control passss to the ELSE condition. As there
612: is no entry corresponding to the latest period counter in
613: the 'igi_iac_asset_balances' table, the cursor c_iac_asset_bal raises
614: 'NO_DATA_FOUND' exception.
615:
616: IF (l_last_period_counter >= l_fully_rsvd_pc OR p_asset_iac_adj_info.depreciate_flag = 'NO') THEN
617: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 636: -- Fetch the latest IGI_IAC_ASSET_BALANCES for the asset regardless of type

632: p_string => 'asset is depreciable with life');
633: l_rsvd_pc := l_last_period_counter;
634: END IF;
635: */
636: -- Fetch the latest IGI_IAC_ASSET_BALANCES for the asset regardless of type
637: -- bug 3391000 start 1
638: /*OPEN c_iac_asset_bal(l_asset_id,
639: l_book_type_code,
640: l_rsvd_pc);

Line 647: -- Fetch the latest IGI_IAC_ASSET_BALANCES for the asset regardless of type

643: RAISE NO_DATA_FOUND ;
644: END IF ;
645: CLOSE c_iac_asset_bal; */
646:
647: -- Fetch the latest IGI_IAC_ASSET_BALANCES for the asset regardless of type
648: -- if a balance row exists for the latest open period counter then retrieve
649: -- that else, retrieve the last active row
650:
651: --bug# 7609363 modification begins

Line 735: -- igi_iac_asset_balances

731: p_full_path => l_path_name,
732: p_string => 'New revalued cost: '||l_iac_new_reval_cost);
733:
734: -- Calculate the difference between the new revalued iac cost and the latest adjusted_cost from
735: -- igi_iac_asset_balances
736: l_diff_cost := l_iac_new_reval_cost - l_iac_asset_bal.adjusted_cost;
737: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
738: p_full_path => l_path_name,
739: p_string => 'Difference: '||l_diff_cost);

Line 1041: -- check if a row exists in igi_iac_asset_balances for l_last_period_counter

1037: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1038: p_full_path => l_path_name,
1039: p_string => 'YTD rows rolled forward');
1040:
1041: -- check if a row exists in igi_iac_asset_balances for l_last_period_counter
1042: -- if it does then update it else insert a new row
1043: SELECT count(*)
1044: INTO l_exists
1045: FROM igi_iac_asset_balances

Line 1045: FROM igi_iac_asset_balances

1041: -- check if a row exists in igi_iac_asset_balances for l_last_period_counter
1042: -- if it does then update it else insert a new row
1043: SELECT count(*)
1044: INTO l_exists
1045: FROM igi_iac_asset_balances
1046: WHERE asset_id = l_asset_id
1047: AND book_type_code = l_book_type_code
1048: AND period_counter = l_last_period_counter;
1049:

Line 1050: -- Update row in IGI_IAC_ASSET_BALANCES for the asset for the new revalued iac cost using

1046: WHERE asset_id = l_asset_id
1047: AND book_type_code = l_book_type_code
1048: AND period_counter = l_last_period_counter;
1049:
1050: -- Update row in IGI_IAC_ASSET_BALANCES for the asset for the new revalued iac cost using
1051: -- IGI_IAC_ASSET_BALANCES.Update_Row
1052: IF (l_exists > 0) THEN
1053: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(
1054: X_asset_id => l_asset_id,

Line 1051: -- IGI_IAC_ASSET_BALANCES.Update_Row

1047: AND book_type_code = l_book_type_code
1048: AND period_counter = l_last_period_counter;
1049:
1050: -- Update row in IGI_IAC_ASSET_BALANCES for the asset for the new revalued iac cost using
1051: -- IGI_IAC_ASSET_BALANCES.Update_Row
1052: IF (l_exists > 0) THEN
1053: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(
1054: X_asset_id => l_asset_id,
1055: X_book_type_code => l_book_type_code,

Line 1053: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(

1049:
1050: -- Update row in IGI_IAC_ASSET_BALANCES for the asset for the new revalued iac cost using
1051: -- IGI_IAC_ASSET_BALANCES.Update_Row
1052: IF (l_exists > 0) THEN
1053: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(
1054: X_asset_id => l_asset_id,
1055: X_book_type_code => l_book_type_code,
1056: X_period_counter => l_iac_asset_bal.period_counter,
1057: X_net_book_value => l_iac_new_nbv, --l_iac_asset_bal.net_book_value,

Line 1071: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(

1067: X_cumulative_reval_factor => l_iac_asset_bal.cumulative_reval_factor
1068: ) ;
1069: ELSE
1070: -- insert a row for the last period counter
1071: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(
1072: X_rowid => l_rowid,
1073: X_asset_id => l_asset_id,
1074: X_book_type_code => l_book_type_code,
1075: X_period_counter => l_last_period_counter,