[Home] [Help]
Skip to content
PACKAGE: APPS.OKS_COPY_CONTRACT_PVT
Source
1 Package OKS_COPY_CONTRACT_PVT AUTHID CURRENT_USER AS
2 /*$Header: OKSCOPYS.pls 120.39.12020000.3 2013/04/05 09:52:48 vgujarat ship $*/
3
4
5 SUBTYPE chrv_rec_type IS OKC_CONTRACT_PUB.chrv_rec_type;
6 SUBTYPE chrv_tbl_type IS OKC_CONTRACT_PUB.chrv_tbl_type;
7 SUBTYPE clev_rec_type IS OKC_CONTRACT_PUB.clev_rec_type;
8 SUBTYPE clev_tbl_type IS OKC_CONTRACT_PUB.clev_tbl_type;
9 SUBTYPE cacv_rec_type IS OKC_CONTRACT_PUB.cacv_rec_type;
10 SUBTYPE cacv_tbl_type IS OKC_CONTRACT_PUB.cacv_tbl_type;
11 SUBTYPE cpsv_rec_type IS OKC_CONTRACT_PUB.cpsv_rec_type;
12 SUBTYPE cpsv_tbl_type IS OKC_CONTRACT_PUB.cpsv_tbl_type;
13 SUBTYPE catv_rec_type IS OKC_K_ARTICLE_PUB.catv_rec_type;
14 SUBTYPE catv_tbl_type IS OKC_K_ARTICLE_PUB.catv_tbl_type;
15 SUBTYPE atnv_rec_type IS OKC_K_ARTICLE_PUB.atnv_rec_type;
16 SUBTYPE atnv_tbl_type IS OKC_K_ARTICLE_PUB.atnv_tbl_type;
17 SUBTYPE cnhv_rec_type IS OKC_CONDITIONS_PUB.cnhv_rec_type;
18 SUBTYPE cnhv_tbl_type IS OKC_CONDITIONS_PUB.cnhv_tbl_type;
19 SUBTYPE cnlv_rec_type IS OKC_CONDITIONS_PUB.cnlv_rec_type;
20 SUBTYPE cnlv_tbl_type IS OKC_CONDITIONS_PUB.cnlv_tbl_type;
21 SUBTYPE cimv_rec_type IS OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
22 SUBTYPE cimv_tbl_type IS OKC_CONTRACT_ITEM_PUB.cimv_tbl_type;
23 SUBTYPE cplv_rec_type IS OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
24 SUBTYPE cplv_tbl_type IS OKC_CONTRACT_PARTY_PUB.cplv_tbl_type;
25 SUBTYPE cgcv_rec_type IS OKC_CONTRACT_GROUP_PUB.cgcv_rec_type;
26 SUBTYPE cgcv_tbl_type IS OKC_CONTRACT_GROUP_PUB.cgcv_tbl_type;
27 SUBTYPE ctcv_rec_type IS OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
28 SUBTYPE ctcv_tbl_type IS OKC_CONTRACT_PARTY_PUB.ctcv_tbl_type;
29
30 ---------------------------------------------------------------------------
31 -- GLOBAL MESSAGE CONSTANTS
32 ---------------------------------------------------------------------------
33 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
34 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
35 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
36 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
43 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
44 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
45 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
46 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQ';
47
48 ------------------------------------------------------------------------------------
49 -- GLOBAL EXCEPTION
50 ---------------------------------------------------------------------------
51 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
52
53 -- GLOBAL VARIABLES
54 ---------------------------------------------------------------------------
55 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
56 G_APP_ID CONSTANT NUMBER := 515;
57 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_COPY_CONTRACT_PVT';
58 G_BULK_FETCH_LIMIT NUMBER := 1000;
59 HexFormatStr VARCHAR2(100) := 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';
60
61 ---------------------------------------------------------------------------
62 /*
63 TYPE api_components_rec IS RECORD(id NUMBER,
64 to_k NUMBER,
65 component_type VARCHAR2(30),
66 attribute1 VARCHAR2(100));
67 TYPE api_components_tbl IS TABLE OF api_components_rec
68 INDEX BY BINARY_INTEGER;
69
70 TYPE api_lines_rec IS RECORD(id NUMBER,
71 to_k NUMBER,
72 to_line NUMBER,
73 lse_id NUMBER,
74 line_exists_yn VARCHAR2(1),
75 line_exp_yn VARCHAR2(1)); --Bug 3990643
76 TYPE api_lines_tbl IS TABLE OF api_lines_rec
77 INDEX BY BINARY_INTEGER;
78 */
79
80 TYPE published_line_ids_rec IS RECORD(old_line_id NUMBER
81 ,new_line_id NUMBER);
82
83 TYPE published_line_ids_tbl IS TABLE OF published_line_ids_rec
84 INDEX BY BINARY_INTEGER;
85
86 SUBTYPE api_components_tbl IS OKC_COPY_CONTRACT_PVT.api_components_tbl;
87 SUBTYPE api_lines_tbl IS OKC_COPY_CONTRACT_PVT.api_lines_tbl;
88
89
90 ------------------------------Data Types added for 12.0 Copy--------------------------
91
92 --------Table Datatypes for Common Columns--------
93 TYPE NumTabType IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
94 TYPE FlagTabType IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
95 TYPE YNTabType IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;
96 TYPE DateTabType IS TABLE OF DATE INDEX BY BINARY_INTEGER;
97 TYPE OrigSystemRef1TabType IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
98 TYPE OrigSystemSourceCodeTabType IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
99 TYPE UpgOrigSystemRefTabType IS TABLE OF VARCHAR2(60) INDEX BY BINARY_INTEGER;
100 TYPE LanguageTabType IS TABLE OF VARCHAR2(12) INDEX BY BINARY_INTEGER;
101 TYPE AttributeCategoryTabType IS TABLE OF VARCHAR2(90) INDEX BY BINARY_INTEGER;
102 TYPE AttributeTabType IS TABLE OF VARCHAR2(450) INDEX BY BINARY_INTEGER;
103 TYPE Object1ID1TabType IS TABLE OF VARCHAR2(40) INDEX BY BINARY_INTEGER;
104 TYPE Object1ID2TabType IS TABLE OF VARCHAR2(200) INDEX BY BINARY_INTEGER;
105 TYPE JTOTObject1CodeTabType IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
106 TYPE CognomenTabType IS TABLE OF VARCHAR2(300) INDEX BY BINARY_INTEGER;
107 TYPE Varchar2_30_TabType IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
108 TYPE Varchar2_40_TabType IS TABLE OF VARCHAR2(40) INDEX BY BINARY_INTEGER;
109 TYPE Varchar2_90_TabType IS TABLE OF VARCHAR2(90) INDEX BY BINARY_INTEGER;
110 TYPE Varchar2_240_TabType IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
111 TYPE Varchar2_450_TabType IS TABLE OF VARCHAR2(450) INDEX BY BINARY_INTEGER;
112 TYPE Varchar2_2000_TabType IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
113
114
115 TYPE ApiLinesRecTabType IS RECORD(
116 IDTab NumTabType
117 ,ToKTab NumTabType
118 ,ToLineTab NumTabType
119 ,LineExistsYNTab FlagTabType
120 ,LineExpYNTab FlagTabType
121 );
122
123 ApiLinesRecTab ApiLinesRecTabType;
124
125 --------Table datatypes for OKC_K_LINES_B columns------------
126 TYPE OkcB_LineNumberTabType IS TABLE OF OKC_K_LINES_B.LINE_NUMBER%TYPE;
127 TYPE OkcB_DisplaySequenceTabType IS TABLE OF OKC_K_LINES_B.DISPLAY_SEQUENCE%TYPE;
128 TYPE OkcB_StsCodeTabType IS TABLE OF OKC_K_LINES_B.STS_CODE%TYPE;
129 TYPE OkcB_TrnCodeTabType IS TABLE OF OKC_K_LINES_B.TRN_CODE%TYPE;
130 TYPE OkcB_LseIDTabType IS TABLE OF OKC_K_LINES_B.LSE_ID%TYPE;
131 TYPE OkcB_ObjVersionNumTabType IS TABLE OF OKC_K_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
132 TYPE OkcB_DpasRatingTabType IS TABLE OF OKC_K_LINES_B.DPAS_RATING%TYPE;
133 TYPE OkcB_TemplateUsedTabType IS TABLE OF OKC_K_LINES_B.TEMPLATE_USED%TYPE;
134 TYPE OkcB_PriceTypeTabType IS TABLE OF OKC_K_LINES_B.PRICE_TYPE%TYPE;
135 TYPE OkcB_CurrencyCodeTabType IS TABLE OF OKC_K_LINES_B.CURRENCY_CODE%TYPE;
136 TYPE OkcB_ConfigItemTypeTabType IS TABLE OF OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE;
137 TYPE OkcB_PhPricingTypeTabType IS TABLE OF OKC_K_LINES_B.PH_PRICING_TYPE%TYPE;
138 TYPE OkcB_PhPriceBreakBasisTabType IS TABLE OF OKC_K_LINES_B.PH_PRICE_BREAK_BASIS%TYPE;
139 TYPE OkcB_LineRenewTypeCodeTabType IS TABLE OF OKC_K_LINES_B.LINE_RENEWAL_TYPE_CODE%TYPE;
140 TYPE OkcB_TermCancelSourceTabType IS TABLE OF OKC_K_LINES_B.TERM_CANCEL_SOURCE%TYPE;
141
142 ------Table datatypes for OKS_K_LINES_B columns---------------
143 TYPE OksB_LimitUOMQuantifyTabType IS TABLE OF OKS_K_LINES_B.LIMIT_UOM_QUANTIFIED%TYPE;
144 TYPE OksB_OffsetPeriodTabType IS TABLE OF OKS_K_LINES_B.OFFSET_PERIOD%TYPE;
145 TYPE OksB_TransferOptionTabType IS TABLE OF OKS_K_LINES_B.TRANSFER_OPTION%TYPE;
146 TYPE OksB_InheritanceTypeTabType IS TABLE OF OKS_K_LINES_B.INHERITANCE_TYPE%TYPE;
147 TYPE OksB_PaymentTypeTabType IS TABLE OF OKS_K_LINES_B.PAYMENT_TYPE%TYPE;
148 TYPE OksB_CCNOTabType IS TABLE OF OKS_K_LINES_B.CC_NO%TYPE;
149 TYPE OksB_CCAuthCodeTabType IS TABLE OF OKS_K_LINES_B.CC_AUTH_CODE%TYPE;
150 TYPE OksB_UsageEstMethodTabType IS TABLE OF OKS_K_LINES_B.USAGE_EST_METHOD%TYPE;
151 TYPE OksB_TermnMethodTabType IS TABLE OF OKS_K_LINES_B.TERMN_METHOD%TYPE;
152 TYPE OksB_CustPONumberTabType IS TABLE OF OKS_K_LINES_B.CUST_PO_NUMBER%TYPE;
153 TYPE OksB_GracePeriodTabType IS TABLE OF OKS_K_LINES_B.GRACE_PERIOD%TYPE;
154 TYPE OksB_PriceUOMTabType IS TABLE OF OKS_K_LINES_B.PRICE_UOM%TYPE;
155 TYPE OksB_TaxStatusTabType IS TABLE OF OKS_K_LINES_B.TAX_STATUS%TYPE;
156 TYPE OksB_IBTransTypeTabType IS TABLE OF OKS_K_LINES_B.IB_TRANS_TYPE%TYPE;
157 TYPE OksB_ClvlUOMCodeTabType IS TABLE OF OKS_K_LINES_B.CLVL_UOM_CODE%TYPE;
158 TYPE OksB_TopLVLOperandCodeTabType IS TABLE OF OKS_K_LINES_B.TOPLVL_OPERAND_CODE%TYPE;
159 TYPE OksB_TOPLVLUOMCodeTabType IS TABLE OF OKS_K_LINES_B.TOPLVL_UOM_CODE%TYPE;
160 TYPE OksB_SettlemntIntervalTabType IS TABLE OF OKS_K_LINES_B.SETTLEMENT_INTERVAL%TYPE;
161 TYPE OksB_UsagePeriodTabType IS TABLE OF OKS_K_LINES_B.USAGE_PERIOD%TYPE;
162 TYPE OksB_UsageTypeTabType IS TABLE OF OKS_K_LINES_B.USAGE_TYPE%TYPE;
163 TYPE OksB_UOMQuantifiedTabType IS TABLE OF OKS_K_LINES_B.UOM_QUANTIFIED%TYPE;
164 TYPE OksB_BillScheduleTypeTabType IS TABLE OF OKS_K_LINES_B.BILLING_SCHEDULE_TYPE%TYPE;
165 TYPE OksB_FullCreditTabType IS TABLE OF OKS_K_LINES_B.FULL_CREDIT%TYPE;
166 TYPE OksB_BreakUOMTabType IS TABLE OF OKS_K_LINES_B.BREAK_UOM%TYPE;
167 TYPE OksB_ProrateTabType IS TABLE OF OKS_K_LINES_B.PRORATE%TYPE;
168 TYPE OksB_CoverageTypeTabType IS TABLE OF OKS_K_LINES_B.COVERAGE_TYPE%TYPE;
169 TYPE OksB_TaxClassfnCodeTabType IS TABLE OF OKS_K_LINES_B.TAX_CLASSIFICATION_CODE%TYPE;
170 TYPE OksB_ExemptCertNumTabType IS TABLE OF OKS_K_LINES_B.EXEMPT_CERTIFICATE_NUMBER%TYPE;
171 TYPE OksB_ExemptReasonCodeTabType IS TABLE OF OKS_K_LINES_B.EXEMPT_REASON_CODE%TYPE;
172
173 ---Table datatypes for OKC_K_ITEMS columns--------------------
174 TYPE OkcI_UOMCodeTabType IS TABLE OF OKC_K_ITEMS.UOM_CODE%TYPE;
175 TYPE OkcI_ExceptionYNTabType IS TABLE OF OKC_K_ITEMS.EXCEPTION_YN%TYPE;
176 TYPE OkcI_PricedItemYNTabType IS TABLE OF OKC_K_ITEMS.PRICED_ITEM_YN%TYPE;
177
178 -----------Start of Record of Tables Data Type for columns in OKC_K_LINES_B,OKS_K_LINES_B,OKC_K_ITEMS------------
179 TYPE OKCOKSLinesRecTabType IS RECORD
180 (
181 -----------Start of Record Members for OKC_K_LINES_B columns------------
182 OkcB_OldOKCLineID NumTabType
183 ,OkcB_NewOKCLineID NumTabType
184 ,OkcB_LINE_NUMBER OkcB_LineNumberTabType
185 ,OkcB_NewChrID NumTabType
186 ,OkcB_CLE_ID NumTabType
187 ,OkcB_NewDnzChrID NumTabType
188 ,OkcB_DISPLAY_SEQUENCE OkcB_DisplaySequenceTabType
189 ,OkcB_STS_CODE OkcB_StsCodeTabType
190 ,OkcB_TRN_CODE OkcB_TrnCodeTabType
191 ,OkcB_LSE_ID NumTabType
192 ,OkcB_EXCEPTION_YN YNTabType
193 ,OkcB_OBJECT_VERSION_NUMBER NumTabType
194 ,OkcB_HIDDEN_IND YNTabType
195 ,OkcB_PRICE_NEGOTIATED NumTabType
196 ,OkcB_PRICE_LEVEL_IND YNTabType
197 ,OkcB_PRICE_UNIT NumTabType
198 ,OkcB_PRICE_UNIT_PERCENT NumTabType
199 ,OkcB_INVOICE_LINE_LEVEL_IND YNTabType
200 ,OkcB_DPAS_RATING OkcB_DpasRatingTabType
201 ,OkcB_TEMPLATE_USED OkcB_TemplateUsedTabType
202 ,OkcB_PRICE_TYPE OkcB_PriceTypeTabType
203 ,OkcB_CURRENCY_CODE OkcB_CurrencyCodeTabType
204 ,OkcB_DATE_TERMINATED DateTabType
205 ,OkcB_START_DATE DateTabType
206 ,OkcB_END_DATE DateTabType
207 ,OkcB_ATTRIBUTE_CATEGORY AttributeCategoryTabType
208 ,OkcB_ATTRIBUTE1 AttributeTabType
209 ,OkcB_ATTRIBUTE2 AttributeTabType
210 ,OkcB_ATTRIBUTE3 AttributeTabType
211 ,OkcB_ATTRIBUTE4 AttributeTabType
212 ,OkcB_ATTRIBUTE5 AttributeTabType
213 ,OkcB_ATTRIBUTE6 AttributeTabType
214 ,OkcB_ATTRIBUTE7 AttributeTabType
215 ,OkcB_ATTRIBUTE8 AttributeTabType
216 ,OkcB_ATTRIBUTE9 AttributeTabType
217 ,OkcB_ATTRIBUTE10 AttributeTabType
218 ,OkcB_ATTRIBUTE11 AttributeTabType
219 ,OkcB_ATTRIBUTE12 AttributeTabType
220 ,OkcB_ATTRIBUTE13 AttributeTabType
221 ,OkcB_ATTRIBUTE14 AttributeTabType
222 ,OkcB_ATTRIBUTE15 AttributeTabType
223 ,OkcB_SECURITY_GROUP_ID NumTabType
224 ,OkcB_PRICE_NEGOTIATED_RENEWED NumTabType
225 ,OkcB_CURRENCY_CODE_RENEWED OkcB_CurrencyCodeTabType
226 ,OkcB_UPG_ORIG_SYSTEM_REF UpgOrigSystemRefTabType
227 ,OkcB_UPG_ORIG_SYSTEM_REF_ID NumTabType
228 ,OkcB_DATE_RENEWED DateTabType
229 ,OkcB_ORIG_SYSTEM_ID1 NumTabType
230 ,OkcB_ORIG_SYSTEM_REFERENCE1 OrigSystemRef1TabType
231 ,OkcB_ORIG_SYSTEM_SOURCE_CODE OrigSystemSourceCodeTabType
232 ,OkcB_PROGRAM_APPLICATION_ID NumTabType
233 ,OkcB_PROGRAM_ID NumTabType
234 ,OkcB_PROGRAM_UPDATE_DATE DateTabType
235 ,OkcB_REQUEST_ID NumTabType
236 ,OkcB_PRICE_LIST_ID NumTabType
237 ,OkcB_PRICE_LIST_LINE_ID NumTabType
238 ,OkcB_LINE_LIST_PRICE NumTabType
239 ,OkcB_ITEM_TO_PRICE_YN YNTabType
240 ,OkcB_PRICING_DATE DateTabType
241 ,OkcB_PRICE_BASIS_YN YNTabType
242 ,OkcB_CONFIG_HEADER_ID NumTabType
243 ,OkcB_CONFIG_REVISION_NUMBER NumTabType
244 ,OkcB_CONFIG_COMPLETE_YN YNTabType
245 ,OkcB_CONFIG_VALID_YN YNTabType
246 ,OkcB_CONFIG_TOP_MODEL_LINE_ID NumTabType
247 ,OkcB_CONFIG_ITEM_TYPE OkcB_ConfigItemTypeTabType
248 ,OkcB_CONFIG_ITEM_ID NumTabType
249 ,OkcB_SERVICE_ITEM_YN YNTabType
250 ,OkcB_PH_PRICING_TYPE OkcB_PhPricingTypeTabType
251 ,OkcB_PH_PRICE_BREAK_BASIS OkcB_PhPriceBreakBasisTabType
252 ,OkcB_PH_MIN_QTY NumTabType
253 ,OkcB_PH_MIN_AMT NumTabType
254 ,OkcB_PH_QP_REFERENCE_ID NumTabType
255 ,OkcB_PH_VALUE NumTabType
256 ,OkcB_PH_ENFORCE_PRICE_LIST_YN FlagTabType
257 ,OkcB_PH_ADJUSTMENT NumTabType
258 ,OkcB_PH_INTEGRATED_WITH_QP FlagTabType
259 ,OkcB_CUST_ACCT_ID NumTabType
260 ,OkcB_BILL_TO_SITE_USE_ID NumTabType
261 ,OkcB_INV_RULE_ID NumTabType
262 ,OkcB_LINE_RENEWAL_TYPE_CODE OkcB_LineRenewTypeCodeTabType
263 ,OkcB_SHIP_TO_SITE_USE_ID NumTabType
264 ,OkcB_PAYMENT_TERM_ID NumTabType
265 ,OkcB_DATE_CANCELLED DateTabType
266 ,OkcB_TERM_CANCEL_SOURCE OkcB_TermCancelSourceTabType
267 ,OkcB_ANNUALIZED_FACTOR NumTabType
268 ,OkcB_PAYMENT_INSTRUCTION_TYPE YNTabType
269 ,OkcB_CANCELLED_AMOUNT NumTabType
270 ,OkcB_LINE_CANCELLED_FLAG FlagTabType
271 ,OkcB_LINE_TERMINATED_FLAG FlagTabType
272 -----------------End of record members for OKC_K_LINES_B columns
273 -----------------Start of record members for OKS_K_LINES_B columns
274 ,OksB_OldOksLineID NumTabType
275 ,OksB_NewOksLineID NumTabType
276 ,OksB_CLE_ID NumTabType
277 ,OksB_NewDnzChrID NumTabType
278 ,OksB_DISCOUNT_LIST NumTabType
279 ,OksB_ACCT_RULE_ID NumTabType
280 ,OksB_PAYMENT_TYPE OksB_PaymentTypeTabType
281 ,OksB_CC_NO OksB_CCNOTabType
282 ,OksB_CC_EXPIRY_DATE DateTabType
283 ,OksB_CC_BANK_ACCT_ID NumTabType
284 ,OksB_CC_AUTH_CODE OksB_CCAuthCodeTabType
285 ,OksB_COMMITMENT_ID NumTabType
286 ,OksB_LOCKED_PRICE_LIST_ID NumTabType
287 ,OksB_USAGE_EST_YN FlagTabType
288 ,OksB_USAGE_EST_METHOD OksB_UsageEstMethodTabType
289 ,OksB_USAGE_EST_START_DATE DateTabType
290 ,OksB_TERMN_METHOD OksB_TermnMethodTabType
291 ,OksB_UBT_AMOUNT NumTabType
292 ,OksB_CREDIT_AMOUNT NumTabType
293 ,OksB_SUPPRESSED_CREDIT NumTabType
294 ,OksB_OVERRIDE_AMOUNT NumTabType
295 ,OksB_CUST_PO_NUMBER_REQ_YN FlagTabType
296 ,OksB_CUST_PO_NUMBER OksB_CustPONumberTabType
297 ,OksB_GRACE_DURATION NumTabType
298 ,OksB_GRACE_PERIOD OksB_GracePeriodTabType
299 ,OksB_INV_PRINT_FLAG FlagTabType
300 ,OksB_PRICE_UOM OksB_PriceUOMTabType
301 ,OksB_TAX_AMOUNT NumTabType
302 ,OksB_TAX_INCLUSIVE_YN FlagTabType
303 ,OksB_TAX_STATUS OksB_TaxStatusTabType
304 ,OksB_TAX_CODE NumTabType
305 ,OksB_TAX_EXEMPTION_ID NumTabType
306 ,OksB_IB_TRANS_TYPE OksB_IBTransTypeTabType
307 ,OksB_IB_TRANS_DATE DateTabType
308 ,OksB_PROD_PRICE NumTabType
309 ,OksB_SERVICE_PRICE NumTabType
310 ,OksB_CLVL_LIST_PRICE NumTabType
311 ,OksB_CLVL_QUANTITY NumTabType
312 ,OksB_CLVL_EXTENDED_AMT NumTabType
313 ,OksB_CLVL_UOM_CODE OksB_ClvlUOMCodeTabType
314 ,OksB_TOPLVL_OPERAND_CODE OksB_TopLVLOperandCodeTabType
315 ,OksB_TOPLVL_OPERAND_VAL NumTabType
316 ,OksB_TOPLVL_QUANTITY NumTabType
317 ,OksB_TOPLVL_UOM_CODE OksB_TopLVLUOMCodeTabType
318 ,OksB_TOPLVL_ADJ_PRICE NumTabType
319 ,OksB_TOPLVL_PRICE_QTY NumTabType
320 ,OksB_AVERAGING_INTERVAL NumTabType
321 ,OksB_SETTLEMENT_INTERVAL OksB_SettlemntIntervalTabType
322 ,OksB_MINIMUM_QUANTITY NumTabType
323 ,OksB_DEFAULT_QUANTITY NumTabType
324 ,OksB_AMCV_FLAG FlagTabType
325 ,OksB_FIXED_QUANTITY NumTabType
326 ,OksB_USAGE_DURATION NumTabType
327 ,OksB_USAGE_PERIOD OksB_UsagePeriodTabType
328 ,OksB_LEVEL_YN FlagTabType
329 ,OksB_USAGE_TYPE OksB_UsageTypeTabType
330 ,OksB_UOM_QUANTIFIED OksB_UOMQuantifiedTabType
331 ,OksB_BASE_READING NumTabType
332 ,OksB_BILLING_SCHEDULE_TYPE OksB_BillScheduleTypeTabType
333 ,OksB_FULL_CREDIT OksB_FullCreditTabType
334 ,OksB_LOCKED_PRICE_LIST_LINE_ID NumTabType
335 ,OksB_BREAK_UOM OksB_BreakUOMTabType
336 ,OksB_PRORATE OksB_ProrateTabType
337 ,OksB_COVERAGE_TYPE OksB_CoverageTypeTabType
338 ,OksB_EXCEPTION_COV_ID NumTabType
339 ,OksB_LIMIT_UOM_QUANTIFIED OksB_LimitUOMQuantifyTabType
340 ,OksB_DISCOUNT_AMOUNT NumTabType
341 ,OksB_DISCOUNT_PERCENT NumTabType
342 ,OksB_OFFSET_DURATION NumTabType
343 ,OksB_OFFSET_PERIOD OksB_OffsetPeriodTabType
344 ,OksB_INCIDENT_SEVERITY_ID NumTabType
345 ,OksB_PDF_ID NumTabType
346 ,OksB_WORK_THRU_YN FlagTabType
347 ,OksB_REACT_ACTIVE_YN FlagTabType
348 ,OksB_TRANSFER_OPTION OksB_TransferOptionTabType
349 ,OksB_PROD_UPGRADE_YN FlagTabType
350 ,OksB_INHERITANCE_TYPE OksB_InheritanceTypeTabType
351 ,OksB_PM_PROGRAM_ID NumTabType
352 ,OksB_PM_CONF_REQ_YN FlagTabType
353 ,OksB_PM_SCH_EXISTS_YN FlagTabType
354 ,OksB_ALLOW_BT_DISCOUNT FlagTabType
355 ,OksB_APPLY_DEFAULT_TIMEZONE FlagTabType
356 ,OksB_SYNC_DATE_INSTALL FlagTabType
357 ,OksB_OBJECT_VERSION_NUMBER NumTabType
358 ,OksB_SECURITY_GROUP_ID NumTabType
359 ,OksB_REQUEST_ID NumTabType
360 ,OksB_ORIG_SYSTEM_ID1 NumTabType
361 ,OksB_ORIG_SYSTEM_REFERENCE1 OrigSystemRef1TabType
362 ,OksB_ORIG_SYSTEM_SOURCE_CODE OrigSystemSourceCodeTabType
363 ,OksB_TRXN_EXTENSION_ID NumTabType
364 ,OksB_TAX_CLASSIFICATION_CODE OksB_TaxClassfnCodeTabType
365 ,OksB_EXEMPT_CERTIFICATE_NUMBER OksB_ExemptCertNumTabType
366 ,OksB_EXEMPT_REASON_CODE OksB_ExemptReasonCodeTabType
367 ,OksB_COVERAGE_ID NumTabType
368 ,OksB_STANDARD_COV_YN FlagTabType
369 -----------------End of record members for OKS_K_LINES_B columns
370 -----------------Start of record members for OKC_K_ITEMS columns
371 ,OkcI_OldOkcItemID NumTabType
372 ,OkcI_NewOkcItemID NumTabType
373 ,OkcI_CLE_ID NumTabType
374 ,OkcI_NewDnzChrID NumTabType
375 ,OkcI_NewChrID NumTabType
376 ,OkcI_OBJECT1_ID1 Object1ID1TabType
377 ,OkcI_OBJECT1_ID2 Object1ID2TabType
378 ,OkcI_JTOT_OBJECT1_CODE JTOTObject1CodeTabType
379 ,OkcI_UOM_CODE OkcI_UOMCodeTabType
380 ,OkcI_EXCEPTION_YN OkcI_ExceptionYNTabType
381 ,OkcI_NUMBER_OF_ITEMS NumTabType
382 ,OkcI_PRICED_ITEM_YN OkcI_PricedItemYNTabType
383 ,OkcI_OBJECT_VERSION_NUMBER NumTabType
384 ,OkcI_SECURITY_GROUP_ID NumTabType
385 ,OkcI_UPG_ORIG_SYSTEM_REF UpgOrigSystemRefTabType
386 ,OkcI_UPG_ORIG_SYSTEM_REF_ID NumTabType
387 ,Okc_PROGRAM_APPLICATION_ID NumTabType
388 ,OkcI_PROGRAM_ID NumTabType
389 ,OkcI_PROGRAM_UPDATE_DATE DateTabType
390 ,OkcI_REQUEST_ID NumTabType
391 ,OksB_COUNTER_VALUE_ID NumTabType
392 );
393 --------End of Record of Tables datatype for columns in OKC_K_LINES_B,OKS_K_LINES_B,OKC_K_ITEMS-----------------------
394 OKCOKSLinesRecTab OKCOKSLinesRecTabType;
395
396 --------Table datatypes for OKC_K_LINES_TL columns------------
397 TYPE OkcTL_NameTabType IS TABLE OF OKC_K_LINES_TL.NAME%TYPE;
398 TYPE OkcTL_CommentsTabType IS TABLE OF OKC_K_LINES_TL.COMMENTS%TYPE;
399 TYPE OkcTL_ItemDescTabType IS TABLE OF OKC_K_LINES_TL.ITEM_DESCRIPTION%TYPE;
400 TYPE OkcTL_Block23TxtTabType IS TABLE OF OKC_K_LINES_TL.BLOCK23TEXT%TYPE;
401 TYPE OkcTL_OkeBoeDescTabType IS TABLE OF OKC_K_LINES_TL.OKE_BOE_DESCRIPTION%TYPE;
402
403 --------Record of Tables datatype for OKC_K_LINES_TL------------
404 TYPE OKCLinesTLRecTabType IS RECORD
405 (
406 OkcTL_OldID NumTabType
407 ,OkcTL_NewID NumTabType
408 ,OkcTL_LANGUAGE LanguageTabType
409 ,OkcTL_SOURCE_LANG LanguageTabType
410 ,OkcTL_SFWT_FLAG YNTabType
411 ,OkcTL_NAME OkcTL_NameTabType
412 ,OkcTL_COMMENTS OkcTL_CommentsTabType
413 ,OkcTL_ITEM_DESCRIPTION OkcTL_ItemDescTabType
414 ,OkcTL_BLOCK23TEXT OkcTL_Block23TxtTabType
415 ,OkcTL_SECURITY_GROUP_ID NumTabType
416 ,OkcTL_OKE_BOE_DESCRIPTION OkcTL_OkeBoeDescTabType
417 ,OkcTL_COGNOMEN CognomenTabType
418 );
419
420 --------End of Record of Tables datatype for OKC_K_LINES_TL
421 OKCLinesTLRecTab OKCLinesTLRecTabType;
422
423 ------Table datatypes for OKC_K_PARTY_ROLES_B columns------------
424 TYPE OkcPRB_RLECodeTabType IS TABLE OF OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE;
425 TYPE OkcPRB_CodeTabType IS TABLE OF OKC_K_PARTY_ROLES_B.CODE%TYPE;
426 TYPE OkcPRB_FacilityTabType IS TABLE OF OKC_K_PARTY_ROLES_B.FACILITY%TYPE;
427 TYPE OkcPRB_MinorGrpLkupCodeTabType IS TABLE OF OKC_K_PARTY_ROLES_B.MINORITY_GROUP_LOOKUP_CODE%TYPE;
428
429 ------Record of Tables datatype for OKC_K_PARTY_ROLES_B----------
430 TYPE OkcPRBRecTabType IS RECORD
431 (OkcPRB_OldID NumTabType
432 ,OkcPRB_NewID NumTabType
433 ,OkcPRB_NewChrID NumTabType
434 ,OkcPRB_NewCleID NumTabType
435 ,OkcPRB_NewDnzChrID NumTabType
436 ,OkcPRB_RLE_CODE OkcPRB_RLECodeTabType
437 ,OkcPRB_OBJECT1_ID1 Object1ID1TabType
438 ,OkcPRB_OBJECT1_ID2 Object1ID2TabType
439 ,OkcPRB_JTOT_OBJECT1_CODE JTOTObject1CodeTabType
440 ,OkcPRB_OBJECT_VERSION_NUMBER NumTabType
441 ,OkcPRB_CODE OkcPRB_CodeTabType
442 ,OkcPRB_FACILITY OkcPRB_FacilityTabType
443 ,OkcPRB_MINOR_GROUP_LOOKUP_CODE OkcPRB_MinorGrpLkupCodeTabType
444 ,OkcPRB_SMALL_BUSINESS_FLAG YNTabType
445 ,OkcPRB_WOMEN_OWNED_FLAG YNTabType
446 ,OkcPRB_ATTRIBUTE_CATEGORY AttributeCategoryTabType
447 ,OkcPRB_ATTRIBUTE1 AttributeTabType
448 ,OkcPRB_ATTRIBUTE2 AttributeTabType
449 ,OkcPRB_ATTRIBUTE3 AttributeTabType
450 ,OkcPRB_ATTRIBUTE4 AttributeTabType
451 ,OkcPRB_ATTRIBUTE5 AttributeTabType
452 ,OkcPRB_ATTRIBUTE6 AttributeTabType
453 ,OkcPRB_ATTRIBUTE7 AttributeTabType
454 ,OkcPRB_ATTRIBUTE8 AttributeTabType
455 ,OkcPRB_ATTRIBUTE9 AttributeTabType
456 ,OkcPRB_ATTRIBUTE10 AttributeTabType
457 ,OkcPRB_ATTRIBUTE11 AttributeTabType
458 ,OkcPRB_ATTRIBUTE12 AttributeTabType
459 ,OkcPRB_ATTRIBUTE13 AttributeTabType
460 ,OkcPRB_ATTRIBUTE14 AttributeTabType
461 ,OkcPRB_ATTRIBUTE15 AttributeTabType
462 ,OkcPRB_SECURITY_GROUP_ID NumTabType
463 ,OkcPRB_CPL_ID NumTabType
464 ,OkcPRB_PRIMARY_YN FlagTabType
465 ,OkcPRB_BILL_TO_SITE_USE_ID NumTabType
466 ,OkcPRB_CUST_ACCT_ID NumTabType
467 ,OkcPRB_ORIG_SYSTEM_ID1 NumTabType
468 ,OkcPRB_ORIG_SYSTEM_REFERENCE1 OrigSystemRef1TabType
469 ,OkcPRB_ORIG_SYSTEM_SOURCE_CODE OrigSystemSourceCodeTabType
470 );
471
472 OkcPRBRecTab OkcPRBRecTabType;
473 ------End of Record of Tables datatype for OKC_K_PARTY_ROLES_B---
474
475 ------Table datatypes for OKC_K_PARTY_ROLES_TL------------------
476 TYPE OkcPRTL_AliasTabType IS TABLE OF OKC_K_PARTY_ROLES_TL.ALIAS%TYPE;
477
478 ------Record of tables datatype for OKC_K_PARTY_ROLES_TL----------
479 TYPE OkcPRTLRecTabType IS RECORD
480 (OkcPRTL_OldID NumTabType
481 ,OkcPRTL_NewID NumTabType
482 ,OkcPRTL_LANGUAGE LanguageTabType
483 ,OkcPRTL_SOURCE_LANG LanguageTabType
484 ,OkcPRTL_SFWT_FLAG YNTabType
485 ,OkcPRTL_COGNOMEN CognomenTabType
486 ,OkcPRTL_ALIAS OkcPRTL_AliasTabType
487 ,OkcPRTL_SECURITY_GROUP_ID NumTabType
488 );
489
490 OkcPRTLRecTab OkcPRTLRecTabType;
491 --------------------------------------------------------------------
492
493 -----Table datatypes for OKC_CONTACTS-----------------------------
494 TYPE OkcC_CroCodeTabType IS TABLE OF OKC_CONTACTS.CRO_CODE%TYPE;
495 TYPE OkcC_ResourceClassTabType IS TABLE OF OKC_CONTACTS.RESOURCE_CLASS%TYPE;
496
497 -----Record of tables datatype for OKC_CONTACTS------------------
498 TYPE OkcCRecTabType IS RECORD
499 (OkcC_OldID NumTabType
500 ,OkcC_NewID NumTabType
501 ,OkcC_NewCplID NumTabType
502 ,OkcC_CRO_CODE OkcC_CroCodeTabType
503 ,OkcC_NewDnzChrID NumTabType
504 ,OkcC_OBJECT1_ID1 Object1ID1TabType
505 ,OkcC_OBJECT1_ID2 Object1ID2TabType
506 ,OkcC_JTOT_OBJECT1_CODE JTOTObject1CodeTabType
507 ,OkcC_OBJECT_VERSION_NUMBER NumTabType
508 ,OkcC_CONTACT_SEQUENCE NumTabType
509 ,OkcC_ATTRIBUTE_CATEGORY AttributeCategoryTabType
510 ,OkcC_ATTRIBUTE1 AttributeTabType
511 ,OkcC_ATTRIBUTE2 AttributeTabType
512 ,OkcC_ATTRIBUTE3 AttributeTabType
513 ,OkcC_ATTRIBUTE4 AttributeTabType
514 ,OkcC_ATTRIBUTE5 AttributeTabType
515 ,OkcC_ATTRIBUTE6 AttributeTabType
516 ,OkcC_ATTRIBUTE7 AttributeTabType
517 ,OkcC_ATTRIBUTE8 AttributeTabType
518 ,OkcC_ATTRIBUTE9 AttributeTabType
519 ,OkcC_ATTRIBUTE10 AttributeTabType
520 ,OkcC_ATTRIBUTE11 AttributeTabType
521 ,OkcC_ATTRIBUTE12 AttributeTabType
522 ,OkcC_ATTRIBUTE13 AttributeTabType
523 ,OkcC_ATTRIBUTE14 AttributeTabType
524 ,OkcC_ATTRIBUTE15 AttributeTabType
525 ,OkcC_SECURITY_GROUP_ID NumTabType
526 ,OkcC_START_DATE DateTabType
527 ,OkcC_END_DATE DateTabType
528 ,OkcC_PRIMARY_YN FlagTabType
529 ,OkcC_RESOURCE_CLASS OkcC_ResourceClassTabType
530 ,OkcC_SALES_GROUP_ID NumTabType
531 );
532
533 OkcCRecTab OkcCRecTabType;
534 ------------------------------------------------------------------
535
536 ------Table Datatypes for OKC_PRICE_ATT_VALUES------------------
537 TYPE OkcPAV_FlexTitleTabType IS TABLE OF OKC_PRICE_ATT_VALUES.FLEX_TITLE%TYPE;
538 TYPE OkcPAV_PricingContextTabType IS TABLE OF OKC_PRICE_ATT_VALUES.PRICING_CONTEXT%TYPE;
539 TYPE OkcPAV_PricingAttributeTabType IS TABLE OF OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE1%TYPE;
540 TYPE OkcPAV_QualifierContextTabType IS TABLE OF OKC_PRICE_ATT_VALUES.QUALIFIER_CONTEXT%TYPE;
541 TYPE OkcPAV_QualifAttributeTabType IS TABLE OF OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE1%TYPE;
542
543
544 ------Record of tables datatype for OKC_PRICE_ATT_VALUES-------------
545 TYPE OkcPAVRecTabType IS RECORD
546 (
547 OkcPAV_OldID NumTabType
548 ,OkcPAV_NewID NumTabType
549 ,OkcPAV_FLEX_TITLE OkcPAV_FlexTitleTabType
550 ,OkcPAV_PRICING_CONTEXT OkcPAV_PricingContextTabType
551 ,OkcPAV_PRICING_ATTRIBUTE1 OkcPAV_PricingAttributeTabType
552 ,OkcPAV_NewChrID NumTabType
553 ,OkcPAV_PRICING_ATTRIBUTE2 OkcPAV_PricingAttributeTabType
554 ,OkcPAV_NewCleID NumTabType
555 ,OkcPAV_PRICING_ATTRIBUTE3 OkcPAV_PricingAttributeTabType
556 ,OkcPAV_PRICING_ATTRIBUTE4 OkcPAV_PricingAttributeTabType
557 ,OkcPAV_PRICING_ATTRIBUTE5 OkcPAV_PricingAttributeTabType
558 ,OkcPAV_PRICING_ATTRIBUTE6 OkcPAV_PricingAttributeTabType
559 ,OkcPAV_PRICING_ATTRIBUTE7 OkcPAV_PricingAttributeTabType
560 ,OkcPAV_PRICING_ATTRIBUTE8 OkcPAV_PricingAttributeTabType
561 ,OkcPAV_PRICING_ATTRIBUTE9 OkcPAV_PricingAttributeTabType
562 ,OkcPAV_PRICING_ATTRIBUTE10 OkcPAV_PricingAttributeTabType
563 ,OkcPAV_PRICING_ATTRIBUTE11 OkcPAV_PricingAttributeTabType
564 ,OkcPAV_PRICING_ATTRIBUTE12 OkcPAV_PricingAttributeTabType
565 ,OkcPAV_PRICING_ATTRIBUTE13 OkcPAV_PricingAttributeTabType
566 ,OkcPAV_PRICING_ATTRIBUTE14 OkcPAV_PricingAttributeTabType
567 ,OkcPAV_PRICING_ATTRIBUTE15 OkcPAV_PricingAttributeTabType
568 ,OkcPAV_PRICING_ATTRIBUTE16 OkcPAV_PricingAttributeTabType
569 ,OkcPAV_PRICING_ATTRIBUTE17 OkcPAV_PricingAttributeTabType
570 ,OkcPAV_PRICING_ATTRIBUTE18 OkcPAV_PricingAttributeTabType
571 ,OkcPAV_PRICING_ATTRIBUTE19 OkcPAV_PricingAttributeTabType
572 ,OkcPAV_PRICING_ATTRIBUTE20 OkcPAV_PricingAttributeTabType
573 ,OkcPAV_PRICING_ATTRIBUTE21 OkcPAV_PricingAttributeTabType
574 ,OkcPAV_PRICING_ATTRIBUTE22 OkcPAV_PricingAttributeTabType
575 ,OkcPAV_PRICING_ATTRIBUTE23 OkcPAV_PricingAttributeTabType
576 ,OkcPAV_PRICING_ATTRIBUTE24 OkcPAV_PricingAttributeTabType
577 ,OkcPAV_PRICING_ATTRIBUTE25 OkcPAV_PricingAttributeTabType
578 ,OkcPAV_PRICING_ATTRIBUTE26 OkcPAV_PricingAttributeTabType
579 ,OkcPAV_PRICING_ATTRIBUTE27 OkcPAV_PricingAttributeTabType
580 ,OkcPAV_PRICING_ATTRIBUTE28 OkcPAV_PricingAttributeTabType
581 ,OkcPAV_PRICING_ATTRIBUTE29 OkcPAV_PricingAttributeTabType
582 ,OkcPAV_PRICING_ATTRIBUTE30 OkcPAV_PricingAttributeTabType
583 ,OkcPAV_PRICING_ATTRIBUTE31 OkcPAV_PricingAttributeTabType
584 ,OkcPAV_PRICING_ATTRIBUTE32 OkcPAV_PricingAttributeTabType
585 ,OkcPAV_PRICING_ATTRIBUTE33 OkcPAV_PricingAttributeTabType
586 ,OkcPAV_PRICING_ATTRIBUTE34 OkcPAV_PricingAttributeTabType
587 ,OkcPAV_PRICING_ATTRIBUTE35 OkcPAV_PricingAttributeTabType
588 ,OkcPAV_PRICING_ATTRIBUTE36 OkcPAV_PricingAttributeTabType
589 ,OkcPAV_PRICING_ATTRIBUTE37 OkcPAV_PricingAttributeTabType
590 ,OkcPAV_PRICING_ATTRIBUTE38 OkcPAV_PricingAttributeTabType
591 ,OkcPAV_PRICING_ATTRIBUTE39 OkcPAV_PricingAttributeTabType
592 ,OkcPAV_PRICING_ATTRIBUTE40 OkcPAV_PricingAttributeTabType
593 ,OkcPAV_PRICING_ATTRIBUTE41 OkcPAV_PricingAttributeTabType
594 ,OkcPAV_PRICING_ATTRIBUTE42 OkcPAV_PricingAttributeTabType
595 ,OkcPAV_PRICING_ATTRIBUTE43 OkcPAV_PricingAttributeTabType
596 ,OkcPAV_PRICING_ATTRIBUTE44 OkcPAV_PricingAttributeTabType
597 ,OkcPAV_PRICING_ATTRIBUTE45 OkcPAV_PricingAttributeTabType
598 ,OkcPAV_PRICING_ATTRIBUTE46 OkcPAV_PricingAttributeTabType
599 ,OkcPAV_PRICING_ATTRIBUTE47 OkcPAV_PricingAttributeTabType
600 ,OkcPAV_PRICING_ATTRIBUTE48 OkcPAV_PricingAttributeTabType
601 ,OkcPAV_PRICING_ATTRIBUTE49 OkcPAV_PricingAttributeTabType
602 ,OkcPAV_PRICING_ATTRIBUTE50 OkcPAV_PricingAttributeTabType
603 ,OkcPAV_PRICING_ATTRIBUTE51 OkcPAV_PricingAttributeTabType
604 ,OkcPAV_PRICING_ATTRIBUTE52 OkcPAV_PricingAttributeTabType
605 ,OkcPAV_PRICING_ATTRIBUTE53 OkcPAV_PricingAttributeTabType
606 ,OkcPAV_PRICING_ATTRIBUTE54 OkcPAV_PricingAttributeTabType
607 ,OkcPAV_PRICING_ATTRIBUTE55 OkcPAV_PricingAttributeTabType
608 ,OkcPAV_PRICING_ATTRIBUTE56 OkcPAV_PricingAttributeTabType
609 ,OkcPAV_PRICING_ATTRIBUTE57 OkcPAV_PricingAttributeTabType
610 ,OkcPAV_PRICING_ATTRIBUTE58 OkcPAV_PricingAttributeTabType
611 ,OkcPAV_PRICING_ATTRIBUTE59 OkcPAV_PricingAttributeTabType
612 ,OkcPAV_PRICING_ATTRIBUTE60 OkcPAV_PricingAttributeTabType
613 ,OkcPAV_PRICING_ATTRIBUTE61 OkcPAV_PricingAttributeTabType
614 ,OkcPAV_PRICING_ATTRIBUTE62 OkcPAV_PricingAttributeTabType
615 ,OkcPAV_PRICING_ATTRIBUTE63 OkcPAV_PricingAttributeTabType
616 ,OkcPAV_PRICING_ATTRIBUTE64 OkcPAV_PricingAttributeTabType
617 ,OkcPAV_PRICING_ATTRIBUTE65 OkcPAV_PricingAttributeTabType
618 ,OkcPAV_PRICING_ATTRIBUTE66 OkcPAV_PricingAttributeTabType
619 ,OkcPAV_PRICING_ATTRIBUTE67 OkcPAV_PricingAttributeTabType
620 ,OkcPAV_PRICING_ATTRIBUTE68 OkcPAV_PricingAttributeTabType
621 ,OkcPAV_PRICING_ATTRIBUTE69 OkcPAV_PricingAttributeTabType
622 ,OkcPAV_PRICING_ATTRIBUTE70 OkcPAV_PricingAttributeTabType
623 ,OkcPAV_PRICING_ATTRIBUTE71 OkcPAV_PricingAttributeTabType
624 ,OkcPAV_PRICING_ATTRIBUTE72 OkcPAV_PricingAttributeTabType
625 ,OkcPAV_PRICING_ATTRIBUTE73 OkcPAV_PricingAttributeTabType
626 ,OkcPAV_PRICING_ATTRIBUTE74 OkcPAV_PricingAttributeTabType
627 ,OkcPAV_PRICING_ATTRIBUTE75 OkcPAV_PricingAttributeTabType
628 ,OkcPAV_PRICING_ATTRIBUTE76 OkcPAV_PricingAttributeTabType
629 ,OkcPAV_PRICING_ATTRIBUTE77 OkcPAV_PricingAttributeTabType
630 ,OkcPAV_PRICING_ATTRIBUTE78 OkcPAV_PricingAttributeTabType
631 ,OkcPAV_PRICING_ATTRIBUTE79 OkcPAV_PricingAttributeTabType
632 ,OkcPAV_PRICING_ATTRIBUTE80 OkcPAV_PricingAttributeTabType
633 ,OkcPAV_PRICING_ATTRIBUTE81 OkcPAV_PricingAttributeTabType
634 ,OkcPAV_PRICING_ATTRIBUTE82 OkcPAV_PricingAttributeTabType
635 ,OkcPAV_PRICING_ATTRIBUTE83 OkcPAV_PricingAttributeTabType
636 ,OkcPAV_PRICING_ATTRIBUTE84 OkcPAV_PricingAttributeTabType
637 ,OkcPAV_PRICING_ATTRIBUTE85 OkcPAV_PricingAttributeTabType
638 ,OkcPAV_PRICING_ATTRIBUTE86 OkcPAV_PricingAttributeTabType
639 ,OkcPAV_PRICING_ATTRIBUTE87 OkcPAV_PricingAttributeTabType
640 ,OkcPAV_PRICING_ATTRIBUTE88 OkcPAV_PricingAttributeTabType
641 ,OkcPAV_PRICING_ATTRIBUTE89 OkcPAV_PricingAttributeTabType
642 ,OkcPAV_PRICING_ATTRIBUTE90 OkcPAV_PricingAttributeTabType
643 ,OkcPAV_PRICING_ATTRIBUTE91 OkcPAV_PricingAttributeTabType
644 ,OkcPAV_PRICING_ATTRIBUTE92 OkcPAV_PricingAttributeTabType
645 ,OkcPAV_PRICING_ATTRIBUTE93 OkcPAV_PricingAttributeTabType
646 ,OkcPAV_PRICING_ATTRIBUTE94 OkcPAV_PricingAttributeTabType
647 ,OkcPAV_PRICING_ATTRIBUTE95 OkcPAV_PricingAttributeTabType
648 ,OkcPAV_PRICING_ATTRIBUTE96 OkcPAV_PricingAttributeTabType
649 ,OkcPAV_PRICING_ATTRIBUTE97 OkcPAV_PricingAttributeTabType
650 ,OkcPAV_PRICING_ATTRIBUTE98 OkcPAV_PricingAttributeTabType
651 ,OkcPAV_PRICING_ATTRIBUTE99 OkcPAV_PricingAttributeTabType
652 ,OkcPAV_PRICING_ATTRIBUTE100 OkcPAV_PricingAttributeTabType
653 ,OkcPAV_QUALIFIER_CONTEXT OkcPAV_QualifierContextTabType
654 ,OkcPAV_QUALIFIER_ATTRIBUTE1 OkcPAV_QualifAttributeTabType
655 ,OkcPAV_QUALIFIER_ATTRIBUTE2 OkcPAV_QualifAttributeTabType
656 ,OkcPAV_QUALIFIER_ATTRIBUTE3 OkcPAV_QualifAttributeTabType
657 ,OkcPAV_QUALIFIER_ATTRIBUTE4 OkcPAV_QualifAttributeTabType
658 ,OkcPAV_QUALIFIER_ATTRIBUTE5 OkcPAV_QualifAttributeTabType
659 ,OkcPAV_QUALIFIER_ATTRIBUTE6 OkcPAV_QualifAttributeTabType
660 ,OkcPAV_QUALIFIER_ATTRIBUTE7 OkcPAV_QualifAttributeTabType
661 ,OkcPAV_QUALIFIER_ATTRIBUTE8 OkcPAV_QualifAttributeTabType
662 ,OkcPAV_QUALIFIER_ATTRIBUTE9 OkcPAV_QualifAttributeTabType
663 ,OkcPAV_QUALIFIER_ATTRIBUTE10 OkcPAV_QualifAttributeTabType
664 ,OkcPAV_QUALIFIER_ATTRIBUTE11 OkcPAV_QualifAttributeTabType
665 ,OkcPAV_QUALIFIER_ATTRIBUTE12 OkcPAV_QualifAttributeTabType
666 ,OkcPAV_QUALIFIER_ATTRIBUTE13 OkcPAV_QualifAttributeTabType
667 ,OkcPAV_QUALIFIER_ATTRIBUTE14 OkcPAV_QualifAttributeTabType
668 ,OkcPAV_QUALIFIER_ATTRIBUTE15 OkcPAV_QualifAttributeTabType
669 ,OkcPAV_QUALIFIER_ATTRIBUTE16 OkcPAV_QualifAttributeTabType
670 ,OkcPAV_QUALIFIER_ATTRIBUTE17 OkcPAV_QualifAttributeTabType
671 ,OkcPAV_QUALIFIER_ATTRIBUTE18 OkcPAV_QualifAttributeTabType
672 ,OkcPAV_QUALIFIER_ATTRIBUTE19 OkcPAV_QualifAttributeTabType
673 ,OkcPAV_QUALIFIER_ATTRIBUTE20 OkcPAV_QualifAttributeTabType
674 ,OkcPAV_QUALIFIER_ATTRIBUTE21 OkcPAV_QualifAttributeTabType
675 ,OkcPAV_QUALIFIER_ATTRIBUTE22 OkcPAV_QualifAttributeTabType
676 ,OkcPAV_QUALIFIER_ATTRIBUTE23 OkcPAV_QualifAttributeTabType
677 ,OkcPAV_QUALIFIER_ATTRIBUTE24 OkcPAV_QualifAttributeTabType
678 ,OkcPAV_QUALIFIER_ATTRIBUTE25 OkcPAV_QualifAttributeTabType
679 ,OkcPAV_QUALIFIER_ATTRIBUTE26 OkcPAV_QualifAttributeTabType
680 ,OkcPAV_QUALIFIER_ATTRIBUTE27 OkcPAV_QualifAttributeTabType
681 ,OkcPAV_QUALIFIER_ATTRIBUTE28 OkcPAV_QualifAttributeTabType
682 ,OkcPAV_QUALIFIER_ATTRIBUTE29 OkcPAV_QualifAttributeTabType
683 ,OkcPAV_QUALIFIER_ATTRIBUTE30 OkcPAV_QualifAttributeTabType
684 ,OkcPAV_QUALIFIER_ATTRIBUTE31 OkcPAV_QualifAttributeTabType
685 ,OkcPAV_QUALIFIER_ATTRIBUTE32 OkcPAV_QualifAttributeTabType
686 ,OkcPAV_QUALIFIER_ATTRIBUTE33 OkcPAV_QualifAttributeTabType
687 ,OkcPAV_QUALIFIER_ATTRIBUTE34 OkcPAV_QualifAttributeTabType
688 ,OkcPAV_QUALIFIER_ATTRIBUTE35 OkcPAV_QualifAttributeTabType
689 ,OkcPAV_QUALIFIER_ATTRIBUTE36 OkcPAV_QualifAttributeTabType
690 ,OkcPAV_QUALIFIER_ATTRIBUTE37 OkcPAV_QualifAttributeTabType
691 ,OkcPAV_QUALIFIER_ATTRIBUTE38 OkcPAV_QualifAttributeTabType
692 ,OkcPAV_QUALIFIER_ATTRIBUTE39 OkcPAV_QualifAttributeTabType
693 ,OkcPAV_QUALIFIER_ATTRIBUTE40 OkcPAV_QualifAttributeTabType
694 ,OkcPAV_QUALIFIER_ATTRIBUTE41 OkcPAV_QualifAttributeTabType
695 ,OkcPAV_QUALIFIER_ATTRIBUTE42 OkcPAV_QualifAttributeTabType
696 ,OkcPAV_QUALIFIER_ATTRIBUTE43 OkcPAV_QualifAttributeTabType
697 ,OkcPAV_QUALIFIER_ATTRIBUTE44 OkcPAV_QualifAttributeTabType
698 ,OkcPAV_QUALIFIER_ATTRIBUTE45 OkcPAV_QualifAttributeTabType
699 ,OkcPAV_QUALIFIER_ATTRIBUTE46 OkcPAV_QualifAttributeTabType
700 ,OkcPAV_QUALIFIER_ATTRIBUTE47 OkcPAV_QualifAttributeTabType
701 ,OkcPAV_QUALIFIER_ATTRIBUTE48 OkcPAV_QualifAttributeTabType
702 ,OkcPAV_QUALIFIER_ATTRIBUTE49 OkcPAV_QualifAttributeTabType
703 ,OkcPAV_QUALIFIER_ATTRIBUTE50 OkcPAV_QualifAttributeTabType
704 ,OkcPAV_QUALIFIER_ATTRIBUTE51 OkcPAV_QualifAttributeTabType
705 ,OkcPAV_QUALIFIER_ATTRIBUTE52 OkcPAV_QualifAttributeTabType
706 ,OkcPAV_QUALIFIER_ATTRIBUTE53 OkcPAV_QualifAttributeTabType
707 ,OkcPAV_QUALIFIER_ATTRIBUTE54 OkcPAV_QualifAttributeTabType
708 ,OkcPAV_QUALIFIER_ATTRIBUTE55 OkcPAV_QualifAttributeTabType
709 ,OkcPAV_QUALIFIER_ATTRIBUTE56 OkcPAV_QualifAttributeTabType
710 ,OkcPAV_QUALIFIER_ATTRIBUTE57 OkcPAV_QualifAttributeTabType
711 ,OkcPAV_QUALIFIER_ATTRIBUTE58 OkcPAV_QualifAttributeTabType
712 ,OkcPAV_QUALIFIER_ATTRIBUTE59 OkcPAV_QualifAttributeTabType
713 ,OkcPAV_QUALIFIER_ATTRIBUTE60 OkcPAV_QualifAttributeTabType
714 ,OkcPAV_QUALIFIER_ATTRIBUTE61 OkcPAV_QualifAttributeTabType
715 ,OkcPAV_QUALIFIER_ATTRIBUTE62 OkcPAV_QualifAttributeTabType
716 ,OkcPAV_QUALIFIER_ATTRIBUTE63 OkcPAV_QualifAttributeTabType
717 ,OkcPAV_QUALIFIER_ATTRIBUTE64 OkcPAV_QualifAttributeTabType
718 ,OkcPAV_QUALIFIER_ATTRIBUTE65 OkcPAV_QualifAttributeTabType
719 ,OkcPAV_QUALIFIER_ATTRIBUTE66 OkcPAV_QualifAttributeTabType
720 ,OkcPAV_QUALIFIER_ATTRIBUTE67 OkcPAV_QualifAttributeTabType
721 ,OkcPAV_QUALIFIER_ATTRIBUTE68 OkcPAV_QualifAttributeTabType
722 ,OkcPAV_QUALIFIER_ATTRIBUTE69 OkcPAV_QualifAttributeTabType
723 ,OkcPAV_QUALIFIER_ATTRIBUTE70 OkcPAV_QualifAttributeTabType
724 ,OkcPAV_QUALIFIER_ATTRIBUTE71 OkcPAV_QualifAttributeTabType
725 ,OkcPAV_QUALIFIER_ATTRIBUTE72 OkcPAV_QualifAttributeTabType
726 ,OkcPAV_QUALIFIER_ATTRIBUTE73 OkcPAV_QualifAttributeTabType
727 ,OkcPAV_QUALIFIER_ATTRIBUTE74 OkcPAV_QualifAttributeTabType
728 ,OkcPAV_QUALIFIER_ATTRIBUTE75 OkcPAV_QualifAttributeTabType
729 ,OkcPAV_QUALIFIER_ATTRIBUTE76 OkcPAV_QualifAttributeTabType
730 ,OkcPAV_QUALIFIER_ATTRIBUTE77 OkcPAV_QualifAttributeTabType
731 ,OkcPAV_QUALIFIER_ATTRIBUTE78 OkcPAV_QualifAttributeTabType
732 ,OkcPAV_QUALIFIER_ATTRIBUTE79 OkcPAV_QualifAttributeTabType
733 ,OkcPAV_QUALIFIER_ATTRIBUTE80 OkcPAV_QualifAttributeTabType
734 ,OkcPAV_QUALIFIER_ATTRIBUTE81 OkcPAV_QualifAttributeTabType
735 ,OkcPAV_QUALIFIER_ATTRIBUTE82 OkcPAV_QualifAttributeTabType
736 ,OkcPAV_QUALIFIER_ATTRIBUTE83 OkcPAV_QualifAttributeTabType
737 ,OkcPAV_QUALIFIER_ATTRIBUTE84 OkcPAV_QualifAttributeTabType
738 ,OkcPAV_QUALIFIER_ATTRIBUTE85 OkcPAV_QualifAttributeTabType
739 ,OkcPAV_QUALIFIER_ATTRIBUTE86 OkcPAV_QualifAttributeTabType
740 ,OkcPAV_QUALIFIER_ATTRIBUTE87 OkcPAV_QualifAttributeTabType
741 ,OkcPAV_QUALIFIER_ATTRIBUTE88 OkcPAV_QualifAttributeTabType
742 ,OkcPAV_QUALIFIER_ATTRIBUTE89 OkcPAV_QualifAttributeTabType
743 ,OkcPAV_QUALIFIER_ATTRIBUTE90 OkcPAV_QualifAttributeTabType
744 ,OkcPAV_QUALIFIER_ATTRIBUTE91 OkcPAV_QualifAttributeTabType
745 ,OkcPAV_QUALIFIER_ATTRIBUTE92 OkcPAV_QualifAttributeTabType
746 ,OkcPAV_QUALIFIER_ATTRIBUTE93 OkcPAV_QualifAttributeTabType
747 ,OkcPAV_QUALIFIER_ATTRIBUTE94 OkcPAV_QualifAttributeTabType
748 ,OkcPAV_QUALIFIER_ATTRIBUTE95 OkcPAV_QualifAttributeTabType
749 ,OkcPAV_QUALIFIER_ATTRIBUTE96 OkcPAV_QualifAttributeTabType
750 ,OkcPAV_QUALIFIER_ATTRIBUTE97 OkcPAV_QualifAttributeTabType
751 ,OkcPAV_QUALIFIER_ATTRIBUTE98 OkcPAV_QualifAttributeTabType
752 ,OkcPAV_QUALIFIER_ATTRIBUTE99 OkcPAV_QualifAttributeTabType
753 ,OkcPAV_QUALIFIER_ATTRIBUTE100 OkcPAV_QualifAttributeTabType
754 ,OkcPAV_SECURITY_GROUP_ID NumTabType
755 ,OkcPAV_PROGRAM_APPLICATION_ID NumTabType
756 ,OkcPAV_PROGRAM_ID NumTabType
757 ,OkcPAV_PROGRAM_UPDATE_DATE DateTabType
758 ,OkcPAV_REQUEST_ID NumTabType
759 ,OkcPAV_OBJECT_VERSION_NUMBER NumTabType
760 );
761
762 OkcPAVRecTab OkcPAVRecTabType;
763
764 --------------------------------------------------------------------
765
766 ---Table datatypes for OKC_PRICE_ADJUSTMENTS columns-----------------
767 TYPE OkcPA_AttributeTabType IS TABLE OF OKC_PRICE_ADJUSTMENTS.ATTRIBUTE1%TYPE;
768 TYPE OkcPA_ListLineNoTabType IS TABLE OF OKC_PRICE_ADJUSTMENTS.LIST_LINE_NO%TYPE;
769
770 ---Record of Tables datatype for OKC_PRICE_ADJUSTMENTS---------------
771 TYPE OkcPARecTabType IS RECORD
772 (
773 OkcPA_OldID NumTabType
774 ,OkcPA_NewID NumTabType
775 ,OkcPA_PAT_ID NumTabType
776 ,OkcPA_NewChrID NumTabType
777 ,OkcPA_NewCleID NumTabType
778 ,OkcPA_BSL_ID NumTabType
779 ,OkcPA_BCL_ID NumTabType
780 ,OkcPA_MODIFIED_FROM NumTabType
781 ,OkcPA_MODIFIED_TO NumTabType
782 ,OkcPA_MODIF_MECHNSM_TYPE_CODE Varchar2_90_TabType
783 ,OkcPA_OPERAND NumTabType
784 ,OkcPA_ARITHMETIC_OPERATOR Varchar2_90_TabType
785 ,OkcPA_AUTOMATIC_FLAG YNTabType
786 ,OkcPA_UPDATE_ALLOWED YNTabType
787 ,OkcPA_UPDATED_FLAG YNTabType
788 ,OkcPA_APPLIED_FLAG YNTabType
789 ,OkcPA_ON_INVOICE_FLAG YNTabType
790 ,OkcPA_PRICING_PHASE_ID NumTabType
791 ,OkcPA_CONTEXT Varchar2_90_TabType
792 ,OkcPA_ATTRIBUTE1 OkcPA_AttributeTabType
793 ,OkcPA_ATTRIBUTE2 OkcPA_AttributeTabType
794 ,OkcPA_ATTRIBUTE3 OkcPA_AttributeTabType
795 ,OkcPA_ATTRIBUTE4 OkcPA_AttributeTabType
796 ,OkcPA_ATTRIBUTE5 OkcPA_AttributeTabType
797 ,OkcPA_ATTRIBUTE6 OkcPA_AttributeTabType
798 ,OkcPA_ATTRIBUTE7 OkcPA_AttributeTabType
799 ,OkcPA_ATTRIBUTE8 OkcPA_AttributeTabType
800 ,OkcPA_ATTRIBUTE9 OkcPA_AttributeTabType
801 ,OkcPA_ATTRIBUTE10 OkcPA_AttributeTabType
802 ,OkcPA_ATTRIBUTE11 OkcPA_AttributeTabType
803 ,OkcPA_ATTRIBUTE12 OkcPA_AttributeTabType
804 ,OkcPA_ATTRIBUTE13 OkcPA_AttributeTabType
805 ,OkcPA_ATTRIBUTE14 OkcPA_AttributeTabType
806 ,OkcPA_ATTRIBUTE15 OkcPA_AttributeTabType
807 ,OkcPA_SECURITY_GROUP_ID NumTabType
808 ,OkcPA_PROGRAM_APPLICATION_ID NumTabType
809 ,OkcPA_PROGRAM_ID NumTabType
810 ,OkcPA_PROGRAM_UPDATE_DATE DateTabType
811 ,OkcPA_REQUEST_ID NumTabType
812 ,OkcPA_OBJECT_VERSION_NUMBER NumTabType
813 ,OkcPA_LIST_HEADER_ID NumTabType
814 ,OkcPA_LIST_LINE_ID NumTabType
815 ,OkcPA_LIST_LINE_TYPE_CODE Varchar2_90_TabType
816 ,OkcPA_CHANGE_REASON_CODE Varchar2_90_TabType
817 ,OkcPA_CHANGE_REASON_TEXT Varchar2_2000_TabType
818 ,OkcPA_ESTIMATED_FLAG YNTabType
819 ,OkcPA_ADJUSTED_AMOUNT NumTabType
820 ,OkcPA_CHARGE_TYPE_CODE Varchar2_90_TabType
821 ,OkcPA_CHARGE_SUBTYPE_CODE Varchar2_90_TabType
822 ,OkcPA_RANGE_BREAK_QUANTITY NumTabType
823 ,OkcPA_ACCRUAL_CONVERSION_RATE NumTabType
824 ,OkcPA_PRICING_GROUP_SEQUENCE NumTabType
825 ,OkcPA_ACCRUAL_FLAG YNTabType
826 ,OkcPA_LIST_LINE_NO OKCPA_ListLineNoTabType
827 ,OkcPA_SOURCE_SYSTEM_CODE Varchar2_90_TabType
828 ,OkcPA_BENEFIT_QTY NumTabType
829 ,OkcPA_BENEFIT_UOM_CODE YNTabType
830 ,OkcPA_EXPIRATION_DATE DateTabType
831 ,OkcPA_MODIFIER_LEVEL_CODE Varchar2_90_TabType
832 ,OkcPA_PRICE_BREAK_TYPE_CODE Varchar2_90_TabType
833 ,OkcPA_SUBSTITUTION_ATTRIBUTE Varchar2_90_TabType
834 ,OkcPA_PRORATION_TYPE_CODE Varchar2_90_TabType
835 ,OkcPA_INCLUDE_ON_RETURNS_FLAG YNTabType
836 ,OkcPA_REBATE_TRXN_TYPE_CODE Varchar2_30_TabType
837 );
838
839 OkcPARecTab OkcPARecTabType;
840 --------------------------------------------------------
841
842
843 ---Record of tables datatype for OKS_K_LINES_TL--------------
844 TYPE OksTLRecTabType IS RECORD(
845 OksTL_OldID NumTabType
846 ,OksTL_NewID NumTabType
847 ,OksTL_LANGUAGE LanguageTabType
848 ,OksTL_SOURCE_LANG LanguageTabType
849 ,OksTL_SFWT_FLAG YNTabType
850 ,OksTL_INVOICE_TEXT Varchar2_2000_TabType
851 ,OksTL_IB_TRX_DETAILS Varchar2_2000_TabType
852 ,OksTL_STATUS_TEXT Varchar2_450_TabType
853 ,OksTL_REACT_TIME_NAME Varchar2_450_TabType
854 ,OksTL_SECURITY_GROUP_ID NumTabType
855 );
856
857 OksTLRecTab OksTLRecTabType;
858 -------------------------------------------------------------
859
860 -----Table datatypes for OKS_REV_DISTRIBUTIONS columns--------
861 TYPE OksRD_AccountClassTabType IS TABLE OF OKS_REV_DISTRIBUTIONS.ACCOUNT_CLASS%TYPE;
862
863 -----Record of Tables datatype for OKS_REV_DISTRIBUTIONS-----------
864 TYPE OksRDRecTabType IS RECORD (
865 OksRD_OldID NumTabType
866 ,OksRD_NewID NumTabType
867 ,OksRD_NewChrID NumTabType
868 ,OksRD_NewCleID NumTabType
869 ,OksRD_ACCOUNT_CLASS OksRD_AccountClassTabType
870 ,OksRD_CODE_COMBINATION_ID NumTabType
871 ,OksRD_PERCENT NumTabType
872 ,OksRD_OBJECT_VERSION_NUMBER NumTabType
873 ,OksRD_SECURITY_GROUP_ID NumTabType
874 );
875
876 OksRDRecTab OksRDRecTabType;
877 -------------------------------------------------------------------
878
879 -----Table datatypes for OKS_QUALIFIERS columns--------------------
880 TYPE OksQ_QualifDataTypeTabType IS TABLE OF OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE;
881
882 -------------------------------------------------------------------
883
884 -----Record of tables datatype for OKS_QUALIFIERS-----------------
885 TYPE OksQRecTabType IS RECORD (
886 OksQ_OldQualifierID NumTabType
887 ,OksQ_NewQualifierID NumTabType
888 ,OksQ_REQUEST_ID NumTabType
889 ,OksQ_PROGRAM_APPLICATION_ID NumTabType
890 ,OksQ_PROGRAM_ID NumTabType
891 ,OksQ_PROGRAM_UPDATE_DATE DateTabType
892 ,OksQ_QUALIFIER_GROUPING_NO NumTabType
893 ,OksQ_QUALIFIER_CONTEXT Varchar2_30_TabType
894 ,OksQ_QUALIFIER_ATTRIBUTE Varchar2_30_TabType
895 ,OksQ_QUALIFIER_ATTR_VALUE Varchar2_240_TabType
896 ,OksQ_COMPARISON_OPERATOR_CODE Varchar2_30_TabType
897 ,OksQ_EXCLUDER_FLAG YNTabType
898 ,OksQ_QUALIFIER_RULE_ID NumTabType
899 ,OksQ_START_DATE_ACTIVE DateTabType
900 ,OksQ_END_DATE_ACTIVE DateTabType
901 ,OksQ_CREATED_FROM_RULE_ID NumTabType
902 ,OksQ_QUALIFIER_PRECEDENCE NumTabType
903 ,OksQ_NewListHeaderID NumTabType
904 ,OksQ_NewListLineID NumTabType
905 ,OksQ_QUALIFIER_DATATYPE OksQ_QualifDataTypeTabType
906 ,OksQ_QUALIFIER_ATTR_VALUE_TO Varchar2_240_TabType
907 ,OksQ_CONTEXT Varchar2_30_TabType
908 ,OksQ_ATTRIBUTE1 Varchar2_240_TabType
909 ,OksQ_ATTRIBUTE2 Varchar2_240_TabType
910 ,OksQ_ATTRIBUTE3 Varchar2_240_TabType
911 ,OksQ_ATTRIBUTE4 Varchar2_240_TabType
912 ,OksQ_ATTRIBUTE5 Varchar2_240_TabType
913 ,OksQ_ATTRIBUTE6 Varchar2_240_TabType
914 ,OksQ_ATTRIBUTE7 Varchar2_240_TabType
915 ,OksQ_ATTRIBUTE8 Varchar2_240_TabType
916 ,OksQ_ATTRIBUTE9 Varchar2_240_TabType
917 ,OksQ_ATTRIBUTE10 Varchar2_240_TabType
918 ,OksQ_ATTRIBUTE11 Varchar2_240_TabType
919 ,OksQ_ATTRIBUTE12 Varchar2_240_TabType
920 ,OksQ_ATTRIBUTE13 Varchar2_240_TabType
921 ,OksQ_ATTRIBUTE14 Varchar2_240_TabType
922 ,OksQ_ATTRIBUTE15 Varchar2_240_TabType
923 ,OksQ_ACTIVE_FLAG YNTabType
924 ,OksQ_LIST_TYPE_CODE Varchar2_30_TabType
925 ,OksQ_QUAL_ATTRVALUE_FROM_NUM NumTabType
926 ,OksQ_QUAL_ATTRVALUE_TO_NUM NumTabType
927 ,OksQ_SECURITY_GROUP_ID NumTabType
928 );
929
930 OksQRecTab OksQRecTabType;
931
932 -----Record of tables datatype for OKS_COVERAGE_TIMEZONES-----------------
933 TYPE OksCTZRecTabType IS RECORD (
934 OksCTZ_OldID NumTabType
935 ,OksCTZ_NewID NumTabType
936 ,OksCTZ_NewCleID NumTabType
937 ,OksCTZ_DEFAULT_YN FlagTabType
938 ,OksCTZ_TIMEZONE_ID NumTabType
939 ,OksCTZ_NewDnzChrID NumTabType
940 ,OksCTZ_SECURITY_GROUP_ID NumTabType
941 ,OksCTZ_PROGRAM_APPLICATION_ID NumTabType
942 ,OksCTZ_PROGRAM_ID NumTabType
943 ,OksCTZ_PROGRAM_UPDATE_DATE DateTabType
944 ,OksCTZ_REQUEST_ID NumTabType
945 ,OksCTZ_OBJECT_VERSION_NUMBER NumTabType
946 ,OksCTZ_ORIG_SYSTEM_ID1 NumTabType
947 ,OksCTZ_ORIG_SYSTEM_SOURCE_CODE Varchar2_30_TabType
948 ,OksCTZ_ORIG_SYSTEM_REFERENCE1 Varchar2_30_TabType
949 );
950
951 OksCTZRecTab OksCTZRecTabType;
952
953 ------Record of tables datatype for OKS_COVERAGE_TIMES
954 TYPE OksCTRecTabType IS RECORD (
955 OksCT_OldID NumTabType
956 ,OksCT_NewID NumTabType
957 ,OksCT_NewDnzChrID NumTabType
958 ,OksCT_NewCovTzeLineID NumTabType
959 ,OksCT_START_HOUR NumTabType
960 ,OksCT_START_MINUTE NumTabType
961 ,OksCT_END_HOUR NumTabType
962 ,OksCT_END_MINUTE NumTabType
963 ,OksCT_MONDAY_YN FlagTabType
964 ,OksCT_TUESDAY_YN FlagTabType
965 ,OksCT_WEDNESDAY_YN FlagTabType
966 ,OksCT_THURSDAY_YN FlagTabType
967 ,OksCT_FRIDAY_YN FlagTabType
968 ,OksCT_SATURDAY_YN FlagTabType
969 ,OksCT_SUNDAY_YN FlagTabType
970 ,OksCT_SECURITY_GROUP_ID NumTabType
971 ,OksCT_PROGRAM_APPLICATION_ID NumTabType
972 ,OksCT_OBJECT_VERSION_NUMBER NumTabType
973 ,OksCT_PROGRAM_ID NumTabType
974 ,OksCT_PROGRAM_UPDATE_DATE DateTabType
975 ,OksCT_REQUEST_ID NumTabType
976 );
977 OksCTRecTab OksCTRecTabType;
978
979 -----Record of tables datatype for OKS_PM_ACTIVITIES------
980 TYPE OksPMARecTabType IS RECORD (
981 OksPMA_OldID NumTabType
982 ,OksPMA_NewID NumTabType
983 ,OksPMA_NewCleID NumTabType
984 ,OksPMA_NewDnzChrID NumTabType
985 ,OksPMA_ACTIVITY_ID NumTabType
986 ,OksPMA_SELECT_YN FlagTabType
987 ,OksPMA_CONF_REQ_YN FlagTabType
988 ,OksPMA_SCH_EXISTS_YN FlagTabType
989 ,OksPMA_PROGRAM_APPLICATION_ID NumTabType
990 ,OksPMA_PROGRAM_ID NumTabType
991 ,OksPMA_PROGRAM_UPDATE_DATE DateTabType
992 ,OksPMA_OBJECT_VERSION_NUMBER NumTabType
993 ,OksPMA_SECURITY_GROUP_ID NumTabType
994 ,OksPMA_REQUEST_ID NumTabType
995 ,OksPMA_ORIG_SYSTEM_ID1 NumTabType
996 ,OksPMA_ORIG_SYSTEM_SOURCE_CODE Varchar2_30_TabType
997 ,OksPMA_ORIG_SYSTEM_REFERENCE1 Varchar2_30_TabType
998 );
999
1000 OksPMARecTab OksPMARecTabType;
1001
1002 ----Record of tables datatype for OKS_PM_STREAM_LEVELS----
1003 TYPE OksPMSLRecTabType IS RECORD (
1004 OksPMSL_OldID NumTabType
1005 ,OksPMSL_NewID NumTabType
1006 ,OksPMSL_NewCleID NumTabType
1007 ,OksPMSL_NewDnzChrID NumTabType
1008 ,OksPMSL_NewActivityLineID NumTabType
1009 ,OksPMSL_SEQUENCE_NUMBER NumTabType
1010 ,OksPMSL_NUMBER_OF_OCCURENCES NumTabType
1011 ,OksPMSL_START_DATE DateTabType
1012 ,OksPMSL_END_DATE DateTabType
1013 ,OksPMSL_FREQUENCY NumTabType
1014 ,OksPMSL_FREQUENCY_UOM YNTabType
1015 ,OksPMSL_OFFSET_DURATION NumTabType
1016 ,OksPMSL_OFFSET_UOM YNTabType
1017 ,OksPMSL_AUTOSCHEDULE_YN FlagTabType
1018 ,OksPMSL_PROGRAM_APPLICATION_ID NumTabType
1019 ,OksPMSL_PROGRAM_ID NumTabType
1020 ,OksPMSL_PROGRAM_UPDATE_DATE DateTabType
1021 ,OksPMSL_OBJECT_VERSION_NUMBER NumTabType
1022 ,OksPMSL_SECURITY_GROUP_ID NumTabType
1023 ,OksPMSL_REQUEST_ID NumTabType
1024 ,OksPMSL_ORIG_SYSTEM_ID1 NumTabType
1025 ,OksPMSL_ORIG_SYS_SOURCE_CODE Varchar2_30_TabType
1026 ,OksPMSL_ORIG_SYS_REFERENCE1 Varchar2_30_TabType
1027 );
1028
1029 OksPMSLRecTab OksPMSLRecTabType;
1030
1031 -----Record of tables datatype for OKS_PM_SCHEDULES
1032 TYPE OksPMSCHRecTabType IS RECORD (
1033 OksPMSCH_OldID NumTabType
1034 ,OksPMSCH_NewID NumTabType
1035 ,OksPMSCH_RULE_ID NumTabType
1036 ,OksPMSCH_OBJECT_VERSION_NUMBER NumTabType
1037 ,OksPMSCH_NewDnzChrID NumTabType
1038 ,OksPMSCH_NewCleID NumTabType
1039 ,OksPMSCH_SCH_SEQUENCE NumTabType
1040 ,OksPMSCH_SCHEDULE_DATE DateTabType
1041 ,OksPMSCH_SCHEDULE_DATE_FROM DateTabType
1042 ,OksPMSCH_SCHEDULE_DATE_TO DateTabType
1043 ,OksPMSCH_PMA_RULE_ID NumTabType
1044 ,OksPMSCH_PMP_RULE_ID NumTabType
1045 ,OksPMSCH_NewActivityLineID NumTabType
1046 ,OksPMSCH_NewStreamLineID NumTabType
1047 ,OksPMSCH_SECURITY_GROUP_ID NumTabType
1048 ,OksPMSCH_PROG_APPLICATION_ID NumTabType
1049 ,OksPMSCH_PROGRAM_ID NumTabType
1050 ,OksPMSCH_PROGRAM_UPDATE_DATE DateTabType
1051 ,OksPMSCH_REQUEST_ID NumTabType
1052 );
1053
1054 OksPMSCHRecTab OksPMSCHRecTabType;
1055
1056 -----Record of tables datatype for OKS_ACTION_TIME_TYPES-------
1057 TYPE OksATTRecTabType IS RECORD (
1058 OksATT_OldID NumTabType
1059 ,OksATT_NewID NumTabType
1060 ,OksATT_NewCleID NumTabType
1061 ,OksATT_NewDnzChrID NumTabType
1062 ,OksATT_ACTION_TYPE_CODE Varchar2_30_TabType
1063 ,OksATT_SECURITY_GROUP_ID NumTabType
1064 ,OksATT_PROGRAM_APPLICATION_ID NumTabType
1065 ,OksATT_PROGRAM_ID NumTabType
1066 ,OksATT_PROGRAM_UPDATE_DATE DateTabType
1067 ,OksATT_REQUEST_ID NumTabType
1068 ,OksATT_OBJECT_VERSION_NUMBER NumTabType
1069 ,OksATT_ORIG_SYSTEM_ID1 NumTabType
1070 ,OksATT_ORIG_SYSTEM_SOURCE_CODE Varchar2_30_TabType
1071 ,OksATT_ORIG_SYSTEM_REFERENCE1 Varchar2_30_TabType
1072 );
1073 OksATTRecTab OksATTRecTabType;
1074
1075 ------Record of tables datatype for OKS_ACTION_TIMES------
1076 TYPE OksATRecTabType IS RECORD (
1077 OksAT_OldID NumTabType
1078 ,OksAT_NewID NumTabType
1079 ,OksAT_NewCovActionTypeID NumTabType
1080 ,OksAT_NewCleID NumTabType
1081 ,OksAT_NewDnzChrID NumTabType
1082 ,OksAT_UOM_CODE Varchar2_30_TabType
1083 ,OksAT_SUN_DURATION NumTabType
1084 ,OksAT_MON_DURATION NumTabType
1085 ,OksAT_TUE_DURATION NumTabType
1086 ,OksAT_WED_DURATION NumTabType
1087 ,OksAT_THU_DURATION NumTabType
1088 ,OksAT_FRI_DURATION NumTabType
1089 ,OksAT_SAT_DURATION NumTabType
1090 ,OksAT_SECURITY_GROUP_ID NumTabType
1091 ,OksAT_PROGRAM_APPLICATION_ID NumTabType
1092 ,OksAT_PROGRAM_ID NumTabType
1093 ,OksAT_PROGRAM_UPDATE_DATE DateTabType
1094 ,OksAT_REQUEST_ID NumTabType
1095 ,OksAT_OBJECT_VERSION_NUMBER NumTabType
1096 );
1097 OksATRecTab OksATRecTabType;
1098
1099 -----Record of tables datatype for OKS_STREAM_LEVELS_B----
1100 TYPE OksSLRecTabType IS RECORD (
1101 OksSL_OldID NumTabType
1102 ,OksSL_NewID NumTabType
1103 ,OksSL_NewChrId NumTabType
1104 ,OksSL_NewCleID NumTabType
1105 ,OksSL_NewDnzChrID NumTabType
1106 ,OksSL_SEQUENCE_NO NumTabType
1107 ,OksSL_UOM_CODE YNTabType
1108 ,OksSL_START_DATE DateTabType
1109 ,OksSL_END_DATE DateTabType
1110 ,OksSL_LEVEL_PERIODS NumTabType
1111 ,OksSL_UOM_PER_PERIOD NumTabType
1112 ,OksSL_ADVANCE_PERIODS NumTabType
1113 ,OksSL_LEVEL_AMOUNT NumTabType
1114 ,OksSL_INVOICE_OFFSET_DAYS NumTabType
1115 ,OksSL_INTERFACE_OFFSET_DAYS NumTabType
1116 ,OksSL_COMMENTS Varchar2_2000_TabType
1117 ,OksSL_DUE_ARR_YN FlagTabType
1118 ,OksSL_AMOUNT NumTabType
1119 ,OksSL_LINES_DETAILED_YN FlagTabType
1120 ,OksSL_OBJECT_VERSION_NUMBER NumTabType
1121 ,OksSL_SECURITY_GROUP_ID NumTabType
1122 ,OksSL_REQUEST_ID NumTabType
1123 ,OksSL_ORIG_SYSTEM_ID1 NumTabType
1124 ,OksSL_ORIG_SYSTEM_SOURCE_CODE Varchar2_30_TabType
1125 ,OksSL_ORIG_SYSTEM_REFERENCE1 Varchar2_30_TabType
1126 );
1127 OksSLRecTab OksSLRecTabType;
1128
1129 ----Record of tables datatype for OKS_LEVEL_ELEMENTS------
1130 TYPE OksLERecTabType IS RECORD (
1131 OksLE_OldID NumTabType
1132 ,OksLE_NewID NumTabType
1133 ,OksLE_SEQUENCE_NUMBER NumTabType
1134 ,OksLE_DATE_START DateTabType
1135 ,OksLE_AMOUNT NumTabType
1136 ,OksLE_DATE_RECEIVABLE_GL DateTabType
1137 ,OksLE_DATE_REVENUE_RULE_START DateTabType
1138 ,OksLE_DATE_TRANSACTION DateTabType
1139 ,OksLE_DATE_DUE DateTabType
1140 ,OksLE_DATE_PRINT DateTabType
1141 ,OksLE_DATE_TO_INTERFACE DateTabType
1142 ,OksLE_DATE_COMPLETED DateTabType
1143 ,OksLE_OBJECT_VERSION_NUMBER NumTabType
1144 ,OksLE_NewRulID NumTabType
1145 ,OksLE_SECURITY_GROUP_ID NumTabType
1146 ,OksLE_NewCleID NumTabType
1147 ,OksLE_NewDnzChrID NumTabType
1148 ,OksLE_NewParentCleID NumTabType
1149 ,OksLE_DATE_END DateTabType
1150 );
1151 OksLERecTab OksLERecTabType;
1152
1153 -----Record of tables datatype for OKS_K_SALES_CREDITS---------
1154 TYPE OksSCRecTabType IS RECORD (
1155 OksSC_OldID NumTabType
1156 ,OksSC_NewID NumTabType
1157 ,OksSC_PERCENT NumTabType
1158 ,OksSC_NewChrID NumTabType
1159 ,OksSC_NewCleId NumTabType
1160 ,OksSC_CTC_ID NumTabType
1161 ,OksSC_SALES_CREDIT_TYPE_ID1 Varchar2_40_TabType
1162 ,OksSC_SALES_CREDIT_TYPE_ID2 Varchar2_40_TabType
1163 ,OksSC_OBJECT_VERSION_NUMBER NumTabType
1164 ,OksSC_SECURITY_GROUP_ID NumTabType
1165 ,OksSC_SALES_GROUP_ID NumTabType
1166 );
1167 OksSCRecTab OksSCRecTabType;
1168
1169 -----Record of tables datatype for OKS_BILLRATE_SCHEDULES-----
1170 TYPE OksBSCHRecTabType IS RECORD (
1171 OksBSCH_OldID NumTabType
1172 ,OksBSCH_NewID NumTabType
1173 ,OksBSCH_NewCleId NumTabType
1174 ,OksBSCH_NewBTCleID NumTabType
1175 ,OksBSCH_NewDnzChrID NumTabType
1176 ,OksBSCH_START_HOUR NumTabType
1177 ,OksBSCH_START_MINUTE NumTabType
1178 ,OksBSCH_END_HOUR NumTabType
1179 ,OksBSCH_END_MINUTE NumTabType
1180 ,OksBSCH_MONDAY_FLAG FlagTabType
1181 ,OksBSCH_TUESDAY_FLAG FlagTabType
1182 ,OksBSCH_WEDNESDAY_FLAG FlagTabType
1183 ,OksBSCH_THURSDAY_FLAG FlagTabType
1184 ,OksBSCH_FRIDAY_FLAG FlagTabType
1185 ,OksBSCH_SATURDAY_FLAG FlagTabType
1186 ,OksBSCH_SUNDAY_FLAG FlagTabType
1187 ,OksBSCH_OBJECT1_ID1 Object1ID1TabType
1188 ,OksBSCH_OBJECT1_ID2 Object1ID2TabType
1189 ,OksBSCH_JTOT_OBJECT1_CODE JTOTObject1CodeTabType
1190 ,OksBSCH_BILL_RATE_CODE Varchar2_40_TabType
1191 ,OksBSCH_FLAT_RATE NumTabType
1192 ,OksBSCH_UOM YNTabType
1193 ,OksBSCH_HOLIDAY_YN FlagTabType
1194 ,OksBSCH_PCT_OVER_LIST_PRICE NumTabType
1195 ,OksBSCH_PRGRM_APPLICATION_ID NumTabType
1196 ,OksBSCH_PROGRAM_ID NumTabType
1197 ,OksBSCH_PROGRAM_UPDATE_DATE DateTabType
1198 ,OksBSCH_REQUEST_ID NumTabType
1199 ,OksBSCH_SECURITY_GROUP_ID NumTabType
1200 ,OksBSCH_OBJECT_VERSION_NUMBER NumTabType
1201 );
1202 OksBSCHRecTab OksBSCHRecTabType;
1203
1204 ------Record of tables datatype for OKC_OPERATION_LINES-------------
1205 TYPE OkcOLRecTabType IS RECORD (
1206 OkcOLID NumTabType
1207 ,OkcOLSELECT_YN YNTabType
1208 ,OkcOLPROCESS_FLAG FlagTabType
1209 ,OkcOLOIE_ID NumTabType
1210 ,OkcOLSUBJECT_CHR_ID NumTabType
1211 ,OkcOLOBJECT_CHR_ID NumTabType
1212 ,OkcOLSUBJECT_CLE_ID NumTabType
1213 ,OkcOLOBJECT_CLE_ID NumTabType
1214 ,OkcOLOBJECT_VERSION_NUMBER NumTabType
1215 ,OkcOLREQUEST_ID NumTabType
1216 ,OkcOLPROGRAM_APPLICATION_ID NumTabType
1217 ,OkcOLPROGRAM_ID NumTabType
1218 ,OkcOLPROGRAM_UPDATE_DATE DateTabType
1219 ,OkcOLSECURITY_GROUP_ID NumTabType
1220 ,OkcOLMESSAGE_CODE Varchar2_30_TabType
1221 ,OkcOLPARENT_OLE_ID NumTabType
1222 ,OkcOLACTIVE_YN YNTabType
1223 );
1224 OkcOLRecTab OkcOLRecTabType;
1225
1226 ---Commented the plsql table definition in package body and added in package spec for bug 14387486
1227 ----------------------------------------------------------------------------
1228 --PL/SQL Table to check the party has already copied.
1229 --If Yes give the new cpl_id ----Begins
1230 ----------------------------------------------------------------------------
1231 TYPE party_rec_type IS RECORD (
1232 old_cpl_id NUMBER := OKC_API.G_MISS_NUM,
1233 new_cpl_id NUMBER := OKC_API.G_MISS_NUM);
1234 TYPE party_tbl_type IS TABLE OF party_rec_type
1235 INDEX BY BINARY_INTEGER;
1236 g_party party_tbl_type;
1237
1238
1239 FUNCTION is_copy_allowed(p_chr_id IN NUMBER,p_sts_code IN VARCHAR2 DEFAULT NULL) RETURN BOOLEAN;
1240
1241 PROCEDURE copy_components(
1242 p_api_version IN NUMBER,
1243 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1244 x_return_status OUT NOCOPY VARCHAR2,
1245 x_msg_count OUT NOCOPY NUMBER,
1246 x_msg_data OUT NOCOPY VARCHAR2,
1247 p_from_chr_id IN NUMBER,
1248 p_to_chr_id IN NUMBER,
1249 p_contract_number IN VARCHAR2,
1250 p_contract_number_modifier IN VARCHAR2,
1251 p_to_template_yn IN VARCHAR2 DEFAULT 'N',
1252 p_components_tbl IN api_components_tbl,
1253 p_lines_tbl IN api_lines_tbl,
1254 p_change_status_YN IN VARCHAR2 DEFAULT 'Y',--Added for Update_Service requirement(Bug 4747648)
1255 --If 'Y', status of new line is default status
1256 --If 'N', status from Source Line is retained
1257 p_return_new_top_line_ID_YN IN VARCHAR2 DEFAULT 'N', --Added for Update_Service requirement(Bug 4747648)
1258 --If 'Y' then the new line IDs of the copied top lines need to be
1259 --published
1260 x_to_chr_id OUT NOCOPY NUMBER,
1261 p_published_line_ids_tbl OUT NOCOPY published_line_ids_tbl --Added for Update Service requirement(Bug 4747648)
1262 --This table will be populated if p_return_new_top_line_ID_YN = 'Y'
1263 ,p_include_cancelled_lines IN VARCHAR2 DEFAULT 'Y',
1264 p_include_terminated_lines IN VARCHAR2 DEFAULT 'Y'); /*modified for copy enhancement*/
1265
1266
1267 PROCEDURE copy_contract(
1268 p_api_version IN NUMBER,
1269 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1270 x_return_status OUT NOCOPY VARCHAR2,
1271 x_msg_count OUT NOCOPY NUMBER,
1272 x_msg_data OUT NOCOPY VARCHAR2,
1273 p_commit IN VARCHAR2 DEFAULT 'F',
1274 p_chr_id IN NUMBER,
1275 p_contract_number IN VARCHAR2,
1276 p_contract_number_modifier IN VARCHAR2,
1277 p_to_template_yn IN VARCHAR2,
1278 p_renew_ref_yn IN VARCHAR2,
1279 x_to_chr_id OUT NOCOPY NUMBER,
1280 p_include_cancelled_lines IN VARCHAR2 DEFAULT 'Y',
1281 p_include_terminated_lines IN VARCHAR2 DEFAULT 'Y');
1282
1283 PROCEDURE copy_contract_header(
1284 p_api_version IN NUMBER,
1285 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1286 x_return_status OUT NOCOPY VARCHAR2,
1287 x_msg_count OUT NOCOPY NUMBER,
1288 x_msg_data OUT NOCOPY VARCHAR2,
1289 p_from_chr_id IN NUMBER,
1290 p_contract_number IN VARCHAR2,
1291 p_contract_number_modifier IN VARCHAR2,
1292 p_to_template_yn IN VARCHAR2,
1293 p_renew_ref_yn IN VARCHAR2,
1294 x_to_chr_id OUT NOCOPY NUMBER);
1295
1296 /******Header Level events no longer supported****
1297 PROCEDURE copy_events(
1298 p_api_version IN NUMBER,
1299 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1300 x_return_status OUT NOCOPY VARCHAR2,
1301 x_msg_count OUT NOCOPY NUMBER,
1302 x_msg_data OUT NOCOPY VARCHAR2,
1303 p_cnh_id IN NUMBER,
1304 p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
1305 p_to_template_yn IN VARCHAR2,
1306 x_cnh_id OUT NOCOPY NUMBER);
1307 ****************************************************/
1308
1309 ---------------------------------Start New code for 12.0---------------------------------
1310
1311 /*======================================================================================
1312 --Copy_Lines: This procedure copies all lines and its details for a given Contract Header
1313 This pricedure is used in COPY_CONTRACT API.
1314 Parameters:
1315 P_From_Chr_ID: Header ID of the Source Contract
1316 P_To_Chr_ID : Header ID of the Target Contract
1317 P_Renew_Ref_YN : Parameter to indicate if this routine is being called in
1318 the context of Contract Renewal or regular Copy. Valid
1319 values are 'Y' and 'N'
1320 =======================================================================================*/
1321 PROCEDURE copy_lines(
1322 p_api_version IN NUMBER
1323 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1324 ,x_return_status OUT NOCOPY VARCHAR2
1325 ,x_msg_count OUT NOCOPY NUMBER
1326 ,x_msg_data OUT NOCOPY VARCHAR2
1327 ,P_From_Chr_ID IN NUMBER
1328 ,P_To_Chr_ID IN NUMBER
1329 ,P_Renew_Ref_YN IN VARCHAR2
1330 ,p_include_cancelled_lines IN VARCHAR2 DEFAULT 'Y'
1331 ,p_include_terminated_lines IN VARCHAR2 DEFAULT 'Y'); /*modified for copy enhancement*/
1332
1333
1334 /*======================================================================================
1335 --Copy_Lines: This procedure copies all lines that are selected by the user for Copy in the Copy UI
1336 and their details. This pricedure is used in COPY_COMPONENTS API.
1337 Parameters:
1338 P_From_Chr_ID: Header ID of the Source Contract
1339 P_To_Chr_ID : Header ID of the Target Contract
1340 P_Target_Contract_New_YN: Flag to indicate if the Target Contract was just created as part of Copy
1341 or was already present and only lines were copied to an existing target
1342 contract. Value for this parameter will be 'Y' if source contract is being
1343 copied to a new contract, 'N' if the copy is happening into an existing
1344 contract.
1345 This parameter would be initialized in this API to 'N' and
1346 get set to 'Y' immediately after the call to Copy_Contract_Header.
1347
1348 This parameter would be used in copy of:
1349 Price Attribute Values
1350 Price Adjustments
1351 Sales Credits
1352 Billing Schedules.
1353
1354 If value is 'N' these entities would be copied only for Lines
1355 else they would be copied for both Header and Lines.
1356 =========================================================================================*/
1357 PROCEDURE copy_line_components(
1358 p_api_version IN NUMBER
1359 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1360 ,x_return_status OUT NOCOPY VARCHAR2
1361 ,x_msg_count OUT NOCOPY NUMBER
1362 ,x_msg_data OUT NOCOPY VARCHAR2
1363 ,P_From_Chr_ID IN NUMBER
1364 ,P_To_Chr_ID IN NUMBER
1365 ,P_Target_Contract_New_YN IN VARCHAR2
1366 ,P_Lines_Tbl IN api_lines_tbl
1367 ,p_change_status_YN IN VARCHAR2 --Added for Update_Service requirement(Bug 4747648)
1368 --If 'Y', status of new line is default status
1369 --If 'N', status from Source Line is retained
1370 ,p_return_new_top_line_ID_YN IN VARCHAR2 --Added for Update_Service requirement(Bug 4747648)
1371 --If 'Y' then the new line IDs of the copied top lines need to be
1372 --published
1373 ,p_include_cancelled_lines IN VARCHAR2 DEFAULT 'Y'
1374 ,p_include_terminated_lines IN VARCHAR2 DEFAULT 'Y'); /*modified for copy enhancement*/
1375
1376 /*=======================================================================
1377 Returns 'Y' if the Contract has a Partial Period Setup else returns 'N'
1378 ========================================================================*/
1379
1380 Function ContractPPSetupEXISTS(P_Chr_ID IN NUMBER) RETURN VARCHAR2;
1381
1382 /*=========================================================================
1383 This procedure is being exposed so that it can be invoked from OKC_COPY_CONTRACT_PVT.update_template_Contract
1384 to support partial period uptake
1385 ==========================================================================*/
1386
1387 Procedure create_bsch_using_PPSetup(P_To_Chr_ID IN NUMBER
1388 ,P_From_Chr_ID IN NUMBER
1389 ,P_Partial_Copy_YN IN VARCHAR2
1390 ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
1391 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1392 ,x_return_status OUT NOCOPY VARCHAR2
1393 ,x_msg_count OUT NOCOPY NUMBER
1394 ,x_msg_data OUT NOCOPY VARCHAR2);
1395
1396 /***--Procedure moved to package OKS_UTIL_PUB
1397 Procedure create_transaction_extension(P_Api_Version IN NUMBER
1398 ,P_Init_Msg_List IN VARCHAR2
1399 ,P_Header_ID IN NUMBER
1400 ,P_Line_ID IN NUMBER
1401 ,P_Source_Trx_Ext_ID IN NUMBER
1402 ,P_Cust_Acct_ID IN NUMBER
1403 ,P_Bill_To_Site_Use_ID IN NUMBER
1404 ,x_entity_id OUT NOCOPY NUMBER
1405 ,x_msg_data OUT NOCOPY VARCHAR2
1406 ,x_msg_count OUT NOCOPY NUMBER
1407 ,x_return_status OUT NOCOPY VARCHAR2);
1408 ****/
1409
1410 --npalepu added on 18-may-2006 for bug # 5211482
1411 -------------------------------------------------------------------------------
1412 -- Procedure: chk_line_effectivity
1413 -- Purpose: This procedure checks the effectivity dates of source
1414 -- contract line and target contract line
1415 -- In Parameters: p_new_cle_id Target contract line id
1416 -- Out Parameters: x_return_status standard return status
1417 -- x_flag yes no flag
1418 -----------------------------------------------------------------------------
1419
1420 PROCEDURE chk_line_effectivity(p_new_cle_id IN NUMBER,
1421 x_flag OUT NOCOPY VARCHAR2,
1422 x_return_status OUT NOCOPY VARCHAR2
1423 );
1424 --end npalepu
1425
1426 END OKS_COPY_CONTRACT_PVT;