eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.XTR_MISC_P dependencies on XTR_DEALS

Line 653: XTR_DEALS_V b

649: 'BDOFACEVAL',a.amount,
650: 'SWPTNFACEVAL',a.amount,
651: 'FRAFACEVAL',a.amount,0)),0) gross_amount
652: from XTR_DEAL_DATE_AMOUNTS_V a,
653: XTR_DEALS_V b
654: where a.amount_date >= p_from_date
655: and a.currency like p_currency
656: and a.company_code like p_company_code
657: and a.portfolio_code like p_portfolio_code

Line 762: XTR_DEALS_V b

758: 'RTMM',decode(nvl(a.balance_out,0),0,a.balance_out_bf,a.balance_out),
759: 'DEB',decode(nvl(a.balance_out,0),0,a.balance_out_bf,a.balance_out),
760: a.balance_out)),0) gross_amount
761: from XTR_ROLLOVER_TRANSACTIONS_V a,
762: XTR_DEALS_V b
763: where a.company_code like p_company_code and a.currency like p_currency
764: and a.status_code='CURRENT'
765: and a.portfolio_code like p_portfolio_code
766: and nvl(a.maturity_date,p_from_date+1) >p_from_date

Line 922: from xtr_deals_v a, xtr_deals_v b

918:
919: -- bug #1295341 jhung
920: cursor IRS_OTHER_DEAL is
921: select b.deal_no
922: from xtr_deals_v a, xtr_deals_v b
923: where a.int_swap_ref = b.int_swap_ref
924: and a.deal_type = b.deal_type
925: and a.deal_type = 'IRS'
926: and a.deal_subtype <> b.deal_subtype

Line 949: update XTR_DEALS

945: 'NEW_FXO_CONTRACT',
946: 'FX_CONTRACT_SWAP',
947: 'ROLLOVER_OF_FX_CONTRACT',
948: 'PREDELIVERY_OF_FX_CONTRACT') then
949: update XTR_DEALS
950: set DUAL_AUTHORISATION_BY = p_validated_by,
951: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
952: where DEAL_NO = p_deal_no
953: and DEAL_TYPE = p_deal_type;

Line 955: update XTR_DEALS

951: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
952: where DEAL_NO = p_deal_no
953: and DEAL_TYPE = p_deal_type;
954: elsif p_action_type='EXERCISE_OF_FX_OPTION_CONTRACT' then
955: update XTR_DEALS
956: set SETTLE_DUAL_AUTHORISATION_BY = p_validated_by,
957: SETTLE_DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
958: where DEAL_NO = p_deal_no
959: and DEAL_TYPE = p_deal_type;

Line 966: update XTR_DEALS

962: -- Actions are as follows (and the form they originated from)
963: -- PRO0770 - NEW_FRA_CONTRACT
964: -- PRO0770 - SETTLEMENT_OF_FRA_CONTRACT
965: if p_action_type ='NEW_FRA_CONTRACT' then
966: update XTR_DEALS
967: set DUAL_AUTHORISATION_BY = p_validated_by,
968: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
969: where DEAL_NO = p_deal_no
970: and DEAL_TYPE = p_deal_type;

Line 972: update XTR_DEALS

968: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
969: where DEAL_NO = p_deal_no
970: and DEAL_TYPE = p_deal_type;
971: elsif p_action_type='SETTLEMENT_OF_FRA_CONTRACT' then
972: update XTR_DEALS
973: set SETTLE_DUAL_AUTHORISATION_BY = p_validated_by,
974: SETTLE_DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
975: where DEAL_NO = p_deal_no
976: and DEAL_TYPE = p_deal_type;

Line 983: update XTR_DEALS

979: -- Actions are as follows (and the form they originated from)
980: -- PRO0270 - NEW_IRO_CONTRACT
981: -- PRO0270 - Settlement of IRO Contract
982: if p_action_type = 'NEW_IRO_CONTRACT' then
983: update XTR_DEALS
984: set DUAL_AUTHORISATION_BY = p_validated_by,
985: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
986: where DEAL_NO = p_deal_no
987: and DEAL_TYPE = p_deal_type;

Line 989: update XTR_DEALS

985: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
986: where DEAL_NO = p_deal_no
987: and DEAL_TYPE = p_deal_type;
988: elsif p_action_type = 'EXERCISE_OF_IRO_CONTRACT' then
989: update XTR_DEALS
990: set SETTLE_DUAL_AUTHORISATION_BY = p_validated_by,
991: SETTLE_DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
992: where DEAL_NO = p_deal_no
993: and DEAL_TYPE = p_deal_type;

Line 998: update XTR_DEALS

994: end if;
995: elsif p_deal_type ='BDO' then
996: -- Actions are as follows (and the form they originated from)
997: if p_action_type = 'NEW_BOND_OPTION_CONTRACT' then
998: update XTR_DEALS
999: set DUAL_AUTHORISATION_BY = p_validated_by,
1000: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1001: where DEAL_NO = p_deal_no
1002: and DEAL_TYPE = p_deal_type;

Line 1004: update XTR_DEALS

