APPS.XTR_AUTO_RECONCILIATION dependencies on XTR_ROLLOVER_TRANSACTIONS_V

Line 322: from XTR_ROLLOVER_TRANSACTIONS_V

318: order by DEAL_NUMBER,TRANSACTION_NUMBER;
319: --
320: cursor S_DATE is
321: select START_DATE,CURRENCY,DEAL_SUBTYPE
322: from XTR_ROLLOVER_TRANSACTIONS_V
323: where DEAL_NUMBER = l_deal_no
324: and TRANSACTION_NUMBER = l_trans_no;
325: --
326: begin

Line 360: update XTR_ROLLOVER_TRANSACTIONS_V

356: and TRANSACTION_NUMBER = l_trans_no
357: and nvl(ACTION_CODE,'@#@') <>'INCRSE'
358: and DATE_TYPE = 'SETTLE'; -- AW 1/6/2000 Bug 1139396
359: --
360: update XTR_ROLLOVER_TRANSACTIONS_V
361: set PI_AMOUNT_RECEIVED = NULL,
362: SETTLE_DATE = NULL
363: where DEAL_NUMBER = l_deal_no
364: and TRANSACTION_NUMBER = l_trans_no;

Line 452: from XTR_ROLLOVER_TRANSACTIONS_V

448: order by DEAL_NUMBER,TRANSACTION_NUMBER;
449: --
450: CURSOR S_DATE is
451: select START_DATE,CURRENCY,DEAL_SUBTYPE
452: from XTR_ROLLOVER_TRANSACTIONS_V
453: where DEAL_NUMBER = l_deal_no
454: and TRANSACTION_NUMBER = l_trans_no;
455: -- Created cursor Bug 4226409
456: CURSOR SETTLE_DATE(p_rec_ref NUMBER) is

Line 504: UPDATE XTR_ROLLOVER_TRANSACTIONS_V

500: -- Modified Bug 4226409
501: l_settle_date := p_val_date;
502:
503:
504: UPDATE XTR_ROLLOVER_TRANSACTIONS_V
505: SET PI_AMOUNT_RECEIVED = l_amount,
506: MATURITY_DATE = l_date,
507: SETTLE_DATE = l_settle_date
508: WHERE DEAL_NUMBER = l_deal_no

Line 621: from XTR_ROLLOVER_TRANSACTIONS_V

617: order by DEAL_NUMBER,TRANSACTION_NUMBER;
618: --
619: CURSOR S_DATE is
620: select START_DATE,CURRENCY,DEAL_SUBTYPE
621: from XTR_ROLLOVER_TRANSACTIONS_V
622: where DEAL_NUMBER = l_deal_no
623: and TRANSACTION_NUMBER = l_trans_no;
624: -- Created cursor Bug 4226409
625: CURSOR SETTLE_DATE(p_rec_ref NUMBER) is

Line 662: UPDATE XTR_ROLLOVER_TRANSACTIONS_V

658: OPEN SETTLE_DATE(l_rec_ref);
659: FETCH SETTLE_DATE INTO l_settle_date;
660: CLOSE SETTLE_DATE;
661: -- Modified Bug 4226409
662: UPDATE XTR_ROLLOVER_TRANSACTIONS_V
663: SET PI_AMOUNT_RECEIVED = l_amount,
664: MATURITY_DATE = l_date,
665: SETTLE_DATE = l_settle_date
666: WHERE DEAL_NUMBER = l_deal_no

Line 931: from XTR_ROLLOVER_TRANSACTIONS_V

927: where a.CURRENCY = l_ccy;
928: --
929: cursor START_ROW is
930: select max(START_DATE)
931: from XTR_ROLLOVER_TRANSACTIONS_V
932: where DEAL_NUMBER = l_deal_no
933: and START_DATE <= l_ref_date
934: and STATUS_CODE = 'CURRENT';
935: --

Line 938: from XTR_ROLLOVER_TRANSACTIONS_V

934: and STATUS_CODE = 'CURRENT';
935: --
936: cursor LAST_ROW is
937: select rowid
938: from XTR_ROLLOVER_TRANSACTIONS_V
939: where DEAL_NUMBER = l_deal_no
940: and START_DATE >= l_start_date
941: and STATUS_CODE = 'CURRENT'
942: order by START_DATE desc,nvl(SETTLE_DATE,MATURITY_DATE) desc,TRANSACTION_NUMBER desc;

Line 953: from XTR_ROLLOVER_TRANSACTIONS_V

949: INTEREST_SETTLED,PRINCIPAL_ACTION,TRANSACTION_NUMBER,
950: SETTLE_DATE,ACCUM_INTEREST_BF,PI_AMOUNT_DUE,PI_AMOUNT_RECEIVED,
951: ACCUM_INTEREST,ROWID,ADJUSTED_BALANCE,COMMENTS,
952: EXPECTED_BALANCE_BF,EXPECTED_BALANCE_OUT,PRINCIPAL_AMOUNT_TYPE,ENDORSER_CODE
953: from XTR_ROLLOVER_TRANSACTIONS_V
954: where DEAL_NUMBER = l_deal_no
955: and START_DATE >= l_start_date
956: and STATUS_CODE = 'CURRENT'
957: order by START_DATE asc,nvl(SETTLE_DATE,MATURITY_DATE) asc,TRANSACTION_NUMBER asc

Line 1270: update XTR_ROLLOVER_TRANSACTIONS_V

1266: hce_accum_int := (pmt.ACCUM_INTEREST / l_hce_rate);
1267: hce_accum_int := xtr_fps2_p.interest_round(hce_accum_int, rounding_fac, l_rounding_type);
1268: hce_due := round(pmt.PI_AMOUNT_DUE / l_hce_rate,rounding_fac);
1269: --
1270: update XTR_ROLLOVER_TRANSACTIONS_V
1271: set START_DATE = pmt.START_DATE,
1272: BALANCE_OUT_BF = pmt.BALANCE_OUT_BF,
1273: BALANCE_OUT_BF_HCE = hce_balbf,
1274: ACCUM_INTEREST_BF = pmt.ACCUM_INTEREST_BF,

Line 1387: delete from XTR_ROLLOVER_TRANSACTIONS_V

1383: end if;
1384: fetch DT_ROW INTO pmt;
1385: END LOOP;
1386: if l_nill_date is NOT NULL then
1387: delete from XTR_ROLLOVER_TRANSACTIONS_V
1388: where DEAL_NUMBER = l_deal_no
1389: and START_DATE >= l_nill_date;
1390: If SQL%Found then
1391: null;