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_FIN_PLAN_UTILS dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 10416: FROM PA_RESOURCE_ASSIGNMENTS a, pa_proj_element_versions pelm

10412: SELECT 'Y'
10413: INTO l_exists
10414: FROM DUAL
10415: WHERE EXISTS (SELECT 'x'
10416: FROM PA_RESOURCE_ASSIGNMENTS a, pa_proj_element_versions pelm
10417: WHERE a.budget_version_id = p_budget_version_id
10418: AND a.task_id = pelm.proj_element_id
10419: AND a.resource_class_code = PA_FP_CONSTANTS_PKG.G_RESOURCE_CLASS_CODE_FIN
10420: AND a.task_id = p_task_id

Line 10527: FROM pa_proj_element_versions ppev1,

10523: and pst.structure_type_class_code = 'WORKPLAN';
10524:
10525: CURSOR get_tasks (c_structure_id pa_proj_elements.proj_element_id%TYPE) IS
10526: SELECT ppev1.proj_element_id
10527: FROM pa_proj_element_versions ppev1,
10528: pa_proj_element_versions ppev2
10529: WHERE ppev2.object_type = 'PA_STRUCTURES'
10530: AND ppev2.project_id = p_project_id
10531: AND ppev2.proj_element_id = c_structure_id

Line 10528: pa_proj_element_versions ppev2

10524:
10525: CURSOR get_tasks (c_structure_id pa_proj_elements.proj_element_id%TYPE) IS
10526: SELECT ppev1.proj_element_id
10527: FROM pa_proj_element_versions ppev1,
10528: pa_proj_element_versions ppev2
10529: WHERE ppev2.object_type = 'PA_STRUCTURES'
10530: AND ppev2.project_id = p_project_id
10531: AND ppev2.proj_element_id = c_structure_id
10532: AND ppev1.parent_structure_version_id = ppev2.element_version_id

Line 10541: from pa_proj_element_versions ppev1,

10537: where project_id = p_project_id
10538: and object_type = 'PA_TASKS'
10539: and proj_element_id IN (
10540: select ppev1.proj_element_id
10541: from pa_proj_element_versions ppev1,
10542: pa_proj_element_versions ppev2
10543: where ppev2.object_type = 'PA_STRUCTURES'
10544: and ppev2.project_id = p_project_id
10545: and ppev2.proj_element_id = c_structure_id

Line 10542: pa_proj_element_versions ppev2

10538: and object_type = 'PA_TASKS'
10539: and proj_element_id IN (
10540: select ppev1.proj_element_id
10541: from pa_proj_element_versions ppev1,
10542: pa_proj_element_versions ppev2
10543: where ppev2.object_type = 'PA_STRUCTURES'
10544: and ppev2.project_id = p_project_id
10545: and ppev2.proj_element_id = c_structure_id
10546: and ppev1.parent_structure_version_id = ppev2.element_version_id);

Line 12931: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE)

12927: is introduced as part of performance improvement for FP.M excel download.
12928: */
12929: FUNCTION get_physical_pc_complete
12930: ( p_project_id IN pa_projects_all.project_id%TYPE,
12931: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE)
12932:
12933: RETURN NUMBER IS
12934:
12935: l_msg_count NUMBER;

Line 12981: (p_structure_version_id IN pa_proj_element_versions.parent_structure_version_id%TYPE,

12977:
12978: END get_physical_pc_complete;
12979:
12980: FUNCTION set_webadi_download_var
12981: (p_structure_version_id IN pa_proj_element_versions.parent_structure_version_id%TYPE,
12982: p_structure_status_flag IN VARCHAR2)
12983:
12984: RETURN VARCHAR2
12985: IS

Line 13007: x_struct_version_id OUT NOCOPY pa_proj_element_versions.parent_structure_version_id%TYPE,

13003: * and the structure version status flag to be used as URL parameter for BNE URL
13004: */
13005: PROCEDURE return_struct_ver_info
13006: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
13007: x_struct_version_id OUT NOCOPY pa_proj_element_versions.parent_structure_version_id%TYPE,
13008: x_struct_status_flag OUT NOCOPY VARCHAR2,
13009: x_return_status OUT NOCOPY VARCHAR2,
13010: x_msg_count OUT NOCOPY NUMBER,
13011: x_msg_data OUT NOCOPY VARCHAR2)