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_REVAL_CRUD dependencies on IGI_IAC_DET_BALANCES

Line 380: , fp_det_balances out NOCOPY igi_iac_det_balances%ROWTYPE

376: , fp_asset_id in number
377: , fp_book_type_code in varchar2
378: , fp_period_counter in number
379: , fp_transaction_sub_type in varchar2
380: , fp_det_balances out NOCOPY igi_iac_det_balances%ROWTYPE
381: )
382: return boolean is
383:
384: l_fp_det_balances igi_iac_det_balances%ROWTYPE;

Line 384: l_fp_det_balances igi_iac_det_balances%ROWTYPE;

380: , fp_det_balances out NOCOPY igi_iac_det_balances%ROWTYPE
381: )
382: return boolean is
383:
384: l_fp_det_balances igi_iac_det_balances%ROWTYPE;
385: l_success boolean ;
386: transaction_sub_type igi_iac_transaction_headers.TRANSACTION_SUB_TYPE%TYPE;
387: period_counter number;
388:

Line 391: from igi_iac_det_balances bal

387: period_counter number;
388:
389: cursor c_prev_bal (period_counter number) is
390: select bal.*
391: from igi_iac_det_balances bal
392: where bal.adjustment_id = fp_adjustment_id
393: and bal.distribution_id = fp_distribution_id
394: and bal.asset_id = fp_asset_id
395: and bal.period_counter <= period_counter

Line 404: FROM igi_iac_transaction_headers th, igi_iac_det_balances db

400: SELECT 1
401: FROM dual
402: WHERE EXISTS(
403: SELECT 1
404: FROM igi_iac_transaction_headers th, igi_iac_det_balances db
405: WHERE th.transaction_sub_type = 'IMPLEMENTATION'
406: AND th.adjustment_id = db.adjustment_id
407: AND db.book_type_code = p_book_type_code
408: AND db.period_counter = p_period_counter

Line 429: from igi_iac_det_Balances

425: )
426: return boolean is
427: cursor c_exists is
428: select distinct 'x'
429: from igi_iac_det_Balances
430: where asset_id = p_asset_id
431: and distribution_id = p_distribution_id
432: and book_type_code = p_book_type_code
433: ;

Line 531: l_book_type_code igi_iac_det_balances.book_type_code%TYPE;

527: end;
528:
529: procedure round_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances )
530: is
531: l_book_type_code igi_iac_det_balances.book_type_code%TYPE;
532: l_fp_det_balances igi_iac_types.iac_det_balances;
533: l_path varchar2(150);
534:
535: procedure Do_Rounding ( pp_amount in out NOCOPY number ) is

Line 581: l_book_type_code igi_iac_det_balances.book_type_code%TYPE;

577:
578: procedure round_fa_figures ( fp_fa_hist in out NOCOPY IGI_IAC_TYPES.fa_hist_asset_info
579: , fp_det_balances in IGI_IAC_TYPES.iac_det_balances )
580: is
581: l_book_type_code igi_iac_det_balances.book_type_code%TYPE;
582: l_fp_fa_hist igi_iac_types.fa_hist_asset_info;
583: l_path varchar2(150);
584:
585: procedure Do_Rounding ( pp_amount in out NOCOPY number ) is

Line 829: IGI_IAC_DET_BALANCES_PKG.insert_row (

825: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
826:
827:
828:
829: IGI_IAC_DET_BALANCES_PKG.insert_row (
830: x_rowid => l_rowid,
831: x_adjustment_id => l_det_balances.adjustment_id,
832: x_asset_id => l_det_balances.asset_id,
833: x_distribution_id => l_det_balances.distribution_id,

Line 907: FUNCTION forward_inactive_det_balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,

903: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
904: return false;
905: end;
906:
907: FUNCTION forward_inactive_det_balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
908: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
909: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
910: p_period_counter igi_iac_det_balances.period_counter%TYPE,
911: p_iac_inactive_dists_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,

Line 908: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,

904: return false;
905: end;
906:
907: FUNCTION forward_inactive_det_balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
908: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
909: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
910: p_period_counter igi_iac_det_balances.period_counter%TYPE,
911: p_iac_inactive_dists_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
912: p_fa_inactive_dists_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE)

Line 909: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,

905: end;
906:
907: FUNCTION forward_inactive_det_balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
908: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
909: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
910: p_period_counter igi_iac_det_balances.period_counter%TYPE,
911: p_iac_inactive_dists_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
912: p_fa_inactive_dists_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE)
913: RETURN BOOLEAN IS

Line 910: p_period_counter igi_iac_det_balances.period_counter%TYPE,

