DBA Data[Home] [Help]

APPS.OKL_VR_DOCUMENT_PVT dependencies on FND_LOOKUPS

Line 186: l_meaning FND_LOOKUPS.meaning%TYPE;

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;

Line 187: l_description FND_LOOKUPS.description%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;
191: l_okl_trx_created VARCHAR2(1) := OKL_API.G_FALSE;

Line 199: l_tcn_type FND_LOOKUPS.lookup_code%TYPE;

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;

Line 200: l_tcn_meaning FND_LOOKUPS.meaning%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;

Line 201: l_tcn_desc FND_LOOKUPS.description%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;

Line 203: l_tcl_type FND_LOOKUPS.lookup_code%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

Line 204: l_tcl_meaning FND_LOOKUPS.meaning%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
208: l_tcn_id NUMBER;

Line 205: l_tcl_desc FND_LOOKUPS.description%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;
209: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;

Line 261: FROM fnd_lookups

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