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.

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 2722: l_structure_version_id PA_PROJ_ELEMENT_VERSIONS.PARENT_STRUCTURE_VERSION_ID%TYPE;

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

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

2832: SELECT 'Y'
2833: INTO l_bl_already_exists
2834: FROM DUAL
2835: WHERE EXISTS ( SELECT 1
2836: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA,PA_PROJ_ELEMENT_VERSIONS PEV
2837: WHERE PRA.PROJECT_ID = p_project_id
2838: AND PRA.BUDGET_VERSION_ID = p_budget_version_id
2839: AND PRA.RESOURCE_LIST_MEMBER_ID = p_resource_list_member_id_tbl(i)
2840: AND PEV.PROJ_ELEMENT_ID = PRA.TASK_ID

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

2861:
2862: BEGIN
2863: -- SQL Repository Bug 4884718; SQL ID 14903213
2864: -- Fixed Merge Join Cartesian violation by commenting out
2865: -- PA_PROJ_ELEMENT_VERSIONS from the FROM clause of the
2866: -- query below. It seems to be a copy/past artifact, as it
2867: -- is not references anywhere in the WHERE clause.
2868:
2869: SELECT 'Y'

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

2870: INTO l_bl_already_exists
2871: FROM DUAL
2872: WHERE EXISTS ( SELECT 1
2873: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA
2874: --,PA_PROJ_ELEMENT_VERSIONS PEV /* Bug 4884718; SQL ID 14903213 */
2875: WHERE PRA.PROJECT_ID = p_project_id
2876: AND PRA.BUDGET_VERSION_ID = p_budget_version_id
2877: AND PRA.RESOURCE_LIST_MEMBER_ID = p_resource_list_member_id_tbl(i)
2878: AND PRA.TASK_ID = 0

Line 3153: p_wbs_project_element_id IN pa_proj_element_versions.proj_element_id%TYPE,

3149: -- must be set to 'N'
3150: FUNCTION get_wbs_element_name_from_id
3151: (p_project_id IN pa_projects_all.project_id%TYPE,
3152: p_wbs_element_version_id IN pa_resource_assignments.wbs_element_version_id%TYPE,
3153: p_wbs_project_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
3154: p_use_element_version_flag IN VARCHAR2)
3155: return VARCHAR2
3156: IS
3157: l_return_value pa_proj_elements.name%TYPE;

Line 3178: from pa_proj_element_versions pev,

3174: else
3175: -- using wbs_element_version_id
3176: select pe.name
3177: into l_return_value
3178: from pa_proj_element_versions pev,
3179: pa_proj_elements pe
3180: where pev.element_version_id = p_wbs_element_version_id and
3181: pev.proj_element_id = pe.proj_element_id;
3182: return l_return_value;

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

3190: END get_wbs_element_name_from_id;
3191:
3192:
3193: FUNCTION get_proj_element_id
3194: (p_wbs_element_version_id IN pa_proj_element_versions.element_version_id%TYPE)
3195: return NUMBER
3196: IS
3197: l_return_value pa_proj_element_versions.proj_element_id%TYPE;
3198: BEGIN

Line 3197: l_return_value pa_proj_element_versions.proj_element_id%TYPE;

3193: FUNCTION get_proj_element_id
3194: (p_wbs_element_version_id IN pa_proj_element_versions.element_version_id%TYPE)
3195: return NUMBER
3196: IS
3197: l_return_value pa_proj_element_versions.proj_element_id%TYPE;
3198: BEGIN
3199: select proj_element_id
3200: into l_return_value
3201: from pa_proj_element_versions

Line 3201: from pa_proj_element_versions

3197: l_return_value pa_proj_element_versions.proj_element_id%TYPE;
3198: BEGIN
3199: select proj_element_id
3200: into l_return_value
3201: from pa_proj_element_versions
3202: where element_version_id = p_wbs_element_version_id;
3203: return l_return_value;
3204: EXCEPTION
3205: when NO_DATA_FOUND then

Line 3235: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE,

3231:
3232: FUNCTION get_task_percent_complete
3233: (p_project_id IN pa_projects_all.project_id%TYPE,
3234: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3235: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
3236: p_calling_context IN VARCHAR2) return NUMBER
3237: is
3238: l_return_value NUMBER;
3239: l_structure_type VARCHAR2(30) := 'FINANCIAL'; -- could also be 'WORKPLAN'

Line 3242: l_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE;

3238: l_return_value NUMBER;
3239: l_structure_type VARCHAR2(30) := 'FINANCIAL'; -- could also be 'WORKPLAN'
3240: l_object_type VARCHAR2(30) := 'PA_TASKS';
3241: l_structure_status_flag VARCHAR2(1) := null;
3242: l_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE;
3243: l_structure_status VARCHAR2(30) := null;
3244: l_base_percent_complete NUMBER := null;
3245: l_return_status VARCHAR2(1);
3246: l_msg_count NUMBER;