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_CALC_P dependencies on XTR_DEAL_DATE_AMOUNTS_V

Line 1391: delete from XTR_DEAL_DATE_AMOUNTS_V

1387: ENDORSER_CODE = l_date_exits
1388: where ROWID = pmt.ROWID;
1389:
1390: --DDA
1391: delete from XTR_DEAL_DATE_AMOUNTS_V
1392: where DEAL_NUMBER = l_deal_no
1393: and TRANSACTION_NUMBER = pmt.TRANSACTION_NUMBER;
1394:
1395: --

Line 1402: insert into XTR_DEAL_DATE_AMOUNTS_V

1398: if nvl(pmt.PRINCIPAL_ADJUST,0) <> 0 then
1399: -- Principal Increase has ocurred
1400: if pmt.PRINCIPAL_ACTION = 'INCRSE' then
1401: -- Principal Increase has ocurred
1402: insert into XTR_DEAL_DATE_AMOUNTS_V
1403: (deal_type,amount_type,date_type,
1404: deal_number,transaction_number,transaction_date,currency,
1405: amount,hce_amount,amount_date,transaction_rate,
1406: cashflow_amount,company_code,account_no,action_code,

Line 1429: insert into XTR_DEAL_DATE_AMOUNTS_V

1425: end if;
1426: -- Principal Reduction Row
1427: if nvl(pmt.PRINCIPAL_ACTION,'@#@') = 'DECRSE' then
1428: if nvl(pmt.PRINCIPAL_AMOUNT_TYPE,'PRINFLW') <> 'PRINFLW' then
1429: insert into XTR_DEAL_DATE_AMOUNTS_V
1430: (deal_type,amount_type,date_type,
1431: deal_number,transaction_number,transaction_date,currency,
1432: amount,hce_amount,amount_date,transaction_rate,
1433: cashflow_amount,company_code,account_no,action_code,

Line 1464: insert into XTR_DEAL_DATE_AMOUNTS_V

1460:
1461: --
1462: -- Reduction in Principal from a repayment (insert forcast row with 0's if not received)
1463: --
1464: insert into XTR_DEAL_DATE_AMOUNTS_V
1465: (deal_type,amount_type,date_type,
1466: deal_number,transaction_number,transaction_date,currency,
1467: amount,hce_amount,amount_date,transaction_rate,
1468: cashflow_amount,company_code,account_no,action_code,

Line 1503: insert into XTR_DEAL_DATE_AMOUNTS_V

1499: l_dual_authorisation_on);
1500:
1501: if nvl(pmt.BALANCE_OUT,0) <> 0 and pmt.INTEREST_RATE <> 0 then
1502: --- Rateset Date
1503: insert into XTR_DEAL_DATE_AMOUNTS_V
1504: (deal_type,amount_type,date_type,
1505: deal_number,transaction_number,transaction_date,currency,
1506: amount,hce_amount,amount_date,transaction_rate,
1507: cashflow_amount,company_code,account_no,action_code,

Line 1524: insert into XTR_DEAL_DATE_AMOUNTS_V

1520: end if;
1521:
1522: -- Interest Row
1523:
1524: insert into XTR_DEAL_DATE_AMOUNTS_V
1525: (deal_type,amount_type,date_type,
1526: deal_number,transaction_number,transaction_date,currency,
1527: amount,hce_amount,amount_date,transaction_rate,
1528: cashflow_amount,company_code,account_no,action_code,

Line 1555: delete from XTR_DEAL_DATE_AMOUNTS_V

1551: l_dual_authorisation_by, -- bug 3958736
1552: l_dual_authorisation_on);
1553: --
1554: if nvl(pmt.PRINCIPAL_ADJUST,0) = 0 then
1555: delete from XTR_DEAL_DATE_AMOUNTS_V
1556: where DEAL_NUMBER = l_deal_no
1557: and TRANSACTION_NUMBER = pmt.TRANSACTION_NUMBER
1558: and AMOUNT_TYPE = 'PRINFLW'
1559: and ACTION_CODE = 'INCRSE';-- Why only INCRSE ????

Line 1564: delete from XTR_DEAL_DATE_AMOUNTS_V

1560: end if;
1561: --
1562: if pmt.NO_OF_DAYS = 0 and pmt.PRINCIPAL_ACTION is NULL and nvl(pmt.INTEREST,0) = 0 then
1563: -- **** questionable delete
1564: delete from XTR_DEAL_DATE_AMOUNTS_V
1565: where DEAL_NUMBER = l_deal_no
1566: and TRANSACTION_NUMBER = pmt.TRANSACTION_NUMBER
1567: and DATE_TYPE = 'RATESET';
1568: end if;

Line 1586: delete from XTR_DEAL_DATE_AMOUNTS_V

1582: where DEAL_NUMBER = l_deal_no
1583: and START_DATE > l_nill_date
1584: and SETTLE_DATE is null; --- >=
1585: --
1586: delete from XTR_DEAL_DATE_AMOUNTS_V
1587: where DEAL_NUMBER = l_deal_no
1588: and amount_date > l_nill_date;
1589: end if;
1590: --

Line 1604: update XTR_DEAL_DATE_AMOUNTS_V

1600: g_accum_interest_bf :='0';
1601: g_principal_adjust := to_char(l_face_value_amount);
1602: end if;
1603: else
1604: update XTR_DEAL_DATE_AMOUNTS_V
1605: set amount=nvl(pmt.BALANCE_OUT,0),
1606: hce_amount=nvl(hce_balos,0)
1607: where deal_type='RTMM' and amount_type='BALOUT' and deal_number=l_deal_no;
1608: if SQL%NOTFOUND then

Line 1610: insert into XTR_DEAL_DATE_AMOUNTS_V

1606: hce_amount=nvl(hce_balos,0)
1607: where deal_type='RTMM' and amount_type='BALOUT' and deal_number=l_deal_no;
1608: if SQL%NOTFOUND then
1609: --- Add 1 more row to DDA for Balout
1610: insert into XTR_DEAL_DATE_AMOUNTS_V
1611: (deal_type,amount_type,date_type,
1612: deal_number,transaction_number,transaction_date,currency,
1613: amount,hce_amount,amount_date,transaction_rate,
1614: cashflow_amount,company_code,account_no,action_code,

Line 1635: insert into XTR_DEAL_DATE_AMOUNTS_V

1631: end if;
1632:
1633: if nvl(g_chk_bal,'N')='Y' and nvl(c_writoff_int,0)<>0 then
1634: -- Add 1 more row to DDA for WRITINT
1635: insert into XTR_DEAL_DATE_AMOUNTS_V
1636: (deal_type,amount_type,date_type,
1637: deal_number,transaction_number,transaction_date,currency,
1638: amount,hce_amount,amount_date,transaction_rate,
1639: cashflow_amount,company_code,account_no,action_code,