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

Line 327: from XTR_DEAL_DATE_AMOUNTS_V dda

323: ---------
324: CURSOR DDA_REC_ROW is
325: select dda.DEAL_NUMBER, dda.TRANSACTION_NUMBER, dda.AMOUNT, dda.AMOUNT_DATE,
326: dda.RECONCILED_REFERENCE,substr(dda.RECONCILED_PASS_CODE,2) ---reset
327: from XTR_DEAL_DATE_AMOUNTS_V dda
328: where dda.RECONCILED_REFERENCE between
329: nvl(L_MIN_REC_NOS,9999999) and nvl(L_MAX_REC_NOS,0)
330: and dda.DEAL_TYPE = 'RTMM'
331: and nvl(dda.amount,0) <>0

Line 710: from xtr_deal_date_amounts_v

706: -- Bug 4226409
707: cursor cur_settle_detail is
708: select actual_settlement_date,settlement_number,deal_type,trans_mts
709: ,settlement_authorised_by,audit_indicator
710: from xtr_deal_date_amounts_v
711: where deal_number = l_deal_no
712: and transaction_number = pmt.transaction_number
713: and amount_type = 'INTSET';
714:

Line 717: l_deal_type xtr_deal_date_amounts.deal_type%TYPE; -- added for bug 4226409.

713: and amount_type = 'INTSET';
714:
715: l_settle_number number; -- added for bug 4226409.
716: l_settle_date date; -- added for bug 4226409.
717: l_deal_type xtr_deal_date_amounts.deal_type%TYPE; -- added for bug 4226409.
718: l_trans_mts xtr_deal_date_amounts.trans_mts%TYPE; -- added for bug 4226409.
719: l_settle_by xtr_deal_date_amounts.settlement_authorised_by%TYPE; -- added for bug 4226409.
720: l_audit_indicator xtr_deal_date_amounts.audit_indicator%TYPE; -- added for bug 4226409.
721:

Line 718: l_trans_mts xtr_deal_date_amounts.trans_mts%TYPE; -- added for bug 4226409.

714:
715: l_settle_number number; -- added for bug 4226409.
716: l_settle_date date; -- added for bug 4226409.
717: l_deal_type xtr_deal_date_amounts.deal_type%TYPE; -- added for bug 4226409.
718: l_trans_mts xtr_deal_date_amounts.trans_mts%TYPE; -- added for bug 4226409.
719: l_settle_by xtr_deal_date_amounts.settlement_authorised_by%TYPE; -- added for bug 4226409.
720: l_audit_indicator xtr_deal_date_amounts.audit_indicator%TYPE; -- added for bug 4226409.
721:
722:

Line 719: l_settle_by xtr_deal_date_amounts.settlement_authorised_by%TYPE; -- added for bug 4226409.

715: l_settle_number number; -- added for bug 4226409.
716: l_settle_date date; -- added for bug 4226409.
717: l_deal_type xtr_deal_date_amounts.deal_type%TYPE; -- added for bug 4226409.
718: l_trans_mts xtr_deal_date_amounts.trans_mts%TYPE; -- added for bug 4226409.
719: l_settle_by xtr_deal_date_amounts.settlement_authorised_by%TYPE; -- added for bug 4226409.
720: l_audit_indicator xtr_deal_date_amounts.audit_indicator%TYPE; -- added for bug 4226409.
721:
722:
723: begin

Line 720: l_audit_indicator xtr_deal_date_amounts.audit_indicator%TYPE; -- added for bug 4226409.

716: l_settle_date date; -- added for bug 4226409.
717: l_deal_type xtr_deal_date_amounts.deal_type%TYPE; -- added for bug 4226409.
718: l_trans_mts xtr_deal_date_amounts.trans_mts%TYPE; -- added for bug 4226409.
719: l_settle_by xtr_deal_date_amounts.settlement_authorised_by%TYPE; -- added for bug 4226409.
720: l_audit_indicator xtr_deal_date_amounts.audit_indicator%TYPE; -- added for bug 4226409.
721:
722:
723: begin
724:

Line 1022: update XTR_DEAL_DATE_AMOUNTS_V

1018: null;
1019: End if;
1020: --
1021: -- Update Interest Amounts
1022: update XTR_DEAL_DATE_AMOUNTS_V
1023: set AMOUNT = round(decode(nvl(pmt.PI_AMOUNT_RECEIVED,0)
1024: ,0,nvl(pmt.PI_AMOUNT_DUE,0)
1025: ,nvl(pmt.INTEREST_SETTLED,0)),
1026: rounding_fac),

Line 1053: update XTR_DEAL_DATE_AMOUNTS_V

