[Home] [Help]
4106: l_quantity_tbl SYSTEM.pa_num_tbl_type;
4107: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4108: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4109: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4110: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
4111: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4112: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4113: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;
4114: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;
4111: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4112: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4113: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;
4114: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;
4115: l_bl_rb_flag_chg_tbl SYSTEM.pa_varchar2_1_tbl_type;
4116: l_target_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4117: l_prev_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
4118: l_temp_flag VARCHAR2(1);
4119: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4430: --The pa_fp_upgrade_pkg.Apply_Calculate_FPM_Rules API will return a pl-sql tbl of RA ids which can
4431: --be made non rate based. Note that this might not be equal in length to the input l_ra_id_tbl to that API
4432: --The below block will prepare a pl-sql tbl l_bl_rb_flag_chg_tbl which will be equal in length to l_ra_id_tbl
4433: --This tbl will have Y if the ra id is made non rate based . Otherwise it will contain N
4434: l_bl_rb_flag_chg_tbl := SYSTEM.pa_varchar2_1_tbl_type();
4435: IF p_src_plan_class_code = 'FORECAST' THEN
4436:
4437: IF l_debug_mode='Y' THEN
4438: