[Home] [Help]
4118: l_quantity_tbl SYSTEM.pa_num_tbl_type;
4119: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4120: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4121: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4122: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
4123: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4124: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4125: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;
4126: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;
4123: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4124: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4125: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;
4126: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;
4127: l_bl_rb_flag_chg_tbl SYSTEM.pa_varchar2_1_tbl_type;
4128: l_target_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4129: l_prev_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
4130: l_temp_flag VARCHAR2(1);
4131: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4442: --The pa_fp_upgrade_pkg.Apply_Calculate_FPM_Rules API will return a pl-sql tbl of RA ids which can
4443: --be made non rate based. Note that this might not be equal in length to the input l_ra_id_tbl to that API
4444: --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
4445: --This tbl will have Y if the ra id is made non rate based . Otherwise it will contain N
4446: l_bl_rb_flag_chg_tbl := SYSTEM.pa_varchar2_1_tbl_type();
4447: IF p_src_plan_class_code = 'FORECAST' THEN
4448:
4449: IF l_debug_mode='Y' THEN
4450: