DBA Data[Home] [Help]

APPS.PA_PROGRESS_PVT dependencies on PA_PROJ_PROGRESS_ATTR

Line 95: l_Rollup_Method pa_proj_progress_attr.task_weight_basis_code%TYPE ;

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

Line 4478: FROM pa_proj_progress_attr

4474: AND proj_element_id = c_task_id;
4475:
4476: CURSOR c_get_task_weightage_method(c_project_id number) IS
4477: SELECT task_weight_basis_code,progress_cycle_id ---4701759, 4701727
4478: FROM pa_proj_progress_attr
4479: WHERE project_id = c_project_id
4480: AND structure_type = 'WORKPLAN';
4481:
4482: CURSOR c_get_sub_proj_rollup IS

Line 4518: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;

4514: l_child_prog_cycle_id number; ---4701759, 4701727
4515: l_par_prog_cycle_id number;
4516: l_sub_project_rec c_get_sub_proj_rollup%ROWTYPE;
4517: l_parent_task_rec c_get_par_task_rollup%ROWTYPE;
4518: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
4519: L_BASE_STRUCT_VER_ID NUMBER;
4520:
4521: l_remaining_effort1 NUMBER ;
4522: l_ETC_Cost_PC NUMBER ;

Line 5594: l_Rollup_Method pa_proj_progress_attr.task_weight_basis_code%TYPE ;

5590: L_TASK_DERIVATION_CODE pa_proj_elements.base_percent_comp_deriv_code%TYPE ;
5591: l_split_workplan VARCHAR2(1) ;
5592: l_structure_version_id NUMBER ;
5593: g1_debug_mode VARCHAR2(1) ;
5594: l_Rollup_Method pa_proj_progress_attr.task_weight_basis_code%TYPE ;
5595:
5596:
5597: --This cursor selects the given task.
5598: CURSOR cur_tasks( c_task_ver_id NUMBER )

Line 10606: l_Rollup_Method pa_proj_progress_attr.task_weight_basis_code%TYPE ;

10602: l_sharing_Enabled VARCHAR2(1) ;
10603: l_split_workplan VARCHAR2(1) ;
10604: l_structure_version_id NUMBER ;
10605: g1_debug_mode VARCHAR2(1) ;
10606: l_Rollup_Method pa_proj_progress_attr.task_weight_basis_code%TYPE ;
10607:
10608:
10609: -- Rollup Cases
10610: -- 1. Workplan Publsihed Version Rollup.

Line 14162: l_Rollup_Method pa_proj_progress_attr.task_weight_basis_code%TYPE ;

14158: l_sharing_Enabled VARCHAR2(1) ;
14159: l_split_workplan VARCHAR2(1) ;
14160: l_structure_version_id NUMBER ;
14161: g1_debug_mode VARCHAR2(1) ;
14162: l_Rollup_Method pa_proj_progress_attr.task_weight_basis_code%TYPE ;
14163:
14164:
14165: -- sridhar_rollup
14166: