58: l_effort_tbl t_proj_id_table;
59: l_elem_ver_id_tbl t_proj_id_table;
60: --
61: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
62: l_planning_start_tbl SYSTEM.pa_date_tbl_type;
63: l_planning_end_tbl SYSTEM.pa_date_tbl_type;
64: --
65: TYPE DYNAMIC_CUR IS REF CURSOR;
66: l_cur DYNAMIC_CUR;
59: l_elem_ver_id_tbl t_proj_id_table;
60: --
61: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
62: l_planning_start_tbl SYSTEM.pa_date_tbl_type;
63: l_planning_end_tbl SYSTEM.pa_date_tbl_type;
64: --
65: TYPE DYNAMIC_CUR IS REF CURSOR;
66: l_cur DYNAMIC_CUR;
67: l_sql VARCHAR2(32767);
1126: /* Bug #: 3305199 SMukka */
1127: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
1128: /*l_planning_start_tbl PA_PLSQL_DATATYPES.NumTabTyp; */
1129: /*l_planning_end_tbl PA_PLSQL_DATATYPES.NumTabTyp; */
1130: l_planning_start_tbl SYSTEM.pa_date_tbl_type;
1131: l_planning_end_tbl SYSTEM.pa_date_tbl_type;
1132:
1133: TYPE DYNAMIC_CUR IS REF CURSOR;
1134: l_cur DYNAMIC_CUR;
1127: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
1128: /*l_planning_start_tbl PA_PLSQL_DATATYPES.NumTabTyp; */
1129: /*l_planning_end_tbl PA_PLSQL_DATATYPES.NumTabTyp; */
1130: l_planning_start_tbl SYSTEM.pa_date_tbl_type;
1131: l_planning_end_tbl SYSTEM.pa_date_tbl_type;
1132:
1133: TYPE DYNAMIC_CUR IS REF CURSOR;
1134: l_cur DYNAMIC_CUR;
1135: l_sql VARCHAR2(32767);