APPS.PA_DELIVERABLE_UTILS dependencies on PA_TASK_TYPES

Line 13: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

9: ) RETURN VARCHAR2;
10:
11: FUNCTION IS_DLV_TYPE_IN_USE
12: (
13: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
14: ) RETURN VARCHAR2;
15:
16: FUNCTION IS_DLV_TYPE_ACTIONS_EXISTS
17: (

Line 18: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

14: ) RETURN VARCHAR2;
15:
16: FUNCTION IS_DLV_TYPE_ACTIONS_EXISTS
17: (
18: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
19: ) RETURN VARCHAR2;
20:
21: FUNCTION IS_DLV_ACTIONS_EXISTS
22: (

Line 23: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

19: ) RETURN VARCHAR2;
20:
21: FUNCTION IS_DLV_ACTIONS_EXISTS
22: (
23: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
24: ) RETURN VARCHAR2;
25:
26: FUNCTION IS_DLV_BASED_ASSCN_EXISTS
27: (

Line 28: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

24: ) RETURN VARCHAR2;
25:
26: FUNCTION IS_DLV_BASED_ASSCN_EXISTS
27: (
28: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
29: ) RETURN VARCHAR2;
30:
31: FUNCTION IS_EFF_FROM_TO_DATE_VALID
32: (

Line 75: ,p_dlv_type_id IN pa_task_types.task_type_id%TYPE

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
77: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
78: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
79: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 85: FUNCTION GET_DLV_TYPE_CLASS_CODE(p_dlvr_type_id IN pa_task_types.task_type_id%TYPE )

81:
82: FUNCTION GET_FUNCTION_CODE(p_action_element_id IN pa_proj_elements.proj_element_id%TYPE)
83: RETURN VARCHAR2 ;
84:
85: FUNCTION GET_DLV_TYPE_CLASS_CODE(p_dlvr_type_id IN pa_task_types.task_type_id%TYPE )
86: RETURN VARCHAR2 ;
87:
88: FUNCTION IS_DLV_DOC_DEFINED(p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
89: ,p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

Line 142: p_dlvr_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

138: ) RETURN VARCHAR2;
139:
140: PROCEDURE GET_DLVR_TYPE_INFO
141: (
142: p_dlvr_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
143: ,x_dlvr_prg_enabled OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
144: ,x_dlvr_action_enabled OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
145: ,x_dlvr_default_status_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
146: );

Line 417: , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895

413: , p_dlvr_owner_name IN VARCHAR2 := NULL
414: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
416: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895
417: , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895
418: , p_carrying_out_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
419: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
420: , p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
421: , p_calling_mode IN VARCHAR2 := 'INSERT'

Line 506: , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895

502: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
503: , p_dlvr_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
504: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
505: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895
506: , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895
507: , p_calling_Mode IN VARCHAR2 := 'INSERT'
508: ) ;
509:
510: Procedure enable_deliverable(