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_REINSTATE_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 57: -- the units_assigned can be obtained from fa_distribution_history

53: WHERE book_type_code = n_book_type_code
54: AND asset_id = n_asset_id
55: AND date_ineffective IS NULL;
56:
57: -- the units_assigned can be obtained from fa_distribution_history
58: CURSOR c_fa_units_assigned(n_dist_id NUMBER)
59: IS
60: SELECT units_assigned
61: FROM fa_distribution_history

Line 61: FROM fa_distribution_history

57: -- the units_assigned can be obtained from fa_distribution_history
58: CURSOR c_fa_units_assigned(n_dist_id NUMBER)
59: IS
60: SELECT units_assigned
61: FROM fa_distribution_history
62: WHERE distribution_id = n_dist_id;
63:
64:
65: -- retrieve the transaction just prior to the

Line 224: fa_distribution_history fdh

220: iidb.last_reval_date,
221: iidb.current_reval_factor,
222: iidb.cumulative_reval_factor
223: FROM igi_iac_det_balances iidb,
224: fa_distribution_history fdh
225: WHERE iidb.adjustment_id = cp_adjustment_id
226: AND iidb.book_type_code = cp_book_type_code
227: AND iidb.asset_id = cp_asset_id
228: AND fdh.book_type_code = cp_book_type_code

Line 423: FROM fa_distribution_history old,

419: -- initially find out NOCOPY if the distribution has ever
420: -- been unit or full retired or never been retired
421: SELECT COUNT(*)
422: INTO l_cnt
423: FROM fa_distribution_history old,
424: fa_distribution_history new
425: WHERE old.location_id = new.location_id
426: AND old.code_combination_id = new.code_combination_id
427: AND NVL(old.assigned_to, -999) = NVL(new.assigned_to, -999)

Line 424: fa_distribution_history new

420: -- been unit or full retired or never been retired
421: SELECT COUNT(*)
422: INTO l_cnt
423: FROM fa_distribution_history old,
424: fa_distribution_history new
425: WHERE old.location_id = new.location_id
426: AND old.code_combination_id = new.code_combination_id
427: AND NVL(old.assigned_to, -999) = NVL(new.assigned_to, -999)
428: AND old.retirement_id = g_retirement_id

Line 439: FROM fa_distribution_history old,

435: ELSE
436: -- has been retired partially(units) or fully
437: SELECT new.distribution_id
438: INTO l_ren_dist_id
439: FROM fa_distribution_history old,
440: fa_distribution_history new
441: WHERE old.location_id = new.location_id
442: AND old.code_combination_id = new.code_combination_id
443: AND NVL(old.assigned_to, -999) = NVL(new.assigned_to, -999)

Line 440: fa_distribution_history new

436: -- has been retired partially(units) or fully
437: SELECT new.distribution_id
438: INTO l_ren_dist_id
439: FROM fa_distribution_history old,
440: fa_distribution_history new
441: WHERE old.location_id = new.location_id
442: AND old.code_combination_id = new.code_combination_id
443: AND NVL(old.assigned_to, -999) = NVL(new.assigned_to, -999)
444: AND old.retirement_id = g_retirement_id

Line 541: l_units_assigned fa_distribution_history.units_assigned%TYPE;

537: l_exists NUMBER;
538: l_fully_reserved NUMBER;
539:
540: l_ret_ass_bal c_ret_ass_bal%ROWTYPE;
541: l_units_assigned fa_distribution_history.units_assigned%TYPE;
542:
543: -- bug 2480915 start(1)
544: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
545: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;

Line 629: -- from this the units_assigned can be obtained from fa_distribution_history

625: END IF;
626: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reinstatement dist id: '||l_ren_dist_id);
627:
628:
629: -- from this the units_assigned can be obtained from fa_distribution_history
630: SELECT units_assigned
631: INTO l_units_assigned
632: FROM fa_distribution_history
633: WHERE distribution_id = l_ren_dist_id;

Line 632: FROM fa_distribution_history

628:
629: -- from this the units_assigned can be obtained from fa_distribution_history
630: SELECT units_assigned
631: INTO l_units_assigned
632: FROM fa_distribution_history
633: WHERE distribution_id = l_ren_dist_id;
634:
635: -- get account values
636: l_adjustment_cost := l_det_bal.adjustment_cost;

