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

Line 846: PA_PROJ_ELEMENT_VERSIONS PEV

842: Cursor c_actn_info(l_action_ver_id IN NUMBER) IS
843: SELECT
844: PEV.PROJ_ELEMENT_ID
845: FROM
846: PA_PROJ_ELEMENT_VERSIONS PEV
847: WHERE
848: PEV.ELEMENT_VERSION_ID = l_action_ver_id
849: AND PEV.OBJECT_TYPE = 'PA_ACTIONS';
850:

Line 1513: CURSOR c_completed_date (c_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE) IS

1509: pa_proj_elements ppe
1510: WHERE ppe.proj_element_id = c_action_id
1511: AND pps.project_status_code = ppe.status_code ;
1512:
1513: CURSOR c_completed_date (c_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE) IS
1514: SELECT actual_finish_date
1515: ,scheduled_finish_date
1516: FROM pa_proj_elem_ver_schedule
1517: WHERE element_version_id = c_action_ver_id ;

Line 1543: PA_PROJ_ELEMENT_VERSIONS PEV

1539: Cursor c_actn_info(l_action_ver_id IN NUMBER) IS
1540: SELECT
1541: PEV.PROJ_ELEMENT_ID
1542: FROM
1543: PA_PROJ_ELEMENT_VERSIONS PEV
1544: WHERE
1545: PEV.ELEMENT_VERSION_ID = l_action_ver_id
1546: AND PEV.OBJECT_TYPE = 'PA_ACTIONS';
1547:

Line 2387: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE

2383: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2384: ,p_debug_mode IN VARCHAR2 :='N'
2385: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2386: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
2387: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
2388: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2389: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2390: ,p_function_code IN pa_proj_elements.function_code%TYPE
2391: ,p_project_id IN pa_projects_all.project_id%TYPE

Line 2389: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE

2385: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2386: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
2387: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
2388: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2389: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2390: ,p_function_code IN pa_proj_elements.function_code%TYPE
2391: ,p_project_id IN pa_projects_all.project_id%TYPE
2392: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2393: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2410: PA_PROJ_ELEMENT_VERSIONS PEV

2406: Cursor c_actn_info IS
2407: SELECT
2408: PEV.PROJ_ELEMENT_ID
2409: FROM
2410: PA_PROJ_ELEMENT_VERSIONS PEV
2411: WHERE
2412: PEV.ELEMENT_VERSION_ID = p_action_ver_id
2413: AND PEV.OBJECT_TYPE = 'PA_ACTIONS'
2414: AND PEV.PROJECT_ID = p_project_id;

Line 2614: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null

2610: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
2611: ,p_source_project_id IN pa_projects_all.project_id%TYPE
2612: ,p_target_project_id IN pa_projects_all.project_id%TYPE
2613: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null
2614: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null
2615: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
2616: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
2617: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
2618: ,p_calling_mode IN VARCHAR2 := NULL -- Added for bug# 3911050

Line 3022: l_object_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL ;

3018: l_attribute15_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;
3019:
3020: l_project_id PA_PROJ_ELEMENTS.PROJECT_ID%TYPE := NULL ;
3021: l_object_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE := NULL ;
3022: l_object_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL ;
3023: l_object_type PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := NULL ;
3024: l_pm_source_code VARCHAR2(30) := NULL ;
3025: l_pm_source_reference VARCHAR2(30) := NULL ;
3026: -- to be modified l_pm_source_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() ;

Line 3074: FROM pa_proj_element_versions vers

3070: , proj.segment1
3071: , elem.element_Number
3072: , proj.project_id
3073: , Pa_Deliverable_Utils.IS_Dlvr_Item_Based(vers.element_version_id)
3074: FROM pa_proj_element_versions vers
3075: , pa_proj_elements elem
3076: , pa_projects_all proj
3077: WHERE vers.proj_element_id = elem.proj_element_id
3078: AND elem.project_id = vers.project_id

Line 3094: FROM pa_proj_element_versions pev

3090: -- proj element id is passed as argument
3091:
3092: Cursor C_act_ver (p_proj_element_id IN NUMBER) IS
3093: SELECT pev.element_version_id
3094: FROM pa_proj_element_versions pev
3095: WHERE pev.proj_element_id = p_proj_element_id
3096: AND pev.object_type = 'PA_ACTIONS';
3097:
3098: -- 3749462 changes for financial top task and lowest chargeable task validation