DBA Data[Home] [Help]

APPS.OKL_ACCOUNTING_UTIL dependencies on OKC_K_HEADERS_B

Line 2083: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,

2079: ======================================================================================*/
2080:
2081: PROCEDURE convert_to_functional_currency
2082: (
2083: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
2084: p_to_currency IN fnd_currencies.currency_code%TYPE,
2085: p_transaction_date IN DATE,
2086: p_amount IN NUMBER,
2087: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,

Line 2087: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,

2083: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
2084: p_to_currency IN fnd_currencies.currency_code%TYPE,
2085: p_transaction_date IN DATE,
2086: p_amount IN NUMBER,
2087: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2088: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
2089: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
2090: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
2091: x_converted_amount OUT NOCOPY NUMBER

Line 2193: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,

2189: ======================================================================================*/
2190:
2191: PROCEDURE convert_to_functional_currency
2192: (
2193: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
2194: p_to_currency IN fnd_currencies.currency_code%TYPE,
2195: p_transaction_date IN DATE,
2196: p_amount IN NUMBER,
2197: x_return_status OUT NOCOPY VARCHAR2,

Line 2198: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,

2194: p_to_currency IN fnd_currencies.currency_code%TYPE,
2195: p_transaction_date IN DATE,
2196: p_amount IN NUMBER,
2197: x_return_status OUT NOCOPY VARCHAR2,
2198: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2199: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
2200: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
2201: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
2202: x_converted_amount OUT NOCOPY NUMBER

Line 2348: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,

2344:
2345:
2346: PROCEDURE convert_to_contract_currency
2347: (
2348: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
2349: p_from_currency IN fnd_currencies.currency_code%TYPE,
2350: p_transaction_date IN DATE,
2351: p_amount IN NUMBER,
2352: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,

Line 2352: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,

2348: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
2349: p_from_currency IN fnd_currencies.currency_code%TYPE,
2350: p_transaction_date IN DATE,
2351: p_amount IN NUMBER,
2352: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2353: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
2354: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
2355: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
2356: x_converted_amount OUT NOCOPY NUMBER

Line 2467: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,

2463:
2464:
2465: PROCEDURE convert_to_contract_currency
2466: (
2467: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
2468: p_from_currency IN fnd_currencies.currency_code%TYPE,
2469: p_transaction_date IN DATE,
2470: p_amount IN NUMBER,
2471: x_return_status OUT NOCOPY VARCHAR2,

Line 2472: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,

2468: p_from_currency IN fnd_currencies.currency_code%TYPE,
2469: p_transaction_date IN DATE,
2470: p_amount IN NUMBER,
2471: x_return_status OUT NOCOPY VARCHAR2,
2472: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2473: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,
2474: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,
2475: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,
2476: x_converted_amount OUT NOCOPY NUMBER

Line 3246: FROM okc_k_headers_b a, okl_k_headers b

3242: x_rep_deal_type OUT NOCOPY VARCHAR2 ) IS
3243: -- Get the financial product of the contract
3244: CURSOR l_get_fin_product(cp_khr_id IN NUMBER) IS
3245: SELECT a.start_date, a.contract_number, b.pdt_id
3246: FROM okc_k_headers_b a, okl_k_headers b
3247: WHERE a.id = b.id
3248: AND a.id = cp_khr_id;
3249: SUBTYPE pdtv_rec_type IS OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
3250: SUBTYPE pdt_parameters_rec_type IS OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;