906:
907: FUNCTION forward_inactive_det_balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
908: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
909: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
910: p_period_counter igi_iac_det_balances.period_counter%TYPE,
911: p_iac_inactive_dists_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
912: p_fa_inactive_dists_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE)
913: RETURN BOOLEAN IS
914:

Line 911: p_iac_inactive_dists_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,

907: FUNCTION forward_inactive_det_balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
908: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
909: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
910: p_period_counter igi_iac_det_balances.period_counter%TYPE,
911: p_iac_inactive_dists_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
912: p_fa_inactive_dists_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE)
913: RETURN BOOLEAN IS
914:
915: CURSOR c_get_prev_adjustment IS

Line 924: CURSOR c_get_iac_inactive_dists(cp_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS

920: AND adjustment_id < p_adjustment_id
921: AND adjustment_status NOT IN ('PREVIEW','OBSOLETE');
922:
923: -- cursor to retrieve the inactive distributions that will be rolled forward
924: CURSOR c_get_iac_inactive_dists(cp_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS
925: SELECT iidb.adjustment_id,
926: iidb.distribution_id,
927: iidb.adjustment_cost,
928: iidb.net_book_value,

Line 947: FROM igi_iac_det_balances iidb

943: iidb.active_flag,
944: iidb.last_reval_date,
945: iidb.current_reval_factor,
946: iidb.cumulative_reval_factor
947: FROM igi_iac_det_balances iidb
948: WHERE iidb.adjustment_id = cp_adjustment_id
949: AND iidb.asset_id = p_asset_id
950: AND iidb.book_type_code = p_book_type_code
951: AND nvl(iidb.active_flag,'Y') = 'N';

Line 991: -- insert into igi_iac_det_balances with reinstatement adjustment_id

987: RETURN TRUE;
988: END IF;
989:
990: FOR l_iac_inactive_dist IN c_get_iac_inactive_dists(l_prev_adjustment_id) LOOP
991: -- insert into igi_iac_det_balances with reinstatement adjustment_id
992: l_rowid := NULL;
993: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
994: x_rowid => l_rowid,
995: x_adjustment_id => p_adjustment_id,

Line 993: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

989:
990: FOR l_iac_inactive_dist IN c_get_iac_inactive_dists(l_prev_adjustment_id) LOOP
991: -- insert into igi_iac_det_balances with reinstatement adjustment_id
992: l_rowid := NULL;
993: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
994: x_rowid => l_rowid,
995: x_adjustment_id => p_adjustment_id,
996: x_asset_id => p_asset_id,
997: x_book_type_code => p_book_type_code,

Line 1052: FUNCTION Create_Inactive_Det_Balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,

1048: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1049: return false;
1050: END forward_inactive_det_balances;
1051:
1052: FUNCTION Create_Inactive_Det_Balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
1053: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
1054: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
1055: p_period_counter igi_iac_det_balances.period_counter%TYPE,
1056: p_asset_iac_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,

Line 1053: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,

1049: return false;
1050: END forward_inactive_det_balances;
1051:
1052: FUNCTION Create_Inactive_Det_Balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
1053: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
1054: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
1055: p_period_counter igi_iac_det_balances.period_counter%TYPE,
1056: p_asset_iac_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
1057: p_asset_fa_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE,

Line 1054: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,

1050: END forward_inactive_det_balances;
1051:
1052: FUNCTION Create_Inactive_Det_Balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
1053: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
1054: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
1055: p_period_counter igi_iac_det_balances.period_counter%TYPE,
1056: p_asset_iac_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
1057: p_asset_fa_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE,
1058: p_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab,

Line 1055: p_period_counter igi_iac_det_balances.period_counter%TYPE,

1051:
1052: FUNCTION Create_Inactive_Det_Balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
1053: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
1054: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
1055: p_period_counter igi_iac_det_balances.period_counter%TYPE,
1056: p_asset_iac_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
1057: p_asset_fa_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE,
1058: p_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab,
1059: p_YTD_prorate_dists_idx binary_integer)

Line 1056: p_asset_iac_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,

1052: FUNCTION Create_Inactive_Det_Balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
1053: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
1054: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
1055: p_period_counter igi_iac_det_balances.period_counter%TYPE,
1056: p_asset_iac_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
1057: p_asset_fa_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE,
1058: p_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab,
1059: p_YTD_prorate_dists_idx binary_integer)
1060: RETURN BOOLEAN IS

Line 1086: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_det_balances');

1082: do_round(l_dist_iac_ytd,p_book_type_code);
1083: l_dist_fa_ytd := l_YTD_prorate_dists_tab(idx_YTD).ytd_prorate_factor * p_asset_fa_ytd;
1084: do_round(l_dist_fa_ytd,p_book_type_code);
1085:
1086: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_det_balances');
1087: l_rowid := NULL;
1088: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
1089: x_rowid => l_rowid,
1090: x_adjustment_id => p_adjustment_id,

