[Home] [Help]
PACKAGE: APPS.OKL_QTE_PVT
Source
1 Package OKL_QTE_PVT AS
2 /* $Header: OKLSQTES.pls 120.3 2007/11/05 20:09:17 apaul noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE qte_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 qrs_code OKL_TRX_QUOTES_B.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
9 qst_code OKL_TRX_QUOTES_B.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
10 consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
11 khr_id NUMBER := OKC_API.G_MISS_NUM,
12 art_id NUMBER := OKC_API.G_MISS_NUM,
13 qtp_code OKL_TRX_QUOTES_B.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
14 trn_code OKL_TRX_QUOTES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
15 pop_code_end OKL_TRX_QUOTES_B.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
16 pop_code_early OKL_TRX_QUOTES_B.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
17 pdt_id NUMBER := OKC_API.G_MISS_NUM,
18 date_effective_from OKL_TRX_QUOTES_B.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
19 quote_number NUMBER := OKC_API.G_MISS_NUM,
20 object_version_number NUMBER := OKC_API.G_MISS_NUM,
21 purchase_percent NUMBER := OKC_API.G_MISS_NUM,
22 term NUMBER := OKC_API.G_MISS_NUM,
23 date_restructure_start OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
24 date_due OKL_TRX_QUOTES_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
25 date_approved OKL_TRX_QUOTES_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
26 date_restructure_end OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
27 remaining_payments NUMBER := OKC_API.G_MISS_NUM,
28 rent_amount NUMBER := OKC_API.G_MISS_NUM,
29 yield NUMBER := OKC_API.G_MISS_NUM,
30 residual_amount NUMBER := OKC_API.G_MISS_NUM,
31 principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
32 payment_frequency OKL_TRX_QUOTES_B.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
33 early_termination_yn OKL_TRX_QUOTES_B.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
34 partial_yn OKL_TRX_QUOTES_B.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
35 preproceeds_yn OKL_TRX_QUOTES_B.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
36 summary_format_yn OKL_TRX_QUOTES_B.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
37 consolidated_yn OKL_TRX_QUOTES_B.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
38 date_requested OKL_TRX_QUOTES_B.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
39 date_proposal OKL_TRX_QUOTES_B.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
40 date_effective_to OKL_TRX_QUOTES_B.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
41 date_accepted OKL_TRX_QUOTES_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
42 payment_received_yn OKL_TRX_QUOTES_B.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
43 requested_by NUMBER := OKC_API.G_MISS_NUM,
44 approved_yn OKL_TRX_QUOTES_B.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
45 accepted_yn OKL_TRX_QUOTES_B.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
46 date_payment_received OKL_TRX_QUOTES_B.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
47 approved_by NUMBER := OKC_API.G_MISS_NUM,
48 org_id NUMBER := OKC_API.G_MISS_NUM,
49 request_id NUMBER := OKC_API.G_MISS_NUM,
50 program_application_id NUMBER := OKC_API.G_MISS_NUM,
51 program_id NUMBER := OKC_API.G_MISS_NUM,
52 program_update_date OKL_TRX_QUOTES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
53 attribute_category OKL_TRX_QUOTES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
54 attribute1 OKL_TRX_QUOTES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
55 attribute2 OKL_TRX_QUOTES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
56 attribute3 OKL_TRX_QUOTES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
57 attribute4 OKL_TRX_QUOTES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
58 attribute5 OKL_TRX_QUOTES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
59 attribute6 OKL_TRX_QUOTES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
60 attribute7 OKL_TRX_QUOTES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
61 attribute8 OKL_TRX_QUOTES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
62 attribute9 OKL_TRX_QUOTES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
63 attribute10 OKL_TRX_QUOTES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
64 attribute11 OKL_TRX_QUOTES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
65 attribute12 OKL_TRX_QUOTES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
66 attribute13 OKL_TRX_QUOTES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
67 attribute14 OKL_TRX_QUOTES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
68 attribute15 OKL_TRX_QUOTES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
69 created_by NUMBER := OKC_API.G_MISS_NUM,
70 creation_date OKL_TRX_QUOTES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
71 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72 last_update_date OKL_TRX_QUOTES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
73 last_update_login NUMBER := OKC_API.G_MISS_NUM,
74 purchase_amount NUMBER := OKC_API.G_MISS_NUM,
75 purchase_formula OKL_TRX_QUOTES_B.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
76 asset_value NUMBER := OKC_API.G_MISS_NUM,
77 residual_value NUMBER := OKC_API.G_MISS_NUM,
78 unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
79 gain_loss NUMBER := OKC_API.G_MISS_NUM,
80 PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
81 -- BAKUCHIB - 2667636 - start
82 currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
83 currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
84 currency_conversion_type OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
85 currency_conversion_rate OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
86 currency_conversion_date OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
87 -- BAKUCHIB - 2667636 - End
88 legal_entity_id OKL_TRX_QUOTES_B.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM, --dkagrawa for LE Uptake
89 repo_quote_indicator_yn OKL_TRX_QUOTES_B.REPO_QUOTE_INDICATOR_YN%TYPE := OKL_API.G_MISS_CHAR -- AKP:REPO-QUOTE-START-END 6599890
90 );
91
92 g_miss_qte_rec qte_rec_type;
93 TYPE qte_tbl_type IS TABLE OF qte_rec_type
94 INDEX BY BINARY_INTEGER;
95 TYPE okl_trx_quotes_tl_rec_type IS RECORD (
96 id NUMBER := OKC_API.G_MISS_NUM,
97 language OKL_TRX_QUOTES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
98 source_lang OKL_TRX_QUOTES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
99 sfwt_flag OKL_TRX_QUOTES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
100 comments OKL_TRX_QUOTES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
101 created_by NUMBER := OKC_API.G_MISS_NUM,
102 creation_date OKL_TRX_QUOTES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
103 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
104 last_update_date OKL_TRX_QUOTES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
105 last_update_login NUMBER := OKC_API.G_MISS_NUM);
106 g_miss_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
107 TYPE okl_trx_quotes_tl_tbl_type IS TABLE OF okl_trx_quotes_tl_rec_type
108 INDEX BY BINARY_INTEGER;
109 TYPE qtev_rec_type IS RECORD (
110 id NUMBER := OKC_API.G_MISS_NUM,
111 object_version_number NUMBER := OKC_API.G_MISS_NUM,
112 sfwt_flag OKL_TRX_QUOTES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
113 qrs_code OKL_TRX_QUOTES_V.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
114 qst_code OKL_TRX_QUOTES_V.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
115 qtp_code OKL_TRX_QUOTES_V.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
116 trn_code OKL_TRX_QUOTES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
117 pop_code_end OKL_TRX_QUOTES_V.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
118 pop_code_early OKL_TRX_QUOTES_V.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
119 consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
120 khr_id NUMBER := OKC_API.G_MISS_NUM,
121 art_id NUMBER := OKC_API.G_MISS_NUM,
122 pdt_id NUMBER := OKC_API.G_MISS_NUM,
123 early_termination_yn OKL_TRX_QUOTES_V.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
124 partial_yn OKL_TRX_QUOTES_V.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
125 preproceeds_yn OKL_TRX_QUOTES_V.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
126 date_requested OKL_TRX_QUOTES_V.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
127 date_proposal OKL_TRX_QUOTES_V.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
128 date_effective_to OKL_TRX_QUOTES_V.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
129 date_accepted OKL_TRX_QUOTES_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
130 summary_format_yn OKL_TRX_QUOTES_V.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
131 consolidated_yn OKL_TRX_QUOTES_V.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
132 principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
133 residual_amount NUMBER := OKC_API.G_MISS_NUM,
134 yield NUMBER := OKC_API.G_MISS_NUM,
135 rent_amount NUMBER := OKC_API.G_MISS_NUM,
136 date_restructure_end OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
137 date_restructure_start OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
138 term NUMBER := OKC_API.G_MISS_NUM,
139 purchase_percent NUMBER := OKC_API.G_MISS_NUM,
140 comments OKL_TRX_QUOTES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
141 date_due OKL_TRX_QUOTES_V.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
142 payment_frequency OKL_TRX_QUOTES_V.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
143 remaining_payments NUMBER := OKC_API.G_MISS_NUM,
144 date_effective_from OKL_TRX_QUOTES_V.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
145 quote_number NUMBER := OKC_API.G_MISS_NUM,
146 requested_by NUMBER := OKC_API.G_MISS_NUM,
147 approved_yn OKL_TRX_QUOTES_V.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
148 accepted_yn OKL_TRX_QUOTES_V.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
149 payment_received_yn OKL_TRX_QUOTES_V.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
150 date_payment_received OKL_TRX_QUOTES_V.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
151 attribute_category OKL_TRX_QUOTES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
152 attribute1 OKL_TRX_QUOTES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
153 attribute2 OKL_TRX_QUOTES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
154 attribute3 OKL_TRX_QUOTES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
155 attribute4 OKL_TRX_QUOTES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
156 attribute5 OKL_TRX_QUOTES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
157 attribute6 OKL_TRX_QUOTES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
158 attribute7 OKL_TRX_QUOTES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
159 attribute8 OKL_TRX_QUOTES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
160 attribute9 OKL_TRX_QUOTES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
161 attribute10 OKL_TRX_QUOTES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
162 attribute11 OKL_TRX_QUOTES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
163 attribute12 OKL_TRX_QUOTES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
164 attribute13 OKL_TRX_QUOTES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
165 attribute14 OKL_TRX_QUOTES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
166 attribute15 OKL_TRX_QUOTES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
167 date_approved OKL_TRX_QUOTES_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
168 approved_by NUMBER := OKC_API.G_MISS_NUM,
169 org_id NUMBER := OKC_API.G_MISS_NUM,
170 request_id NUMBER := OKC_API.G_MISS_NUM,
171 program_application_id NUMBER := OKC_API.G_MISS_NUM,
172 program_id NUMBER := OKC_API.G_MISS_NUM,
173 program_update_date OKL_TRX_QUOTES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
174 created_by NUMBER := OKC_API.G_MISS_NUM,
175 creation_date OKL_TRX_QUOTES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
176 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
177 last_update_date OKL_TRX_QUOTES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
178 last_update_login NUMBER := OKC_API.G_MISS_NUM,
179 purchase_amount NUMBER := OKC_API.G_MISS_NUM,
180 purchase_formula OKL_TRX_QUOTES_V.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
181 asset_value NUMBER := OKC_API.G_MISS_NUM,
182 residual_value NUMBER := OKC_API.G_MISS_NUM,
183 unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
184 gain_loss NUMBER := OKC_API.G_MISS_NUM,
185 PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
186 -- BAKUCHIB - 2667636 - start
187 currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
188 currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
189 currency_conversion_type OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
190 currency_conversion_rate OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
191 currency_conversion_date OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
192 -- BAKUCHIB - 2667636 - end
193 legal_entity_id OKL_TRX_QUOTES_B.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM, --dkagrawa for LE Uptake
194 repo_quote_indicator_yn OKL_TRX_QUOTES_B.REPO_QUOTE_INDICATOR_YN%TYPE := OKL_API.G_MISS_CHAR -- AKP:REPO-QUOTE-START-END 6599890
195 );
196 g_miss_qtev_rec qtev_rec_type;
197 TYPE qtev_tbl_type IS TABLE OF qtev_rec_type
198 INDEX BY BINARY_INTEGER;
199 ---------------------------------------------------------------------------
200 -- GLOBAL MESSAGE CONSTANTS
201 ---------------------------------------------------------------------------
202 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
203 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
204 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
205 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
206 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
207 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
208 G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
209 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
210 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
211 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
212 ---------------------------------------------------------------------------
213 -- GLOBAL VARIABLES
214 ---------------------------------------------------------------------------
215 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_QTE_PVT';
216 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
217 ---------------------------------------------------------------------------
218 -- Procedures and Functions
219 ---------------------------------------------------------------------------
220
221 PROCEDURE qc;
222 PROCEDURE change_version;
223 PROCEDURE api_copy;
224 PROCEDURE add_language;
225 PROCEDURE insert_row(
226 p_api_version IN NUMBER,
227 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 p_qtev_rec IN qtev_rec_type,
232 x_qtev_rec OUT NOCOPY qtev_rec_type);
233
234 PROCEDURE insert_row(
235 p_api_version IN NUMBER,
236 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2,
240 p_qtev_tbl IN qtev_tbl_type,
241 x_qtev_tbl OUT NOCOPY qtev_tbl_type);
242
243 PROCEDURE lock_row(
244 p_api_version IN NUMBER,
245 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
246 x_return_status OUT NOCOPY VARCHAR2,
247 x_msg_count OUT NOCOPY NUMBER,
248 x_msg_data OUT NOCOPY VARCHAR2,
249 p_qtev_rec IN qtev_rec_type);
250
251 PROCEDURE lock_row(
252 p_api_version IN NUMBER,
253 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 p_qtev_tbl IN qtev_tbl_type);
258
259 PROCEDURE update_row(
260 p_api_version IN NUMBER,
261 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
262 x_return_status OUT NOCOPY VARCHAR2,
263 x_msg_count OUT NOCOPY NUMBER,
264 x_msg_data OUT NOCOPY VARCHAR2,
265 p_qtev_rec IN qtev_rec_type,
266 x_qtev_rec OUT NOCOPY qtev_rec_type);
267
268 PROCEDURE update_row(
269 p_api_version IN NUMBER,
270 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
271 x_return_status OUT NOCOPY VARCHAR2,
272 x_msg_count OUT NOCOPY NUMBER,
273 x_msg_data OUT NOCOPY VARCHAR2,
274 p_qtev_tbl IN qtev_tbl_type,
275 x_qtev_tbl OUT NOCOPY qtev_tbl_type);
276
277 PROCEDURE delete_row(
278 p_api_version IN NUMBER,
279 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
280 x_return_status OUT NOCOPY VARCHAR2,
281 x_msg_count OUT NOCOPY NUMBER,
282 x_msg_data OUT NOCOPY VARCHAR2,
283 p_qtev_rec IN qtev_rec_type);
284
285 PROCEDURE delete_row(
286 p_api_version IN NUMBER,
287 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
288 x_return_status OUT NOCOPY VARCHAR2,
289 x_msg_count OUT NOCOPY NUMBER,
290 x_msg_data OUT NOCOPY VARCHAR2,
291 p_qtev_tbl IN qtev_tbl_type);
292
293 PROCEDURE validate_row(
294 p_api_version IN NUMBER,
295 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_msg_count OUT NOCOPY NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2,
299 p_qtev_rec IN qtev_rec_type);
300
301 PROCEDURE validate_row(
302 p_api_version IN NUMBER,
303 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
304 x_return_status OUT NOCOPY VARCHAR2,
305 x_msg_count OUT NOCOPY NUMBER,
306 x_msg_data OUT NOCOPY VARCHAR2,
307 p_qtev_tbl IN qtev_tbl_type);
308
309 END OKL_QTE_PVT;