1 PACKAGE CSF_TASK_DEPENDENCY_PUB as
2 /* $Header: CSFPTKDS.pls 120.0 2005/05/24 17:32:06 appldev noship $ */
3
4 -- Start of Comments
5
6 -- Package name : CSF_TASK_DEPENDENCY_PUB
7 -- Purpose : This package is related to the task dependency
8 -- History : Created by sseshaiy on 26-aug-2004
9 -- NOTE : This package do the operations on jtf_task_depends table
10
11 -- End of Comments
12
13 /**
14 * Create task dependency always set the Validate flag as 'N' and validate flag is not exposed
15 * @param p_api_version the standard API version number
16 * @param p_init_msg_list the standard API flag allows API callers to request
17 * that the API does the initialization of the message list on their behalf.
18 * By default, the message list will not be initialized.
19 * @param p_commit the standard API flag is used by API callers to ask
20 * the API to commit on their behalf after performing its function
21 * By default, the commit will not be performed.
22 * @param p_validation_level the standard API validation level
23 * @param p_task_id the task id for dependency creation
24 * @param p_dependent_on_task_id the master task id for dependency creation
25 * @param p_dependency_type_code the dependency type code of the dependency
26 * @param x_dependency_id the dependency id being created
27 * @param x_return_status returns the result of all the operations performed
28 * by the API and must have one of the following values:
29 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
30 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
31 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
32 * @param x_msg_data returns the message in an encoded format if
33 * <code>x_msg_count</code> returns number one.
34 * @param x_msg_count returns the number of messages in the API message list
35 * @param p_attribute1 attribute1 for flexfield
36 * @param p_attribute2 attribute2 for flexfield
37 * @param p_attribute3 attribute3 for flexfield
38 * @param p_attribute4 attribute4 for flexfield
39 * @param p_attribute5 attribute5 for flexfield
40 * @param p_attribute6 attribute6 for flexfield
41 * @param p_attribute7 attribute7 for flexfield
42 * @param p_attribute8 attribute8 for flexfield
43 * @param p_attribute9 attribute9 for flexfield
44 * @param p_attribute10 attribute10 for flexfield
45 * @param p_attribute11 attribute11 for flexfield
46 * @param p_attribute12 attribute12 for flexfield
47 * @param p_attribute13 attribute13 for flexfield
48 * @param p_attribute14 attribute14 for flexfield
49 * @param p_attribute15 attribute15 for flexfield
50 * @param p_attribute_category attribute category
51 */
52
53 PROCEDURE CREATE_TASK_DEPENDENCY_NV (
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
56 p_commit IN VARCHAR2 DEFAULT NULL,
57 p_validation_level IN VARCHAR2 DEFAULT NULL,
58 p_task_id IN NUMBER,
59 p_dependent_on_task_id IN NUMBER,
60 p_dependency_type_code IN VARCHAR2,
61 x_dependency_id OUT NOCOPY NUMBER,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_attribute1 IN VARCHAR2 DEFAULT NULL ,
66 p_attribute2 IN VARCHAR2 DEFAULT NULL ,
67 p_attribute3 IN VARCHAR2 DEFAULT NULL ,
68 p_attribute4 IN VARCHAR2 DEFAULT NULL ,
69 p_attribute5 IN VARCHAR2 DEFAULT NULL ,
70 p_attribute6 IN VARCHAR2 DEFAULT NULL ,
71 p_attribute7 IN VARCHAR2 DEFAULT NULL ,
72 p_attribute8 IN VARCHAR2 DEFAULT NULL ,
73 p_attribute9 IN VARCHAR2 DEFAULT NULL ,
74 p_attribute10 IN VARCHAR2 DEFAULT NULL ,
75 p_attribute11 IN VARCHAR2 DEFAULT NULL ,
76 p_attribute12 IN VARCHAR2 DEFAULT NULL ,
77 p_attribute13 IN VARCHAR2 DEFAULT NULL ,
78 p_attribute14 IN VARCHAR2 DEFAULT NULL ,
79 p_attribute15 IN VARCHAR2 DEFAULT NULL ,
80 p_attribute_category IN VARCHAR2 DEFAULT NULL
81 );
82
83 /**
84 * Task dependency row locking API.
85 *
86 * @param p_api_version the standard API version number
87 * @param p_init_msg_list the standard API flag allows API callers to request
88 * that the API does the initialization of the message list on their behalf.
89 * By default, the message list will not be initialized.
90 * @param p_commit the standard API flag is used by API callers to ask
91 * the API to commit on their behalf after performing its function
92 * By default, the commit will not be performed.
93 * @param p_object_version_number the object version number for lock
94 * @param x_dependency_id the dependency id being locked
95 * @param x_return_status returns the result of all the operations performed
96 * by the API and must have one of the following values:
97 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
98 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
99 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
100 * @param x_msg_data returns the message in an encoded format if
101 * <code>x_msg_count</code> returns number one.
102 * @param x_msg_count returns the number of messages in the API message list
103 */
104
105 PROCEDURE LOCK_TASK_DEPENDENCY (
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
108 p_commit IN VARCHAR2 DEFAULT NULL,
109 p_dependency_id IN NUMBER,
110 p_object_version_number IN NUMBER ,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER
114 );
115
116
117 /**
118 * Task dependency update API.
119 *
120 * @param p_api_version the standard API version number
124 * @param p_commit the standard API flag is used by API callers to ask
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.
125 * the API to commit on their behalf after performing its function
126 * By default, the commit will not be performed.
127 * @param p_object_version_number the object version number for dependency update
128 * @param p_dependency_id the dependency id for dependency update
129 * @param p_task_id the sub task id for dependency update
130 * @param p_dependent_on_task_id the master task id for dependency update
131 * @param p_dependent_on_task_number the master task number for dependency update
132 * @param p_dependency_type_code the dependency type code of the dependency
133 * @param p_adjustment_time the time offset to be applied to re-calculate the master tasks scheduled start date or end date
134 * @param p_adjustment_time_uom the unit of measure of the time offset to be applied for date re-calculation
135 * @param p_validated_flag the validated flag
136 * @param x_return_status returns the result of all the operations performed
137 * by the API and must have one of the following values:
138 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
139 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
140 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
141 * @param x_msg_count returns the number of messages in the API message list
142 * <code>x_msg_count</code> returns number one.
143 * @param x_msg_data returns the message in an encoded format if
144 * @param p_attribute1 attribute1 for flexfield
145 * @param p_attribute2 attribute2 for flexfield
146 * @param p_attribute3 attribute3 for flexfield
147 * @param p_attribute4 attribute4 for flexfield
148 * @param p_attribute5 attribute5 for flexfield
149 * @param p_attribute6 attribute6 for flexfield
150 * @param p_attribute7 attribute7 for flexfield
151 * @param p_attribute8 attribute8 for flexfield
152 * @param p_attribute9 attribute9 for flexfield
153 * @param p_attribute10 attribute10 for flexfield
154 * @param p_attribute11 attribute11 for flexfield
158 * @param p_attribute15 attribute15 for flexfield
155 * @param p_attribute12 attribute12 for flexfield
156 * @param p_attribute13 attribute13 for flexfield
157 * @param p_attribute14 attribute14 for flexfield
159 * @param p_attribute_category attribute category
160 */
161
162 PROCEDURE UPDATE_TASK_DEPENDENCY (
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
165 p_commit IN VARCHAR2 DEFAULT NULL,
166 p_object_version_number IN OUT NOCOPY NUMBER,
167 p_dependency_id IN NUMBER,
168 p_task_id IN NUMBER DEFAULT NULL,
169 p_dependent_on_task_id IN NUMBER DEFAULT NULL,
170 p_dependency_type_code IN VARCHAR2 DEFAULT NULL,
171 x_return_status OUT NOCOPY VARCHAR2,
172 x_msg_count OUT NOCOPY NUMBER,
173 x_msg_data OUT NOCOPY VARCHAR2,
174 p_attribute1 IN VARCHAR2 DEFAULT NULL,
175 p_attribute2 IN VARCHAR2 DEFAULT NULL,
176 p_attribute3 IN VARCHAR2 DEFAULT NULL,
177 p_attribute4 IN VARCHAR2 DEFAULT NULL,
178 p_attribute5 IN VARCHAR2 DEFAULT NULL,
179 p_attribute6 IN VARCHAR2 DEFAULT NULL,
180 p_attribute7 IN VARCHAR2 DEFAULT NULL,
181 p_attribute8 IN VARCHAR2 DEFAULT NULL,
182 p_attribute9 IN VARCHAR2 DEFAULT NULL,
183 p_attribute10 IN VARCHAR2 DEFAULT NULL,
184 p_attribute11 IN VARCHAR2 DEFAULT NULL,
185 p_attribute12 IN VARCHAR2 DEFAULT NULL,
186 p_attribute13 IN VARCHAR2 DEFAULT NULL,
187 p_attribute14 IN VARCHAR2 DEFAULT NULL,
188 p_attribute15 IN VARCHAR2 DEFAULT NULL,
192 /**
189 p_attribute_category IN VARCHAR2 DEFAULT NULL
190 );
191
193 * Task dependency delete API.
194 *
195 * @param p_api_version the standard API version number
196 * @param p_init_msg_list the standard API flag allows API callers to request
197 * that the API does the initialization of the message list on their behalf.
198 * By default, the message list will not be initialized.
199 * @param p_commit the standard API flag is used by API callers to ask
200 * the API to commit on their behalf after performing its function
201 * By default, the commit will not be performed.
202 * @param p_object_version_number the object version number for delete
203 * @param p_dependency_id the dependency id being deleted
204 * @param x_return_status returns the result of all the operations performed
205 * by the API and must have one of the following values:
206 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
207 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
208 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
209 * @param x_msg_count returns the number of messages in the API message list
210 * @param x_msg_data returns the message in an encoded format if
211 * <code>x_msg_count</code> returns number one.
212 */
213 PROCEDURE DELETE_TASK_DEPENDENCY (
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
216 p_commit IN VARCHAR2 DEFAULT NULL,
217 p_object_version_number IN NUMBER ,
218 p_dependency_id IN NUMBER,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2
222 );
223
224 -- For the given task id, all the dependencies are deleted.
225 PROCEDURE CLEAR_TASK_DEPENDENCIES (
226 p_api_version IN NUMBER
227 , p_init_msg_list IN VARCHAR2 DEFAULT NULL
231 , x_msg_count OUT NOCOPY NUMBER
228 , p_commit IN VARCHAR2 DEFAULT NULL
229 , p_task_id IN NUMBER
230 , x_return_status OUT NOCOPY VARCHAR2
232 , x_msg_data OUT NOCOPY VARCHAR2
233 );
234
235 END CSF_TASK_DEPENDENCY_PUB;
236