APPS.ARPCURR dependencies on GL_CURRENCY_API

Line 353: | If not found above then get it from gl_currency_api.get_rate |

349: | If not found in cache, search the linear table (where |
350: | conversion_rate's |
351: | will go if collision on the hash table occurs). |
352: | |
353: | If not found above then get it from gl_currency_api.get_rate |
354: +----------------------------------------------------------------*/
355:
356: IF PG_DEBUG in ('Y', 'C') THEN
357: arp_standard.debug('arpcurr.getrate');

Line 397: l_user_conversion_rate := gl_currency_api.get_rate(p_from_curr_code,p_to_curr_code,p_conversion_date,p_conversion_type);

393: END IF;
394: IF found THEN
395: RETURN(l_user_conversion_rate);
396: ELSE
397: l_user_conversion_rate := gl_currency_api.get_rate(p_from_curr_code,p_to_curr_code,p_conversion_date,p_conversion_type);
398:
399: IF PG_DEBUG in ('Y', 'C') THEN
400: arp_standard.debug('GetRate: ' || 'after call to gl_currency_api');
401: END IF;

Line 400: arp_standard.debug('GetRate: ' || 'after call to gl_currency_api');

396: ELSE
397: l_user_conversion_rate := gl_currency_api.get_rate(p_from_curr_code,p_to_curr_code,p_conversion_date,p_conversion_type);
398:
399: IF PG_DEBUG in ('Y', 'C') THEN
400: arp_standard.debug('GetRate: ' || 'after call to gl_currency_api');
401: END IF;
402: IF pg_getrate_hash_seg_cache.exists(l_hash_value) then
403: tab_size := tab_size + 1;
404: pg_getrate_line_id_cache(tab_size) := l_user_conversion_rate;

Line 417: WHEN GL_CURRENCY_API.NO_RATE THEN

413: END IF;
414: END IF;
415:
416: EXCEPTION
417: WHEN GL_CURRENCY_API.NO_RATE THEN
418: return -1;
419: WHEN OTHERS THEN
420: RAISE ;
421: END GetRate;

Line 433: l_user_conversion_rate := gl_currency_api.get_rate(p_set_of_books_id,p_from_curr_code,p_conversion_date,p_conversion_type);

429: IF (p_from_curr_code IS NULL)
430: THEN
431: return 'X';
432: END IF;
433: l_user_conversion_rate := gl_currency_api.get_rate(p_set_of_books_id,p_from_curr_code,p_conversion_date,p_conversion_type);
434:
435: IF (l_user_conversion_rate IS NOT NULL)
436: THEN
437: return 'Y';

Line 440: WHEN GL_CURRENCY_API.NO_RATE THEN

436: THEN
437: return 'Y';
438: END IF;
439: EXCEPTION
440: WHEN GL_CURRENCY_API.NO_RATE THEN
441: return 'N';
442: WHEN OTHERS THEN
443: RAISE ;
444: END RateExists;

Line 464: l_rec_relation := gl_currency_api.is_fixed_rate(p_rec_curr_code,p_funct_curr_code,p_rec_conversion_date);

460:
461:
462: IF (p_trx_curr_code IS NOT NULL) THEN
463:
464: l_rec_relation := gl_currency_api.is_fixed_rate(p_rec_curr_code,p_funct_curr_code,p_rec_conversion_date);
465: l_trx_relation := gl_currency_api.is_fixed_rate(p_trx_curr_code,p_funct_curr_code,p_trx_conversion_date);
466:
467: IF (l_rec_relation = 'Y' and l_trx_relation = 'Y') Then
468: l_relation := 'Y';

Line 465: l_trx_relation := gl_currency_api.is_fixed_rate(p_trx_curr_code,p_funct_curr_code,p_trx_conversion_date);

461:
462: IF (p_trx_curr_code IS NOT NULL) THEN
463:
464: l_rec_relation := gl_currency_api.is_fixed_rate(p_rec_curr_code,p_funct_curr_code,p_rec_conversion_date);
465: l_trx_relation := gl_currency_api.is_fixed_rate(p_trx_curr_code,p_funct_curr_code,p_trx_conversion_date);
466:
467: IF (l_rec_relation = 'Y' and l_trx_relation = 'Y') Then
468: l_relation := 'Y';
469: Else

Line 475: l_relation := gl_currency_api.is_fixed_rate(p_rec_curr_code,p_funct_curr_code,p_rec_conversion_date);

471: End if;
472:
473: ELSE
474:
475: l_relation := gl_currency_api.is_fixed_rate(p_rec_curr_code,p_funct_curr_code,p_rec_conversion_date);
476:
477: END IF;
478:
479: return(l_relation);

Line 482: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN

478:
479: return(l_relation);
480:
481: EXCEPTION
482: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
483: RETURN 'N';
484: WHEN OTHERS THEN
485: RAISE;
486: