PACKAGE: APPS.PA_TASK_TYPE_UTILS

Source

1 PACKAGE  pa_task_type_utils AS
2 /*$Header: PATTUTLS.pls 120.1 2005/08/19 17:06:45 mwasowic noship $*/
3 
4 FUNCTION is_task_type_unique(p_task_type      IN  VARCHAR2,
5                              p_task_type_id   IN  NUMBER := NULL) RETURN VARCHAR2;
6 
7 PROCEDURE change_task_type_allowed(p_task_id IN NUMBER,
8           p_from_task_type_id     IN NUMBER,
9           p_to_task_type_id       IN NUMBER,
10           x_change_allowed        OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
11           x_return_status         OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
12           x_msg_count             OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
13           x_msg_data             OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
14 
15 
16 PROCEDURE change_wi_allowed(p_task_id IN NUMBER,
17           x_return_status         OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
18           x_msg_count             OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
19           x_msg_data             OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
20 
21 PROCEDURE change_uom_allowed(p_task_id IN NUMBER,
22           x_return_status         OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
23           x_msg_count             OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
24           x_msg_data             OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
25 
26 PROCEDURE check_planned_quantity(p_planned_quantity IN NUMBER,
27           p_actual_work_quantity  IN  NUMBER,
28           x_return_status         OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
29           x_msg_count             OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
30           x_msg_data             OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
31 
32 FUNCTION check_page_layout_referenced(
33 p_page_id    NUMBER ) RETURN BOOLEAN;
34 
35 PROCEDURE validate_progress_attributes(
36            p_prog_entry_enable_flag        IN VARCHAR2
37           ,p_prog_entry_req_flag           IN VARCHAR2
38           ,p_initial_progress_status_code  IN VARCHAR2
39           ,p_task_prog_entry_page_id       IN NUMBER
40           ,p_wq_enable_flag                IN VARCHAR2
41           ,p_work_item_code                IN VARCHAR2
42           ,p_uom_code                      IN VARCHAR2
43           ,p_actual_wq_entry_code          IN VARCHAR2
44           ,p_percent_comp_enable_flag      IN VARCHAR2
45           ,p_base_percent_comp_deriv_code  IN VARCHAR2
46           ,p_task_weighting_deriv_code     IN VARCHAR2
47           ,p_remain_effort_enable_flag     IN VARCHAR2
48           ,x_return_status                 OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
49           ,x_msg_count                     OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
50           ,x_msg_data                      OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
51 
52 FUNCTION check_tk_type_effective(p_task_type_id IN NUMBER)
53          RETURN VARCHAR2;
54 
55 FUNCTION check_tk_type_progressable(p_task_type_id IN NUMBER)
56          RETURN VARCHAR2;
57 
58 FUNCTION check_tk_type_wq_enabled(p_task_type_id IN NUMBER)
59          RETURN VARCHAR2;
60 
61 END pa_task_type_utils;