[Home] [Help]
PACKAGE: APPS.PA_WORKPLAN_ATTR_UTILS
Source
1 PACKAGE PA_WORKPLAN_ATTR_UTILS AUTHID CURRENT_USER AS
2 /* $Header: PAPRWPUS.pls 120.1 2005/08/19 16:46:02 mwasowic noship $ */
3
4 -- API name : CHECK_LIFECYCLE_PHASE_NAME_ID
5 -- Type : Utility
6 -- Pre-reqs : None.
7 -- Parameters :
8 -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
9 -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
10 -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
11 -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
12 -- x_current_lifecycle_phase_id OUT NUMBER Required
13 -- x_return_status OUT VARCHAR2 Required
14 -- x_error_msg_code OUT VARCHAR2 Required
15
16 PROCEDURE CHECK_LIFECYCLE_PHASE_NAME_ID
17 ( p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
18 ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
19 ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
20 ,p_check_id_flag IN VARCHAR2 := 'A'
21 ,x_current_lifecycle_phase_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
22 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
24 );
25
26 -- API name : CHECK_LIFECYCLE_NAME_OR_ID
27 -- Type : Utility
28 -- Pre-reqs : None.
29 -- Parameters :
30 -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
31 -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
32 -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
33 -- x_lifecycle_id OUT NUMBER Required
34 -- x_return_status OUT VARCHAR2 Required
35 -- x_error_msg_code OUT VARCHAR2 Required
36
37 PROCEDURE CHECK_LIFECYCLE_NAME_OR_ID
38 ( p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
39 ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
40 ,p_check_id_flag IN VARCHAR2 := 'A'
41 ,x_lifecycle_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
42 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
43 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
44 );
45
46 -- API name : Check_Approver_Name_Or_Id
47 -- Type : Utility
48 -- Pre-reqs : None.
49 -- Parameters :
50 -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
51 -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
52 -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
53 -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
54 -- x_approver_source_id OUT NUMBER Required
55 -- x_approver_source_type OUT NUMBER Required
56 -- x_return_status OUT VARCHAR2 Required
57 -- x_error_msg_code OUT VARCHAR2 Required
58
59 PROCEDURE CHECK_APPROVER_NAME_OR_ID
60 ( p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
61 ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
62 ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
63 ,p_check_id_flag IN VARCHAR2 := 'A'
64 ,x_approver_source_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
65 ,x_approver_source_type OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
66 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
67 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
68 );
69
70
71 -- API name : Check_Wp_Versioning_Enabled
72 -- Type : Utility
73 -- Pre-reqs : None.
74 -- Parameters :
75 -- p_project_id IN NUMBER Required
76
77 FUNCTION CHECK_WP_VERSIONING_ENABLED
78 ( p_project_id IN NUMBER
79 ) RETURN VARCHAR2;
80
81
82 -- API name : Check_DATE_SYNC_ENABLED
83 -- Type : Utility
84 -- Pre-reqs : None.
85 -- Parameters :
86 -- p_proj_element_id IN NUMBER Required
87
88 FUNCTION CHECK_AUTO_DATE_SYNC_ENABLED
89 ( p_proj_element_id IN NUMBER
90 ) RETURN VARCHAR2;
91
92
93 -- API name : GET_SYNC_BUF_DAYS
94 -- Type : Utility
95 -- Pre-reqs : None.
96 -- Parameters :
97 -- p_proj_element_id IN NUMBER Required
98
99 FUNCTION GET_SYNC_BUF_DAYS
100 ( p_proj_element_id IN NUMBER
101 ) RETURN NUMBER;
102
103
104 -- API name : CHECK_WP_PROJECT_EXISTS
105 -- Type : Utility
106 -- Pre-reqs : None.
107 -- Parameters :
108 -- p_lifecycle_id IN NUMBER Required
109
110 PROCEDURE CHECK_WP_PROJECT_EXISTS
111 ( p_lifecycle_id IN NUMBER
112 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
113 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
114 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
115
116
117 -- API name : CHECK_WP_TASK_EXISTS
118 -- Type : Utility
119 -- Pre-reqs : None.
120 -- Parameters :
121 -- p_lifecycle_phase_id IN NUMBER Required
122
123 PROCEDURE CHECK_WP_TASK_EXISTS
124 ( p_lifecycle_phase_id IN NUMBER
125 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
126 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
127 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
128
129 PROCEDURE UPDATE_CURRENT_PHASE
130 (
131 p_lifecycle_phase_id IN NUMBER
132 ,p_proj_element_id IN NUMBER
133 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
134 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
135 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
136
137 FUNCTION CHECK_APPROVAL_REQUIRED
138 ( p_project_id IN NUMBER
139 ) RETURN VARCHAR2;
140
141 FUNCTION CHECK_AUTO_PUB_ENABLED
142 ( p_project_id IN NUMBER
143 ) RETURN VARCHAR2;
144
145 FUNCTION CHECK_AUTO_PUB_AT_CREATION
146 ( p_template_id IN NUMBER
147 ) RETURN VARCHAR2;
148
149 END PA_WORKPLAN_ATTR_UTILS;