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 994: from XTR_ROLLOVER_TRANSACTIONS

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

Line 1002: from XTR_ROLLOVER_TRANSACTIONS

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

Line 1021: from XTR_ROLLOVER_TRANSACTIONS

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

Line 1044: from XTR_ROLLOVER_TRANSACTIONS

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

Line 1130: FROM xtr_rollover_transactions_v

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

Line 1363: update XTR_ROLLOVER_TRANSACTIONS

1359: hce_balos := round(nvl(pmt.BALANCE_OUT,0) / l_hce_rate,rounding_fac);
1360: hce_accum_int := round(nvl(pmt.ACCUM_INTEREST,0) / l_hce_rate,rounding_fac);
1361: hce_due := round(nvl(pmt.PI_AMOUNT_DUE,0) / l_hce_rate,rounding_fac);
1362: --
1363: update XTR_ROLLOVER_TRANSACTIONS
1364: set START_DATE = pmt.START_DATE,
1365: RATE_FIXING_DATE = pmt.START_DATE,
1366: BALANCE_OUT_BF = pmt.BALANCE_OUT_BF,
1367: BALANCE_OUT_BF_HCE = hce_balbf,

Line 1581: delete from XTR_ROLLOVER_TRANSACTIONS

1577:
1578: --
1579: --
1580: if l_nill_date is NOT NULL then
1581: delete from XTR_ROLLOVER_TRANSACTIONS
1582: where DEAL_NUMBER = l_deal_no
1583: and START_DATE > l_nill_date
1584: and SETTLE_DATE is null; --- >=
1585: --