APPS.OKL_PAYMENT_SPLIT_PVT dependencies on OKC_K_HEADERS_V

Line 129: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

125: -- Called By:
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

Line 134: FROM okc_k_headers_v

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
135: WHERE id = p_chr_id;
136:
137: CURSOR curr_csr (p_curr_code VARCHAR2) IS
138: SELECT precision

Line 196: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

192: PROCEDURE gen_line_rule(
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
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,

Line 348: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

344: PROCEDURE get_total_capital_amount(
345: x_return_status OUT NOCOPY VARCHAR2,
346: x_msg_count OUT NOCOPY NUMBER,
347: x_msg_data OUT NOCOPY VARCHAR2,
348: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
349: x_tot_capital_amount OUT NOCOPY NUMBER
350: ) IS
351: l_proc_name VARCHAR2(35) := 'GET_TOTAL_CAPITAL_AMOUNT';
352:

Line 354: CURSOR fin_cap_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

350: ) IS
351: l_proc_name VARCHAR2(35) := 'GET_TOTAL_CAPITAL_AMOUNT';
352:
353: -- Total Capital amount from Financial Asset Top line
354: CURSOR fin_cap_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
355: SELECT SUM(NVL(line.capital_amount,0))
356: FROM okl_k_lines_full_v line
357: WHERE line.dnz_chr_id = p_chr_id
358: AND EXISTS ( SELECT 'Y'

Line 371: CURSOR fee_cap_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

367: WHERE okcsts.code = line.sts_code
368: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
369:
370: -- Total Capital amount from FEE Top Line
371: CURSOR fee_cap_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
372: SELECT SUM(NVL(line.capital_amount,0))
373: FROM okl_k_lines_full_v line,
374: okc_line_styles_v style,
375: okc_k_items_v item,

Line 463: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

459: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
460: x_return_status OUT NOCOPY VARCHAR2,
461: x_msg_count OUT NOCOPY NUMBER,
462: x_msg_data OUT NOCOPY VARCHAR2,
463: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
464: p_payment_type IN VARCHAR2,
465: p_amount IN NUMBER,
466: p_start_date IN DATE,
467: p_period IN NUMBER,

Line 477: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

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,
480: okc_line_styles_b ols
481: WHERE okl.dnz_chr_id = p_chr_id