APPS.XTR_MAINTAIN_DDA_P dependencies on XTR_ROLLOVER_TRANSACTIONS

Line 774: insert into XTR_ROLLOVER_TRANSACTIONS

770: nvl(P_FREQUENCY,2),round_fac);
771: end if;
772: coupon_hce := round(coupon / hce_rate,round_fac);
773: --
774: insert into XTR_ROLLOVER_TRANSACTIONS
775: (deal_number,transaction_number,deal_type,start_date,no_of_days,
776: maturity_date,interest_rate,interest,interest_hce,deal_subtype,
777: product_type,company_code,cparty_code,client_code,currency,
778: deal_date,status_code,created_by,created_on,settle_date)

Line 1276: delete from XTR_ROLLOVER_TRANSACTIONS

1272: where deal_number = P_DEAL_NO;
1273: --
1274: if P_DEAL_TYPE = 'BOND' then
1275: -- coupons
1276: delete from XTR_ROLLOVER_TRANSACTIONS
1277: where deal_number = P_DEAL_NO;
1278: elsif P_DEAL_TYPE = 'FX' then
1279: -- Swapdepo transactions
1280: update XTR_ROLLOVER_TRANSACTIONS

Line 1280: update XTR_ROLLOVER_TRANSACTIONS

1276: delete from XTR_ROLLOVER_TRANSACTIONS
1277: where deal_number = P_DEAL_NO;
1278: elsif P_DEAL_TYPE = 'FX' then
1279: -- Swapdepo transactions
1280: update XTR_ROLLOVER_TRANSACTIONS
1281: set STATUS_CODE = 'CANCELLED'
1282: where deal_number = P_DEAL_NO;
1283: end if;
1284: --

Line 1294: update XTR_ROLLOVER_TRANSACTIONS

1290: /*
1291: ------------
1292: -- NEW NI --
1293: ------------
1294: update XTR_ROLLOVER_TRANSACTIONS
1295: set STATUS_CODE = 'CANCELLED'
1296: where DEAL_NUMBER = P_DEAL_NO
1297: and TRANS_CLOSEOUT_NO is null;
1298: */