APPS.PA_DELIVERABLE_UTILS dependencies on PA_PROJECTS_ALL

Line 43: ( p_project_id IN pa_projects_all.project_id%TYPE

39: p_deliverable_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
40: ) RETURN VARCHAR2;
41:
42: PROCEDURE GET_OKE_FLAGS
43: ( p_project_id IN pa_projects_all.project_id%TYPE
44: ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE
45: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE
46: ,p_action_item_id IN pa_proj_elements.proj_element_id%TYPE
47: ,p_action_version_id IN pa_proj_element_versions.element_version_id%TYPE

Line 65: ( p_project_id IN pa_projects_all.project_id%TYPE

61: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
62: ) ;
63:
64: FUNCTION IS_TASK_ASSGMNT_EXISTS
65: ( p_project_id IN pa_projects_all.project_id%TYPE
66: ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE
67: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE
68: )
69: RETURN VARCHAR2 ;

Line 72: ( p_project_id IN pa_projects_all.project_id%TYPE

68: )
69: RETURN VARCHAR2 ;
70:
71: PROCEDURE IS_DLV_STATUS_CHANGE_ALLOWED
72: ( p_project_id IN pa_projects_all.project_id%TYPE
73: ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE
74: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE
75: ,p_dlv_type_id IN pa_task_types.task_type_id%TYPE
76: ,p_dlvr_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE

Line 218: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE

214: ) RETURN VARCHAR2;
215:
216: PROCEDURE GET_PROJECT_DETAILS
217: (
218: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
219: ,x_projfunc_currency_code OUT NOCOPY PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE --File.Sql.39 bug 4440895
220: ,x_org_id OUT NOCOPY PA_PLAN_RES_DEFAULTS.item_master_id%TYPE -- 3462360 changed type --File.Sql.39 bug 4440895
221: );
222:

Line 219: ,x_projfunc_currency_code OUT NOCOPY PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE --File.Sql.39 bug 4440895

215:
216: PROCEDURE GET_PROJECT_DETAILS
217: (
218: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
219: ,x_projfunc_currency_code OUT NOCOPY PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE --File.Sql.39 bug 4440895
220: ,x_org_id OUT NOCOPY PA_PLAN_RES_DEFAULTS.item_master_id%TYPE -- 3462360 changed type --File.Sql.39 bug 4440895
221: );
222:
223: -- OKEAPI

Line 258: ,x_project_name OUT NOCOPY PA_PROJECTS_ALL.NAME%TYPE --File.Sql.39 bug 4440895

254: PROCEDURE GET_DLVR_PROJECT_DETAIL
255: (
256: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
257: ,x_project_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJECT_ID%TYPE --File.Sql.39 bug 4440895
258: ,x_project_name OUT NOCOPY PA_PROJECTS_ALL.NAME%TYPE --File.Sql.39 bug 4440895
259: );
260:
261: -- OKEAPI
262: -- This API will return project id and project name

Line 268: ,x_project_name OUT NOCOPY PA_PROJECTS_ALL.NAME%TYPE --File.Sql.39 bug 4440895

264: PROCEDURE GET_ACTION_PROJECT_DETAIL
265: (
266: p_dlvr_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
267: ,x_project_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJECT_ID%TYPE --File.Sql.39 bug 4440895
268: ,x_project_name OUT NOCOPY PA_PROJECTS_ALL.NAME%TYPE --File.Sql.39 bug 4440895
269: );
270:
271: -- OKEAPI
272: -- This API will return task number based on task version id

Line 351: p_project_id IN pa_projects_all.project_id%TYPE

347: ) RETURN VARCHAR2;
348:
349: FUNCTION GET_ADJUSTED_DATES
350: (
351: p_project_id IN pa_projects_all.project_id%TYPE
352: ,p_dlv_due_date IN DATE
353: ,p_delta IN NUMBER
354: ) RETURN DATE ;
355:

Line 516: , p_project_id IN Pa_Projects_All.project_id%TYPE

512: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
513: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
514: , p_debug_mode IN VARCHAR2 := 'N'
515: , p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
516: , p_project_id IN Pa_Projects_All.project_id%TYPE
517: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
518: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
519: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
520: );