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_DELIVERABLE_PVT dependencies on PA_PROJECTS_ALL

Line 1648: ,p_project_id IN pa_projects_all.project_id%TYPE

1644: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1645: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1646: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
1647: ,p_rec_ver_number IN pa_proj_elements.record_version_number%TYPE
1648: ,p_project_id IN pa_projects_all.project_id%TYPE
1649: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1650: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1651: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1652: )

Line 2089: ,p_project_id IN pa_projects_all.project_id%TYPE

2085: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2086: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2087: ,p_object_relationship_id IN pa_object_relationships.object_relationship_id%TYPE
2088: ,p_obj_rec_ver_number IN pa_object_relationships.record_version_number%TYPE
2089: ,p_project_id IN pa_projects_all.project_id%TYPE
2090: ,p_calling_context IN VARCHAR2 -- Bug 3555460
2091: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2092: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2093: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2314: ,p_project_id IN pa_projects_all.project_id%TYPE

2310: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2311: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2312: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2313: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2314: ,p_project_id IN pa_projects_all.project_id%TYPE
2315: ,p_calling_context IN VARCHAR2 -- Bug 3555460
2316: ,x_disassociation_allowed OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2317: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2318: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2440: ,p_project_id IN pa_projects_all.project_id%TYPE

2436: ,p_element_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
2437: ,p_element_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
2438: ,p_task_or_dlv_elt_id IN NUMBER
2439: ,p_task_or_dlv_ver_id IN NUMBER
2440: ,p_project_id IN pa_projects_all.project_id%TYPE
2441: ,p_task_or_dlv IN VARCHAR2 := 'PA_TASKS'
2442: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2443: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2444: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2686: ,p_project_id IN pa_projects_all.project_id%TYPE

2682: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2683: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2684: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2685: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2686: ,p_project_id IN pa_projects_all.project_id%TYPE
2687: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2688: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2689: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2690: )

Line 2923: ,p_project_id IN pa_projects_all.project_id%TYPE

2919: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2920: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2921: ,p_debug_mode IN VARCHAR2 :='N'
2922: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2923: ,p_project_id IN pa_projects_all.project_id%TYPE
2924: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2925: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2926: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2927: )

Line 3181: ,p_project_id IN pa_projects_all.project_id%TYPE

3177: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3178: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
3179: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
3180: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
3181: ,p_project_id IN pa_projects_all.project_id%TYPE
3182: ,p_delete_or_validate IN VARCHAR2 := 'B' -- 3955848 V- Validate , D - Delete, B - Validate and Delete ( default )
3183: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3184: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3185: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3822: PA_PROJECTS_ALL pa

3818: ,pa.project_status_code
3819: ,project_system_status_code
3820: ,segment1 -- 3671408 added column to retrieve project number
3821: FROM PA_PROJECT_STATUSES pps,
3822: PA_PROJECTS_ALL pa
3823: WHERE pa.PROJECT_ID = p_target_project_id
3824: AND pps.PROJECT_STATUS_CODE = pa.PROJECT_STATUS_CODE ;
3825:
3826: l_project_sys_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;

Line 3828: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;

3824: AND pps.PROJECT_STATUS_CODE = pa.PROJECT_STATUS_CODE ;
3825:
3826: l_project_sys_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
3827: l_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
3828: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
3829:
3830: l_item_type VARCHAR2(30);
3831: l_wf_process VARCHAR2(30);
3832: l_wf_item_type VARCHAR2(30);

Line 3845: l_project_name pa_projects_all.name%TYPE ;

3841: l_due_date DATE ;
3842: l_parent_structure_id NUMBER ;
3843: l_parent_structure_version_id NUMBER ;
3844: l_y_or_n VARCHAR2(1) ;
3845: l_project_name pa_projects_all.name%TYPE ;
3846: l_suffix pa_lookups.meaning%TYPE ;
3847: l_name VARCHAR2(250);
3848:
3849: l_element_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;

Line 3889: l_project_number pa_projects_all.segment1%TYPE ; -- added for bug# 3671408

3885: l_date DATE ;
3886: -- Bug#3515852 : This flag is no more required. Hence commenting.
3887: -- l_item_details_flag VARCHAR2(1) := 'N' ; -- 3469876 added the variable
3888:
3889: l_project_number pa_projects_all.segment1%TYPE ; -- added for bug# 3671408
3890:
3891: BEGIN
3892:
3893: l_msg_count := 0;

Line 3927: FROM pa_projects_all

3923: AND lookup_code = 'DELIVERABLE';
3924:
3925: SELECT name
3926: INTO l_project_name
3927: FROM pa_projects_all
3928: WHERE project_id = p_target_project_id ;
3929:
3930:
3931: