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_PROJECT_PVT dependencies on PA_PROJ_ELEMENTS

Line 4061: FROM pa_proj_elements

4057:
4058: CURSOR l_proj_element_id_csr
4059: IS
4060: SELECT 'X'
4061: FROM pa_proj_elements
4062: WHERE proj_element_id = p_pa_task_id
4063: AND project_id = p_pa_project_id;
4064:
4065: CURSOR cur_pa_proj_elems

Line 4068: FROM pa_proj_elements

4064:
4065: CURSOR cur_pa_proj_elems
4066: IS
4067: SELECT proj_element_id
4068: FROM pa_proj_elements
4069: WHERE PM_SOURCE_REFERENCE = p_pm_task_reference
4070: AND project_id = p_pa_project_id
4071: AND parent_structure_id = ( SELECT ppe.proj_element_id --Added this subQry for bug#3653517
4072: FROM pa_proj_elements ppe,

Line 4072: FROM pa_proj_elements ppe,

4068: FROM pa_proj_elements
4069: WHERE PM_SOURCE_REFERENCE = p_pm_task_reference
4070: AND project_id = p_pa_project_id
4071: AND parent_structure_id = ( SELECT ppe.proj_element_id --Added this subQry for bug#3653517
4072: FROM pa_proj_elements ppe,
4073: pa_proj_structure_types ppst,
4074: pa_structure_types pst
4075: WHERE ppe.proj_element_id = ppst.proj_element_id
4076: AND ppe.project_id = p_pa_project_id

Line 4153: --pa_proj_elements too.

4149: IF (p_structure_type = 'FINANCIAL') THEN
4150:
4151: --Added by rtarway, for BUG 3919800
4152: --Get the structure sharing type, if its partial shared structure, check for the task in
4153: --pa_proj_elements too.
4154:
4155: l_project_sharing_type := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(p_pa_project_id);
4156:
4157: IF p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 4175: -- hence task_id needs to be validaetd against pa_proj_elements if it does not exist in

4171: THEN
4172: --Added by rtarway, for BUG 3919800
4173: -- bug 8325536 - skkoppul : added SHARE_FULL structure_type condition. Update_task will
4174: -- always be called with structure_type as FINANCIAL in case of fully shared structure
4175: -- hence task_id needs to be validaetd against pa_proj_elements if it does not exist in
4176: -- pa_tasks table which is the case when task is never published.
4177: IF (l_project_sharing_type = 'SHARE_PARTIAL' OR l_project_sharing_type = 'SHARE_FULL')
4178: THEN
4179: OPEN l_proj_element_id_csr;

Line 10008: --only deletes from pa_proj_elements. There is a check in pa_task_pvt1.delete_task_version api not to delete from pa_tasks if called from AMG.

10004: CLOSE lock_tasks_csr;
10005:
10006: --bug 2765115
10007:
10008: --only deletes from pa_proj_elements. There is a check in pa_task_pvt1.delete_task_version api not to delete from pa_tasks if called from AMG.
10009: PA_PROJ_TASK_STRUC_PUB.delete_task_structure
10010: (
10011: p_calling_module => 'AMG'
10012: ,p_task_id => l_task_id

Line 11019: FROM pa_proj_elements ppe, pa_proj_structure_types ppst

11015: IS
11016: CURSOR cur_proj_elems
11017: IS
11018: SELECT ppe.proj_element_id
11019: FROM pa_proj_elements ppe, pa_proj_structure_types ppst
11020: WHERE ppe.proj_element_id = ppst.proj_element_id
11021: AND ppe.project_id = p_project_id
11022: AND ppe.object_type = 'PA_STRUCTURES'
11023: AND ppst.structure_type_id = 1 ;