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
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 ;
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
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:
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
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
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
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:
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: );