APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_PROJ_PROGRESS_ATTR

Line 3253: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;

3249: --bug 3822112
3250: l_share_flag VARCHAR2(1) := 'N';
3251: l_copy_actuals_flag VARCHAR2(1) := 'Y';
3252: -- Bug 3839288 Begin
3253: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
3254: l_as_of_date DATE;
3255: -- Bug 3839288 End
3256: l_upd_new_elem_ver_id_flag VARCHAR2(1) := 'Y'; --rtarway, 3951024
3257:

Line 7340: from pa_proj_progress_attr

7336: l_wp_attr_rec get_wp_attr%ROWTYPE;
7337:
7338: CURSOR get_progress_attr(c_proj_element_id NUMBER, c_project_id NUMBER) IS -- For Bug 3968095
7339: select *
7340: from pa_proj_progress_attr
7341: where object_type = 'PA_STRUCTURES'
7342: and object_id = c_proj_element_id
7343: and project_id = c_project_id; -- For Bug 3968095
7344: l_progress_attr_rec get_progress_attr%ROWTYPE;

Line 9594: from pa_proj_progress_attr

9590: l_proj_workplan_attr_rec sel_proj_workplan_attr%ROWTYPE;
9591:
9592: cursor sel_proj_progress_attr(c_struc_id NUMBER) IS
9593: select *
9594: from pa_proj_progress_attr
9595: where project_id = p_project_id
9596: and object_type = 'PA_STRUCTURES'
9597: and object_id = c_struc_id;
9598: l_proj_progress_attr_rec sel_proj_progress_attr%ROWTYPE;

Line 11337: l_weight_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;

11333: l_finish_date DATE;
11334: l_template_flag VARCHAR2(1);
11335:
11336: --Bug 3010538.
11337: l_weight_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;
11338:
11339: CURSOR c1 IS
11340: select template_flag
11341: from pa_projects_all where project_id = p_project_id;

Line 13956: from pa_proj_progress_attr

13952: l_proj_workplan_attr_rec sel_proj_workplan_attr%ROWTYPE;
13953:
13954: cursor sel_proj_progress_attr(c_struc_id NUMBER) IS
13955: select *
13956: from pa_proj_progress_attr
13957: where project_id = p_project_id
13958: and object_type = 'PA_STRUCTURES'
13959: and object_id = c_struc_id;
13960: l_proj_progress_attr_rec sel_proj_progress_attr%ROWTYPE;

Line 14612: --create row in pa_proj_progress_attr

14608: END IF;
14609:
14610: /* Bug # 3420093. Progress Management changes. */
14611:
14612: --create row in pa_proj_progress_attr
14613: PA_PROGRESS_PUB.CREATE_PROJ_PROG_ATTR(
14614: p_project_id => p_project_id
14615: ,P_OBJECT_TYPE => 'PA_STRUCTURES'
14616: ,P_OBJECT_ID => l_structure_id

Line 16020: --delete from pa_proj_progress_attr

16016: END IF;
16017: END LOOP;
16018: CLOSE sel_other_structure_ver;
16019:
16020: --delete from pa_proj_progress_attr
16021: PA_PROGRESS_PUB.DELETE_PROJ_PROG_ATTR(
16022: p_validate_only => FND_API.G_FALSE
16023: ,p_project_id => p_project_id
16024: ,P_OBJECT_TYPE => 'PA_STRUCTURES'

Line 16555: --delete from pa_proj_progress_attr

16551: END IF;
16552: END LOOP;
16553: CLOSE sel_other_structure_ver;
16554:
16555: --delete from pa_proj_progress_attr
16556: PA_PROGRESS_PUB.DELETE_PROJ_PROG_ATTR(
16557: p_validate_only => FND_API.G_FALSE
16558: ,p_project_id => p_project_id
16559: ,P_OBJECT_TYPE => 'PA_STRUCTURES'