7334: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
7335: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
7336: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7337: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7338: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
7339: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
7340:
7341: --hsiu: 3453772
7342: l_old_sch_date DATE;
7335: /* l_task_ver_ids2 PA_PLSQL_DATATYPES.IdTabTyp; */
7336: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7337: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
7338: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
7339: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(); /* Venky */
7340:
7341: --hsiu: 3453772
7342: l_old_sch_date DATE;
7343: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
7340:
7341: --hsiu: 3453772
7342: l_old_sch_date DATE;
7343: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
7344: l_planning_start_tbl SYSTEM.pa_date_tbl_type;
7345: l_planning_end_tbl SYSTEM.pa_date_tbl_type;
7346:
7347: l_ext_act_duration NUMBER;
7348: l_ext_remain_duration NUMBER;
7341: --hsiu: 3453772
7342: l_old_sch_date DATE;
7343: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
7344: l_planning_start_tbl SYSTEM.pa_date_tbl_type;
7345: l_planning_end_tbl SYSTEM.pa_date_tbl_type;
7346:
7347: l_ext_act_duration NUMBER;
7348: l_ext_remain_duration NUMBER;
7349: l_ext_sch_duration NUMBER;