DBA Data[Home] [Help]

APPS.POA_DBI_RCV_TXN_F_C dependencies on POA_CURRENCY_PKG

Line 88: if(poa_currency_pkg.display_secondary_currency_yn)

84: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
85: l_srate_type := bis_common_parameters.get_secondary_rate_type;
86: l_batch_size := bis_common_parameters.get_batch_size(10);
87: l_rate_type := bis_common_parameters.get_rate_type;
88: if(poa_currency_pkg.display_secondary_currency_yn)
89: then
90: l_sec_cur_yn := 1;
91: else
92: l_sec_cur_yn := 0;

Line 260: poa_currency_pkg.get_dbi_global_rate(

256: select
257: txn_cur_code,
258: func_cur_code,
259: rate_date,
260: poa_currency_pkg.get_dbi_global_rate(
261: l_rate_type,
262: func_cur_code,
263: rate_date,
264: txn_cur_code

Line 268: else poa_currency_pkg.get_dbi_sglobal_rate(

264: txn_cur_code
265: ) global_cur_conv_rate,
266: ( case when l_sec_cur_yn = 0
267: then null
268: else poa_currency_pkg.get_dbi_sglobal_rate(
269: l_srate_type,
270: func_cur_code,
271: rate_date,
272: txn_cur_code

Line 303: IF (poa_currency_pkg.g_missing_cur) THEN

299: || '. Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
300:
301: /* missing currency handling */
302:
303: IF (poa_currency_pkg.g_missing_cur) THEN
304: poa_currency_pkg.g_missing_cur := false;
305: errbuf := 'There are missing currencies\n';
306: RAISE_APPLICATION_ERROR (-20000, 'Error in INC table collection: ' || errbuf);
307: END IF;

Line 304: poa_currency_pkg.g_missing_cur := false;

300:
301: /* missing currency handling */
302:
303: IF (poa_currency_pkg.g_missing_cur) THEN
304: poa_currency_pkg.g_missing_cur := false;
305: errbuf := 'There are missing currencies\n';
306: RAISE_APPLICATION_ERROR (-20000, 'Error in INC table collection: ' || errbuf);
307: END IF;
308: