[Home] [Help]
PACKAGE: APPS.OKS_KLN_PVT
Source
1 PACKAGE OKS_KLN_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSSKLNS.pls 120.5.12020000.3 2013/04/05 07:09:22 vgujarat 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 --skuchima VRM ER
115 ,revenue_Impact_Date OKS_K_LINES_V.REVENUE_IMPACT_DATE%TYPE := OKC_API.G_MISS_DATE
116 , counter_value_id NUMBER := OKC_API.G_MISS_NUM
117 );
118 G_MISS_klnv_rec klnv_rec_type;
119 TYPE klnv_tbl_type IS TABLE OF klnv_rec_type
120 INDEX BY BINARY_INTEGER;
121 -- OKS_K_LINES_B Record Spec
122 TYPE kln_rec_type IS RECORD (
123 id NUMBER := OKC_API.G_MISS_NUM
124 ,cle_id NUMBER := OKC_API.G_MISS_NUM
125 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
126 ,discount_list NUMBER := OKC_API.G_MISS_NUM
127 ,acct_rule_id NUMBER := OKC_API.G_MISS_NUM
128 ,payment_type OKS_K_LINES_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
129 ,cc_no OKS_K_LINES_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR
130 ,cc_expiry_date OKS_K_LINES_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
131 ,cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
132 ,cc_auth_code OKS_K_LINES_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
133 ,commitment_id NUMBER := OKC_API.G_MISS_NUM
134 ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
135 ,usage_est_yn OKS_K_LINES_B.USAGE_EST_YN%TYPE := OKC_API.G_MISS_CHAR
136 ,usage_est_method OKS_K_LINES_B.USAGE_EST_METHOD%TYPE := OKC_API.G_MISS_CHAR
137 ,usage_est_start_date OKS_K_LINES_B.USAGE_EST_START_DATE%TYPE := OKC_API.G_MISS_DATE
138 ,termn_method OKS_K_LINES_B.TERMN_METHOD%TYPE := OKC_API.G_MISS_CHAR
139 ,ubt_amount NUMBER := OKC_API.G_MISS_NUM
140 ,credit_amount NUMBER := OKC_API.G_MISS_NUM
141 ,suppressed_credit NUMBER := OKC_API.G_MISS_NUM
142 ,override_amount NUMBER := OKC_API.G_MISS_NUM
143 ,cust_po_number_req_yn OKS_K_LINES_B.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
144 ,cust_po_number OKS_K_LINES_B.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
145 ,grace_duration NUMBER := OKC_API.G_MISS_NUM
146 ,grace_period OKS_K_LINES_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
147 ,inv_print_flag OKS_K_LINES_B.INV_PRINT_FLAG%TYPE := OKC_API.G_MISS_CHAR
148 ,price_uom OKS_K_LINES_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
149 ,tax_amount NUMBER := OKC_API.G_MISS_NUM
150 ,tax_inclusive_yn OKS_K_LINES_B.TAX_INCLUSIVE_YN%TYPE := OKC_API.G_MISS_CHAR
151 ,tax_status OKS_K_LINES_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
152 ,tax_code NUMBER := OKC_API.G_MISS_NUM
153 ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
154 ,ib_trans_type OKS_K_LINES_B.IB_TRANS_TYPE%TYPE := OKC_API.G_MISS_CHAR
155 ,ib_trans_date OKS_K_LINES_B.IB_TRANS_DATE%TYPE := OKC_API.G_MISS_DATE
156 ,prod_price NUMBER := OKC_API.G_MISS_NUM
157 ,service_price NUMBER := OKC_API.G_MISS_NUM
158 ,clvl_list_price NUMBER := OKC_API.G_MISS_NUM
159 ,clvl_quantity NUMBER := OKC_API.G_MISS_NUM
160 ,clvl_extended_amt NUMBER := OKC_API.G_MISS_NUM
161 ,clvl_uom_code OKS_K_LINES_B.CLVL_UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
162 ,toplvl_operand_code OKS_K_LINES_B.TOPLVL_OPERAND_CODE%TYPE := OKC_API.G_MISS_CHAR
163 ,toplvl_operand_val NUMBER := OKC_API.G_MISS_NUM
164 ,toplvl_quantity NUMBER := OKC_API.G_MISS_NUM
165 ,toplvl_uom_code OKS_K_LINES_B.TOPLVL_UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
166 ,toplvl_adj_price NUMBER := OKC_API.G_MISS_NUM
167 ,toplvl_price_qty NUMBER := OKC_API.G_MISS_NUM
168 ,averaging_interval NUMBER := OKC_API.G_MISS_NUM
169 ,settlement_interval OKS_K_LINES_B.SETTLEMENT_INTERVAL%TYPE := OKC_API.G_MISS_CHAR
170 ,minimum_quantity NUMBER := OKC_API.G_MISS_NUM
171 ,default_quantity NUMBER := OKC_API.G_MISS_NUM
172 ,amcv_flag OKS_K_LINES_B.AMCV_FLAG%TYPE := OKC_API.G_MISS_CHAR
173 ,fixed_quantity NUMBER := OKC_API.G_MISS_NUM
174 ,usage_duration NUMBER := OKC_API.G_MISS_NUM
175 ,usage_period OKS_K_LINES_B.USAGE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
176 ,level_yn OKS_K_LINES_B.LEVEL_YN%TYPE := OKC_API.G_MISS_CHAR
177 ,usage_type OKS_K_LINES_B.USAGE_TYPE%TYPE := OKC_API.G_MISS_CHAR
178 ,uom_quantified OKS_K_LINES_B.UOM_QUANTIFIED%TYPE := OKC_API.G_MISS_CHAR
179 ,base_reading NUMBER := OKC_API.G_MISS_NUM
180 ,billing_schedule_type OKS_K_LINES_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
181 ,full_credit OKS_K_LINES_B.FULL_CREDIT%TYPE := OKC_API.G_MISS_CHAR
182 ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
183 ,break_uom OKS_K_LINES_B.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
184 ,prorate OKS_K_LINES_B.PRORATE%TYPE := OKC_API.G_MISS_CHAR
185 ,coverage_type OKS_K_LINES_B.COVERAGE_TYPE%TYPE := OKC_API.G_MISS_CHAR
186 ,exception_cov_id NUMBER := OKC_API.G_MISS_NUM
187 ,limit_uom_quantified OKS_K_LINES_B.LIMIT_UOM_QUANTIFIED%TYPE := OKC_API.G_MISS_CHAR
188 ,discount_amount NUMBER := OKC_API.G_MISS_NUM
189 ,discount_percent NUMBER := OKC_API.G_MISS_NUM
190 ,offset_duration NUMBER := OKC_API.G_MISS_NUM
191 ,offset_period OKS_K_LINES_B.OFFSET_PERIOD%TYPE := OKC_API.G_MISS_CHAR
192 ,incident_severity_id NUMBER := OKC_API.G_MISS_NUM
193 ,pdf_id NUMBER := OKC_API.G_MISS_NUM
194 ,work_thru_yn OKS_K_LINES_B.WORK_THRU_YN%TYPE := OKC_API.G_MISS_CHAR
195 ,react_active_yn OKS_K_LINES_B.REACT_ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR
196 ,transfer_option OKS_K_LINES_B.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
197 ,prod_upgrade_yn OKS_K_LINES_B.PROD_UPGRADE_YN%TYPE := OKC_API.G_MISS_CHAR
198 ,inheritance_type OKS_K_LINES_B.INHERITANCE_TYPE%TYPE := OKC_API.G_MISS_CHAR
199 ,pm_program_id NUMBER := OKC_API.G_MISS_NUM
200 ,pm_conf_req_yn OKS_K_LINES_B.PM_CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
201 ,pm_sch_exists_yn OKS_K_LINES_B.PM_SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
202 ,allow_bt_discount OKS_K_LINES_B.ALLOW_BT_DISCOUNT%TYPE := OKC_API.G_MISS_CHAR
203 ,apply_default_timezone OKS_K_LINES_B.APPLY_DEFAULT_TIMEZONE%TYPE := OKC_API.G_MISS_CHAR
204 ,sync_date_install OKS_K_LINES_B.SYNC_DATE_INSTALL%TYPE := OKC_API.G_MISS_CHAR
205 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
206 ,request_id NUMBER := OKC_API.G_MISS_NUM
207 ,created_by NUMBER := OKC_API.G_MISS_NUM
208 ,creation_date OKS_K_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
209 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
210 ,last_update_date OKS_K_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
211 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
212 -- R12 Data Model Changes 4485150 Start
213 ,trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
214 ,tax_classification_code OKS_K_LINES_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
215 ,exempt_certificate_number OKS_K_LINES_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
216 ,exempt_reason_code OKS_K_LINES_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
217 ,coverage_id NUMBER := OKC_API.G_MISS_NUM
218 ,standard_cov_yn OKS_K_LINES_B.STANDARD_COV_YN%TYPE := OKC_API.G_MISS_CHAR
219 ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
220 ,orig_system_reference1 OKS_K_LINES_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
221 ,orig_system_source_code OKS_K_LINES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
222 -- R12 Data Model Changes 4485150 End
223 --skuchima VRM ER
224 ,revenue_Impact_Date OKS_K_LINES_B.revenue_Impact_Date%TYPE := OKC_API.G_MISS_DATE
225 , counter_value_id NUMBER := OKC_API.G_MISS_NUM
226 );
227 G_MISS_kln_rec kln_rec_type;
228 TYPE kln_tbl_type IS TABLE OF kln_rec_type
229 INDEX BY BINARY_INTEGER;
230 -- OKS_K_LINES_TL Record Spec
231 TYPE klt_rec_type IS RECORD (
232 id NUMBER := OKC_API.G_MISS_NUM
233 ,language OKS_K_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
234 ,source_lang OKS_K_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
235 ,sfwt_flag OKS_K_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
236 ,invoice_text OKS_K_LINES_TL.INVOICE_TEXT%TYPE := OKC_API.G_MISS_CHAR
237 ,ib_trx_details OKS_K_LINES_TL.IB_TRX_DETAILS%TYPE := OKC_API.G_MISS_CHAR
238 ,status_text OKS_K_LINES_TL.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
239 ,react_time_name OKS_K_LINES_TL.REACT_TIME_NAME%TYPE := OKC_API.G_MISS_CHAR
240 ,created_by NUMBER := OKC_API.G_MISS_NUM
241 ,creation_date OKS_K_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
242 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
243 ,last_update_date OKS_K_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
244 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
245 G_MISS_klt_rec klt_rec_type;
246 TYPE klt_tbl_type IS TABLE OF klt_rec_type
247 INDEX BY BINARY_INTEGER;
248 ---------------------------------------------------------------------------
249 -- GLOBAL MESSAGE CONSTANTS
250 ---------------------------------------------------------------------------
251 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
252 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
253 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
254 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
255 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
256 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
257 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
258 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
259 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
260 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
261 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
262 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
263 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
264
265 ---------------------------------------------------------------------------
266 -- GLOBAL EXCEPTIONS
267 ---------------------------------------------------------------------------
268 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
269
270 ---------------------------------------------------------------------------
271 -- GLOBAL VARIABLES
272 ---------------------------------------------------------------------------
273 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_KLN_PVT';
274 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
275 ---------------------------------------------------------------------------
276 -- Procedures and Functions
277 ---------------------------------------------------------------------------
278
279 PROCEDURE qc;
280 PROCEDURE change_version;
281 PROCEDURE api_copy;
282 PROCEDURE add_language;
283 PROCEDURE insert_row(
284 p_api_version IN NUMBER,
285 p_init_msg_list IN VARCHAR2,
286 x_return_status OUT NOCOPY VARCHAR2,
287 x_msg_count OUT NOCOPY NUMBER,
288 x_msg_data OUT NOCOPY VARCHAR2,
289 p_klnv_rec IN klnv_rec_type,
290 x_klnv_rec OUT NOCOPY klnv_rec_type);
291 PROCEDURE insert_row(
292 p_api_version IN NUMBER,
293 p_init_msg_list IN VARCHAR2,
294 x_return_status OUT NOCOPY VARCHAR2,
295 x_msg_count OUT NOCOPY NUMBER,
296 x_msg_data OUT NOCOPY VARCHAR2,
297 p_klnv_tbl IN klnv_tbl_type,
298 x_klnv_tbl OUT NOCOPY klnv_tbl_type,
299 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
300 PROCEDURE insert_row(
301 p_api_version IN NUMBER,
302 p_init_msg_list IN VARCHAR2,
303 x_return_status OUT NOCOPY VARCHAR2,
304 x_msg_count OUT NOCOPY NUMBER,
305 x_msg_data OUT NOCOPY VARCHAR2,
306 p_klnv_tbl IN klnv_tbl_type,
307 x_klnv_tbl OUT NOCOPY klnv_tbl_type);
308 PROCEDURE lock_row(
309 p_api_version IN NUMBER,
310 p_init_msg_list IN VARCHAR2,
311 x_return_status OUT NOCOPY VARCHAR2,
312 x_msg_count OUT NOCOPY NUMBER,
313 x_msg_data OUT NOCOPY VARCHAR2,
314 p_klnv_rec IN klnv_rec_type);
315 PROCEDURE lock_row(
316 p_api_version IN NUMBER,
317 p_init_msg_list IN VARCHAR2,
318 x_return_status OUT NOCOPY VARCHAR2,
319 x_msg_count OUT NOCOPY NUMBER,
320 x_msg_data OUT NOCOPY VARCHAR2,
321 p_klnv_tbl IN klnv_tbl_type,
322 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
323 PROCEDURE lock_row(
324 p_api_version IN NUMBER,
325 p_init_msg_list IN VARCHAR2,
326 x_return_status OUT NOCOPY VARCHAR2,
327 x_msg_count OUT NOCOPY NUMBER,
328 x_msg_data OUT NOCOPY VARCHAR2,
329 p_klnv_tbl IN klnv_tbl_type);
330 PROCEDURE update_row(
331 p_api_version IN NUMBER,
332 p_init_msg_list IN VARCHAR2,
333 x_return_status OUT NOCOPY VARCHAR2,
334 x_msg_count OUT NOCOPY NUMBER,
335 x_msg_data OUT NOCOPY VARCHAR2,
336 p_klnv_rec IN klnv_rec_type,
337 x_klnv_rec OUT NOCOPY klnv_rec_type);
338 PROCEDURE update_row(
339 p_api_version IN NUMBER,
340 p_init_msg_list IN VARCHAR2,
341 x_return_status OUT NOCOPY VARCHAR2,
342 x_msg_count OUT NOCOPY NUMBER,
343 x_msg_data OUT NOCOPY VARCHAR2,
344 p_klnv_tbl IN klnv_tbl_type,
345 x_klnv_tbl OUT NOCOPY klnv_tbl_type,
346 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
347 PROCEDURE update_row(
348 p_api_version IN NUMBER,
349 p_init_msg_list IN VARCHAR2,
350 x_return_status OUT NOCOPY VARCHAR2,
351 x_msg_count OUT NOCOPY NUMBER,
352 x_msg_data OUT NOCOPY VARCHAR2,
353 p_klnv_tbl IN klnv_tbl_type,
354 x_klnv_tbl OUT NOCOPY klnv_tbl_type);
355 PROCEDURE delete_row(
356 p_api_version IN NUMBER,
357 p_init_msg_list IN VARCHAR2,
358 x_return_status OUT NOCOPY VARCHAR2,
359 x_msg_count OUT NOCOPY NUMBER,
360 x_msg_data OUT NOCOPY VARCHAR2,
361 p_klnv_rec IN klnv_rec_type);
362 PROCEDURE delete_row(
363 p_api_version IN NUMBER,
364 p_init_msg_list IN VARCHAR2,
365 x_return_status OUT NOCOPY VARCHAR2,
366 x_msg_count OUT NOCOPY NUMBER,
367 x_msg_data OUT NOCOPY VARCHAR2,
368 p_klnv_tbl IN klnv_tbl_type,
369 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
370 PROCEDURE delete_row(
371 p_api_version IN NUMBER,
372 p_init_msg_list IN VARCHAR2,
373 x_return_status OUT NOCOPY VARCHAR2,
374 x_msg_count OUT NOCOPY NUMBER,
375 x_msg_data OUT NOCOPY VARCHAR2,
376 p_klnv_tbl IN klnv_tbl_type);
377 PROCEDURE validate_row(
378 p_api_version IN NUMBER,
379 p_init_msg_list IN VARCHAR2,
380 x_return_status OUT NOCOPY VARCHAR2,
381 x_msg_count OUT NOCOPY NUMBER,
382 x_msg_data OUT NOCOPY VARCHAR2,
383 p_klnv_rec IN klnv_rec_type);
384 PROCEDURE validate_row(
385 p_api_version IN NUMBER,
386 p_init_msg_list IN VARCHAR2,
387 x_return_status OUT NOCOPY VARCHAR2,
388 x_msg_count OUT NOCOPY NUMBER,
389 x_msg_data OUT NOCOPY VARCHAR2,
390 p_klnv_tbl IN klnv_tbl_type,
391 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
392 PROCEDURE validate_row(
393 p_api_version IN NUMBER,
394 p_init_msg_list IN VARCHAR2,
395 x_return_status OUT NOCOPY VARCHAR2,
396 x_msg_count OUT NOCOPY NUMBER,
397 x_msg_data OUT NOCOPY VARCHAR2,
398 p_klnv_tbl IN klnv_tbl_type);
399 END OKS_KLN_PVT;