536: */
537:
538: PROCEDURE convert_to_functional_currency
539: (
540: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
541: p_to_currency IN fnd_currencies.currency_code%TYPE,
542: p_transaction_date IN DATE,
543: p_amount IN NUMBER,
544: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
540: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
541: p_to_currency IN fnd_currencies.currency_code%TYPE,
542: p_transaction_date IN DATE,
543: p_amount IN NUMBER,
544: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
545: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
546: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
547: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
548: x_converted_amount OUT NOCOPY NUMBER
556: */
557:
558: PROCEDURE convert_to_functional_currency
559: (
560: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
561: p_to_currency IN fnd_currencies.currency_code%TYPE,
562: p_transaction_date IN DATE,
563: p_amount IN NUMBER,
564: x_return_status OUT NOCOPY VARCHAR2,
561: p_to_currency IN fnd_currencies.currency_code%TYPE,
562: p_transaction_date IN DATE,
563: p_amount IN NUMBER,
564: x_return_status OUT NOCOPY VARCHAR2,
565: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
566: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
567: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
568: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
569: x_converted_amount OUT NOCOPY NUMBER
577: */
578:
579: PROCEDURE convert_to_contract_currency
580: (
581: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
582: p_from_currency IN fnd_currencies.currency_code%TYPE,
583: p_transaction_date IN DATE,
584: p_amount IN NUMBER,
585: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
581: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
582: p_from_currency IN fnd_currencies.currency_code%TYPE,
583: p_transaction_date IN DATE,
584: p_amount IN NUMBER,
585: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
586: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
587: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
588: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
589: x_converted_amount OUT NOCOPY NUMBER
597: */
598:
599: PROCEDURE convert_to_contract_currency
600: (
601: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
602: p_from_currency IN fnd_currencies.currency_code%TYPE,
603: p_transaction_date IN DATE,
604: p_amount IN NUMBER,
605: x_return_status OUT NOCOPY VARCHAR2,
602: p_from_currency IN fnd_currencies.currency_code%TYPE,
603: p_transaction_date IN DATE,
604: p_amount IN NUMBER,
605: x_return_status OUT NOCOPY VARCHAR2,
606: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
607: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
608: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
609: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
610: x_converted_amount OUT NOCOPY NUMBER