DBA Data[Home] [Help]

APPS.OKL_PAYMENT_SPLIT_PVT dependencies on FND_CURRENCIES

Line 130: x_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE

126: ------------------------------------------------------------------------------
127: PROCEDURE get_currency_precision (
128: x_return_status OUT NOCOPY VARCHAR2,
129: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
130: x_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE
131: ) IS
132: CURSOR chr_csr (p_chr_id NUMBER) IS
133: SELECT currency_code
134: FROM okc_k_headers_v

Line 139: FROM fnd_currencies

135: WHERE id = p_chr_id;
136:
137: CURSOR curr_csr (p_curr_code VARCHAR2) IS
138: SELECT precision
139: FROM fnd_currencies
140: WHERE currency_code = p_curr_code;
141:
142: curr_failed EXCEPTION;
143: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;

Line 143: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;

139: FROM fnd_currencies
140: WHERE currency_code = p_curr_code;
141:
142: curr_failed EXCEPTION;
143: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
144: l_precision FND_CURRENCIES.PRECISION%TYPE;
145:
146: BEGIN
147:

Line 144: l_precision FND_CURRENCIES.PRECISION%TYPE;

140: WHERE currency_code = p_curr_code;
141:
142: curr_failed EXCEPTION;
143: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
144: l_precision FND_CURRENCIES.PRECISION%TYPE;
145:
146: BEGIN
147:
148: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 200: p_precision IN FND_CURRENCIES.PRECISION%TYPE,

196: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
197: p_cle_id IN NUMBER,
198: p_fin_line_capital_amount IN NUMBER,
199: p_tot_capital_amount IN NUMBER,
200: p_precision IN FND_CURRENCIES.PRECISION%TYPE,
201: p_payment_type IN VARCHAR2,
202: p_amount IN NUMBER,
203: p_period IN NUMBER,
204: p_start_date IN DATE,

Line 475: l_precision FND_CURRENCIES.PRECISION%TYPE;

471:
472: l_api_name VARCHAR2(35) := 'generate_line_payments';
473: l_proc_name VARCHAR2(35) := 'generate_line_payments';
474: l_api_version CONSTANT NUMBER := 1;
475: l_precision FND_CURRENCIES.PRECISION%TYPE;
476:
477: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
478: SELECT okl.*
479: FROM okl_k_lines_full_v okl,