182: l_trxH_out_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
183: l_trxL_in_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
184: l_trxL_out_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
185: l_acc_gen_primary_key_tbl Okl_Account_Generator_Pvt.primary_key_tbl;
186: l_meaning FND_LOOKUPS.meaning%TYPE;
187: l_description FND_LOOKUPS.description%TYPE;
188:
189: l_stream_created VARCHAR2(1) := OKL_API.G_FALSE;
190: l_strm_element_created VARCHAR2(1) := OKL_API.G_FALSE;
183: l_trxL_in_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
184: l_trxL_out_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
185: l_acc_gen_primary_key_tbl Okl_Account_Generator_Pvt.primary_key_tbl;
186: l_meaning FND_LOOKUPS.meaning%TYPE;
187: l_description FND_LOOKUPS.description%TYPE;
188:
189: l_stream_created VARCHAR2(1) := OKL_API.G_FALSE;
190: l_strm_element_created VARCHAR2(1) := OKL_API.G_FALSE;
191: l_okl_trx_created VARCHAR2(1) := OKL_API.G_FALSE;
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;
202:
203: l_tcl_type FND_LOOKUPS.lookup_code%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;
202:
203: l_tcl_type FND_LOOKUPS.lookup_code%TYPE;
204: l_tcl_meaning FND_LOOKUPS.meaning%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;
202:
203: l_tcl_type FND_LOOKUPS.lookup_code%TYPE;
204: l_tcl_meaning FND_LOOKUPS.meaning%TYPE;
205: l_tcl_desc FND_LOOKUPS.description%TYPE;
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;
202:
203: l_tcl_type FND_LOOKUPS.lookup_code%TYPE;
204: l_tcl_meaning FND_LOOKUPS.meaning%TYPE;
205: l_tcl_desc FND_LOOKUPS.description%TYPE;
206:
207: -- Bug 5964482 dpsingh SLA Uptake Project
200: l_tcn_meaning FND_LOOKUPS.meaning%TYPE;
201: l_tcn_desc FND_LOOKUPS.description%TYPE;
202:
203: l_tcl_type FND_LOOKUPS.lookup_code%TYPE;
204: l_tcl_meaning FND_LOOKUPS.meaning%TYPE;
205: l_tcl_desc FND_LOOKUPS.description%TYPE;
206:
207: -- Bug 5964482 dpsingh SLA Uptake Project
208: l_tcn_id NUMBER;
201: l_tcn_desc FND_LOOKUPS.description%TYPE;
202:
203: l_tcl_type FND_LOOKUPS.lookup_code%TYPE;
204: l_tcl_meaning FND_LOOKUPS.meaning%TYPE;
205: l_tcl_desc FND_LOOKUPS.description%TYPE;
206:
207: -- Bug 5964482 dpsingh SLA Uptake Project
208: l_tcn_id NUMBER;
209: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
257:
258:
259: CURSOR fnd_lookup_csr (p_lookup_type VARCHAR2, p_lookup_code VARCHAR2) IS
260: SELECT lookup_code, meaning, description
261: FROM fnd_lookups
262: WHERE lookup_code = p_lookup_code
263: AND lookup_type = p_lookup_type;
264:
265: --Added by dpsingh for LE Uptake