4153: l_src_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4154: l_src_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4155: l_targ_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4156: l_targ_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4157: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4158: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4159: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4160: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4161: l_targ_rlm_id_tbl SYSTEM.PA_NUM_TBL_TYPE; -- bug 3615617
4154: l_src_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4155: l_targ_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4156: l_targ_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4157: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4158: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4159: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4160: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4161: l_targ_rlm_id_tbl SYSTEM.PA_NUM_TBL_TYPE; -- bug 3615617
4162:
4155: l_targ_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4156: l_targ_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4157: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4158: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4159: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4160: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4161: l_targ_rlm_id_tbl SYSTEM.PA_NUM_TBL_TYPE; -- bug 3615617
4162:
4163: /* The existing cursors were replaced by the following cursors to get the resource assignments
4156: l_targ_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
4157: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4158: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4159: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4160: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE;
4161: l_targ_rlm_id_tbl SYSTEM.PA_NUM_TBL_TYPE; -- bug 3615617
4162:
4163: /* The existing cursors were replaced by the following cursors to get the resource assignments
4164: * for the impacted task, or its childrens or its parent's childrens as the case may be