1 PACKAGE jtf_task_dependency_pub AS
2 /* $Header: jtfptkes.pls 120.1 2005/07/02 00:58:56 appldev ship $ */
3 /*#
4 * This is the public package to validate, crete, update, and delete task dependencies.
5 *
6 * @rep:scope internal
7 * @rep:product CAC
8 * @rep:lifecycle active
9 * @rep:displayname Task Dependency
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY CAC_CAL_TASK
12 */
13
14 TYPE task_dependency_rec IS RECORD (
15 dependency_id NUMBER,
16 task_id NUMBER,
17 task_name VARCHAR2(30),
18 task_number NUMBER,
19 dependenct_on_task_id NUMBER,
20 dependenct_on_task_name NUMBER,
21 dependenct_on_task_number NUMBER,
22 dependency_type_code VARCHAR2(30),
23 dependency_type_code_desc VARCHAR2(80),
24 adjustment_time NUMBER,
25 adjustment_time_uom VARCHAR2(30)
26 );
27
28 /*#
29 * Task dependency creation API. Many validations will be performed before
30 * creating task dependency.
31 *
32 * @param p_api_version the standard API version number
33 * @param p_init_msg_list the standard API flag allows API callers to request
34 * that the API does the initialization of the message list on their behalf.
35 * By default, the message list will not be initialized.
36 * @param p_commit the standard API flag is used by API callers to ask
37 * the API to commit on their behalf after performing its function
38 * By default, the commit will not be performed.
39 * @param p_validation_level the validation level for dependency creation
40 * @param p_task_id the task id for dependency creation
41 * @param p_task_number the task number for dependency creation
42 * @param p_dependent_on_task_id the master task id for dependency creation
43 * @param p_dependent_on_task_number the dependent on task number
44 * @param p_dependency_type_code the dependency type code of the dependency
45 * @param p_template_flag the template flag to be applied
46 * @param p_adjustment_time the time offset to be applied to re-calculate the master tasks scheduled start date or end date
47 * @param p_adjustment_time_uom the unit of measure of the time offset to be applied for date re-calculation
48 * @param p_validated_flag the validated flag
49 * @param x_dependency_id the dependency id being created
50 * @param x_return_status returns the result of all the operations performed
51 * by the API and must have one of the following values:
52 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
53 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
54 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
55 * @param x_msg_data returns the message in an encoded format if
56 * <code>x_msg_count</code> returns number one.
57 * @param x_msg_count returns the number of messages in the API message list
58 * @param p_attribute1 attribute1 for flexfield
59 * @param p_attribute2 attribute2 for flexfield
60 * @param p_attribute3 attribute3 for flexfield
61 * @param p_attribute4 attribute4 for flexfield
62 * @param p_attribute5 attribute5 for flexfield
63 * @param p_attribute6 attribute6 for flexfield
64 * @param p_attribute7 attribute7 for flexfield
65 * @param p_attribute8 attribute8 for flexfield
66 * @param p_attribute9 attribute9 for flexfield
67 * @param p_attribute10 attribute10 for flexfield
68 * @param p_attribute11 attribute11 for flexfield
69 * @param p_attribute12 attribute12 for flexfield
70 * @param p_attribute13 attribute13 for flexfield
71 * @param p_attribute14 attribute14 for flexfield
72 * @param p_attribute15 attribute15 for flexfield
73 * @param p_attribute_category attribute category
74 * @paraminfo {@rep:precision 6000}
75 * @rep:scope internal
76 * @rep:lifecycle active
77 * @rep:displayname Create Task Dependency
78 * @rep:compatibility S
79 */
80 PROCEDURE create_task_dependency (
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
83 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
84 p_validation_level IN VARCHAR2
85 DEFAULT fnd_api.g_valid_level_full,
86 p_task_id IN NUMBER DEFAULT NULL,
87 p_task_number IN VARCHAR2 DEFAULT NULL,
88 p_dependent_on_task_id IN NUMBER DEFAULT NULL,
89 p_dependent_on_task_number IN VARCHAR2 DEFAULT NULL,
90 p_dependency_type_code IN VARCHAR2,
91 p_template_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no,
92 p_adjustment_time IN NUMBER DEFAULT NULL,
93 p_adjustment_time_uom IN VARCHAR2 DEFAULT NULL,
94 p_validated_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no,
95 x_dependency_id OUT NOCOPY NUMBER,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_attribute1 IN VARCHAR2 DEFAULT null ,
100 p_attribute2 IN VARCHAR2 DEFAULT null ,
101 p_attribute3 IN VARCHAR2 DEFAULT null ,
102 p_attribute4 IN VARCHAR2 DEFAULT null ,
103 p_attribute5 IN VARCHAR2 DEFAULT null ,
104 p_attribute6 IN VARCHAR2 DEFAULT null ,
105 p_attribute7 IN VARCHAR2 DEFAULT null ,
106 p_attribute8 IN VARCHAR2 DEFAULT null ,
107 p_attribute9 IN VARCHAR2 DEFAULT null ,
108 p_attribute10 IN VARCHAR2 DEFAULT null ,
109 p_attribute11 IN VARCHAR2 DEFAULT null ,
110 p_attribute12 IN VARCHAR2 DEFAULT null ,
111 p_attribute13 IN VARCHAR2 DEFAULT null ,
112 p_attribute14 IN VARCHAR2 DEFAULT null ,
113 p_attribute15 IN VARCHAR2 DEFAULT null ,
114 p_attribute_category IN VARCHAR2 DEFAULT null
115 );
116
117 /*#
118 * Task dependency row locking API.
119 *
120 * @param p_api_version the standard API version number
121 * @param p_init_msg_list the standard API flag allows API callers to request
122 * that the API does the initialization of the message list on their behalf.
123 * By default, the message list will not be initialized.
124 * @param p_commit the standard API flag is used by API callers to ask
125 * the API to commit on their behalf after performing its function
126 * By default, the commit will not be performed.
127 * @param p_dependency_id the dependency id being locked
128 * @param p_object_version_number the object version number for lock
129 * @param x_return_status returns the result of all the operations performed
130 * by the API and must have one of the following values:
131 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
132 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
133 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
134 * @param x_msg_data returns the message in an encoded format if
135 * <code>x_msg_count</code> returns number one.
136 * @param x_msg_count returns the number of messages in the API message list
137 * @paraminfo {@rep:precision 6000}
138 * @rep:scope private
139 * @rep:lifecycle active
140 * @rep:displayname Lock Task Dependency
141 * @rep:compatibility S
142 */
143 PROCEDURE lock_task_dependency (
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
146 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
147 p_dependency_id IN NUMBER,
148 p_object_version_number IN NUMBER ,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER
152 );
153
154 /*#
155 * Task dependency update API.
156 *
157 * @param p_api_version the standard API version number
158 * @param p_init_msg_list the standard API flag allows API callers to request
159 * that the API does the initialization of the message list on their behalf.
160 * By default, the message list will not be initialized.
161 * @param p_commit the standard API flag is used by API callers to ask
162 * the API to commit on their behalf after performing its function
163 * By default, the commit will not be performed.
164 * @param p_object_version_number the object version number for dependency update
165 * @param p_dependency_id the dependency id for dependency update
166 * @param p_task_id the sub task id for dependency update
167 * @param p_dependent_on_task_id the master task id for dependency update
168 * @param p_dependent_on_task_number the master task number for dependency update
169 * @param p_dependency_type_code the dependency type code of the dependency
170 * @param p_adjustment_time the time offset to be applied to re-calculate the master tasks scheduled start date or end date
171 * @param p_adjustment_time_uom the unit of measure of the time offset to be applied for date re-calculation
172 * @param p_validated_flag the validated flag
173 * @param x_return_status returns the result of all the operations performed
174 * by the API and must have one of the following values:
175 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
176 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
177 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
178 * @param x_msg_count returns the number of messages in the API message list
179 * <code>x_msg_count</code> returns number one.
180 * @param x_msg_data returns the message in an encoded format if
181 * @param p_attribute1 attribute1 for flexfield
182 * @param p_attribute2 attribute2 for flexfield
183 * @param p_attribute3 attribute3 for flexfield
184 * @param p_attribute4 attribute4 for flexfield
185 * @param p_attribute5 attribute5 for flexfield
186 * @param p_attribute6 attribute6 for flexfield
187 * @param p_attribute7 attribute7 for flexfield
188 * @param p_attribute8 attribute8 for flexfield
189 * @param p_attribute9 attribute9 for flexfield
190 * @param p_attribute10 attribute10 for flexfield
191 * @param p_attribute11 attribute11 for flexfield
192 * @param p_attribute12 attribute12 for flexfield
193 * @param p_attribute13 attribute13 for flexfield
194 * @param p_attribute14 attribute14 for flexfield
195 * @param p_attribute15 attribute15 for flexfield
196 * @param p_attribute_category attribute category
197 * @paraminfo {@rep:precision 6000}
198 * @rep:scope internal
199 * @rep:lifecycle active
200 * @rep:displayname Update Task Dependency
201 * @rep:compatibility S
202 */
203 PROCEDURE update_task_dependency (
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
206 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
207 p_object_version_number IN OUT NOCOPY NUMBER ,
208 p_dependency_id IN NUMBER,
209 p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
210 p_dependent_on_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
211 p_dependent_on_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
212 p_dependency_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
213 p_adjustment_time IN NUMBER DEFAULT fnd_api.g_miss_num,
214 p_adjustment_time_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
215 p_validated_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2,
219 p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
220 p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
221 p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
222 p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
223 p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
224 p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
225 p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
226 p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
227 p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
228 p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
229 p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
230 p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
231 p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
232 p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
233 p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
234 p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
235 );
236
237 /*#
238 * Task dependency delete API.
239 *
240 * @param p_api_version the standard API version number
241 * @param p_init_msg_list the standard API flag allows API callers to request
242 * that the API does the initialization of the message list on their behalf.
243 * By default, the message list will not be initialized.
244 * @param p_commit the standard API flag is used by API callers to ask
245 * the API to commit on their behalf after performing its function
246 * By default, the commit will not be performed.
247 * @param p_object_version_number the object version number for delete
248 * @param p_dependency_id the dependency id being deleted
249 * @param x_return_status returns the result of all the operations performed
250 * by the API and must have one of the following values:
251 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
252 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
253 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
254 * @param x_msg_count returns the number of messages in the API message list
255 * @param x_msg_data returns the message in an encoded format if
256 * <code>x_msg_count</code> returns number one.
257 * @paraminfo {@rep:precision 6000}
258 * @rep:scope internal
259 * @rep:lifecycle active
260 * @rep:displayname Delete Task Dependency
261 * @rep:compatibility S
262 */
263 PROCEDURE delete_task_dependency (
264 p_api_version IN NUMBER,
265 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
266 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
267 p_object_version_number IN NUMBER ,
268 p_dependency_id IN NUMBER,
269 x_return_status OUT NOCOPY VARCHAR2,
270 x_msg_count OUT NOCOPY NUMBER,
271 x_msg_data OUT NOCOPY VARCHAR2
272 );
273
274 END;