APPS.OKL_VR_DOCUMENT_PVT dependencies on OKL_TRX_TYPES_V

Line 195: l_trx_type_id Okl_Trx_Types_V.id%TYPE;

191: l_okl_trx_created VARCHAR2(1) := OKL_API.G_FALSE;
192: create_stream_invoice_failed EXCEPTION;
193:
194: -- 5033120
195: l_trx_type_id Okl_Trx_Types_V.id%TYPE;
196: l_trx_try_id Okl_Trx_Types_V.try_id%TYPE;
197: l_trx_desc Okl_Trx_Types_V.description%TYPE;
198:
199: l_tcn_type FND_LOOKUPS.lookup_code%TYPE;

Line 196: l_trx_try_id Okl_Trx_Types_V.try_id%TYPE;

192: create_stream_invoice_failed EXCEPTION;
193:
194: -- 5033120
195: l_trx_type_id Okl_Trx_Types_V.id%TYPE;
196: l_trx_try_id Okl_Trx_Types_V.try_id%TYPE;
197: l_trx_desc Okl_Trx_Types_V.description%TYPE;
198:
199: l_tcn_type FND_LOOKUPS.lookup_code%TYPE;
200: l_tcn_meaning FND_LOOKUPS.meaning%TYPE;

Line 197: l_trx_desc Okl_Trx_Types_V.description%TYPE;

193:
194: -- 5033120
195: l_trx_type_id Okl_Trx_Types_V.id%TYPE;
196: l_trx_try_id Okl_Trx_Types_V.try_id%TYPE;
197: l_trx_desc Okl_Trx_Types_V.description%TYPE;
198:
199: l_tcn_type FND_LOOKUPS.lookup_code%TYPE;
200: l_tcn_meaning FND_LOOKUPS.meaning%TYPE;
201: l_tcn_desc FND_LOOKUPS.description%TYPE;

Line 255: FROM okl_trx_types_v

251:
252:
253: CURSOR trx_type_csr (p_trx_name VARCHAR2) IS
254: SELECT id, try_id, description
255: FROM okl_trx_types_v
256: WHERE name = p_trx_name;
257:
258:
259: CURSOR fnd_lookup_csr (p_lookup_type VARCHAR2, p_lookup_code VARCHAR2) IS