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_EXP_TRANSFERS_PKG dependencies on XTR_EXPOSURE_TRANSACTIONS

Line 726: This procedure maps the XTR_DEALS_INTERFACE to XTR_EXPOSURE_TRANSACTIONS

722:
723:
724:
725: /*------------------------------------------------------------------------
726: This procedure maps the XTR_DEALS_INTERFACE to XTR_EXPOSURE_TRANSACTIONS
727: table.
728: ------------------------------------------------------------------------*/
729: procedure COPY_FROM_INTERFACE_TO_EXP
730: (ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,

Line 863: (ARec IN OUT NOCOPY XTR_EXPOSURE_TRANSACTIONS%rowtype) IS

859: This procedure assigns the values to the global record that will be used
860: to insert the deal later on.
861: ------------------------------------------------------------------------*/
862: procedure COPY_TO_EXP
863: (ARec IN OUT NOCOPY XTR_EXPOSURE_TRANSACTIONS%rowtype) IS
864:
865: BEGIN
866: IF xtr_risk_debug_pkg.g_Debug THEN
867: xtr_risk_debug_pkg.dpush('XTR_EXP_TRANSFERS.COPY_TO_EXP');

Line 1328: This procedure is the table handler for XTR_EXPOSURE_TRANSACTIONS

1324:
1325:
1326:
1327: /*------------------------------------------------------------------------
1328: This procedure is the table handler for XTR_EXPOSURE_TRANSACTIONS
1329: ------------------------------------------------------------------------*/
1330: procedure CREATE_EXP_DEAL(ARec_Exp IN XTR_EXPOSURE_TRANSACTIONS%rowtype) IS
1331:
1332: cursor FIND_USER (p_fnd_user in number) is

Line 1330: procedure CREATE_EXP_DEAL(ARec_Exp IN XTR_EXPOSURE_TRANSACTIONS%rowtype) IS

1326:
1327: /*------------------------------------------------------------------------
1328: This procedure is the table handler for XTR_EXPOSURE_TRANSACTIONS
1329: ------------------------------------------------------------------------*/
1330: procedure CREATE_EXP_DEAL(ARec_Exp IN XTR_EXPOSURE_TRANSACTIONS%rowtype) IS
1331:
1332: cursor FIND_USER (p_fnd_user in number) is
1333: select dealer_code
1334: from xtr_dealer_codes_v

Line 1362: INSERT INTO xtr_exposure_transactions (

1358: l_dual_user := l_user;
1359: end if;
1360: end if;
1361:
1362: INSERT INTO xtr_exposure_transactions (
1363: ACCOUNT_NO,
1364: ACTION_CODE,
1365: AMOUNT ,
1366: AMOUNT_HCE,

Line 1544: PROCEDURE INS_DEAL_DATE_AMOUNTS (ARec_Exp IN XTR_EXPOSURE_TRANSACTIONS%rowtype)

1540:
1541: /*------------------------------------------------------------------------
1542: This procedure is the table handler for XTR_DEAL_DATE_AMOUNTS_V
1543: ------------------------------------------------------------------------*/
1544: PROCEDURE INS_DEAL_DATE_AMOUNTS (ARec_Exp IN XTR_EXPOSURE_TRANSACTIONS%rowtype)
1545: IS
1546:
1547: -- bug 1849281 proper dealer id should be inserted into dda
1548: cursor DEALER is

Line 1778: -- into the XTR_EXPOSURE_TRANSACTIONS table

1774:
1775: if (validation_error <> TRUE) then
1776: --
1777: -- Copy to the temp. storage that will be used for inserting
1778: -- into the XTR_EXPOSURE_TRANSACTIONS table
1779: --
1780: COPY_FROM_INTERFACE_TO_EXP(ARec_Interface, validation_error);
1781: IF xtr_risk_debug_pkg.g_Debug THEN
1782: xtr_risk_debug_pkg.dlog('TRANSFER_EXP_DEALS: ' || 'validation_error from COPY',validation_error);

Line 1800: xtr_risk_debug_pkg.dlog('TRANSFER_EXP_DEALS: ' || 'After inserting to XTR_EXPOSURE_TRANSACTIONS');

1796: --Insert deal
1797: --
1798: CREATE_EXP_DEAL(g_main_rec);
1799: IF xtr_risk_debug_pkg.g_Debug THEN
1800: xtr_risk_debug_pkg.dlog('TRANSFER_EXP_DEALS: ' || 'After inserting to XTR_EXPOSURE_TRANSACTIONS');
1801: END IF;
1802: --
1803: --Also insert to XTR_DEAL_DATE_AMOUNTS_V
1804: --

Line 1856: ARec IN OUT NOCOPY XTR_EXPOSURE_TRANSACTIONS%rowtype,

1852: , TAX_CP_G (if called from TAX API with interest action Compounded
1853: gross)
1854: ------------------------------------------------------------------------*/
1855: procedure TRANSFER_EXP_DEALS(
1856: ARec IN OUT NOCOPY XTR_EXPOSURE_TRANSACTIONS%rowtype,
1857: p_source IN VARCHAR2,
1858: user_error OUT NOCOPY BOOLEAN,
1859: mandatory_error OUT NOCOPY BOOLEAN,
1860: validation_error OUT NOCOPY BOOLEAN,

Line 1908: xtr_risk_debug_pkg.dlog('TRANSFER_EXP_DEALS: ' || 'After inserting to XTR_EXPOSURE_TRANSACTIONS');

1904: --Insert deal
1905: --
1906: CREATE_EXP_DEAL(g_main_rec);
1907: IF xtr_risk_debug_pkg.g_Debug THEN
1908: xtr_risk_debug_pkg.dlog('TRANSFER_EXP_DEALS: ' || 'After inserting to XTR_EXPOSURE_TRANSACTIONS');
1909: END IF;
1910: --
1911: --Also insert to XTR_DEAL_DATE_AMOUNTS_V
1912: --