APPS.PA_TASKS_MAINT_UTILS dependencies on PA_INTERFACE_UTILS_PUB

Line 8: p_task_mgr_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4:
5:
6: procedure CHECK_TASK_MGR_NAME_OR_ID
7: (
8: p_task_mgr_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9: ,p_task_mgr_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10: ,p_project_id IN NUMBER := NULL
11: ,p_check_id_flag IN VARCHAR2 := 'A'
12: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 9: ,p_task_mgr_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

5:
6: procedure CHECK_TASK_MGR_NAME_OR_ID
7: (
8: p_task_mgr_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9: ,p_task_mgr_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10: ,p_project_id IN NUMBER := NULL
11: ,p_check_id_flag IN VARCHAR2 := 'A'
12: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
13: ,x_task_mgr_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 21: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

17:
18:
19: procedure CHECK_TASK_NAME_OR_ID
20: (
21: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: ,p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23: ,p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,p_check_id_flag IN VARCHAR2 := 'A'
25: ,x_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 22: ,p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

18:
19: procedure CHECK_TASK_NAME_OR_ID
20: (
21: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: ,p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23: ,p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,p_check_id_flag IN VARCHAR2 := 'A'
25: ,x_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
26: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 23: ,p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

19: procedure CHECK_TASK_NAME_OR_ID
20: (
21: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: ,p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23: ,p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: ,p_check_id_flag IN VARCHAR2 := 'A'
25: ,x_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
26: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
27: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 32: p_project_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

28: );
29:
30: procedure CHECK_PROJECT_NAME_OR_ID
31: (
32: p_project_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
33: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
34: ,p_check_id_flag IN VARCHAR2 := 'A'
35: ,x_project_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
36: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 33: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

29:
30: procedure CHECK_PROJECT_NAME_OR_ID
31: (
32: p_project_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
33: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
34: ,p_check_id_flag IN VARCHAR2 := 'A'
35: ,x_project_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
36: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
37: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895