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.

APPS.XTR_MISC_P dependencies on XTR_DEALS

Line 666: XTR_DEALS_V b

662: 'BDOFACEVAL',a.amount,
663: 'SWPTNFACEVAL',a.amount,
664: 'FRAFACEVAL',a.amount,0)),0) gross_amount
665: from XTR_DEAL_DATE_AMOUNTS_V a,
666: XTR_DEALS_V b
667: where a.amount_date >= p_from_date
668: and a.currency like p_currency
669: and a.company_code like p_company_code
670: and a.portfolio_code like p_portfolio_code

Line 775: XTR_DEALS_V b

771: 'RTMM',decode(nvl(a.balance_out,0),0,a.balance_out_bf,a.balance_out),
772: 'DEB',decode(nvl(a.balance_out,0),0,a.balance_out_bf,a.balance_out),
773: a.balance_out)),0) gross_amount
774: from XTR_ROLLOVER_TRANSACTIONS_V a,
775: XTR_DEALS_V b
776: where a.company_code like p_company_code and a.currency like p_currency
777: and a.status_code='CURRENT'
778: and a.portfolio_code like p_portfolio_code
779: and nvl(a.maturity_date,p_from_date+1) >p_from_date

Line 935: from xtr_deals_v a, xtr_deals_v b

931:
932: -- bug #1295341 jhung
933: cursor IRS_OTHER_DEAL is
934: select b.deal_no
935: from xtr_deals_v a, xtr_deals_v b
936: where a.int_swap_ref = b.int_swap_ref
937: and a.deal_type = b.deal_type
938: and a.deal_type = 'IRS'
939: and a.deal_subtype <> b.deal_subtype

Line 962: update XTR_DEALS

958: 'NEW_FXO_CONTRACT',
959: 'FX_CONTRACT_SWAP',
960: 'ROLLOVER_OF_FX_CONTRACT',
961: 'PREDELIVERY_OF_FX_CONTRACT') then
962: update XTR_DEALS
963: set DUAL_AUTHORISATION_BY = p_validated_by,
964: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
965: where DEAL_NO = p_deal_no
966: and DEAL_TYPE = p_deal_type;

Line 968: update XTR_DEALS

964: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
965: where DEAL_NO = p_deal_no
966: and DEAL_TYPE = p_deal_type;
967: elsif p_action_type='EXERCISE_OF_FX_OPTION_CONTRACT' then
968: update XTR_DEALS
969: set SETTLE_DUAL_AUTHORISATION_BY = p_validated_by,
970: SETTLE_DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
971: where DEAL_NO = p_deal_no
972: and DEAL_TYPE = p_deal_type;

Line 979: update XTR_DEALS

975: -- Actions are as follows (and the form they originated from)
976: -- PRO0770 - NEW_FRA_CONTRACT
977: -- PRO0770 - SETTLEMENT_OF_FRA_CONTRACT
978: if p_action_type ='NEW_FRA_CONTRACT' then
979: update XTR_DEALS
980: set DUAL_AUTHORISATION_BY = p_validated_by,
981: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
982: where DEAL_NO = p_deal_no
983: and DEAL_TYPE = p_deal_type;

Line 985: update XTR_DEALS

981: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
982: where DEAL_NO = p_deal_no
983: and DEAL_TYPE = p_deal_type;
984: elsif p_action_type='SETTLEMENT_OF_FRA_CONTRACT' then
985: update XTR_DEALS
986: set SETTLE_DUAL_AUTHORISATION_BY = p_validated_by,
987: SETTLE_DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
988: where DEAL_NO = p_deal_no
989: and DEAL_TYPE = p_deal_type;

Line 996: update XTR_DEALS

992: -- Actions are as follows (and the form they originated from)
993: -- PRO0270 - NEW_IRO_CONTRACT
994: -- PRO0270 - Settlement of IRO Contract
995: if p_action_type = 'NEW_IRO_CONTRACT' then
996: update XTR_DEALS
997: set DUAL_AUTHORISATION_BY = p_validated_by,
998: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
999: where DEAL_NO = p_deal_no
1000: and DEAL_TYPE = p_deal_type;

Line 1002: update XTR_DEALS

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

Line 1011: update XTR_DEALS

1007: end if;
1008: elsif p_deal_type ='BDO' then
1009: -- Actions are as follows (and the form they originated from)
1010: if p_action_type = 'NEW_BOND_OPTION_CONTRACT' then
1011: update XTR_DEALS
1012: set DUAL_AUTHORISATION_BY = p_validated_by,
1013: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1014: where DEAL_NO = p_deal_no
1015: and DEAL_TYPE = p_deal_type;

Line 1017: update XTR_DEALS

