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_WRAPPER_API_P dependencies on XTR_DEAL_DATE_AMOUNTS

Line 78: u_date_type XTR_DEAL_DATE_AMOUNTS.DATE_TYPE%TYPE;

74: l_adjust number;
75: l_dda_amount number;
76: u_deal_number Number;
77: u_transaction_number Number;
78: u_date_type XTR_DEAL_DATE_AMOUNTS.DATE_TYPE%TYPE;
79: u_amount_type XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE%TYPE;
80: u_amount_date XTR_DEAL_DATE_AMOUNTS.AMOUNT_DATE%TYPE;
81: u_currency XTR_DEAL_DATE_AMOUNTS.CURRENCY%TYPE;
82: u_account_number XTR_DEAL_DATE_AMOUNTS.ACCOUNT_NO%TYPE;

Line 79: u_amount_type XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE%TYPE;

75: l_dda_amount number;
76: u_deal_number Number;
77: u_transaction_number Number;
78: u_date_type XTR_DEAL_DATE_AMOUNTS.DATE_TYPE%TYPE;
79: u_amount_type XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE%TYPE;
80: u_amount_date XTR_DEAL_DATE_AMOUNTS.AMOUNT_DATE%TYPE;
81: u_currency XTR_DEAL_DATE_AMOUNTS.CURRENCY%TYPE;
82: u_account_number XTR_DEAL_DATE_AMOUNTS.ACCOUNT_NO%TYPE;
83: u_Settlement_Number XTR_DEAL_DATE_AMOUNTS.SETTLEMENT_NUMBER%TYPE;

Line 80: u_amount_date XTR_DEAL_DATE_AMOUNTS.AMOUNT_DATE%TYPE;

76: u_deal_number Number;
77: u_transaction_number Number;
78: u_date_type XTR_DEAL_DATE_AMOUNTS.DATE_TYPE%TYPE;
79: u_amount_type XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE%TYPE;
80: u_amount_date XTR_DEAL_DATE_AMOUNTS.AMOUNT_DATE%TYPE;
81: u_currency XTR_DEAL_DATE_AMOUNTS.CURRENCY%TYPE;
82: u_account_number XTR_DEAL_DATE_AMOUNTS.ACCOUNT_NO%TYPE;
83: u_Settlement_Number XTR_DEAL_DATE_AMOUNTS.SETTLEMENT_NUMBER%TYPE;
84: l_amount NUMBER;

Line 81: u_currency XTR_DEAL_DATE_AMOUNTS.CURRENCY%TYPE;

77: u_transaction_number Number;
78: u_date_type XTR_DEAL_DATE_AMOUNTS.DATE_TYPE%TYPE;
79: u_amount_type XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE%TYPE;
80: u_amount_date XTR_DEAL_DATE_AMOUNTS.AMOUNT_DATE%TYPE;
81: u_currency XTR_DEAL_DATE_AMOUNTS.CURRENCY%TYPE;
82: u_account_number XTR_DEAL_DATE_AMOUNTS.ACCOUNT_NO%TYPE;
83: u_Settlement_Number XTR_DEAL_DATE_AMOUNTS.SETTLEMENT_NUMBER%TYPE;
84: l_amount NUMBER;
85: l_hce_amt NUMBER;

Line 82: u_account_number XTR_DEAL_DATE_AMOUNTS.ACCOUNT_NO%TYPE;

78: u_date_type XTR_DEAL_DATE_AMOUNTS.DATE_TYPE%TYPE;
79: u_amount_type XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE%TYPE;
80: u_amount_date XTR_DEAL_DATE_AMOUNTS.AMOUNT_DATE%TYPE;
81: u_currency XTR_DEAL_DATE_AMOUNTS.CURRENCY%TYPE;
82: u_account_number XTR_DEAL_DATE_AMOUNTS.ACCOUNT_NO%TYPE;
83: u_Settlement_Number XTR_DEAL_DATE_AMOUNTS.SETTLEMENT_NUMBER%TYPE;
84: l_amount NUMBER;
85: l_hce_amt NUMBER;
86: l_test_number NUMBER;

Line 83: u_Settlement_Number XTR_DEAL_DATE_AMOUNTS.SETTLEMENT_NUMBER%TYPE;

79: u_amount_type XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE%TYPE;
80: u_amount_date XTR_DEAL_DATE_AMOUNTS.AMOUNT_DATE%TYPE;
81: u_currency XTR_DEAL_DATE_AMOUNTS.CURRENCY%TYPE;
82: u_account_number XTR_DEAL_DATE_AMOUNTS.ACCOUNT_NO%TYPE;
83: u_Settlement_Number XTR_DEAL_DATE_AMOUNTS.SETTLEMENT_NUMBER%TYPE;
84: l_amount NUMBER;
85: l_hce_amt NUMBER;
86: l_test_number NUMBER;
87: l_cashflow_amt NUMBER;

Line 88: l_deal_type XTR_DEAL_DATE_AMOUNTS.DEAL_TYPE%TYPE;

84: l_amount NUMBER;
85: l_hce_amt NUMBER;
86: l_test_number NUMBER;
87: l_cashflow_amt NUMBER;
88: l_deal_type XTR_DEAL_DATE_AMOUNTS.DEAL_TYPE%TYPE;
89:
90: Cursor C1 is
91: Select *
92: From Xtr_Deal_Date_Amounts

Line 92: From Xtr_Deal_Date_Amounts

88: l_deal_type XTR_DEAL_DATE_AMOUNTS.DEAL_TYPE%TYPE;
89:
90: Cursor C1 is
91: Select *
92: From Xtr_Deal_Date_Amounts
93: Where settlement_number in
94: (Select settlement_number
95: From Xtr_Settlement_Summary
96: Where net_ID = p_settlement_summary_ID)

Line 102: from xtr_deal_date_amounts Where settlement_number in

98:
99:
100: cursor pop_dda_var is
101: select deal_number,transaction_number,date_type,amount_type,amount_date,currency,account_no,settlement_number
102: from xtr_deal_date_amounts Where settlement_number in
103: (Select settlement_number
104: From Xtr_Settlement_Summary
105: Where settlement_summary_id = p_settlement_summary_ID);
106:

Line 123: from XTR_DEAL_DATE_AMOUNTS_V

119: CASHFLOW_AMOUNT,
120: /******** code below added by Ilavenil for CE Reconciliation project *******/
121: SETTLEMENT_NUMBER,
122: NETOFF_NUMBER
123: from XTR_DEAL_DATE_AMOUNTS_V
124: where DEAL_NUMBER = p_deal_no
125: and TRANSACTION_NUMBER = p_trans_no
126: and DATE_TYPE = p_date_type
127: and AMOUNT_TYPE = p_amount_type

Line 150: select deal_type into l_deal_type from xtr_deal_date_amounts where settlement_number in

146:
147: -- ER 7601596 Start
148:
149: BEGIN --12733323
150: select deal_type into l_deal_type from xtr_deal_date_amounts where settlement_number in
151: (Select settlement_number
152: From Xtr_Settlement_Summary
153: Where settlement_summary_id = p_settlement_summary_ID);
154: EXCEPTION

Line 164: select amount into l_dda_amount from xtr_deal_date_amounts where settlement_number in

160:
161: if l_deal_type ='RTMM' then
162:
163: /* Calculate Adjustments */
164: select amount into l_dda_amount from xtr_deal_date_amounts where settlement_number in
165: (Select settlement_number
166: From Xtr_Settlement_Summary
167: Where settlement_summary_id = p_settlement_summary_ID);
168:

Line 205: Select Xtr_Deal_Date_Amounts_S.Nextval

201: Else
202: l_cashflow_amt := nvl(DDA_ROW.cashflow_amount,0) + l_adjust;
203: End If;
204:
205: Select Xtr_Deal_Date_Amounts_S.Nextval
206: Into v_reconciled_reference
207: From dual;
208:
209:

Line 210: update XTR_DEAL_DATE_AMOUNTS_V

