eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_CALC_PLAN_PKG dependencies on PA_NUM_TBL_TYPE

Line 56: g_ipm_ra_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

52: G_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
53: --G_populate_mrc_tab_flag VARCHAR2(10) := 'N';
54: G_call_raTxn_rollup_flag VARCHAR2(10) := 'Y';
55:
56: g_ipm_ra_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
57: g_ipm_curr_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
58: g_ipm_cost_rate_ovr_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
59: g_ipm_bill_rate_ovr_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
60: g_ipm_burden_rate_ovr_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 58: g_ipm_cost_rate_ovr_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

54: G_call_raTxn_rollup_flag VARCHAR2(10) := 'Y';
55:
56: g_ipm_ra_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
57: g_ipm_curr_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
58: g_ipm_cost_rate_ovr_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
59: g_ipm_bill_rate_ovr_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
60: g_ipm_burden_rate_ovr_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
61:
62: /* Billabliity and MRC Enhancements: Note declaring table of records cannot be used in Bulk updates / bulk inserts

Line 59: g_ipm_bill_rate_ovr_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

55:
56: g_ipm_ra_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
57: g_ipm_curr_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
58: g_ipm_cost_rate_ovr_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
59: g_ipm_bill_rate_ovr_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
60: g_ipm_burden_rate_ovr_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
61:
62: /* Billabliity and MRC Enhancements: Note declaring table of records cannot be used in Bulk updates / bulk inserts
63: * so 9.2.5.0 version donot support the builk-in-bind of table of records with indexes

Line 60: g_ipm_burden_rate_ovr_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

56: g_ipm_ra_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
57: g_ipm_curr_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
58: g_ipm_cost_rate_ovr_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
59: g_ipm_bill_rate_ovr_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
60: g_ipm_burden_rate_ovr_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
61:
62: /* Billabliity and MRC Enhancements: Note declaring table of records cannot be used in Bulk updates / bulk inserts
63: * so 9.2.5.0 version donot support the builk-in-bind of table of records with indexes
64: * so commenting it out for time being

Line 2810: ,p_resource_assignment_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2806: ,p_spread_required_flag IN VARCHAR2
2807: ,p_wp_cost_changed_flag IN VARCHAR2
2808: ,p_time_phase_changed_flag IN VARCHAR2
2809: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2810: ,p_resource_assignment_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2811: ,p_delete_budget_lines_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2812: ,p_spread_amts_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2813: ,p_txn_currency_code_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
2814: ,p_txn_currency_override_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()

Line 2815: ,p_total_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2811: ,p_delete_budget_lines_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2812: ,p_spread_amts_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2813: ,p_txn_currency_code_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
2814: ,p_txn_currency_override_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
2815: ,p_total_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2816: ,p_addl_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2817: ,p_total_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2818: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2819: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 2816: ,p_addl_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2812: ,p_spread_amts_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2813: ,p_txn_currency_code_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
2814: ,p_txn_currency_override_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
2815: ,p_total_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2816: ,p_addl_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2817: ,p_total_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2818: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2819: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2820: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 2817: ,p_total_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2813: ,p_txn_currency_code_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
2814: ,p_txn_currency_override_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
2815: ,p_total_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2816: ,p_addl_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2817: ,p_total_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2818: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2819: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2820: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2821: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 2818: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2814: ,p_txn_currency_override_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
2815: ,p_total_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2816: ,p_addl_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2817: ,p_total_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2818: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2819: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2820: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2821: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2822: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 2819: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2815: ,p_total_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2816: ,p_addl_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2817: ,p_total_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2818: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2819: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2820: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2821: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2822: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2823: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 2820: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2816: ,p_addl_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2817: ,p_total_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2818: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2819: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2820: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2821: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2822: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2823: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2824: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 2821: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2817: ,p_total_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2818: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2819: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2820: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2821: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2822: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2823: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2824: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2825: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 2822: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2818: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2819: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2820: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2821: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2822: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2823: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2824: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2825: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2826: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 2823: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2819: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2820: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2821: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2822: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2823: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2824: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2825: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2826: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2827: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 2824: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2820: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2821: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2822: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2823: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2824: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2825: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2826: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2827: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2828: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 2825: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2821: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2822: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2823: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2824: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2825: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2826: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2827: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2828: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2829: ,p_line_start_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()

Line 2826: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2822: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2823: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2824: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2825: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2826: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2827: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2828: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2829: ,p_line_start_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2830: ,p_line_end_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()

Line 2827: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2823: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2824: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2825: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2826: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2827: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2828: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2829: ,p_line_start_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2830: ,p_line_end_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2831: /* for enhancement */

Line 2828: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2824: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2825: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2826: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2827: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2828: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2829: ,p_line_start_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2830: ,p_line_end_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2831: /* for enhancement */
2832: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 2832: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2828: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2829: ,p_line_start_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2830: ,p_line_end_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2831: /* for enhancement */
2832: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2833: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2834: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2835: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2836: ,p_plan_start_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()

