DBA Data[Home] [Help]

APPS.OKL_ACCOUNTING_UTIL dependencies on OKL_K_HEADERS

Line 2088: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%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
2092: )

Line 2089: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%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
2092: )
2093: AS

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

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
2092: )
2093: AS
2094:

Line 2101: FROM OKL_K_HEADERS_FULL_V

2097: SELECT CURRENCY_CODE,
2098: CURRENCY_CONVERSION_TYPE,
2099: CURRENCY_CONVERSION_RATE,
2100: CURRENCY_CONVERSION_DATE
2101: FROM OKL_K_HEADERS_FULL_V
2102: WHERE ID = p_khr_id;
2103:
2104: l_func_currency VARCHAR2(15);
2105: l_contract_currency VARCHAR2(15);

Line 2199: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%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
2203: )

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

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
2203: )
2204: AS

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

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
2203: )
2204: AS
2205:

Line 2212: FROM OKL_K_HEADERS_FULL_V

2208: SELECT CURRENCY_CODE,
2209: CURRENCY_CONVERSION_TYPE,
2210: CURRENCY_CONVERSION_RATE,
2211: CURRENCY_CONVERSION_DATE
2212: FROM OKL_K_HEADERS_FULL_V
2213: WHERE ID = p_khr_id;
2214:
2215: l_func_currency VARCHAR2(15);
2216: l_contract_currency VARCHAR2(15);

Line 2353: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%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
2357: )

Line 2354: x_currency_conversion_rate OUT NOCOPY OKL_K_HEADERS.currency_conversion_rate%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
2357: )
2358: AS

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

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
2357: )
2358: AS
2359:

Line 2366: FROM OKL_K_HEADERS_FULL_V

2362: SELECT CURRENCY_CODE,
2363: CURRENCY_CONVERSION_TYPE,
2364: CURRENCY_CONVERSION_RATE,
2365: CURRENCY_CONVERSION_DATE
2366: FROM OKL_K_HEADERS_FULL_V
2367: WHERE ID = p_khr_id;
2368:
2369: l_func_currency VARCHAR2(15);
2370: l_contract_currency VARCHAR2(15);

Line 2473: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%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
2477: )

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

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
2477: )
2478: AS

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

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
2477: )
2478: AS
2479:

Line 2486: FROM OKL_K_HEADERS_FULL_V

2482: SELECT CURRENCY_CODE,
2483: CURRENCY_CONVERSION_TYPE,
2484: CURRENCY_CONVERSION_RATE,
2485: CURRENCY_CONVERSION_DATE
2486: FROM OKL_K_HEADERS_FULL_V
2487: WHERE ID = p_khr_id;
2488:
2489: l_func_currency VARCHAR2(15);
2490: l_contract_currency VARCHAR2(15);

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;