DBA Data[Home] [Help]

APPS.IGI_IAC_ADJ_COST_REVAL_PKG dependencies on IGI_IAC_ADJUSTMENTS

Line 339: p_adj_hist igi_iac_adjustments_history%ROWTYPE,

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
343: -- local cursors

Line 467: l_dr_cr_flag_c igi_iac_adjustments.dr_cr_flag%TYPE;

463: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
464: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
465: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
466:
467: l_dr_cr_flag_c igi_iac_adjustments.dr_cr_flag%TYPE;
468: l_dr_cr_flag_ro igi_iac_adjustments.dr_cr_flag%TYPE;
469: l_adjust_type VARCHAR2(15);
470: -- l_ccid igi_iac_adjustments.code_combination_id%TYPE;
471: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;

Line 468: l_dr_cr_flag_ro igi_iac_adjustments.dr_cr_flag%TYPE;

464: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
465: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
466:
467: l_dr_cr_flag_c igi_iac_adjustments.dr_cr_flag%TYPE;
468: l_dr_cr_flag_ro igi_iac_adjustments.dr_cr_flag%TYPE;
469: l_adjust_type VARCHAR2(15);
470: -- l_ccid igi_iac_adjustments.code_combination_id%TYPE;
471: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
472: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;

Line 470: -- l_ccid igi_iac_adjustments.code_combination_id%TYPE;

466:
467: l_dr_cr_flag_c igi_iac_adjustments.dr_cr_flag%TYPE;
468: l_dr_cr_flag_ro igi_iac_adjustments.dr_cr_flag%TYPE;
469: l_adjust_type VARCHAR2(15);
470: -- l_ccid igi_iac_adjustments.code_combination_id%TYPE;
471: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
472: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
473: l_op_exp_ccid igi_iac_adjustments.code_combination_id%TYPE;
474: l_report_ccid igi_iac_adjustments.code_combination_id%TYPE;

Line 471: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;

467: l_dr_cr_flag_c igi_iac_adjustments.dr_cr_flag%TYPE;
468: l_dr_cr_flag_ro igi_iac_adjustments.dr_cr_flag%TYPE;
469: l_adjust_type VARCHAR2(15);
470: -- l_ccid igi_iac_adjustments.code_combination_id%TYPE;
471: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
472: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
473: l_op_exp_ccid igi_iac_adjustments.code_combination_id%TYPE;
474: l_report_ccid igi_iac_adjustments.code_combination_id%TYPE;
475: l_adjustment_offset_type VARCHAR2(50);

Line 472: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;

468: l_dr_cr_flag_ro igi_iac_adjustments.dr_cr_flag%TYPE;
469: l_adjust_type VARCHAR2(15);
470: -- l_ccid igi_iac_adjustments.code_combination_id%TYPE;
471: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
472: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
473: l_op_exp_ccid igi_iac_adjustments.code_combination_id%TYPE;
474: l_report_ccid igi_iac_adjustments.code_combination_id%TYPE;
475: l_adjustment_offset_type VARCHAR2(50);
476: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;

Line 473: l_op_exp_ccid igi_iac_adjustments.code_combination_id%TYPE;

469: l_adjust_type VARCHAR2(15);
470: -- l_ccid igi_iac_adjustments.code_combination_id%TYPE;
471: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
472: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
473: l_op_exp_ccid igi_iac_adjustments.code_combination_id%TYPE;
474: l_report_ccid igi_iac_adjustments.code_combination_id%TYPE;
475: l_adjustment_offset_type VARCHAR2(50);
476: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;
477: l_last_period_counter igi_iac_transaction_headers.period_counter%TYPE;

Line 474: l_report_ccid igi_iac_adjustments.code_combination_id%TYPE;

470: -- l_ccid igi_iac_adjustments.code_combination_id%TYPE;
471: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
472: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
473: l_op_exp_ccid igi_iac_adjustments.code_combination_id%TYPE;
474: l_report_ccid igi_iac_adjustments.code_combination_id%TYPE;
475: l_adjustment_offset_type VARCHAR2(50);
476: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;
477: l_last_period_counter igi_iac_transaction_headers.period_counter%TYPE;
478: l_rsvd_pc igi_iac_transaction_headers.period_counter%TYPE;