Line 1229: l_units_assigned fa_distribution_history.units_assigned%TYPE;

1225: l_ab_deprn_reserve NUMBER;
1226: l_ab_backlog_deprn_reserve NUMBER;
1227: l_ab_general_fund NUMBER;
1228:
1229: l_units_assigned fa_distribution_history.units_assigned%TYPE;
1230: l_fully_reserved NUMBER;
1231:
1232: -- bug 2480915 start(8)
1233: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1467: FROM fa_distribution_history

1463: IF (p_transaction_run = 'SECOND') THEN
1464: -- get the number of units assigned to the distribution
1465: SELECT units_assigned
1466: INTO l_units_assigned
1467: FROM fa_distribution_history
1468: WHERE distribution_id = l_det_bal.distribution_id;
1469: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Units assigned to distribution '||l_units_assigned);
1470:
1471: -- create the catchup journals only if the catchup amounts are greater than zero,

Line 1895: fa_distribution_history fdh

1891: iidb.current_reval_factor,
1892: iidb.cumulative_reval_factor,
1893: iidb.active_flag
1894: FROM igi_iac_det_balances iidb,
1895: fa_distribution_history fdh
1896: WHERE iidb.adjustment_id = n_adjust_id
1897: AND iidb.distribution_id = n_dist_id
1898: AND fdh.distribution_id = iidb.distribution_id
1899: AND fdh.retirement_id = n_retirement_id;

Line 1929: l_units_ren fa_distribution_history.units_assigned%TYPE;

1925: -- local variables
1926: l_rowid ROWID;
1927: l_path VARCHAR2(150);
1928:
1929: l_units_ren fa_distribution_history.units_assigned%TYPE;
1930: l_units_ret fa_distribution_history.units_assigned%TYPE;
1931: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1932: l_prev_dist_id igi_iac_det_balances.distribution_id%TYPE;
1933:

Line 1930: l_units_ret fa_distribution_history.units_assigned%TYPE;

1926: l_rowid ROWID;
1927: l_path VARCHAR2(150);
1928:
1929: l_units_ren fa_distribution_history.units_assigned%TYPE;
1930: l_units_ret fa_distribution_history.units_assigned%TYPE;
1931: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1932: l_prev_dist_id igi_iac_det_balances.distribution_id%TYPE;
1933:
1934: l_retire_effect NUMBER := 0;

Line 1999: l_units_assigned fa_distribution_history.units_assigned%TYPE;

1995: l_ab_general_fund NUMBER;
1996:
1997: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;
1998: l_ret_dist_id igi_iac_det_balances.distribution_id%TYPE;
1999: l_units_assigned fa_distribution_history.units_assigned%TYPE;
2000: l_dist_units fa_distribution_history.transaction_units%TYPE;
2001: l_curr_units fa_distribution_history.units_assigned%TYPE;
2002:
2003: l_retire_id fa_distribution_history.retirement_id%TYPE;

Line 2000: l_dist_units fa_distribution_history.transaction_units%TYPE;

1996:
1997: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;
1998: l_ret_dist_id igi_iac_det_balances.distribution_id%TYPE;
1999: l_units_assigned fa_distribution_history.units_assigned%TYPE;
2000: l_dist_units fa_distribution_history.transaction_units%TYPE;
2001: l_curr_units fa_distribution_history.units_assigned%TYPE;
2002:
2003: l_retire_id fa_distribution_history.retirement_id%TYPE;
2004: l_trx_hdr_id_out fa_distribution_history.transaction_header_id_out%TYPE;

Line 2001: l_curr_units fa_distribution_history.units_assigned%TYPE;

1997: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;
1998: l_ret_dist_id igi_iac_det_balances.distribution_id%TYPE;
1999: l_units_assigned fa_distribution_history.units_assigned%TYPE;
2000: l_dist_units fa_distribution_history.transaction_units%TYPE;
2001: l_curr_units fa_distribution_history.units_assigned%TYPE;
2002:
2003: l_retire_id fa_distribution_history.retirement_id%TYPE;
2004: l_trx_hdr_id_out fa_distribution_history.transaction_header_id_out%TYPE;
2005:

