[Home] [Help]
PACKAGE: APPS.OKS_COPY_CONTRACT_PVT
Source
1 Package OKS_COPY_CONTRACT_PVT AS
2 /*$Header: OKSCOPYS.pls 120.35.12010000.2 2008/10/22 12:49:31 ssreekum 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 );
392 --------End of Record of Tables datatype for columns in OKC_K_LINES_B,OKS_K_LINES_B,OKC_K_ITEMS-----------------------
393 OKCOKSLinesRecTab OKCOKSLinesRecTabType;
394
395 --------Table datatypes for OKC_K_LINES_TL columns------------
396 TYPE OkcTL_NameTabType IS TABLE OF OKC_K_LINES_TL.NAME%TYPE;
397 TYPE OkcTL_CommentsTabType IS TABLE OF OKC_K_LINES_TL.COMMENTS%TYPE;
398 TYPE OkcTL_ItemDescTabType IS TABLE OF OKC_K_LINES_TL.ITEM_DESCRIPTION%TYPE;
399 TYPE OkcTL_Block23TxtTabType IS TABLE OF OKC_K_LINES_TL.BLOCK23TEXT%TYPE;
400 TYPE OkcTL_OkeBoeDescTabType IS TABLE OF OKC_K_LINES_TL.OKE_BOE_DESCRIPTION%TYPE;
401
402 --------Record of Tables datatype for OKC_K_LINES_TL------------
403 TYPE OKCLinesTLRecTabType IS RECORD
404 (
405 OkcTL_OldID NumTabType
406 ,OkcTL_NewID NumTabType
407 ,OkcTL_LANGUAGE LanguageTabType
408 ,OkcTL_SOURCE_LANG LanguageTabType
409 ,OkcTL_SFWT_FLAG YNTabType
410 ,OkcTL_NAME OkcTL_NameTabType
411 ,OkcTL_COMMENTS OkcTL_CommentsTabType
412 ,OkcTL_ITEM_DESCRIPTION OkcTL_ItemDescTabType
413 ,OkcTL_BLOCK23TEXT OkcTL_Block23TxtTabType
414 ,OkcTL_SECURITY_GROUP_ID NumTabType
415 ,OkcTL_OKE_BOE_DESCRIPTION OkcTL_OkeBoeDescTabType
416 ,OkcTL_COGNOMEN CognomenTabType
417 );
418
419 --------End of Record of Tables datatype for OKC_K_LINES_TL
420 OKCLinesTLRecTab OKCLinesTLRecTabType;
421
422 ------Table datatypes for OKC_K_PARTY_ROLES_B columns------------
423 TYPE OkcPRB_RLECodeTabType IS TABLE OF OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE;
424 TYPE OkcPRB_CodeTabType IS TABLE OF OKC_K_PARTY_ROLES_B.CODE%TYPE;
425 TYPE OkcPRB_FacilityTabType IS TABLE OF OKC_K_PARTY_ROLES_B.FACILITY%TYPE;
426 TYPE OkcPRB_MinorGrpLkupCodeTabType IS TABLE OF OKC_K_PARTY_ROLES_B.MINORITY_GROUP_LOOKUP_CODE%TYPE;
427
428 ------Record of Tables datatype for OKC_K_PARTY_ROLES_B----------
429 TYPE OkcPRBRecTabType IS RECORD
430 (OkcPRB_OldID NumTabType
431 ,OkcPRB_NewID NumTabType
432 ,OkcPRB_NewChrID NumTabType
433 ,OkcPRB_NewCleID NumTabType
434 ,OkcPRB_NewDnzChrID NumTabType
435 ,OkcPRB_RLE_CODE OkcPRB_RLECodeTabType
436 ,OkcPRB_OBJECT1_ID1 Object1ID1TabType
437 ,OkcPRB_OBJECT1_ID2 Object1ID2TabType
438 ,OkcPRB_JTOT_OBJECT1_CODE JTOTObject1CodeTabType
439 ,OkcPRB_OBJECT_VERSION_NUMBER NumTabType
440 ,OkcPRB_CODE OkcPRB_CodeTabType
441 ,OkcPRB_FACILITY OkcPRB_FacilityTabType
442 ,OkcPRB_MINOR_GROUP_LOOKUP_CODE OkcPRB_MinorGrpLkupCodeTabType
443 ,OkcPRB_SMALL_BUSINESS_FLAG YNTabType
444 ,OkcPRB_WOMEN_OWNED_FLAG YNTabType
445 ,OkcPRB_ATTRIBUTE_CATEGORY AttributeCategoryTabType
446 ,OkcPRB_ATTRIBUTE1 AttributeTabType
447 ,OkcPRB_ATTRIBUTE2 AttributeTabType
448 ,OkcPRB_ATTRIBUTE3 AttributeTabType
449 ,OkcPRB_ATTRIBUTE4 AttributeTabType
450 ,OkcPRB_ATTRIBUTE5 AttributeTabType
451 ,OkcPRB_ATTRIBUTE6 AttributeTabType
452 ,OkcPRB_ATTRIBUTE7 AttributeTabType
453 ,OkcPRB_ATTRIBUTE8 AttributeTabType
454 ,OkcPRB_ATTRIBUTE9 AttributeTabType
455 ,OkcPRB_ATTRIBUTE10 AttributeTabType
456 ,OkcPRB_ATTRIBUTE11 AttributeTabType
457 ,OkcPRB_ATTRIBUTE12 AttributeTabType
458 ,OkcPRB_ATTRIBUTE13 AttributeTabType
459 ,OkcPRB_ATTRIBUTE14 AttributeTabType
460 ,OkcPRB_ATTRIBUTE15 AttributeTabType
461 ,OkcPRB_SECURITY_GROUP_ID NumTabType
462 ,OkcPRB_CPL_ID NumTabType
463 ,OkcPRB_PRIMARY_YN FlagTabType
464 ,OkcPRB_BILL_TO_SITE_USE_ID NumTabType
465 ,OkcPRB_CUST_ACCT_ID NumTabType
466 ,OkcPRB_ORIG_SYSTEM_ID1 NumTabType
467 ,OkcPRB_ORIG_SYSTEM_REFERENCE1 OrigSystemRef1TabType
468 ,OkcPRB_ORIG_SYSTEM_SOURCE_CODE OrigSystemSourceCodeTabType
469 );
470
471 OkcPRBRecTab OkcPRBRecTabType;
472 ------End of Record of Tables datatype for OKC_K_PARTY_ROLES_B---
473
474 ------Table datatypes for OKC_K_PARTY_ROLES_TL------------------
475 TYPE OkcPRTL_AliasTabType IS TABLE OF OKC_K_PARTY_ROLES_TL.ALIAS%TYPE;
476
477 ------Record of tables datatype for OKC_K_PARTY_ROLES_TL----------
478 TYPE OkcPRTLRecTabType IS RECORD
479 (OkcPRTL_OldID NumTabType
480 ,OkcPRTL_NewID NumTabType
481 ,OkcPRTL_LANGUAGE LanguageTabType
482 ,OkcPRTL_SOURCE_LANG LanguageTabType
483 ,OkcPRTL_SFWT_FLAG YNTabType
484 ,OkcPRTL_COGNOMEN CognomenTabType
485 ,OkcPRTL_ALIAS OkcPRTL_AliasTabType
486 ,OkcPRTL_SECURITY_GROUP_ID NumTabType
487 );
488
489 OkcPRTLRecTab OkcPRTLRecTabType;
490 --------------------------------------------------------------------
491
492 -----Table datatypes for OKC_CONTACTS-----------------------------
493 TYPE OkcC_CroCodeTabType IS TABLE OF OKC_CONTACTS.CRO_CODE%TYPE;
494 TYPE OkcC_ResourceClassTabType IS TABLE OF OKC_CONTACTS.RESOURCE_CLASS%TYPE;
495
496 -----Record of tables datatype for OKC_CONTACTS------------------
497 TYPE OkcCRecTabType IS RECORD
498 (OkcC_OldID NumTabType
499 ,OkcC_NewID NumTabType
500 ,OkcC_NewCplID NumTabType
501 ,OkcC_CRO_CODE OkcC_CroCodeTabType
502 ,OkcC_NewDnzChrID NumTabType
503 ,OkcC_OBJECT1_ID1 Object1ID1TabType
504 ,OkcC_OBJECT1_ID2 Object1ID2TabType
505 ,OkcC_JTOT_OBJECT1_CODE JTOTObject1CodeTabType
506 ,OkcC_OBJECT_VERSION_NUMBER NumTabType
507 ,OkcC_CONTACT_SEQUENCE NumTabType
508 ,OkcC_ATTRIBUTE_CATEGORY AttributeCategoryTabType
509 ,OkcC_ATTRIBUTE1 AttributeTabType
510 ,OkcC_ATTRIBUTE2 AttributeTabType
511 ,OkcC_ATTRIBUTE3 AttributeTabType
512 ,OkcC_ATTRIBUTE4 AttributeTabType
513 ,OkcC_ATTRIBUTE5 AttributeTabType
514 ,OkcC_ATTRIBUTE6 AttributeTabType
515 ,OkcC_ATTRIBUTE7 AttributeTabType
516 ,OkcC_ATTRIBUTE8 AttributeTabType
517 ,OkcC_ATTRIBUTE9 AttributeTabType
518 ,OkcC_ATTRIBUTE10 AttributeTabType
519 ,OkcC_ATTRIBUTE11 AttributeTabType
520 ,OkcC_ATTRIBUTE12 AttributeTabType
521 ,OkcC_ATTRIBUTE13 AttributeTabType
522 ,OkcC_ATTRIBUTE14 AttributeTabType
523 ,OkcC_ATTRIBUTE15 AttributeTabType
524 ,OkcC_SECURITY_GROUP_ID NumTabType
525 ,OkcC_START_DATE DateTabType
526 ,OkcC_END_DATE DateTabType
527 ,OkcC_PRIMARY_YN FlagTabType
528 ,OkcC_RESOURCE_CLASS OkcC_ResourceClassTabType
529 ,OkcC_SALES_GROUP_ID NumTabType
530 );
531
532 OkcCRecTab OkcCRecTabType;
533 ------------------------------------------------------------------
534
535 ------Table Datatypes for OKC_PRICE_ATT_VALUES------------------
536 TYPE OkcPAV_FlexTitleTabType IS TABLE OF OKC_PRICE_ATT_VALUES.FLEX_TITLE%TYPE;
537 TYPE OkcPAV_PricingContextTabType IS TABLE OF OKC_PRICE_ATT_VALUES.PRICING_CONTEXT%TYPE;
538 TYPE OkcPAV_PricingAttributeTabType IS TABLE OF OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE1%TYPE;
539 TYPE OkcPAV_QualifierContextTabType IS TABLE OF OKC_PRICE_ATT_VALUES.QUALIFIER_CONTEXT%TYPE;
540 TYPE OkcPAV_QualifAttributeTabType IS TABLE OF OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE1%TYPE;
541
542
543 ------Record of tables datatype for OKC_PRICE_ATT_VALUES-------------
544 TYPE OkcPAVRecTabType IS RECORD
545 (
546 OkcPAV_OldID NumTabType
547 ,OkcPAV_NewID NumTabType
548 ,OkcPAV_FLEX_TITLE OkcPAV_FlexTitleTabType
549 ,OkcPAV_PRICING_CONTEXT OkcPAV_PricingContextTabType
550 ,OkcPAV_PRICING_ATTRIBUTE1 OkcPAV_PricingAttributeTabType
551 ,OkcPAV_NewChrID NumTabType
552 ,OkcPAV_PRICING_ATTRIBUTE2 OkcPAV_PricingAttributeTabType
553 ,OkcPAV_NewCleID NumTabType
554 ,OkcPAV_PRICING_ATTRIBUTE3 OkcPAV_PricingAttributeTabType
555 ,OkcPAV_PRICING_ATTRIBUTE4 OkcPAV_PricingAttributeTabType
556 ,OkcPAV_PRICING_ATTRIBUTE5 OkcPAV_PricingAttributeTabType
557 ,OkcPAV_PRICING_ATTRIBUTE6 OkcPAV_PricingAttributeTabType
558 ,OkcPAV_PRICING_ATTRIBUTE7 OkcPAV_PricingAttributeTabType
559 ,OkcPAV_PRICING_ATTRIBUTE8 OkcPAV_PricingAttributeTabType
560 ,OkcPAV_PRICING_ATTRIBUTE9 OkcPAV_PricingAttributeTabType
561 ,OkcPAV_PRICING_ATTRIBUTE10 OkcPAV_PricingAttributeTabType
562 ,OkcPAV_PRICING_ATTRIBUTE11 OkcPAV_PricingAttributeTabType
563 ,OkcPAV_PRICING_ATTRIBUTE12 OkcPAV_PricingAttributeTabType
564 ,OkcPAV_PRICING_ATTRIBUTE13 OkcPAV_PricingAttributeTabType
565 ,OkcPAV_PRICING_ATTRIBUTE14 OkcPAV_PricingAttributeTabType
566 ,OkcPAV_PRICING_ATTRIBUTE15 OkcPAV_PricingAttributeTabType
567 ,OkcPAV_PRICING_ATTRIBUTE16 OkcPAV_PricingAttributeTabType
568 ,OkcPAV_PRICING_ATTRIBUTE17 OkcPAV_PricingAttributeTabType
569 ,OkcPAV_PRICING_ATTRIBUTE18 OkcPAV_PricingAttributeTabType
570 ,OkcPAV_PRICING_ATTRIBUTE19 OkcPAV_PricingAttributeTabType
571 ,OkcPAV_PRICING_ATTRIBUTE20 OkcPAV_PricingAttributeTabType
572 ,OkcPAV_PRICING_ATTRIBUTE21 OkcPAV_PricingAttributeTabType
573 ,OkcPAV_PRICING_ATTRIBUTE22 OkcPAV_PricingAttributeTabType
574 ,OkcPAV_PRICING_ATTRIBUTE23 OkcPAV_PricingAttributeTabType
575 ,OkcPAV_PRICING_ATTRIBUTE24 OkcPAV_PricingAttributeTabType
576 ,OkcPAV_PRICING_ATTRIBUTE25 OkcPAV_PricingAttributeTabType
577 ,OkcPAV_PRICING_ATTRIBUTE26 OkcPAV_PricingAttributeTabType
578 ,OkcPAV_PRICING_ATTRIBUTE27 OkcPAV_PricingAttributeTabType
579 ,OkcPAV_PRICING_ATTRIBUTE28 OkcPAV_PricingAttributeTabType
580 ,OkcPAV_PRICING_ATTRIBUTE29 OkcPAV_PricingAttributeTabType
581 ,OkcPAV_PRICING_ATTRIBUTE30 OkcPAV_PricingAttributeTabType
582 ,OkcPAV_PRICING_ATTRIBUTE31 OkcPAV_PricingAttributeTabType
583 ,OkcPAV_PRICING_ATTRIBUTE32 OkcPAV_PricingAttributeTabType
584 ,OkcPAV_PRICING_ATTRIBUTE33 OkcPAV_PricingAttributeTabType
585 ,OkcPAV_PRICING_ATTRIBUTE34 OkcPAV_PricingAttributeTabType
586 ,OkcPAV_PRICING_ATTRIBUTE35 OkcPAV_PricingAttributeTabType
587 ,OkcPAV_PRICING_ATTRIBUTE36 OkcPAV_PricingAttributeTabType
588 ,OkcPAV_PRICING_ATTRIBUTE37 OkcPAV_PricingAttributeTabType
589 ,OkcPAV_PRICING_ATTRIBUTE38 OkcPAV_PricingAttributeTabType
590 ,OkcPAV_PRICING_ATTRIBUTE39 OkcPAV_PricingAttributeTabType
591 ,OkcPAV_PRICING_ATTRIBUTE40 OkcPAV_PricingAttributeTabType
592 ,OkcPAV_PRICING_ATTRIBUTE41 OkcPAV_PricingAttributeTabType
593 ,OkcPAV_PRICING_ATTRIBUTE42 OkcPAV_PricingAttributeTabType
594 ,OkcPAV_PRICING_ATTRIBUTE43 OkcPAV_PricingAttributeTabType
595 ,OkcPAV_PRICING_ATTRIBUTE44 OkcPAV_PricingAttributeTabType
596 ,OkcPAV_PRICING_ATTRIBUTE45 OkcPAV_PricingAttributeTabType
597 ,OkcPAV_PRICING_ATTRIBUTE46 OkcPAV_PricingAttributeTabType
598 ,OkcPAV_PRICING_ATTRIBUTE47 OkcPAV_PricingAttributeTabType
599 ,OkcPAV_PRICING_ATTRIBUTE48 OkcPAV_PricingAttributeTabType
600 ,OkcPAV_PRICING_ATTRIBUTE49 OkcPAV_PricingAttributeTabType
601 ,OkcPAV_PRICING_ATTRIBUTE50 OkcPAV_PricingAttributeTabType
602 ,OkcPAV_PRICING_ATTRIBUTE51 OkcPAV_PricingAttributeTabType
603 ,OkcPAV_PRICING_ATTRIBUTE52 OkcPAV_PricingAttributeTabType
604 ,OkcPAV_PRICING_ATTRIBUTE53 OkcPAV_PricingAttributeTabType
605 ,OkcPAV_PRICING_ATTRIBUTE54 OkcPAV_PricingAttributeTabType
606 ,OkcPAV_PRICING_ATTRIBUTE55 OkcPAV_PricingAttributeTabType
607 ,OkcPAV_PRICING_ATTRIBUTE56 OkcPAV_PricingAttributeTabType
608 ,OkcPAV_PRICING_ATTRIBUTE57 OkcPAV_PricingAttributeTabType
609 ,OkcPAV_PRICING_ATTRIBUTE58 OkcPAV_PricingAttributeTabType
610 ,OkcPAV_PRICING_ATTRIBUTE59 OkcPAV_PricingAttributeTabType
611 ,OkcPAV_PRICING_ATTRIBUTE60 OkcPAV_PricingAttributeTabType
612 ,OkcPAV_PRICING_ATTRIBUTE61 OkcPAV_PricingAttributeTabType
613 ,OkcPAV_PRICING_ATTRIBUTE62 OkcPAV_PricingAttributeTabType
614 ,OkcPAV_PRICING_ATTRIBUTE63 OkcPAV_PricingAttributeTabType
615 ,OkcPAV_PRICING_ATTRIBUTE64 OkcPAV_PricingAttributeTabType
616 ,OkcPAV_PRICING_ATTRIBUTE65 OkcPAV_PricingAttributeTabType
617 ,OkcPAV_PRICING_ATTRIBUTE66 OkcPAV_PricingAttributeTabType
618 ,OkcPAV_PRICING_ATTRIBUTE67 OkcPAV_PricingAttributeTabType
619 ,OkcPAV_PRICING_ATTRIBUTE68 OkcPAV_PricingAttributeTabType
620 ,OkcPAV_PRICING_ATTRIBUTE69 OkcPAV_PricingAttributeTabType
621 ,OkcPAV_PRICING_ATTRIBUTE70 OkcPAV_PricingAttributeTabType
622 ,OkcPAV_PRICING_ATTRIBUTE71 OkcPAV_PricingAttributeTabType
623 ,OkcPAV_PRICING_ATTRIBUTE72 OkcPAV_PricingAttributeTabType
624 ,OkcPAV_PRICING_ATTRIBUTE73 OkcPAV_PricingAttributeTabType
625 ,OkcPAV_PRICING_ATTRIBUTE74 OkcPAV_PricingAttributeTabType
626 ,OkcPAV_PRICING_ATTRIBUTE75 OkcPAV_PricingAttributeTabType
627 ,OkcPAV_PRICING_ATTRIBUTE76 OkcPAV_PricingAttributeTabType
628 ,OkcPAV_PRICING_ATTRIBUTE77 OkcPAV_PricingAttributeTabType
629 ,OkcPAV_PRICING_ATTRIBUTE78 OkcPAV_PricingAttributeTabType
630 ,OkcPAV_PRICING_ATTRIBUTE79 OkcPAV_PricingAttributeTabType
631 ,OkcPAV_PRICING_ATTRIBUTE80 OkcPAV_PricingAttributeTabType
632 ,OkcPAV_PRICING_ATTRIBUTE81 OkcPAV_PricingAttributeTabType
633 ,OkcPAV_PRICING_ATTRIBUTE82 OkcPAV_PricingAttributeTabType
634 ,OkcPAV_PRICING_ATTRIBUTE83 OkcPAV_PricingAttributeTabType
635 ,OkcPAV_PRICING_ATTRIBUTE84 OkcPAV_PricingAttributeTabType
636 ,OkcPAV_PRICING_ATTRIBUTE85 OkcPAV_PricingAttributeTabType
637 ,OkcPAV_PRICING_ATTRIBUTE86 OkcPAV_PricingAttributeTabType
638 ,OkcPAV_PRICING_ATTRIBUTE87 OkcPAV_PricingAttributeTabType
639 ,OkcPAV_PRICING_ATTRIBUTE88 OkcPAV_PricingAttributeTabType
640 ,OkcPAV_PRICING_ATTRIBUTE89 OkcPAV_PricingAttributeTabType
641 ,OkcPAV_PRICING_ATTRIBUTE90 OkcPAV_PricingAttributeTabType
642 ,OkcPAV_PRICING_ATTRIBUTE91 OkcPAV_PricingAttributeTabType
643 ,OkcPAV_PRICING_ATTRIBUTE92 OkcPAV_PricingAttributeTabType
644 ,OkcPAV_PRICING_ATTRIBUTE93 OkcPAV_PricingAttributeTabType
645 ,OkcPAV_PRICING_ATTRIBUTE94 OkcPAV_PricingAttributeTabType
646 ,OkcPAV_PRICING_ATTRIBUTE95 OkcPAV_PricingAttributeTabType
647 ,OkcPAV_PRICING_ATTRIBUTE96 OkcPAV_PricingAttributeTabType
648 ,OkcPAV_PRICING_ATTRIBUTE97 OkcPAV_PricingAttributeTabType
649 ,OkcPAV_PRICING_ATTRIBUTE98 OkcPAV_PricingAttributeTabType
650 ,OkcPAV_PRICING_ATTRIBUTE99 OkcPAV_PricingAttributeTabType
651 ,OkcPAV_PRICING_ATTRIBUTE100 OkcPAV_PricingAttributeTabType
652 ,OkcPAV_QUALIFIER_CONTEXT OkcPAV_QualifierContextTabType
653 ,OkcPAV_QUALIFIER_ATTRIBUTE1 OkcPAV_QualifAttributeTabType
654 ,OkcPAV_QUALIFIER_ATTRIBUTE2 OkcPAV_QualifAttributeTabType
655 ,OkcPAV_QUALIFIER_ATTRIBUTE3 OkcPAV_QualifAttributeTabType
656 ,OkcPAV_QUALIFIER_ATTRIBUTE4 OkcPAV_QualifAttributeTabType
657 ,OkcPAV_QUALIFIER_ATTRIBUTE5 OkcPAV_QualifAttributeTabType
658 ,OkcPAV_QUALIFIER_ATTRIBUTE6 OkcPAV_QualifAttributeTabType
659 ,OkcPAV_QUALIFIER_ATTRIBUTE7 OkcPAV_QualifAttributeTabType
660 ,OkcPAV_QUALIFIER_ATTRIBUTE8 OkcPAV_QualifAttributeTabType
661 ,OkcPAV_QUALIFIER_ATTRIBUTE9 OkcPAV_QualifAttributeTabType
662 ,OkcPAV_QUALIFIER_ATTRIBUTE10 OkcPAV_QualifAttributeTabType
663 ,OkcPAV_QUALIFIER_ATTRIBUTE11 OkcPAV_QualifAttributeTabType
664 ,OkcPAV_QUALIFIER_ATTRIBUTE12 OkcPAV_QualifAttributeTabType
665 ,OkcPAV_QUALIFIER_ATTRIBUTE13 OkcPAV_QualifAttributeTabType
666 ,OkcPAV_QUALIFIER_ATTRIBUTE14 OkcPAV_QualifAttributeTabType
667 ,OkcPAV_QUALIFIER_ATTRIBUTE15 OkcPAV_QualifAttributeTabType
668 ,OkcPAV_QUALIFIER_ATTRIBUTE16 OkcPAV_QualifAttributeTabType
669 ,OkcPAV_QUALIFIER_ATTRIBUTE17 OkcPAV_QualifAttributeTabType
670 ,OkcPAV_QUALIFIER_ATTRIBUTE18 OkcPAV_QualifAttributeTabType
671 ,OkcPAV_QUALIFIER_ATTRIBUTE19 OkcPAV_QualifAttributeTabType
672 ,OkcPAV_QUALIFIER_ATTRIBUTE20 OkcPAV_QualifAttributeTabType
673 ,OkcPAV_QUALIFIER_ATTRIBUTE21 OkcPAV_QualifAttributeTabType
674 ,OkcPAV_QUALIFIER_ATTRIBUTE22 OkcPAV_QualifAttributeTabType
675 ,OkcPAV_QUALIFIER_ATTRIBUTE23 OkcPAV_QualifAttributeTabType
676 ,OkcPAV_QUALIFIER_ATTRIBUTE24 OkcPAV_QualifAttributeTabType
677 ,OkcPAV_QUALIFIER_ATTRIBUTE25 OkcPAV_QualifAttributeTabType
678 ,OkcPAV_QUALIFIER_ATTRIBUTE26 OkcPAV_QualifAttributeTabType
679 ,OkcPAV_QUALIFIER_ATTRIBUTE27 OkcPAV_QualifAttributeTabType
680 ,OkcPAV_QUALIFIER_ATTRIBUTE28 OkcPAV_QualifAttributeTabType
681 ,OkcPAV_QUALIFIER_ATTRIBUTE29 OkcPAV_QualifAttributeTabType
682 ,OkcPAV_QUALIFIER_ATTRIBUTE30 OkcPAV_QualifAttributeTabType
683 ,OkcPAV_QUALIFIER_ATTRIBUTE31 OkcPAV_QualifAttributeTabType
684 ,OkcPAV_QUALIFIER_ATTRIBUTE32 OkcPAV_QualifAttributeTabType
685 ,OkcPAV_QUALIFIER_ATTRIBUTE33 OkcPAV_QualifAttributeTabType
686 ,OkcPAV_QUALIFIER_ATTRIBUTE34 OkcPAV_QualifAttributeTabType
687 ,OkcPAV_QUALIFIER_ATTRIBUTE35 OkcPAV_QualifAttributeTabType
688 ,OkcPAV_QUALIFIER_ATTRIBUTE36 OkcPAV_QualifAttributeTabType
689 ,OkcPAV_QUALIFIER_ATTRIBUTE37 OkcPAV_QualifAttributeTabType
690 ,OkcPAV_QUALIFIER_ATTRIBUTE38 OkcPAV_QualifAttributeTabType
691 ,OkcPAV_QUALIFIER_ATTRIBUTE39 OkcPAV_QualifAttributeTabType
692 ,OkcPAV_QUALIFIER_ATTRIBUTE40 OkcPAV_QualifAttributeTabType
693 ,OkcPAV_QUALIFIER_ATTRIBUTE41 OkcPAV_QualifAttributeTabType
694 ,OkcPAV_QUALIFIER_ATTRIBUTE42 OkcPAV_QualifAttributeTabType
695 ,OkcPAV_QUALIFIER_ATTRIBUTE43 OkcPAV_QualifAttributeTabType
696 ,OkcPAV_QUALIFIER_ATTRIBUTE44 OkcPAV_QualifAttributeTabType
697 ,OkcPAV_QUALIFIER_ATTRIBUTE45 OkcPAV_QualifAttributeTabType
698 ,OkcPAV_QUALIFIER_ATTRIBUTE46 OkcPAV_QualifAttributeTabType
699 ,OkcPAV_QUALIFIER_ATTRIBUTE47 OkcPAV_QualifAttributeTabType
700 ,OkcPAV_QUALIFIER_ATTRIBUTE48 OkcPAV_QualifAttributeTabType
701 ,OkcPAV_QUALIFIER_ATTRIBUTE49 OkcPAV_QualifAttributeTabType
702 ,OkcPAV_QUALIFIER_ATTRIBUTE50 OkcPAV_QualifAttributeTabType
703 ,OkcPAV_QUALIFIER_ATTRIBUTE51 OkcPAV_QualifAttributeTabType
704 ,OkcPAV_QUALIFIER_ATTRIBUTE52 OkcPAV_QualifAttributeTabType
705 ,OkcPAV_QUALIFIER_ATTRIBUTE53 OkcPAV_QualifAttributeTabType
706 ,OkcPAV_QUALIFIER_ATTRIBUTE54 OkcPAV_QualifAttributeTabType
707 ,OkcPAV_QUALIFIER_ATTRIBUTE55 OkcPAV_QualifAttributeTabType
708 ,OkcPAV_QUALIFIER_ATTRIBUTE56 OkcPAV_QualifAttributeTabType
709 ,OkcPAV_QUALIFIER_ATTRIBUTE57 OkcPAV_QualifAttributeTabType
710 ,OkcPAV_QUALIFIER_ATTRIBUTE58 OkcPAV_QualifAttributeTabType
711 ,OkcPAV_QUALIFIER_ATTRIBUTE59 OkcPAV_QualifAttributeTabType
712 ,OkcPAV_QUALIFIER_ATTRIBUTE60 OkcPAV_QualifAttributeTabType
713 ,OkcPAV_QUALIFIER_ATTRIBUTE61 OkcPAV_QualifAttributeTabType
714 ,OkcPAV_QUALIFIER_ATTRIBUTE62 OkcPAV_QualifAttributeTabType
715 ,OkcPAV_QUALIFIER_ATTRIBUTE63 OkcPAV_QualifAttributeTabType
716 ,OkcPAV_QUALIFIER_ATTRIBUTE64 OkcPAV_QualifAttributeTabType
717 ,OkcPAV_QUALIFIER_ATTRIBUTE65 OkcPAV_QualifAttributeTabType
718 ,OkcPAV_QUALIFIER_ATTRIBUTE66 OkcPAV_QualifAttributeTabType
719 ,OkcPAV_QUALIFIER_ATTRIBUTE67 OkcPAV_QualifAttributeTabType
720 ,OkcPAV_QUALIFIER_ATTRIBUTE68 OkcPAV_QualifAttributeTabType
721 ,OkcPAV_QUALIFIER_ATTRIBUTE69 OkcPAV_QualifAttributeTabType
722 ,OkcPAV_QUALIFIER_ATTRIBUTE70 OkcPAV_QualifAttributeTabType
723 ,OkcPAV_QUALIFIER_ATTRIBUTE71 OkcPAV_QualifAttributeTabType
724 ,OkcPAV_QUALIFIER_ATTRIBUTE72 OkcPAV_QualifAttributeTabType
725 ,OkcPAV_QUALIFIER_ATTRIBUTE73 OkcPAV_QualifAttributeTabType
726 ,OkcPAV_QUALIFIER_ATTRIBUTE74 OkcPAV_QualifAttributeTabType
727 ,OkcPAV_QUALIFIER_ATTRIBUTE75 OkcPAV_QualifAttributeTabType
728 ,OkcPAV_QUALIFIER_ATTRIBUTE76 OkcPAV_QualifAttributeTabType
729 ,OkcPAV_QUALIFIER_ATTRIBUTE77 OkcPAV_QualifAttributeTabType
730 ,OkcPAV_QUALIFIER_ATTRIBUTE78 OkcPAV_QualifAttributeTabType
731 ,OkcPAV_QUALIFIER_ATTRIBUTE79 OkcPAV_QualifAttributeTabType
732 ,OkcPAV_QUALIFIER_ATTRIBUTE80 OkcPAV_QualifAttributeTabType
733 ,OkcPAV_QUALIFIER_ATTRIBUTE81 OkcPAV_QualifAttributeTabType
734 ,OkcPAV_QUALIFIER_ATTRIBUTE82 OkcPAV_QualifAttributeTabType
735 ,OkcPAV_QUALIFIER_ATTRIBUTE83 OkcPAV_QualifAttributeTabType
736 ,OkcPAV_QUALIFIER_ATTRIBUTE84 OkcPAV_QualifAttributeTabType
737 ,OkcPAV_QUALIFIER_ATTRIBUTE85 OkcPAV_QualifAttributeTabType
738 ,OkcPAV_QUALIFIER_ATTRIBUTE86 OkcPAV_QualifAttributeTabType
739 ,OkcPAV_QUALIFIER_ATTRIBUTE87 OkcPAV_QualifAttributeTabType
740 ,OkcPAV_QUALIFIER_ATTRIBUTE88 OkcPAV_QualifAttributeTabType
741 ,OkcPAV_QUALIFIER_ATTRIBUTE89 OkcPAV_QualifAttributeTabType
742 ,OkcPAV_QUALIFIER_ATTRIBUTE90 OkcPAV_QualifAttributeTabType
743 ,OkcPAV_QUALIFIER_ATTRIBUTE91 OkcPAV_QualifAttributeTabType
744 ,OkcPAV_QUALIFIER_ATTRIBUTE92 OkcPAV_QualifAttributeTabType
745 ,OkcPAV_QUALIFIER_ATTRIBUTE93 OkcPAV_QualifAttributeTabType
746 ,OkcPAV_QUALIFIER_ATTRIBUTE94 OkcPAV_QualifAttributeTabType
747 ,OkcPAV_QUALIFIER_ATTRIBUTE95 OkcPAV_QualifAttributeTabType
748 ,OkcPAV_QUALIFIER_ATTRIBUTE96 OkcPAV_QualifAttributeTabType
749 ,OkcPAV_QUALIFIER_ATTRIBUTE97 OkcPAV_QualifAttributeTabType
750 ,OkcPAV_QUALIFIER_ATTRIBUTE98 OkcPAV_QualifAttributeTabType
751 ,OkcPAV_QUALIFIER_ATTRIBUTE99 OkcPAV_QualifAttributeTabType
752 ,OkcPAV_QUALIFIER_ATTRIBUTE100 OkcPAV_QualifAttributeTabType
753 ,OkcPAV_SECURITY_GROUP_ID NumTabType
754 ,OkcPAV_PROGRAM_APPLICATION_ID NumTabType
755 ,OkcPAV_PROGRAM_ID NumTabType
756 ,OkcPAV_PROGRAM_UPDATE_DATE DateTabType
757 ,OkcPAV_REQUEST_ID NumTabType
758 ,OkcPAV_OBJECT_VERSION_NUMBER NumTabType
759 );
760
761 OkcPAVRecTab OkcPAVRecTabType;
762
763 --------------------------------------------------------------------
764
765 ---Table datatypes for OKC_PRICE_ADJUSTMENTS columns-----------------
766 TYPE OkcPA_AttributeTabType IS TABLE OF OKC_PRICE_ADJUSTMENTS.ATTRIBUTE1%TYPE;
767 TYPE OkcPA_ListLineNoTabType IS TABLE OF OKC_PRICE_ADJUSTMENTS.LIST_LINE_NO%TYPE;
768
769 ---Record of Tables datatype for OKC_PRICE_ADJUSTMENTS---------------
770 TYPE OkcPARecTabType IS RECORD
771 (
772 OkcPA_OldID NumTabType
773 ,OkcPA_NewID NumTabType
774 ,OkcPA_PAT_ID NumTabType
775 ,OkcPA_NewChrID NumTabType
776 ,OkcPA_NewCleID NumTabType
777 ,OkcPA_BSL_ID NumTabType
778 ,OkcPA_BCL_ID NumTabType
779 ,OkcPA_MODIFIED_FROM NumTabType
780 ,OkcPA_MODIFIED_TO NumTabType
781 ,OkcPA_MODIF_MECHNSM_TYPE_CODE Varchar2_90_TabType
782 ,OkcPA_OPERAND NumTabType
783 ,OkcPA_ARITHMETIC_OPERATOR Varchar2_90_TabType
784 ,OkcPA_AUTOMATIC_FLAG YNTabType
785 ,OkcPA_UPDATE_ALLOWED YNTabType
786 ,OkcPA_UPDATED_FLAG YNTabType
787 ,OkcPA_APPLIED_FLAG YNTabType
788 ,OkcPA_ON_INVOICE_FLAG YNTabType
789 ,OkcPA_PRICING_PHASE_ID NumTabType
790 ,OkcPA_CONTEXT Varchar2_90_TabType
791 ,OkcPA_ATTRIBUTE1 OkcPA_AttributeTabType
792 ,OkcPA_ATTRIBUTE2 OkcPA_AttributeTabType
793 ,OkcPA_ATTRIBUTE3 OkcPA_AttributeTabType
794 ,OkcPA_ATTRIBUTE4 OkcPA_AttributeTabType
795 ,OkcPA_ATTRIBUTE5 OkcPA_AttributeTabType
796 ,OkcPA_ATTRIBUTE6 OkcPA_AttributeTabType
797 ,OkcPA_ATTRIBUTE7 OkcPA_AttributeTabType
798 ,OkcPA_ATTRIBUTE8 OkcPA_AttributeTabType
799 ,OkcPA_ATTRIBUTE9 OkcPA_AttributeTabType
800 ,OkcPA_ATTRIBUTE10 OkcPA_AttributeTabType
801 ,OkcPA_ATTRIBUTE11 OkcPA_AttributeTabType
802 ,OkcPA_ATTRIBUTE12 OkcPA_AttributeTabType
803 ,OkcPA_ATTRIBUTE13 OkcPA_AttributeTabType
804 ,OkcPA_ATTRIBUTE14 OkcPA_AttributeTabType
805 ,OkcPA_ATTRIBUTE15 OkcPA_AttributeTabType
806 ,OkcPA_SECURITY_GROUP_ID NumTabType
807 ,OkcPA_PROGRAM_APPLICATION_ID NumTabType
808 ,OkcPA_PROGRAM_ID NumTabType
809 ,OkcPA_PROGRAM_UPDATE_DATE DateTabType
810 ,OkcPA_REQUEST_ID NumTabType
811 ,OkcPA_OBJECT_VERSION_NUMBER NumTabType
812 ,OkcPA_LIST_HEADER_ID NumTabType
813 ,OkcPA_LIST_LINE_ID NumTabType
814 ,OkcPA_LIST_LINE_TYPE_CODE Varchar2_90_TabType
815 ,OkcPA_CHANGE_REASON_CODE Varchar2_90_TabType
816 ,OkcPA_CHANGE_REASON_TEXT Varchar2_2000_TabType
817 ,OkcPA_ESTIMATED_FLAG YNTabType
818 ,OkcPA_ADJUSTED_AMOUNT NumTabType
819 ,OkcPA_CHARGE_TYPE_CODE Varchar2_90_TabType
820 ,OkcPA_CHARGE_SUBTYPE_CODE Varchar2_90_TabType
821 ,OkcPA_RANGE_BREAK_QUANTITY NumTabType
822 ,OkcPA_ACCRUAL_CONVERSION_RATE NumTabType
823 ,OkcPA_PRICING_GROUP_SEQUENCE NumTabType
824 ,OkcPA_ACCRUAL_FLAG YNTabType
825 ,OkcPA_LIST_LINE_NO OKCPA_ListLineNoTabType
826 ,OkcPA_SOURCE_SYSTEM_CODE Varchar2_90_TabType
827 ,OkcPA_BENEFIT_QTY NumTabType
828 ,OkcPA_BENEFIT_UOM_CODE YNTabType
829 ,OkcPA_EXPIRATION_DATE DateTabType
830 ,OkcPA_MODIFIER_LEVEL_CODE Varchar2_90_TabType
831 ,OkcPA_PRICE_BREAK_TYPE_CODE Varchar2_90_TabType
832 ,OkcPA_SUBSTITUTION_ATTRIBUTE Varchar2_90_TabType
833 ,OkcPA_PRORATION_TYPE_CODE Varchar2_90_TabType
834 ,OkcPA_INCLUDE_ON_RETURNS_FLAG YNTabType
835 ,OkcPA_REBATE_TRXN_TYPE_CODE Varchar2_30_TabType
836 );
837
838 OkcPARecTab OkcPARecTabType;
839 --------------------------------------------------------
840
841
842 ---Record of tables datatype for OKS_K_LINES_TL--------------
843 TYPE OksTLRecTabType IS RECORD(
844 OksTL_OldID NumTabType
845 ,OksTL_NewID NumTabType
846 ,OksTL_LANGUAGE LanguageTabType
847 ,OksTL_SOURCE_LANG LanguageTabType
848 ,OksTL_SFWT_FLAG YNTabType
849 ,OksTL_INVOICE_TEXT Varchar2_2000_TabType
850 ,OksTL_IB_TRX_DETAILS Varchar2_2000_TabType
851 ,OksTL_STATUS_TEXT Varchar2_450_TabType
852 ,OksTL_REACT_TIME_NAME Varchar2_450_TabType
853 ,OksTL_SECURITY_GROUP_ID NumTabType
854 );
855
856 OksTLRecTab OksTLRecTabType;
857 -------------------------------------------------------------
858
859 -----Table datatypes for OKS_REV_DISTRIBUTIONS columns--------
860 TYPE OksRD_AccountClassTabType IS TABLE OF OKS_REV_DISTRIBUTIONS.ACCOUNT_CLASS%TYPE;
861
862 -----Record of Tables datatype for OKS_REV_DISTRIBUTIONS-----------
863 TYPE OksRDRecTabType IS RECORD (
864 OksRD_OldID NumTabType
865 ,OksRD_NewID NumTabType
866 ,OksRD_NewChrID NumTabType
867 ,OksRD_NewCleID NumTabType
868 ,OksRD_ACCOUNT_CLASS OksRD_AccountClassTabType
869 ,OksRD_CODE_COMBINATION_ID NumTabType
870 ,OksRD_PERCENT NumTabType
871 ,OksRD_OBJECT_VERSION_NUMBER NumTabType
872 ,OksRD_SECURITY_GROUP_ID NumTabType
873 );
874
875 OksRDRecTab OksRDRecTabType;
876 -------------------------------------------------------------------
877
878 -----Table datatypes for OKS_QUALIFIERS columns--------------------
879 TYPE OksQ_QualifDataTypeTabType IS TABLE OF OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE;
880
881 -------------------------------------------------------------------
882
883 -----Record of tables datatype for OKS_QUALIFIERS-----------------
884 TYPE OksQRecTabType IS RECORD (
885 OksQ_OldQualifierID NumTabType
886 ,OksQ_NewQualifierID NumTabType
887 ,OksQ_REQUEST_ID NumTabType
888 ,OksQ_PROGRAM_APPLICATION_ID NumTabType
889 ,OksQ_PROGRAM_ID NumTabType
890 ,OksQ_PROGRAM_UPDATE_DATE DateTabType
891 ,OksQ_QUALIFIER_GROUPING_NO NumTabType
892 ,OksQ_QUALIFIER_CONTEXT Varchar2_30_TabType
893 ,OksQ_QUALIFIER_ATTRIBUTE Varchar2_30_TabType
894 ,OksQ_QUALIFIER_ATTR_VALUE Varchar2_240_TabType
895 ,OksQ_COMPARISON_OPERATOR_CODE Varchar2_30_TabType
896 ,OksQ_EXCLUDER_FLAG YNTabType
897 ,OksQ_QUALIFIER_RULE_ID NumTabType
898 ,OksQ_START_DATE_ACTIVE DateTabType
899 ,OksQ_END_DATE_ACTIVE DateTabType
900 ,OksQ_CREATED_FROM_RULE_ID NumTabType
901 ,OksQ_QUALIFIER_PRECEDENCE NumTabType
902 ,OksQ_NewListHeaderID NumTabType
903 ,OksQ_NewListLineID NumTabType
904 ,OksQ_QUALIFIER_DATATYPE OksQ_QualifDataTypeTabType
905 ,OksQ_QUALIFIER_ATTR_VALUE_TO Varchar2_240_TabType
906 ,OksQ_CONTEXT Varchar2_30_TabType
907 ,OksQ_ATTRIBUTE1 Varchar2_240_TabType
908 ,OksQ_ATTRIBUTE2 Varchar2_240_TabType
909 ,OksQ_ATTRIBUTE3 Varchar2_240_TabType
910 ,OksQ_ATTRIBUTE4 Varchar2_240_TabType
911 ,OksQ_ATTRIBUTE5 Varchar2_240_TabType
912 ,OksQ_ATTRIBUTE6 Varchar2_240_TabType
913 ,OksQ_ATTRIBUTE7 Varchar2_240_TabType
914 ,OksQ_ATTRIBUTE8 Varchar2_240_TabType
915 ,OksQ_ATTRIBUTE9 Varchar2_240_TabType
916 ,OksQ_ATTRIBUTE10 Varchar2_240_TabType
917 ,OksQ_ATTRIBUTE11 Varchar2_240_TabType
918 ,OksQ_ATTRIBUTE12 Varchar2_240_TabType
919 ,OksQ_ATTRIBUTE13 Varchar2_240_TabType
920 ,OksQ_ATTRIBUTE14 Varchar2_240_TabType
921 ,OksQ_ATTRIBUTE15 Varchar2_240_TabType
922 ,OksQ_ACTIVE_FLAG YNTabType
923 ,OksQ_LIST_TYPE_CODE Varchar2_30_TabType
924 ,OksQ_QUAL_ATTRVALUE_FROM_NUM NumTabType
925 ,OksQ_QUAL_ATTRVALUE_TO_NUM NumTabType
926 ,OksQ_SECURITY_GROUP_ID NumTabType
927 );
928
929 OksQRecTab OksQRecTabType;
930
931 -----Record of tables datatype for OKS_COVERAGE_TIMEZONES-----------------
932 TYPE OksCTZRecTabType IS RECORD (
933 OksCTZ_OldID NumTabType
934 ,OksCTZ_NewID NumTabType
935 ,OksCTZ_NewCleID NumTabType
936 ,OksCTZ_DEFAULT_YN FlagTabType
937 ,OksCTZ_TIMEZONE_ID NumTabType
938 ,OksCTZ_NewDnzChrID NumTabType
939 ,OksCTZ_SECURITY_GROUP_ID NumTabType
940 ,OksCTZ_PROGRAM_APPLICATION_ID NumTabType
941 ,OksCTZ_PROGRAM_ID NumTabType
942 ,OksCTZ_PROGRAM_UPDATE_DATE DateTabType
943 ,OksCTZ_REQUEST_ID NumTabType
944 ,OksCTZ_OBJECT_VERSION_NUMBER NumTabType
945 ,OksCTZ_ORIG_SYSTEM_ID1 NumTabType
946 ,OksCTZ_ORIG_SYSTEM_SOURCE_CODE Varchar2_30_TabType
947 ,OksCTZ_ORIG_SYSTEM_REFERENCE1 Varchar2_30_TabType
948 );
949
950 OksCTZRecTab OksCTZRecTabType;
951
952 ------Record of tables datatype for OKS_COVERAGE_TIMES
953 TYPE OksCTRecTabType IS RECORD (
954 OksCT_OldID NumTabType
955 ,OksCT_NewID NumTabType
956 ,OksCT_NewDnzChrID NumTabType
957 ,OksCT_NewCovTzeLineID NumTabType
958 ,OksCT_START_HOUR NumTabType
959 ,OksCT_START_MINUTE NumTabType
960 ,OksCT_END_HOUR NumTabType
961 ,OksCT_END_MINUTE NumTabType
962 ,OksCT_MONDAY_YN FlagTabType
963 ,OksCT_TUESDAY_YN FlagTabType
964 ,OksCT_WEDNESDAY_YN FlagTabType
965 ,OksCT_THURSDAY_YN FlagTabType
966 ,OksCT_FRIDAY_YN FlagTabType
967 ,OksCT_SATURDAY_YN FlagTabType
968 ,OksCT_SUNDAY_YN FlagTabType
969 ,OksCT_SECURITY_GROUP_ID NumTabType
970 ,OksCT_PROGRAM_APPLICATION_ID NumTabType
971 ,OksCT_OBJECT_VERSION_NUMBER NumTabType
972 ,OksCT_PROGRAM_ID NumTabType
973 ,OksCT_PROGRAM_UPDATE_DATE DateTabType
974 ,OksCT_REQUEST_ID NumTabType
975 );
976 OksCTRecTab OksCTRecTabType;
977
978 -----Record of tables datatype for OKS_PM_ACTIVITIES------
979 TYPE OksPMARecTabType IS RECORD (
980 OksPMA_OldID NumTabType
981 ,OksPMA_NewID NumTabType
982 ,OksPMA_NewCleID NumTabType
983 ,OksPMA_NewDnzChrID NumTabType
984 ,OksPMA_ACTIVITY_ID NumTabType
985 ,OksPMA_SELECT_YN FlagTabType
986 ,OksPMA_CONF_REQ_YN FlagTabType
987 ,OksPMA_SCH_EXISTS_YN FlagTabType
988 ,OksPMA_PROGRAM_APPLICATION_ID NumTabType
989 ,OksPMA_PROGRAM_ID NumTabType
990 ,OksPMA_PROGRAM_UPDATE_DATE DateTabType
991 ,OksPMA_OBJECT_VERSION_NUMBER NumTabType
992 ,OksPMA_SECURITY_GROUP_ID NumTabType
993 ,OksPMA_REQUEST_ID NumTabType
994 ,OksPMA_ORIG_SYSTEM_ID1 NumTabType
995 ,OksPMA_ORIG_SYSTEM_SOURCE_CODE Varchar2_30_TabType
996 ,OksPMA_ORIG_SYSTEM_REFERENCE1 Varchar2_30_TabType
997 );
998
999 OksPMARecTab OksPMARecTabType;
1000
1001 ----Record of tables datatype for OKS_PM_STREAM_LEVELS----
1002 TYPE OksPMSLRecTabType IS RECORD (
1003 OksPMSL_OldID NumTabType
1004 ,OksPMSL_NewID NumTabType
1005 ,OksPMSL_NewCleID NumTabType
1006 ,OksPMSL_NewDnzChrID NumTabType
1007 ,OksPMSL_NewActivityLineID NumTabType
1008 ,OksPMSL_SEQUENCE_NUMBER NumTabType
1009 ,OksPMSL_NUMBER_OF_OCCURENCES NumTabType
1010 ,OksPMSL_START_DATE DateTabType
1011 ,OksPMSL_END_DATE DateTabType
1012 ,OksPMSL_FREQUENCY NumTabType
1013 ,OksPMSL_FREQUENCY_UOM YNTabType
1014 ,OksPMSL_OFFSET_DURATION NumTabType
1015 ,OksPMSL_OFFSET_UOM YNTabType
1016 ,OksPMSL_AUTOSCHEDULE_YN FlagTabType
1017 ,OksPMSL_PROGRAM_APPLICATION_ID NumTabType
1018 ,OksPMSL_PROGRAM_ID NumTabType
1019 ,OksPMSL_PROGRAM_UPDATE_DATE DateTabType
1020 ,OksPMSL_OBJECT_VERSION_NUMBER NumTabType
1021 ,OksPMSL_SECURITY_GROUP_ID NumTabType
1022 ,OksPMSL_REQUEST_ID NumTabType
1023 ,OksPMSL_ORIG_SYSTEM_ID1 NumTabType
1024 ,OksPMSL_ORIG_SYS_SOURCE_CODE Varchar2_30_TabType
1025 ,OksPMSL_ORIG_SYS_REFERENCE1 Varchar2_30_TabType
1026 );
1027
1028 OksPMSLRecTab OksPMSLRecTabType;
1029
1030 -----Record of tables datatype for OKS_PM_SCHEDULES
1031 TYPE OksPMSCHRecTabType IS RECORD (
1032 OksPMSCH_OldID NumTabType
1033 ,OksPMSCH_NewID NumTabType
1034 ,OksPMSCH_RULE_ID NumTabType
1035 ,OksPMSCH_OBJECT_VERSION_NUMBER NumTabType
1036 ,OksPMSCH_NewDnzChrID NumTabType
1037 ,OksPMSCH_NewCleID NumTabType
1038 ,OksPMSCH_SCH_SEQUENCE NumTabType
1039 ,OksPMSCH_SCHEDULE_DATE DateTabType
1040 ,OksPMSCH_SCHEDULE_DATE_FROM DateTabType
1041 ,OksPMSCH_SCHEDULE_DATE_TO DateTabType
1042 ,OksPMSCH_PMA_RULE_ID NumTabType
1043 ,OksPMSCH_PMP_RULE_ID NumTabType
1044 ,OksPMSCH_NewActivityLineID NumTabType
1045 ,OksPMSCH_NewStreamLineID NumTabType
1046 ,OksPMSCH_SECURITY_GROUP_ID NumTabType
1047 ,OksPMSCH_PROG_APPLICATION_ID NumTabType
1048 ,OksPMSCH_PROGRAM_ID NumTabType
1049 ,OksPMSCH_PROGRAM_UPDATE_DATE DateTabType
1050 ,OksPMSCH_REQUEST_ID NumTabType
1051 );
1052
1053 OksPMSCHRecTab OksPMSCHRecTabType;
1054
1055 -----Record of tables datatype for OKS_ACTION_TIME_TYPES-------
1056 TYPE OksATTRecTabType IS RECORD (
1057 OksATT_OldID NumTabType
1058 ,OksATT_NewID NumTabType
1059 ,OksATT_NewCleID NumTabType
1060 ,OksATT_NewDnzChrID NumTabType
1061 ,OksATT_ACTION_TYPE_CODE Varchar2_30_TabType
1062 ,OksATT_SECURITY_GROUP_ID NumTabType
1063 ,OksATT_PROGRAM_APPLICATION_ID NumTabType
1064 ,OksATT_PROGRAM_ID NumTabType
1065 ,OksATT_PROGRAM_UPDATE_DATE DateTabType
1066 ,OksATT_REQUEST_ID NumTabType
1067 ,OksATT_OBJECT_VERSION_NUMBER NumTabType
1068 ,OksATT_ORIG_SYSTEM_ID1 NumTabType
1069 ,OksATT_ORIG_SYSTEM_SOURCE_CODE Varchar2_30_TabType
1070 ,OksATT_ORIG_SYSTEM_REFERENCE1 Varchar2_30_TabType
1071 );
1072 OksATTRecTab OksATTRecTabType;
1073
1074 ------Record of tables datatype for OKS_ACTION_TIMES------
1075 TYPE OksATRecTabType IS RECORD (
1076 OksAT_OldID NumTabType
1077 ,OksAT_NewID NumTabType
1078 ,OksAT_NewCovActionTypeID NumTabType
1079 ,OksAT_NewCleID NumTabType
1080 ,OksAT_NewDnzChrID NumTabType
1081 ,OksAT_UOM_CODE Varchar2_30_TabType
1082 ,OksAT_SUN_DURATION NumTabType
1083 ,OksAT_MON_DURATION NumTabType
1084 ,OksAT_TUE_DURATION NumTabType
1085 ,OksAT_WED_DURATION NumTabType
1086 ,OksAT_THU_DURATION NumTabType
1087 ,OksAT_FRI_DURATION NumTabType
1088 ,OksAT_SAT_DURATION NumTabType
1089 ,OksAT_SECURITY_GROUP_ID NumTabType
1090 ,OksAT_PROGRAM_APPLICATION_ID NumTabType
1091 ,OksAT_PROGRAM_ID NumTabType
1092 ,OksAT_PROGRAM_UPDATE_DATE DateTabType
1093 ,OksAT_REQUEST_ID NumTabType
1094 ,OksAT_OBJECT_VERSION_NUMBER NumTabType
1095 );
1096 OksATRecTab OksATRecTabType;
1097
1098 -----Record of tables datatype for OKS_STREAM_LEVELS_B----
1099 TYPE OksSLRecTabType IS RECORD (
1100 OksSL_OldID NumTabType
1101 ,OksSL_NewID NumTabType
1102 ,OksSL_NewChrId NumTabType
1103 ,OksSL_NewCleID NumTabType
1104 ,OksSL_NewDnzChrID NumTabType
1105 ,OksSL_SEQUENCE_NO NumTabType
1106 ,OksSL_UOM_CODE YNTabType
1107 ,OksSL_START_DATE DateTabType
1108 ,OksSL_END_DATE DateTabType
1109 ,OksSL_LEVEL_PERIODS NumTabType
1110 ,OksSL_UOM_PER_PERIOD NumTabType
1111 ,OksSL_ADVANCE_PERIODS NumTabType
1112 ,OksSL_LEVEL_AMOUNT NumTabType
1113 ,OksSL_INVOICE_OFFSET_DAYS NumTabType
1114 ,OksSL_INTERFACE_OFFSET_DAYS NumTabType
1115 ,OksSL_COMMENTS Varchar2_2000_TabType
1116 ,OksSL_DUE_ARR_YN FlagTabType
1117 ,OksSL_AMOUNT NumTabType
1118 ,OksSL_LINES_DETAILED_YN FlagTabType
1119 ,OksSL_OBJECT_VERSION_NUMBER NumTabType
1120 ,OksSL_SECURITY_GROUP_ID NumTabType
1121 ,OksSL_REQUEST_ID NumTabType
1122 ,OksSL_ORIG_SYSTEM_ID1 NumTabType
1123 ,OksSL_ORIG_SYSTEM_SOURCE_CODE Varchar2_30_TabType
1124 ,OksSL_ORIG_SYSTEM_REFERENCE1 Varchar2_30_TabType
1125 );
1126 OksSLRecTab OksSLRecTabType;
1127
1128 ----Record of tables datatype for OKS_LEVEL_ELEMENTS------
1129 TYPE OksLERecTabType IS RECORD (
1130 OksLE_OldID NumTabType
1131 ,OksLE_NewID NumTabType
1132 ,OksLE_SEQUENCE_NUMBER NumTabType
1133 ,OksLE_DATE_START DateTabType
1134 ,OksLE_AMOUNT NumTabType
1135 ,OksLE_DATE_RECEIVABLE_GL DateTabType
1136 ,OksLE_DATE_REVENUE_RULE_START DateTabType
1137 ,OksLE_DATE_TRANSACTION DateTabType
1138 ,OksLE_DATE_DUE DateTabType
1139 ,OksLE_DATE_PRINT DateTabType
1140 ,OksLE_DATE_TO_INTERFACE DateTabType
1141 ,OksLE_DATE_COMPLETED DateTabType
1142 ,OksLE_OBJECT_VERSION_NUMBER NumTabType
1143 ,OksLE_NewRulID NumTabType
1144 ,OksLE_SECURITY_GROUP_ID NumTabType
1145 ,OksLE_NewCleID NumTabType
1146 ,OksLE_NewDnzChrID NumTabType
1147 ,OksLE_NewParentCleID NumTabType
1148 ,OksLE_DATE_END DateTabType
1149 );
1150 OksLERecTab OksLERecTabType;
1151
1152 -----Record of tables datatype for OKS_K_SALES_CREDITS---------
1153 TYPE OksSCRecTabType IS RECORD (
1154 OksSC_OldID NumTabType
1155 ,OksSC_NewID NumTabType
1156 ,OksSC_PERCENT NumTabType
1157 ,OksSC_NewChrID NumTabType
1158 ,OksSC_NewCleId NumTabType
1159 ,OksSC_CTC_ID NumTabType
1160 ,OksSC_SALES_CREDIT_TYPE_ID1 Varchar2_40_TabType
1161 ,OksSC_SALES_CREDIT_TYPE_ID2 Varchar2_40_TabType
1162 ,OksSC_OBJECT_VERSION_NUMBER NumTabType
1163 ,OksSC_SECURITY_GROUP_ID NumTabType
1164 ,OksSC_SALES_GROUP_ID NumTabType
1165 );
1166 OksSCRecTab OksSCRecTabType;
1167
1168 -----Record of tables datatype for OKS_BILLRATE_SCHEDULES-----
1169 TYPE OksBSCHRecTabType IS RECORD (
1170 OksBSCH_OldID NumTabType
1171 ,OksBSCH_NewID NumTabType
1172 ,OksBSCH_NewCleId NumTabType
1173 ,OksBSCH_NewBTCleID NumTabType
1174 ,OksBSCH_NewDnzChrID NumTabType
1175 ,OksBSCH_START_HOUR NumTabType
1176 ,OksBSCH_START_MINUTE NumTabType
1177 ,OksBSCH_END_HOUR NumTabType
1178 ,OksBSCH_END_MINUTE NumTabType
1179 ,OksBSCH_MONDAY_FLAG FlagTabType
1180 ,OksBSCH_TUESDAY_FLAG FlagTabType
1181 ,OksBSCH_WEDNESDAY_FLAG FlagTabType
1182 ,OksBSCH_THURSDAY_FLAG FlagTabType
1183 ,OksBSCH_FRIDAY_FLAG FlagTabType
1184 ,OksBSCH_SATURDAY_FLAG FlagTabType
1185 ,OksBSCH_SUNDAY_FLAG FlagTabType
1186 ,OksBSCH_OBJECT1_ID1 Object1ID1TabType
1187 ,OksBSCH_OBJECT1_ID2 Object1ID2TabType
1188 ,OksBSCH_JTOT_OBJECT1_CODE JTOTObject1CodeTabType
1189 ,OksBSCH_BILL_RATE_CODE Varchar2_40_TabType
1190 ,OksBSCH_FLAT_RATE NumTabType
1191 ,OksBSCH_UOM YNTabType
1192 ,OksBSCH_HOLIDAY_YN FlagTabType
1193 ,OksBSCH_PCT_OVER_LIST_PRICE NumTabType
1194 ,OksBSCH_PRGRM_APPLICATION_ID NumTabType
1195 ,OksBSCH_PROGRAM_ID NumTabType
1196 ,OksBSCH_PROGRAM_UPDATE_DATE DateTabType
1197 ,OksBSCH_REQUEST_ID NumTabType
1198 ,OksBSCH_SECURITY_GROUP_ID NumTabType
1199 ,OksBSCH_OBJECT_VERSION_NUMBER NumTabType
1200 );
1201 OksBSCHRecTab OksBSCHRecTabType;
1202
1203 ------Record of tables datatype for OKC_OPERATION_LINES-------------
1204 TYPE OkcOLRecTabType IS RECORD (
1205 OkcOLID NumTabType
1206 ,OkcOLSELECT_YN YNTabType
1207 ,OkcOLPROCESS_FLAG FlagTabType
1208 ,OkcOLOIE_ID NumTabType
1209 ,OkcOLSUBJECT_CHR_ID NumTabType
1210 ,OkcOLOBJECT_CHR_ID NumTabType
1211 ,OkcOLSUBJECT_CLE_ID NumTabType
1212 ,OkcOLOBJECT_CLE_ID NumTabType
1213 ,OkcOLOBJECT_VERSION_NUMBER NumTabType
1214 ,OkcOLREQUEST_ID NumTabType
1215 ,OkcOLPROGRAM_APPLICATION_ID NumTabType
1216 ,OkcOLPROGRAM_ID NumTabType
1217 ,OkcOLPROGRAM_UPDATE_DATE DateTabType
1218 ,OkcOLSECURITY_GROUP_ID NumTabType
1219 ,OkcOLMESSAGE_CODE Varchar2_30_TabType
1220 ,OkcOLPARENT_OLE_ID NumTabType
1221 ,OkcOLACTIVE_YN YNTabType
1222 );
1223 OkcOLRecTab OkcOLRecTabType;
1224
1225
1226 FUNCTION is_copy_allowed(p_chr_id IN NUMBER,p_sts_code IN VARCHAR2 DEFAULT NULL) RETURN BOOLEAN;
1227
1228 PROCEDURE copy_components(
1229 p_api_version IN NUMBER,
1230 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1231 x_return_status OUT NOCOPY VARCHAR2,
1232 x_msg_count OUT NOCOPY NUMBER,
1233 x_msg_data OUT NOCOPY VARCHAR2,
1234 p_from_chr_id IN NUMBER,
1235 p_to_chr_id IN NUMBER,
1236 p_contract_number IN VARCHAR2,
1237 p_contract_number_modifier IN VARCHAR2,
1238 p_to_template_yn IN VARCHAR2 DEFAULT 'N',
1239 p_components_tbl IN api_components_tbl,
1240 p_lines_tbl IN api_lines_tbl,
1241 p_change_status_YN IN VARCHAR2 DEFAULT 'Y',--Added for Update_Service requirement(Bug 4747648)
1242 --If 'Y', status of new line is default status
1243 --If 'N', status from Source Line is retained
1244 p_return_new_top_line_ID_YN IN VARCHAR2 DEFAULT 'N', --Added for Update_Service requirement(Bug 4747648)
1245 --If 'Y' then the new line IDs of the copied top lines need to be
1246 --published
1247 x_to_chr_id OUT NOCOPY NUMBER,
1248 p_published_line_ids_tbl OUT NOCOPY published_line_ids_tbl --Added for Update Service requirement(Bug 4747648)
1249 --This table will be populated if p_return_new_top_line_ID_YN = 'Y'
1250 ,p_include_cancelled_lines IN VARCHAR2 DEFAULT 'Y',
1251 p_include_terminated_lines IN VARCHAR2 DEFAULT 'Y'); /*modified for copy enhancement*/
1252
1253
1254 PROCEDURE copy_contract(
1255 p_api_version IN NUMBER,
1256 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1257 x_return_status OUT NOCOPY VARCHAR2,
1258 x_msg_count OUT NOCOPY NUMBER,
1259 x_msg_data OUT NOCOPY VARCHAR2,
1260 p_commit IN VARCHAR2 DEFAULT 'F',
1261 p_chr_id IN NUMBER,
1262 p_contract_number IN VARCHAR2,
1263 p_contract_number_modifier IN VARCHAR2,
1264 p_to_template_yn IN VARCHAR2,
1265 p_renew_ref_yn IN VARCHAR2,
1266 x_to_chr_id OUT NOCOPY NUMBER,
1267 p_include_cancelled_lines IN VARCHAR2 DEFAULT 'Y',
1268 p_include_terminated_lines IN VARCHAR2 DEFAULT 'Y');
1269
1270 PROCEDURE copy_contract_header(
1271 p_api_version IN NUMBER,
1272 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1273 x_return_status OUT NOCOPY VARCHAR2,
1274 x_msg_count OUT NOCOPY NUMBER,
1275 x_msg_data OUT NOCOPY VARCHAR2,
1276 p_from_chr_id IN NUMBER,
1277 p_contract_number IN VARCHAR2,
1278 p_contract_number_modifier IN VARCHAR2,
1279 p_to_template_yn IN VARCHAR2,
1280 p_renew_ref_yn IN VARCHAR2,
1281 x_to_chr_id OUT NOCOPY NUMBER);
1282
1283 /******Header Level events no longer supported****
1284 PROCEDURE copy_events(
1285 p_api_version IN NUMBER,
1286 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1287 x_return_status OUT NOCOPY VARCHAR2,
1288 x_msg_count OUT NOCOPY NUMBER,
1289 x_msg_data OUT NOCOPY VARCHAR2,
1290 p_cnh_id IN NUMBER,
1291 p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
1292 p_to_template_yn IN VARCHAR2,
1293 x_cnh_id OUT NOCOPY NUMBER);
1294 ****************************************************/
1295
1296 ---------------------------------Start New code for 12.0---------------------------------
1297
1298 /*======================================================================================
1299 --Copy_Lines: This procedure copies all lines and its details for a given Contract Header
1300 This pricedure is used in COPY_CONTRACT API.
1301 Parameters:
1302 P_From_Chr_ID: Header ID of the Source Contract
1303 P_To_Chr_ID : Header ID of the Target Contract
1304 P_Renew_Ref_YN : Parameter to indicate if this routine is being called in
1305 the context of Contract Renewal or regular Copy. Valid
1306 values are 'Y' and 'N'
1307 =======================================================================================*/
1308 PROCEDURE copy_lines(
1309 p_api_version IN NUMBER
1310 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1311 ,x_return_status OUT NOCOPY VARCHAR2
1312 ,x_msg_count OUT NOCOPY NUMBER
1313 ,x_msg_data OUT NOCOPY VARCHAR2
1314 ,P_From_Chr_ID IN NUMBER
1315 ,P_To_Chr_ID IN NUMBER
1316 ,P_Renew_Ref_YN IN VARCHAR2
1317 ,p_include_cancelled_lines IN VARCHAR2 DEFAULT 'Y'
1318 ,p_include_terminated_lines IN VARCHAR2 DEFAULT 'Y'); /*modified for copy enhancement*/
1319
1320
1321 /*======================================================================================
1322 --Copy_Lines: This procedure copies all lines that are selected by the user for Copy in the Copy UI
1323 and their details. This pricedure is used in COPY_COMPONENTS API.
1324 Parameters:
1325 P_From_Chr_ID: Header ID of the Source Contract
1326 P_To_Chr_ID : Header ID of the Target Contract
1327 P_Target_Contract_New_YN: Flag to indicate if the Target Contract was just created as part of Copy
1328 or was already present and only lines were copied to an existing target
1329 contract. Value for this parameter will be 'Y' if source contract is being
1330 copied to a new contract, 'N' if the copy is happening into an existing
1331 contract.
1332 This parameter would be initialized in this API to 'N' and
1333 get set to 'Y' immediately after the call to Copy_Contract_Header.
1334
1335 This parameter would be used in copy of:
1336 Price Attribute Values
1337 Price Adjustments
1338 Sales Credits
1339 Billing Schedules.
1340
1341 If value is 'N' these entities would be copied only for Lines
1342 else they would be copied for both Header and Lines.
1343 =========================================================================================*/
1344 PROCEDURE copy_line_components(
1345 p_api_version IN NUMBER
1346 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1347 ,x_return_status OUT NOCOPY VARCHAR2
1348 ,x_msg_count OUT NOCOPY NUMBER
1349 ,x_msg_data OUT NOCOPY VARCHAR2
1350 ,P_From_Chr_ID IN NUMBER
1351 ,P_To_Chr_ID IN NUMBER
1352 ,P_Target_Contract_New_YN IN VARCHAR2
1353 ,P_Lines_Tbl IN api_lines_tbl
1354 ,p_change_status_YN IN VARCHAR2 --Added for Update_Service requirement(Bug 4747648)
1355 --If 'Y', status of new line is default status
1356 --If 'N', status from Source Line is retained
1357 ,p_return_new_top_line_ID_YN IN VARCHAR2 --Added for Update_Service requirement(Bug 4747648)
1358 --If 'Y' then the new line IDs of the copied top lines need to be
1359 --published
1360 ,p_include_cancelled_lines IN VARCHAR2 DEFAULT 'Y'
1361 ,p_include_terminated_lines IN VARCHAR2 DEFAULT 'Y'); /*modified for copy enhancement*/
1362
1363 /*=======================================================================
1364 Returns 'Y' if the Contract has a Partial Period Setup else returns 'N'
1365 ========================================================================*/
1366
1367 Function ContractPPSetupEXISTS(P_Chr_ID IN NUMBER) RETURN VARCHAR2;
1368
1369 /*=========================================================================
1370 This procedure is being exposed so that it can be invoked from OKC_COPY_CONTRACT_PVT.update_template_Contract
1371 to support partial period uptake
1372 ==========================================================================*/
1373
1374 Procedure create_bsch_using_PPSetup(P_To_Chr_ID IN NUMBER
1375 ,P_From_Chr_ID IN NUMBER
1376 ,P_Partial_Copy_YN IN VARCHAR2
1377 ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
1378 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1379 ,x_return_status OUT NOCOPY VARCHAR2
1380 ,x_msg_count OUT NOCOPY NUMBER
1381 ,x_msg_data OUT NOCOPY VARCHAR2);
1382
1383 /***--Procedure moved to package OKS_UTIL_PUB
1384 Procedure create_transaction_extension(P_Api_Version IN NUMBER
1385 ,P_Init_Msg_List IN VARCHAR2
1386 ,P_Header_ID IN NUMBER
1387 ,P_Line_ID IN NUMBER
1388 ,P_Source_Trx_Ext_ID IN NUMBER
1389 ,P_Cust_Acct_ID IN NUMBER
1390 ,P_Bill_To_Site_Use_ID IN NUMBER
1391 ,x_entity_id OUT NOCOPY NUMBER
1392 ,x_msg_data OUT NOCOPY VARCHAR2
1393 ,x_msg_count OUT NOCOPY NUMBER
1394 ,x_return_status OUT NOCOPY VARCHAR2);
1395 ****/
1396
1397 --npalepu added on 18-may-2006 for bug # 5211482
1398 -------------------------------------------------------------------------------
1399 -- Procedure: chk_line_effectivity
1400 -- Purpose: This procedure checks the effectivity dates of source
1401 -- contract line and target contract line
1402 -- In Parameters: p_new_cle_id Target contract line id
1403 -- Out Parameters: x_return_status standard return status
1404 -- x_flag yes no flag
1405 -----------------------------------------------------------------------------
1406
1407 PROCEDURE chk_line_effectivity(p_new_cle_id IN NUMBER,
1408 x_flag OUT NOCOPY VARCHAR2,
1409 x_return_status OUT NOCOPY VARCHAR2
1410 );
1411 --end npalepu
1412
1413 END OKS_COPY_CONTRACT_PVT;