206: Into v_reconciled_reference
207: From dual;
208:
209:
210: update XTR_DEAL_DATE_AMOUNTS_V
211: set RECONCILED_REFERENCE = v_reconciled_reference,
212: RECONCILED_PASS_CODE = decode(DATE_TYPE,'FORCAST','^'||'M','M'),
213: RECONCILED_DAYS_ADJUST = (nvl(P_VAL_DATE,SYSDATE) - U_AMOUNT_DATE),
214: AMOUNT_DATE = decode(DATE_TYPE,'FORCAST',nvl(P_VAL_DATE,SYSDATE),AMOUNT_DATE),

Line 261: Select Xtr_Deal_Date_Amounts_S.Nextval

257: Into v_settlement_number
258: From Xtr_Settlement_Summary
259: Where settlement_summary_id = p_settlement_summary_ID;
260:
261: Select Xtr_Deal_Date_Amounts_S.Nextval
262: Into v_reconciled_reference
263: From dual;
264:
265: /* This is to update DDA about the successful completion of Reconciliation */

Line 266: Update Xtr_Deal_Date_Amounts

262: Into v_reconciled_reference
263: From dual;
264:
265: /* This is to update DDA about the successful completion of Reconciliation */
266: Update Xtr_Deal_Date_Amounts
267: Set Reconciled_Reference = v_reconciled_reference,
268: Reconciled_Pass_Code = p_reconciled_method
269: Where settlement_number = v_settlement_number;
270:

Line 274: Update Xtr_Deal_Date_Amounts

270:
271: If SQL%NOTFOUND then
272: For C1_Rec in C1
273: Loop
274: Update Xtr_Deal_Date_Amounts
275: Set reconciled_reference = v_reconciled_reference,
276: reconciled_pass_code = p_reconciled_method
277: Where current of C1;
278: End Loop;

Line 287: select distinct deal_type into l_deal_type from xtr_deal_date_amounts where settlement_number in

283: Else
284: -- ER 7601596 Start for Unreconciliation
285:
286: BEGIN --12733323
287: select distinct deal_type into l_deal_type from xtr_deal_date_amounts where settlement_number in
288: (Select settlement_number
289: From Xtr_Settlement_Summary
290: Where settlement_summary_id = p_settlement_summary_ID);
291: EXCEPTION

Line 302: SELECT DISTINCT reconciled_reference into v_recon_ref FROM xtr_deal_date_amounts

