DBA Data[Home] [Help]

PACKAGE: APPS.CS_REACTTIME_PVT

Source


1 Package CS_REACTTIME_PVT AUTHID CURRENT_USER AS
2 /* $Header: csctcrts.pls 115.0 99/07/16 08:51:08 porting ship  $ */
3   ---------------------------------------------------------------------------
4   -- GLOBAL DATASTRUCTURES
5   ---------------------------------------------------------------------------
6   TYPE ReactTime_Rec_Type IS RECORD (
7     reaction_time_id               NUMBER := NULL,
8     name                           CS_COV_REACTION_TIMES.NAME%TYPE := NULL,
9     description                    CS_COV_REACTION_TIMES.DESCRIPTION%TYPE := NULL,
10     reaction_time_sunday           NUMBER := NULL,
11     reaction_time_monday           NUMBER := NULL,
12     reaction_time_tuesday          NUMBER := NULL,
13     reaction_time_wednesday        NUMBER := NULL,
14     reaction_time_thursday         NUMBER := NULL,
15     reaction_time_friday           NUMBER := NULL,
16     reaction_time_saturday         NUMBER := NULL,
17     incident_severity_id           NUMBER := NULL,
18     always_covered                 CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := NULL,
19     workflow                       CS_COV_REACTION_TIMES.WORKFLOW%TYPE := NULL,
20     coverage_txn_group_id          NUMBER := NULL,
21     use_for_sr_date_calc           CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := NULL,
22     last_update_date               CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := NULL,
23     last_updated_by                NUMBER := NULL,
24     creation_date                  CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := NULL,
25     created_by                     NUMBER := NULL,
26     last_update_login              NUMBER := NULL,
27     attribute1                     CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := NULL,
28     attribute2                     CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := NULL,
29     attribute3                     CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := NULL,
30     attribute4                     CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := NULL,
31     attribute5                     CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := NULL,
32     attribute6                     CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := NULL,
33     attribute7                     CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := NULL,
34     attribute8                     CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := NULL,
35     attribute9                     CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := NULL,
36     attribute10                    CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := NULL,
37     attribute11                    CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := NULL,
38     attribute12                    CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := NULL,
39     attribute13                    CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := NULL,
40     attribute14                    CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := NULL,
41     attribute15                    CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := NULL,
42     context                        CS_COV_REACTION_TIMES.CONTEXT%TYPE := NULL,
43     object_version_number          NUMBER := NULL);
44   G_MISS_reacttime_rec                    ReactTime_Rec_Type;
45   TYPE ReactTime_Val_Rec_Type IS RECORD (
46     reaction_time_id               NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
47     name                           CS_COV_REACTION_TIMES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
48     description                    CS_COV_REACTION_TIMES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
49     reaction_time_sunday           NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
50     reaction_time_monday           NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
51     reaction_time_tuesday          NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
52     reaction_time_wednesday        NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
53     reaction_time_thursday         NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
54     reaction_time_friday           NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
55     reaction_time_saturday         NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
56     incident_severity_id           NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
57     always_covered                 CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
58     workflow                       CS_COV_REACTION_TIMES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
59     coverage_txn_group_id          NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
60     use_for_sr_date_calc           CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
61     last_update_date               CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
62     last_updated_by                NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
63     creation_date                  CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
64     created_by                     NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
65     last_update_login              NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
66     attribute1                     CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
67     attribute2                     CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
68     attribute3                     CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
69     attribute4                     CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
70     attribute5                     CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
71     attribute6                     CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
72     attribute7                     CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
73     attribute8                     CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
74     attribute9                     CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
75     attribute10                    CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
76     attribute11                    CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
77     attribute12                    CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
78     attribute13                    CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
79     attribute14                    CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
80     attribute15                    CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
81     context                        CS_COV_REACTION_TIMES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
82     object_version_number          NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
83   G_MISS_reacttime_val_rec                ReactTime_Val_Rec_Type;
84   ---------------------------------------------------------------------------
85   -- GLOBAL MESSAGE CONSTANTS
86   ---------------------------------------------------------------------------
87   G_FND_APP			CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
88   G_FORM_UNABLE_TO_RESERVE_REC	CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
89   G_FORM_RECORD_DELETED		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
90   G_FORM_RECORD_CHANGED		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
91   G_RECORD_LOGICALLY_DELETED	CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
92   G_REQUIRED_VALUE		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
93   G_INVALID_VALUE			CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
94   G_COL_NAME_TOKEN		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
95   G_PARENT_TABLE_TOKEN		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
96   G_CHILD_TABLE_TOKEN		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
97   ---------------------------------------------------------------------------
98   -- GLOBAL VARIABLES
99   ---------------------------------------------------------------------------
100   G_PKG_NAME			CONSTANT	VARCHAR2(200) := 'CS_REACTTIME_PVT';
101   G_APP_NAME			CONSTANT 	VARCHAR2(3) :=  TAPI_DEV_KIT.G_APP_NAME;
102   ---------------------------------------------------------------------------
103   -- Procedures and Functions
104   ---------------------------------------------------------------------------
105 
106   PROCEDURE insert_row
107   (
108     p_api_version                  IN NUMBER,
109     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
110     p_validation_level             IN NUMBER,
111     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
112     x_return_status                OUT VARCHAR2,
113     x_msg_count                    OUT NUMBER,
114     x_msg_data                     OUT VARCHAR2,
115     p_reacttime_rec                IN ReactTime_Rec_Type := G_MISS_REACTTIME_REC,
116     x_reaction_time_id             OUT NUMBER,
117     x_object_version_number        OUT NUMBER);
118   PROCEDURE insert_row
119   (
120     p_api_version                  IN NUMBER,
121     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
122     p_validation_level             IN NUMBER,
123     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
124     x_return_status                OUT VARCHAR2,
125     x_msg_count                    OUT NUMBER,
126     x_msg_data                     OUT VARCHAR2,
127     p_name                         IN CS_COV_REACTION_TIMES.NAME%TYPE := NULL,
128     p_description                  IN CS_COV_REACTION_TIMES.DESCRIPTION%TYPE := NULL,
129     p_reaction_time_sunday         IN NUMBER := NULL,
130     p_reaction_time_monday         IN NUMBER := NULL,
131     p_reaction_time_tuesday        IN NUMBER := NULL,
132     p_reaction_time_wednesday      IN NUMBER := NULL,
133     p_reaction_time_thursday       IN NUMBER := NULL,
134     p_reaction_time_friday         IN NUMBER := NULL,
135     p_reaction_time_saturday       IN NUMBER := NULL,
136     p_incident_severity_id         IN NUMBER := NULL,
137     p_always_covered               IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := NULL,
138     p_workflow                     IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := NULL,
139     p_coverage_txn_group_id        IN NUMBER := NULL,
140     p_use_for_sr_date_calc         IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := NULL,
141     p_last_update_date             IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := NULL,
142     p_last_updated_by              IN NUMBER := NULL,
143     p_creation_date                IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := NULL,
144     p_created_by                   IN NUMBER := NULL,
145     p_last_update_login            IN NUMBER := NULL,
146     p_attribute1                   IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := NULL,
147     p_attribute2                   IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := NULL,
148     p_attribute3                   IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := NULL,
149     p_attribute4                   IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := NULL,
150     p_attribute5                   IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := NULL,
151     p_attribute6                   IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := NULL,
152     p_attribute7                   IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := NULL,
153     p_attribute8                   IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := NULL,
154     p_attribute9                   IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := NULL,
155     p_attribute10                  IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := NULL,
156     p_attribute11                  IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := NULL,
157     p_attribute12                  IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := NULL,
158     p_attribute13                  IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := NULL,
159     p_attribute14                  IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := NULL,
160     p_attribute15                  IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := NULL,
161     p_context                      IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := NULL,
162     p_object_version_number        IN NUMBER := NULL,
163     x_reaction_time_id             OUT NUMBER,
164     x_object_version_number        OUT NUMBER);
165   Procedure lock_row
166   (
167     p_api_version                  IN NUMBER,
168     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
169     p_validation_level             IN NUMBER,
170     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
171     x_return_status                OUT VARCHAR2,
172     x_msg_count                    OUT NUMBER,
173     x_msg_data                     OUT VARCHAR2,
174     p_reaction_time_id             IN NUMBER,
175     p_object_version_number        IN NUMBER);
176   Procedure update_row
177   (
178     p_api_version                  IN NUMBER,
179     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
180     p_validation_level             IN NUMBER,
181     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
182     x_return_status                OUT VARCHAR2,
183     x_msg_count                    OUT NUMBER,
184     x_msg_data                     OUT VARCHAR2,
185     p_reacttime_val_rec            IN ReactTime_Val_Rec_Type := G_MISS_REACTTIME_VAL_REC,
186     x_object_version_number        OUT NUMBER);
187   Procedure update_row
188   (
189     p_api_version                  IN NUMBER,
190     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
191     p_validation_level             IN NUMBER,
192     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
193     x_return_status                OUT VARCHAR2,
194     x_msg_count                    OUT NUMBER,
195     x_msg_data                     OUT VARCHAR2,
196     p_reaction_time_id             IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
197     p_name                         IN CS_COV_REACTION_TIMES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
198     p_description                  IN CS_COV_REACTION_TIMES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
199     p_reaction_time_sunday         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
200     p_reaction_time_monday         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
201     p_reaction_time_tuesday        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
202     p_reaction_time_wednesday      IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
203     p_reaction_time_thursday       IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
204     p_reaction_time_friday         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
205     p_reaction_time_saturday       IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
206     p_incident_severity_id         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
207     p_always_covered               IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
208     p_workflow                     IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
209     p_coverage_txn_group_id        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
210     p_use_for_sr_date_calc         IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
211     p_last_update_date             IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
212     p_last_updated_by              IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
213     p_creation_date                IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
214     p_created_by                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
215     p_last_update_login            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
216     p_attribute1                   IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
217     p_attribute2                   IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
218     p_attribute3                   IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
219     p_attribute4                   IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
220     p_attribute5                   IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
221     p_attribute6                   IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
222     p_attribute7                   IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
223     p_attribute8                   IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
224     p_attribute9                   IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
225     p_attribute10                  IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
226     p_attribute11                  IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
227     p_attribute12                  IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
228     p_attribute13                  IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
229     p_attribute14                  IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
230     p_attribute15                  IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
231     p_context                      IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
232     p_object_version_number        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
233     x_object_version_number        OUT NUMBER);
234   Procedure delete_row
235   (
236     p_api_version                  IN NUMBER,
237     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
238     p_validation_level             IN NUMBER,
239     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
240     x_return_status                OUT VARCHAR2,
241     x_msg_count                    OUT NUMBER,
242     x_msg_data                     OUT VARCHAR2,
243     p_reaction_time_id             IN NUMBER);
244   PROCEDURE validate_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_reacttime_val_rec            IN ReactTime_Val_Rec_Type := G_MISS_REACTTIME_VAL_REC);
254   PROCEDURE validate_row
255   (
256     p_api_version                  IN NUMBER,
257     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
258     p_validation_level             IN NUMBER,
259     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
260     x_return_status                OUT VARCHAR2,
261     x_msg_count                    OUT NUMBER,
262     x_msg_data                     OUT VARCHAR2,
263     p_reaction_time_id             IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
264     p_name                         IN CS_COV_REACTION_TIMES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
265     p_description                  IN CS_COV_REACTION_TIMES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
266     p_reaction_time_sunday         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
267     p_reaction_time_monday         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
268     p_reaction_time_tuesday        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
269     p_reaction_time_wednesday      IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
270     p_reaction_time_thursday       IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
271     p_reaction_time_friday         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
272     p_reaction_time_saturday       IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
273     p_incident_severity_id         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
274     p_always_covered               IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
275     p_workflow                     IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
276     p_coverage_txn_group_id        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
277     p_use_for_sr_date_calc         IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
278     p_last_update_date             IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
279     p_last_updated_by              IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
280     p_creation_date                IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
281     p_created_by                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
282     p_last_update_login            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
283     p_attribute1                   IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
284     p_attribute2                   IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
285     p_attribute3                   IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
286     p_attribute4                   IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
287     p_attribute5                   IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
288     p_attribute6                   IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
289     p_attribute7                   IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
290     p_attribute8                   IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
291     p_attribute9                   IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
292     p_attribute10                  IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
293     p_attribute11                  IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
294     p_attribute12                  IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
295     p_attribute13                  IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
296     p_attribute14                  IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
297     p_attribute15                  IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
298     p_context                      IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
299     p_object_version_number        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
300 END CS_REACTTIME_PVT;