73: l_rate_type := bis_common_parameters.get_rate_type;
74: l_global_cur_code := bis_common_parameters.get_currency_code;
75: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
76: l_srate_type := bis_common_parameters.get_secondary_rate_type;
77: if(poa_currency_pkg.display_secondary_currency_yn)
78: then
79: l_sec_cur_yn := 1;
80: else
81: l_sec_cur_yn := 0;
253: SELECT
254: txn_cur_code,
255: func_cur_code,
256: rate_date,
257: poa_currency_pkg.get_dbi_global_rate(
258: l_rate_type,
259: func_cur_code,
260: rate_date,
261: txn_cur_code
261: txn_cur_code
262: ) global_cur_conv_rate,
263: ( case when l_sec_cur_yn = 0 then null
264: else
265: poa_currency_pkg.get_dbi_sglobal_rate (
266: l_srate_type,
267: func_cur_code,
268: rate_date,
269: txn_cur_code
297:
298:
299: /* missing currency handling */
300:
301: IF (poa_currency_pkg.g_missing_cur) THEN
302: poa_currency_pkg.g_missing_cur := false;
303: errbuf := 'There are missing currencies\n';
304: raise_application_error (-20000, 'Error in INC table collection: ' || errbuf);
305: END IF;
298:
299: /* missing currency handling */
300:
301: IF (poa_currency_pkg.g_missing_cur) THEN
302: poa_currency_pkg.g_missing_cur := false;
303: errbuf := 'There are missing currencies\n';
304: raise_application_error (-20000, 'Error in INC table collection: ' || errbuf);
305: END IF;
306: