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_VARCHAR2_1_TBL_TYPE

Line 230: g_apply_progress_flag_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

226: g_rtChanged_RwMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
227: g_rtChanged_BrMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
228: g_rtChanged_RvMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
229:
230: g_apply_progress_flag_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
231:
232: g_etcrevrej_raId_tab pa_plsql_datatypes.NumTabTyp;
233: g_etcrevrej_txnCur_tab pa_plsql_datatypes.Char30TabTyp;
234: g_etcrevrej_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 2781: ,p_delete_budget_lines_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()

2777: ,p_wp_cost_changed_flag IN VARCHAR2
2778: ,p_time_phase_changed_flag IN VARCHAR2
2779: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2780: ,p_resource_assignment_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2781: ,p_delete_budget_lines_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2782: ,p_spread_amts_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2783: ,p_txn_currency_code_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
2784: ,p_txn_currency_override_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
2785: ,p_total_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 2782: ,p_spread_amts_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()

2778: ,p_time_phase_changed_flag IN VARCHAR2
2779: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2780: ,p_resource_assignment_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2781: ,p_delete_budget_lines_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2782: ,p_spread_amts_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2783: ,p_txn_currency_code_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
2784: ,p_txn_currency_override_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
2785: ,p_total_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2786: ,p_addl_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 2810: ,p_re_spread_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_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()
2814: ,p_mfc_cost_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()

Line 2811: ,p_sp_curve_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_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()
2814: ,p_mfc_cost_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2815: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 2812: ,p_plan_dates_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_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()
2814: ,p_mfc_cost_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2815: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2816: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 2813: ,p_spfix_date_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_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()
2814: ,p_mfc_cost_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2815: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2816: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2817: ,p_rlm_id_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()

Line 2814: ,p_mfc_cost_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_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()
2814: ,p_mfc_cost_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2815: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2816: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2817: ,p_rlm_id_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2818: ,p_fp_task_billable_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()

Line 2817: ,p_rlm_id_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()
2814: ,p_mfc_cost_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2815: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2816: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2817: ,p_rlm_id_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2818: ,p_fp_task_billable_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2819: ,x_return_status OUT NOCOPY VARCHAR2
2820: ,x_msg_count OUT NOCOPY NUMBER
2821: ,x_msg_data OUT NOCOPY VARCHAR2) IS

Line 2818: ,p_fp_task_billable_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()

2814: ,p_mfc_cost_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2815: ,p_mfc_cost_type_id_old_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2816: ,p_mfc_cost_type_id_new_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2817: ,p_rlm_id_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2818: ,p_fp_task_billable_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2819: ,x_return_status OUT NOCOPY VARCHAR2
2820: ,x_msg_count OUT NOCOPY NUMBER
2821: ,x_msg_data OUT NOCOPY VARCHAR2) IS
2822:

Line 7781: ,p_delete_budget_lines_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()

7777: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
7778: ,p_calling_module IN VARCHAR2 DEFAULT 'UPDATE_PLAN_TRANSACTION'
7779: ,p_activity_code IN VARCHAR2 DEFAULT 'CALCULATE'
7780: ,p_resource_assignment_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7781: ,p_delete_budget_lines_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7782: ,p_spread_amts_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7783: ,p_txn_currency_code_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
7784: ,p_txn_currency_override_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
7785: ,p_total_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 7782: ,p_spread_amts_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()

7778: ,p_calling_module IN VARCHAR2 DEFAULT 'UPDATE_PLAN_TRANSACTION'
7779: ,p_activity_code IN VARCHAR2 DEFAULT 'CALCULATE'
7780: ,p_resource_assignment_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7781: ,p_delete_budget_lines_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7782: ,p_spread_amts_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7783: ,p_txn_currency_code_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
7784: ,p_txn_currency_override_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()
7785: ,p_total_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7786: ,p_addl_qty_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()

Line 7812: ,p_re_spread_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_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
7816: we will pass N and for other calls to calculate api it would

Line 7813: ,p_rlm_id_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_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
7816: we will pass N and for other calls to calculate api it would
7817: be yes */

Line 7818: ,p_fp_task_billable_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type() /* default 'D' */

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
7816: we will pass N and for other calls to calculate api it would
7817: be yes */
7818: ,p_fp_task_billable_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type() /* default 'D' */
7819: ,p_clientExtn_api_call_flag IN VARCHAR2 DEFAULT 'Y'
7820: ,p_raTxn_rollup_api_call_flag IN VARCHAR2 DEFAULT 'Y' /* Bug fix:4900436 */
7821: ,x_return_status OUT NOCOPY VARCHAR2
7822: ,x_msg_count OUT NOCOPY NUMBER

Line 7843: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7839: l_message_name VARCHAR2(100);
7840:
7841: -- TABLE IN LOCAL VARIABLES
7842: l_resource_assignment_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7843: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7844: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7845: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type();
7846: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type();
7847: l_total_qty_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 7844: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7840:
7841: -- TABLE IN LOCAL VARIABLES
7842: l_resource_assignment_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7843: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7844: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7845: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type();
7846: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type();
7847: l_total_qty_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7848: l_addl_qty_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 7871: l_re_spread_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_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();
7875: l_mfc_cost_type_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 7872: l_sp_curve_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_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();
7875: l_mfc_cost_type_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7876: l_mfc_cost_type_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 7873: l_plan_dates_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_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();
7875: l_mfc_cost_type_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7876: l_mfc_cost_type_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7877: l_mfc_cost_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

Line 7874: l_spfix_date_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_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();
7875: l_mfc_cost_type_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7876: l_mfc_cost_type_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7877: l_mfc_cost_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7878: l_rlm_id_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

Line 7877: l_mfc_cost_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();
7875: l_mfc_cost_type_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7876: l_mfc_cost_type_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7877: l_mfc_cost_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7878: l_rlm_id_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7879: l_plan_sdate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7880: l_plan_edate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7881: l_mfc_cost_refresh_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

Line 7878: l_rlm_id_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();
7875: l_mfc_cost_type_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7876: l_mfc_cost_type_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7877: l_mfc_cost_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7878: l_rlm_id_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7879: l_plan_sdate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7880: l_plan_edate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7881: l_mfc_cost_refresh_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7882: l_ra_in_multi_cur_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

Line 7879: l_plan_sdate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7875: l_mfc_cost_type_id_old_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7876: l_mfc_cost_type_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7877: l_mfc_cost_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7878: l_rlm_id_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7879: l_plan_sdate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7880: l_plan_edate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7881: l_mfc_cost_refresh_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7882: l_ra_in_multi_cur_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7883: l_fp_task_billable_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

Line 7880: l_plan_edate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7876: l_mfc_cost_type_id_new_tab SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
7877: l_mfc_cost_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7878: l_rlm_id_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7879: l_plan_sdate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7880: l_plan_edate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7881: l_mfc_cost_refresh_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7882: l_ra_in_multi_cur_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7883: l_fp_task_billable_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7884:

Line 7881: l_mfc_cost_refresh_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7877: l_mfc_cost_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7878: l_rlm_id_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7879: l_plan_sdate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7880: l_plan_edate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7881: l_mfc_cost_refresh_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7882: l_ra_in_multi_cur_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7883: l_fp_task_billable_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7884:
7885: l_quantity_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

Line 7882: l_ra_in_multi_cur_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7878: l_rlm_id_change_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7879: l_plan_sdate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7880: l_plan_edate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7881: l_mfc_cost_refresh_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7882: l_ra_in_multi_cur_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7883: l_fp_task_billable_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7884:
7885: l_quantity_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7886: l_raw_cost_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

Line 7883: l_fp_task_billable_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7879: l_plan_sdate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7880: l_plan_edate_shrunk_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7881: l_mfc_cost_refresh_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7882: l_ra_in_multi_cur_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7883: l_fp_task_billable_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7884:
7885: l_quantity_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7886: l_raw_cost_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7887: l_cost_rate_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

