[Home] [Help]
PACKAGE: APPS.OKS_KHR_PVT
Source
1 PACKAGE OKS_KHR_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSSKHRS.pls 120.5.12020000.2 2013/02/13 06:23:03 mchandak ship $ */
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 , renewal_comment OKS_K_HEADERS_V.RENEWAL_COMMENT%TYPE := OKC_API.G_MISS_CHAR
95 , cc_email_address OKS_K_HEADERS_B.CC_EMAIl_ADDRESS%TYPE := OKC_API.G_MISS_CHAR); /*Added for ER 13869562*/
96 G_MISS_khrv_rec khrv_rec_type;
97 TYPE khrv_tbl_type IS TABLE OF khrv_rec_type
98 INDEX BY BINARY_INTEGER;
99 -- OKS_K_HEADERS_B Record Spec
100 TYPE khr_rec_type IS RECORD (
101 id NUMBER := OKC_API.G_MISS_NUM
102 , chr_id NUMBER := OKC_API.G_MISS_NUM
103 , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
104 , payment_type OKS_K_HEADERS_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
105 , cc_no OKS_K_HEADERS_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR
106 , cc_expiry_date OKS_K_HEADERS_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
107 , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
108 , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
109 , commitment_id NUMBER := OKC_API.G_MISS_NUM
110 , grace_duration NUMBER := OKC_API.G_MISS_NUM
111 , grace_period OKS_K_HEADERS_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
112 , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
113 , est_rev_date OKS_K_HEADERS_B.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
114 , tax_amount NUMBER := OKC_API.G_MISS_NUM
115 , tax_status OKS_K_HEADERS_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
116 , tax_code NUMBER := OKC_API.G_MISS_NUM
117 , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
118 , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
119 , renewal_status OKS_K_HEADERS_B.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
120 , electronic_renewal_flag OKS_K_HEADERS_B.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
121 , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
122 , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
123 , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
124 , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
125 , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
126 , renewal_po_required OKS_K_HEADERS_B.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
127 , renewal_po_number OKS_K_HEADERS_B.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
128 , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
129 , renewal_pricing_type OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
130 , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
131 , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
132 , renewal_grace_period OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
133 , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
134 , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
135 , renewal_est_rev_period OKS_K_HEADERS_B.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
136 , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
137 , renewal_type_used OKS_K_HEADERS_B.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
138 , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
139 , renewal_po_used OKS_K_HEADERS_B.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
140 , renewal_pricing_type_used OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
141 , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
142 , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
143 , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
144 , rev_est_period_used OKS_K_HEADERS_B.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
145 , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
146 , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
147 , evn_threshold_cur OKS_K_HEADERS_B.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
148 , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
149 , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
150 , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
151 , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
152 , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
153 , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
154 , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
155 , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
156 , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
157 , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
158 , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
159 , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
160 , object_version_number NUMBER := OKC_API.G_MISS_NUM
161 , request_id NUMBER := OKC_API.G_MISS_NUM
162 , created_by NUMBER := OKC_API.G_MISS_NUM
163 , creation_date OKS_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
164 , last_updated_by NUMBER := OKC_API.G_MISS_NUM
165 , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
166 , last_update_login NUMBER := OKC_API.G_MISS_NUM
167 , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
168 , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
169 , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
170 , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
171 , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
172 , accepted_by NUMBER := OKC_API.G_MISS_NUM
173 , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
174 , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
175 , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
176 , process_request_id NUMBER := OKC_API.G_MISS_NUM
177 , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
178 , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
179 , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
180 , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
181 , person_party_id NUMBER := OKC_API.G_MISS_NUM
182 , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
183 , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
184 , exempt_reason_code OKS_K_HEADERS_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
185 , approval_type_used OKS_K_HEADERS_B.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
186 , renewal_comment OKS_K_HEADERS_B.renewal_comment%TYPE := OKC_API.G_MISS_CHAR
187 , cc_email_address OKS_K_HEADERS_B.CC_EMAIl_ADDRESS%TYPE := OKC_API.G_MISS_CHAR); /*Added for ER 13869562*/
188 G_MISS_khr_rec khr_rec_type;
189 TYPE khr_tbl_type IS TABLE OF khr_rec_type
190 INDEX BY BINARY_INTEGER;
191 ---------------------------------------------------------------------------
192 -- GLOBAL MESSAGE CONSTANTS
193 ---------------------------------------------------------------------------
194 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
195 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
196 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
197 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
198 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
199 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
200 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
201 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
202 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
203 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
204 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
205 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
206 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
207
208 ---------------------------------------------------------------------------
209 -- GLOBAL EXCEPTIONS
210 ---------------------------------------------------------------------------
211 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
212
213 ---------------------------------------------------------------------------
214 -- GLOBAL VARIABLES
215 ---------------------------------------------------------------------------
216 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_KHR_PVT';
217 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
218 ---------------------------------------------------------------------------
219 -- Procedures and Functions
220 ---------------------------------------------------------------------------
221
222 PROCEDURE qc;
223 PROCEDURE change_version;
224 PROCEDURE api_copy;
225 PROCEDURE insert_row(
226 p_api_version IN NUMBER,
227 p_init_msg_list IN VARCHAR2,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 p_khrv_rec IN khrv_rec_type,
232 x_khrv_rec OUT NOCOPY khrv_rec_type);
233 PROCEDURE insert_row(
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 p_khrv_tbl IN khrv_tbl_type,
240 x_khrv_tbl OUT NOCOPY khrv_tbl_type,
241 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
242 PROCEDURE insert_row(
243 p_api_version IN NUMBER,
244 p_init_msg_list IN VARCHAR2,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2,
248 p_khrv_tbl IN khrv_tbl_type,
249 x_khrv_tbl OUT NOCOPY khrv_tbl_type);
250 PROCEDURE lock_row(
251 p_api_version IN NUMBER,
252 p_init_msg_list IN VARCHAR2,
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2,
256 p_khrv_rec IN khrv_rec_type);
257 PROCEDURE lock_row(
258 p_api_version IN NUMBER,
259 p_init_msg_list IN VARCHAR2,
260 x_return_status OUT NOCOPY VARCHAR2,
261 x_msg_count OUT NOCOPY NUMBER,
262 x_msg_data OUT NOCOPY VARCHAR2,
263 p_khrv_tbl IN khrv_tbl_type,
264 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
265 PROCEDURE lock_row(
266 p_api_version IN NUMBER,
267 p_init_msg_list IN VARCHAR2,
268 x_return_status OUT NOCOPY VARCHAR2,
269 x_msg_count OUT NOCOPY NUMBER,
270 x_msg_data OUT NOCOPY VARCHAR2,
271 p_khrv_tbl IN khrv_tbl_type);
272 PROCEDURE update_row(
273 p_api_version IN NUMBER,
274 p_init_msg_list IN VARCHAR2,
275 x_return_status OUT NOCOPY VARCHAR2,
276 x_msg_count OUT NOCOPY NUMBER,
277 x_msg_data OUT NOCOPY VARCHAR2,
278 p_khrv_rec IN khrv_rec_type,
279 x_khrv_rec OUT NOCOPY khrv_rec_type);
280 PROCEDURE update_row(
281 p_api_version IN NUMBER,
282 p_init_msg_list IN VARCHAR2,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_msg_count OUT NOCOPY NUMBER,
285 x_msg_data OUT NOCOPY VARCHAR2,
286 p_khrv_tbl IN khrv_tbl_type,
287 x_khrv_tbl OUT NOCOPY khrv_tbl_type,
288 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
289 PROCEDURE update_row(
290 p_api_version IN NUMBER,
291 p_init_msg_list IN VARCHAR2,
292 x_return_status OUT NOCOPY VARCHAR2,
293 x_msg_count OUT NOCOPY NUMBER,
294 x_msg_data OUT NOCOPY VARCHAR2,
295 p_khrv_tbl IN khrv_tbl_type,
296 x_khrv_tbl OUT NOCOPY khrv_tbl_type);
297 PROCEDURE delete_row(
298 p_api_version IN NUMBER,
299 p_init_msg_list IN VARCHAR2,
300 x_return_status OUT NOCOPY VARCHAR2,
301 x_msg_count OUT NOCOPY NUMBER,
302 x_msg_data OUT NOCOPY VARCHAR2,
303 p_khrv_rec IN khrv_rec_type);
304 PROCEDURE delete_row(
305 p_api_version IN NUMBER,
306 p_init_msg_list IN VARCHAR2,
307 x_return_status OUT NOCOPY VARCHAR2,
308 x_msg_count OUT NOCOPY NUMBER,
309 x_msg_data OUT NOCOPY VARCHAR2,
310 p_khrv_tbl IN khrv_tbl_type,
311 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
312 PROCEDURE delete_row(
313 p_api_version IN NUMBER,
314 p_init_msg_list IN VARCHAR2,
315 x_return_status OUT NOCOPY VARCHAR2,
316 x_msg_count OUT NOCOPY NUMBER,
317 x_msg_data OUT NOCOPY VARCHAR2,
318 p_khrv_tbl IN khrv_tbl_type);
319 PROCEDURE validate_row(
320 p_api_version IN NUMBER,
321 p_init_msg_list IN VARCHAR2,
322 x_return_status OUT NOCOPY VARCHAR2,
323 x_msg_count OUT NOCOPY NUMBER,
324 x_msg_data OUT NOCOPY VARCHAR2,
325 p_khrv_rec IN khrv_rec_type);
326 PROCEDURE validate_row(
327 p_api_version IN NUMBER,
328 p_init_msg_list IN VARCHAR2,
329 x_return_status OUT NOCOPY VARCHAR2,
330 x_msg_count OUT NOCOPY NUMBER,
331 x_msg_data OUT NOCOPY VARCHAR2,
332 p_khrv_tbl IN khrv_tbl_type,
333 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
334 PROCEDURE validate_row(
335 p_api_version IN NUMBER,
336 p_init_msg_list IN VARCHAR2,
337 x_return_status OUT NOCOPY VARCHAR2,
338 x_msg_count OUT NOCOPY NUMBER,
339 x_msg_data OUT NOCOPY VARCHAR2,
340 p_khrv_tbl IN khrv_tbl_type);
341 END OKS_KHR_PVT;