60: l_effort_tbl t_proj_id_table;
61: l_elem_ver_id_tbl t_proj_id_table;
62: --
63: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
64: l_planning_start_tbl SYSTEM.pa_date_tbl_type;
65: l_planning_end_tbl SYSTEM.pa_date_tbl_type;
66: --
67: TYPE DYNAMIC_CUR IS REF CURSOR;
68: l_cur DYNAMIC_CUR;
61: l_elem_ver_id_tbl t_proj_id_table;
62: --
63: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
64: l_planning_start_tbl SYSTEM.pa_date_tbl_type;
65: l_planning_end_tbl SYSTEM.pa_date_tbl_type;
66: --
67: TYPE DYNAMIC_CUR IS REF CURSOR;
68: l_cur DYNAMIC_CUR;
69: l_sql VARCHAR2(32767);
1173: /* Bug #: 3305199 SMukka */
1174: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
1175: /*l_planning_start_tbl PA_PLSQL_DATATYPES.NumTabTyp; */
1176: /*l_planning_end_tbl PA_PLSQL_DATATYPES.NumTabTyp; */
1177: l_planning_start_tbl SYSTEM.pa_date_tbl_type;
1178: l_planning_end_tbl SYSTEM.pa_date_tbl_type;
1179:
1180: TYPE DYNAMIC_CUR IS REF CURSOR;
1181: l_cur DYNAMIC_CUR;
1174: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
1175: /*l_planning_start_tbl PA_PLSQL_DATATYPES.NumTabTyp; */
1176: /*l_planning_end_tbl PA_PLSQL_DATATYPES.NumTabTyp; */
1177: l_planning_start_tbl SYSTEM.pa_date_tbl_type;
1178: l_planning_end_tbl SYSTEM.pa_date_tbl_type;
1179:
1180: TYPE DYNAMIC_CUR IS REF CURSOR;
1181: l_cur DYNAMIC_CUR;
1182: l_sql VARCHAR2(32767);