1049: End if;
1050: --
1051: -- Principal Repayment has/will ocurr ???
1052: if nvl(l_prin_decr,0)<>0 then
1053: update XTR_DEAL_DATE_AMOUNTS_V
1054: set AMOUNT = decode(nvl(AMOUNT,0),0,nvl(l_prin_decr,0),AMOUNT),
1055: HCE_AMOUNT = decode(nvl(HCE_AMOUNT,0),0,hce_decr,HCE_AMOUNT),
1056: AMOUNT_DATE = nvl(pmt.SETTLE_DATE,pmt.MATURITY_DATE),
1057: DATE_TYPE = decode(nvl(pmt.PI_AMOUNT_RECEIVED,0),0,'FORCAST','SETTLE'),

Line 1076: update XTR_DEAL_DATE_AMOUNTS_V

1072: fetch cur_settle_detail into l_settle_date,l_settle_number,l_deal_type
1073: ,l_trans_mts,l_settle_by,l_audit_indicator;
1074: if(l_deal_type = 'RTMM') then
1075: close cur_settle_detail;
1076: update XTR_DEAL_DATE_AMOUNTS_V
1077: set SETTLEMENT_NUMBER = l_settle_number,
1078: ACTUAL_SETTLEMENT_DATE = l_settle_date,
1079: TRANS_MTS = l_trans_mts,
1080: SETTLEMENT_AUTHORISED_BY = l_settle_by,

Line 1095: delete from XTR_DEAL_DATE_AMOUNTS_V

1091: End if;
1092: --
1093: end if;
1094: if nvl(pmt.PRINCIPAL_ADJUST,0) = 0 then
1095: delete from XTR_DEAL_DATE_AMOUNTS_V
1096: where DEAL_NUMBER = l_deal_no
1097: and TRANSACTION_NUMBER = pmt.TRANSACTION_NUMBER
1098: and AMOUNT_TYPE in ('PRINFLW')
1099: and ACTION_CODE = 'INCRSE';

Line 1119: UPDATE XTR_DEAL_DATE_AMOUNTS_V

1115: End if;
1116: end if;
1117:
1118: -- Update BALOUT Amounts
1119: UPDATE XTR_DEAL_DATE_AMOUNTS_V
1120: set AMOUNT = nvl(pmt.BALANCE_OUT,0),
1121: HCE_AMOUNT = hce_balos
1122: where DEAL_NUMBER = l_deal_no
1123: and DEAL_TYPE='RTMM'

Line 1132: insert into XTR_DEAL_DATE_AMOUNTS_V

