1 package body XTR_REVALUATION_DETAILS_PKG as
2 /* $Header: xtrrdetb.pls 120.2 2005/06/29 10:29:31 rjose noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_REVALUATION_DETAILS_ID in NUMBER,
6 X_ACCOUNT_NO in VARCHAR2,
7 X_REVAL_CURR_FV_AMOUNT in NUMBER,
8 X_COMPLETE_FLAG in VARCHAR2,
9 X_FAIR_VALUE in NUMBER,
10 X_SWAP_REF in VARCHAR2,
11 X_CUMM_GAIN_LOSS_AMOUNT in NUMBER,
12 X_CURR_GAIN_LOSS_AMOUNT in NUMBER,
13 X_SOB_FV_GAIN_LOSS_AMOUNT in NUMBER,
14 X_SOB_FAIR_VALUE_AMOUNT in NUMBER,
15 X_CTR_CURR_SOB_CURR_FWD_RATE in NUMBER,
16 X_EXCHANGE_RATE_TWO in NUMBER,
17 X_ACTION_CODE in VARCHAR2,
18 X_COMPANY_CODE in VARCHAR2,
19 X_CONTRACT_CODE in VARCHAR2,
20 X_CURRENCYA in VARCHAR2,
21 X_CURRENCYB in VARCHAR2,
22 X_DEAL_NO in NUMBER,
23 X_DEAL_SUBTYPE in VARCHAR2,
24 X_DEAL_TYPE in VARCHAR2,
25 X_EFFECTIVE_DATE in DATE,
26 X_EFFECTIVE_DAYS in NUMBER,
27 X_ENTERED_BY in VARCHAR2,
28 X_ENTERED_ON in DATE,
29 X_FACE_VALUE in NUMBER,
30 X_FXO_SELL_REF_AMOUNT in NUMBER,
31 X_PERIOD_FROM in DATE,
32 X_PERIOD_TO in DATE,
33 X_PORTFOLIO_CODE in VARCHAR2,
34 X_PRODUCT_TYPE in VARCHAR2,
35 X_REALISED_PL in NUMBER,
36 X_REVAL_CCY in VARCHAR2,
37 X_REVAL_RATE in NUMBER,
38 X_TRANSACTION_NO in NUMBER,
39 X_TRANSACTION_PERIOD in NUMBER,
40 X_TRANSACTION_RATE in NUMBER,
41 X_UNREALISED_PL in NUMBER,
42 X_UPDATED_BY in VARCHAR2,
43 X_UPDATED_ON in DATE,
44 X_YEAR_BASIS in NUMBER,
45 X_CREATED_ON in DATE,
46 X_EXCHANGE_RATE_ONE in NUMBER,
47 X_REALIZED_FLAG in VARCHAR2,
48 X_OVERWRITE_TYPE in VARCHAR2,
49 X_OVERWRITE_VALUE in NUMBER,
50 X_OVERWRITE_REASON in VARCHAR2,
51 X_BATCH_ID in NUMBER,
52 X_CREATED_BY in NUMBER,
53 X_NI_DISC_AMOUNT in NUMBER,
54 X_AMOUNT_TYPE in VARCHAR2,
55 X_QUANTITY in NUMBER
56 ) is
57 cursor C is select ROWID from XTR_REVALUATION_DETAILS
58 where REVALUATION_DETAILS_ID = X_REVALUATION_DETAILS_ID
59 ;
60 begin
61 insert into XTR_REVALUATION_DETAILS (
62 ACCOUNT_NO,
63 BATCH_ID,
64 REVALUATION_DETAILS_ID,
65 REVAL_CURR_FV_AMOUNT,
66 COMPLETE_FLAG,
67 FAIR_VALUE,
68 SWAP_REF,
69 CUMM_GAIN_LOSS_AMOUNT,
70 CURR_GAIN_LOSS_AMOUNT,
71 SOB_FV_GAIN_LOSS_AMOUNT,
72 SOB_FAIR_VALUE_AMOUNT,
73 CTR_CURR_SOB_CURR_FWD_RATE,
74 EXCHANGE_RATE_TWO,
75 ACTION_CODE,
76 COMPANY_CODE,
77 CONTRACT_CODE,
78 CURRENCYA,
79 CURRENCYB,
80 DEAL_NO,
81 DEAL_SUBTYPE,
82 DEAL_TYPE,
83 EFFECTIVE_DATE,
84 EFFECTIVE_DAYS,
85 ENTERED_BY,
86 ENTERED_ON,
87 FACE_VALUE,
88 FXO_SELL_REF_AMOUNT,
89 PERIOD_FROM,
90 PERIOD_TO,
91 PORTFOLIO_CODE,
92 PRODUCT_TYPE,
93 REALISED_PL,
94 REVAL_CCY,
95 REVAL_RATE,
96 TRANSACTION_NO,
97 TRANSACTION_PERIOD,
98 TRANSACTION_RATE,
99 UNREALISED_PL,
100 UPDATED_BY,
101 UPDATED_ON,
102 YEAR_BASIS,
103 CREATED_BY,
104 CREATED_ON,
105 EXCHANGE_RATE_ONE,
106 REALIZED_FLAG,
107 OVERWRITE_TYPE,
108 OVERWRITE_VALUE,
109 OVERWRITE_REASON,
110 NI_DISC_AMOUNT,
111 AMOUNT_TYPE,
112 QUANTITY
113 ) values
114 (
115 X_ACCOUNT_NO,
116 X_BATCH_ID,
117 X_REVALUATION_DETAILS_ID,
118 X_REVAL_CURR_FV_AMOUNT,
119 X_COMPLETE_FLAG,
120 X_FAIR_VALUE,
121 X_SWAP_REF,
122 X_CUMM_GAIN_LOSS_AMOUNT,
123 X_CURR_GAIN_LOSS_AMOUNT,
124 X_SOB_FV_GAIN_LOSS_AMOUNT,
125 X_SOB_FAIR_VALUE_AMOUNT,
126 X_CTR_CURR_SOB_CURR_FWD_RATE,
127 X_EXCHANGE_RATE_TWO,
128 X_ACTION_CODE,
129 X_COMPANY_CODE,
130 X_CONTRACT_CODE,
131 X_CURRENCYA,
132 X_CURRENCYB,
133 X_DEAL_NO,
134 X_DEAL_SUBTYPE,
135 X_DEAL_TYPE,
136 X_EFFECTIVE_DATE,
137 X_EFFECTIVE_DAYS,
138 X_ENTERED_BY,
139 X_ENTERED_ON,
140 X_FACE_VALUE,
141 X_FXO_SELL_REF_AMOUNT,
142 X_PERIOD_FROM,
143 X_PERIOD_TO,
144 X_PORTFOLIO_CODE,
145 X_PRODUCT_TYPE,
146 X_REALISED_PL,
147 X_REVAL_CCY,
148 X_REVAL_RATE,
149 X_TRANSACTION_NO,
150 X_TRANSACTION_PERIOD,
151 X_TRANSACTION_RATE,
152 X_UNREALISED_PL,
153 X_UPDATED_BY,
154 X_UPDATED_ON,
155 X_YEAR_BASIS,
156 X_CREATED_BY,
157 X_CREATED_ON,
158 X_EXCHANGE_RATE_ONE,
159 X_REALIZED_FLAG,
160 X_OVERWRITE_TYPE,
161 X_OVERWRITE_VALUE,
162 X_OVERWRITE_REASON,
163 X_NI_DISC_AMOUNT,
164 X_AMOUNT_TYPE,
165 X_QUANTITY
166 );
167
168 open c;
169 fetch c into X_ROWID;
170 if (c%notfound) then
171 close c;
172 raise no_data_found;
173 end if;
174 close c;
175
176 end INSERT_ROW;
177
178 procedure LOCK_ROW (
179 X_REVALUATION_DETAILS_ID in NUMBER,
180 X_ACCOUNT_NO in VARCHAR2,
181 X_REVAL_CURR_FV_AMOUNT in NUMBER,
182 X_COMPLETE_FLAG in VARCHAR2,
183 X_FAIR_VALUE in NUMBER,
184 X_SWAP_REF in VARCHAR2,
185 X_CUMM_GAIN_LOSS_AMOUNT in NUMBER,
186 X_CURR_GAIN_LOSS_AMOUNT in NUMBER,
187 X_SOB_FV_GAIN_LOSS_AMOUNT in NUMBER,
188 X_SOB_FAIR_VALUE_AMOUNT in NUMBER,
189 X_CTR_CURR_SOB_CURR_FWD_RATE in NUMBER,
190 X_EXCHANGE_RATE_TWO in NUMBER,
191 X_ACTION_CODE in VARCHAR2,
192 X_COMPANY_CODE in VARCHAR2,
193 X_CONTRACT_CODE in VARCHAR2,
194 X_CURRENCYA in VARCHAR2,
195 X_CURRENCYB in VARCHAR2,
196 X_DEAL_NO in NUMBER,
197 X_DEAL_SUBTYPE in VARCHAR2,
198 X_DEAL_TYPE in VARCHAR2,
199 X_EFFECTIVE_DATE in DATE,
200 X_EFFECTIVE_DAYS in NUMBER,
201 X_ENTERED_BY in VARCHAR2,
202 X_ENTERED_ON in DATE,
203 X_FACE_VALUE in NUMBER,
204 X_FXO_SELL_REF_AMOUNT in NUMBER,
205 X_PERIOD_FROM in DATE,
206 X_PERIOD_TO in DATE,
207 X_PORTFOLIO_CODE in VARCHAR2,
208 X_PRODUCT_TYPE in VARCHAR2,
209 X_REALISED_PL in NUMBER,
210 X_REVAL_CCY in VARCHAR2,
211 X_REVAL_RATE in NUMBER,
212 X_TRANSACTION_NO in NUMBER,
213 X_TRANSACTION_PERIOD in NUMBER,
214 X_TRANSACTION_RATE in NUMBER,
215 X_UNREALISED_PL in NUMBER,
216 X_UPDATED_BY in VARCHAR2,
217 X_UPDATED_ON in DATE,
218 X_YEAR_BASIS in NUMBER,
219 X_CREATED_ON in DATE,
220 X_EXCHANGE_RATE_ONE in NUMBER,
221 X_REALIZED_FLAG in VARCHAR2,
222 X_OVERWRITE_TYPE in VARCHAR2,
223 X_OVERWRITE_VALUE in NUMBER,
224 X_OVERWRITE_REASON in VARCHAR2,
225 X_BATCH_ID in NUMBER,
226 X_NI_DISC_AMOUNT in NUMBER,
227 X_AMOUNT_TYPE in VARCHAR2,
228 X_QUANTITY in NUMBER
229 ) is
230 cursor c1 is select
231 ACCOUNT_NO,
232 REVAL_CURR_FV_AMOUNT,
233 COMPLETE_FLAG,
234 FAIR_VALUE,
235 SWAP_REF,
236 CUMM_GAIN_LOSS_AMOUNT,
237 CURR_GAIN_LOSS_AMOUNT,
238 SOB_FV_GAIN_LOSS_AMOUNT,
239 SOB_FAIR_VALUE_AMOUNT,
240 CTR_CURR_SOB_CURR_FWD_RATE,
241 EXCHANGE_RATE_TWO,
242 ACTION_CODE,
243 COMPANY_CODE,
244 CONTRACT_CODE,
245 CURRENCYA,
246 CURRENCYB,
247 DEAL_NO,
248 DEAL_SUBTYPE,
249 DEAL_TYPE,
250 EFFECTIVE_DATE,
251 EFFECTIVE_DAYS,
252 ENTERED_BY,
253 ENTERED_ON,
254 FACE_VALUE,
255 FXO_SELL_REF_AMOUNT,
256 PERIOD_FROM,
257 PERIOD_TO,
258 PORTFOLIO_CODE,
259 PRODUCT_TYPE,
260 REALISED_PL,
261 REVAL_CCY,
262 REVAL_RATE,
263 TRANSACTION_NO,
264 TRANSACTION_PERIOD,
265 TRANSACTION_RATE,
266 UNREALISED_PL,
267 UPDATED_BY,
268 UPDATED_ON,
269 YEAR_BASIS,
270 CREATED_ON,
271 EXCHANGE_RATE_ONE,
272 REALIZED_FLAG,
273 OVERWRITE_TYPE,
274 OVERWRITE_VALUE,
275 OVERWRITE_REASON,
276 BATCH_ID,
277 NI_DISC_AMOUNT,
278 AMOUNT_TYPE,
279 QUANTITY
280 from XTR_REVALUATION_DETAILS
281 where REVALUATION_DETAILS_ID = X_REVALUATION_DETAILS_ID
282 for update of REVALUATION_DETAILS_ID nowait;
283 begin
284 for tlinfo in c1 loop
285 if ( ((tlinfo.BATCH_ID = X_BATCH_ID)
286 OR ((tlinfo.BATCH_ID is null) AND (X_BATCH_ID is null)))
287 AND ((tlinfo.ACCOUNT_NO = X_ACCOUNT_NO)
288 OR ((tlinfo.ACCOUNT_NO is null) AND (X_ACCOUNT_NO is null)))
289 AND ((tlinfo.REVAL_CURR_FV_AMOUNT = X_REVAL_CURR_FV_AMOUNT)
290 OR ((tlinfo.REVAL_CURR_FV_AMOUNT is null) AND (X_REVAL_CURR_FV_AMOUNT is null)))
291 AND ((tlinfo.COMPLETE_FLAG = X_COMPLETE_FLAG)
292 OR ((tlinfo.COMPLETE_FLAG is null) AND (X_COMPLETE_FLAG is null)))
293 AND ((tlinfo.FAIR_VALUE = X_FAIR_VALUE)
294 OR ((tlinfo.FAIR_VALUE is null) AND (X_FAIR_VALUE is null)))
295 AND ((tlinfo.SWAP_REF = X_SWAP_REF)
296 OR ((tlinfo.SWAP_REF is null) AND (X_SWAP_REF is null)))
297 AND ((tlinfo.CUMM_GAIN_LOSS_AMOUNT = X_CUMM_GAIN_LOSS_AMOUNT)
298 OR ((tlinfo.CUMM_GAIN_LOSS_AMOUNT is null) AND (X_CUMM_GAIN_LOSS_AMOUNT is null)))
299 AND ((tlinfo.CURR_GAIN_LOSS_AMOUNT = X_CURR_GAIN_LOSS_AMOUNT)
300 OR ((tlinfo.CURR_GAIN_LOSS_AMOUNT is null) AND (X_CURR_GAIN_LOSS_AMOUNT is null)))
301 AND ((tlinfo.SOB_FV_GAIN_LOSS_AMOUNT = X_SOB_FV_GAIN_LOSS_AMOUNT)
302 OR ((tlinfo.SOB_FV_GAIN_LOSS_AMOUNT is null) AND (X_SOB_FV_GAIN_LOSS_AMOUNT is null)))
303 AND ((tlinfo.SOB_FAIR_VALUE_AMOUNT = X_SOB_FAIR_VALUE_AMOUNT)
304 OR ((tlinfo.SOB_FAIR_VALUE_AMOUNT is null) AND (X_SOB_FAIR_VALUE_AMOUNT is null)))
305 AND ((tlinfo.CTR_CURR_SOB_CURR_FWD_RATE = X_CTR_CURR_SOB_CURR_FWD_RATE)
306 OR ((tlinfo.CTR_CURR_SOB_CURR_FWD_RATE is null) AND (X_CTR_CURR_SOB_CURR_FWD_RATE is null)))
307 AND ((tlinfo.EXCHANGE_RATE_TWO = X_EXCHANGE_RATE_TWO)
308 OR ((tlinfo.EXCHANGE_RATE_TWO is null) AND (X_EXCHANGE_RATE_TWO is null)))
309 AND ((tlinfo.ACTION_CODE = X_ACTION_CODE)
310 OR ((tlinfo.ACTION_CODE is null) AND (X_ACTION_CODE is null)))
311 AND (tlinfo.COMPANY_CODE = X_COMPANY_CODE)
312 AND ((tlinfo.CONTRACT_CODE = X_CONTRACT_CODE)
313 OR ((tlinfo.CONTRACT_CODE is null) AND (X_CONTRACT_CODE is null)))
314 AND (tlinfo.CURRENCYA = X_CURRENCYA)
315 AND ((tlinfo.CURRENCYB = X_CURRENCYB)
316 OR ((tlinfo.CURRENCYB is null) AND (X_CURRENCYB is null)))
317 AND (tlinfo.DEAL_NO = X_DEAL_NO)
318 AND (tlinfo.DEAL_SUBTYPE = X_DEAL_SUBTYPE)
319 AND (tlinfo.DEAL_TYPE = X_DEAL_TYPE)
320 AND (tlinfo.EFFECTIVE_DATE = X_EFFECTIVE_DATE)
321 AND ((tlinfo.EFFECTIVE_DAYS = X_EFFECTIVE_DAYS)
322 OR ((tlinfo.EFFECTIVE_DAYS is null) AND (X_EFFECTIVE_DAYS is null)))
323 AND (tlinfo.ENTERED_BY = X_ENTERED_BY)
324 AND (tlinfo.ENTERED_ON = X_ENTERED_ON)
325 AND (tlinfo.FACE_VALUE = X_FACE_VALUE)
326 AND ((tlinfo.FXO_SELL_REF_AMOUNT = X_FXO_SELL_REF_AMOUNT)
327 OR ((tlinfo.FXO_SELL_REF_AMOUNT is null) AND (X_FXO_SELL_REF_AMOUNT is null)))
328 AND (tlinfo.PERIOD_FROM = X_PERIOD_FROM)
329 AND (tlinfo.PERIOD_TO = X_PERIOD_TO)
330 AND ((tlinfo.PORTFOLIO_CODE = X_PORTFOLIO_CODE)
331 OR ((tlinfo.PORTFOLIO_CODE is null) AND (X_PORTFOLIO_CODE is null)))
332 AND (tlinfo.PRODUCT_TYPE = X_PRODUCT_TYPE)
333 AND ((tlinfo.REALISED_PL = X_REALISED_PL)
334 OR ((tlinfo.REALISED_PL is null) AND (X_REALISED_PL is null)))
335 AND ((tlinfo.REVAL_CCY = X_REVAL_CCY)
336 OR ((tlinfo.REVAL_CCY is null) AND (X_REVAL_CCY is null)))
337 AND ((tlinfo.REVAL_RATE = X_REVAL_RATE)
338 OR ((tlinfo.REVAL_RATE is null) AND (X_REVAL_RATE is null)))
339 AND ((tlinfo.TRANSACTION_NO = X_TRANSACTION_NO)
340 OR ((tlinfo.TRANSACTION_NO is null) AND (X_TRANSACTION_NO is null)))
341 AND (tlinfo.TRANSACTION_PERIOD = X_TRANSACTION_PERIOD)
342 AND (tlinfo.TRANSACTION_RATE = X_TRANSACTION_RATE)
343 AND ((tlinfo.UNREALISED_PL = X_UNREALISED_PL)
344 OR ((tlinfo.UNREALISED_PL is null) AND (X_UNREALISED_PL is null)))
345 AND ((tlinfo.UPDATED_BY = X_UPDATED_BY)
346 OR ((tlinfo.UPDATED_BY is null) AND (X_UPDATED_BY is null)))
347 AND ((tlinfo.UPDATED_ON = X_UPDATED_ON)
348 OR ((tlinfo.UPDATED_ON is null) AND (X_UPDATED_ON is null)))
349 AND ((tlinfo.YEAR_BASIS = X_YEAR_BASIS)
350 OR ((tlinfo.YEAR_BASIS is null) AND (X_YEAR_BASIS is null)))
351 AND (tlinfo.CREATED_ON = X_CREATED_ON)
352 AND ((tlinfo.EXCHANGE_RATE_ONE = X_EXCHANGE_RATE_ONE)
353 OR ((tlinfo.EXCHANGE_RATE_ONE is null) AND (X_EXCHANGE_RATE_ONE is null)))
354 AND ((tlinfo.REALIZED_FLAG = X_REALIZED_FLAG)
355 OR ((tlinfo.REALIZED_FLAG is null) AND (X_REALIZED_FLAG is null)))
356 AND ((tlinfo.OVERWRITE_TYPE = X_OVERWRITE_TYPE)
357 OR ((tlinfo.OVERWRITE_TYPE is null) AND (X_OVERWRITE_TYPE is null)))
358 AND ((tlinfo.OVERWRITE_VALUE = X_OVERWRITE_VALUE)
359 OR ((tlinfo.OVERWRITE_VALUE is null) AND (X_OVERWRITE_VALUE is null)))
360 AND ((tlinfo.OVERWRITE_REASON = X_OVERWRITE_REASON)
361 OR ((tlinfo.OVERWRITE_REASON is null) AND (X_OVERWRITE_REASON is null)))
362 ) then
363 null;
364 else
365 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
366 app_exception.raise_exception;
367 end if;
368 end loop;
369 return;
370 end LOCK_ROW;
371
372 procedure UPDATE_ROW (
373 X_REVALUATION_DETAILS_ID in NUMBER,
374 X_ACCOUNT_NO in VARCHAR2,
375 X_REVAL_CURR_FV_AMOUNT in NUMBER,
376 X_COMPLETE_FLAG in VARCHAR2,
377 X_FAIR_VALUE in NUMBER,
378 X_SWAP_REF in VARCHAR2,
379 X_CUMM_GAIN_LOSS_AMOUNT in NUMBER,
380 X_CURR_GAIN_LOSS_AMOUNT in NUMBER,
381 X_SOB_FV_GAIN_LOSS_AMOUNT in NUMBER,
382 X_SOB_FAIR_VALUE_AMOUNT in NUMBER,
383 X_CTR_CURR_SOB_CURR_FWD_RATE in NUMBER,
384 X_EXCHANGE_RATE_TWO in NUMBER,
385 X_ACTION_CODE in VARCHAR2,
386 X_COMPANY_CODE in VARCHAR2,
387 X_CONTRACT_CODE in VARCHAR2,
388 X_CURRENCYA in VARCHAR2,
389 X_CURRENCYB in VARCHAR2,
390 X_DEAL_NO in NUMBER,
391 X_DEAL_SUBTYPE in VARCHAR2,
392 X_DEAL_TYPE in VARCHAR2,
393 X_EFFECTIVE_DATE in DATE,
394 X_EFFECTIVE_DAYS in NUMBER,
395 X_ENTERED_BY in VARCHAR2,
396 X_ENTERED_ON in DATE,
397 X_FACE_VALUE in NUMBER,
398 X_FXO_SELL_REF_AMOUNT in NUMBER,
399 X_PERIOD_FROM in DATE,
400 X_PERIOD_TO in DATE,
401 X_PORTFOLIO_CODE in VARCHAR2,
402 X_PRODUCT_TYPE in VARCHAR2,
403 X_REALISED_PL in NUMBER,
404 X_REVAL_CCY in VARCHAR2,
405 X_REVAL_RATE in NUMBER,
406 X_TRANSACTION_NO in NUMBER,
407 X_TRANSACTION_PERIOD in NUMBER,
408 X_TRANSACTION_RATE in NUMBER,
409 X_UNREALISED_PL in NUMBER,
410 X_UPDATED_BY in VARCHAR2,
411 X_UPDATED_ON in DATE,
412 X_YEAR_BASIS in NUMBER,
413 X_CREATED_ON in DATE,
414 X_EXCHANGE_RATE_ONE in NUMBER,
415 X_REALIZED_FLAG in VARCHAR2,
416 X_OVERWRITE_TYPE in VARCHAR2,
417 X_OVERWRITE_VALUE in NUMBER,
418 X_OVERWRITE_REASON in VARCHAR2,
419 X_BATCH_ID in NUMBER,
420 X_NI_DISC_AMOUNT in NUMBER,
421 X_AMOUNT_TYPE in VARCHAR2,
422 X_QUANTITY in NUMBER
423 ) is
424 begin
425 update XTR_REVALUATION_DETAILS set
426 ACCOUNT_NO = X_ACCOUNT_NO,
427 REVAL_CURR_FV_AMOUNT = X_REVAL_CURR_FV_AMOUNT,
428 COMPLETE_FLAG = X_COMPLETE_FLAG,
429 FAIR_VALUE = X_FAIR_VALUE,
430 SWAP_REF = X_SWAP_REF,
431 CUMM_GAIN_LOSS_AMOUNT = X_CUMM_GAIN_LOSS_AMOUNT,
432 CURR_GAIN_LOSS_AMOUNT = X_CURR_GAIN_LOSS_AMOUNT,
433 SOB_FV_GAIN_LOSS_AMOUNT = X_SOB_FV_GAIN_LOSS_AMOUNT,
434 SOB_FAIR_VALUE_AMOUNT = X_SOB_FAIR_VALUE_AMOUNT,
435 CTR_CURR_SOB_CURR_FWD_RATE = X_CTR_CURR_SOB_CURR_FWD_RATE,
436 EXCHANGE_RATE_TWO = X_EXCHANGE_RATE_TWO,
437 ACTION_CODE = X_ACTION_CODE,
438 COMPANY_CODE = X_COMPANY_CODE,
439 CONTRACT_CODE = X_CONTRACT_CODE,
440 CURRENCYA = X_CURRENCYA,
441 CURRENCYB = X_CURRENCYB,
442 DEAL_NO = X_DEAL_NO,
443 DEAL_SUBTYPE = X_DEAL_SUBTYPE,
444 DEAL_TYPE = X_DEAL_TYPE,
445 EFFECTIVE_DATE = X_EFFECTIVE_DATE,
446 EFFECTIVE_DAYS = X_EFFECTIVE_DAYS,
447 ENTERED_BY = X_ENTERED_BY,
448 ENTERED_ON = X_ENTERED_ON,
449 FACE_VALUE = X_FACE_VALUE,
450 FXO_SELL_REF_AMOUNT = X_FXO_SELL_REF_AMOUNT,
451 PERIOD_FROM = X_PERIOD_FROM,
452 PERIOD_TO = X_PERIOD_TO,
453 PORTFOLIO_CODE = X_PORTFOLIO_CODE,
454 PRODUCT_TYPE = X_PRODUCT_TYPE,
455 REALISED_PL = X_REALISED_PL,
456 REVAL_CCY = X_REVAL_CCY,
457 REVAL_RATE = X_REVAL_RATE,
458 TRANSACTION_NO = X_TRANSACTION_NO,
459 TRANSACTION_PERIOD = X_TRANSACTION_PERIOD,
460 TRANSACTION_RATE = X_TRANSACTION_RATE,
461 UNREALISED_PL = X_UNREALISED_PL,
462 UPDATED_BY = X_UPDATED_BY,
463 UPDATED_ON = X_UPDATED_ON,
464 YEAR_BASIS = X_YEAR_BASIS,
465 CREATED_ON = X_CREATED_ON,
466 EXCHANGE_RATE_ONE = X_EXCHANGE_RATE_ONE,
467 REALIZED_FLAG = X_REALIZED_FLAG,
468 OVERWRITE_TYPE = X_OVERWRITE_TYPE,
469 OVERWRITE_VALUE = X_OVERWRITE_VALUE,
470 OVERWRITE_REASON = X_OVERWRITE_REASON,
471 BATCH_ID = X_BATCH_ID,
472 NI_DISC_AMOUNT = X_NI_DISC_AMOUNT,
473 AMOUNT_TYPE = X_AMOUNT_TYPE,
474 QUANTITY = X_QUANTITY
475 where REVALUATION_DETAILS_ID = X_REVALUATION_DETAILS_ID;
476
477 if (sql%notfound) then
478 raise no_data_found;
479 end if;
480 end UPDATE_ROW;
481
482 procedure DELETE_ROW (
483 X_REVALUATION_DETAILS_ID in NUMBER
484 ) is
485 begin
486 delete from XTR_REVALUATION_DETAILS
487 where REVALUATION_DETAILS_ID = X_REVALUATION_DETAILS_ID;
488
489 if (sql%notfound) then
490 raise no_data_found;
491 end if;
492
493 end DELETE_ROW;
494
495 end XTR_REVALUATION_DETAILS_PKG;