[Home] [Help]
PACKAGE: APPS.CS_CONTRACTSTATS_PVT
Source
1 Package CS_CONTRACTSTATS_PVT AUTHID CURRENT_USER AS
2 /* $Header: csctcsts.pls 115.0 99/07/16 08:51:32 porting ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ContractStats_Rec_Type IS RECORD (
7 contract_status_id NUMBER := NULL,
8 name CS_CONTRACT_STATUSES.NAME%TYPE := NULL,
9 description CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := NULL,
10 validate_contract CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := NULL,
11 status_level NUMBER := NULL,
12 eligible_for_invoicing CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := NULL,
13 update_allowed CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := NULL,
14 eligible_for_entitlements CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := NULL,
15 terminated_flag CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := NULL,
16 delete_allowed CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := NULL,
17 last_update_date CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := NULL,
18 last_updated_by NUMBER := NULL,
19 creation_date CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := NULL,
20 created_by NUMBER := NULL,
21 last_update_login NUMBER := NULL,
22 start_date_active CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := NULL,
23 end_date_active CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := NULL,
24 attribute1 CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := NULL,
25 attribute2 CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := NULL,
26 attribute3 CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := NULL,
27 attribute4 CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := NULL,
28 attribute5 CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := NULL,
29 attribute6 CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := NULL,
30 attribute7 CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := NULL,
31 attribute8 CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := NULL,
32 attribute9 CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := NULL,
33 attribute10 CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := NULL,
34 attribute11 CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := NULL,
35 attribute12 CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := NULL,
36 attribute13 CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := NULL,
37 attribute14 CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := NULL,
38 attribute15 CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := NULL,
39 context CS_CONTRACT_STATUSES.CONTEXT%TYPE := NULL,
40 object_version_number NUMBER := NULL);
41 G_MISS_contractstats_rec ContractStats_Rec_Type;
42 TYPE ContractStats_Val_Rec_Type IS RECORD (
43 contract_status_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
44 name CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
45 description CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
46 validate_contract CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
47 status_level NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
48 eligible_for_invoicing CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
49 update_allowed CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
50 eligible_for_entitlements CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
51 terminated_flag CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
52 delete_allowed CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
53 last_update_date CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
54 last_updated_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
55 creation_date CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
56 created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
57 last_update_login NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
58 start_date_active CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
59 end_date_active CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
60 attribute1 CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
61 attribute2 CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
62 attribute3 CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
63 attribute4 CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
64 attribute5 CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
65 attribute6 CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
66 attribute7 CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
67 attribute8 CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
68 attribute9 CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
69 attribute10 CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
70 attribute11 CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
71 attribute12 CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
72 attribute13 CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
73 attribute14 CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
74 attribute15 CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
75 context CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
76 object_version_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
77 G_MISS_contractstats_val_rec ContractStats_Val_Rec_Type;
78 ---------------------------------------------------------------------------
79 -- GLOBAL MESSAGE CONSTANTS
80 ---------------------------------------------------------------------------
81 G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
82 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
83 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
84 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
85 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
86 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
87 G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
88 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
89 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
90 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
91 ---------------------------------------------------------------------------
92 -- GLOBAL VARIABLES
93 ---------------------------------------------------------------------------
94 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_CONTRACTSTATS_PVT';
95 G_APP_NAME CONSTANT VARCHAR2(3) := TAPI_DEV_KIT.G_APP_NAME;
96 ---------------------------------------------------------------------------
97 -- Procedures and Functions
98 ---------------------------------------------------------------------------
99
100 PROCEDURE insert_row
101 (
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
104 p_validation_level IN NUMBER,
105 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
106 x_return_status OUT VARCHAR2,
107 x_msg_count OUT NUMBER,
108 x_msg_data OUT VARCHAR2,
109 p_contractstats_rec IN ContractStats_Rec_Type := G_MISS_CONTRACTSTATS_REC,
110 x_contract_status_id OUT NUMBER,
111 x_object_version_number OUT NUMBER);
112 PROCEDURE insert_row
113 (
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
116 p_validation_level IN NUMBER,
117 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
118 x_return_status OUT VARCHAR2,
119 x_msg_count OUT NUMBER,
120 x_msg_data OUT VARCHAR2,
121 p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := NULL,
122 p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := NULL,
123 p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := NULL,
124 p_status_level IN NUMBER := NULL,
125 p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := NULL,
126 p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := NULL,
127 p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := NULL,
128 p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := NULL,
129 p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := NULL,
130 p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := NULL,
131 p_last_updated_by IN NUMBER := NULL,
132 p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := NULL,
133 p_created_by IN NUMBER := NULL,
134 p_last_update_login IN NUMBER := NULL,
135 p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := NULL,
136 p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := NULL,
137 p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := NULL,
138 p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := NULL,
139 p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := NULL,
140 p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := NULL,
141 p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := NULL,
142 p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := NULL,
143 p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := NULL,
144 p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := NULL,
145 p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := NULL,
146 p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := NULL,
147 p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := NULL,
148 p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := NULL,
149 p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := NULL,
150 p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := NULL,
151 p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := NULL,
152 p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := NULL,
153 p_object_version_number IN NUMBER := NULL,
154 x_contract_status_id OUT NUMBER,
155 x_object_version_number OUT NUMBER);
156 Procedure lock_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_contract_status_id IN NUMBER,
166 p_object_version_number IN NUMBER);
167 Procedure update_row
168 (
169 p_api_version IN NUMBER,
170 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
171 p_validation_level IN NUMBER,
172 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
173 x_return_status OUT VARCHAR2,
174 x_msg_count OUT NUMBER,
175 x_msg_data OUT VARCHAR2,
176 p_contractstats_val_rec IN ContractStats_Val_Rec_Type := G_MISS_CONTRACTSTATS_VAL_REC,
177 x_object_version_number OUT NUMBER);
178 Procedure update_row
179 (
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
182 p_validation_level IN NUMBER,
183 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
184 x_return_status OUT VARCHAR2,
185 x_msg_count OUT NUMBER,
186 x_msg_data OUT VARCHAR2,
187 p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
188 p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
189 p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
190 p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
191 p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
192 p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
193 p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
194 p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
195 p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
196 p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
197 p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
198 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
199 p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
200 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
201 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
202 p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
203 p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
204 p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
205 p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
206 p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
207 p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
211 p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
208 p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
209 p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
210 p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
212 p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
213 p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
214 p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
215 p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
216 p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
217 p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
218 p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
219 p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
220 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
221 x_object_version_number OUT NUMBER);
222 Procedure delete_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_contract_status_id IN NUMBER);
232 PROCEDURE validate_row
233 (
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
236 p_validation_level IN NUMBER,
237 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
238 x_return_status OUT VARCHAR2,
239 x_msg_count OUT NUMBER,
240 x_msg_data OUT VARCHAR2,
241 p_contractstats_val_rec IN ContractStats_Val_Rec_Type := G_MISS_CONTRACTSTATS_VAL_REC);
242 PROCEDURE validate_row
243 (
244 p_api_version IN NUMBER,
245 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
246 p_validation_level IN NUMBER,
247 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
248 x_return_status OUT VARCHAR2,
249 x_msg_count OUT NUMBER,
250 x_msg_data OUT VARCHAR2,
251 p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
252 p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
253 p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
254 p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
255 p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
256 p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
257 p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
258 p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
259 p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
260 p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
261 p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
262 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
263 p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
264 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
265 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
266 p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
267 p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
268 p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
269 p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
270 p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
271 p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
272 p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
273 p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
274 p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
275 p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
276 p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
277 p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
278 p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
279 p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
280 p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
281 p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
282 p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
283 p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
284 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
285 END CS_CONTRACTSTATS_PVT;