[Home] [Help]
PACKAGE: APPS.CS_CONTRACT_PVT
Source
1 Package CS_CONTRACT_PVT AUTHID CURRENT_USER AS
2 /* $Header: csctcons.pls 115.1 99/07/16 08:50:22 porting ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE Contract_Rec_Type IS RECORD (
7 contract_id NUMBER := NULL,
8 contract_number NUMBER := NULL,
9 workflow CS_CONTRACTS.WORKFLOW%TYPE := NULL,
10 workflow_process_id NUMBER := NULL,
11 agreement_id NUMBER := NULL,
12 price_list_id NUMBER := NULL,
13 currency_code CS_CONTRACTS.CURRENCY_CODE%TYPE := NULL,
14 conversion_type_code CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := NULL,
15 conversion_rate NUMBER := NULL,
16 conversion_date CS_CONTRACTS.CONVERSION_DATE%TYPE := NULL,
17 invoicing_rule_id NUMBER := NULL,
18 accounting_rule_id NUMBER := NULL,
19 billing_frequency_period CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
20 first_bill_date CS_CONTRACTS.FIRST_BILL_DATE%TYPE := NULL,
21 next_bill_date CS_CONTRACTS.NEXT_BILL_DATE%TYPE := NULL,
22 create_sales_order CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := NULL,
23 renewal_rule CS_CONTRACTS.RENEWAL_RULE%TYPE := NULL,
24 termination_rule CS_CONTRACTS.TERMINATION_RULE%TYPE := NULL,
25 bill_to_site_use_id NUMBER := NULL,
26 contract_status_id NUMBER := NULL,
27 contract_type_id NUMBER := NULL,
28 contract_template_id NUMBER := NULL,
29 contract_group_id NUMBER := NULL,
30 customer_id NUMBER := NULL,
31 duration NUMBER := NULL,
32 period_code CS_CONTRACTS.PERIOD_CODE%TYPE := NULL,
33 ship_to_site_use_id NUMBER := NULL,
34 salesperson_id NUMBER := NULL,
35 ordered_by_contact_id NUMBER := NULL,
36 source_code CS_CONTRACTS.SOURCE_CODE%TYPE := NULL,
37 source_reference CS_CONTRACTS.SOURCE_REFERENCE%TYPE := NULL,
38 terms_id NUMBER := NULL,
39 po_number CS_CONTRACTS.PO_NUMBER%TYPE := NULL,
40 bill_on NUMBER := NULL,
41 tax_handling CS_CONTRACTS.TAX_HANDLING%TYPE := NULL,
42 tax_exempt_num CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := NULL,
43 tax_exempt_reason_code CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
44 contract_amount NUMBER := NULL,
45 auto_renewal_flag CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := NULL,
46 original_end_date CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := NULL,
47 terminate_reason_code CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := NULL,
48 discount_id NUMBER := NULL,
49 po_required_to_service CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := NULL,
50 pre_payment_required CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := NULL,
51 last_update_date CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := NULL,
52 last_updated_by NUMBER := NULL,
53 creation_date CS_CONTRACTS.CREATION_DATE%TYPE := NULL,
54 created_by NUMBER := NULL,
55 last_update_login NUMBER := NULL,
56 start_date_active CS_CONTRACTS.START_DATE_ACTIVE%TYPE := NULL,
57 end_date_active CS_CONTRACTS.END_DATE_ACTIVE%TYPE := NULL,
58 attribute1 CS_CONTRACTS.ATTRIBUTE1%TYPE := NULL,
59 attribute2 CS_CONTRACTS.ATTRIBUTE2%TYPE := NULL,
60 attribute3 CS_CONTRACTS.ATTRIBUTE3%TYPE := NULL,
61 attribute4 CS_CONTRACTS.ATTRIBUTE4%TYPE := NULL,
62 attribute5 CS_CONTRACTS.ATTRIBUTE5%TYPE := NULL,
63 attribute6 CS_CONTRACTS.ATTRIBUTE6%TYPE := NULL,
64 attribute7 CS_CONTRACTS.ATTRIBUTE7%TYPE := NULL,
65 attribute8 CS_CONTRACTS.ATTRIBUTE8%TYPE := NULL,
66 attribute9 CS_CONTRACTS.ATTRIBUTE9%TYPE := NULL,
67 attribute10 CS_CONTRACTS.ATTRIBUTE10%TYPE := NULL,
68 attribute11 CS_CONTRACTS.ATTRIBUTE11%TYPE := NULL,
69 attribute12 CS_CONTRACTS.ATTRIBUTE12%TYPE := NULL,
70 attribute13 CS_CONTRACTS.ATTRIBUTE13%TYPE := NULL,
71 attribute14 CS_CONTRACTS.ATTRIBUTE14%TYPE := NULL,
72 attribute15 CS_CONTRACTS.ATTRIBUTE15%TYPE := NULL,
73 context CS_CONTRACTS.CONTEXT%TYPE := NULL,
74 object_version_number NUMBER := NULL);
75 G_MISS_contract_rec Contract_Rec_Type;
76 TYPE Contract_Val_Rec_Type IS RECORD (
77 contract_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
78 contract_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
79 workflow CS_CONTRACTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
80 workflow_process_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
81 agreement_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
82 price_list_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
83 currency_code CS_CONTRACTS.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
84 conversion_type_code CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
85 conversion_rate NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
86 conversion_date CS_CONTRACTS.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
87 invoicing_rule_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
88 accounting_rule_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
89 billing_frequency_period CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
90 first_bill_date CS_CONTRACTS.FIRST_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
91 next_bill_date CS_CONTRACTS.NEXT_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
92 create_sales_order CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
93 renewal_rule CS_CONTRACTS.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
94 termination_rule CS_CONTRACTS.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
95 bill_to_site_use_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
96 contract_status_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
97 contract_type_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
98 contract_template_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
99 contract_group_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
100 customer_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
101 duration NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
102 period_code CS_CONTRACTS.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
103 ship_to_site_use_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
104 salesperson_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
105 ordered_by_contact_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
106 source_code CS_CONTRACTS.SOURCE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
107 source_reference CS_CONTRACTS.SOURCE_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
108 terms_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
109 po_number CS_CONTRACTS.PO_NUMBER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
110 bill_on NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
111 tax_handling CS_CONTRACTS.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
112 tax_exempt_num CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
113 tax_exempt_reason_code CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
114 contract_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
115 auto_renewal_flag CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
116 original_end_date CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
117 terminate_reason_code CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
118 discount_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
119 po_required_to_service CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
120 pre_payment_required CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
121 last_update_date CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
122 last_updated_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
123 creation_date CS_CONTRACTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
124 created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
125 last_update_login NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
126 start_date_active CS_CONTRACTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
127 end_date_active CS_CONTRACTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
128 attribute1 CS_CONTRACTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
129 attribute2 CS_CONTRACTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
130 attribute3 CS_CONTRACTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
131 attribute4 CS_CONTRACTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
132 attribute5 CS_CONTRACTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
133 attribute6 CS_CONTRACTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
134 attribute7 CS_CONTRACTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
135 attribute8 CS_CONTRACTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
136 attribute9 CS_CONTRACTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
137 attribute10 CS_CONTRACTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
138 attribute11 CS_CONTRACTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
139 attribute12 CS_CONTRACTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
140 attribute13 CS_CONTRACTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
141 attribute14 CS_CONTRACTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
142 attribute15 CS_CONTRACTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
143 context CS_CONTRACTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
144 object_version_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
145 G_MISS_contract_val_rec Contract_Val_Rec_Type;
146 ---------------------------------------------------------------------------
147 -- GLOBAL MESSAGE CONSTANTS
148 ---------------------------------------------------------------------------
149 G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
150 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
151 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
152 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
153 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
154 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
155 G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
156 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
157 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
158 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
159 ---------------------------------------------------------------------------
160 -- GLOBAL VARIABLES
161 ---------------------------------------------------------------------------
162 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_CONTRACT_PVT';
163 G_APP_NAME CONSTANT VARCHAR2(3) := TAPI_DEV_KIT.G_APP_NAME;
164 ---------------------------------------------------------------------------
165 -- Procedures and Functions
166 ---------------------------------------------------------------------------
167
168 PROCEDURE insert_row
169 (
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
172 p_validation_level IN NUMBER,
173 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
174 x_return_status OUT VARCHAR2,
175 x_msg_count OUT NUMBER,
176 x_msg_data OUT VARCHAR2,
177 p_contract_rec IN Contract_Rec_Type := G_MISS_CONTRACT_REC,
178 x_contract_id OUT NUMBER,
179 x_object_version_number OUT NUMBER);
180 PROCEDURE insert_row
181 (
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
184 p_validation_level IN NUMBER,
185 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
186 x_return_status OUT VARCHAR2,
187 x_msg_count OUT NUMBER,
188 x_msg_data OUT VARCHAR2,
189 p_contract_number IN NUMBER := NULL,
190 p_workflow IN CS_CONTRACTS.WORKFLOW%TYPE := NULL,
191 p_workflow_process_id IN NUMBER := NULL,
192 p_agreement_id IN NUMBER := NULL,
193 p_price_list_id IN NUMBER := NULL,
194 p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := NULL,
195 p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := NULL,
196 p_conversion_rate IN NUMBER := NULL,
197 p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := NULL,
198 p_invoicing_rule_id IN NUMBER := NULL,
199 p_accounting_rule_id IN NUMBER := NULL,
200 p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
201 p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := NULL,
202 p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := NULL,
203 p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := NULL,
204 p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := NULL,
205 p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := NULL,
206 p_bill_to_site_use_id IN NUMBER := NULL,
207 p_contract_status_id IN NUMBER := NULL,
208 p_contract_type_id IN NUMBER := NULL,
209 p_contract_template_id IN NUMBER := NULL,
210 p_contract_group_id IN NUMBER := NULL,
211 p_customer_id IN NUMBER := NULL,
212 p_duration IN NUMBER := NULL,
213 p_period_code IN CS_CONTRACTS.PERIOD_CODE%TYPE := NULL,
214 p_ship_to_site_use_id IN NUMBER := NULL,
215 p_salesperson_id IN NUMBER := NULL,
216 p_ordered_by_contact_id IN NUMBER := NULL,
217 p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := NULL,
218 p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := NULL,
222 p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := NULL,
219 p_terms_id IN NUMBER := NULL,
220 p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := NULL,
221 p_bill_on IN NUMBER := NULL,
223 p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := NULL,
224 p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
225 p_contract_amount IN NUMBER := NULL,
226 p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := NULL,
227 p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := NULL,
228 p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := NULL,
229 p_discount_id IN NUMBER := NULL,
230 p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := NULL,
231 p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := NULL,
232 p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := NULL,
233 p_last_updated_by IN NUMBER := NULL,
234 p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := NULL,
235 p_created_by IN NUMBER := NULL,
236 p_last_update_login IN NUMBER := NULL,
237 p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := NULL,
238 p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := NULL,
239 p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := NULL,
240 p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := NULL,
241 p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := NULL,
242 p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := NULL,
243 p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := NULL,
244 p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := NULL,
245 p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := NULL,
246 p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := NULL,
247 p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := NULL,
248 p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := NULL,
249 p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := NULL,
250 p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := NULL,
251 p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := NULL,
252 p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := NULL,
253 p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := NULL,
254 p_context IN CS_CONTRACTS.CONTEXT%TYPE := NULL,
255 p_object_version_number IN NUMBER := NULL,
256 x_contract_id OUT NUMBER,
257 x_object_version_number OUT NUMBER);
258 Procedure lock_row
259 (
260 p_api_version IN NUMBER,
261 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
262 p_validation_level IN NUMBER,
263 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
264 x_return_status OUT VARCHAR2,
265 x_msg_count OUT NUMBER,
266 x_msg_data OUT VARCHAR2,
267 p_contract_id IN NUMBER,
268 p_object_version_number IN NUMBER);
269 Procedure update_row
270 (
271 p_api_version IN NUMBER,
272 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
273 p_validation_level IN NUMBER,
274 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
275 x_return_status OUT VARCHAR2,
276 x_msg_count OUT NUMBER,
277 x_msg_data OUT VARCHAR2,
278 p_contract_val_rec IN Contract_Val_Rec_Type := G_MISS_CONTRACT_VAL_REC,
279 x_object_version_number OUT NUMBER);
280 Procedure update_row
281 (
282 p_api_version IN NUMBER,
283 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
284 p_validation_level IN NUMBER,
285 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
286 x_return_status OUT VARCHAR2,
287 x_msg_count OUT NUMBER,
288 x_msg_data OUT VARCHAR2,
289 p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
290 p_contract_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
291 p_workflow IN CS_CONTRACTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
292 p_workflow_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
293 p_agreement_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
294 p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
295 p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
296 p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
297 p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
298 p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
299 p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
300 p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
301 p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
302 p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
303 p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
304 p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
305 p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
306 p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
307 p_bill_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
311 p_contract_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
308 p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
309 p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
310 p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
312 p_customer_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
313 p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
314 p_period_code IN CS_CONTRACTS.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
315 p_ship_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
316 p_salesperson_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
317 p_ordered_by_contact_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
318 p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
319 p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
320 p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
321 p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
322 p_bill_on IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
323 p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
324 p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
325 p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
326 p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
327 p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
328 p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
329 p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
330 p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
331 p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
332 p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
333 p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
334 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
335 p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
336 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
337 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
338 p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
339 p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
340 p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
341 p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
342 p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
343 p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
344 p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
345 p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
346 p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
347 p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
348 p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
349 p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
350 p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
351 p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
352 p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
353 p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
354 p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
355 p_context IN CS_CONTRACTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
356 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
357 x_object_version_number OUT NUMBER);
358 Procedure delete_row
359 (
360 p_api_version IN NUMBER,
361 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
362 p_validation_level IN NUMBER,
363 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
364 x_return_status OUT VARCHAR2,
365 x_msg_count OUT NUMBER,
366 x_msg_data OUT VARCHAR2,
367 p_contract_id IN NUMBER);
368 PROCEDURE validate_row
369 (
370 p_api_version IN NUMBER,
371 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
372 p_validation_level IN NUMBER,
373 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
374 x_return_status OUT VARCHAR2,
375 x_msg_count OUT NUMBER,
376 x_msg_data OUT VARCHAR2,
377 p_contract_val_rec IN Contract_Val_Rec_Type := G_MISS_CONTRACT_VAL_REC);
378 PROCEDURE validate_row
379 (
380 p_api_version IN NUMBER,
381 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
382 p_validation_level IN NUMBER,
383 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
384 x_return_status OUT VARCHAR2,
385 x_msg_count OUT NUMBER,
386 x_msg_data OUT VARCHAR2,
387 p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
388 p_contract_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
389 p_workflow IN CS_CONTRACTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
393 p_currency_code IN CS_CONTRACTS.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
390 p_workflow_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
391 p_agreement_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
392 p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
394 p_conversion_type_code IN CS_CONTRACTS.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
395 p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
396 p_conversion_date IN CS_CONTRACTS.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
397 p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
398 p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
399 p_billing_frequency_period IN CS_CONTRACTS.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
400 p_first_bill_date IN CS_CONTRACTS.FIRST_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
401 p_next_bill_date IN CS_CONTRACTS.NEXT_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
402 p_create_sales_order IN CS_CONTRACTS.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
403 p_renewal_rule IN CS_CONTRACTS.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
404 p_termination_rule IN CS_CONTRACTS.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
405 p_bill_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
406 p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
407 p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
408 p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
409 p_contract_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
410 p_customer_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
411 p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
412 p_period_code IN CS_CONTRACTS.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
413 p_ship_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
414 p_salesperson_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
415 p_ordered_by_contact_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
416 p_source_code IN CS_CONTRACTS.SOURCE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
417 p_source_reference IN CS_CONTRACTS.SOURCE_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
418 p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
419 p_po_number IN CS_CONTRACTS.PO_NUMBER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
420 p_bill_on IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
421 p_tax_handling IN CS_CONTRACTS.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
422 p_tax_exempt_num IN CS_CONTRACTS.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
423 p_tax_exempt_reason_code IN CS_CONTRACTS.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
424 p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
425 p_auto_renewal_flag IN CS_CONTRACTS.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
426 p_original_end_date IN CS_CONTRACTS.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
427 p_terminate_reason_code IN CS_CONTRACTS.TERMINATE_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
428 p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
429 p_po_required_to_service IN CS_CONTRACTS.PO_REQUIRED_TO_SERVICE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
430 p_pre_payment_required IN CS_CONTRACTS.PRE_PAYMENT_REQUIRED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
431 p_last_update_date IN CS_CONTRACTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
432 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
433 p_creation_date IN CS_CONTRACTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
434 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
435 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
436 p_start_date_active IN CS_CONTRACTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
437 p_end_date_active IN CS_CONTRACTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
438 p_attribute1 IN CS_CONTRACTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
439 p_attribute2 IN CS_CONTRACTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
440 p_attribute3 IN CS_CONTRACTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
441 p_attribute4 IN CS_CONTRACTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
442 p_attribute5 IN CS_CONTRACTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
443 p_attribute6 IN CS_CONTRACTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
444 p_attribute7 IN CS_CONTRACTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
445 p_attribute8 IN CS_CONTRACTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
446 p_attribute9 IN CS_CONTRACTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
447 p_attribute10 IN CS_CONTRACTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
448 p_attribute11 IN CS_CONTRACTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
449 p_attribute12 IN CS_CONTRACTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
450 p_attribute13 IN CS_CONTRACTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
451 p_attribute14 IN CS_CONTRACTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
452 p_attribute15 IN CS_CONTRACTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
453 p_context IN CS_CONTRACTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
454 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
455 END CS_CONTRACT_PVT;