2795: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2796: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2797: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2798: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2799: ,p_line_start_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2800: ,p_line_end_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2801: /* for enhancement */
2802: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2803: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2796: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2797: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2798: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2799: ,p_line_start_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2800: ,p_line_end_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2801: /* for enhancement */
2802: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2803: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2804: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2800: ,p_line_end_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2801: /* for enhancement */
2802: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2803: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2804: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2805: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2806: ,p_plan_start_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2807: ,p_plan_start_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2808: ,p_plan_end_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2801: /* for enhancement */
2802: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2803: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2804: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2805: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2806: ,p_plan_start_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2807: ,p_plan_start_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2808: ,p_plan_end_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2809: ,p_plan_end_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2802: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2803: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2804: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2805: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2806: ,p_plan_start_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2807: ,p_plan_start_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2808: ,p_plan_end_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2809: ,p_plan_end_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2810: ,p_re_spread_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2803: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2804: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2805: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2806: ,p_plan_start_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2807: ,p_plan_start_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2808: ,p_plan_end_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2809: ,p_plan_end_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2810: ,p_re_spread_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2811: ,p_sp_curve_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2804: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2805: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2806: ,p_plan_start_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2807: ,p_plan_start_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2808: ,p_plan_end_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2809: ,p_plan_end_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2810: ,p_re_spread_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2811: ,p_sp_curve_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2812: ,p_plan_dates_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2805: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2806: ,p_plan_start_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2807: ,p_plan_start_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2808: ,p_plan_end_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2809: ,p_plan_end_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2810: ,p_re_spread_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2811: ,p_sp_curve_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2812: ,p_plan_dates_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2813: ,p_spfix_date_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7795: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7796: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7797: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7798: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7799: ,p_line_start_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7800: ,p_line_end_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7801: /* Added for Spread enhancements */
7802: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7803: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7796: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7797: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7798: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7799: ,p_line_start_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7800: ,p_line_end_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7801: /* Added for Spread enhancements */
7802: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7803: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7804: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7802: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7803: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7804: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7805: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7806: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7807: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7808: ,p_plan_start_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7809: ,p_plan_start_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7810: ,p_plan_end_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7803: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7804: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7805: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7806: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7807: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7808: ,p_plan_start_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7809: ,p_plan_start_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7810: ,p_plan_end_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7811: ,p_plan_end_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7804: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7805: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7806: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7807: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7808: ,p_plan_start_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7809: ,p_plan_start_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7810: ,p_plan_end_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7811: ,p_plan_end_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7812: ,p_re_spread_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7805: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7806: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7807: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7808: ,p_plan_start_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7809: ,p_plan_start_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7810: ,p_plan_end_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7811: ,p_plan_end_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7812: ,p_re_spread_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7813: ,p_rlm_id_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7806: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7807: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7808: ,p_plan_start_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7809: ,p_plan_start_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7810: ,p_plan_end_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7811: ,p_plan_end_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7812: ,p_re_spread_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7813: ,p_rlm_id_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7814: ,p_del_spread_calc_tmp1_flg IN VARCHAR2 := 'Y' /* Bug: 4309290.Added the parameter to identify if
7807: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7808: ,p_plan_start_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7809: ,p_plan_start_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7810: ,p_plan_end_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7811: ,p_plan_end_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7812: ,p_re_spread_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7813: ,p_rlm_id_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7814: ,p_del_spread_calc_tmp1_flg IN VARCHAR2 := 'Y' /* Bug: 4309290.Added the parameter to identify if
7815: PA_FP_SPREAD_CALC_TMP1 is to be deleted or not. Frm AMG flow
7857: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7858: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7859: l_bill_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7860: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7861: l_line_start_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7862: l_line_end_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7863: l_spread_curve_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7864: l_spread_curve_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7865: l_sp_fixed_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7858: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7859: l_bill_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7860: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7861: l_line_start_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7862: l_line_end_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7863: l_spread_curve_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7864: l_spread_curve_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7865: l_sp_fixed_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7866: l_sp_fixed_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7861: l_line_start_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7862: l_line_end_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7863: l_spread_curve_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7864: l_spread_curve_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7865: l_sp_fixed_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7866: l_sp_fixed_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7867: l_plan_start_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7868: l_plan_start_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7869: l_plan_end_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7862: l_line_end_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7863: l_spread_curve_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7864: l_spread_curve_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7865: l_sp_fixed_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7866: l_sp_fixed_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7867: l_plan_start_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7868: l_plan_start_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7869: l_plan_end_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7870: l_plan_end_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7863: l_spread_curve_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7864: l_spread_curve_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7865: l_sp_fixed_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7866: l_sp_fixed_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7867: l_plan_start_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7868: l_plan_start_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7869: l_plan_end_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7870: l_plan_end_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7871: l_re_spread_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7864: l_spread_curve_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7865: l_sp_fixed_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7866: l_sp_fixed_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7867: l_plan_start_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7868: l_plan_start_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7869: l_plan_end_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7870: l_plan_end_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7871: l_re_spread_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7872: l_sp_curve_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7865: l_sp_fixed_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7866: l_sp_fixed_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7867: l_plan_start_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7868: l_plan_start_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7869: l_plan_end_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7870: l_plan_end_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7871: l_re_spread_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7872: l_sp_curve_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7873: l_plan_dates_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7866: l_sp_fixed_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7867: l_plan_start_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7868: l_plan_start_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7869: l_plan_end_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7870: l_plan_end_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7871: l_re_spread_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7872: l_sp_curve_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7873: l_plan_dates_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7874: l_spfix_date_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7888: l_burden_cost_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7889: l_burden_rate_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7890: l_rev_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7891: l_bill_rate_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7892: l_multicur_plan_start_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7893: l_multicur_plan_end_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7894:
7895: l_cost_rt_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7896: l_burd_rt_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7889: l_burden_rate_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7890: l_rev_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7891: l_bill_rate_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7892: l_multicur_plan_start_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7893: l_multicur_plan_end_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7894:
7895: l_cost_rt_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7896: l_burd_rt_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7897: l_bill_rt_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();