[Home] [Help]
PACKAGE: APPS.OKS_KHR_PVT
Source
1 PACKAGE OKS_KHR_PVT AS
2 /* $Header: OKSSKHRS.pls 120.4 2006/09/11 22:37:54 jakuruvi noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKS_K_HEADERS_V Record Spec
7 TYPE khrv_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 , chr_id NUMBER := OKC_API.G_MISS_NUM
10 , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
11 , payment_type OKS_K_HEADERS_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
12 , cc_no OKS_K_HEADERS_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
13 , cc_expiry_date OKS_K_HEADERS_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
14 , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
15 , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
16 , commitment_id NUMBER := OKC_API.G_MISS_NUM
17 , grace_duration NUMBER := OKC_API.G_MISS_NUM
18 , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
19 , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
20 , est_rev_date OKS_K_HEADERS_V.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
21 , tax_amount NUMBER := OKC_API.G_MISS_NUM
22 , tax_status OKS_K_HEADERS_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
23 , tax_code NUMBER := OKC_API.G_MISS_NUM
24 , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
25 , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
26 , renewal_status OKS_K_HEADERS_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
27 , electronic_renewal_flag OKS_K_HEADERS_V.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
28 , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
29 , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
30 , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
31 , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
32 , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
33 , renewal_po_required OKS_K_HEADERS_V.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
34 , renewal_po_number OKS_K_HEADERS_V.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
35 , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
36 , renewal_pricing_type OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
37 , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
38 , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
39 , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
40 , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
41 , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
42 , renewal_est_rev_period OKS_K_HEADERS_V.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
43 , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
44 , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
45 , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
46 , renewal_po_used OKS_K_HEADERS_V.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
47 , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
48 , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
49 , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
50 , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
51 , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
52 , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
53 , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
54 , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
55 , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
56 , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
57 , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
58 , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
59 , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
60 , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
61 , inv_print_profile OKS_K_HEADERS_V.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
62 , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
63 , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
64 , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
65 , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
66 , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
67 , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
68 , object_version_number NUMBER := OKC_API.G_MISS_NUM
69 , security_group_id NUMBER := OKC_API.G_MISS_NUM
70 , request_id NUMBER := OKC_API.G_MISS_NUM
71 , created_by NUMBER := OKC_API.G_MISS_NUM
72 , creation_date OKS_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
73 , last_updated_by NUMBER := OKC_API.G_MISS_NUM
74 , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
75 , last_update_login NUMBER := OKC_API.G_MISS_NUM
76 , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
77 , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
78 , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
79 , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
80 , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
81 , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
82 , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
83 , accepted_by NUMBER := OKC_API.G_MISS_NUM
84 , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
85 , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
86 , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
87 , process_request_id NUMBER := OKC_API.G_MISS_NUM
88 , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
89 , person_party_id NUMBER := OKC_API.G_MISS_NUM
90 , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
91 , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
92 , exempt_reason_code OKS_K_HEADERS_V.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
93 , approval_type_used OKS_K_HEADERS_V.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR );
94 G_MISS_khrv_rec khrv_rec_type;
95 TYPE khrv_tbl_type IS TABLE OF khrv_rec_type
96 INDEX BY BINARY_INTEGER;
97 -- OKS_K_HEADERS_B Record Spec
98 TYPE khr_rec_type IS RECORD (
99 id NUMBER := OKC_API.G_MISS_NUM
100 , chr_id NUMBER := OKC_API.G_MISS_NUM
101 , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
102 , payment_type OKS_K_HEADERS_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
103 , cc_no OKS_K_HEADERS_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR
104 , cc_expiry_date OKS_K_HEADERS_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
105 , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
106 , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
107 , commitment_id NUMBER := OKC_API.G_MISS_NUM
108 , grace_duration NUMBER := OKC_API.G_MISS_NUM
109 , grace_period OKS_K_HEADERS_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
110 , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
111 , est_rev_date OKS_K_HEADERS_B.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
112 , tax_amount NUMBER := OKC_API.G_MISS_NUM
113 , tax_status OKS_K_HEADERS_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
114 , tax_code NUMBER := OKC_API.G_MISS_NUM
115 , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
116 , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
117 , renewal_status OKS_K_HEADERS_B.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
118 , electronic_renewal_flag OKS_K_HEADERS_B.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
119 , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
120 , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
121 , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
122 , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
123 , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
124 , renewal_po_required OKS_K_HEADERS_B.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
125 , renewal_po_number OKS_K_HEADERS_B.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
126 , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
127 , renewal_pricing_type OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
128 , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
129 , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
130 , renewal_grace_period OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
131 , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
132 , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
133 , renewal_est_rev_period OKS_K_HEADERS_B.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
134 , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
135 , renewal_type_used OKS_K_HEADERS_B.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
136 , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
137 , renewal_po_used OKS_K_HEADERS_B.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
138 , renewal_pricing_type_used OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
139 , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
140 , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
141 , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
142 , rev_est_period_used OKS_K_HEADERS_B.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
143 , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
144 , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
145 , evn_threshold_cur OKS_K_HEADERS_B.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
146 , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
147 , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
148 , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
149 , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
150 , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
151 , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
152 , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
153 , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
154 , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
155 , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
156 , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
157 , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
158 , object_version_number NUMBER := OKC_API.G_MISS_NUM
159 , request_id NUMBER := OKC_API.G_MISS_NUM
160 , created_by NUMBER := OKC_API.G_MISS_NUM
161 , creation_date OKS_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
165 , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
162 , last_updated_by NUMBER := OKC_API.G_MISS_NUM
163 , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
164 , last_update_login NUMBER := OKC_API.G_MISS_NUM
166 , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
167 , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
168 , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
169 , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
170 , accepted_by NUMBER := OKC_API.G_MISS_NUM
171 , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
172 , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
173 , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
174 , process_request_id NUMBER := OKC_API.G_MISS_NUM
175 , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
176 , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
177 , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
178 , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
179 , person_party_id NUMBER := OKC_API.G_MISS_NUM
180 , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
181 , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
182 , exempt_reason_code OKS_K_HEADERS_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
183 , approval_type_used OKS_K_HEADERS_B.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR );
184 G_MISS_khr_rec khr_rec_type;
185 TYPE khr_tbl_type IS TABLE OF khr_rec_type
186 INDEX BY BINARY_INTEGER;
187 ---------------------------------------------------------------------------
188 -- GLOBAL MESSAGE CONSTANTS
189 ---------------------------------------------------------------------------
190 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
191 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
192 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
193 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
194 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
195 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
196 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
197 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
198 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
199 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
200 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
201 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
202 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
203
204 ---------------------------------------------------------------------------
205 -- GLOBAL EXCEPTIONS
206 ---------------------------------------------------------------------------
207 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
208
209 ---------------------------------------------------------------------------
210 -- GLOBAL VARIABLES
211 ---------------------------------------------------------------------------
212 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_KHR_PVT';
213 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
214 ---------------------------------------------------------------------------
215 -- Procedures and Functions
216 ---------------------------------------------------------------------------
217
218 PROCEDURE qc;
219 PROCEDURE change_version;
220 PROCEDURE api_copy;
221 PROCEDURE insert_row(
222 p_api_version IN NUMBER,
223 p_init_msg_list IN VARCHAR2,
224 x_return_status OUT NOCOPY VARCHAR2,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 p_khrv_rec IN khrv_rec_type,
228 x_khrv_rec OUT NOCOPY khrv_rec_type);
229 PROCEDURE insert_row(
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2,
235 p_khrv_tbl IN khrv_tbl_type,
236 x_khrv_tbl OUT NOCOPY khrv_tbl_type,
237 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
238 PROCEDURE insert_row(
239 p_api_version IN NUMBER,
240 p_init_msg_list IN VARCHAR2,
241 x_return_status OUT NOCOPY VARCHAR2,
242 x_msg_count OUT NOCOPY NUMBER,
243 x_msg_data OUT NOCOPY VARCHAR2,
244 p_khrv_tbl IN khrv_tbl_type,
245 x_khrv_tbl OUT NOCOPY khrv_tbl_type);
246 PROCEDURE lock_row(
247 p_api_version IN NUMBER,
248 p_init_msg_list IN VARCHAR2,
249 x_return_status OUT NOCOPY VARCHAR2,
250 x_msg_count OUT NOCOPY NUMBER,
251 x_msg_data OUT NOCOPY VARCHAR2,
252 p_khrv_rec IN khrv_rec_type);
253 PROCEDURE lock_row(
254 p_api_version IN NUMBER,
255 p_init_msg_list IN VARCHAR2,
256 x_return_status OUT NOCOPY VARCHAR2,
257 x_msg_count OUT NOCOPY NUMBER,
258 x_msg_data OUT NOCOPY VARCHAR2,
259 p_khrv_tbl IN khrv_tbl_type,
260 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
261 PROCEDURE lock_row(
262 p_api_version IN NUMBER,
263 p_init_msg_list IN VARCHAR2,
264 x_return_status OUT NOCOPY VARCHAR2,
265 x_msg_count OUT NOCOPY NUMBER,
266 x_msg_data OUT NOCOPY VARCHAR2,
267 p_khrv_tbl IN khrv_tbl_type);
268 PROCEDURE update_row(
269 p_api_version IN NUMBER,
270 p_init_msg_list IN VARCHAR2,
271 x_return_status OUT NOCOPY VARCHAR2,
272 x_msg_count OUT NOCOPY NUMBER,
273 x_msg_data OUT NOCOPY VARCHAR2,
274 p_khrv_rec IN khrv_rec_type,
275 x_khrv_rec OUT NOCOPY khrv_rec_type);
276 PROCEDURE update_row(
277 p_api_version IN NUMBER,
278 p_init_msg_list IN VARCHAR2,
279 x_return_status OUT NOCOPY VARCHAR2,
280 x_msg_count OUT NOCOPY NUMBER,
281 x_msg_data OUT NOCOPY VARCHAR2,
282 p_khrv_tbl IN khrv_tbl_type,
283 x_khrv_tbl OUT NOCOPY khrv_tbl_type,
284 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
285 PROCEDURE update_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_khrv_tbl IN khrv_tbl_type,
292 x_khrv_tbl OUT NOCOPY khrv_tbl_type);
293 PROCEDURE delete_row(
294 p_api_version IN NUMBER,
295 p_init_msg_list IN VARCHAR2,
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_msg_count OUT NOCOPY NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2,
299 p_khrv_rec IN khrv_rec_type);
300 PROCEDURE delete_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_khrv_tbl IN khrv_tbl_type,
307 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
308 PROCEDURE delete_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_khrv_tbl IN khrv_tbl_type);
315 PROCEDURE validate_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_khrv_rec IN khrv_rec_type);
322 PROCEDURE validate_row(
323 p_api_version IN NUMBER,
324 p_init_msg_list IN VARCHAR2,
325 x_return_status OUT NOCOPY VARCHAR2,
326 x_msg_count OUT NOCOPY NUMBER,
327 x_msg_data OUT NOCOPY VARCHAR2,
328 p_khrv_tbl IN khrv_tbl_type,
329 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
330 PROCEDURE validate_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_khrv_tbl IN khrv_tbl_type);
337 END OKS_KHR_PVT;