1128:
1129: if SQL%NOTFOUND then
1130: -- Add 1 more row to DDA for Balout
1131:
1132: insert into XTR_DEAL_DATE_AMOUNTS_V
1133: (deal_type,amount_type,date_type,
1134: deal_number,transaction_number,transaction_date,currency,
1135: amount,hce_amount,amount_date,transaction_rate,
1136: cashflow_amount,company_code,account_no,action_code,

Line 1250: select XTR_DEAL_DATE_AMOUNTS_S.NEXTVAL

1246: rec_det REC%ROWTYPE;
1247: v_netoff_number NUMBER;
1248: --
1249: cursor REC_NUM is
1250: select XTR_DEAL_DATE_AMOUNTS_S.NEXTVAL
1251: from DUAL;
1252: --
1253:
1254: Cursor C1(p_netoff_number number) is

Line 1258: from xtr_deal_date_amounts

1254: Cursor C1(p_netoff_number number) is
1255: select net_id from xtr_settlement_summary
1256: where settlement_number =
1257: (select settlement_number
1258: from xtr_deal_date_amounts
1259: where netoff_number = p_netoff_number
1260: and rownum < 2);
1261:
1262: Cursor C2(p_reconciled_reference number) is

Line 1264: from xtr_deal_date_amounts

1260: and rownum < 2);
1261:
1262: Cursor C2(p_reconciled_reference number) is
1263: select settlement_number
1264: from xtr_deal_date_amounts
1265: where reconciled_reference = p_reconciled_reference;
1266:
1267: /************* CE Reconc project ******************/
1268: /* modified the cursor to differentiate non-netted records from netted records. incase of netted records, we need to

Line 1272: from XTR_DEAL_DATE_AMOUNTS_V

1268: /* modified the cursor to differentiate non-netted records from netted records. incase of netted records, we need to
1269: look at the netted amount. */
1270: cursor DDA is
1271: select sum(round(CASHFLOW_AMOUNT,2)),count(*),AMOUNT_DATE, NETOFF_NUMBER
1272: from XTR_DEAL_DATE_AMOUNTS_V
1273: where ((to_char(DEAL_NUMBER) = ltrim(rtrim(rec_det.PARTICULARS))
1274: and nvl(l_deal_no,'N') = 'Y')
1275: or (l_deal_no is NULL )) --- modify
1276: and ((AMOUNT_DATE between (rec_det.VALUE_DATE - l_days) and

Line 1307: from XTR_DEAL_DATE_AMOUNTS_V

1303: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N') ='Y')
1304: group by AMOUNT_DATE, NETOFF_NUMBER
1305: union all
1306: select sum(round(CASHFLOW_AMOUNT,2)),count(distinct NETOFF_NUMBER),AMOUNT_DATE, NETOFF_NUMBER
1307: from XTR_DEAL_DATE_AMOUNTS_V
1308: where
1309: /*
1310: ((to_char(DEAL_NUMBER) = ltrim(rtrim(rec_det.PARTICULARS))
1311: and nvl(l_deal_no,'N') = 'Y')

Line 1350: from XTR_DEAL_DATE_AMOUNTS_V

1346: /***************** CE Recon project **********************/
1347: /* non-netted records are summed up, while netted records are summed by the netoff_number */
1348: cursor DDA_SUM_DATE is
1349: select AMOUNT_DATE,sum(round(CASHFLOW_AMOUNT,2)),count(distinct nvl(NETOFF_NUMBER, -1)), NETOFF_NUMBER
1350: from XTR_DEAL_DATE_AMOUNTS_V
1351: where ((to_char(DEAL_NUMBER) = ltrim(rtrim(rec_det.PARTICULARS))
1352: and nvl(l_deal_no,'N') = 'Y')
1353: or (l_deal_no is NULL and date_type <> 'FORCAST'))
1354: and (((AMOUNT_DATE between (rec_det.VALUE_DATE - l_days) and

Line 1381: from XTR_DEAL_DATE_AMOUNTS_V

1377: /************* CE Recon proejct *************/
1378: /* netted records and non-netted records are dealt with separately*/
1379: cursor DDA_SUM_RANGE is
1380: select sum(round(CASHFLOW_AMOUNT,2)),count(distinct nvl(netoff_number, -1)), Netoff_number
1381: from XTR_DEAL_DATE_AMOUNTS_V
1382: where ((to_char(DEAL_NUMBER) = ltrim(rtrim(rec_det.PARTICULARS))
1383: and nvl(l_deal_no,'N') = 'Y')
1384: or (l_deal_no is NULL and date_type<>'FORCAST'))
1385: and (((AMOUNT_DATE between (rec_det.VALUE_DATE - l_days) and

Line 1618: update XTR_DEAL_DATE_AMOUNTS

1614: utl_file.put_line (l_file,'>>---- inside IF ');
1615: utl_file.put_line (l_file,'>>------------------------------');
1616: /***************/
1617:
1618: update XTR_DEAL_DATE_AMOUNTS
1619: set RECONCILED_REFERENCE = l_rec_nos,
1620: RECONCILED_PASS_CODE =
1621: decode(DATE_TYPE,'FORCAST','^'||P_PASS_CODE,P_PASS_CODE),
1622: RECONCILED_DAYS_ADJUST = (trunc(rec_det.VALUE_DATE) -

Line 1679: update XTR_DEAL_DATE_AMOUNTS

1675: utl_file.put_line (l_file,'>>---- inside ELSE ');
1676: utl_file.put_line (l_file,'>>------------------------------');
1677: /***************/
1678:
1679: update XTR_DEAL_DATE_AMOUNTS
1680: set RECONCILED_REFERENCE = l_rec_nos,
1681: RECONCILED_PASS_CODE =
1682: decode(DATE_TYPE,'FORCAST','^'||P_PASS_CODE,P_PASS_CODE),
1683: RECONCILED_DAYS_ADJUST = (trunc(rec_det.VALUE_DATE) -

Line 1778: update XTR_DEAL_DATE_AMOUNTS

1774: utl_file.put_line (l_file,'>>---- inside IF '||v_netoff_number);
1775: utl_file.put_line (l_file,'>>------------------------------');
1776: /***************/
1777:
1778: update XTR_DEAL_DATE_AMOUNTS
1779: set RECONCILED_REFERENCE = l_rec_nos,
1780: RECONCILED_PASS_CODE =
1781: decode(DATE_TYPE,'FORCAST','^'||P_PASS_CODE,P_PASS_CODE),
1782: RECONCILED_DAYS_ADJUST = (trunc(rec_det.VALUE_DATE) -

Line 1840: update XTR_DEAL_DATE_AMOUNTS

1836: utl_file.put_line (l_file,'>>---- inside ELSE ');
1837: utl_file.put_line (l_file,'>>------------------------------');
1838: /***************/
1839:
1840: update XTR_DEAL_DATE_AMOUNTS
1841: set RECONCILED_REFERENCE = l_rec_nos,
1842: RECONCILED_PASS_CODE =
1843: decode(DATE_TYPE,'FORCAST','^'||P_PASS_CODE,P_PASS_CODE),
1844: RECONCILED_DAYS_ADJUST = (trunc(rec_det.VALUE_DATE) -

Line 1971: update XTR_DEAL_DATE_AMOUNTS

1967: utl_file.put_line (l_file,'>>---- inside IF ');
1968: utl_file.put_line (l_file,'>>------------------------------');
1969: /***************/
1970:
1971: update XTR_DEAL_DATE_AMOUNTS
1972: set RECONCILED_REFERENCE = l_rec_nos,
1973: RECONCILED_PASS_CODE =
1974: decode(DATE_TYPE,'FORCAST','^'||P_PASS_CODE,P_PASS_CODE),
1975: RECONCILED_DAYS_ADJUST = (trunc(rec_det.VALUE_DATE) -

Line 2034: update XTR_DEAL_DATE_AMOUNTS

2030: utl_file.put_line (l_file,'>>---- inside ELSE net# '||v_netoff_number);
2031: utl_file.put_line (l_file,'>>------------------------------');
2032: /***************/
2033:
2034: update XTR_DEAL_DATE_AMOUNTS
2035: set RECONCILED_REFERENCE = l_rec_nos,
2036: RECONCILED_PASS_CODE =
2037: decode(DATE_TYPE,'FORCAST','^'||P_PASS_CODE,P_PASS_CODE),
2038: RECONCILED_DAYS_ADJUST = (trunc(rec_det.VALUE_DATE) -

Line 2137: update XTR_DEAL_DATE_AMOUNTS

2133: utl_file.put_line (l_file,'>>----inside IF rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);
2134: utl_file.put_line (l_file,'>>------------------------------');
2135: /***************/
2136:
2137: update XTR_DEAL_DATE_AMOUNTS
2138: set RECONCILED_REFERENCE = l_rec_nos,
2139: RECONCILED_PASS_CODE =
2140: decode(DATE_TYPE,'FORCAST','^'||P_PASS_CODE,P_PASS_CODE),
2141: RECONCILED_DAYS_ADJUST = (trunc(rec_det.VALUE_DATE) -

Line 2201: update XTR_DEAL_DATE_AMOUNTS

2197: utl_file.put_line (l_file,'>>---- inside ELSE net#, rec#, rec-pass '||v_netoff_number||' - '||l_rec_nos||' - '||p_pass_code);
2198: utl_file.put_line (l_file,'>>------------------------------');
2199: /***************/
2200:
2201: update XTR_DEAL_DATE_AMOUNTS
2202: set RECONCILED_REFERENCE = l_rec_nos,
2203: RECONCILED_PASS_CODE =
2204: decode(DATE_TYPE,'FORCAST','^'||P_PASS_CODE,P_PASS_CODE),
2205: RECONCILED_DAYS_ADJUST = (trunc(rec_det.VALUE_DATE) -

Line 2345: update XTR_DEAL_DATE_AMOUNTS

2341: utl_file.put_line (l_file,'>>---- inside IF , rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);
2342: utl_file.put_line (l_file,'>>------------------------------');
2343: /***************/
2344:
2345: update XTR_DEAL_DATE_AMOUNTS
2346: set RECONCILED_REFERENCE = l_rec_nos,
2347: RECONCILED_PASS_CODE =
2348: decode(DATE_TYPE,'FORCAST','^'||P_PASS_CODE,P_PASS_CODE),
2349: RECONCILED_DAYS_ADJUST = (trunc(rec_det.VALUE_DATE) -

Line 2417: update XTR_DEAL_DATE_AMOUNTS

2413: utl_file.put_line (l_file,'>>---- inside ELSE rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);
2414: utl_file.put_line (l_file,'>>------------------------------');
2415: /***************/
2416:
2417: update XTR_DEAL_DATE_AMOUNTS
2418: set RECONCILED_REFERENCE = l_rec_nos,
2419: RECONCILED_PASS_CODE =
2420: decode(DATE_TYPE,'FORCAST','^'||P_PASS_CODE,P_PASS_CODE),
2421: RECONCILED_DAYS_ADJUST = (trunc(rec_det.VALUE_DATE) -