1 PACKAGE JTF_EC_CONTACTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfeccos.pls 120.1 2005/07/02 00:41:16 appldev ship $ */
3 /*#
4 * This is the private interface to the JTF Escalation Management.
5 * This Interface is used to Create / Update / Delete Contacts for
6 * the escalations.
7 *
8 * @rep:scope private
9 * @rep:product JTF
10 * @rep:lifecycle active
11 * @rep:displayname Escalation Management
12 * @rep:compatibility S
13 * @rep:category BUSINESS_ENTITY JTA_ESCALATION
14 */
15
16 g_pkg_name constant VARCHAR2(30) := 'JTF_ESCALATION_CONTACTS_PVT';
17
18 /*#
19 * Creates Escalation Contacts
20 *
21 * @param p_api_version the standard API version number
22 * @param p_init_msg_list the standard API flag allows API callers to request
23 * that the API does the initialization of the message list on their behalf.
24 * By default, the message list will not be initialized.
25 * @param p_commit the standard API flag is used by API callers to ask
26 * the API to commit on their behalf after performing its function
27 * By default, the commit will not be performed.
28 * @param p_escalation_id the Escalation ID for which the contact is created
29 * @param p_escalation_number the Escalation Number for which the contact is created
30 * @param p_contact_id the contact ID of the Escalation Contact to be created
31 * @param p_contact_type_code the contact Type Code of the Escalation Contact to be created
32 * @param p_escalation_notify_flag the flag that checks if the notify option is checked
33 * @param p_escalation_requester_flag the flag that determines if the contact is requester for Escalation
34 * @param x_escalation_contact_id the parameter that returns the Escalation Contact ID for the created Escalation Contact
35 * @param x_return_status the parameter that returns the result of all the operations performed.
36 * by the API and must have one of the following values:
37 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
38 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
39 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
40 * @param x_msg_data the parameter that returns the FND Message in encoded format.
41 * @param x_msg_count the parameter that returns the number of messages in the FND message list.
42 * @param p_attribute1 the value of the flex field attribute1
43 * @param p_attribute2 the value of the flex field attribute2
44 * @param p_attribute3 the value of the flex field attribute3
45 * @param p_attribute4 the value of the flex field attribute4
46 * @param p_attribute5 the value of the flex field attribute5
47 * @param p_attribute6 the value of the flex field attribute6
48 * @param p_attribute7 the value of the flex field attribute7
49 * @param p_attribute8 the value of the flex field attribute8
50 * @param p_attribute9 the value of the flex field attribute9
51 * @param p_attribute10 the value of the flex field attribute10
52 * @param p_attribute11 the value of the flex field attribute11
53 * @param p_attribute12 the value of the flex field attribute12
54 * @param p_attribute13 the value of the flex field attribute13
55 * @param p_attribute14 the value of the flex field attribute14
56 * @param p_attribute15 the value of the flex field attribute15
57 * @param p_attribute_category the value of the flex field attribute category
58 * @rep:scope private
59 * @rep:lifecycle active
60 * @rep:displayname Create Escalation Contacts
61 * @rep:compatibility S
62 */
63 PROCEDURE create_escalation_contacts (
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
66 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
67 p_escalation_id IN NUMBER DEFAULT NULL,
68 p_escalation_number IN VARCHAR2 DEFAULT NULL,
69 p_contact_id IN NUMBER,
70 p_contact_type_code IN VARCHAR2 DEFAULT NULL,
71 p_escalation_notify_flag IN VARCHAR2 DEFAULT NULL,
72 p_escalation_requester_flag IN VARCHAR2 DEFAULT NULL,
73 x_escalation_contact_id OUT NOCOPY NUMBER,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
78 p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
79 p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
80 p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
81 p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
82 p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
83 p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
84 p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
85 p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
86 p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
87 p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
88 p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
89 p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
90 p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
91 p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
92 p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
93 );
94
95
96 /*#
97 * Updates Escalation Contacts
98 *
99 * @param p_api_version the standard API version number
100 * @param p_init_msg_list the standard API flag allows API callers to request
101 * that the API does the initialization of the message list on their behalf.
102 * By default, the message list will not be initialized.
103 * @param p_commit the standard API flag is used by API callers to ask
104 * the API to commit on their behalf after performing its function
105 * By default, the commit will not be performed.
106 * @param p_object_version_number the object version number of the escalation contact record
107 * @param p_escalation_contact_id the Escalation Contact ID for the Escalation Contact
108 * @param p_contact_id the contact ID of the Escalation Contact to be created
109 * @param p_contact_type_code the contact Type Code of the Escalation Contact to be created
110 * @param p_escalation_notify_flag the flag that checks if the notify option is checked
111 * @param p_escalation_requester_flag the flag that determines if the contact is requester for Escalation
112 * @param x_return_status the parameter that returns the result of all the operations performed.
113 * by the API and must have one of the following values:
114 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
115 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
116 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
117 * @param x_msg_data the parameter that returns the FND Message in encoded format.
118 * @param x_msg_count the parameter that returns the number of messages in the FND message list.
119 * @param p_attribute1 the value of the flex field attribute1
120 * @param p_attribute2 the value of the flex field attribute2
121 * @param p_attribute3 the value of the flex field attribute3
122 * @param p_attribute4 the value of the flex field attribute4
123 * @param p_attribute5 the value of the flex field attribute5
124 * @param p_attribute6 the value of the flex field attribute6
125 * @param p_attribute7 the value of the flex field attribute7
126 * @param p_attribute8 the value of the flex field attribute8
127 * @param p_attribute9 the value of the flex field attribute9
128 * @param p_attribute10 the value of the flex field attribute10
129 * @param p_attribute11 the value of the flex field attribute11
130 * @param p_attribute12 the value of the flex field attribute12
131 * @param p_attribute13 the value of the flex field attribute13
132 * @param p_attribute14 the value of the flex field attribute14
133 * @param p_attribute15 the value of the flex field attribute15
134 * @param p_attribute_category the value of the flex field attribute category
135 * @rep:scope private
136 * @rep:lifecycle active
137 * @rep:displayname Update Escalation Contacts
138 * @rep:compatibility S
139 */
140 PROCEDURE update_escalation_contacts (
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
143 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
144 p_object_version_number IN OUT NOCOPY VARCHAR2 ,
145 p_escalation_contact_id IN NUMBER DEFAULT NULL,
146 p_contact_id IN NUMBER,
147 p_contact_type_code IN VARCHAR2 DEFAULT NULL,
148 p_escalation_notify_flag IN VARCHAR2 DEFAULT NULL,
149 p_escalation_requester_flag IN VARCHAR2 DEFAULT NULL,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
154 p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
155 p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
156 p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
157 p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
158 p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
159 p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
160 p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
161 p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
162 p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
163 p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
164 p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
165 p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
166 p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
167 p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
168 p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
169 );
170
171 /*#
172 * Deletes Escalation Contacts
173 *
174 * @param p_api_version the standard API version number
175 * @param p_init_msg_list the standard API flag allows API callers to request
176 * that the API does the initialization of the message list on their behalf.
177 * By default, the message list will not be initialized.
178 * @param p_commit the standard API flag is used by API callers to ask
179 * the API to commit on their behalf after performing its function
180 * By default, the commit will not be performed.
181 * @param p_object_version_number the object version number of the escalation contact record
182 * @param p_escalation_contact_id the Escalation Contact ID for the Escalation Contact
183 * @param x_return_status the parameter that returns the result of all the operations performed.
184 * by the API and must have one of the following values:
185 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
186 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
187 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
188 * @param x_msg_data the parameter that returns the FND Message in encoded format.
189 * @param x_msg_count the parameter that returns the number of messages in the FND message list.
190 * @rep:scope private
191 * @rep:lifecycle active
192 * @rep:displayname Delete Escalation Contacts
193 * @rep:compatibility S
194 */
195 PROCEDURE delete_escalation_contacts (
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
198 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
199 p_object_version_number IN NUMBER,
200 p_escalation_contact_id IN NUMBER,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER
204 ) ;
205
206
207 END;