Line 1088: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

1084: do_round(l_dist_fa_ytd,p_book_type_code);
1085:
1086: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_det_balances');
1087: l_rowid := NULL;
1088: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
1089: x_rowid => l_rowid,
1090: x_adjustment_id => p_adjustment_id,
1091: x_asset_id => p_asset_id,
1092: x_book_type_code => p_book_type_code,

Line 1461: l_deprn_ytd_total := l_deprn_ytd_total - l_iac_inactive_dists_ytd; /* YTD for igi_iac_det_balances */

1457: l_fa_inactive_dists_ytd) THEN
1458: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+forward inactive detail balances Failed');
1459: return false;
1460: ELSE
1461: l_deprn_ytd_total := l_deprn_ytd_total - l_iac_inactive_dists_ytd; /* YTD for igi_iac_det_balances */
1462: l_total_fa.ytd_deprn := l_total_fa.ytd_deprn - l_fa_inactive_dists_ytd; /* YTD for igi_iac_fa_deprn */
1463: END IF;
1464:
1465: IF (fp_reval_params.reval_control.transaction_type_code = 'REVALUATION' AND

Line 1551: from igi_iac_det_balances

1547:
1548: begin
1549: select nvl(operating_acct_ytd,0)
1550: into l_operatg_ytd_bal
1551: from igi_iac_det_balances
1552: where asset_id = fp_reval_params.reval_asset_params.asset_id
1553: and distribution_id = l_prorate_dists_tab( idx ).distribution_id
1554: and book_type_code = fp_reval_params.reval_asset_params.book_type_code
1555: and adjustment_id = l_prev_adj_id

Line 1608: l_dist_deprn_ytd := l_deprn_ytd_total * l_ytd_factor; /* YTD proration for igi_iac_det_balances */

1604: l_db.current_reval_factor := l_reval_factor_curr;
1605: l_db.cumulative_reval_factor := l_reval_factor_cumm;
1606: l_db.active_flag := l_prorate_dists_tab ( idx ).active_flag;
1607:
1608: l_dist_deprn_ytd := l_deprn_ytd_total * l_ytd_factor; /* YTD proration for igi_iac_det_balances */
1609: do_round(l_dist_deprn_ytd,fp_reval_params.reval_output_asset_mvmt.book_type_code);
1610:
1611: if not igi_iac_common_utils.iac_round ( x_amount => l_dist_deprn_ytd
1612: , x_book => fp_reval_params.reval_asset_params.book_type_code ) then

Line 1666: l_dist_deprn_ytd := l_deprn_ytd_total * l_ytd_factor; /* YTD for igi_iac_det_balances */

1662: l_db.current_reval_factor := l_reval_factor_curr;
1663: l_db.cumulative_reval_factor := l_reval_factor_cumm;
1664: l_db.active_flag := l_prorate_dists_tab ( idx ).active_flag;
1665:
1666: l_dist_deprn_ytd := l_deprn_ytd_total * l_ytd_factor; /* YTD for igi_iac_det_balances */
1667: do_round(l_dist_deprn_ytd,fp_reval_params.reval_output_asset_mvmt.book_type_code);
1668: round_det_balances ( l_db ) ;
1669:
1670: verify_det_balances ( fp_det_balances => l_db

Line 2294: from igi_iac_det_balances

2290: ,nvl(sum(deprn_period),0) deprn_amount
2291: ,nvl(sum(deprn_reserve),0) deprn_reserve
2292: ,nvl(sum(deprn_reserve_backlog),0) backlog_deprn_reserve
2293: ,nvl(sum(nvl(reval_reserve_gen_fund,0)),0) general_fund
2294: from igi_iac_det_balances
2295: where asset_id = fp_asset_id
2296: and book_type_code = fp_book_type_code
2297: and period_counter = fp_period_counter
2298: and adjustment_id in ( select adjustment_id

Line 2338: -- 2. Get the sum from igi_iac_det_balances

2334: for l_bal in c_asset_bal loop
2335: l_cumm_reval_factor := l_bal.cumulative_reval_factor;
2336: end loop;
2337:
2338: -- 2. Get the sum from igi_iac_det_balances
2339: for l_det in c_asset_det loop
2340: -- 3. add (1) and (2) to get the final result.
2341: l_bal_net_book_value := l_bal_net_book_value + l_det.net_book_value;
2342: l_bal_adjusted_cost := l_bal_adjusted_cost + l_det.adjusted_cost;