1013: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1014: where DEAL_NO = p_deal_no
1015: and DEAL_TYPE = p_deal_type;
1016: elsif p_action_type = 'EXERCISE_OF_BOND_OPTION_CONTRACT' then
1017: update XTR_DEALS
1018: set SETTLE_DUAL_AUTHORISATION_BY = p_validated_by,
1019: SETTLE_DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1020: where DEAL_NO = p_deal_no
1021: and DEAL_TYPE = p_deal_type;

Line 1027: update XTR_DEALS

1023: elsif p_deal_type ='NI' then
1024: -- Actions are as follows (and the form they originated from)
1025: -- PRO0240 - NEW_NI_CONTRACT
1026: if p_action_type ='NEW_NI_CONTRACT' then
1027: update XTR_DEALS
1028: set DUAL_AUTHORISATION_BY = p_validated_by,
1029: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1030: where DEAL_NO = p_deal_no
1031: and DEAL_TYPE = p_deal_type;

Line 1037: update XTR_DEALS

1033: elsif p_deal_type ='BOND' then
1034: -- Actions are as follows (and the form they originated from)
1035: -- PRO0280 - NEW_BOND_CONTRACT
1036: if p_action_type ='NEW_BOND_CONTRACT' then
1037: update XTR_DEALS
1038: set DUAL_AUTHORISATION_BY = p_validated_by,
1039: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1040: where DEAL_NO = p_deal_no
1041: and DEAL_TYPE = p_deal_type;

Line 1047: update XTR_DEALS

1043: elsif p_deal_type ='SWPTN' then
1044: -- Actions are as follows (and the form they originated from)
1045: -- PRO0290 - New SWPTN Contract
1046: if p_action_type ='NEW_SWAPTION_CONTRACT' then
1047: update XTR_DEALS
1048: set DUAL_AUTHORISATION_BY = p_validated_by,
1049: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1050: where DEAL_NO = p_deal_no
1051: and DEAL_TYPE = p_deal_type;

Line 1053: update XTR_DEALS

1049: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1050: where DEAL_NO = p_deal_no
1051: and DEAL_TYPE = p_deal_type;
1052: elsif p_action_type = 'EXERCISE_OF_SWAPTION_CONTRACT' then
1053: update XTR_DEALS
1054: set SETTLE_DUAL_AUTHORISATION_BY = p_validated_by,
1055: SETTLE_DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1056: where DEAL_NO = p_deal_no
1057: and DEAL_TYPE = p_deal_type;

Line 1067: update XTR_DEALS -- Update paying side deal

1063: open IRS_OTHER_DEAL;
1064: fetch IRS_OTHER_DEAL into receive_deal_no;
1065: close IRS_OTHER_DEAL;
1066:
1067: update XTR_DEALS -- Update paying side deal
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 1072: update XTR_DEALS -- Update receiving side deal

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;
1072: update XTR_DEALS -- Update receiving side deal
1073: set DUAL_AUTHORISATION_BY = p_validated_by,
1074: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1075: where DEAL_NO = receive_deal_no
1076: and DEAL_TYPE = p_deal_type;

Line 1080: update XTR_DEALS

1076: and DEAL_TYPE = p_deal_type;
1077: end if;
1078: elsif p_deal_type ='TMM' then
1079: ---- Only for NEW_WHOLESALE_TERM_CONTRACT at this stage. Should use TERM_ACTIONS like Retail Term
1080: update XTR_DEALS
1081: set DUAL_AUTHORISATION_BY = p_validated_by,
1082: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1083: where DEAL_NO = p_deal_no
1084: and DEAL_TYPE = p_deal_type;

Line 1095: update XTR_DEALS

1091: and settle_date is null;
1092:
1093: elsif p_deal_type = 'STOCK' then
1094: if p_action_type = 'NEW_STOCK_BUY_CONTRACT' then -- BUY stock deal
1095: update XTR_DEALS
1096: set DUAL_AUTHORISATION_BY = p_validated_by,
1097: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1098: where DEAL_NO = p_deal_no
1099: and DEAL_TYPE = p_deal_type;

Line 1124: update XTR_DEALS

1120: and TRANSACTION_NUMBER = p_trans_no
1121: and DEAL_TYPE = p_deal_type;
1122:
1123: elsif p_action_type = 'NEW_STOCK_SELL_CONTRACT' then -- SELL stock deal
1124: update XTR_DEALS
1125: set DUAL_AUTHORISATION_BY = p_validated_by,
1126: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1127: where DEAL_NO = p_deal_no
1128: and DEAL_TYPE = p_deal_type;

Line 1143: update XTR_DEALS

1139: --- PRINCIPAL_ADJUSTMENT_OF_RETAIL_TERM_CONTRA
1140: --- RETAIL_TERM_INTEREST_RESET
1141: --- Ammend Schedule Type for Retail Term
1142: if p_action_type ='NEW_RETAIL_TERM_CONTRACT' then
1143: update XTR_DEALS
1144: set DUAL_AUTHORISATION_BY = p_validated_by,
1145: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1146: where DEAL_NO = p_deal_no
1147: and DEAL_TYPE = p_deal_type;