2082: p_to_currency IN fnd_currencies.currency_code%TYPE,
2083: p_transaction_date IN DATE,
2084: p_amount IN NUMBER,
2085: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2086: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
2087: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
2088: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
2089: x_converted_amount OUT NOCOPY NUMBER
2090: )
2083: p_transaction_date IN DATE,
2084: p_amount IN NUMBER,
2085: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2086: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
2087: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
2088: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
2089: x_converted_amount OUT NOCOPY NUMBER
2090: )
2091: AS
2084: p_amount IN NUMBER,
2085: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2086: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
2087: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
2088: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
2089: x_converted_amount OUT NOCOPY NUMBER
2090: )
2091: AS
2092:
2095: SELECT CURRENCY_CODE,
2096: CURRENCY_CONVERSION_TYPE,
2097: CURRENCY_CONVERSION_RATE,
2098: CURRENCY_CONVERSION_DATE
2099: FROM OKL_K_HEADERS_FULL_V
2100: WHERE ID = p_khr_id;
2101:
2102: l_func_currency VARCHAR2(15);
2103: l_contract_currency VARCHAR2(15);
2193: p_transaction_date IN DATE,
2194: p_amount IN NUMBER,
2195: x_return_status OUT NOCOPY VARCHAR2,
2196: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2197: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
2198: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
2199: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
2200: x_converted_amount OUT NOCOPY NUMBER
2201: )
2194: p_amount IN NUMBER,
2195: x_return_status OUT NOCOPY VARCHAR2,
2196: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2197: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
2198: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
2199: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
2200: x_converted_amount OUT NOCOPY NUMBER
2201: )
2202: AS
2195: x_return_status OUT NOCOPY VARCHAR2,
2196: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2197: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
2198: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
2199: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
2200: x_converted_amount OUT NOCOPY NUMBER
2201: )
2202: AS
2203:
2206: SELECT CURRENCY_CODE,
2207: CURRENCY_CONVERSION_TYPE,
2208: CURRENCY_CONVERSION_RATE,
2209: CURRENCY_CONVERSION_DATE
2210: FROM OKL_K_HEADERS_FULL_V
2211: WHERE ID = p_khr_id;
2212:
2213: l_func_currency VARCHAR2(15);
2214: l_contract_currency VARCHAR2(15);
2347: p_from_currency IN fnd_currencies.currency_code%TYPE,
2348: p_transaction_date IN DATE,
2349: p_amount IN NUMBER,
2350: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2351: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
2352: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
2353: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
2354: x_converted_amount OUT NOCOPY NUMBER
2355: )
2348: p_transaction_date IN DATE,
2349: p_amount IN NUMBER,
2350: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2351: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
2352: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
2353: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
2354: x_converted_amount OUT NOCOPY NUMBER
2355: )
2356: AS
2349: p_amount IN NUMBER,
2350: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2351: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
2352: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
2353: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
2354: x_converted_amount OUT NOCOPY NUMBER
2355: )
2356: AS
2357:
2360: SELECT CURRENCY_CODE,
2361: CURRENCY_CONVERSION_TYPE,
2362: CURRENCY_CONVERSION_RATE,
2363: CURRENCY_CONVERSION_DATE
2364: FROM OKL_K_HEADERS_FULL_V
2365: WHERE ID = p_khr_id;
2366:
2367: l_func_currency VARCHAR2(15);
2368: l_contract_currency VARCHAR2(15);
2467: p_transaction_date IN DATE,
2468: p_amount IN NUMBER,
2469: x_return_status OUT NOCOPY VARCHAR2,
2470: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2471: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
2472: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
2473: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
2474: x_converted_amount OUT NOCOPY NUMBER
2475: )
2468: p_amount IN NUMBER,
2469: x_return_status OUT NOCOPY VARCHAR2,
2470: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2471: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
2472: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
2473: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
2474: x_converted_amount OUT NOCOPY NUMBER
2475: )
2476: AS
2469: x_return_status OUT NOCOPY VARCHAR2,
2470: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2471: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
2472: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
2473: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
2474: x_converted_amount OUT NOCOPY NUMBER
2475: )
2476: AS
2477:
2480: SELECT CURRENCY_CODE,
2481: CURRENCY_CONVERSION_TYPE,
2482: CURRENCY_CONVERSION_RATE,
2483: CURRENCY_CONVERSION_DATE
2484: FROM OKL_K_HEADERS_FULL_V
2485: WHERE ID = p_khr_id;
2486:
2487: l_func_currency VARCHAR2(15);
2488: l_contract_currency VARCHAR2(15);