2089:
2090: CURSOR c_get_task_weight_method(c_project_id NUMBER, c_structure_type VARCHAR2)
2091: IS
2092: SELECT task_weight_basis_code
2093: FROM pa_proj_progress_attr
2094: WHERE project_id = c_project_id
2095: AND structure_type = c_structure_type;
2096:
2097: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE; -- Bug 3606627
2093: FROM pa_proj_progress_attr
2094: WHERE project_id = c_project_id
2095: AND structure_type = c_structure_type;
2096:
2097: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE; -- Bug 3606627
2098: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE; -- Bug 3606627
2099: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE; -- Bug 3606627
2100:
2101: --maansari6/28 bug 3673618
2094: WHERE project_id = c_project_id
2095: AND structure_type = c_structure_type;
2096:
2097: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE; -- Bug 3606627
2098: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE; -- Bug 3606627
2099: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE; -- Bug 3606627
2100:
2101: --maansari6/28 bug 3673618
2102: l_progress_updated_flag VARCHAR2(1) := 'N';
2095: AND structure_type = c_structure_type;
2096:
2097: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE; -- Bug 3606627
2098: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE; -- Bug 3606627
2099: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE; -- Bug 3606627
2100:
2101: --maansari6/28 bug 3673618
2102: l_progress_updated_flag VARCHAR2(1) := 'N';
2103: l_raise_exception VARCHAR2(1) := 'N';