APPS.IGI_IAC_ADJ_COST_REVAL_PKG dependencies on IGI_IAC_TYPES

Line 33: PROCEDURE debug_adj_asset(p_asset igi_iac_types.iac_adj_hist_asset_info)

29: -- -------------------------------------------------------------------
30: -- PROCEDURE Debug_Adj_Asset : Procedure that will print the historic
31: -- asset information
32: -- -------------------------------------------------------------------
33: PROCEDURE debug_adj_asset(p_asset igi_iac_types.iac_adj_hist_asset_info)
34: IS
35: l_path_name VARCHAR2(150);
36: BEGIN
37: l_path_name := g_path||'debug_adj_asset';

Line 140: l_prd_rec_frm_ctr igi_iac_types.prd_rec;

136: FROM fa_book_controls
137: WHERE book_type_code = n_book_code);
138:
139:
140: l_prd_rec_frm_ctr igi_iac_types.prd_rec;
141: l_prd_rec_frm_date igi_iac_types.prd_rec;
142: l_end_date DATE;
143: l_asset_rec c_get_asset_det%ROWTYPE;
144: l_ret_flag BOOLEAN;

Line 141: l_prd_rec_frm_date igi_iac_types.prd_rec;

137: WHERE book_type_code = n_book_code);
138:
139:
140: l_prd_rec_frm_ctr igi_iac_types.prd_rec;
141: l_prd_rec_frm_date igi_iac_types.prd_rec;
142: l_end_date DATE;
143: l_asset_rec c_get_asset_det%ROWTYPE;
144: l_ret_flag BOOLEAN;
145: l_mess varchar2(255);

Line 148: l_dpis_prd_rec igi_iac_types.prd_rec;

144: l_ret_flag BOOLEAN;
145: l_mess varchar2(255);
146:
147: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
148: l_dpis_prd_rec igi_iac_types.prd_rec;
149: l_total_periods NUMBER;
150: l_path_name VARCHAR2(150);
151:
152: BEGIN

Line 337: (p_asset_iac_adj_info igi_iac_types.iac_adj_hist_asset_info,

333: -- do the cost revaluation if an asset has had cost adjustment done
334: -- against it
335: -- -------------------------------------------------------------------
336: FUNCTION Do_Cost_Revaluation
337: (p_asset_iac_adj_info igi_iac_types.iac_adj_hist_asset_info,
338: p_asset_iac_dist_info igi_iac_types.iac_adj_dist_info_tab,
339: p_adj_hist igi_iac_adjustments_history%ROWTYPE,
340: p_event_id number) --R12 uptake
341: RETURN BOOLEAN

Line 338: p_asset_iac_dist_info igi_iac_types.iac_adj_dist_info_tab,

334: -- against it
335: -- -------------------------------------------------------------------
336: FUNCTION Do_Cost_Revaluation
337: (p_asset_iac_adj_info igi_iac_types.iac_adj_hist_asset_info,
338: p_asset_iac_dist_info igi_iac_types.iac_adj_dist_info_tab,
339: p_adj_hist igi_iac_adjustments_history%ROWTYPE,
340: p_event_id number) --R12 uptake
341: RETURN BOOLEAN
342: IS

Line 442: l_prd_rec IGI_IAC_TYPES.prd_rec;

438: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
439: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
440: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;
441: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
442: l_prd_rec IGI_IAC_TYPES.prd_rec;
443: l_iac_new_reval_cost igi_iac_asset_balances.adjusted_cost%TYPE;
444: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
445: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;
446: l_iac_new_op igi_iac_asset_balances.operating_acct%TYPE;

Line 450: l_det_table IGI_IAC_TYPES.dist_amt_tab;

446: l_iac_new_op igi_iac_asset_balances.operating_acct%TYPE;
447:
448: l_diff_cost igi_iac_asset_balances.adjusted_cost%TYPE;
449: l_ret BOOLEAN;
450: l_det_table IGI_IAC_TYPES.dist_amt_tab;
451: l_det_bal c_det_bal%ROWTYPE;
452:
453: l_dist_idx NUMBER;
454: l_add_cost igi_iac_det_balances.adjustment_cost%TYPE;