DBA Data[Home] [Help]

APPS.PA_PROGRESS_PVT dependencies on PA_PROJ_PROGRESS_ATTR

Line 94: l_Rollup_Method pa_proj_progress_attr.task_weight_basis_code%TYPE ;

90: l_sharing_Enabled VARCHAR2(1) ;
91: l_split_workplan VARCHAR2(1) ;
92: l_structure_version_id NUMBER ;
93: g1_debug_mode VARCHAR2(1) ;
94: l_Rollup_Method pa_proj_progress_attr.task_weight_basis_code%TYPE ;
95:
96:
97: -- Rollup Cases
98: -- 1. Workplan Publsihed Version Rollup.

Line 4435: FROM pa_proj_progress_attr

4431: AND proj_element_id = c_task_id;
4432:
4433: CURSOR c_get_task_weightage_method(c_project_id number) IS
4434: SELECT task_weight_basis_code,progress_cycle_id ---4701759, 4701727
4435: FROM pa_proj_progress_attr
4436: WHERE project_id = c_project_id
4437: AND structure_type = 'WORKPLAN';
4438:
4439: CURSOR c_get_sub_proj_rollup IS

Line 4475: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;

4471: l_child_prog_cycle_id number; ---4701759, 4701727
4472: l_par_prog_cycle_id number;
4473: l_sub_project_rec c_get_sub_proj_rollup%ROWTYPE;
4474: l_parent_task_rec c_get_par_task_rollup%ROWTYPE;
4475: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
4476: L_BASE_STRUCT_VER_ID NUMBER;
4477:
4478: l_remaining_effort1 NUMBER ;
4479: l_ETC_Cost_PC NUMBER ;

Line 5528: l_Rollup_Method pa_proj_progress_attr.task_weight_basis_code%TYPE ;

5524: L_TASK_DERIVATION_CODE pa_proj_elements.base_percent_comp_deriv_code%TYPE ;
5525: l_split_workplan VARCHAR2(1) ;
5526: l_structure_version_id NUMBER ;
5527: g1_debug_mode VARCHAR2(1) ;
5528: l_Rollup_Method pa_proj_progress_attr.task_weight_basis_code%TYPE ;
5529:
5530:
5531: --This cursor selects the given task.
5532: CURSOR cur_tasks( c_task_ver_id NUMBER )