DBA Data[Home] [Help]

APPS.OKL_CONTRACT_TOP_LINE_PVT dependencies on OKC_K_LINES_V

Line 1746: p_line_id IN OKC_K_LINES_V.ID%TYPE,

1742: x_return_status OUT NOCOPY VARCHAR2,
1743: x_msg_count OUT NOCOPY NUMBER,
1744: x_msg_data OUT NOCOPY VARCHAR2,
1745: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1746: p_line_id IN OKC_K_LINES_V.ID%TYPE,
1747: p_no_of_period IN NUMBER,
1748: p_frequency IN VARCHAR2,
1749: p_amount_per_period IN NUMBER
1750: ) IS

Line 1760: p_line_id OKC_K_LINES_V.ID%TYPE) IS

1756: l_id1 VARCHAR2(30);
1757: scscode OKC_K_HEADERS_B.SCS_CODE%TYPE ;
1758:
1759: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1760: p_line_id OKC_K_LINES_V.ID%TYPE) IS
1761: SELECT line.start_date,
1762: line.end_date,
1763: line.amount,
1764: line.capital_amount,

Line 2168: p_line_id IN OKC_K_LINES_V.ID%TYPE,

2164: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2165: x_return_status OUT NOCOPY VARCHAR2,
2166: x_msg_count OUT NOCOPY NUMBER,
2167: x_msg_data OUT NOCOPY VARCHAR2,
2168: p_line_id IN OKC_K_LINES_V.ID%TYPE,
2169: p_vendor_id IN NUMBER,
2170: p_payment_term IN VARCHAR2,
2171: p_payment_term_id IN NUMBER,
2172: p_pay_to_site IN VARCHAR2,

Line 2192: CURSOR line_style_csr (p_line_id OKC_K_LINES_V.ID%TYPE) IS

2188: l_api_name VARCHAR2(35) := 'validate_passthru_rule';
2189: l_proc_name VARCHAR2(35) := 'VALIDATE_PASSTHRU_RULE';
2190: l_api_version NUMBER := 1.0;
2191:
2192: CURSOR line_style_csr (p_line_id OKC_K_LINES_V.ID%TYPE) IS
2193: SELECT style.lty_code
2194: FROM okc_k_lines_b line,
2195: okc_line_styles_b style
2196: WHERE line.lse_id = style.id