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