APPS.XTR_CALC_P dependencies on XTR_ROLLOVER_TRANSACTIONS

Line 705: Insert into XTR_ROLLOVER_TRANSACTIONS (

701: CLOSE get_settle_method;
702: END IF;
703:
704: Begin
705: Insert into XTR_ROLLOVER_TRANSACTIONS (
706: deal_number,
707: transaction_number,
708: deal_type,
709: start_date,

Line 769: FND_MESSAGE.Set_Token ('TABLE', 'XTR_ROLLOVER_TRANSACTIONS');

765: errnum := SQLCODE;
766: errmsg := SUBSTR(SQLERRM,1,100);
767: l_errmsg := to_char(errnum) || ' - ' || errmsg;
768: FND_MESSAGE.Set_Name ('XTR', 'XTR_2172');
769: FND_MESSAGE.Set_Token ('TABLE', 'XTR_ROLLOVER_TRANSACTIONS');
770: FND_MESSAGE.Set_Token ('ERRCODE_TEXT', l_errmsg);
771: APP_EXCEPTION.Raise_Exception;
772: END;
773:

Line 992: from XTR_ROLLOVER_TRANSACTIONS

988: where CURRENCY = l_ccy;
989:
990: cursor START_ROW is
991: select max(START_DATE)
992: from XTR_ROLLOVER_TRANSACTIONS
993: where DEAL_NUMBER = l_deal_no
994: and START_DATE <= l_ref_date --- <
995: and STATUS_CODE = 'CURRENT'
996: and TRANSACTION_NUMBER <>l_trans_num;

Line 1000: from XTR_ROLLOVER_TRANSACTIONS

996: and TRANSACTION_NUMBER <>l_trans_num;
997:
998: cursor LAST_ROW is
999: select rowid
1000: from XTR_ROLLOVER_TRANSACTIONS
1001: where DEAL_NUMBER = l_deal_no
1002: and START_DATE >= l_start_date
1003: and (MATURITY_DATE > l_start_date or l_last_row='Y') --- add
1004: and STATUS_CODE = 'CURRENT'

Line 1019: from XTR_ROLLOVER_TRANSACTIONS

1015: SETTLE_DATE,ACCUM_INTEREST_BF,PI_AMOUNT_DUE,PI_AMOUNT_RECEIVED,
1016: ACCUM_INTEREST,ROWID,ADJUSTED_BALANCE,COMMENTS,
1017: EXPECTED_BALANCE_BF,EXPECTED_BALANCE_OUT,PRINCIPAL_AMOUNT_TYPE,
1018: ENDORSER_CODE,RATE_FIXING_DATE
1019: from XTR_ROLLOVER_TRANSACTIONS
1020: where DEAL_NUMBER = l_deal_no
1021: and START_DATE >= l_start_date
1022: and (MATURITY_DATE > l_start_date or l_last_row = 'Y')
1023: and STATUS_CODE = 'CURRENT'

Line 1042: from XTR_ROLLOVER_TRANSACTIONS

1038: l_date_exits varchar2(1);
1039:
1040: cursor chk_date_exits is
1041: select NULL
1042: from XTR_ROLLOVER_TRANSACTIONS
1043: where DEAL_NUMBER = l_deal_no
1044: and (START_DATE = l_ref_date or MATURITY_DATE = l_ref_date)
1045: and transaction_number <>l_trans_num
1046: order by START_DATE desc,TRANSACTION_NUMBER desc ;

Line 1126: FROM xtr_rollover_transactions_v

1122: AND nvl(l_day_count_type,'F') = 'B' THEN
1123:
1124: SELECT MAX(transaction_number)
1125: INTO l_max_trans_no
1126: FROM xtr_rollover_transactions_v
1127: WHERE deal_number = l_deal_no
1128: AND start_date = pmt.start_date;
1129:
1130: IF pmt.transaction_number = Nvl(l_max_trans_no,1) THEN

Line 1348: update XTR_ROLLOVER_TRANSACTIONS

1344: hce_balos := round(nvl(pmt.BALANCE_OUT,0) / l_hce_rate,rounding_fac);
1345: hce_accum_int := round(nvl(pmt.ACCUM_INTEREST,0) / l_hce_rate,rounding_fac);
1346: hce_due := round(nvl(pmt.PI_AMOUNT_DUE,0) / l_hce_rate,rounding_fac);
1347: --
1348: update XTR_ROLLOVER_TRANSACTIONS
1349: set START_DATE = pmt.START_DATE,
1350: RATE_FIXING_DATE = pmt.START_DATE,
1351: BALANCE_OUT_BF = pmt.BALANCE_OUT_BF,
1352: BALANCE_OUT_BF_HCE = hce_balbf,

Line 1566: delete from XTR_ROLLOVER_TRANSACTIONS

1562:
1563: --
1564: --
1565: if l_nill_date is NOT NULL then
1566: delete from XTR_ROLLOVER_TRANSACTIONS
1567: where DEAL_NUMBER = l_deal_no
1568: and START_DATE > l_nill_date
1569: and SETTLE_DATE is null; --- >=
1570: --