Line 2003: l_retire_id fa_distribution_history.retirement_id%TYPE;

1999: l_units_assigned fa_distribution_history.units_assigned%TYPE;
2000: l_dist_units fa_distribution_history.transaction_units%TYPE;
2001: l_curr_units fa_distribution_history.units_assigned%TYPE;
2002:
2003: l_retire_id fa_distribution_history.retirement_id%TYPE;
2004: l_trx_hdr_id_out fa_distribution_history.transaction_header_id_out%TYPE;
2005:
2006: l_ret_ass_bal c_ret_ass_bal%ROWTYPE;
2007: l_ret_ytd c_ret_ytd%ROWTYPE;

Line 2004: l_trx_hdr_id_out fa_distribution_history.transaction_header_id_out%TYPE;

2000: l_dist_units fa_distribution_history.transaction_units%TYPE;
2001: l_curr_units fa_distribution_history.units_assigned%TYPE;
2002:
2003: l_retire_id fa_distribution_history.retirement_id%TYPE;
2004: l_trx_hdr_id_out fa_distribution_history.transaction_header_id_out%TYPE;
2005:
2006: l_ret_ass_bal c_ret_ass_bal%ROWTYPE;
2007: l_ret_ytd c_ret_ytd%ROWTYPE;
2008: l_fully_reserved NUMBER;

Line 2065: FROM fa_distribution_history

2061:
2062: -- find out NOCOPY if the distribution has been touched by retirement
2063: SELECT COUNT(*)
2064: INTO l_retire_effect
2065: FROM fa_distribution_history
2066: WHERE distribution_id = l_det_bal.distribution_id
2067: AND retirement_id = g_retirement_id;
2068: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Retirement effect: '||l_retire_effect);
2069:

Line 2244: FROM fa_distribution_history

2240: SELECT units_assigned,
2241: transaction_units
2242: INTO l_units_assigned,
2243: l_dist_units
2244: FROM fa_distribution_history
2245: WHERE distribution_id = l_det_bal.distribution_id;
2246:
2247: -- get the retirement prorate factor
2248: l_prorate_factor := l_dist_units/l_units_assigned;

Line 2406: FROM fa_distribution_history new, fa_distribution_history old

2402: -- get the latest account amounts for calculating adjustment catchups
2403: -- get the associated retirement distribution id
2404: SELECT new.distribution_id
2405: INTO l_ret_dist_id
2406: FROM fa_distribution_history new, fa_distribution_history old
2407: WHERE old.retirement_id = g_retirement_id
2408: AND old.location_id = new.location_id
2409: AND old.code_combination_id = new.code_combination_id
2410: AND NVL(old.assigned_to,-99) = NVL(new.assigned_to,-99)

Line 2920: l_units_assigned fa_distribution_history.units_assigned%TYPE;

2916: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
2917: l_adjust_id_reinstate igi_iac_transaction_headers.adjustment_id%TYPE;
2918: l_dr_cr_flag igi_iac_adjustments.dr_cr_flag%TYPE;
2919: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;
2920: l_units_assigned fa_distribution_history.units_assigned%TYPE;
2921:
2922: l_path VARCHAR2(150);
2923:
2924: -- exceptions

Line 3001: -- from fa_distribution_history

2997: IF (l_ren_dist_id = 0) THEN
2998: RAISE e_no_corr_reinstatement;
2999: END IF;
3000: -- get the units_assigned value for the distribution
3001: -- from fa_distribution_history
3002: SELECT units_assigned
3003: INTO l_units_assigned
3004: FROM fa_distribution_history
3005: WHERE distribution_id = l_reverse_je.distribution_id;

Line 3004: FROM fa_distribution_history

3000: -- get the units_assigned value for the distribution
3001: -- from fa_distribution_history
3002: SELECT units_assigned
3003: INTO l_units_assigned
3004: FROM fa_distribution_history
3005: WHERE distribution_id = l_reverse_je.distribution_id;
3006:
3007: -- insert into igi_iac_adjustments
3008: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(