APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_PROJ_PROGRESS_ATTR

Line 3283: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;

3279: --bug 3822112
3280: l_share_flag VARCHAR2(1) := 'N';
3281: l_copy_actuals_flag VARCHAR2(1) := 'Y';
3282: -- Bug 3839288 Begin
3283: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
3284: l_as_of_date DATE;
3285: -- Bug 3839288 End
3286: l_upd_new_elem_ver_id_flag VARCHAR2(1) := 'Y'; --rtarway, 3951024
3287:

Line 7400: from pa_proj_progress_attr

7396: l_wp_attr_rec get_wp_attr%ROWTYPE;
7397:
7398: CURSOR get_progress_attr(c_proj_element_id NUMBER, c_project_id NUMBER) IS -- For Bug 3968095
7399: select *
7400: from pa_proj_progress_attr
7401: where object_type = 'PA_STRUCTURES'
7402: and object_id = c_proj_element_id
7403: and project_id = c_project_id; -- For Bug 3968095
7404: l_progress_attr_rec get_progress_attr%ROWTYPE;

Line 9966: from pa_proj_progress_attr

9962: l_proj_workplan_attr_rec sel_proj_workplan_attr%ROWTYPE;
9963:
9964: cursor sel_proj_progress_attr(c_struc_id NUMBER) IS
9965: select *
9966: from pa_proj_progress_attr
9967: where project_id = p_project_id
9968: and object_type = 'PA_STRUCTURES'
9969: and object_id = c_struc_id;
9970: l_proj_progress_attr_rec sel_proj_progress_attr%ROWTYPE;

Line 11709: l_weight_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;

11705: l_finish_date DATE;
11706: l_template_flag VARCHAR2(1);
11707:
11708: --Bug 3010538.
11709: l_weight_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;
11710:
11711: CURSOR c1 IS
11712: select template_flag
11713: from pa_projects_all where project_id = p_project_id;

Line 14330: from pa_proj_progress_attr

14326: l_proj_workplan_attr_rec sel_proj_workplan_attr%ROWTYPE;
14327:
14328: cursor sel_proj_progress_attr(c_struc_id NUMBER) IS
14329: select *
14330: from pa_proj_progress_attr
14331: where project_id = p_project_id
14332: and object_type = 'PA_STRUCTURES'
14333: and object_id = c_struc_id;
14334: l_proj_progress_attr_rec sel_proj_progress_attr%ROWTYPE;

Line 14988: --create row in pa_proj_progress_attr

14984: END IF;
14985:
14986: /* Bug # 3420093. Progress Management changes. */
14987:
14988: --create row in pa_proj_progress_attr
14989: PA_PROGRESS_PUB.CREATE_PROJ_PROG_ATTR(
14990: p_project_id => p_project_id
14991: ,P_OBJECT_TYPE => 'PA_STRUCTURES'
14992: ,P_OBJECT_ID => l_structure_id

Line 16396: --delete from pa_proj_progress_attr

16392: END IF;
16393: END LOOP;
16394: CLOSE sel_other_structure_ver;
16395:
16396: --delete from pa_proj_progress_attr
16397: PA_PROGRESS_PUB.DELETE_PROJ_PROG_ATTR(
16398: p_validate_only => FND_API.G_FALSE
16399: ,p_project_id => p_project_id
16400: ,P_OBJECT_TYPE => 'PA_STRUCTURES'

Line 16931: --delete from pa_proj_progress_attr

16927: END IF;
16928: END LOOP;
16929: CLOSE sel_other_structure_ver;
16930:
16931: --delete from pa_proj_progress_attr
16932: PA_PROGRESS_PUB.DELETE_PROJ_PROG_ATTR(
16933: p_validate_only => FND_API.G_FALSE
16934: ,p_project_id => p_project_id
16935: ,P_OBJECT_TYPE => 'PA_STRUCTURES'