[Home] [Help]
PACKAGE: APPS.OKS_CONTRACTS_PUB
Source
1 Package OKS_CONTRACTS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSPKCRS.pls 120.0 2005/05/25 18:28:48 appldev noship $ */
3
4
5 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
6 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
7 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
8 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
9 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
10 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
14
15 ------------------------------------------------------------------------------------
16 -- GLOBAL EXCEPTION
17 ---------------------------------------------------------------------------
18 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
19
20 --global variables
21
22 ---------------------------------------------------------------------------
23 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKSOMINT';
24 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
25
26 G_JTF_ORDER_HDR CONSTANT VARCHAR2(200) := 'OKX_ORDERHEAD';
27 G_JTF_ORDER_LN CONSTANT VARCHAR2(200) := 'OKX_ORDERLINE';
28
29 G_INVOICE_CONTACT CONSTANT VARCHAR2(200) := 'BILLING';
30 G_RULE_GROUP_CODE CONSTANT VARCHAR2(200) := 'SVC_K';
31
32 G_JTF_EXTWARR CONSTANT VARCHAR2(200) := 'OKX_SERVICE';
33 G_JTF_WARR CONSTANT VARCHAR2(200) := 'OKX_WARRANTY';
34 G_JTF_PARTY CONSTANT VARCHAR2(200) := 'OKX_PARTY';
35 G_JTF_PARTY_VENDOR CONSTANT VARCHAR2(200) := 'OKX_OPERUNIT';
36 G_JTF_INVOICE_CONTACT CONSTANT VARCHAR2(200) := 'OKX_PCONTACT';
37 G_JTF_BILLTO CONSTANT VARCHAR2(200) := 'OKX_BILLTO';
38 G_JTF_COUNTER CONSTANT VARCHAR2(200) := 'OKX_COUNTER';
39 G_JTF_USAGE CONSTANT VARCHAR2(200) := 'OKX_USAGE';
40 G_JTF_SHIPTO CONSTANT VARCHAR2(200) := 'OKX_SHIPTO';
41 G_JTF_ARL CONSTANT VARCHAR2(200) := 'OKX_ACCTRULE';
42 G_JTF_IRE CONSTANT VARCHAR2(200) := 'OKX_INVRULE';
43 G_JTF_CUSTPROD CONSTANT VARCHAR2(200) := 'OKX_CUSTPROD';
44 G_JTF_CUSTACCT CONSTANT VARCHAR2(200) := 'OKX_CUSTACCT';
45 G_JTF_PRICE CONSTANT VARCHAR2(200) := 'OKX_PRICE';
46 G_JTF_PAYMENT_TERM CONSTANT VARCHAR2(200) := 'OKX_RPAYTERM';
47 G_JTF_CONV_TYPE CONSTANT VARCHAR2(200) := 'OKX_CONVTYPE';
48 G_JTF_TAXEXEMP CONSTANT VARCHAR2(200) := 'OKX_TAXEXEMP';
49 G_JTF_TAXCTRL CONSTANT VARCHAR2(200) := 'OKX_TAXCTRL';
50 ----
51
52 Type Header_Rec_Type Is Record
53 (
54 contract_number Varchar2(120)
55 , start_date Date
56 , end_date Date
57 , sts_code Varchar2(30)
58 , scs_code Varchar2(30)
59 , authoring_org_id Number
60 , short_description Varchar2(1995)
61 , chr_group Number
62 , pdf_id Number
63 , party_id Number
64 , bill_to_id Number
65 , ship_to_id Number
66 , price_list_id Number
67 , cust_po_number Varchar2(240)
68 , agreement_id Number
69 , currency Varchar2(15)
70 , accounting_rule_type Number
71 , invoice_rule_type Number
72 , order_hdr_id Number
73 , payment_term_id Number
74 , cvn_type Varchar2(25)
75 , cvn_rate Number
76 , cvn_date Date
77 , cvn_euro_rate Number
78 , tax_exemption_id Number
79 , qto_contact_id Number
80 , qto_email_id Number
81 , qto_phone_id Number
82 , qto_fax_id Number
83 , qto_site_id Number
84 , contact_id Number
85 , tax_status_flag Varchar2(30)
86 , third_party_role Varchar2(30)
87 , merge_type Varchar2(10) --'NEW'
88 , merge_object_id Number -- 'NULL'
89 , renewal_type Varchar2(3) --'NSR/SFA/DNR/EVN'
90 , renewal_pricing_type Varchar2(3) --'LST/PCT/MAN'
91 , renewal_price_list_id Number
92 , renewal_markup Number
93 , renewal_po Varchar2(1) --'Y/N'
94 , estimate_percent Number
95 , estimate_duration Number
96 , estimate_period Varchar2(25)
97 , Credit_card_no VARCHAR2(40)
98 , Expiry_date DATE
99 , Organization_id NUMBER
100 , Ar_interface_yn VARCHAR2(1)
101 , transaction_type VARCHAR2(40)
102 , Summary_invoice_yn VARCHAR2(1)
103 , rve_percent VARCHAR2(40)
104 , rve_end_date DATE
105 , qcl_id NUMBER
106 , ATTRIBUTE1 VARCHAR2(450)
107 , ATTRIBUTE2 VARCHAR2(450)
108 , ATTRIBUTE3 VARCHAR2(450)
109 , ATTRIBUTE4 VARCHAR2(450)
110 , ATTRIBUTE5 VARCHAR2(450)
111 , ATTRIBUTE6 VARCHAR2(450)
112 , ATTRIBUTE7 VARCHAR2(450)
113 , ATTRIBUTE8 VARCHAR2(450)
114 , ATTRIBUTE9 VARCHAR2(450)
115 , ATTRIBUTE10 VARCHAR2(450)
116 , ATTRIBUTE11 VARCHAR2(450)
117 , ATTRIBUTE12 VARCHAR2(450)
118 , ATTRIBUTE13 VARCHAR2(450)
119 , ATTRIBUTE14 VARCHAR2(450)
120 , ATTRIBUTE15 VARCHAR2(450)
121 );
122
123 Type Counter_Type Is Record
124 (
125 usage_item_id Number
126 , counter_id Number
127 );
128 Type Counter_tbl is TABLE of Counter_type index by binary_integer;
129
130 Type Contact_Type Is Record
131 (
132 party_role Varchar2(30)
133 , contact_role Varchar2(30)
134 , contact_object_code Varchar2(30)
135 , contact_id Number
136 );
137 Type Contact_tbl is TABLE of Contact_type index by binary_integer;
138
139 Type SalesCredit_Type Is Record
140 (
141 ctc_id Number
142 , sales_credit_type_id Number
143 , percent Number
144 );
145 Type SalesCredit_tbl is TABLE of SalesCredit_type index by binary_integer;
146
147 Type line_Rec_Type Is Record
148 (
149 k_hdr_id Number
150 , k_line_number Varchar2(150)
151 , line_sts_code Varchar2(30)
152 , cust_account Number
153 , org_id Number
154 , organization_id NUMBER
155 , bill_to_id Number
156 , ship_to_id Number
157 , order_line_id Number
158 , accounting_rule_type Number
159 , invoicing_rule_type Number
160 , line_type VARCHAR(2) ---E,U.W,S,SB,SU
161 , currency Varchar2(15)
162 , list_price Number
163 , negotiated_amount Number
164 , reason_code Varchar2(30)
165 , reason_comments Varchar2(1995)
166 , line_renewal_type Varchar2(3) -- 'FUL/KEP/DNR'
167 , usage_type VARCHAR2(30)
168 , usage_period Varchar2(30)
169 , tax_exemption_id Number
170 , tax_status_flag Varchar2(30)
171 , customer_product_id Number
172 , ATTRIBUTE1 VARCHAR2(450)
173 , ATTRIBUTE2 VARCHAR2(450)
174 , ATTRIBUTE3 VARCHAR2(450)
175 , ATTRIBUTE4 VARCHAR2(450)
176 , ATTRIBUTE5 VARCHAR2(450)
177 , ATTRIBUTE6 VARCHAR2(450)
178 , ATTRIBUTE7 VARCHAR2(450)
179 , ATTRIBUTE8 VARCHAR2(450)
180 , ATTRIBUTE9 VARCHAR2(450)
181 , ATTRIBUTE10 VARCHAR2(450)
182 , ATTRIBUTE11 VARCHAR2(450)
183 , ATTRIBUTE12 VARCHAR2(450)
184 , ATTRIBUTE13 VARCHAR2(450)
185 , ATTRIBUTE14 VARCHAR2(450)
186 , ATTRIBUTE15 VARCHAR2(450)
187
188
189 , customer_id NUMBER
190 , cp_status_id NUMBER
191 , start_date_active DATE
192 , end_date_active DATE
193 --, misc_order_info OrderInfo_Rec_Type
194 --, misc_return_info ReturnInfo_Rec_Type
195 , quantity NUMBER
196 , uom_code VARCHAR2(25)
197 , net_amount NUMBER
198 , currency_code VARCHAR2(15)
199 , po_number VARCHAR2(50)
200 , delivered_flag VARCHAR2(1)
201 , shipped_flag VARCHAR2(1)
202 , cp_type VARCHAR2(30)
203 , system_id NUMBER
204 , prod_agreement_id NUMBER
205 , ship_to_site_use_id NUMBER
206 , bill_to_site_use_id NUMBER
207 , install_site_use_id NUMBER
208 , installation_date DATE
209 , srv_id NUMBER
210 , srv_sdt DATE
211 , srv_edt DATE
212 , srv_desc VARCHAR2(1995)
213 --, config_type VARCHAR2(30) --not req
214 --, config_start_date DATE --not req
215 --, config_parent_cp_id NUMBER --not req
216 --, project_id NUMBER --not req
217 --, task_id NUMBER --not req
218 --, platform_version_id NUMBER --not req
219 --, customer_view_flag VARCHAR2(1) --not req 'N'
220 --, merchant_view_flag VARCHAR2(1) --not req 'Y'
221 --, desc_flex DFF_Rec_Type -- null
222 --, price_attribs PRICE_ATT_Rec_Type
223 , shipped_date DATE
224 , ship_to_contact_id NUMBER
225 , invoice_to_contact_id NUMBER
226 , expired_flag VARCHAR2(1)
227 , customer_product_status_id NUMBER
228 , split_flag VARCHAR2(1)
229 , returned_quantity NUMBER
230 , LOCATION_TYPE_CODE VARCHAR2(30)
231 , LOCATION_ID NUMBER
232 , INV_ORGANIZATION_ID NUMBER
233 , INV_SUBINVENTORY_NAME VARCHAR2(10)
234 , INV_LOCATOR_ID NUMBER
235 , PA_PROJECT_ID NUMBER
236 , PA_PROJECT_TASK_ID NUMBER
237 , IN_TRANSIT_ORDER_LINE_ID NUMBER
238 , WIP_JOB_ID NUMBER
239 , PO_ORDER_LINE_ID NUMBER
240 --, commitment_id NUMBER --to be added
241 ) ;
242
243 Type Covered_level_Rec_Type Is Record
244 (
245 k_id Number
246 , Attach_2_Line_id Number
247 , line_number Varchar2(150)
248 , product_sts_code Varchar2(30)
249 , Customer_Product_Id Number --either cp id or counter id
250 , Product_Desc Varchar2(440)
251 , Product_Start_Date Date
252 , Product_End_Date Date
253 , Quantity Number
254 , settlement_flag varchar2(450)
255 , average_bill_flag Varchar2(450)
256 , Uom_Code Varchar2(3)
257 , list_price Number
258 , negotiated_amount Number
259 , currency_code Varchar2(15)
260 , reason_code Varchar2(30)
261 , reason_comments Varchar2(1995)
262 , line_renewal_type Varchar2(3) -- 'FUL/KEP/DNR'
263 , minimum_qty VARCHAR2(30)
264 , default_qty VARCHAR2(30)
265 , period Varchar2(30) -- should be the same as usage_period at line level else errors out
266 , amcv_flag VARCHAR2(30)
267 , fixed_qty VARCHAR2(30)
268 , level_yn VARCHAR2(30)
269 , base_reading VARCHAR2(30)
270 , invoice_print_flag Varchar2(1)
271 , ATTRIBUTE1 VARCHAR2(450)
272 , ATTRIBUTE2 VARCHAR2(450)
273 , ATTRIBUTE3 VARCHAR2(450)
274 , ATTRIBUTE4 VARCHAR2(450)
275 , ATTRIBUTE5 VARCHAR2(450)
276 , ATTRIBUTE6 VARCHAR2(450)
277 , ATTRIBUTE7 VARCHAR2(450)
278 , ATTRIBUTE8 VARCHAR2(450)
279 , ATTRIBUTE9 VARCHAR2(450)
280 , ATTRIBUTE10 VARCHAR2(450)
281 , ATTRIBUTE11 VARCHAR2(450)
282 , ATTRIBUTE12 VARCHAR2(450)
283 , ATTRIBUTE13 VARCHAR2(450)
284 , ATTRIBUTE14 VARCHAR2(450)
285 , ATTRIBUTE15 VARCHAR2(450)
286 );
287
288 Type Suspend_rec Is Record
289 (
290 Customer_id Number
291 ,Subscription_id Number
292 );
293
294 TYPE obj_articles_rec IS RECORD
295 (
296 name VARCHAR2(150)
297 ,subject_code VARCHAR2(150)
298 ,full_text_yn VARCHAR2(3)
299 );
300
301 Type obj_articles_tbl is TABLE of obj_articles_rec index by binary_integer;
302
303
304 TYPE Pricing_Attributes_Type Is Record
305 (
309 pricing_attribute3 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
306 pricing_context OKC_PRICE_ATT_VALUES.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
307 pricing_attribute1 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
308 pricing_attribute2 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
310 pricing_attribute4 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
311 pricing_attribute5 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
312 pricing_attribute6 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
313 pricing_attribute7 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
314 pricing_attribute8 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
315 pricing_attribute9 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
316 pricing_attribute10 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
317 pricing_attribute11 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
318 pricing_attribute12 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
319 pricing_attribute13 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
320 pricing_attribute14 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
321 pricing_attribute15 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
322 pricing_attribute16 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE16%TYPE := OKC_API.G_MISS_CHAR,
323 pricing_attribute17 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE17%TYPE := OKC_API.G_MISS_CHAR,
324 pricing_attribute18 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE18%TYPE := OKC_API.G_MISS_CHAR,
325 pricing_attribute19 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE19%TYPE := OKC_API.G_MISS_CHAR,
326 pricing_attribute20 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE20%TYPE := OKC_API.G_MISS_CHAR,
327 pricing_attribute21 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE21%TYPE := OKC_API.G_MISS_CHAR,
328 pricing_attribute22 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE22%TYPE := OKC_API.G_MISS_CHAR,
329 pricing_attribute23 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE23%TYPE := OKC_API.G_MISS_CHAR,
330 pricing_attribute24 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE24%TYPE := OKC_API.G_MISS_CHAR,
331 pricing_attribute25 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE25%TYPE := OKC_API.G_MISS_CHAR,
332 pricing_attribute26 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE26%TYPE := OKC_API.G_MISS_CHAR,
333 pricing_attribute27 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE27%TYPE := OKC_API.G_MISS_CHAR,
334 pricing_attribute28 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE28%TYPE := OKC_API.G_MISS_CHAR,
335 pricing_attribute29 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE29%TYPE := OKC_API.G_MISS_CHAR,
336 pricing_attribute30 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE30%TYPE := OKC_API.G_MISS_CHAR,
337 pricing_attribute31 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE31%TYPE := OKC_API.G_MISS_CHAR,
338 pricing_attribute32 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE32%TYPE := OKC_API.G_MISS_CHAR,
339 pricing_attribute33 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE33%TYPE := OKC_API.G_MISS_CHAR,
340 pricing_attribute34 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE34%TYPE := OKC_API.G_MISS_CHAR,
341 pricing_attribute35 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE35%TYPE := OKC_API.G_MISS_CHAR,
342 pricing_attribute36 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE36%TYPE := OKC_API.G_MISS_CHAR,
343 pricing_attribute37 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE37%TYPE := OKC_API.G_MISS_CHAR,
344 pricing_attribute38 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE38%TYPE := OKC_API.G_MISS_CHAR,
345 pricing_attribute39 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE39%TYPE := OKC_API.G_MISS_CHAR,
346 pricing_attribute40 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE40%TYPE := OKC_API.G_MISS_CHAR,
347 pricing_attribute41 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE41%TYPE := OKC_API.G_MISS_CHAR,
348 pricing_attribute42 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE42%TYPE := OKC_API.G_MISS_CHAR,
349 pricing_attribute43 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE43%TYPE := OKC_API.G_MISS_CHAR,
350 pricing_attribute44 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE44%TYPE := OKC_API.G_MISS_CHAR,
351 pricing_attribute45 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE45%TYPE := OKC_API.G_MISS_CHAR,
352 pricing_attribute46 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE46%TYPE := OKC_API.G_MISS_CHAR,
353 pricing_attribute47 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE47%TYPE := OKC_API.G_MISS_CHAR,
354 pricing_attribute48 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE48%TYPE := OKC_API.G_MISS_CHAR,
355 pricing_attribute49 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE49%TYPE := OKC_API.G_MISS_CHAR,
356 pricing_attribute50 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE50%TYPE := OKC_API.G_MISS_CHAR,
357 pricing_attribute51 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE51%TYPE := OKC_API.G_MISS_CHAR,
358 pricing_attribute52 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE52%TYPE := OKC_API.G_MISS_CHAR,
359 pricing_attribute53 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE53%TYPE := OKC_API.G_MISS_CHAR,
360 pricing_attribute54 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE54%TYPE := OKC_API.G_MISS_CHAR,
361 pricing_attribute55 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE55%TYPE := OKC_API.G_MISS_CHAR,
362 pricing_attribute56 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE56%TYPE := OKC_API.G_MISS_CHAR,
363 pricing_attribute57 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE57%TYPE := OKC_API.G_MISS_CHAR,
364 pricing_attribute58 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE58%TYPE := OKC_API.G_MISS_CHAR,
365 pricing_attribute59 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE59%TYPE := OKC_API.G_MISS_CHAR,
369 pricing_attribute63 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE63%TYPE := OKC_API.G_MISS_CHAR,
366 pricing_attribute60 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE60%TYPE := OKC_API.G_MISS_CHAR,
367 pricing_attribute61 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE61%TYPE := OKC_API.G_MISS_CHAR,
368 pricing_attribute62 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE62%TYPE := OKC_API.G_MISS_CHAR,
370 pricing_attribute64 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE64%TYPE := OKC_API.G_MISS_CHAR,
371 pricing_attribute65 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE65%TYPE := OKC_API.G_MISS_CHAR,
372 pricing_attribute66 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE66%TYPE := OKC_API.G_MISS_CHAR,
373 pricing_attribute67 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE67%TYPE := OKC_API.G_MISS_CHAR,
374 pricing_attribute68 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE68%TYPE := OKC_API.G_MISS_CHAR,
375 pricing_attribute69 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE69%TYPE := OKC_API.G_MISS_CHAR,
376 pricing_attribute70 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE70%TYPE := OKC_API.G_MISS_CHAR,
377 pricing_attribute71 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE71%TYPE := OKC_API.G_MISS_CHAR,
378 pricing_attribute72 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE72%TYPE := OKC_API.G_MISS_CHAR,
379 pricing_attribute73 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE73%TYPE := OKC_API.G_MISS_CHAR,
380 pricing_attribute74 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE74%TYPE := OKC_API.G_MISS_CHAR,
381 pricing_attribute75 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE75%TYPE := OKC_API.G_MISS_CHAR,
382 pricing_attribute76 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE76%TYPE := OKC_API.G_MISS_CHAR,
383 pricing_attribute77 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE77%TYPE := OKC_API.G_MISS_CHAR,
384 pricing_attribute78 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE78%TYPE := OKC_API.G_MISS_CHAR,
385 pricing_attribute79 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE79%TYPE := OKC_API.G_MISS_CHAR,
386 pricing_attribute80 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE80%TYPE := OKC_API.G_MISS_CHAR,
387 pricing_attribute81 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE81%TYPE := OKC_API.G_MISS_CHAR,
388 pricing_attribute82 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE82%TYPE := OKC_API.G_MISS_CHAR,
389 pricing_attribute83 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE83%TYPE := OKC_API.G_MISS_CHAR,
390 pricing_attribute84 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE84%TYPE := OKC_API.G_MISS_CHAR,
391 pricing_attribute85 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE85%TYPE := OKC_API.G_MISS_CHAR,
392 pricing_attribute86 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE86%TYPE := OKC_API.G_MISS_CHAR,
393 pricing_attribute87 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE87%TYPE := OKC_API.G_MISS_CHAR,
394 pricing_attribute88 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE88%TYPE := OKC_API.G_MISS_CHAR,
395 pricing_attribute89 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE89%TYPE := OKC_API.G_MISS_CHAR,
396 pricing_attribute90 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE90%TYPE := OKC_API.G_MISS_CHAR,
397 pricing_attribute91 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE91%TYPE := OKC_API.G_MISS_CHAR,
398 pricing_attribute92 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE92%TYPE := OKC_API.G_MISS_CHAR,
399 pricing_attribute93 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE93%TYPE := OKC_API.G_MISS_CHAR,
400 pricing_attribute94 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE94%TYPE := OKC_API.G_MISS_CHAR,
401 pricing_attribute95 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE95%TYPE := OKC_API.G_MISS_CHAR,
402 pricing_attribute96 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE96%TYPE := OKC_API.G_MISS_CHAR,
403 pricing_attribute97 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE97%TYPE := OKC_API.G_MISS_CHAR,
404 pricing_attribute98 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE98%TYPE := OKC_API.G_MISS_CHAR,
405 pricing_attribute99 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE99%TYPE := OKC_API.G_MISS_CHAR,
406 pricing_attribute100 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE100%TYPE := OKC_API.G_MISS_CHAR
407 );
408
409
410 Procedure create_contract
411 (
412 p_K_header_rec IN OKS_CONTRACTS_PUB.header_rec_type
413 , p_header_contacts_tbl IN OKS_CONTRACTS_PUB.contact_tbl
414 , p_header_sales_crd_tbl IN OKS_CONTRACTS_PUB.SalesCredit_tbl
415 , p_header_articles_tbl IN OKS_CONTRACTS_PUB.obj_articles_tbl
416 , p_K_line_rec IN OKS_CONTRACTS_PUB.line_rec_type
417 , p_line_contacts_tbl IN OKS_CONTRACTS_PUB.contact_tbl
418 , p_line_sales_crd_tbl IN OKS_CONTRACTS_PUB.SalesCredit_tbl
419 , p_K_Support_rec IN OKS_CONTRACTS_PUB.line_rec_type
420 , p_Support_contacts_tbl IN OKS_CONTRACTS_PUB.contact_tbl
421 , p_Support_sales_crd_tbl IN OKS_CONTRACTS_PUB.SalesCredit_tbl
422 --, p_line_articles_tbl IN OKS_CONTRACTS_PUB.line_articles_tbl
423 , p_K_covd_rec IN OKS_CONTRACTS_PUB.Covered_level_Rec_Type
424 , p_price_attribs_in IN OKS_CONTRACTS_PUB.pricing_attributes_type
425 , p_merge_rule IN Varchar2
426 , p_usage_instantiate IN Varchar2
427 , p_ib_creation IN Varchar2
428 , p_billing_sch_type IN Varchar2
429 , p_strm_level_tbl IN OKS_BILL_SCH.StreamLvl_tbl
430 , x_chrid OUT NOCOPY Number
431 , x_return_status OUT NOCOPY Varchar2
432 , x_msg_count OUT NOCOPY Number
433 , x_msg_data OUT NOCOPY Varchar2
434 );
435
436
437
438 /*Procedure Update_contract
439 (
440 p_K_header_rec IN OKS_CONTRACTS_PUB.header_rec_type
441 , p_header_contacts_tbl IN OKS_CONTRACTS_PUB.contact_tbl
442 , p_header_sales_crd_tbl IN OKS_CONTRACTS_PUB.SalesCredit_tbl
443 --, p_header_articles_tbl IN OKS_CONTRACTS_PUB.obj_articles_tbl
444 , p_K_line_rec IN OKS_CONTRACTS_PUB.line_rec_type
445 , p_line_contacts_tbl IN OKS_CONTRACTS_PUB.contact_tbl
446 , p_line_sales_crd_tbl IN OKS_CONTRACTS_PUB.SalesCredit_tbl
447 --, p_line_articles_tbl IN OKS_CONTRACTS_PUB.line_articles_tbl
448 , p_K_covd_rec IN OKS_CONTRACTS_PUB.Covered_level_Rec_Type
449 , x_chrid OUT Number
450 , x_return_status OUT Varchar2
451 , x_msg_count OUT Number
452 , x_msg_data OUT Varchar2
453 );
454
455
456
457 Procedure suspend_subscription
458 ( p_api_version IN NUMBER,
459 p_init_msg_list IN VARCHAR2 ,
460 x_return_status OUT NOCOPY VARCHAR2,
461 x_msg_count OUT NOCOPY NUMBER,
462 x_msg_data OUT NOCOPY VARCHAR2,
463 p_suspend_rec IN OKS_CONTRACTS_PUB.suspend_rec,
464 p_do_commit IN VARCHAR2
465 );
466
467
468 Procedure reactivate_subscription
469 ( p_api_version IN NUMBER,
470 p_init_msg_list IN VARCHAR2 ,
471 x_return_status OUT NOCOPY VARCHAR2,
472 x_msg_count OUT NOCOPY NUMBER,
473 x_msg_data OUT NOCOPY VARCHAR2,
474 p_reactivate_rec IN OKS_CONTRACTS_PUB.suspend_rec,
475 p_do_commit IN VARCHAR2
476 );*/
477
478 Procedure Create_Covered_Line(
479 p_k_covd_rec IN Covered_level_Rec_Type
480 , p_PRICE_ATTRIBS IN Pricing_attributes_Type
481 , x_cp_line_id OUT NOCOPY NUMBER
482 , x_return_status OUT NOCOPY Varchar2
483 , x_msg_count OUT NOCOPY Number
484 , x_msg_data OUT NOCOPY Varchar2
485 );
486
487 Procedure Create_Service_Line
488 (
489 p_k_line_rec IN line_Rec_Type
490 ,p_Contact_tbl IN Contact_Tbl
491 ,p_line_sales_crd_tbl IN SalesCredit_Tbl
492 ,x_service_line_id OUT NOCOPY Number
493 ,x_return_status OUT NOCOPY Varchar2
494 ,x_msg_count OUT NOCOPY Number
495 ,x_msg_data OUT NOCOPY Varchar2
496 );
497
498 Procedure Create_Contract_Header
499 (
500 p_K_header_rec IN OKS_CONTRACTS_PUB.header_rec_type
501 , p_header_contacts_tbl IN OKS_CONTRACTS_PUB.contact_tbl
502 , p_header_sales_crd_tbl IN OKS_CONTRACTS_PUB.SalesCredit_tbl
503 , p_header_articles_tbl IN OKS_CONTRACTS_PUB.obj_articles_tbl
504 , x_chrid OUT NOCOPY Number
505 , x_return_status OUT NOCOPY VARCHAR2
506 , x_msg_count OUT NOCOPY Number
507 , x_msg_data OUT NOCOPY VARCHAR2
508 );
509
510 /*************NOTE: MAPPING FOR THE FIELDS FOR BLIILING SCHEDULE
511
512 ---mapping for SLH
513 common name filed name
514 line id Cle_Id --required
515 stream_type_id1 Object1_Id1
516 stream_type_id2 Object1_Id2
517 stream_tp_code Jtot_Object1_Code
518 slh_timeval_id1 Object2_Id1
519 slh_timeval_id2 Object2_Id2
520 slh_timeval_code Jtot_Object2_Code
521 Bill_type Rule_Information1 --required
522 Rule_Information_Category ('SLH') --REQUIRED
523
524 ----FOR SLL RULE TABLE
525 Mapping of fields for SLL rules
526
527
528 seq_no - RULE_INFORMATION1 --required
529 Date start - RULE_INFORMATION2
530 level_period - RULE_INFORMATION3 --required
531 tuom_per_period - RULE_INFORMATION4 --required
532 tuomcode - OBJECT1_ID1 --required
533 amount - RULE_INFORMATION6 -- for Bill_type = 'T' NOT required for 'E' & 'P' required.
534 action_offset_days - RULE_INFORMATION7
535 interface_offset_days - RULE_INFORMATION8
536 comments - RULE_INFORMATION9
537 due arr yn - RULE_INFORMATION10
538 amount actual yn - RULE_INFORMATION11
539 Lines detailed yn - RULE_INFORMATION12
540
541 ---
542 p_invoice_rule_id --- whatever is given for header record
543 *******************************************/
544
545 Procedure Create_Bill_Schedule(p_billing_sch IN Varchar2,
546 p_strm_level_tbl IN OKS_BILL_SCH.StreamLvl_tbl,
547 p_invoice_rule_id IN Number,
548 x_return_status OUT NOCOPY VARCHAR2
549 );
550
551 /*dummy procedure created for OKL */
552 Procedure Create_Bill_Schedule(p_Strm_hdr_rec IN OKS_BILL_SCH.StreamHdr_Type,
553 p_strm_level_tbl IN OKS_BILL_SCH.StreamLvl_tbl,
554 p_invoice_rule_id IN Number,
555 x_return_status OUT NOCOPY VARCHAR2
556 );
557
558 END OKS_CONTRACTS_PUB;
559