[Home] [Help]
PACKAGE: APPS.CS_TXNGRP_PVT
Source
1 Package CS_TXNGRP_PVT AUTHID CURRENT_USER AS
2 /* $Header: csctxngs.pls 115.0 99/07/16 08:56:12 porting ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE TxnGrp_Rec_Type IS RECORD (
7 coverage_txn_group_id NUMBER := NULL,
8 offset_duration NUMBER := NULL,
9 offset_period CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := NULL,
10 coverage_start_date CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := NULL,
11 coverage_end_date CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := NULL,
12 price_list_id NUMBER := NULL,
13 manufacturing_org_id NUMBER := NULL,
14 subinventory_code CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := NULL,
15 coverage_id NUMBER := NULL,
16 discount_id NUMBER := NULL,
17 business_process_id NUMBER := NULL,
18 sunday_end_time CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := NULL,
19 sunday_start_time CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := NULL,
20 monday_start_time CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := NULL,
21 monday_end_time CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := NULL,
22 tuesday_start_time CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := NULL,
23 tuesday_end_time CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := NULL,
24 wednesday_start_time CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := NULL,
25 wednesday_end_time CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := NULL,
26 thursday_start_time CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := NULL,
27 thursday_end_time CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := NULL,
28 friday_start_time CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := NULL,
29 friday_end_time CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := NULL,
30 saturday_start_time CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := NULL,
31 saturday_end_time CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := NULL,
32 preferred_engineer1 CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := NULL,
33 time_zone_id NUMBER := NULL,
34 preferred_engineer2 CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := NULL,
35 last_update_date CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := NULL,
36 last_updated_by NUMBER := NULL,
37 creation_date CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := NULL,
38 created_by NUMBER := NULL,
39 last_update_login NUMBER := NULL,
40 attribute1 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := NULL,
41 attribute2 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := NULL,
42 attribute3 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := NULL,
43 attribute4 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := NULL,
44 attribute5 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := NULL,
45 attribute6 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := NULL,
46 attribute7 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := NULL,
47 attribute8 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := NULL,
48 attribute9 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := NULL,
49 attribute10 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := NULL,
50 attribute11 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := NULL,
51 attribute12 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := NULL,
52 attribute13 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := NULL,
53 attribute14 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := NULL,
54 attribute15 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := NULL,
55 context CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := NULL,
56 object_version_number NUMBER := NULL);
57 G_MISS_txngrp_rec TxnGrp_Rec_Type;
58 TYPE TxnGrp_Val_Rec_Type IS RECORD (
59 coverage_txn_group_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
60 offset_duration NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
61 offset_period CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
62 coverage_start_date CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
63 coverage_end_date CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
64 price_list_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
65 manufacturing_org_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
66 subinventory_code CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
67 coverage_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
68 discount_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
69 business_process_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
70 sunday_end_time CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
71 sunday_start_time CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
72 monday_start_time CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
73 monday_end_time CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
74 tuesday_start_time CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
75 tuesday_end_time CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
76 wednesday_start_time CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
77 wednesday_end_time CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
78 thursday_start_time CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
79 thursday_end_time CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
80 friday_start_time CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
81 friday_end_time CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
82 saturday_start_time CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
83 saturday_end_time CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
84 preferred_engineer1 CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
85 time_zone_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
86 preferred_engineer2 CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
87 last_update_date CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
88 last_updated_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
89 creation_date CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
90 created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
91 last_update_login NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
92 attribute1 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
93 attribute2 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
94 attribute3 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
95 attribute4 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
96 attribute5 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
97 attribute6 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
98 attribute7 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
99 attribute8 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
100 attribute9 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
101 attribute10 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
102 attribute11 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
103 attribute12 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
104 attribute13 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
105 attribute14 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
106 attribute15 CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
107 context CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
108 object_version_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
109 G_MISS_txngrp_val_rec TxnGrp_Val_Rec_Type;
110 ---------------------------------------------------------------------------
111 -- GLOBAL MESSAGE CONSTANTS
112 ---------------------------------------------------------------------------
113 G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
114 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
115 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
116 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
117 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
118 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
119 G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
120 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
121 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
122 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
123 ---------------------------------------------------------------------------
124 -- GLOBAL VARIABLES
125 ---------------------------------------------------------------------------
126 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_TXNGRP_PVT';
127 G_APP_NAME CONSTANT VARCHAR2(3) := TAPI_DEV_KIT.G_APP_NAME;
128 ---------------------------------------------------------------------------
129 -- Procedures and Functions
130 ---------------------------------------------------------------------------
131
132 PROCEDURE insert_row
133 (
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
136 p_validation_level IN NUMBER,
137 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
138 x_return_status OUT VARCHAR2,
139 x_msg_count OUT NUMBER,
140 x_msg_data OUT VARCHAR2,
141 p_txngrp_rec IN TxnGrp_Rec_Type := G_MISS_TXNGRP_REC,
142 x_coverage_txn_group_id OUT NUMBER,
143 x_object_version_number OUT NUMBER);
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_offset_duration IN NUMBER := NULL,
154 p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := NULL,
155 p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := NULL,
156 p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := NULL,
157 p_price_list_id IN NUMBER := NULL,
158 p_manufacturing_org_id IN NUMBER := NULL,
159 p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := NULL,
160 p_coverage_id IN NUMBER := NULL,
161 p_discount_id IN NUMBER := NULL,
162 p_business_process_id IN NUMBER := NULL,
163 p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := NULL,
164 p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := NULL,
165 p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := NULL,
166 p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := NULL,
167 p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := NULL,
168 p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := NULL,
169 p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := NULL,
170 p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := NULL,
171 p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := NULL,
172 p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := NULL,
173 p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := NULL,
174 p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := NULL,
175 p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := NULL,
176 p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := NULL,
177 p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := NULL,
178 p_time_zone_id IN NUMBER := NULL,
179 p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := NULL,
180 p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := NULL,
181 p_last_updated_by IN NUMBER := NULL,
182 p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := NULL,
183 p_created_by IN NUMBER := NULL,
184 p_last_update_login IN NUMBER := NULL,
185 p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := NULL,
186 p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := NULL,
187 p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := NULL,
188 p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := NULL,
189 p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := NULL,
190 p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := NULL,
191 p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := NULL,
192 p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := NULL,
193 p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := NULL,
194 p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := NULL,
195 p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := NULL,
196 p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := NULL,
197 p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := NULL,
198 p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := NULL,
199 p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := NULL,
200 p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := NULL,
201 p_object_version_number IN NUMBER := NULL,
202 x_coverage_txn_group_id OUT NUMBER,
203 x_object_version_number OUT NUMBER);
204 Procedure lock_row
205 (
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
208 p_validation_level IN NUMBER,
209 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
213 p_coverage_txn_group_id IN NUMBER,
210 x_return_status OUT VARCHAR2,
211 x_msg_count OUT NUMBER,
212 x_msg_data OUT VARCHAR2,
214 p_object_version_number IN NUMBER);
215 Procedure update_row
216 (
217 p_api_version IN NUMBER,
218 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
219 p_validation_level IN NUMBER,
220 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
221 x_return_status OUT VARCHAR2,
222 x_msg_count OUT NUMBER,
223 x_msg_data OUT VARCHAR2,
224 p_txngrp_val_rec IN TxnGrp_Val_Rec_Type := G_MISS_TXNGRP_VAL_REC,
225 x_object_version_number OUT NUMBER);
226 Procedure update_row
227 (
228 p_api_version IN NUMBER,
229 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
230 p_validation_level IN NUMBER,
231 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
232 x_return_status OUT VARCHAR2,
233 x_msg_count OUT NUMBER,
234 x_msg_data OUT VARCHAR2,
235 p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
236 p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
237 p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
238 p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
239 p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
240 p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
241 p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
242 p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
243 p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
244 p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
245 p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
246 p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
247 p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
248 p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
249 p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
250 p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
251 p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
252 p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
253 p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
254 p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
255 p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
256 p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
257 p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
258 p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
259 p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
260 p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
261 p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
262 p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
263 p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
264 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
265 p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
266 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
267 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
268 p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
269 p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
270 p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
271 p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
272 p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
273 p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
274 p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
275 p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
276 p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
277 p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
278 p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
279 p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
280 p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
281 p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
282 p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
283 p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
287 (
284 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
285 x_object_version_number OUT NUMBER);
286 Procedure delete_row
288 p_api_version IN NUMBER,
289 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
290 p_validation_level IN NUMBER,
291 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
292 x_return_status OUT VARCHAR2,
293 x_msg_count OUT NUMBER,
294 x_msg_data OUT VARCHAR2,
295 p_coverage_txn_group_id IN NUMBER);
296 PROCEDURE validate_row
297 (
298 p_api_version IN NUMBER,
299 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
300 p_validation_level IN NUMBER,
301 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
302 x_return_status OUT VARCHAR2,
303 x_msg_count OUT NUMBER,
304 x_msg_data OUT VARCHAR2,
305 p_txngrp_val_rec IN TxnGrp_Val_Rec_Type := G_MISS_TXNGRP_VAL_REC);
306 PROCEDURE validate_row
307 (
308 p_api_version IN NUMBER,
309 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
310 p_validation_level IN NUMBER,
311 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
312 x_return_status OUT VARCHAR2,
313 x_msg_count OUT NUMBER,
314 x_msg_data OUT VARCHAR2,
315 p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
316 p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
317 p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
318 p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
319 p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
320 p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
321 p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
322 p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
323 p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
324 p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
325 p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
326 p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
327 p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
328 p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
329 p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
330 p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
331 p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
332 p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
333 p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
334 p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
335 p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
336 p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
337 p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
338 p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
339 p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
340 p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
341 p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
342 p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
343 p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
344 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
345 p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
346 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
347 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
348 p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
349 p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
350 p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
351 p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
352 p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
353 p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
354 p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
355 p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
356 p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
357 p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
358 p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
359 p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
360 p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
361 p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
362 p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
363 p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
364 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
365 END CS_TXNGRP_PVT;