Line 476: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;

472: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
473: l_op_exp_ccid igi_iac_adjustments.code_combination_id%TYPE;
474: l_report_ccid igi_iac_adjustments.code_combination_id%TYPE;
475: l_adjustment_offset_type VARCHAR2(50);
476: l_units_assigned igi_iac_adjustments.units_assigned%TYPE;
477: l_last_period_counter igi_iac_transaction_headers.period_counter%TYPE;
478: l_rsvd_pc igi_iac_transaction_headers.period_counter%TYPE;
479:
480: l_sob_id NUMBER;

Line 839: -- Create the following accounting entries with the prorated amounts in IGI_IAC_ADJUSTMENTS

835: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
836: p_full_path => l_path_name,
837: p_string => 'IAC Deprn row inserted');
838:
839: -- Create the following accounting entries with the prorated amounts in IGI_IAC_ADJUSTMENTS
840:
841: -- find the ccid for COST
842:
843: If l_add_cost <> 0 Then

Line 858: -- insert into igi_iac_adjustments for REVAL RESERVE or OP EXPENSE

854: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
855: p_full_path => l_path_name,
856: p_string => 'COST ccid: '||l_cost_ccid||' Flag: '||l_dr_cr_flag_c);
857:
858: -- insert into igi_iac_adjustments for REVAL RESERVE or OP EXPENSE
859: IF (l_iac_asset_bal.cumulative_reval_factor >= 1 ) THEN
860: -- find the ccid for COST
861: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,
862: l_asset_id,

Line 875: -- insert into igi_iac_adjustments for REVAL RESERVE

871: l_report_ccid :=l_reval_rsv_ccid;
872:
873: -------- REVAL RESERVE A/C Entry-------------
874:
875: -- insert into igi_iac_adjustments for REVAL RESERVE
876: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
877: x_rowid => l_rowid,
878: x_adjustment_id => l_new_adj_id,
879: x_book_type_code => l_book_type_code,

Line 876: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

872:
873: -------- REVAL RESERVE A/C Entry-------------
874:
875: -- insert into igi_iac_adjustments for REVAL RESERVE
876: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
877: x_rowid => l_rowid,
878: x_adjustment_id => l_new_adj_id,
879: x_book_type_code => l_book_type_code,
880: x_code_combination_id => l_reval_rsv_ccid,

Line 916: -- insert into igi_iac_adjustments for OP EXPENSE

912:
913: l_adjustment_offset_type:='OP EXPENSE';
914: l_report_ccid :=l_op_exp_ccid;
915:
916: -- insert into igi_iac_adjustments for OP EXPENSE
917: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
918: x_rowid => l_rowid,
919: x_adjustment_id => l_new_adj_id,
920: x_book_type_code => l_book_type_code,

Line 917: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

913: l_adjustment_offset_type:='OP EXPENSE';
914: l_report_ccid :=l_op_exp_ccid;
915:
916: -- insert into igi_iac_adjustments for OP EXPENSE
917: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
918: x_rowid => l_rowid,
919: x_adjustment_id => l_new_adj_id,
920: x_book_type_code => l_book_type_code,
921: x_code_combination_id => l_op_exp_ccid,

Line 941: -- insert into igi_iac_adjustments for COST

937: p_full_path => l_path_name,
938: p_string => 'OP EXPENSE ccid: '||l_op_exp_ccid||' Flag: '||l_dr_cr_flag_ro);
939: END IF;
940:
941: -- insert into igi_iac_adjustments for COST
942: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
943: x_rowid => l_rowid,
944: x_adjustment_id => l_new_adj_id,
945: x_book_type_code => l_book_type_code,

Line 942: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

938: p_string => 'OP EXPENSE ccid: '||l_op_exp_ccid||' Flag: '||l_dr_cr_flag_ro);
939: END IF;
940:
941: -- insert into igi_iac_adjustments for COST
942: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
943: x_rowid => l_rowid,
944: x_adjustment_id => l_new_adj_id,
945: x_book_type_code => l_book_type_code,
946: x_code_combination_id => l_cost_ccid,