[Home] [Help]
PACKAGE: APPS.OKS_KLN_PVT
Source
1 PACKAGE OKS_KLN_PVT AS
2 /* $Header: OKSSKLNS.pls 120.5.12000000.1 2007/01/16 22:14:16 appldev ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKS_K_LINES_V Record Spec
7 TYPE klnv_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,cle_id NUMBER := OKC_API.G_MISS_NUM
10 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11 ,discount_list NUMBER := OKC_API.G_MISS_NUM
12 ,acct_rule_id NUMBER := OKC_API.G_MISS_NUM
13 ,payment_type OKS_K_LINES_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
14 ,cc_no OKS_K_LINES_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
15 ,cc_expiry_date OKS_K_LINES_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
16 ,cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
17 ,cc_auth_code OKS_K_LINES_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
18 ,commitment_id NUMBER := OKC_API.G_MISS_NUM
19 ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
20 ,usage_est_yn OKS_K_LINES_V.USAGE_EST_YN%TYPE := OKC_API.G_MISS_CHAR
21 ,usage_est_method OKS_K_LINES_V.USAGE_EST_METHOD%TYPE := OKC_API.G_MISS_CHAR
22 ,usage_est_start_date OKS_K_LINES_V.USAGE_EST_START_DATE%TYPE := OKC_API.G_MISS_DATE
23 ,termn_method OKS_K_LINES_V.TERMN_METHOD%TYPE := OKC_API.G_MISS_CHAR
24 ,ubt_amount NUMBER := OKC_API.G_MISS_NUM
25 ,credit_amount NUMBER := OKC_API.G_MISS_NUM
26 ,suppressed_credit NUMBER := OKC_API.G_MISS_NUM
27 ,override_amount NUMBER := OKC_API.G_MISS_NUM
28 ,cust_po_number_req_yn OKS_K_LINES_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
29 ,cust_po_number OKS_K_LINES_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30 ,grace_duration NUMBER := OKC_API.G_MISS_NUM
31 ,grace_period OKS_K_LINES_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
32 ,inv_print_flag OKS_K_LINES_V.INV_PRINT_FLAG%TYPE := OKC_API.G_MISS_CHAR
33 ,price_uom OKS_K_LINES_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
34 ,tax_amount NUMBER := OKC_API.G_MISS_NUM
35 ,tax_inclusive_yn OKS_K_LINES_V.TAX_INCLUSIVE_YN%TYPE := OKC_API.G_MISS_CHAR
36 ,tax_status OKS_K_LINES_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
37 ,tax_code NUMBER := OKC_API.G_MISS_NUM
38 ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
39 ,ib_trans_type OKS_K_LINES_V.IB_TRANS_TYPE%TYPE := OKC_API.G_MISS_CHAR
40 ,ib_trans_date OKS_K_LINES_V.IB_TRANS_DATE%TYPE := OKC_API.G_MISS_DATE
41 ,prod_price NUMBER := OKC_API.G_MISS_NUM
42 ,service_price NUMBER := OKC_API.G_MISS_NUM
43 ,clvl_list_price NUMBER := OKC_API.G_MISS_NUM
44 ,clvl_quantity NUMBER := OKC_API.G_MISS_NUM
45 ,clvl_extended_amt NUMBER := OKC_API.G_MISS_NUM
46 ,clvl_uom_code OKS_K_LINES_V.CLVL_UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
47 ,toplvl_operand_code OKS_K_LINES_V.TOPLVL_OPERAND_CODE%TYPE := OKC_API.G_MISS_CHAR
48 ,toplvl_operand_val NUMBER := OKC_API.G_MISS_NUM
49 ,toplvl_quantity NUMBER := OKC_API.G_MISS_NUM
50 ,toplvl_uom_code OKS_K_LINES_V.TOPLVL_UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
51 ,toplvl_adj_price NUMBER := OKC_API.G_MISS_NUM
52 ,toplvl_price_qty NUMBER := OKC_API.G_MISS_NUM
53 ,averaging_interval NUMBER := OKC_API.G_MISS_NUM
54 ,settlement_interval OKS_K_LINES_V.SETTLEMENT_INTERVAL%TYPE := OKC_API.G_MISS_CHAR
55 ,minimum_quantity NUMBER := OKC_API.G_MISS_NUM
56 ,default_quantity NUMBER := OKC_API.G_MISS_NUM
57 ,amcv_flag OKS_K_LINES_V.AMCV_FLAG%TYPE := OKC_API.G_MISS_CHAR
58 ,fixed_quantity NUMBER := OKC_API.G_MISS_NUM
59 ,usage_duration NUMBER := OKC_API.G_MISS_NUM
60 ,usage_period OKS_K_LINES_V.USAGE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
61 ,level_yn OKS_K_LINES_V.LEVEL_YN%TYPE := OKC_API.G_MISS_CHAR
62 ,usage_type OKS_K_LINES_V.USAGE_TYPE%TYPE := OKC_API.G_MISS_CHAR
63 ,uom_quantified OKS_K_LINES_V.UOM_QUANTIFIED%TYPE := OKC_API.G_MISS_CHAR
64 ,base_reading NUMBER := OKC_API.G_MISS_NUM
65 ,billing_schedule_type OKS_K_LINES_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
66 ,full_credit OKS_K_LINES_V.FULL_CREDIT%TYPE := OKC_API.G_MISS_CHAR
67 ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
68 ,break_uom OKS_K_LINES_V.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
69 ,prorate OKS_K_LINES_V.PRORATE%TYPE := OKC_API.G_MISS_CHAR
70 ,coverage_type OKS_K_LINES_V.COVERAGE_TYPE%TYPE := OKC_API.G_MISS_CHAR
71 ,exception_cov_id NUMBER := OKC_API.G_MISS_NUM
72 ,limit_uom_quantified OKS_K_LINES_V.LIMIT_UOM_QUANTIFIED%TYPE := OKC_API.G_MISS_CHAR
73 ,discount_amount NUMBER := OKC_API.G_MISS_NUM
74 ,discount_percent NUMBER := OKC_API.G_MISS_NUM
75 ,offset_duration NUMBER := OKC_API.G_MISS_NUM
76 ,offset_period OKS_K_LINES_V.OFFSET_PERIOD%TYPE := OKC_API.G_MISS_CHAR
77 ,incident_severity_id NUMBER := OKC_API.G_MISS_NUM
78 ,pdf_id NUMBER := OKC_API.G_MISS_NUM
79 ,work_thru_yn OKS_K_LINES_V.WORK_THRU_YN%TYPE := OKC_API.G_MISS_CHAR
80 ,react_active_yn OKS_K_LINES_V.REACT_ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR
81 ,transfer_option OKS_K_LINES_V.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
82 ,prod_upgrade_yn OKS_K_LINES_V.PROD_UPGRADE_YN%TYPE := OKC_API.G_MISS_CHAR
83 ,inheritance_type OKS_K_LINES_V.INHERITANCE_TYPE%TYPE := OKC_API.G_MISS_CHAR
84 ,pm_program_id NUMBER := OKC_API.G_MISS_NUM
85 ,pm_conf_req_yn OKS_K_LINES_V.PM_CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
86 ,pm_sch_exists_yn OKS_K_LINES_V.PM_SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
87 ,allow_bt_discount OKS_K_LINES_V.ALLOW_BT_DISCOUNT%TYPE := OKC_API.G_MISS_CHAR
88 ,apply_default_timezone OKS_K_LINES_V.APPLY_DEFAULT_TIMEZONE%TYPE := OKC_API.G_MISS_CHAR
89 ,sync_date_install OKS_K_LINES_V.SYNC_DATE_INSTALL%TYPE := OKC_API.G_MISS_CHAR
90 ,sfwt_flag OKS_K_LINES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
91 ,invoice_text OKS_K_LINES_V.INVOICE_TEXT%TYPE := OKC_API.G_MISS_CHAR
92 ,ib_trx_details OKS_K_LINES_V.IB_TRX_DETAILS%TYPE := OKC_API.G_MISS_CHAR
93 ,status_text OKS_K_LINES_V.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
94 ,react_time_name OKS_K_LINES_V.REACT_TIME_NAME%TYPE := OKC_API.G_MISS_CHAR
95 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
96 ,security_group_id NUMBER := OKC_API.G_MISS_NUM
97 ,request_id NUMBER := OKC_API.G_MISS_NUM
98 ,created_by NUMBER := OKC_API.G_MISS_NUM
99 ,creation_date OKS_K_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
100 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
101 ,last_update_date OKS_K_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
102 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
103 -- R12 Data Model Changes 4485150 Start
104 ,trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
105 ,tax_classification_code OKS_K_LINES_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
106 ,exempt_certificate_number OKS_K_LINES_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
107 ,exempt_reason_code OKS_K_LINES_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
108 ,coverage_id NUMBER := OKC_API.G_MISS_NUM
109 ,standard_cov_yn OKS_K_LINES_V.STANDARD_COV_YN%TYPE := OKC_API.G_MISS_CHAR
110 ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
111 ,orig_system_reference1 OKS_K_LINES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
112 ,orig_system_source_code OKS_K_LINES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
113 -- R12 Data Model Changes 4485150 End
114 );
115 G_MISS_klnv_rec klnv_rec_type;
116 TYPE klnv_tbl_type IS TABLE OF klnv_rec_type
117 INDEX BY BINARY_INTEGER;
118 -- OKS_K_LINES_B Record Spec
119 TYPE kln_rec_type IS RECORD (
120 id NUMBER := OKC_API.G_MISS_NUM
121 ,cle_id NUMBER := OKC_API.G_MISS_NUM
122 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
123 ,discount_list NUMBER := OKC_API.G_MISS_NUM
124 ,acct_rule_id NUMBER := OKC_API.G_MISS_NUM
125 ,payment_type OKS_K_LINES_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
126 ,cc_no OKS_K_LINES_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR
127 ,cc_expiry_date OKS_K_LINES_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
128 ,cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
129 ,cc_auth_code OKS_K_LINES_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
130 ,commitment_id NUMBER := OKC_API.G_MISS_NUM
131 ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
132 ,usage_est_yn OKS_K_LINES_B.USAGE_EST_YN%TYPE := OKC_API.G_MISS_CHAR
133 ,usage_est_method OKS_K_LINES_B.USAGE_EST_METHOD%TYPE := OKC_API.G_MISS_CHAR
134 ,usage_est_start_date OKS_K_LINES_B.USAGE_EST_START_DATE%TYPE := OKC_API.G_MISS_DATE
135 ,termn_method OKS_K_LINES_B.TERMN_METHOD%TYPE := OKC_API.G_MISS_CHAR
136 ,ubt_amount NUMBER := OKC_API.G_MISS_NUM
137 ,credit_amount NUMBER := OKC_API.G_MISS_NUM
138 ,suppressed_credit NUMBER := OKC_API.G_MISS_NUM
139 ,override_amount NUMBER := OKC_API.G_MISS_NUM
140 ,cust_po_number_req_yn OKS_K_LINES_B.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
141 ,cust_po_number OKS_K_LINES_B.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
142 ,grace_duration NUMBER := OKC_API.G_MISS_NUM
143 ,grace_period OKS_K_LINES_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
144 ,inv_print_flag OKS_K_LINES_B.INV_PRINT_FLAG%TYPE := OKC_API.G_MISS_CHAR
145 ,price_uom OKS_K_LINES_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
146 ,tax_amount NUMBER := OKC_API.G_MISS_NUM
147 ,tax_inclusive_yn OKS_K_LINES_B.TAX_INCLUSIVE_YN%TYPE := OKC_API.G_MISS_CHAR
148 ,tax_status OKS_K_LINES_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
149 ,tax_code NUMBER := OKC_API.G_MISS_NUM
150 ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
151 ,ib_trans_type OKS_K_LINES_B.IB_TRANS_TYPE%TYPE := OKC_API.G_MISS_CHAR
152 ,ib_trans_date OKS_K_LINES_B.IB_TRANS_DATE%TYPE := OKC_API.G_MISS_DATE
153 ,prod_price NUMBER := OKC_API.G_MISS_NUM
154 ,service_price NUMBER := OKC_API.G_MISS_NUM
155 ,clvl_list_price NUMBER := OKC_API.G_MISS_NUM
156 ,clvl_quantity NUMBER := OKC_API.G_MISS_NUM
157 ,clvl_extended_amt NUMBER := OKC_API.G_MISS_NUM
158 ,clvl_uom_code OKS_K_LINES_B.CLVL_UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
159 ,toplvl_operand_code OKS_K_LINES_B.TOPLVL_OPERAND_CODE%TYPE := OKC_API.G_MISS_CHAR
160 ,toplvl_operand_val NUMBER := OKC_API.G_MISS_NUM
161 ,toplvl_quantity NUMBER := OKC_API.G_MISS_NUM
162 ,toplvl_uom_code OKS_K_LINES_B.TOPLVL_UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
163 ,toplvl_adj_price NUMBER := OKC_API.G_MISS_NUM
164 ,toplvl_price_qty NUMBER := OKC_API.G_MISS_NUM
165 ,averaging_interval NUMBER := OKC_API.G_MISS_NUM
166 ,settlement_interval OKS_K_LINES_B.SETTLEMENT_INTERVAL%TYPE := OKC_API.G_MISS_CHAR
167 ,minimum_quantity NUMBER := OKC_API.G_MISS_NUM
168 ,default_quantity NUMBER := OKC_API.G_MISS_NUM
169 ,amcv_flag OKS_K_LINES_B.AMCV_FLAG%TYPE := OKC_API.G_MISS_CHAR
170 ,fixed_quantity NUMBER := OKC_API.G_MISS_NUM
171 ,usage_duration NUMBER := OKC_API.G_MISS_NUM
172 ,usage_period OKS_K_LINES_B.USAGE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
173 ,level_yn OKS_K_LINES_B.LEVEL_YN%TYPE := OKC_API.G_MISS_CHAR
174 ,usage_type OKS_K_LINES_B.USAGE_TYPE%TYPE := OKC_API.G_MISS_CHAR
175 ,uom_quantified OKS_K_LINES_B.UOM_QUANTIFIED%TYPE := OKC_API.G_MISS_CHAR
176 ,base_reading NUMBER := OKC_API.G_MISS_NUM
177 ,billing_schedule_type OKS_K_LINES_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
178 ,full_credit OKS_K_LINES_B.FULL_CREDIT%TYPE := OKC_API.G_MISS_CHAR
179 ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
180 ,break_uom OKS_K_LINES_B.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
181 ,prorate OKS_K_LINES_B.PRORATE%TYPE := OKC_API.G_MISS_CHAR
182 ,coverage_type OKS_K_LINES_B.COVERAGE_TYPE%TYPE := OKC_API.G_MISS_CHAR
183 ,exception_cov_id NUMBER := OKC_API.G_MISS_NUM
184 ,limit_uom_quantified OKS_K_LINES_B.LIMIT_UOM_QUANTIFIED%TYPE := OKC_API.G_MISS_CHAR
185 ,discount_amount NUMBER := OKC_API.G_MISS_NUM
186 ,discount_percent NUMBER := OKC_API.G_MISS_NUM
187 ,offset_duration NUMBER := OKC_API.G_MISS_NUM
188 ,offset_period OKS_K_LINES_B.OFFSET_PERIOD%TYPE := OKC_API.G_MISS_CHAR
189 ,incident_severity_id NUMBER := OKC_API.G_MISS_NUM
190 ,pdf_id NUMBER := OKC_API.G_MISS_NUM
191 ,work_thru_yn OKS_K_LINES_B.WORK_THRU_YN%TYPE := OKC_API.G_MISS_CHAR
192 ,react_active_yn OKS_K_LINES_B.REACT_ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR
193 ,transfer_option OKS_K_LINES_B.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
197 ,pm_conf_req_yn OKS_K_LINES_B.PM_CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
194 ,prod_upgrade_yn OKS_K_LINES_B.PROD_UPGRADE_YN%TYPE := OKC_API.G_MISS_CHAR
195 ,inheritance_type OKS_K_LINES_B.INHERITANCE_TYPE%TYPE := OKC_API.G_MISS_CHAR
196 ,pm_program_id NUMBER := OKC_API.G_MISS_NUM
198 ,pm_sch_exists_yn OKS_K_LINES_B.PM_SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
199 ,allow_bt_discount OKS_K_LINES_B.ALLOW_BT_DISCOUNT%TYPE := OKC_API.G_MISS_CHAR
200 ,apply_default_timezone OKS_K_LINES_B.APPLY_DEFAULT_TIMEZONE%TYPE := OKC_API.G_MISS_CHAR
201 ,sync_date_install OKS_K_LINES_B.SYNC_DATE_INSTALL%TYPE := OKC_API.G_MISS_CHAR
202 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
203 ,request_id NUMBER := OKC_API.G_MISS_NUM
204 ,created_by NUMBER := OKC_API.G_MISS_NUM
205 ,creation_date OKS_K_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
206 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
207 ,last_update_date OKS_K_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
208 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
209 -- R12 Data Model Changes 4485150 Start
210 ,trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
211 ,tax_classification_code OKS_K_LINES_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
212 ,exempt_certificate_number OKS_K_LINES_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
213 ,exempt_reason_code OKS_K_LINES_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
214 ,coverage_id NUMBER := OKC_API.G_MISS_NUM
215 ,standard_cov_yn OKS_K_LINES_B.STANDARD_COV_YN%TYPE := OKC_API.G_MISS_CHAR
216 ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
217 ,orig_system_reference1 OKS_K_LINES_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
218 ,orig_system_source_code OKS_K_LINES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
219 -- R12 Data Model Changes 4485150 End
220 );
221 G_MISS_kln_rec kln_rec_type;
222 TYPE kln_tbl_type IS TABLE OF kln_rec_type
223 INDEX BY BINARY_INTEGER;
224 -- OKS_K_LINES_TL Record Spec
225 TYPE klt_rec_type IS RECORD (
226 id NUMBER := OKC_API.G_MISS_NUM
227 ,language OKS_K_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
228 ,source_lang OKS_K_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
229 ,sfwt_flag OKS_K_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
230 ,invoice_text OKS_K_LINES_TL.INVOICE_TEXT%TYPE := OKC_API.G_MISS_CHAR
231 ,ib_trx_details OKS_K_LINES_TL.IB_TRX_DETAILS%TYPE := OKC_API.G_MISS_CHAR
232 ,status_text OKS_K_LINES_TL.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
233 ,react_time_name OKS_K_LINES_TL.REACT_TIME_NAME%TYPE := OKC_API.G_MISS_CHAR
234 ,created_by NUMBER := OKC_API.G_MISS_NUM
235 ,creation_date OKS_K_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
236 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
237 ,last_update_date OKS_K_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
238 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
239 G_MISS_klt_rec klt_rec_type;
240 TYPE klt_tbl_type IS TABLE OF klt_rec_type
241 INDEX BY BINARY_INTEGER;
242 ---------------------------------------------------------------------------
243 -- GLOBAL MESSAGE CONSTANTS
244 ---------------------------------------------------------------------------
245 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
246 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
247 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
248 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
249 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
250 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
251 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
252 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
253 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
254 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
255 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
256 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
257 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
258
259 ---------------------------------------------------------------------------
260 -- GLOBAL EXCEPTIONS
261 ---------------------------------------------------------------------------
262 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
263
264 ---------------------------------------------------------------------------
265 -- GLOBAL VARIABLES
266 ---------------------------------------------------------------------------
267 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_KLN_PVT';
268 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
269 ---------------------------------------------------------------------------
270 -- Procedures and Functions
271 ---------------------------------------------------------------------------
272
273 PROCEDURE qc;
274 PROCEDURE change_version;
275 PROCEDURE api_copy;
276 PROCEDURE add_language;
280 x_return_status OUT NOCOPY VARCHAR2,
277 PROCEDURE insert_row(
278 p_api_version IN NUMBER,
279 p_init_msg_list IN VARCHAR2,
281 x_msg_count OUT NOCOPY NUMBER,
282 x_msg_data OUT NOCOPY VARCHAR2,
283 p_klnv_rec IN klnv_rec_type,
284 x_klnv_rec OUT NOCOPY klnv_rec_type);
285 PROCEDURE insert_row(
286 p_api_version IN NUMBER,
287 p_init_msg_list IN VARCHAR2,
288 x_return_status OUT NOCOPY VARCHAR2,
289 x_msg_count OUT NOCOPY NUMBER,
290 x_msg_data OUT NOCOPY VARCHAR2,
291 p_klnv_tbl IN klnv_tbl_type,
292 x_klnv_tbl OUT NOCOPY klnv_tbl_type,
293 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
294 PROCEDURE insert_row(
295 p_api_version IN NUMBER,
296 p_init_msg_list IN VARCHAR2,
297 x_return_status OUT NOCOPY VARCHAR2,
298 x_msg_count OUT NOCOPY NUMBER,
299 x_msg_data OUT NOCOPY VARCHAR2,
300 p_klnv_tbl IN klnv_tbl_type,
301 x_klnv_tbl OUT NOCOPY klnv_tbl_type);
302 PROCEDURE lock_row(
303 p_api_version IN NUMBER,
304 p_init_msg_list IN VARCHAR2,
305 x_return_status OUT NOCOPY VARCHAR2,
306 x_msg_count OUT NOCOPY NUMBER,
307 x_msg_data OUT NOCOPY VARCHAR2,
308 p_klnv_rec IN klnv_rec_type);
309 PROCEDURE lock_row(
310 p_api_version IN NUMBER,
311 p_init_msg_list IN VARCHAR2,
312 x_return_status OUT NOCOPY VARCHAR2,
313 x_msg_count OUT NOCOPY NUMBER,
314 x_msg_data OUT NOCOPY VARCHAR2,
315 p_klnv_tbl IN klnv_tbl_type,
316 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
317 PROCEDURE lock_row(
318 p_api_version IN NUMBER,
319 p_init_msg_list IN VARCHAR2,
320 x_return_status OUT NOCOPY VARCHAR2,
321 x_msg_count OUT NOCOPY NUMBER,
322 x_msg_data OUT NOCOPY VARCHAR2,
323 p_klnv_tbl IN klnv_tbl_type);
324 PROCEDURE update_row(
325 p_api_version IN NUMBER,
326 p_init_msg_list IN VARCHAR2,
327 x_return_status OUT NOCOPY VARCHAR2,
328 x_msg_count OUT NOCOPY NUMBER,
329 x_msg_data OUT NOCOPY VARCHAR2,
330 p_klnv_rec IN klnv_rec_type,
331 x_klnv_rec OUT NOCOPY klnv_rec_type);
332 PROCEDURE update_row(
333 p_api_version IN NUMBER,
334 p_init_msg_list IN VARCHAR2,
335 x_return_status OUT NOCOPY VARCHAR2,
336 x_msg_count OUT NOCOPY NUMBER,
337 x_msg_data OUT NOCOPY VARCHAR2,
338 p_klnv_tbl IN klnv_tbl_type,
339 x_klnv_tbl OUT NOCOPY klnv_tbl_type,
340 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
341 PROCEDURE update_row(
342 p_api_version IN NUMBER,
343 p_init_msg_list IN VARCHAR2,
344 x_return_status OUT NOCOPY VARCHAR2,
345 x_msg_count OUT NOCOPY NUMBER,
346 x_msg_data OUT NOCOPY VARCHAR2,
347 p_klnv_tbl IN klnv_tbl_type,
348 x_klnv_tbl OUT NOCOPY klnv_tbl_type);
349 PROCEDURE delete_row(
350 p_api_version IN NUMBER,
351 p_init_msg_list IN VARCHAR2,
352 x_return_status OUT NOCOPY VARCHAR2,
353 x_msg_count OUT NOCOPY NUMBER,
354 x_msg_data OUT NOCOPY VARCHAR2,
355 p_klnv_rec IN klnv_rec_type);
356 PROCEDURE delete_row(
357 p_api_version IN NUMBER,
358 p_init_msg_list IN VARCHAR2,
359 x_return_status OUT NOCOPY VARCHAR2,
360 x_msg_count OUT NOCOPY NUMBER,
361 x_msg_data OUT NOCOPY VARCHAR2,
362 p_klnv_tbl IN klnv_tbl_type,
363 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
364 PROCEDURE delete_row(
365 p_api_version IN NUMBER,
366 p_init_msg_list IN VARCHAR2,
367 x_return_status OUT NOCOPY VARCHAR2,
368 x_msg_count OUT NOCOPY NUMBER,
369 x_msg_data OUT NOCOPY VARCHAR2,
370 p_klnv_tbl IN klnv_tbl_type);
371 PROCEDURE validate_row(
372 p_api_version IN NUMBER,
373 p_init_msg_list IN VARCHAR2,
374 x_return_status OUT NOCOPY VARCHAR2,
375 x_msg_count OUT NOCOPY NUMBER,
376 x_msg_data OUT NOCOPY VARCHAR2,
377 p_klnv_rec IN klnv_rec_type);
378 PROCEDURE validate_row(
379 p_api_version IN NUMBER,
380 p_init_msg_list IN VARCHAR2,
381 x_return_status OUT NOCOPY VARCHAR2,
382 x_msg_count OUT NOCOPY NUMBER,
383 x_msg_data OUT NOCOPY VARCHAR2,
384 p_klnv_tbl IN klnv_tbl_type,
385 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
386 PROCEDURE validate_row(
387 p_api_version IN NUMBER,
388 p_init_msg_list IN VARCHAR2,
389 x_return_status OUT NOCOPY VARCHAR2,
390 x_msg_count OUT NOCOPY NUMBER,
391 x_msg_data OUT NOCOPY VARCHAR2,
392 p_klnv_tbl IN klnv_tbl_type);
393 END OKS_KLN_PVT;