298: declare
299: v_recon_ref number;
300: begin
301:
302: SELECT DISTINCT reconciled_reference into v_recon_ref FROM xtr_deal_date_amounts
303: WHERE settlement_number IN
304: (SELECT settlement_number FROM xtr_settlement_summary WHERE settlement_summary_id = p_settlement_summary_ID);
305:
306: XTR_AUTO_RECONCILIATION.REVERSE_ROLL_TRANS_RTMM(

Line 329: Update Xtr_Deal_Date_Amounts

325: Into v_settlement_number
326: From Xtr_Settlement_Summary
327: Where settlement_summary_id = p_settlement_summary_ID;
328:
329: Update Xtr_Deal_Date_Amounts
330: Set Reconciled_Reference = null,
331: Reconciled_Pass_Code = null
332: Where settlement_number = v_settlement_number;
333:

Line 338: Update Xtr_Deal_Date_Amounts

334: If SQL%NOTFOUND then
335: For C1_Rec in C1
336: Loop
337: /* After successful un-reconciliation, DDA is updated such that the records are available for future reconciliation */
338: Update Xtr_Deal_Date_Amounts
339: Set reconciled_reference = null,
340: reconciled_pass_code = null
341: Where current of C1;
342: End Loop;

Line 345: Update Xtr_Deal_Date_Amounts

341: Where current of C1;
342: End Loop;
343: End if;
344: -- ER 7601596 Start
345: Update Xtr_Deal_Date_Amounts
346: Set settlement_number = null
347: Where settlement_number = v_settlement_number and deal_type ='RTMM' and amount_type='PRINFLW'
348: and exists(select 1 from Xtr_Deal_Date_Amounts where settlement_number = v_settlement_number and deal_type ='RTMM' and amount_type='INTSET') ;
349: -- ER 7601596 End

Line 348: and exists(select 1 from Xtr_Deal_Date_Amounts where settlement_number = v_settlement_number and deal_type ='RTMM' and amount_type='INTSET') ;

344: -- ER 7601596 Start
345: Update Xtr_Deal_Date_Amounts
346: Set settlement_number = null
347: Where settlement_number = v_settlement_number and deal_type ='RTMM' and amount_type='PRINFLW'
348: and exists(select 1 from Xtr_Deal_Date_Amounts where settlement_number = v_settlement_number and deal_type ='RTMM' and amount_type='INTSET') ;
349: -- ER 7601596 End
350: End if;
351:
352: If p_result = 'XTR2_SUCCESS' then

Line 948: xtr_deal_date_amounts dd,xtr_revaluation_details rd

944: /*cursor cur_reval_insbal IS
945: SELECT max(period_to)
946: FROM
947: xtr_bank_balances bb,xtr_bank_accounts ba,
948: xtr_deal_date_amounts dd,xtr_revaluation_details rd
949: WHERE
950: bb.company_code = p_company_code
951: AND bb.account_number = p_account_number
952: AND bb.company_code = ba.party_code

Line 964: xtr_deal_date_amounts dd,

960: cursor cur_reval_insbal IS
961: select max(period_to)
962: FROM
963: xtr_bank_accounts ba,
964: xtr_deal_date_amounts dd,
965: xtr_revaluation_details rd
966: WHERE ba.currency = p_currency_code
967: AND ba.currency = dd.currency
968: AND dd.deal_number = rd.deal_no

Line 981: xtr_deal_date_amounts dd,xtr_accrls_amort aa

977: /*cursor cur_accrl_insbal IS
978: SELECT max(period_to)
979: FROM
980: xtr_bank_balances bb,xtr_bank_accounts ba,
981: xtr_deal_date_amounts dd,xtr_accrls_amort aa
982: WHERE
983: bb.company_code = p_company_code
984: AND bb.account_number = p_account_number
985: AND bb.company_code = ba.party_code

Line 997: xtr_deal_date_amounts dd,

993: cursor cur_accrl_insbal IS
994: select max(period_to)
995: FROM
996: xtr_bank_accounts ba,
997: xtr_deal_date_amounts dd,
998: xtr_accrls_amort aa
999: WHERE ba.currency = p_currency_code
1000: AND ba.currency = dd.currency
1001: AND dd.deal_number = aa.deal_no

Line 1721: from xtr_deal_date_amounts

1717: /* Bug 4231200 Added the last AND condition. */
1718:
1719: cursor chk_reconcile (l_amt_type VARCHAR2) is
1720: select 1
1721: from xtr_deal_date_amounts
1722: where deal_number = l_deal_num
1723: and transaction_number = l_tran_num
1724: and amount_type = l_amt_type
1725: and nvl(cashflow_amount,0) <> 0

Line 1839: xtr_deal_date_amounts B,

1835:
1836: cursor chk_reconcile (l_deal_type VARCHAR2) is
1837: select A.transaction_number
1838: from xtr_interacct_transfers A,
1839: xtr_deal_date_amounts B,
1840: xtr_deal_date_amounts C
1841: where A.company_code = l_company_code
1842: and A.transfer_amount = l_transfer_amount
1843: and A.transfer_date = l_transfer_date

Line 1840: xtr_deal_date_amounts C

1836: cursor chk_reconcile (l_deal_type VARCHAR2) is
1837: select A.transaction_number
1838: from xtr_interacct_transfers A,
1839: xtr_deal_date_amounts B,
1840: xtr_deal_date_amounts C
1841: where A.company_code = l_company_code
1842: and A.transfer_amount = l_transfer_amount
1843: and A.transfer_date = l_transfer_date
1844: and A.portfolio_code = l_portfolio