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_MARKET_DATA_P dependencies on XTR_MARKET_DATA_P

Line 1: PACKAGE BODY XTR_MARKET_DATA_P AS

1: PACKAGE BODY XTR_MARKET_DATA_P AS
2: /* $Header: xtrmdcsb.pls 120.6 2007/11/13 10:21:27 kbabu ship $ */
3:
4: --PL/SQL wrapper for Cubic Spline Interpolation
5: FUNCTION cubic_spline_interpolation (v_X XTR_MD_NUM_TABLE, v_Y XTR_MD_NUM_TABLE,

Line 348: xtr_risk_debug_pkg.dpush('XTR_MARKET_DATA_P.GET_MD_FROM_CURVE');

344:
345: BEGIN
346: --call the debug package
347: IF xtr_risk_debug_pkg.g_Debug THEN
348: xtr_risk_debug_pkg.dpush('XTR_MARKET_DATA_P.GET_MD_FROM_CURVE');
349: xtr_risk_debug_pkg.dlog('GET_MD_FROM_CURVE: ' || 'p_curve_code',p_in_rec.p_curve_code);
350: xtr_risk_debug_pkg.dlog('GET_MD_FROM_CURVE: ' || 'p_source',p_in_rec.p_source);
351: xtr_risk_debug_pkg.dlog('GET_MD_FROM_CURVE: ' || 'p_indicator',p_in_rec.p_indicator);
352: xtr_risk_debug_pkg.dlog('GET_MD_FROM_CURVE: ' || 'p_spot_date',p_in_rec.p_spot_date);

Line 364: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_CURVE');

360: --check whether spot date and future date are valid
361: IF (p_in_rec.p_future_date < p_in_rec.p_spot_date) THEN
362: IF xtr_risk_debug_pkg.g_Debug THEN
363: xtr_risk_debug_pkg.dlog('GET_MD_FROM_CURVE: ' || 'p_future_date cannot be earlier than p_spot_date.');
364: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_CURVE');
365: END IF;
366: RAISE_APPLICATION_ERROR
367: (-20001,'p_future_date cannot be earlier than p_spot_date.');
368: END IF;

Line 700: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_CURVE');

696:
697: ELSE
698: IF xtr_risk_debug_pkg.g_Debug THEN
699: xtr_risk_debug_pkg.dlog('GET_MD_FROM_CURVE: ' || 'The p_source values can only be ''C'' or ''R''.');
700: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_CURVE');
701: END IF;
702: RAISE_APPLICATION_ERROR
703: (-20001,'The p_source values can only be ''C'' or ''R''.');
704: END IF;

Line 710: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_CURVE');

706: --if no data retrieved from the table raise exception
707: IF (v_count = 0 and NOT v_found) THEN
708: IF xtr_risk_debug_pkg.g_Debug THEN
709: xtr_risk_debug_pkg.dlog('GET_MD_FROM_CURVE: ' || 'v_count = 0 and v_found = false');
710: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_CURVE');
711: END IF;
712: RAISE e_mdcs_no_data_found;
713: END IF;
714: --if v_xval is outside the range, only linear int. is needed

Line 1022: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_CURVE');

1018:
1019: --close debug and print the result
1020: IF xtr_risk_debug_pkg.g_Debug THEN
1021: xtr_risk_debug_pkg.dlog('GET_MD_FROM_CURVE: ' || 'p_out_rec.p_md_out', p_out_rec.p_md_out);
1022: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_CURVE');
1023: END IF;
1024:
1025: END GET_MD_FROM_CURVE;
1026:

Line 1170: xtr_risk_debug_pkg.dpush('XTR_MARKET_DATA_P.GET_MD_FROM_SET');

1166:
1167: BEGIN
1168: --start debug and print some initial variable values
1169: IF xtr_risk_debug_pkg.g_Debug THEN
1170: xtr_risk_debug_pkg.dpush('XTR_MARKET_DATA_P.GET_MD_FROM_SET');
1171: xtr_risk_debug_pkg.dlog('GET_MD_FROM_SET: ' || 'p_md_set_code',p_in_rec.p_md_set_code);
1172: xtr_risk_debug_pkg.dlog('GET_MD_FROM_SET: ' || 'p_source',p_in_rec.p_source);
1173: xtr_risk_debug_pkg.dlog('GET_MD_FROM_SET: ' || 'p_indicator',p_in_rec.p_indicator);
1174: xtr_risk_debug_pkg.dlog('GET_MD_FROM_SET: ' || 'p_spot_date',p_in_rec.p_spot_date);

Line 1202: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_SET');

1198: --check if at least one curve code is retrieved
1199: IF (v_in_rec.p_curve_code IS NULL) THEN
1200: IF xtr_risk_debug_pkg.g_Debug THEN
1201: xtr_risk_debug_pkg.dlog('GET_MD_FROM_SET: ' || 'For Yield/Disc/IRVol: no curve found');
1202: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_SET');
1203: END IF;
1204: RAISE e_mdcs_no_curve_found;
1205: END IF;
1206:

Line 1245: xtr_risk_debug_pkg.dpop('GET_MD_FROM_SET: ' || 'XTR_MARKET_DATA_P.GET_MD_FROM_CURVE');

1241: --check if at least one curve code is retrieved
1242: IF (v_in_rec.p_curve_code IS NULL) THEN
1243: IF xtr_risk_debug_pkg.g_Debug THEN
1244: xtr_risk_debug_pkg.dlog('GET_MD_FROM_SET: ' || 'For FXVol: no curve found');
1245: xtr_risk_debug_pkg.dpop('GET_MD_FROM_SET: ' || 'XTR_MARKET_DATA_P.GET_MD_FROM_CURVE');
1246: END IF;
1247: RAISE e_mdcs_no_curve_found;
1248: END IF;
1249:

Line 1302: xtr_risk_debug_pkg.dpop('GET_MD_FROM_SET: ' || 'XTR_MARKET_DATA_P.GET_MD_FROM_CURVE');

1298: END IF;
1299: ELSE
1300: IF xtr_risk_debug_pkg.g_Debug THEN
1301: xtr_risk_debug_pkg.dlog('GET_MD_FROM_SET: ' || 'For FX Spot Rates non-USD: The p_source values can only be ''C'' or ''R''.');
1302: xtr_risk_debug_pkg.dpop('GET_MD_FROM_SET: ' || 'XTR_MARKET_DATA_P.GET_MD_FROM_CURVE');
1303: END IF;
1304: RAISE_APPLICATION_ERROR
1305: (-20001,'The p_source values can only be ''C'' or ''R''.');
1306: END IF;

Line 1362: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_SET');

1358: --check whether there is any spot rate retrieved
1359: IF (v_count = 0) THEN
1360: IF xtr_risk_debug_pkg.g_Debug THEN
1361: xtr_risk_debug_pkg.dlog('GET_MD_FROM_SET: ' || 'For FX Spot Rates non-USD: no data found');
1362: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_SET');
1363: END IF;
1364: RAISE e_mdcs_no_data_found;
1365: END IF;
1366: */

Line 1385: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_SET');

1381: END IF;
1382: ELSE
1383: IF xtr_risk_debug_pkg.g_Debug THEN
1384: xtr_risk_debug_pkg.dlog('GET_MD_FROM_SET: ' || 'For FX Spot Rates USD: the p_source values can only be ''C'' or ''R''.');
1385: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_SET');
1386: END IF;
1387: RAISE_APPLICATION_ERROR
1388: (-20001,'The p_source values can only be ''C'' or ''R''.');
1389: END IF;

Line 1445: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_SET');

1441: --check whether there is any spot rate retrieved
1442: IF (v_count = 0) THEN
1443: IF xtr_risk_debug_pkg.g_Debug THEN
1444: xtr_risk_debug_pkg.dlog('GET_MD_FROM_SET: ' || 'For FX Spot Rates USD: no data found');
1445: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_SET');
1446: END IF;
1447: RAISE e_mdcs_no_data_found;
1448: END IF;
1449: */

Line 1495: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_SET');

1491: --check whether there is any spot rate retrieved
1492: IF (p_out_rec.p_md_out IS NULL) THEN
1493: IF xtr_risk_debug_pkg.g_Debug THEN
1494: xtr_risk_debug_pkg.dlog('GET_MD_FROM_SET: ' || 'For Bond: no data found');
1495: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_SET');
1496: END IF;
1497: RAISE e_mdcs_no_data_found;
1498: END IF;
1499:

Line 1545: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_SET');

1541: --check whether there is any spot rate retrieved
1542: IF (p_out_rec.p_md_out IS NULL) THEN
1543: IF xtr_risk_debug_pkg.g_Debug THEN
1544: xtr_risk_debug_pkg.dlog('GET_MD_FROM_SET: ' || 'For Stock: no data found');
1545: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_SET');
1546: END IF;
1547: RAISE e_mdcs_no_data_found;
1548: END IF;
1549:

Line 1553: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_SET');

1549:
1550: ELSE
1551: IF xtr_risk_debug_pkg.g_Debug THEN
1552: xtr_risk_debug_pkg.dlog('GET_MD_FROM_SET: ' || 'p_indicator is invalid');
1553: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_SET');
1554: END IF;
1555: RAISE_APPLICATION_ERROR
1556: (-20001,'Unknown p_indicator values.');
1557: END IF;

Line 1562: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_SET');

1558:
1559: --stop debug and print the result
1560: IF xtr_risk_debug_pkg.g_Debug THEN
1561: xtr_risk_debug_pkg.dlog('GET_MD_FROM_SET: ' || 'p_out_rec.p_md_out', p_out_rec.p_md_out);
1562: xtr_risk_debug_pkg.dpop('XTR_MARKET_DATA_P.GET_MD_FROM_SET');
1563: END IF;
1564: END GET_MD_FROM_SET;
1565:
1566: