eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_PLANNING_ELEMENT_UTILS dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 27: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,

23: l_edit_plan_bv_id pa_budget_versions.budget_version_id%TYPE;
24:
25: PROCEDURE get_workplan_bvids
26: (p_project_id IN pa_budget_versions.project_id%TYPE,
27: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
28: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
29: x_baselined_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
30: x_published_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
31: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 42: from pa_proj_element_versions ev,

38: -- RETRIEVE THE WORKPLAN STRUCTURE VERSION ID which is used for
39: -- join with pa_budget_versions
40: select evs.element_version_id -- changed by shyugen
41: into l_wp_structure_version_id
42: from pa_proj_element_versions ev,
43: pa_proj_elem_ver_structure evs
44: where ev.project_id = p_project_id and
45: ev.element_version_id = p_element_version_id and
46: ev.project_id = evs.project_id and -- Added for perf fix - 3961665

Line 76: pa_proj_element_versions ppev1,

72: begin
73: select bv.budget_version_id
74: into x_baselined_version_id
75: from pa_proj_elem_ver_structure str,
76: pa_proj_element_versions ppev1,
77: pa_proj_element_versions ppev2,
78: pa_budget_versions bv
79: where ppev1.element_version_id = p_element_version_id
80: and ppev1.project_id = ppev2.project_id

Line 77: pa_proj_element_versions ppev2,

73: select bv.budget_version_id
74: into x_baselined_version_id
75: from pa_proj_elem_ver_structure str,
76: pa_proj_element_versions ppev1,
77: pa_proj_element_versions ppev2,
78: pa_budget_versions bv
79: where ppev1.element_version_id = p_element_version_id
80: and ppev1.project_id = ppev2.project_id
81: and ppev1.proj_element_id = ppev2.proj_element_id -- all the other task versions

Line 96: pa_proj_element_versions ppev1,

92: begin
93: select bv.budget_version_id
94: into x_published_version_id
95: from pa_proj_elem_ver_structure str,
96: pa_proj_element_versions ppev1,
97: pa_proj_element_versions ppev2,
98: pa_budget_versions bv
99: where ppev1.element_version_id = p_element_version_id
100: and ppev1.project_id = ppev2.project_id

Line 97: pa_proj_element_versions ppev2,

93: select bv.budget_version_id
94: into x_published_version_id
95: from pa_proj_elem_ver_structure str,
96: pa_proj_element_versions ppev1,
97: pa_proj_element_versions ppev2,
98: pa_budget_versions bv
99: where ppev1.element_version_id = p_element_version_id
100: and ppev1.project_id = ppev2.project_id
101: and ppev1.proj_element_id = ppev2.proj_element_id -- all the other task versions

Line 437: pa_proj_element_versions pelm

433: into l_element_version_id,
434: l_rlm_id,
435: l_project_id
436: from pa_resource_assignments ra,
437: pa_proj_element_versions pelm
438: where ra.resource_assignment_id = p_resource_assignment_id
439: AND pelm.proj_element_id(+)=ra.task_id
440: AND pelm.parent_structure_Version_id(+)=PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(ra.project_id);
441: EXCEPTION

Line 2727: l_structure_version_id PA_PROJ_ELEMENT_VERSIONS.PARENT_STRUCTURE_VERSION_ID%TYPE;

2723: l_debug_mode VARCHAR2(30);
2724: --End of variables used for debugging
2725:
2726: -- Start of Variable used for comparisons and calling ADD PLAN TXN API
2727: l_structure_version_id PA_PROJ_ELEMENT_VERSIONS.PARENT_STRUCTURE_VERSION_ID%TYPE;
2728: l_bl_already_exists VARCHAR2(1) := 'N';
2729: l_rec_already_exists VARCHAR2(1) := 'N';
2730: l_index NUMBER := 1;
2731:

Line 2856: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA,PA_PROJ_ELEMENT_VERSIONS PEV

2852: SELECT 'Y'
2853: INTO l_bl_already_exists
2854: FROM DUAL
2855: WHERE EXISTS ( SELECT 1
2856: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA,PA_PROJ_ELEMENT_VERSIONS PEV
2857: WHERE PRA.PROJECT_ID = p_project_id
2858: AND PRA.BUDGET_VERSION_ID = p_budget_version_id
2859: AND PRA.RESOURCE_LIST_MEMBER_ID = p_resource_list_member_id_tbl(i)
2860: AND PEV.PROJ_ELEMENT_ID = PRA.TASK_ID

Line 2887: -- PA_PROJ_ELEMENT_VERSIONS from the FROM clause of the

2883:
2884: BEGIN
2885: -- SQL Repository Bug 4884718; SQL ID 14903213
2886: -- Fixed Merge Join Cartesian violation by commenting out
2887: -- PA_PROJ_ELEMENT_VERSIONS from the FROM clause of the
2888: -- query below. It seems to be a copy/past artifact, as it
2889: -- is not references anywhere in the WHERE clause.
2890:
2891: SELECT 'Y'

Line 2896: --,PA_PROJ_ELEMENT_VERSIONS PEV /* Bug 4884718; SQL ID 14903213 */

2892: INTO l_bl_already_exists
2893: FROM DUAL
2894: WHERE EXISTS ( SELECT 1
2895: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA
2896: --,PA_PROJ_ELEMENT_VERSIONS PEV /* Bug 4884718; SQL ID 14903213 */
2897: WHERE PRA.PROJECT_ID = p_project_id
2898: AND PRA.BUDGET_VERSION_ID = p_budget_version_id
2899: AND PRA.RESOURCE_LIST_MEMBER_ID = p_resource_list_member_id_tbl(i)
2900: AND PRA.TASK_ID = 0

Line 3197: p_wbs_project_element_id IN pa_proj_element_versions.proj_element_id%TYPE,

3193: -- must be set to 'N'
3194: FUNCTION get_wbs_element_name_from_id
3195: (p_project_id IN pa_projects_all.project_id%TYPE,
3196: p_wbs_element_version_id IN pa_resource_assignments.wbs_element_version_id%TYPE,
3197: p_wbs_project_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
3198: p_use_element_version_flag IN VARCHAR2)
3199: return VARCHAR2
3200: IS
3201: l_return_value pa_proj_elements.name%TYPE;

Line 3222: from pa_proj_element_versions pev,

3218: else
3219: -- using wbs_element_version_id
3220: select pe.name
3221: into l_return_value
3222: from pa_proj_element_versions pev,
3223: pa_proj_elements pe
3224: where pev.element_version_id = p_wbs_element_version_id and
3225: pev.proj_element_id = pe.proj_element_id;
3226: return l_return_value;

Line 3238: (p_wbs_element_version_id IN pa_proj_element_versions.element_version_id%TYPE)

3234: END get_wbs_element_name_from_id;
3235:
3236:
3237: FUNCTION get_proj_element_id
3238: (p_wbs_element_version_id IN pa_proj_element_versions.element_version_id%TYPE)
3239: return NUMBER
3240: IS
3241: l_return_value pa_proj_element_versions.proj_element_id%TYPE;
3242: BEGIN

Line 3241: l_return_value pa_proj_element_versions.proj_element_id%TYPE;

3237: FUNCTION get_proj_element_id
3238: (p_wbs_element_version_id IN pa_proj_element_versions.element_version_id%TYPE)
3239: return NUMBER
3240: IS
3241: l_return_value pa_proj_element_versions.proj_element_id%TYPE;
3242: BEGIN
3243: select proj_element_id
3244: into l_return_value
3245: from pa_proj_element_versions

Line 3245: from pa_proj_element_versions

3241: l_return_value pa_proj_element_versions.proj_element_id%TYPE;
3242: BEGIN
3243: select proj_element_id
3244: into l_return_value
3245: from pa_proj_element_versions
3246: where element_version_id = p_wbs_element_version_id;
3247: return l_return_value;
3248: EXCEPTION
3249: when NO_DATA_FOUND then

Line 3279: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE,

3275:
3276: FUNCTION get_task_percent_complete
3277: (p_project_id IN pa_projects_all.project_id%TYPE,
3278: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3279: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
3280: p_calling_context IN VARCHAR2) return NUMBER
3281: is
3282: l_return_value NUMBER;
3283: l_structure_type VARCHAR2(30) := 'FINANCIAL'; -- could also be 'WORKPLAN'

Line 3286: l_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE;

3282: l_return_value NUMBER;
3283: l_structure_type VARCHAR2(30) := 'FINANCIAL'; -- could also be 'WORKPLAN'
3284: l_object_type VARCHAR2(30) := 'PA_TASKS';
3285: l_structure_status_flag VARCHAR2(1) := null;
3286: l_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE;
3287: l_structure_status VARCHAR2(30) := null;
3288: l_base_percent_complete NUMBER := null;
3289: l_return_status VARCHAR2(1);
3290: l_msg_count NUMBER;