Line 7885: l_quantity_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7881: l_mfc_cost_refresh_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7882: l_ra_in_multi_cur_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7883: l_fp_task_billable_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7884:
7885: l_quantity_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7886: l_raw_cost_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7887: l_cost_rate_changed_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();

Line 7886: l_raw_cost_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7882: l_ra_in_multi_cur_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7883: l_fp_task_billable_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7884:
7885: l_quantity_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7886: l_raw_cost_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7887: l_cost_rate_changed_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();

Line 7887: l_cost_rate_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7883: l_fp_task_billable_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7884:
7885: l_quantity_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7886: l_raw_cost_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7887: l_cost_rate_changed_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();

Line 7888: l_burden_cost_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7884:
7885: l_quantity_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7886: l_raw_cost_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7887: l_cost_rate_changed_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();

Line 7889: l_burden_rate_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7885: l_quantity_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7886: l_raw_cost_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7887: l_cost_rate_changed_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();

Line 7890: l_rev_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7886: l_raw_cost_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7887: l_cost_rate_changed_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:

Line 7891: l_bill_rate_changed_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7887: l_cost_rate_changed_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();

Line 7895: l_cost_rt_miss_num_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();
7898: l_Qty_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7899: l_Rw_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

Line 7896: l_burd_rt_miss_num_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();
7898: l_Qty_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7899: l_Rw_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7900: l_Br_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

Line 7897: l_bill_rt_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_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();
7898: l_Qty_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7899: l_Rw_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7900: l_Br_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7901: l_Rv_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

Line 7898: l_Qty_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_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();
7898: l_Qty_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7899: l_Rw_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7900: l_Br_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7901: l_Rv_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7902: l_rev_only_entry_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

Line 7899: l_Rw_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

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();
7898: l_Qty_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7899: l_Rw_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7900: l_Br_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7901: l_Rv_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7902: l_rev_only_entry_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7903:

Line 7900: l_Br_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();
7898: l_Qty_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7899: l_Rw_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7900: l_Br_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7901: l_Rv_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7902: l_rev_only_entry_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7903:
7904: /* bug fix:5726773 */

Line 7901: l_Rv_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();
7898: l_Qty_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7899: l_Rw_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7900: l_Br_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7901: l_Rv_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7902: l_rev_only_entry_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7903:
7904: /* bug fix:5726773 */
7905: l_neg_Qty_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

Line 7902: l_rev_only_entry_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7898: l_Qty_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7899: l_Rw_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7900: l_Br_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7901: l_Rv_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7902: l_rev_only_entry_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7903:
7904: /* bug fix:5726773 */
7905: l_neg_Qty_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7906: l_neg_Raw_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

Line 7905: l_neg_Qty_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7901: l_Rv_miss_num_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7902: l_rev_only_entry_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7903:
7904: /* bug fix:5726773 */
7905: l_neg_Qty_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7906: l_neg_Raw_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7907: l_neg_Burd_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7908: l_neg_rev_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7909:

Line 7906: l_neg_Raw_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7902: l_rev_only_entry_flag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7903:
7904: /* bug fix:5726773 */
7905: l_neg_Qty_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7906: l_neg_Raw_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7907: l_neg_Burd_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7908: l_neg_rev_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7909:
7910: --pa_resource_assignemts local variables--

Line 7907: l_neg_Burd_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7903:
7904: /* bug fix:5726773 */
7905: l_neg_Qty_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7906: l_neg_Raw_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7907: l_neg_Burd_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7908: l_neg_rev_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7909:
7910: --pa_resource_assignemts local variables--
7911: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

Line 7908: l_neg_rev_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();

7904: /* bug fix:5726773 */
7905: l_neg_Qty_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7906: l_neg_Raw_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7907: l_neg_Burd_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7908: l_neg_rev_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7909:
7910: --pa_resource_assignemts local variables--
7911: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
7912: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;