APPS.OKL_TRANS_CONTRACTS_PVT dependencies on OKL_K_HEADERS

Line 63: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;

59: l_functional_currency okl_trx_contracts.currency_code%TYPE;
60:
61: -- Added by Santonyr on 22-Nov-2002 Multi-Currency
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:

Line 64: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;

60:
61: -- Added by Santonyr on 22-Nov-2002 Multi-Currency
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

Line 65: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;

61: -- Added by Santonyr on 22-Nov-2002 Multi-Currency
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

Line 80: FROM okl_k_headers

76:
77: CURSOR curr_csr (l_khr_id NUMBER) IS
78: SELECT currency_conversion_type, currency_conversion_rate,
79: currency_conversion_date
80: FROM okl_k_headers
81: WHERE id = l_khr_id;
82:
83: l_legal_entity_id NUMBER;
84:

Line 226: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;

222: l_tcnv_rec tcnv_rec_type := p_tcnv_rec;
223:
224: -- Added by Santonyr on 22-Nov-2002 Multi-Currency
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:

Line 227: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;

223:
224: -- Added by Santonyr on 22-Nov-2002 Multi-Currency
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;

Line 228: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;

224: -- Added by Santonyr on 22-Nov-2002 Multi-Currency
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:

Line 245: FROM okl_k_headers

241:
242: CURSOR curr_csr (l_khr_id NUMBER) IS
243: SELECT currency_conversion_type, currency_conversion_rate,
244: currency_conversion_date
245: FROM okl_k_headers
246: WHERE id = l_khr_id;
247:
248: --Added by dpsingh for LE Uptake
249: l_legal_entity_id NUMBER;