14: g_path VARCHAR2(100) ;
15:
16: --===========================FND_LOG.END=====================================
17:
18: PROCEDURE Debug_Period(p_period igi_iac_types.prd_rec) IS
19: l_path_name VARCHAR2(150) ;
20: BEGIN
21: l_path_name := g_path||'debug_period';
22:
50: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
51: Raise;
52: end;
53:
54: PROCEDURE Debug_Asset(p_asset igi_iac_types.iac_reval_input_asset) IS
55: l_path_name VARCHAR2(150);
56: BEGIN
57: l_path_name := g_path||'debug_asset';
58:
145: FROM fa_calendar_types
146: WHERE calendar_type = p_calendar_type;
147:
148: l_fa_deprn_acc fa_adjustments.adjustment_amount%TYPE;
149: l_dpis_period igi_iac_types.prd_rec;
150: l_current_period igi_iac_types.prd_rec;
151: l_last_period igi_iac_types.prd_rec;
152: l_booksrow_period_rec igi_iac_types.prd_rec;
153: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
146: WHERE calendar_type = p_calendar_type;
147:
148: l_fa_deprn_acc fa_adjustments.adjustment_amount%TYPE;
149: l_dpis_period igi_iac_types.prd_rec;
150: l_current_period igi_iac_types.prd_rec;
151: l_last_period igi_iac_types.prd_rec;
152: l_booksrow_period_rec igi_iac_types.prd_rec;
153: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
154: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
147:
148: l_fa_deprn_acc fa_adjustments.adjustment_amount%TYPE;
149: l_dpis_period igi_iac_types.prd_rec;
150: l_current_period igi_iac_types.prd_rec;
151: l_last_period igi_iac_types.prd_rec;
152: l_booksrow_period_rec igi_iac_types.prd_rec;
153: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
154: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
155: l_booksrow_period NUMBER; -- added for bug 2961656
148: l_fa_deprn_acc fa_adjustments.adjustment_amount%TYPE;
149: l_dpis_period igi_iac_types.prd_rec;
150: l_current_period igi_iac_types.prd_rec;
151: l_last_period igi_iac_types.prd_rec;
152: l_booksrow_period_rec igi_iac_types.prd_rec;
153: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
154: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
155: l_booksrow_period NUMBER; -- added for bug 2961656
156: l_booksrow_reserve NUMBER; -- added for bug 2961656
481: p_fa_deprn_expense_cy IN NUMBER,
482: p_asset_last_period IN NUMBER,
483: p_fa_deprn_reserve IN NUMBER,
484: p_fa_deprn_ytd IN NUMBER,
485: p_asset_balance IN OUT NOCOPY igi_iac_types.iac_reval_input_asset,
486: p_event_id IN NUMBER --R12 uptake
487: ) return BOOLEAN IS
488:
489: l_deprn_catchup_amount NUMBER;
489: l_deprn_catchup_amount NUMBER;
490: l_rowid VARCHAR2(25) ;
491: l_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
492: l_transaction_sub_type igi_iac_transaction_headers.transaction_sub_type%TYPE;
493: l_distributions_tab igi_iac_types.dist_amt_tab;
494: l_fa_dist_catchup_tab igi_iac_types.dist_amt_tab;
495: l_account_ccid NUMBER(15) ;
496: l_set_of_books_id NUMBER(15) ;
497: l_chart_of_accts_id NUMBER(15) ;
490: l_rowid VARCHAR2(25) ;
491: l_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
492: l_transaction_sub_type igi_iac_transaction_headers.transaction_sub_type%TYPE;
493: l_distributions_tab igi_iac_types.dist_amt_tab;
494: l_fa_dist_catchup_tab igi_iac_types.dist_amt_tab;
495: l_account_ccid NUMBER(15) ;
496: l_set_of_books_id NUMBER(15) ;
497: l_chart_of_accts_id NUMBER(15) ;
498: l_currency_code VARCHAR2(15) ;
500: l_idx NUMBER;
501: l_detail_balance igi_iac_det_balances%ROWTYPE;
502: l_distribution_amount NUMBER;
503: l_dist_period_amount NUMBER;
504: l_last_catchup_prd_rec igi_iac_types.prd_rec;
505: l_last_reval_prd_rec igi_iac_types.prd_rec;
506: l_deprn_ytd NUMBER;
507: l_reval_reserve_net igi_iac_det_balances.reval_reserve_net%TYPE;
508: l_reval_general_fund igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
501: l_detail_balance igi_iac_det_balances%ROWTYPE;
502: l_distribution_amount NUMBER;
503: l_dist_period_amount NUMBER;
504: l_last_catchup_prd_rec igi_iac_types.prd_rec;
505: l_last_reval_prd_rec igi_iac_types.prd_rec;
506: l_deprn_ytd NUMBER;
507: l_reval_reserve_net igi_iac_det_balances.reval_reserve_net%TYPE;
508: l_reval_general_fund igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
509: l_general_fund_acc igi_iac_det_balances.general_fund_acc%TYPE;
515: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
516: /* Bug 2961656 vgadde 08-jul-2003 Start(3) */
517: l_iac_deprn_amount_py NUMBER;
518: l_iac_deprn_amount_cy NUMBER;
519: l_period_from igi_iac_types.prd_rec;
520: l_period_to igi_iac_types.prd_rec;
521: l_period_open igi_iac_types.prd_rec;
522: l_period_reserved igi_iac_types.prd_rec;
523: /* Bug 2961656 vgadde 08-jul-2003 End(3) */
516: /* Bug 2961656 vgadde 08-jul-2003 Start(3) */
517: l_iac_deprn_amount_py NUMBER;
518: l_iac_deprn_amount_cy NUMBER;
519: l_period_from igi_iac_types.prd_rec;
520: l_period_to igi_iac_types.prd_rec;
521: l_period_open igi_iac_types.prd_rec;
522: l_period_reserved igi_iac_types.prd_rec;
523: /* Bug 2961656 vgadde 08-jul-2003 End(3) */
524: l_path_name VARCHAR2(150);
517: l_iac_deprn_amount_py NUMBER;
518: l_iac_deprn_amount_cy NUMBER;
519: l_period_from igi_iac_types.prd_rec;
520: l_period_to igi_iac_types.prd_rec;
521: l_period_open igi_iac_types.prd_rec;
522: l_period_reserved igi_iac_types.prd_rec;
523: /* Bug 2961656 vgadde 08-jul-2003 End(3) */
524: l_path_name VARCHAR2(150);
525: l_iac_deprn_period_amount NUMBER;
518: l_iac_deprn_amount_cy NUMBER;
519: l_period_from igi_iac_types.prd_rec;
520: l_period_to igi_iac_types.prd_rec;
521: l_period_open igi_iac_types.prd_rec;
522: l_period_reserved igi_iac_types.prd_rec;
523: /* Bug 2961656 vgadde 08-jul-2003 End(3) */
524: l_path_name VARCHAR2(150);
525: l_iac_deprn_period_amount NUMBER;
526: l_fa_deprn_period_amount NUMBER;
1486: END Do_Deprn_Catchup;
1487:
1488: FUNCTION do_reval_init_struct(
1489: p_period_counter IN NUMBER,
1490: p_reval_control IN OUT NOCOPY igi_iac_types.iac_reval_control_tab,
1491: p_reval_asset_params IN OUT NOCOPY igi_iac_types.iac_reval_asset_params_tab,
1492: p_reval_input_asset IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1493: p_reval_output_asset IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1494: p_reval_output_asset_mvmt IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1487:
1488: FUNCTION do_reval_init_struct(
1489: p_period_counter IN NUMBER,
1490: p_reval_control IN OUT NOCOPY igi_iac_types.iac_reval_control_tab,
1491: p_reval_asset_params IN OUT NOCOPY igi_iac_types.iac_reval_asset_params_tab,
1492: p_reval_input_asset IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1493: p_reval_output_asset IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1494: p_reval_output_asset_mvmt IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1495: p_reval_asset_rules IN OUT NOCOPY igi_iac_types.iac_reval_asset_rules_tab,
1488: FUNCTION do_reval_init_struct(
1489: p_period_counter IN NUMBER,
1490: p_reval_control IN OUT NOCOPY igi_iac_types.iac_reval_control_tab,
1491: p_reval_asset_params IN OUT NOCOPY igi_iac_types.iac_reval_asset_params_tab,
1492: p_reval_input_asset IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1493: p_reval_output_asset IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1494: p_reval_output_asset_mvmt IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1495: p_reval_asset_rules IN OUT NOCOPY igi_iac_types.iac_reval_asset_rules_tab,
1496: p_prev_rate_info IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1489: p_period_counter IN NUMBER,
1490: p_reval_control IN OUT NOCOPY igi_iac_types.iac_reval_control_tab,
1491: p_reval_asset_params IN OUT NOCOPY igi_iac_types.iac_reval_asset_params_tab,
1492: p_reval_input_asset IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1493: p_reval_output_asset IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1494: p_reval_output_asset_mvmt IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1495: p_reval_asset_rules IN OUT NOCOPY igi_iac_types.iac_reval_asset_rules_tab,
1496: p_prev_rate_info IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1497: p_curr_rate_info_first IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1490: p_reval_control IN OUT NOCOPY igi_iac_types.iac_reval_control_tab,
1491: p_reval_asset_params IN OUT NOCOPY igi_iac_types.iac_reval_asset_params_tab,
1492: p_reval_input_asset IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1493: p_reval_output_asset IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1494: p_reval_output_asset_mvmt IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1495: p_reval_asset_rules IN OUT NOCOPY igi_iac_types.iac_reval_asset_rules_tab,
1496: p_prev_rate_info IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1497: p_curr_rate_info_first IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1498: p_curr_rate_info_next IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1491: p_reval_asset_params IN OUT NOCOPY igi_iac_types.iac_reval_asset_params_tab,
1492: p_reval_input_asset IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1493: p_reval_output_asset IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1494: p_reval_output_asset_mvmt IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1495: p_reval_asset_rules IN OUT NOCOPY igi_iac_types.iac_reval_asset_rules_tab,
1496: p_prev_rate_info IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1497: p_curr_rate_info_first IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1498: p_curr_rate_info_next IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1499: p_curr_rate_info IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1492: p_reval_input_asset IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1493: p_reval_output_asset IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1494: p_reval_output_asset_mvmt IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1495: p_reval_asset_rules IN OUT NOCOPY igi_iac_types.iac_reval_asset_rules_tab,
1496: p_prev_rate_info IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1497: p_curr_rate_info_first IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1498: p_curr_rate_info_next IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1499: p_curr_rate_info IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1500: p_reval_exceptions IN OUT NOCOPY igi_iac_types.iac_reval_exceptions_tab,
1493: p_reval_output_asset IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1494: p_reval_output_asset_mvmt IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1495: p_reval_asset_rules IN OUT NOCOPY igi_iac_types.iac_reval_asset_rules_tab,
1496: p_prev_rate_info IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1497: p_curr_rate_info_first IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1498: p_curr_rate_info_next IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1499: p_curr_rate_info IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1500: p_reval_exceptions IN OUT NOCOPY igi_iac_types.iac_reval_exceptions_tab,
1501: p_fa_asset_info IN OUT NOCOPY igi_iac_types.iac_reval_fa_asset_info_tab,
1494: p_reval_output_asset_mvmt IN OUT NOCOPY igi_iac_types.iac_reval_asset_tab,
1495: p_reval_asset_rules IN OUT NOCOPY igi_iac_types.iac_reval_asset_rules_tab,
1496: p_prev_rate_info IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1497: p_curr_rate_info_first IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1498: p_curr_rate_info_next IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1499: p_curr_rate_info IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1500: p_reval_exceptions IN OUT NOCOPY igi_iac_types.iac_reval_exceptions_tab,
1501: p_fa_asset_info IN OUT NOCOPY igi_iac_types.iac_reval_fa_asset_info_tab,
1502: p_fa_deprn_expense_py IN NUMBER,
1495: p_reval_asset_rules IN OUT NOCOPY igi_iac_types.iac_reval_asset_rules_tab,
1496: p_prev_rate_info IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1497: p_curr_rate_info_first IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1498: p_curr_rate_info_next IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1499: p_curr_rate_info IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1500: p_reval_exceptions IN OUT NOCOPY igi_iac_types.iac_reval_exceptions_tab,
1501: p_fa_asset_info IN OUT NOCOPY igi_iac_types.iac_reval_fa_asset_info_tab,
1502: p_fa_deprn_expense_py IN NUMBER,
1503: p_fa_deprn_expense_cy IN NUMBER,
1496: p_prev_rate_info IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1497: p_curr_rate_info_first IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1498: p_curr_rate_info_next IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1499: p_curr_rate_info IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1500: p_reval_exceptions IN OUT NOCOPY igi_iac_types.iac_reval_exceptions_tab,
1501: p_fa_asset_info IN OUT NOCOPY igi_iac_types.iac_reval_fa_asset_info_tab,
1502: p_fa_deprn_expense_py IN NUMBER,
1503: p_fa_deprn_expense_cy IN NUMBER,
1504: p_asset_last_period IN NUMBER,
1497: p_curr_rate_info_first IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1498: p_curr_rate_info_next IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1499: p_curr_rate_info IN OUT NOCOPY igi_iac_types.iac_reval_rates_tab,
1500: p_reval_exceptions IN OUT NOCOPY igi_iac_types.iac_reval_exceptions_tab,
1501: p_fa_asset_info IN OUT NOCOPY igi_iac_types.iac_reval_fa_asset_info_tab,
1502: p_fa_deprn_expense_py IN NUMBER,
1503: p_fa_deprn_expense_cy IN NUMBER,
1504: p_asset_last_period IN NUMBER,
1505: p_calling_function IN VARCHAR2
1546: l_login_id NUMBER ;
1547: l_prev_price_index NUMBER;
1548: l_dpis_price_index NUMBER;
1549: l_curr_price_index NUMBER;
1550: l_curr_period igi_iac_types.prd_rec;
1551: l_dpis_period igi_iac_types.prd_rec;
1552: /* Bug 2961656 vgadde 08-jul-2003 Start(8) */
1553: l_open_period igi_iac_types.prd_rec;
1554: l_last_catchup_period igi_iac_types.prd_rec;
1547: l_prev_price_index NUMBER;
1548: l_dpis_price_index NUMBER;
1549: l_curr_price_index NUMBER;
1550: l_curr_period igi_iac_types.prd_rec;
1551: l_dpis_period igi_iac_types.prd_rec;
1552: /* Bug 2961656 vgadde 08-jul-2003 Start(8) */
1553: l_open_period igi_iac_types.prd_rec;
1554: l_last_catchup_period igi_iac_types.prd_rec;
1555: l_last_deprn_period igi_iac_types.prd_rec;
1549: l_curr_price_index NUMBER;
1550: l_curr_period igi_iac_types.prd_rec;
1551: l_dpis_period igi_iac_types.prd_rec;
1552: /* Bug 2961656 vgadde 08-jul-2003 Start(8) */
1553: l_open_period igi_iac_types.prd_rec;
1554: l_last_catchup_period igi_iac_types.prd_rec;
1555: l_last_deprn_period igi_iac_types.prd_rec;
1556: l_fa_asset_info igi_iac_types.fa_hist_asset_info;
1557: l_reval_factor NUMBER;
1550: l_curr_period igi_iac_types.prd_rec;
1551: l_dpis_period igi_iac_types.prd_rec;
1552: /* Bug 2961656 vgadde 08-jul-2003 Start(8) */
1553: l_open_period igi_iac_types.prd_rec;
1554: l_last_catchup_period igi_iac_types.prd_rec;
1555: l_last_deprn_period igi_iac_types.prd_rec;
1556: l_fa_asset_info igi_iac_types.fa_hist_asset_info;
1557: l_reval_factor NUMBER;
1558: l_last_deprn_date DATE;
1551: l_dpis_period igi_iac_types.prd_rec;
1552: /* Bug 2961656 vgadde 08-jul-2003 Start(8) */
1553: l_open_period igi_iac_types.prd_rec;
1554: l_last_catchup_period igi_iac_types.prd_rec;
1555: l_last_deprn_period igi_iac_types.prd_rec;
1556: l_fa_asset_info igi_iac_types.fa_hist_asset_info;
1557: l_reval_factor NUMBER;
1558: l_last_deprn_date DATE;
1559: /* Bug 2961656 vgadde 08-jul-2003 End(8) */
1552: /* Bug 2961656 vgadde 08-jul-2003 Start(8) */
1553: l_open_period igi_iac_types.prd_rec;
1554: l_last_catchup_period igi_iac_types.prd_rec;
1555: l_last_deprn_period igi_iac_types.prd_rec;
1556: l_fa_asset_info igi_iac_types.fa_hist_asset_info;
1557: l_reval_factor NUMBER;
1558: l_last_deprn_date DATE;
1559: /* Bug 2961656 vgadde 08-jul-2003 End(8) */
1560: l_path_name VARCHAR2(150);
1557: l_reval_factor NUMBER;
1558: l_last_deprn_date DATE;
1559: /* Bug 2961656 vgadde 08-jul-2003 End(8) */
1560: l_path_name VARCHAR2(150);
1561: l_booksrow_period_rec igi_iac_types.prd_rec;
1562: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
1563: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
1564: l_booksrow_period NUMBER;
1565: l_booksrow_reserve NUMBER;