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 206: p_dist_id IN fa_distribution_history.distribution_id%TYPE,

202: -- ===============================================================================+
203: -- Procedure to prorate the amounts based on the units assigned |
204: -- ================================================================================+
205: PROCEDURE Prorate_amount_for_dist(
206: p_dist_id IN fa_distribution_history.distribution_id%TYPE,
207: p_units_dist IN fa_distribution_history.units_assigned%TYPE,
208: p_units_total IN NUMBER,
209: p_ab_amounts IN asset_rec_type,
210: p_reval_reserve out NOCOPY number,

Line 207: p_units_dist IN fa_distribution_history.units_assigned%TYPE,

203: -- Procedure to prorate the amounts based on the units assigned |
204: -- ================================================================================+
205: PROCEDURE Prorate_amount_for_dist(
206: p_dist_id IN fa_distribution_history.distribution_id%TYPE,
207: p_units_dist IN fa_distribution_history.units_assigned%TYPE,
208: p_units_total IN NUMBER,
209: p_ab_amounts IN asset_rec_type,
210: p_reval_reserve out NOCOPY number,
211: p_general_fund out NOCOPY number,

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

280:
281: -- ===============================================================================
282: -- Procedure to prorate the amounts based on the units assigned
283: -- ===============================================================================
284: PROCEDURE Prorate_amount_for_fa_dist(P_dist_id in FA_DISTRIBUTION_HISTORY.DISTRIBUTION_ID%type,
285: P_units_dist in number,
286: P_units_total in number,
287: P_ab_amounts IN iac_fa_deprn_rec_type,
288: P_deprn_period OUT NOCOPY number,

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

338: -- ===============================================================================
339: -- PROCEDURE Prorate_Catchup_Amounts: Procedure for prorating catchup amounts like
340: -- deprn_expense and op_expense
341: -- ===============================================================================
342: PROCEDURE Prorate_Catchup_Amounts(p_dist_id IN fa_distribution_history.distribution_id%TYPE,
343: p_units_dist IN fa_distribution_history.units_assigned%TYPE,
344: p_transfer_units IN NUMBER,
345: p_ab_dep_exp IN NUMBER,
346: p_ab_op_exp IN NUMBER,

Line 343: p_units_dist IN fa_distribution_history.units_assigned%TYPE,

339: -- PROCEDURE Prorate_Catchup_Amounts: Procedure for prorating catchup amounts like
340: -- deprn_expense and op_expense
341: -- ===============================================================================
342: PROCEDURE Prorate_Catchup_Amounts(p_dist_id IN fa_distribution_history.distribution_id%TYPE,
343: p_units_dist IN fa_distribution_history.units_assigned%TYPE,
344: p_transfer_units IN NUMBER,
345: p_ab_dep_exp IN NUMBER,
346: p_ab_op_exp IN NUMBER,
347: p_fa_ab_dep_exp IN NUMBER,

Line 394: p_transaction_header_id in FA_DISTRIBUTION_HISTORY.transaction_header_id_in%TYPE,

390: -- Procedure to find the distribution ccid's for various types of accounts
391: -- ===============================================================================
392: PROCEDURE find_ccid(p_book_type_code in FA_BOOKS.book_type_code%TYPE,
393: p_asset_id in FA_BOOKS.asset_id%TYPE,
394: p_transaction_header_id in FA_DISTRIBUTION_HISTORY.transaction_header_id_in%TYPE,
395: p_dist_id in number,
396: p_reval_ccid out NOCOPY number,
397: p_Gen_fund_ccid out NOCOPY number,
398: p_Backlog_ccid out NOCOPY number,

Line 509: p_asset_units IN fa_distribution_history.units_assigned%TYPE,

505: p_tfr_prd_cntr IN igi_iac_transaction_headers.period_counter%TYPE,
506: p_hist_cost IN fa_books.cost%TYPE,
507: p_salvage_value IN fa_books.salvage_value%TYPE,
508: p_trx_header_id IN igi_iac_transaction_headers.transaction_header_id%TYPE,
509: p_asset_units IN fa_distribution_history.units_assigned%TYPE,
510: p_transfer_units IN fa_distribution_history.units_assigned%TYPE,
511: l_asset_rec OUT NOCOPY asset_rec_type,
512: l_iac_fa_dep_rec OUT NOCOPY iac_fa_deprn_rec_type
513: )

Line 510: p_transfer_units IN fa_distribution_history.units_assigned%TYPE,

506: p_hist_cost IN fa_books.cost%TYPE,
507: p_salvage_value IN fa_books.salvage_value%TYPE,
508: p_trx_header_id IN igi_iac_transaction_headers.transaction_header_id%TYPE,
509: p_asset_units IN fa_distribution_history.units_assigned%TYPE,
510: p_transfer_units IN fa_distribution_history.units_assigned%TYPE,
511: l_asset_rec OUT NOCOPY asset_rec_type,
512: l_iac_fa_dep_rec OUT NOCOPY iac_fa_deprn_rec_type
513: )
514: RETURN BOOLEAN

Line 883: FROM fa_distribution_history

879: transaction_header_id_in,
880: units_assigned,
881: transaction_header_id_out,
882: transaction_units
883: FROM fa_distribution_history
884: WHERE asset_id=p_asset_hdr_rec.asset_id
885: AND book_type_code=p_asset_hdr_rec.book_type_code
886: AND (transaction_header_id_out IS NULL OR
887: transaction_header_id_out=p_trans_rec.transaction_header_id);

Line 892: FROM fa_distribution_history

888:
889: -- Cursor to find out the number of ACtive Distributions (keep)
890: CURSOR c_no_of_imp IS
891: SELECT count(*) counter
892: FROM fa_distribution_history
893: WHERE asset_id=p_asset_hdr_rec.asset_id
894: AND book_type_code=p_asset_hdr_rec.book_type_code
895: -- AND transaction_header_id_in=p_trans_rec.transaction_header_id;
896: AND transaction_header_id_out IS NULL;

Line 901: FROM fa_distribution_history

897:
898: -- Cursor to find out the number of ACtive Distributions created by the Transfer(keep)
899: CURSOR c_no_of_active IS
900: SELECT count(*) counter
901: FROM fa_distribution_history
902: WHERE asset_id=p_asset_hdr_rec.asset_id
903: AND book_type_code=p_asset_hdr_rec.book_type_code
904: AND transaction_header_id_in=p_trans_rec.transaction_header_id;
905:

Line 909: FROM fa_distribution_history

905:
906: -- Cursor to find out the number of Inative Distributions created by the Transfer(keep)
907: CURSOR c_no_of_inactive IS
908: SELECT count(*) counter
909: FROM fa_distribution_history
910: WHERE asset_id=p_asset_hdr_rec.asset_id
911: AND book_type_code=p_asset_hdr_rec.book_type_code
912: AND transaction_header_id_out=p_trans_rec.transaction_header_id;
913:

Line 935: FROM fa_distribution_history

931: -- find the number of units involved in the transfer
932: CURSOR c_transfer_units
933: IS
934: SELECT sum(units_assigned)
935: FROM fa_distribution_history
936: WHERE asset_id=p_asset_hdr_rec.asset_id
937: AND book_type_code=p_asset_hdr_rec.book_type_code
938: AND transaction_header_id_in=p_trans_rec.transaction_header_id;
939:

Line 1024: l_old_dist fa_distribution_history.distribution_id%TYPE;

1020: l_prd_rec igi_iac_types.prd_rec;
1021: l_prd_rec_prior igi_iac_types.prd_rec;
1022: l_all_dist c_all_dist%ROWTYPE;
1023: l_iac_dist c_iac_dist%ROWTYPE;
1024: l_old_dist fa_distribution_history.distribution_id%TYPE;
1025: l_impacted_dist fa_distribution_history.distribution_id%TYPE;
1026: l_impacted_units fa_distribution_history.units_assigned%TYPE;
1027: l_no_of_imp c_no_of_imp%ROWTYPE;
1028: l_no_of_active NUMBER;

Line 1025: l_impacted_dist fa_distribution_history.distribution_id%TYPE;

1021: l_prd_rec_prior igi_iac_types.prd_rec;
1022: l_all_dist c_all_dist%ROWTYPE;
1023: l_iac_dist c_iac_dist%ROWTYPE;
1024: l_old_dist fa_distribution_history.distribution_id%TYPE;
1025: l_impacted_dist fa_distribution_history.distribution_id%TYPE;
1026: l_impacted_units fa_distribution_history.units_assigned%TYPE;
1027: l_no_of_imp c_no_of_imp%ROWTYPE;
1028: l_no_of_active NUMBER;
1029: l_no_of_inactive NUMBER;

Line 1026: l_impacted_units fa_distribution_history.units_assigned%TYPE;

1022: l_all_dist c_all_dist%ROWTYPE;
1023: l_iac_dist c_iac_dist%ROWTYPE;
1024: l_old_dist fa_distribution_history.distribution_id%TYPE;
1025: l_impacted_dist fa_distribution_history.distribution_id%TYPE;
1026: l_impacted_units fa_distribution_history.units_assigned%TYPE;
1027: l_no_of_imp c_no_of_imp%ROWTYPE;
1028: l_no_of_active NUMBER;
1029: l_no_of_inactive NUMBER;
1030:

Line 1035: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;

1031: l_ab_amounts asset_rec_type;
1032: l_iac_fa_dep_amounts iac_fa_deprn_rec_type;
1033:
1034: l_asset_num FA_ADDITIONS.asset_number%TYPE;
1035: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1036: l_transfer_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1037:
1038: l_interco_count NUMBER;
1039: l_interco_amount NUMBER ;

Line 1036: l_transfer_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;

1032: l_iac_fa_dep_amounts iac_fa_deprn_rec_type;
1033:
1034: l_asset_num FA_ADDITIONS.asset_number%TYPE;
1035: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1036: l_transfer_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1037:
1038: l_interco_count NUMBER;
1039: l_interco_amount NUMBER ;
1040: l_interco_ccid igi_iac_adjustments.code_combination_id%TYPE;