DBA Data[Home] [Help]

APPS.OKL_CONTRACT_TOP_LINE_PVT dependencies on OKC_K_LINES_V

Line 1691: p_line_id IN OKC_K_LINES_V.ID%TYPE,

1687: x_return_status OUT NOCOPY VARCHAR2,
1688: x_msg_count OUT NOCOPY NUMBER,
1689: x_msg_data OUT NOCOPY VARCHAR2,
1690: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1691: p_line_id IN OKC_K_LINES_V.ID%TYPE,
1692: p_no_of_period IN NUMBER,
1693: p_frequency IN VARCHAR2,
1694: p_amount_per_period IN NUMBER
1695: ) IS

Line 1705: p_line_id OKC_K_LINES_V.ID%TYPE) IS

1701: l_id1 VARCHAR2(30);
1702: scscode OKC_K_HEADERS_B.SCS_CODE%TYPE ;
1703:
1704: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1705: p_line_id OKC_K_LINES_V.ID%TYPE) IS
1706: SELECT line.start_date,
1707: line.end_date,
1708: line.amount,
1709: line.capital_amount,

Line 2113: p_line_id IN OKC_K_LINES_V.ID%TYPE,

2109: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2110: x_return_status OUT NOCOPY VARCHAR2,
2111: x_msg_count OUT NOCOPY NUMBER,
2112: x_msg_data OUT NOCOPY VARCHAR2,
2113: p_line_id IN OKC_K_LINES_V.ID%TYPE,
2114: p_vendor_id IN NUMBER,
2115: p_payment_term IN VARCHAR2,
2116: p_payment_term_id IN NUMBER,
2117: p_pay_to_site IN VARCHAR2,

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

2133: l_api_name VARCHAR2(35) := 'validate_passthru_rule';
2134: l_proc_name VARCHAR2(35) := 'VALIDATE_PASSTHRU_RULE';
2135: l_api_version NUMBER := 1.0;
2136:
2137: CURSOR line_style_csr (p_line_id OKC_K_LINES_V.ID%TYPE) IS
2138: SELECT style.lty_code
2139: FROM okc_k_lines_b line,
2140: okc_line_styles_b style
2141: WHERE line.lse_id = style.id