DBA Data[Home] [Help]

APPS.OKL_ACCOUNTING_UTIL dependencies on OKL_K_HEADERS

Line 2086: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,

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: )

Line 2087: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%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: )
2091: AS

Line 2088: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,

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:

Line 2099: FROM OKL_K_HEADERS_FULL_V

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);

Line 2197: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,

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: )

Line 2198: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,

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

Line 2199: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,

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:

Line 2210: FROM OKL_K_HEADERS_FULL_V

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);

Line 2351: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,

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: )

Line 2352: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%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: )
2356: AS

Line 2353: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,

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:

Line 2364: FROM OKL_K_HEADERS_FULL_V

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);

Line 2471: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,

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: )

Line 2472: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%TYPE,

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

Line 2473: x_currency_conversion_date OUT NOCOPY OKL_K_HEADERS.currency_conversion_date%TYPE,

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:

Line 2484: FROM OKL_K_HEADERS_FULL_V

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);