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