DBA Data[Home] [Help]

APPS.OKL_TRANS_CONTRACTS_PVT dependencies on OKC_K_HEADERS_B

Line 7: FROM OKC_K_HEADERS_B

3:
4: --Added by dpsingh for LE Uptake
5: CURSOR get_contract_number(p_khr_id NUMBER) IS
6: SELECT CONTRACT_NUMBER
7: FROM OKC_K_HEADERS_B
8: WHERE ID = p_khr_id ;
9:
10: -- Added by Santonyr on 03-Dec-2002
11: -- This procedure makes sure that the sum of transaction line

Line 66: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

62:
63: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
64: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
65: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
66: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
67:
68: CURSOR try_csr IS
69: SELECT ID
70: FROM OKL_TRX_TYPES_TL

Line 229: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

225:
226: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
227: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
228: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
229: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
230:
231: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
232:
233: CURSOR try_csr IS