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

Line 229: p_dist_id IN fa_distribution_history.distribution_id%TYPE,

225: -- ===============================================================================+
226: -- Procedure to prorate the amounts based on the units assigned |
227: -- ================================================================================+
228: PROCEDURE Prorate_amount_for_dist(
229: p_dist_id IN fa_distribution_history.distribution_id%TYPE,
230: p_units_dist IN fa_distribution_history.units_assigned%TYPE,
231: p_units_total IN NUMBER,
232: p_ab_amounts IN asset_rec_type,
233: p_reval_reserve out NOCOPY number,

Line 230: p_units_dist IN fa_distribution_history.units_assigned%TYPE,

226: -- Procedure to prorate the amounts based on the units assigned |
227: -- ================================================================================+
228: PROCEDURE Prorate_amount_for_dist(
229: p_dist_id IN fa_distribution_history.distribution_id%TYPE,
230: p_units_dist IN fa_distribution_history.units_assigned%TYPE,
231: p_units_total IN NUMBER,
232: p_ab_amounts IN asset_rec_type,
233: p_reval_reserve out NOCOPY number,
234: p_general_fund out NOCOPY number,

Line 250: l_book_type_code FA_DISTRIBUTION_HISTORY.BOOK_TYPE_CODE%TYPE;

246: )
247: IS
248:
249: prorate_factor number;
250: l_book_type_code FA_DISTRIBUTION_HISTORY.BOOK_TYPE_CODE%TYPE;
251: l_mesg VARCHAR2(500);
252:
253: l_path varchar2(150);
254: BEGIN

Line 257: select book_type_code into l_book_type_code from FA_DISTRIBUTION_HISTORY

253: l_path varchar2(150);
254: BEGIN
255:
256: l_path := g_path||'Prorate_amount_for_dist';
257: select book_type_code into l_book_type_code from FA_DISTRIBUTION_HISTORY
258: where DISTRIBUTION_ID=p_dist_id;
259:
260: -- Prorate the various amounts between for the given distribution
261: prorate_factor := p_units_dist/p_units_total;

Line 335: PROCEDURE Prorate_amount_for_fa_dist(P_dist_id in FA_DISTRIBUTION_HISTORY.DISTRIBUTION_ID%type,

331:
332: -- ===============================================================================
333: -- Procedure to prorate the amounts based on the units assigned
334: -- ===============================================================================
335: PROCEDURE Prorate_amount_for_fa_dist(P_dist_id in FA_DISTRIBUTION_HISTORY.DISTRIBUTION_ID%type,
336: P_units_dist in number,
337: P_units_total in number,
338: P_ab_amounts IN iac_fa_deprn_rec_type,
339: P_deprn_period OUT NOCOPY number,

Line 350: l_book_type_code FA_DISTRIBUTION_HISTORY.BOOK_TYPE_CODE%TYPE;

346: l_mesg VARCHAR2(500);
347: P_deprn_period_old number;
348: P_deprn_ytd_old number;
349: P_deprn_reserve_old number;
350: l_book_type_code FA_DISTRIBUTION_HISTORY.BOOK_TYPE_CODE%TYPE;
351:
352: l_path varchar2(150);
353: BEGIN
354:

Line 356: select book_type_code into l_book_type_code from FA_DISTRIBUTION_HISTORY

352: l_path varchar2(150);
353: BEGIN
354:
355: l_path := g_path||'Prorate_amount_for_fa_dist';
356: select book_type_code into l_book_type_code from FA_DISTRIBUTION_HISTORY
357: where DISTRIBUTION_ID=p_dist_id;
358:
359: P_deprn_period_old := P_ab_amounts.deprn_period;
360: P_deprn_ytd_old := P_ab_amounts.deprn_ytd;

Line 402: PROCEDURE Prorate_Catchup_Amounts(p_dist_id IN fa_distribution_history.distribution_id%TYPE,

398: -- ===============================================================================
399: -- PROCEDURE Prorate_Catchup_Amounts: Procedure for prorating catchup amounts like
400: -- deprn_expense and op_expense
401: -- ===============================================================================
402: PROCEDURE Prorate_Catchup_Amounts(p_dist_id IN fa_distribution_history.distribution_id%TYPE,
403: p_units_dist IN fa_distribution_history.units_assigned%TYPE,
404: p_transfer_units IN NUMBER,
405: p_ab_dep_exp IN NUMBER,
406: p_ab_op_exp IN NUMBER,

Line 403: p_units_dist IN fa_distribution_history.units_assigned%TYPE,

399: -- PROCEDURE Prorate_Catchup_Amounts: Procedure for prorating catchup amounts like
400: -- deprn_expense and op_expense
401: -- ===============================================================================
402: PROCEDURE Prorate_Catchup_Amounts(p_dist_id IN fa_distribution_history.distribution_id%TYPE,
403: p_units_dist IN fa_distribution_history.units_assigned%TYPE,
404: p_transfer_units IN NUMBER,
405: p_ab_dep_exp IN NUMBER,
406: p_ab_op_exp IN NUMBER,
407: p_fa_ab_dep_exp IN NUMBER,

Line 415: l_book_type_code FA_DISTRIBUTION_HISTORY.BOOK_TYPE_CODE%TYPE;

411: )
412: IS
413:
414: prorate_factor number;
415: l_book_type_code FA_DISTRIBUTION_HISTORY.BOOK_TYPE_CODE%TYPE;
416: l_mesg VARCHAR2(500);
417:
418: l_path varchar2(150);
419: BEGIN

Line 422: select book_type_code into l_book_type_code from FA_DISTRIBUTION_HISTORY

418: l_path varchar2(150);
419: BEGIN
420:
421: l_path := g_path||'Prorate_amount_for_dist';
422: select book_type_code into l_book_type_code from FA_DISTRIBUTION_HISTORY
423: where DISTRIBUTION_ID=p_dist_id;
424:
425: -- Prorate the various amounts between for the given distribution
426: prorate_factor := p_units_dist/p_transfer_units;

Line 464: p_transaction_header_id in FA_DISTRIBUTION_HISTORY.transaction_header_id_in%TYPE,

460: -- Procedure to find the distribution ccid's for various types of accounts
461: -- ===============================================================================
462: PROCEDURE find_ccid(p_book_type_code in FA_BOOKS.book_type_code%TYPE,
463: p_asset_id in FA_BOOKS.asset_id%TYPE,
464: p_transaction_header_id in FA_DISTRIBUTION_HISTORY.transaction_header_id_in%TYPE,
465: p_dist_id in number,
466: p_reval_ccid out NOCOPY number,
467: p_Gen_fund_ccid out NOCOPY number,
468: p_Backlog_ccid out NOCOPY number,

Line 579: p_asset_units IN fa_distribution_history.units_assigned%TYPE,

575: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
576: p_hist_cost IN fa_books.cost%TYPE,
577: p_salvage_value IN fa_books.salvage_value%TYPE,
578: p_trx_header_id IN igi_iac_transaction_headers.transaction_header_id%TYPE,
579: p_asset_units IN fa_distribution_history.units_assigned%TYPE,
580: p_transfer_units IN fa_distribution_history.units_assigned%TYPE,
581: l_asset_rec OUT NOCOPY asset_rec_type,
582: l_iac_fa_dep_rec OUT NOCOPY iac_fa_deprn_rec_type
583: )

Line 580: p_transfer_units IN fa_distribution_history.units_assigned%TYPE,

576: p_hist_cost IN fa_books.cost%TYPE,
577: p_salvage_value IN fa_books.salvage_value%TYPE,
578: p_trx_header_id IN igi_iac_transaction_headers.transaction_header_id%TYPE,
579: p_asset_units IN fa_distribution_history.units_assigned%TYPE,
580: p_transfer_units IN fa_distribution_history.units_assigned%TYPE,
581: l_asset_rec OUT NOCOPY asset_rec_type,
582: l_iac_fa_dep_rec OUT NOCOPY iac_fa_deprn_rec_type
583: )
584: RETURN BOOLEAN

Line 974: FROM fa_distribution_history

970: transaction_header_id_in,
971: units_assigned,
972: transaction_header_id_out,
973: transaction_units
974: FROM fa_distribution_history
975: WHERE asset_id=p_asset_hdr_rec.asset_id
976: AND book_type_code=p_asset_hdr_rec.book_type_code
977: AND (transaction_header_id_out IS NULL OR
978: transaction_header_id_out=p_trans_rec.transaction_header_id);

Line 983: FROM fa_distribution_history

979:
980: -- Cursor to find out the number of ACtive Distributions (keep)
981: CURSOR c_no_of_imp IS
982: SELECT count(*) counter
983: FROM fa_distribution_history
984: WHERE asset_id=p_asset_hdr_rec.asset_id
985: AND book_type_code=p_asset_hdr_rec.book_type_code
986: -- AND transaction_header_id_in=p_trans_rec.transaction_header_id;
987: AND transaction_header_id_out IS NULL;

Line 992: FROM fa_distribution_history

988:
989: -- Cursor to find out the number of ACtive Distributions created by the Transfer(keep)
990: CURSOR c_no_of_active IS
991: SELECT count(*) counter
992: FROM fa_distribution_history
993: WHERE asset_id=p_asset_hdr_rec.asset_id
994: AND book_type_code=p_asset_hdr_rec.book_type_code
995: AND transaction_header_id_in=p_trans_rec.transaction_header_id;
996:

Line 1000: FROM fa_distribution_history

996:
997: -- Cursor to find out the number of Inative Distributions created by the Transfer(keep)
998: CURSOR c_no_of_inactive IS
999: SELECT count(*) counter
1000: FROM fa_distribution_history
1001: WHERE asset_id=p_asset_hdr_rec.asset_id
1002: AND book_type_code=p_asset_hdr_rec.book_type_code
1003: AND transaction_header_id_out=p_trans_rec.transaction_header_id;
1004:

Line 1026: FROM fa_distribution_history

1022: -- find the number of units involved in the transfer
1023: CURSOR c_transfer_units
1024: IS
1025: SELECT sum(units_assigned)
1026: FROM fa_distribution_history
1027: WHERE asset_id=p_asset_hdr_rec.asset_id
1028: AND book_type_code=p_asset_hdr_rec.book_type_code
1029: AND transaction_header_id_in=p_trans_rec.transaction_header_id;
1030:

Line 1115: l_old_dist fa_distribution_history.distribution_id%TYPE;

1111: l_prd_rec igi_iac_types.prd_rec;
1112: l_prd_rec_prior igi_iac_types.prd_rec;
1113: l_all_dist c_all_dist%ROWTYPE;
1114: l_iac_dist c_iac_dist%ROWTYPE;
1115: l_old_dist fa_distribution_history.distribution_id%TYPE;
1116: l_impacted_dist fa_distribution_history.distribution_id%TYPE;
1117: l_impacted_units fa_distribution_history.units_assigned%TYPE;
1118: l_no_of_imp c_no_of_imp%ROWTYPE;
1119: l_no_of_active NUMBER;

Line 1116: l_impacted_dist fa_distribution_history.distribution_id%TYPE;

1112: l_prd_rec_prior igi_iac_types.prd_rec;
1113: l_all_dist c_all_dist%ROWTYPE;
1114: l_iac_dist c_iac_dist%ROWTYPE;
1115: l_old_dist fa_distribution_history.distribution_id%TYPE;
1116: l_impacted_dist fa_distribution_history.distribution_id%TYPE;
1117: l_impacted_units fa_distribution_history.units_assigned%TYPE;
1118: l_no_of_imp c_no_of_imp%ROWTYPE;
1119: l_no_of_active NUMBER;
1120: l_no_of_inactive NUMBER;

Line 1117: l_impacted_units fa_distribution_history.units_assigned%TYPE;

1113: l_all_dist c_all_dist%ROWTYPE;
1114: l_iac_dist c_iac_dist%ROWTYPE;
1115: l_old_dist fa_distribution_history.distribution_id%TYPE;
1116: l_impacted_dist fa_distribution_history.distribution_id%TYPE;
1117: l_impacted_units fa_distribution_history.units_assigned%TYPE;
1118: l_no_of_imp c_no_of_imp%ROWTYPE;
1119: l_no_of_active NUMBER;
1120: l_no_of_inactive NUMBER;
1121:

Line 1126: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;

1122: l_ab_amounts asset_rec_type;
1123: l_iac_fa_dep_amounts iac_fa_deprn_rec_type;
1124:
1125: l_asset_num FA_ADDITIONS.asset_number%TYPE;
1126: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1127: l_transfer_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1128:
1129: l_interco_count NUMBER;
1130: l_interco_amount NUMBER ;

Line 1127: l_transfer_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;

1123: l_iac_fa_dep_amounts iac_fa_deprn_rec_type;
1124:
1125: l_asset_num FA_ADDITIONS.asset_number%TYPE;
1126: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1127: l_transfer_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1128:
1129: l_interco_count NUMBER;
1130: l_interco_amount NUMBER ;
1131: l_interco_ccid igi_iac_adjustments.code_combination_id%TYPE;