[Home] [Help]
PACKAGE: APPS.OKS_EXTWARPRGM_OSO_PVT
Source
1 Package OKS_EXTWARPRGM_OSO_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSRXRXS.pls 120.1 2005/08/10 03:32:25 hkamdar noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
8 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
9 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
12 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
15 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
16
17 ------------------------------------------------------------------------------------
18 -- GLOBAL EXCEPTION
19 ---------------------------------------------------------------------------
20 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
21
22 -- GLOBAL VARIABLES
23 ---------------------------------------------------------------------------
24 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKSOMINT';
25 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
26
27 G_JTF_ORDER_HDR CONSTANT VARCHAR2(200) := 'OKX_ORDERHEAD';
28 G_JTF_ORDER_LN CONSTANT VARCHAR2(200) := 'OKX_ORDERLINE';
29
30 G_INVOICE_CONTACT CONSTANT VARCHAR2(200) := 'BILLING';
31 G_RULE_GROUP_CODE CONSTANT VARCHAR2(200) := 'SVC_K';
32
33 G_JTF_EXTWARR CONSTANT VARCHAR2(200) := 'OKX_SERVICE';
34 G_JTF_WARR CONSTANT VARCHAR2(200) := 'OKX_WARRANTY';
35 G_JTF_PARTY CONSTANT VARCHAR2(200) := 'OKX_PARTY';
36 G_JTF_PARTY_VENDOR CONSTANT VARCHAR2(200) := 'OKX_OPERUNIT';
37 G_JTF_INVOICE_CONTACT CONSTANT VARCHAR2(200) := 'OKX_PCONTACT';
38 G_JTF_BILLTO CONSTANT VARCHAR2(200) := 'OKX_BILLTO';
39 G_JTF_COUNTER CONSTANT VARCHAR2(200) := 'OKX_COUNTER';
40 G_JTF_USAGE CONSTANT VARCHAR2(200) := 'OKX_USAGE';
41 G_JTF_SHIPTO CONSTANT VARCHAR2(200) := 'OKX_SHIPTO';
42 G_JTF_ARL CONSTANT VARCHAR2(200) := 'OKX_ACCTRULE';
43 G_JTF_IRE CONSTANT VARCHAR2(200) := 'OKX_INVRULE';
44 G_JTF_CUSTPROD CONSTANT VARCHAR2(200) := 'OKX_CUSTPROD';
45 G_JTF_CUSTACCT CONSTANT VARCHAR2(200) := 'OKX_CUSTACCT';
46 G_JTF_PRICE CONSTANT VARCHAR2(200) := 'OKX_PRICE';
47 G_JTF_PAYMENT_TERM CONSTANT VARCHAR2(200) := 'OKX_PPAYTERM';
48 G_JTF_CONV_TYPE CONSTANT VARCHAR2(200) := 'OKX_CONVTYPE';
49 G_JTF_TAXEXEMP CONSTANT VARCHAR2(200) := 'OKX_TAXEXEMP';
50 G_JTF_TAXCTRL CONSTANT VARCHAR2(200) := 'OKX_TAXCTRL';
51
52
53 ---------------------------------------------------------------------------
54
55 TYPE Pricing_Attributes_Type Is Record
56 (
57 pricing_context OKC_PRICE_ATT_VALUES.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
58 pricing_attribute1 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59 pricing_attribute2 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60 pricing_attribute3 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61 pricing_attribute4 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62 pricing_attribute5 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63 pricing_attribute6 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64 pricing_attribute7 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65 pricing_attribute8 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66 pricing_attribute9 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67 pricing_attribute10 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68 pricing_attribute11 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69 pricing_attribute12 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70 pricing_attribute13 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71 pricing_attribute14 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72 pricing_attribute15 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73 pricing_attribute16 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE16%TYPE := OKC_API.G_MISS_CHAR,
74 pricing_attribute17 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE17%TYPE := OKC_API.G_MISS_CHAR,
75 pricing_attribute18 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE18%TYPE := OKC_API.G_MISS_CHAR,
76 pricing_attribute19 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE19%TYPE := OKC_API.G_MISS_CHAR,
77 pricing_attribute20 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE20%TYPE := OKC_API.G_MISS_CHAR,
78 pricing_attribute21 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE21%TYPE := OKC_API.G_MISS_CHAR,
79 pricing_attribute22 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE22%TYPE := OKC_API.G_MISS_CHAR,
80 pricing_attribute23 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE23%TYPE := OKC_API.G_MISS_CHAR,
81 pricing_attribute24 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE24%TYPE := OKC_API.G_MISS_CHAR,
82 pricing_attribute25 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE25%TYPE := OKC_API.G_MISS_CHAR,
83 pricing_attribute26 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE26%TYPE := OKC_API.G_MISS_CHAR,
84 pricing_attribute27 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE27%TYPE := OKC_API.G_MISS_CHAR,
85 pricing_attribute28 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE28%TYPE := OKC_API.G_MISS_CHAR,
86 pricing_attribute29 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE29%TYPE := OKC_API.G_MISS_CHAR,
87 pricing_attribute30 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE30%TYPE := OKC_API.G_MISS_CHAR,
88 pricing_attribute31 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE31%TYPE := OKC_API.G_MISS_CHAR,
89 pricing_attribute32 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE32%TYPE := OKC_API.G_MISS_CHAR,
90 pricing_attribute33 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE33%TYPE := OKC_API.G_MISS_CHAR,
91 pricing_attribute34 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE34%TYPE := OKC_API.G_MISS_CHAR,
92 pricing_attribute35 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE35%TYPE := OKC_API.G_MISS_CHAR,
93 pricing_attribute36 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE36%TYPE := OKC_API.G_MISS_CHAR,
94 pricing_attribute37 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE37%TYPE := OKC_API.G_MISS_CHAR,
95 pricing_attribute38 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE38%TYPE := OKC_API.G_MISS_CHAR,
96 pricing_attribute39 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE39%TYPE := OKC_API.G_MISS_CHAR,
97 pricing_attribute40 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE40%TYPE := OKC_API.G_MISS_CHAR,
98 pricing_attribute41 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE41%TYPE := OKC_API.G_MISS_CHAR,
99 pricing_attribute42 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE42%TYPE := OKC_API.G_MISS_CHAR,
100 pricing_attribute43 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE43%TYPE := OKC_API.G_MISS_CHAR,
101 pricing_attribute44 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE44%TYPE := OKC_API.G_MISS_CHAR,
102 pricing_attribute45 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE45%TYPE := OKC_API.G_MISS_CHAR,
103 pricing_attribute46 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE46%TYPE := OKC_API.G_MISS_CHAR,
104 pricing_attribute47 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE47%TYPE := OKC_API.G_MISS_CHAR,
105 pricing_attribute48 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE48%TYPE := OKC_API.G_MISS_CHAR,
106 pricing_attribute49 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE49%TYPE := OKC_API.G_MISS_CHAR,
107 pricing_attribute50 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE50%TYPE := OKC_API.G_MISS_CHAR,
108 pricing_attribute51 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE51%TYPE := OKC_API.G_MISS_CHAR,
109 pricing_attribute52 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE52%TYPE := OKC_API.G_MISS_CHAR,
110 pricing_attribute53 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE53%TYPE := OKC_API.G_MISS_CHAR,
111 pricing_attribute54 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE54%TYPE := OKC_API.G_MISS_CHAR,
112 pricing_attribute55 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE55%TYPE := OKC_API.G_MISS_CHAR,
113 pricing_attribute56 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE56%TYPE := OKC_API.G_MISS_CHAR,
114 pricing_attribute57 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE57%TYPE := OKC_API.G_MISS_CHAR,
115 pricing_attribute58 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE58%TYPE := OKC_API.G_MISS_CHAR,
116 pricing_attribute59 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE59%TYPE := OKC_API.G_MISS_CHAR,
117 pricing_attribute60 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE60%TYPE := OKC_API.G_MISS_CHAR,
118 pricing_attribute61 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE61%TYPE := OKC_API.G_MISS_CHAR,
119 pricing_attribute62 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE62%TYPE := OKC_API.G_MISS_CHAR,
120 pricing_attribute63 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE63%TYPE := OKC_API.G_MISS_CHAR,
121 pricing_attribute64 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE64%TYPE := OKC_API.G_MISS_CHAR,
122 pricing_attribute65 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE65%TYPE := OKC_API.G_MISS_CHAR,
123 pricing_attribute66 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE66%TYPE := OKC_API.G_MISS_CHAR,
124 pricing_attribute67 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE67%TYPE := OKC_API.G_MISS_CHAR,
125 pricing_attribute68 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE68%TYPE := OKC_API.G_MISS_CHAR,
126 pricing_attribute69 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE69%TYPE := OKC_API.G_MISS_CHAR,
127 pricing_attribute70 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE70%TYPE := OKC_API.G_MISS_CHAR,
128 pricing_attribute71 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE71%TYPE := OKC_API.G_MISS_CHAR,
129 pricing_attribute72 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE72%TYPE := OKC_API.G_MISS_CHAR,
130 pricing_attribute73 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE73%TYPE := OKC_API.G_MISS_CHAR,
131 pricing_attribute74 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE74%TYPE := OKC_API.G_MISS_CHAR,
132 pricing_attribute75 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE75%TYPE := OKC_API.G_MISS_CHAR,
133 pricing_attribute76 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE76%TYPE := OKC_API.G_MISS_CHAR,
134 pricing_attribute77 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE77%TYPE := OKC_API.G_MISS_CHAR,
135 pricing_attribute78 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE78%TYPE := OKC_API.G_MISS_CHAR,
136 pricing_attribute79 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE79%TYPE := OKC_API.G_MISS_CHAR,
137 pricing_attribute80 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE80%TYPE := OKC_API.G_MISS_CHAR,
138 pricing_attribute81 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE81%TYPE := OKC_API.G_MISS_CHAR,
139 pricing_attribute82 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE82%TYPE := OKC_API.G_MISS_CHAR,
140 pricing_attribute83 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE83%TYPE := OKC_API.G_MISS_CHAR,
141 pricing_attribute84 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE84%TYPE := OKC_API.G_MISS_CHAR,
142 pricing_attribute85 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE85%TYPE := OKC_API.G_MISS_CHAR,
143 pricing_attribute86 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE86%TYPE := OKC_API.G_MISS_CHAR,
144 pricing_attribute87 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE87%TYPE := OKC_API.G_MISS_CHAR,
145 pricing_attribute88 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE88%TYPE := OKC_API.G_MISS_CHAR,
146 pricing_attribute89 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE89%TYPE := OKC_API.G_MISS_CHAR,
147 pricing_attribute90 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE90%TYPE := OKC_API.G_MISS_CHAR,
148 pricing_attribute91 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE91%TYPE := OKC_API.G_MISS_CHAR,
149 pricing_attribute92 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE92%TYPE := OKC_API.G_MISS_CHAR,
150 pricing_attribute93 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE93%TYPE := OKC_API.G_MISS_CHAR,
151 pricing_attribute94 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE94%TYPE := OKC_API.G_MISS_CHAR,
152 pricing_attribute95 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE95%TYPE := OKC_API.G_MISS_CHAR,
156 pricing_attribute99 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE99%TYPE := OKC_API.G_MISS_CHAR,
153 pricing_attribute96 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE96%TYPE := OKC_API.G_MISS_CHAR,
154 pricing_attribute97 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE97%TYPE := OKC_API.G_MISS_CHAR,
155 pricing_attribute98 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE98%TYPE := OKC_API.G_MISS_CHAR,
157 pricing_attribute100 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE100%TYPE := OKC_API.G_MISS_CHAR
158 );
159
160 TYPE PartyRole_Type Is Record
161 (
162 party_role Varchar2 (30)
163 , object1_id1 Number
164 , object1_code Varchar2 (30)
165 );
166
167 Type PartyRole_tbl is TABLE of PartyRole_type index by binary_integer;
168
169 TYPE Contact_Type Is Record
170 (
171 party_role Varchar2(30)
172 , contact_role Varchar2(30)
173 , contact_object_code Varchar2(30)
174 , contact_id Number
175 );
176
177 Type Contact_tbl is TABLE of Contact_type index by binary_integer;
178
182 ctc_id Number
179
180 TYPE SalesCredit_Type Is Record
181 (
183 , sales_credit_type_id Number
184 , percent Number
185 );
186
187 Type SalesCredit_tbl is TABLE of SalesCredit_type index by binary_integer;
188
189
190 TYPE K_Header_Rec_Type Is Record
191 (
192 contract_number Varchar2(120)
193 , start_date Date
194 , end_date Date
195 , sts_code Varchar2(30)
196 , class_code Varchar2(30)
197 , authoring_org_id Number
198 , short_description Varchar2(1995)
199 , chr_group Number
200 , pdf_id Number
201 , party_id Number
202 , bill_to_id Number
203 , ship_to_id Number
204 , price_list_id Number
205 , cust_po_number Varchar2(240)
206 , agreement_id Number
207 , currency Varchar2(15)
208 , accounting_rule_id Number
209 , invoice_rule_id Number
210 , order_hdr_id Number
211 , payment_term_id Number
212 , cvn_type Varchar2(25)
213 , cvn_rate Number
214 , cvn_date Date
215 , cvn_euro_rate Number
216 , tax_exemption_id Number
217 , tax_status_flag Varchar2(30)
218 , third_party_role Varchar2(30)
219 , merge_type Varchar2(10)
220 , merge_object_id Number
221 , renewal_type Varchar2(3) --'NSR/SFA/DNR/EVN'
222 , renewal_pricing_type Varchar2(3) --'LST/PCT/MAN'
223 , renewal_price_list_id Number
224 , renewal_markup Number
225 , renewal_po Varchar2(1) --'Y/N'
226 , first_billon_date DATE
227 , first_billupto_date DATE
228 , Billing_freq VARCHAR2(30)
229 , offset_Duration Varchar2(30)
230 , ATTRIBUTE1 VARCHAR2(450)
231 , ATTRIBUTE2 VARCHAR2(450)
232 , ATTRIBUTE3 VARCHAR2(450)
233 , ATTRIBUTE4 VARCHAR2(450)
234 , ATTRIBUTE5 VARCHAR2(450)
235 , ATTRIBUTE6 VARCHAR2(450)
236 , ATTRIBUTE7 VARCHAR2(450)
237 , ATTRIBUTE8 VARCHAR2(450)
238 , ATTRIBUTE9 VARCHAR2(450)
239 , ATTRIBUTE10 VARCHAR2(450)
240 , ATTRIBUTE11 VARCHAR2(450)
241 , ATTRIBUTE12 VARCHAR2(450)
242 , ATTRIBUTE13 VARCHAR2(450)
243 , ATTRIBUTE14 VARCHAR2(450)
244 , ATTRIBUTE15 VARCHAR2(450)
245 );
246
247
248 Type K_line_Service_Rec_Type Is Record
249 (
250 k_id Number
251 , k_line_number Varchar2(150)
252 , line_sts_code Varchar2(30)
253 , cust_account Number
254 , org_id Number
255 ,organization_id Number
256 , srv_id Number
257 , object_name Varchar2(30)
258 , srv_segment1 Varchar2(440)
259 , srv_desc Varchar2(440)
260 , srv_sdt Date
261 , srv_edt Date
262 , bill_to_id Number
263 , ship_to_id Number
264 , order_line_id Number
265 , accounting_rule_id Number
266 , warranty_flag Char
267 , Coverage_template_id Number
268 , currency Varchar2(15)
269 , reason_code Varchar2(30)
270 , reason_comments Varchar2(1995)
271 , line_renewal_type Varchar2(3) -- 'FUL/KEP/DNR'
272 , l_usage_type VARCHAR2(30)
273 , first_billon_date DATE
274 , first_billupto_date DATE
275 , Billing_freq VARCHAR2(30)
276 , offset_Duration Varchar2(30)
277 , period Varchar2(30)
278 ,amcv_flag Varchar2(1)
282 , ATTRIBUTE1 VARCHAR2(450)
279 ,level_yn Varchar2(1)
280
281 , INvoicing_rule_id NUMBER
283 , ATTRIBUTE2 VARCHAR2(450)
284 , ATTRIBUTE3 VARCHAR2(450)
285 , ATTRIBUTE4 VARCHAR2(450)
286 , ATTRIBUTE5 VARCHAR2(450)
287 , ATTRIBUTE6 VARCHAR2(450)
288 , ATTRIBUTE7 VARCHAR2(450)
289 , ATTRIBUTE8 VARCHAR2(450)
290 , ATTRIBUTE9 VARCHAR2(450)
291 , ATTRIBUTE10 VARCHAR2(450)
292 , ATTRIBUTE11 VARCHAR2(450)
293 , ATTRIBUTE12 VARCHAR2(450)
294 , ATTRIBUTE13 VARCHAR2(450)
295 , ATTRIBUTE14 VARCHAR2(450)
296 , ATTRIBUTE15 VARCHAR2(450)
297 );
298
299 Type K_Line_Covered_level_Rec_Type Is Record
300 (
301 k_id Number
302 , Attach_2_Line_id Number
303 , line_number Varchar2(150)
304 , product_sts_code Varchar2(30)
305 , Customer_Product_Id Number
306 , Product_Item_Id Number
307 , Product_Segment1 Varchar2(440)
308 , Product_Desc Varchar2(440)
309 , Product_Start_Date Date
310 , Product_End_Date Date
311 , Quantity Number
312 , Uom_Code Varchar2(3)
313 , list_price Number
314 , negotiated_amount Number
315 , currency_code Varchar2(15)
316 , warranty_flag Char
317 , reason_code Varchar2(30)
318 , reason_comments Varchar2(1995)
319 , srv_id Number
320 , line_renewal_type Varchar2(3) -- 'FUL/KEP/DNR'
321 , ATTRIBUTE1 VARCHAR2(450)
322 , ATTRIBUTE2 VARCHAR2(450)
323 , ATTRIBUTE3 VARCHAR2(450)
324 , ATTRIBUTE4 VARCHAR2(450)
325 , ATTRIBUTE5 VARCHAR2(450)
326 , ATTRIBUTE6 VARCHAR2(450)
327 , ATTRIBUTE7 VARCHAR2(450)
328 , ATTRIBUTE8 VARCHAR2(450)
329 , ATTRIBUTE9 VARCHAR2(450)
330 , ATTRIBUTE10 VARCHAR2(450)
331 , ATTRIBUTE11 VARCHAR2(450)
332 , ATTRIBUTE12 VARCHAR2(450)
333 , ATTRIBUTE13 VARCHAR2(450)
334 , ATTRIBUTE14 VARCHAR2(450)
335 , ATTRIBUTE15 VARCHAR2(450)
336 , period VARCHAR2(30)
337 , minimum_qty VARCHAR2(30)
338 , default_qty VARCHAR2(30)
339 , amcv_flag VARCHAR2(30)
340 , fixed_qty VARCHAR2(30)
341 , duration VARCHAR2(30)
342 , level_yn VARCHAR2(30)
343 , base_reading VARCHAR2(30)
344 ,org_id NUMBER
345 );
346
347
348 Type ExtWar_Rec_Type Is Record
349 (
350 warranty_flag Char
351 , merge_type Varchar2(10)
352 , merge_object_id Number
353 , hdr_sdt Date
354 , hdr_edt Date
358 , hdr_bill_2_id Number
355 , hdr_org_id Number
356 , hdr_party_id Number
357 , hdr_third_party_role Varchar2(30)
359 , hdr_ship_2_id Number
360 , hdr_price_list_id Number
361 , hdr_cust_po_number Varchar2(240)
362 , hdr_agreement_id Number
363 , hdr_currency Varchar2(15)
364 , hdr_acct_rule_id Number
365 , hdr_inv_rule_id Number
366 , hdr_order_hdr_id Number
367 , hdr_status Varchar2(30)
368 , hdr_payment_term_id Number
369 , hdr_cvn_type Varchar2(25)
370 , hdr_cvn_rate Number
371 , hdr_cvn_date Date
372 , hdr_cvn_euro_rate Number
373 , hdr_chr_group Number
374 , hdr_pdf_id Number
375 , hdr_tax_exemption_id Number
376 , hdr_tax_status_flag Varchar2(30)
377 , hdr_renewal_type Varchar2(3)
378 , hdr_renewal_pricing_type Varchar2(3)
382 , cust_account Number
379 , hdr_renewal_price_list_id Number
380 , hdr_renewal_markup Number
381 , hdr_renewal_po Varchar2(1)
383 , srv_id Number
384 , srv_name Varchar2(440)
385 , srv_desc Varchar2(440)
386 , srv_sdt Date
387 , srv_edt Date
388 , srv_bill_2_id Number
389 , srv_ship_2_id Number
390 , srv_order_line_id Number
391 , srv_amount Number
392 , srv_unit_price Number
393 , srv_price_percent Number
394 , srv_currency Varchar2(15)
395 , srv_Cov_template_id Number
396 , lvl_cp_id Number
397 , lvl_inventory_id Number
398 , lvl_inventory_name Varchar2(440)
399 , lvl_inventory_desc Varchar2(440)
400 , lvl_Quantity Number
401 , lvl_uom_code Varchar2(3)
402 , lvl_order_line_id Number
403 , lvl_sts_code Varchar2(40)
404 , lvl_line_renewal_type Varchar2(3)
405 , l_usage_type VARCHAR2(30)
406 , period VARCHAR2(30)
407 , minimum_qty VARCHAR2(30)
408 , default_qty VARCHAR2(30)
409 , amcv_flag VARCHAR2(30)
410 , fixed_qty VARCHAR2(30)
411 , duration VARCHAR2(30)
412 , level_yn VARCHAR2(30)
413 , base_reading VARCHAR2(30)
414 , first_billon_date DATE
415 , first_billupto_date DATE
416 , Billing_freq VARCHAR2(30)
417 , offset_Duration Varchar2(30)
418 ,organization_id NUMBER
419 );
420
421
422
423
424
425
426
427
428 Procedure Update_Cov_level
429 (
430 p_covered_line_id IN Number,
431 p_new_end_date IN Date,
432 p_K_item_id IN Number,
433 p_new_negotiated_amt IN Number,
434 p_new_cp_qty IN Number,
435 x_return_status OUT NOCOPY Varchar2
436 , x_msg_count OUT NOCOPY Number
437 , x_msg_data OUT NOCOPY Varchar2
438 );
439
440 Procedure Create_K_Hdr
441 (
442 p_k_header_rec IN K_HEADER_REC_TYPE
443 , p_Contact_tbl IN Contact_Tbl
444 , x_chr_id OUT NOCOPY Number
445 , x_return_status OUT NOCOPY Varchar2
446 , x_msg_count OUT NOCOPY Number
447 , x_msg_data OUT NOCOPY Varchar2
448 );
449
450 Procedure Create_OSO_Contract_IBNEW
451 (
452 p_extwar_rec IN ExtWar_Rec_Type
453 , p_contact_tbl_in IN OKS_EXTWARPRGM_OSO_PVT.contact_tbl
454 , p_salescredit_tbl_in IN OKS_EXTWARPRGM_OSO_PVT.salescredit_tbl
455 , p_price_attribs_in IN OKS_EXTWARPRGM_OSO_PVT.pricing_attributes_type
456 , x_chrid OUT NOCOPY Number
457 , x_return_status OUT NOCOPY Varchar2
458 , x_msg_count OUT NOCOPY Number
459 , x_msg_data OUT NOCOPY Varchar2
460 );
461
462 Procedure Create_OSO_K_Covered_Levels
463 (
464 p_k_covd_rec IN K_line_Covered_Level_Rec_type
465 , p_PRICE_ATTRIBS IN Pricing_attributes_Type
466 , x_return_status OUT NOCOPY Varchar2
467 , x_msg_count OUT NOCOPY Number
468 , x_msg_data OUT NOCOPY Varchar2
469 );
470
471 Procedure Create_OSO_K_Service_Lines
472 (
473 p_k_line_rec IN K_line_Service_Rec_type
474 , p_Contact_tbl IN Contact_Tbl
475 , p_salescredit_tbl_in IN SalesCredit_Tbl
476 , x_service_line_id OUT NOCOPY Number
477 , x_return_status OUT NOCOPY Varchar2
478 , x_msg_count OUT NOCOPY Number
479 , x_msg_data OUT NOCOPY Varchar2
480 );
481
482 End OKS_EXTWARPRGM_OSO_PVT;