DBA Data[Home] [Help]

APPS.IGI_IAC_ADJ_COST_REVAL_PKG dependencies on IGI_IAC_TYPES

Line 56: PROCEDURE debug_adj_asset(p_asset igi_iac_types.iac_adj_hist_asset_info)

52: -- -------------------------------------------------------------------
53: -- PROCEDURE Debug_Adj_Asset : Procedure that will print the historic
54: -- asset information
55: -- -------------------------------------------------------------------
56: PROCEDURE debug_adj_asset(p_asset igi_iac_types.iac_adj_hist_asset_info)
57: IS
58: l_path_name VARCHAR2(150);
59: BEGIN
60: l_path_name := g_path||'debug_adj_asset';

Line 163: l_prd_rec_frm_ctr igi_iac_types.prd_rec;

159: FROM fa_book_controls
160: WHERE book_type_code = n_book_code);
161:
162:
163: l_prd_rec_frm_ctr igi_iac_types.prd_rec;
164: l_prd_rec_frm_date igi_iac_types.prd_rec;
165: l_end_date DATE;
166: l_asset_rec c_get_asset_det%ROWTYPE;
167: l_ret_flag BOOLEAN;

Line 164: l_prd_rec_frm_date igi_iac_types.prd_rec;

160: WHERE book_type_code = n_book_code);
161:
162:
163: l_prd_rec_frm_ctr igi_iac_types.prd_rec;
164: l_prd_rec_frm_date igi_iac_types.prd_rec;
165: l_end_date DATE;
166: l_asset_rec c_get_asset_det%ROWTYPE;
167: l_ret_flag BOOLEAN;
168: l_mess varchar2(255);

Line 171: l_dpis_prd_rec igi_iac_types.prd_rec;

167: l_ret_flag BOOLEAN;
168: l_mess varchar2(255);
169:
170: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
171: l_dpis_prd_rec igi_iac_types.prd_rec;
172: l_total_periods NUMBER;
173: l_path_name VARCHAR2(150);
174:
175: BEGIN

Line 362: (p_asset_iac_adj_info igi_iac_types.iac_adj_hist_asset_info,

358: -- do the cost revaluation if an asset has had cost adjustment done
359: -- against it
360: -- -------------------------------------------------------------------
361: FUNCTION Do_Cost_Revaluation
362: (p_asset_iac_adj_info igi_iac_types.iac_adj_hist_asset_info,
363: p_asset_iac_dist_info igi_iac_types.iac_adj_dist_info_tab,
364: p_adj_hist igi_iac_adjustments_history%ROWTYPE,
365: p_event_id number) --R12 uptake
366: RETURN BOOLEAN

Line 363: p_asset_iac_dist_info igi_iac_types.iac_adj_dist_info_tab,

359: -- against it
360: -- -------------------------------------------------------------------
361: FUNCTION Do_Cost_Revaluation
362: (p_asset_iac_adj_info igi_iac_types.iac_adj_hist_asset_info,
363: p_asset_iac_dist_info igi_iac_types.iac_adj_dist_info_tab,
364: p_adj_hist igi_iac_adjustments_history%ROWTYPE,
365: p_event_id number) --R12 uptake
366: RETURN BOOLEAN
367: IS

Line 474: l_prd_rec IGI_IAC_TYPES.prd_rec;

470: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
471: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
472: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;
473: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
474: l_prd_rec IGI_IAC_TYPES.prd_rec;
475: l_iac_new_reval_cost igi_iac_asset_balances.adjusted_cost%TYPE;
476: l_iac_new_nbv igi_iac_asset_balances.net_book_value%TYPE;
477: l_iac_new_rr igi_iac_asset_balances.reval_reserve%TYPE;
478: l_iac_new_op igi_iac_asset_balances.operating_acct%TYPE;

Line 482: l_det_table IGI_IAC_TYPES.dist_amt_tab;

478: l_iac_new_op igi_iac_asset_balances.operating_acct%TYPE;
479:
480: l_diff_cost igi_iac_asset_balances.adjusted_cost%TYPE;
481: l_ret BOOLEAN;
482: l_det_table IGI_IAC_TYPES.dist_amt_tab;
483: l_det_bal c_det_bal%ROWTYPE;
484:
485: l_dist_idx NUMBER;
486: l_add_cost igi_iac_det_balances.adjustment_cost%TYPE;