[Home] [Help]
PACKAGE: APPS.CS_COVERAGE_PVT
Source
1 Package CS_COVERAGE_PVT AUTHID CURRENT_USER AS
2 /* $Header: csctcovs.pls 115.0 99/07/16 08:50:33 porting ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE Coverage_Rec_Type IS RECORD (
7 coverage_id NUMBER := NULL,
8 coverage_template_id NUMBER := NULL,
9 name CS_COVERAGES.NAME%TYPE := NULL,
10 description CS_COVERAGES.DESCRIPTION%TYPE := NULL,
11 template_flag CS_COVERAGES.TEMPLATE_FLAG%TYPE := NULL,
12 renewal_terms CS_COVERAGES.RENEWAL_TERMS%TYPE := NULL,
13 termination_terms CS_COVERAGES.TERMINATION_TERMS%TYPE := NULL,
14 max_support_coverage_amt NUMBER := NULL,
15 exception_coverage_id NUMBER := NULL,
16 time_billable_percent NUMBER := NULL,
17 max_time_billable_amount NUMBER := NULL,
18 material_billable_percent NUMBER := NULL,
19 max_material_billable_amount NUMBER := NULL,
20 expense_billable_percent NUMBER := NULL,
21 max_expense_billable_amount NUMBER := NULL,
22 max_coverage_amount NUMBER := NULL,
23 response_time_period_code CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := NULL,
24 response_time_value NUMBER := NULL,
25 sunday_start_time CS_COVERAGES.SUNDAY_START_TIME%TYPE := NULL,
26 sunday_end_time CS_COVERAGES.SUNDAY_END_TIME%TYPE := NULL,
27 monday_start_time CS_COVERAGES.MONDAY_START_TIME%TYPE := NULL,
28 monday_end_time CS_COVERAGES.MONDAY_END_TIME%TYPE := NULL,
29 start_date_active CS_COVERAGES.START_DATE_ACTIVE%TYPE := NULL,
30 tuesday_start_time CS_COVERAGES.TUESDAY_START_TIME%TYPE := NULL,
31 tuesday_end_time CS_COVERAGES.TUESDAY_END_TIME%TYPE := NULL,
32 end_date_active CS_COVERAGES.END_DATE_ACTIVE%TYPE := NULL,
33 wednesday_start_time CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := NULL,
34 wednesday_end_time CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := NULL,
35 thursday_start_time CS_COVERAGES.THURSDAY_START_TIME%TYPE := NULL,
36 thursday_end_time CS_COVERAGES.THURSDAY_END_TIME%TYPE := NULL,
37 friday_start_time CS_COVERAGES.FRIDAY_START_TIME%TYPE := NULL,
38 friday_end_time CS_COVERAGES.FRIDAY_END_TIME%TYPE := NULL,
39 saturday_start_time CS_COVERAGES.SATURDAY_START_TIME%TYPE := NULL,
40 saturday_end_time CS_COVERAGES.SATURDAY_END_TIME%TYPE := NULL,
41 created_by NUMBER := NULL,
42 creation_date CS_COVERAGES.CREATION_DATE%TYPE := NULL,
43 last_update_date CS_COVERAGES.LAST_UPDATE_DATE%TYPE := NULL,
44 last_updated_by NUMBER := NULL,
45 last_update_login NUMBER := NULL,
46 attribute3 CS_COVERAGES.ATTRIBUTE3%TYPE := NULL,
47 attribute1 CS_COVERAGES.ATTRIBUTE1%TYPE := NULL,
48 attribute2 CS_COVERAGES.ATTRIBUTE2%TYPE := NULL,
49 attribute4 CS_COVERAGES.ATTRIBUTE4%TYPE := NULL,
50 attribute5 CS_COVERAGES.ATTRIBUTE5%TYPE := NULL,
51 attribute6 CS_COVERAGES.ATTRIBUTE6%TYPE := NULL,
52 attribute7 CS_COVERAGES.ATTRIBUTE7%TYPE := NULL,
53 attribute8 CS_COVERAGES.ATTRIBUTE8%TYPE := NULL,
54 attribute9 CS_COVERAGES.ATTRIBUTE9%TYPE := NULL,
55 attribute10 CS_COVERAGES.ATTRIBUTE10%TYPE := NULL,
56 attribute11 CS_COVERAGES.ATTRIBUTE11%TYPE := NULL,
57 attribute12 CS_COVERAGES.ATTRIBUTE12%TYPE := NULL,
58 attribute13 CS_COVERAGES.ATTRIBUTE13%TYPE := NULL,
59 attribute14 CS_COVERAGES.ATTRIBUTE14%TYPE := NULL,
60 attribute15 CS_COVERAGES.ATTRIBUTE15%TYPE := NULL,
61 context CS_COVERAGES.CONTEXT%TYPE := NULL,
62 object_version_number NUMBER := NULL);
63 G_MISS_coverage_rec Coverage_Rec_Type;
64 TYPE Coverage_Val_Rec_Type IS RECORD (
65 coverage_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
66 coverage_template_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
67 name CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
68 description CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
69 template_flag CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
70 renewal_terms CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
71 termination_terms CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
72 max_support_coverage_amt NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
73 exception_coverage_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
74 time_billable_percent NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
75 max_time_billable_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
76 material_billable_percent NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
77 max_material_billable_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
78 expense_billable_percent NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
79 max_expense_billable_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
80 max_coverage_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
81 response_time_period_code CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
82 response_time_value NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
83 sunday_start_time CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
84 sunday_end_time CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
85 monday_start_time CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
86 monday_end_time CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
87 start_date_active CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
88 tuesday_start_time CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
89 tuesday_end_time CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
90 end_date_active CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
91 wednesday_start_time CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
92 wednesday_end_time CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
93 thursday_start_time CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
94 thursday_end_time CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
95 friday_start_time CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
96 friday_end_time CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
97 saturday_start_time CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
98 saturday_end_time CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
99 created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
100 creation_date CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
101 last_update_date CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
102 last_updated_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
103 last_update_login NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
104 attribute3 CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
105 attribute1 CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
106 attribute2 CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
107 attribute4 CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
108 attribute5 CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
109 attribute6 CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
110 attribute7 CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
111 attribute8 CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
112 attribute9 CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
113 attribute10 CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
114 attribute11 CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
115 attribute12 CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
116 attribute13 CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
117 attribute14 CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
118 attribute15 CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
119 context CS_COVERAGES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
120 object_version_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
121 G_MISS_coverage_val_rec Coverage_Val_Rec_Type;
122 ---------------------------------------------------------------------------
123 -- GLOBAL MESSAGE CONSTANTS
124 ---------------------------------------------------------------------------
125 G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
126 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
127 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
128 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
129 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
130 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
131 G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
132 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
133 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
134 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
135 ---------------------------------------------------------------------------
136 -- GLOBAL VARIABLES
137 ---------------------------------------------------------------------------
138 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_COVERAGE_PVT';
139 G_APP_NAME CONSTANT VARCHAR2(3) := TAPI_DEV_KIT.G_APP_NAME;
140 ---------------------------------------------------------------------------
141 -- Procedures and Functions
142 ---------------------------------------------------------------------------
143
144 PROCEDURE insert_row
145 (
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
148 p_validation_level IN NUMBER,
149 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
150 x_return_status OUT VARCHAR2,
151 x_msg_count OUT NUMBER,
152 x_msg_data OUT VARCHAR2,
153 p_coverage_rec IN Coverage_Rec_Type := G_MISS_COVERAGE_REC,
154 x_coverage_id OUT NUMBER,
155 x_object_version_number OUT NUMBER);
156 PROCEDURE insert_row
157 (
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
160 p_validation_level IN NUMBER,
161 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
162 x_return_status OUT VARCHAR2,
163 x_msg_count OUT NUMBER,
164 x_msg_data OUT VARCHAR2,
165 p_coverage_template_id IN NUMBER := NULL,
166 p_name IN CS_COVERAGES.NAME%TYPE := NULL,
167 p_description IN CS_COVERAGES.DESCRIPTION%TYPE := NULL,
168 p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := NULL,
169 p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := NULL,
170 p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := NULL,
171 p_max_support_coverage_amt IN NUMBER := NULL,
172 p_exception_coverage_id IN NUMBER := NULL,
173 p_time_billable_percent IN NUMBER := NULL,
174 p_max_time_billable_amount IN NUMBER := NULL,
175 p_material_billable_percent IN NUMBER := NULL,
176 p_max_material_billable_amount IN NUMBER := NULL,
177 p_expense_billable_percent IN NUMBER := NULL,
178 p_max_expense_billable_amount IN NUMBER := NULL,
179 p_max_coverage_amount IN NUMBER := NULL,
180 p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := NULL,
181 p_response_time_value IN NUMBER := NULL,
182 p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := NULL,
183 p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := NULL,
184 p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := NULL,
185 p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := NULL,
186 p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := NULL,
187 p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := NULL,
188 p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := NULL,
189 p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := NULL,
190 p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := NULL,
191 p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := NULL,
195 p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := NULL,
192 p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := NULL,
193 p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := NULL,
194 p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := NULL,
196 p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := NULL,
197 p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := NULL,
198 p_created_by IN NUMBER := NULL,
199 p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := NULL,
200 p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := NULL,
201 p_last_updated_by IN NUMBER := NULL,
202 p_last_update_login IN NUMBER := NULL,
203 p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := NULL,
204 p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := NULL,
205 p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := NULL,
206 p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := NULL,
207 p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := NULL,
208 p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := NULL,
209 p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := NULL,
210 p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := NULL,
211 p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := NULL,
212 p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := NULL,
213 p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := NULL,
214 p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := NULL,
215 p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := NULL,
216 p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := NULL,
217 p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := NULL,
218 p_context IN CS_COVERAGES.CONTEXT%TYPE := NULL,
219 p_object_version_number IN NUMBER := NULL,
220 x_coverage_id OUT NUMBER,
221 x_object_version_number OUT NUMBER);
222 Procedure lock_row
223 (
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
226 p_validation_level IN NUMBER,
227 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
228 x_return_status OUT VARCHAR2,
229 x_msg_count OUT NUMBER,
230 x_msg_data OUT VARCHAR2,
231 p_coverage_id IN NUMBER,
232 p_object_version_number IN NUMBER);
233 Procedure update_row
234 (
235 p_api_version IN NUMBER,
236 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
237 p_validation_level IN NUMBER,
238 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
239 x_return_status OUT VARCHAR2,
240 x_msg_count OUT NUMBER,
241 x_msg_data OUT VARCHAR2,
242 p_coverage_val_rec IN Coverage_Val_Rec_Type := G_MISS_COVERAGE_VAL_REC,
243 x_object_version_number OUT NUMBER);
244 Procedure update_row
245 (
246 p_api_version IN NUMBER,
247 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
248 p_validation_level IN NUMBER,
249 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
250 x_return_status OUT VARCHAR2,
251 x_msg_count OUT NUMBER,
252 x_msg_data OUT VARCHAR2,
253 p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
254 p_coverage_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
255 p_name IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
256 p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
257 p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
258 p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
259 p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
260 p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
261 p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
262 p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
263 p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
264 p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
265 p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
266 p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
267 p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
268 p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
269 p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
270 p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
271 p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
272 p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
273 p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
274 p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
275 p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
276 p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
277 p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
278 p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
282 p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
279 p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
280 p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
281 p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
283 p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
284 p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
285 p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
286 p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
287 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
288 p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
289 p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
290 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
291 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
292 p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
293 p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
294 p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
295 p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
296 p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
297 p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
298 p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
299 p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
300 p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
301 p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
302 p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
303 p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
304 p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
305 p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
306 p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
307 p_context IN CS_COVERAGES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
308 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
309 x_object_version_number OUT NUMBER);
310 Procedure delete_row
311 (
312 p_api_version IN NUMBER,
313 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
314 p_validation_level IN NUMBER,
315 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
316 x_return_status OUT VARCHAR2,
317 x_msg_count OUT NUMBER,
318 x_msg_data OUT VARCHAR2,
319 p_coverage_id IN NUMBER);
320 PROCEDURE validate_row
321 (
322 p_api_version IN NUMBER,
323 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
324 p_validation_level IN NUMBER,
325 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
326 x_return_status OUT VARCHAR2,
327 x_msg_count OUT NUMBER,
328 x_msg_data OUT VARCHAR2,
329 p_coverage_val_rec IN Coverage_Val_Rec_Type := G_MISS_COVERAGE_VAL_REC);
330 PROCEDURE validate_row
331 (
332 p_api_version IN NUMBER,
333 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
334 p_validation_level IN NUMBER,
335 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
336 x_return_status OUT VARCHAR2,
337 x_msg_count OUT NUMBER,
338 x_msg_data OUT VARCHAR2,
339 p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
340 p_coverage_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
341 p_name IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
342 p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
343 p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
344 p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
345 p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
346 p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
347 p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
348 p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
349 p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
350 p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
351 p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
352 p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
353 p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
354 p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
355 p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
356 p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
357 p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
358 p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
359 p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
363 p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
360 p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
361 p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
362 p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
364 p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
365 p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
366 p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
367 p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
368 p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
369 p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
370 p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
371 p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
372 p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
373 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
374 p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
375 p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
376 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
377 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
378 p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
379 p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
380 p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
381 p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
382 p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
383 p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
384 p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
385 p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
386 p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
387 p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
388 p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
389 p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
390 p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
391 p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
392 p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
393 p_context IN CS_COVERAGES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
394 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
395 END CS_COVERAGE_PVT;