1000: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1001: where DEAL_NO = p_deal_no
1002: and DEAL_TYPE = p_deal_type;
1003: elsif p_action_type = 'EXERCISE_OF_BOND_OPTION_CONTRACT' then
1004: update XTR_DEALS
1005: set SETTLE_DUAL_AUTHORISATION_BY = p_validated_by,
1006: SETTLE_DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1007: where DEAL_NO = p_deal_no
1008: and DEAL_TYPE = p_deal_type;

Line 1014: update XTR_DEALS

1010: elsif p_deal_type ='NI' then
1011: -- Actions are as follows (and the form they originated from)
1012: -- PRO0240 - NEW_NI_CONTRACT
1013: if p_action_type ='NEW_NI_CONTRACT' then
1014: update XTR_DEALS
1015: set DUAL_AUTHORISATION_BY = p_validated_by,
1016: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1017: where DEAL_NO = p_deal_no
1018: and DEAL_TYPE = p_deal_type;

Line 1024: update XTR_DEALS

1020: elsif p_deal_type ='BOND' then
1021: -- Actions are as follows (and the form they originated from)
1022: -- PRO0280 - NEW_BOND_CONTRACT
1023: if p_action_type ='NEW_BOND_CONTRACT' then
1024: update XTR_DEALS
1025: set DUAL_AUTHORISATION_BY = p_validated_by,
1026: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1027: where DEAL_NO = p_deal_no
1028: and DEAL_TYPE = p_deal_type;

Line 1034: update XTR_DEALS

1030: elsif p_deal_type ='SWPTN' then
1031: -- Actions are as follows (and the form they originated from)
1032: -- PRO0290 - New SWPTN Contract
1033: if p_action_type ='NEW_SWAPTION_CONTRACT' then
1034: update XTR_DEALS
1035: set DUAL_AUTHORISATION_BY = p_validated_by,
1036: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1037: where DEAL_NO = p_deal_no
1038: and DEAL_TYPE = p_deal_type;

Line 1040: update XTR_DEALS

1036: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1037: where DEAL_NO = p_deal_no
1038: and DEAL_TYPE = p_deal_type;
1039: elsif p_action_type = 'EXERCISE_OF_SWAPTION_CONTRACT' then
1040: update XTR_DEALS
1041: set SETTLE_DUAL_AUTHORISATION_BY = p_validated_by,
1042: SETTLE_DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1043: where DEAL_NO = p_deal_no
1044: and DEAL_TYPE = p_deal_type;

Line 1054: update XTR_DEALS -- Update paying side deal

1050: open IRS_OTHER_DEAL;
1051: fetch IRS_OTHER_DEAL into receive_deal_no;
1052: close IRS_OTHER_DEAL;
1053:
1054: update XTR_DEALS -- Update paying side deal
1055: set DUAL_AUTHORISATION_BY = p_validated_by,
1056: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1057: where DEAL_NO = p_deal_no
1058: and DEAL_TYPE = p_deal_type;

Line 1059: update XTR_DEALS -- Update receiving side deal

1055: set DUAL_AUTHORISATION_BY = p_validated_by,
1056: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1057: where DEAL_NO = p_deal_no
1058: and DEAL_TYPE = p_deal_type;
1059: update XTR_DEALS -- Update receiving side deal
1060: set DUAL_AUTHORISATION_BY = p_validated_by,
1061: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1062: where DEAL_NO = receive_deal_no
1063: and DEAL_TYPE = p_deal_type;

Line 1067: update XTR_DEALS

1063: and DEAL_TYPE = p_deal_type;
1064: end if;
1065: elsif p_deal_type ='TMM' then
1066: ---- Only for NEW_WHOLESALE_TERM_CONTRACT at this stage. Should use TERM_ACTIONS like Retail Term
1067: update XTR_DEALS
1068: set DUAL_AUTHORISATION_BY = p_validated_by,
1069: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1070: where DEAL_NO = p_deal_no
1071: and DEAL_TYPE = p_deal_type;

Line 1082: update XTR_DEALS

1078: and settle_date is null;
1079:
1080: elsif p_deal_type = 'STOCK' then
1081: if p_action_type = 'NEW_STOCK_BUY_CONTRACT' then -- BUY stock deal
1082: update XTR_DEALS
1083: set DUAL_AUTHORISATION_BY = p_validated_by,
1084: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1085: where DEAL_NO = p_deal_no
1086: and DEAL_TYPE = p_deal_type;

Line 1111: update XTR_DEALS

1107: and TRANSACTION_NUMBER = p_trans_no
1108: and DEAL_TYPE = p_deal_type;
1109:
1110: elsif p_action_type = 'NEW_STOCK_SELL_CONTRACT' then -- SELL stock deal
1111: update XTR_DEALS
1112: set DUAL_AUTHORISATION_BY = p_validated_by,
1113: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1114: where DEAL_NO = p_deal_no
1115: and DEAL_TYPE = p_deal_type;

Line 1130: update XTR_DEALS

1126: --- PRINCIPAL_ADJUSTMENT_OF_RETAIL_TERM_CONTRA
1127: --- RETAIL_TERM_INTEREST_RESET
1128: --- Ammend Schedule Type for Retail Term
1129: if p_action_type ='NEW_RETAIL_TERM_CONTRACT' then
1130: update XTR_DEALS
1131: set DUAL_AUTHORISATION_BY = p_validated_by,
1132: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1133: where DEAL_NO = p_deal_no
1134: and DEAL_TYPE = p_deal_type;