APPS.PA_DELIVERABLE_PUB dependencies on PA_PROJECTS_ALL

Line 167: l_project_number Pa_Projects_All.Segment1%TYPE;

163:
164: l_item_dlv VARCHAR2(1) := NULL;
165: l_dlv_rec oke_amg_grp.dlv_rec_type;
166:
167: l_project_number Pa_Projects_All.Segment1%TYPE;
168: l_task_number Pa_Proj_Elements.Name%TYPE;
169:
170: l_item_id OKE_DELIVERABLES_B.ITEM_ID%TYPE;
171: l_inventory_org_id OKE_DELIVERABLES_B.INVENTORY_ORG_ID%TYPE;

Line 246: FROM Pa_Projects_All

242: l_task_number := null;
243: END IF;
244:
245: SELECT segment1 INTO l_project_number
246: FROM Pa_Projects_All
247: WHERE project_id = p_project_id;
248:
249: IF l_debug_mode = 'Y' THEN
250: Pa_Debug.WRITE(g_module_name, 'token values proj ['||l_Project_Number||'] task ['||l_task_Number||']',l_debug_level3);

Line 1534: ,p_project_id IN pa_projects_all.project_id%TYPE

1530: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1531: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
1532: ,p_object_relationship_id IN pa_object_relationships.object_relationship_id%TYPE
1533: ,p_obj_rec_ver_number IN pa_object_relationships.record_version_number%TYPE
1534: ,p_project_id IN pa_projects_all.project_id%TYPE
1535: ,p_calling_context IN VARCHAR2 := 'TASKS'
1536: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1537: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1538: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1726: ,p_project_id IN pa_projects_all.project_id%TYPE

1722: ,p_dlv_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1723: ,p_rec_ver_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1724: ,p_dlv_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1725: ,p_dlv_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1726: ,p_project_id IN pa_projects_all.project_id%TYPE
1727: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1728: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1729: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1730: )

Line 1941: ,p_project_id IN pa_projects_all.project_id%TYPE

1937: ,p_element_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1938: ,p_element_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1939: ,p_task_or_dlv_elt_id IN NUMBER
1940: ,p_task_or_dlv_ver_id IN NUMBER
1941: ,p_project_id IN pa_projects_all.project_id%TYPE
1942: ,p_task_or_dlv IN VARCHAR2 := 'PA_TASKS'
1943: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1944: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1945: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2099: ,p_project_id IN pa_projects_all.project_id%TYPE

2095: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2096: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2097: ,p_debug_mode IN VARCHAR2 :='N'
2098: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2099: ,p_project_id IN pa_projects_all.project_id%TYPE
2100: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2101: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2102: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2103: )

Line 2235: ,p_project_id IN pa_projects_all.project_id%TYPE

2231: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2232: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
2233: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2234: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2235: ,p_project_id IN pa_projects_all.project_id%TYPE
2236: ,p_delete_or_validate IN VARCHAR2 := 'B' -- 3955848 V- Validate , D - Delete, B - Validate and Delete
2237: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2238: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2239: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895