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.AS_PERIOD_RATES_REFRESH dependencies on AS_PERIOD_RATES

Line 1: PACKAGE BODY AS_PERIOD_RATES_REFRESH as

1: PACKAGE BODY AS_PERIOD_RATES_REFRESH as
2: /* $Header: asxrateb.pls 120.2 2005/06/14 01:32:14 appldev $ */
3:
4: --
5: -- HISTORY

Line 8: -- AS_PERIOD_RATES

4: --
5: -- HISTORY
6: -- 03/20/2001 SOLIN Created
7: -- 05/20/2001 SOLIN Change table name from AS_RATES to
8: -- AS_PERIOD_RATES
9: -- Decide to use N*N currencies
10: --
11: -- FLOW
12: --

Line 15: -- Conversion Rate(AS_PERIOD_RATES)"

11: -- FLOW
12: --
13: -- NOTES
14: -- The main package for the concurrent program "Refresh Mult-Currency
15: -- Conversion Rate(AS_PERIOD_RATES)"
16: --
17:
18:
19: /*-------------------------------------------------------------------------*

Line 24: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_PERIOD_RATES_REFRESH';

20: |
21: | PRIVATE CONSTANTS
22: |
23: *-------------------------------------------------------------------------*/
24: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_PERIOD_RATES_REFRESH';
25: G_FILE_NAME CONSTANT VARCHAR2(12):= 'asxrateb.pls';
26:
27:
28: /*-------------------------------------------------------------------------*

Line 68: | Refresh_AS_PERIOD_RATES

64:
65:
66: /*-------------------------------------------------------------------------*
67: | PUBLIC ROUTINE
68: | Refresh_AS_PERIOD_RATES
69: |
70: | PURPOSE
71: | The main program to refresh AS_PERIOD_RATES table.
72: | Concurrent program to populate multi-currency conversion rate.

Line 71: | The main program to refresh AS_PERIOD_RATES table.

Line 78: | 05/20/2001 SOLIN Changed table name from AS_RATES to AS_PERIOD_RATES

Line 83: PROCEDURE Refresh_AS_PERIOD_RATES(

79: | 10/04/2001 SOLIN Add exception handler in case reporting currency
80: | is not defined in fnd_currencies.
81: *-------------------------------------------------------------------------*/
82:
83: PROCEDURE Refresh_AS_PERIOD_RATES(
84: ERRBUF OUT NOCOPY VARCHAR2,
85: RETCODE OUT NOCOPY VARCHAR2,
86: p_debug_mode IN VARCHAR2,
87: p_trace_mode IN VARCHAR2)

Line 169: l_module CONSTANT VARCHAR2(255) := 'as.plsql.prate.Refresh_AS_PERIOD_RATES';

165: l_fnd_status VARCHAR2(2);
166: l_industry VARCHAR2(2);
167: l_oracle_schema VARCHAR2(32) := 'OSM';
168: l_schema_return BOOLEAN;
169: l_module CONSTANT VARCHAR2(255) := 'as.plsql.prate.Refresh_AS_PERIOD_RATES';
170: BEGIN
171: l_schema_return := FND_INSTALLATION.get_app_info('AS', l_fnd_status, l_industry, l_oracle_schema);
172:
173: g_debug_flag := p_debug_mode;

Line 179: -- truncate AS_PERIOD_RATES

175: AS_DEBUG(l_module, '*** ASXRATES starts ***');
176:
177: fetch_profile_values;
178:
179: -- truncate AS_PERIOD_RATES
180: ddl_curs := dbms_sql.open_cursor;
181: dbms_sql.parse(ddl_curs,'TRUNCATE TABLE ' || l_oracle_schema || '.AS_PERIOD_RATES drop storage',
182: dbms_sql.native);
183: dbms_sql.close_cursor(ddl_curs);

Line 181: dbms_sql.parse(ddl_curs,'TRUNCATE TABLE ' || l_oracle_schema || '.AS_PERIOD_RATES drop storage',

177: fetch_profile_values;
178:
179: -- truncate AS_PERIOD_RATES
180: ddl_curs := dbms_sql.open_cursor;
181: dbms_sql.parse(ddl_curs,'TRUNCATE TABLE ' || l_oracle_schema || '.AS_PERIOD_RATES drop storage',
182: dbms_sql.native);
183: dbms_sql.close_cursor(ddl_curs);
184:
185: -- For period rate

Line 242: SELECT AS_PERIOD_RATES_S.NEXTVAL INTO l_period_rate_id FROM DUAL;

238: WHERE currency_code = l_to_currency;
239:
240: -- AS_DEBUG('precision:' || l_precision || ' mau:' || l_mau);
241:
242: SELECT AS_PERIOD_RATES_S.NEXTVAL INTO l_period_rate_id FROM DUAL;
243:
244: -- Insertion for daily rate
245: INSERT INTO AS_PERIOD_RATES(
246: PERIOD_RATE_ID, FROM_CURRENCY, TO_CURRENCY,

Line 245: INSERT INTO AS_PERIOD_RATES(

241:
242: SELECT AS_PERIOD_RATES_S.NEXTVAL INTO l_period_rate_id FROM DUAL;
243:
244: -- Insertion for daily rate
245: INSERT INTO AS_PERIOD_RATES(
246: PERIOD_RATE_ID, FROM_CURRENCY, TO_CURRENCY,
247: CONVERSION_TYPE, CONVERSION_DATE, CONVERSION_RATE,
248: NUMERATOR_RATE, DENOMINATOR_RATE, PRECISION,
249: MINIMUM_ACCOUNTABLE_UNIT,

Line 279: DBMS_STATS.GATHER_TABLE_STATS ('OSM','AS_PERIOD_RATES', degree=>4, estimate_percent => 99, granularity => 'GLOBAL', cascade=>TRUE);

275: ELSE -- 'E'
276: CLOSE c_get_dp_currency_e;
277: END IF;
278:
279: DBMS_STATS.GATHER_TABLE_STATS ('OSM','AS_PERIOD_RATES', degree=>4, estimate_percent => 99, granularity => 'GLOBAL', cascade=>TRUE);
280: COMMIT;
281: EXCEPTION
282: WHEN others THEN
283: AS_DEBUG(l_module, 'Exception: others in Refresh_AS_PERIOD_RATES');

Line 283: AS_DEBUG(l_module, 'Exception: others in Refresh_AS_PERIOD_RATES');

279: DBMS_STATS.GATHER_TABLE_STATS ('OSM','AS_PERIOD_RATES', degree=>4, estimate_percent => 99, granularity => 'GLOBAL', cascade=>TRUE);
280: COMMIT;
281: EXCEPTION
282: WHEN others THEN
283: AS_DEBUG(l_module, 'Exception: others in Refresh_AS_PERIOD_RATES');
284: AS_DEBUG(l_module, 'SQLCODE ' || to_char(SQLCODE) ||
285: ' SQLERRM ' || substr(SQLERRM, 1, 100));
286:
287: errbuf := SQLERRM;

Line 290: END Refresh_AS_PERIOD_RATES;

286:
287: errbuf := SQLERRM;
288: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
289: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
290: END Refresh_AS_PERIOD_RATES;
291:
292: /*-------------------------------------------------------------------------*
293: |
294: | PRIVATE ROUTINES

Line 413: END AS_PERIOD_RATES_REFRESH;

409: 'SQLCODE ' || to_char(SQLCODE) ||
410: ' SQLERRM ' || substr(SQLERRM, 1, 100));
411: END As_Debug;
412:
413: END AS_PERIOD_RATES_REFRESH;
414: