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_LIMITS_P dependencies on XTR_MIRROR_DDA_LIM_ROW_TMP_V

Line 1824: delete from xtr_MIRROR_DDA_LIM_ROW_TMP_V;

1820: PROCEDURE reinitialize_limits (
1821: errbuf OUT NOCOPY VARCHAR2,
1822: retcode OUT NOCOPY NUMBER) IS
1823: BEGIN
1824: delete from xtr_MIRROR_DDA_LIM_ROW_TMP_V;
1825: --
1826: update xtr_COMPANY_LIMITS_V
1827: set UTILISED_AMOUNT = 0;
1828: update xtr_COUNTERPARTY_LIMITS_V

Line 1839: insert into xtr_MIRROR_DDA_LIM_ROW_TMP_V (

1835: set UTILISED_AMOUNT = 0;
1836: --
1837: -- Insert Trigger on MIRROR_DDA_LIMIT_ROW_TEMP will initialize all
1838: -- limits in above tables
1839: insert into xtr_MIRROR_DDA_LIM_ROW_TMP_V (
1840: DEAL_NUMBER,DEAL_TYPE,TRANSACTION_NUMBER,LIMIT_CODE,
1841: AMOUNT,HCE_AMOUNT,DATE_LAST_SET,PRODUCT_TYPE,COMPANY_CODE,
1842: LIMIT_PARTY,AMOUNT_DATE,DEALER_CODE,COUNTRY_CODE,
1843: DEAL_SUBTYPE,PORTFOLIO_CODE,STATUS_CODE,CURRENCY,

Line 1857: delete from xtr_MIRROR_DDA_LIM_ROW_TMP_V;

1853: LIMIT_TYPE,COMMENCE_DATE,CURRENCY_COMBINATION,CONTRA_CCY,
1854: TRANSACTION_RATE,AMOUNT_INDIC,ACCOUNT_NO
1855: from xtr_MIRROR_DDA_LIMIT_ROW_V;
1856: --
1857: delete from xtr_MIRROR_DDA_LIM_ROW_TMP_V;
1858: END reinitialize_limits;
1859: ---------------------------------------------------------------
1860: end XTR_LIMITS_P;