APPS.XTR_MAINTAIN_DDA_P dependencies on XTR_ROLLOVER_TRANSACTIONS

Line 789: insert into XTR_ROLLOVER_TRANSACTIONS

785: nvl(P_FREQUENCY,2),round_fac);
786: end if;
787: coupon_hce := round(coupon / hce_rate,round_fac);
788: --
789: insert into XTR_ROLLOVER_TRANSACTIONS
790: (deal_number,transaction_number,deal_type,start_date,no_of_days,
791: maturity_date,interest_rate,interest,interest_hce,deal_subtype,
792: product_type,company_code,cparty_code,client_code,currency,
793: deal_date,status_code,created_by,created_on,settle_date)

Line 1291: delete from XTR_ROLLOVER_TRANSACTIONS

1287: where deal_number = P_DEAL_NO;
1288: --
1289: if P_DEAL_TYPE = 'BOND' then
1290: -- coupons
1291: delete from XTR_ROLLOVER_TRANSACTIONS
1292: where deal_number = P_DEAL_NO;
1293: elsif P_DEAL_TYPE = 'FX' then
1294: -- Swapdepo transactions
1295: update XTR_ROLLOVER_TRANSACTIONS

Line 1295: update XTR_ROLLOVER_TRANSACTIONS

1291: delete from XTR_ROLLOVER_TRANSACTIONS
1292: where deal_number = P_DEAL_NO;
1293: elsif P_DEAL_TYPE = 'FX' then
1294: -- Swapdepo transactions
1295: update XTR_ROLLOVER_TRANSACTIONS
1296: set STATUS_CODE = 'CANCELLED'
1297: where deal_number = P_DEAL_NO;
1298: end if;
1299: --

Line 1309: update XTR_ROLLOVER_TRANSACTIONS

1305: /*
1306: ------------
1307: -- NEW NI --
1308: ------------
1309: update XTR_ROLLOVER_TRANSACTIONS
1310: set STATUS_CODE = 'CANCELLED'
1311: where DEAL_NUMBER = P_DEAL_NO
1312: and TRANS_CLOSEOUT_NO is null;
1313: */