Line 2833: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2829: ,p_line_start_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2830: ,p_line_end_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2831: /* for enhancement */
2832: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2833: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2834: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2835: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2836: ,p_plan_start_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
2837: ,p_plan_start_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()

Line 2845: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2841: ,p_sp_curve_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2842: ,p_plan_dates_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2843: ,p_spfix_date_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2844: ,p_mfc_cost_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2845: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2846: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2847: ,p_rlm_id_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2848: ,p_fp_task_billable_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2849: ,x_return_status OUT NOCOPY VARCHAR2

Line 2846: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

2842: ,p_plan_dates_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2843: ,p_spfix_date_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2844: ,p_mfc_cost_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2845: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2846: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2847: ,p_rlm_id_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2848: ,p_fp_task_billable_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2849: ,x_return_status OUT NOCOPY VARCHAR2
2850: ,x_msg_count OUT NOCOPY NUMBER

Line 7264: /* Bug fix:3801261 l_bl_id_tab SYSTEM.pa_num_tbl_type; */

7260: ,x_msg_count OUT NOCOPY NUMBER
7261: ,x_msg_data OUT NOCOPY VARCHAR2) IS
7262:
7263: -----added global variables from the multi currency pkg
7264: /* Bug fix:3801261 l_bl_id_tab SYSTEM.pa_num_tbl_type; */
7265: l_bl_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7266: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7267: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7268: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 7641: ,p_resource_assignment_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7637: * keeping these budget lines will retain the currency code during the resource assignment updates
7638: */
7639: PROCEDURE Delete_BL_Where_Nulls
7640: ( p_budget_version_id IN NUmber
7641: ,p_resource_assignment_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7642: ,x_return_status OUT NOCOPY varchar2
7643: ,x_msg_data OUT NOCOPY varchar2
7644: ) IS
7645:

Line 7870: ,p_resource_assignment_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7866: ,p_revenue_adj_pct IN NUMBER := NULL
7867: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
7868: ,p_calling_module IN VARCHAR2 DEFAULT 'UPDATE_PLAN_TRANSACTION'
7869: ,p_activity_code IN VARCHAR2 DEFAULT 'CALCULATE'
7870: ,p_resource_assignment_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7871: ,p_delete_budget_lines_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7872: ,p_spread_amts_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7873: ,p_txn_currency_code_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
7874: ,p_txn_currency_override_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()

Line 7875: ,p_total_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7871: ,p_delete_budget_lines_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7872: ,p_spread_amts_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7873: ,p_txn_currency_code_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
7874: ,p_txn_currency_override_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
7875: ,p_total_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7876: ,p_addl_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7877: ,p_total_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7878: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7879: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 7876: ,p_addl_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7872: ,p_spread_amts_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7873: ,p_txn_currency_code_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
7874: ,p_txn_currency_override_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
7875: ,p_total_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7876: ,p_addl_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7877: ,p_total_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7878: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7879: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7880: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 7877: ,p_total_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7873: ,p_txn_currency_code_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
7874: ,p_txn_currency_override_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
7875: ,p_total_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7876: ,p_addl_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7877: ,p_total_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7878: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7879: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7880: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7881: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 7878: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7874: ,p_txn_currency_override_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
7875: ,p_total_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7876: ,p_addl_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7877: ,p_total_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7878: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7879: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7880: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7881: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7882: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 7879: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7875: ,p_total_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7876: ,p_addl_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7877: ,p_total_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7878: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7879: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7880: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7881: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7882: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7883: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 7880: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7876: ,p_addl_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7877: ,p_total_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7878: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7879: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7880: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7881: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7882: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7883: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7884: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 7881: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7877: ,p_total_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7878: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7879: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7880: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7881: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7882: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7883: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7884: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7885: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 7882: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7878: ,p_addl_raw_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7879: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7880: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7881: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7882: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7883: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7884: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7885: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7886: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 7883: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7879: ,p_total_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7880: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7881: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7882: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7883: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7884: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7885: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7886: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7887: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 7884: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7880: ,p_addl_burdened_cost_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7881: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7882: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7883: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7884: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7885: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7886: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7887: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7888: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 7885: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7881: ,p_total_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7882: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7883: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7884: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7885: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7886: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7887: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7888: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7889: ,p_line_start_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()

Line 7886: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7882: ,p_addl_revenue_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7883: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7884: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7885: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7886: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7887: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7888: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7889: ,p_line_start_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7890: ,p_line_end_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()

Line 7887: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7883: ,p_raw_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7884: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7885: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7886: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7887: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7888: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7889: ,p_line_start_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7890: ,p_line_end_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7891: /* Added for Spread enhancements */

Line 7888: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7884: ,p_rw_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7885: ,p_b_cost_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7886: ,p_b_cost_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7887: ,p_bill_rate_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7888: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7889: ,p_line_start_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7890: ,p_line_end_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7891: /* Added for Spread enhancements */
7892: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 7892: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7888: ,p_bill_rate_override_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7889: ,p_line_start_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7890: ,p_line_end_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7891: /* Added for Spread enhancements */
7892: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7893: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7894: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7895: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7896: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()

Line 7893: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7889: ,p_line_start_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7890: ,p_line_end_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7891: /* Added for Spread enhancements */
7892: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7893: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7894: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7895: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7896: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7897: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()

Line 7894: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7890: ,p_line_end_date_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7891: /* Added for Spread enhancements */
7892: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7893: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7894: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7895: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7896: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7897: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7898: ,p_plan_start_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()

Line 7895: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

7891: /* Added for Spread enhancements */
7892: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7893: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7894: ,p_spread_curve_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7895: ,p_spread_curve_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7896: ,p_sp_fixed_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7897: ,p_sp_fixed_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7898: ,p_plan_start_date_old_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7899: ,p_plan_start_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()

Line 7932: l_resource_assignment_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7928: l_countr NUMBER ;
7929: l_message_name VARCHAR2(100);
7930:
7931: -- TABLE IN LOCAL VARIABLES
7932: l_resource_assignment_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7933: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7934: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7935: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type();
7936: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type();

Line 7937: l_total_qty_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7933: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7934: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7935: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type();
7936: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type();
7937: l_total_qty_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7938: l_addl_qty_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7939: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7940: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7941: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 7938: l_addl_qty_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7934: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7935: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type();
7936: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type();
7937: l_total_qty_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7938: l_addl_qty_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7939: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7940: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7941: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7942: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 7939: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7935: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type();
7936: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type();
7937: l_total_qty_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7938: l_addl_qty_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7939: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7940: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7941: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7942: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7943: l_total_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 7940: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7936: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type();
7937: l_total_qty_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7938: l_addl_qty_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7939: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7940: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7941: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7942: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7943: l_total_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7944: l_addl_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 7941: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7937: l_total_qty_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7938: l_addl_qty_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7939: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7940: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7941: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7942: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7943: l_total_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7944: l_addl_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7945: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 7942: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7938: l_addl_qty_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7939: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7940: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7941: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7942: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7943: l_total_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7944: l_addl_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7945: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7946: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 7943: l_total_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7939: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7940: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7941: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7942: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7943: l_total_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7944: l_addl_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7945: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7946: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7947: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 7944: l_addl_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7940: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7941: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7942: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7943: l_total_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7944: l_addl_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7945: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7946: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7947: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7948: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 7945: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7941: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7942: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7943: l_total_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7944: l_addl_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7945: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7946: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7947: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7948: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7949: l_bill_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 7946: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7942: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7943: l_total_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7944: l_addl_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7945: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7946: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7947: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7948: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7949: l_bill_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7950: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 7947: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7943: l_total_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7944: l_addl_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7945: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7946: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7947: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7948: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7949: l_bill_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7950: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7951: l_line_start_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();

Line 7948: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7944: l_addl_revenue_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7945: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7946: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7947: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7948: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7949: l_bill_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7950: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7951: l_line_start_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7952: l_line_end_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();

Line 7949: l_bill_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7945: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7946: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7947: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7948: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7949: l_bill_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7950: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7951: l_line_start_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7952: l_line_end_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7953: l_spread_curve_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 7950: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7946: l_rw_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7947: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7948: l_b_cost_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7949: l_bill_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7950: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7951: l_line_start_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7952: l_line_end_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7953: l_spread_curve_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7954: l_spread_curve_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 7953: l_spread_curve_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7949: l_bill_rate_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7950: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7951: l_line_start_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7952: l_line_end_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7953: l_spread_curve_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7954: l_spread_curve_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7955: l_sp_fixed_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7956: l_sp_fixed_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7957: l_plan_start_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();

Line 7954: l_spread_curve_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7950: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7951: l_line_start_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7952: l_line_end_date_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7953: l_spread_curve_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7954: l_spread_curve_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7955: l_sp_fixed_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7956: l_sp_fixed_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7957: l_plan_start_date_old_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();
7958: l_plan_start_date_new_tab SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type();

Line 7965: l_mfc_cost_type_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7961: l_re_spread_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7962: l_sp_curve_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7963: l_plan_dates_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7964: l_spfix_date_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7965: l_mfc_cost_type_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7966: l_mfc_cost_type_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7967: l_mfc_cost_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7968: l_rlm_id_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7969: l_plan_sdate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

Line 7966: l_mfc_cost_type_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

7962: l_sp_curve_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7963: l_plan_dates_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7964: l_spfix_date_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7965: l_mfc_cost_type_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7966: l_mfc_cost_type_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7967: l_mfc_cost_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7968: l_rlm_id_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7969: l_plan_sdate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7970: l_plan_edate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();