eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VP_ASSOCIATIONS_PVT dependencies on OKL_LEASEAPP_TMPLS

Line 252: l_credit_class OKL_LEASEAPP_TMPLS.CUST_CREDIT_CLASSIFICATION%TYPE;

248: -- abindal start --
249: l_dummy VARCHAR2(1);
250: -- Manu 02-Sep-2005 remove references to APPLICATION_TYPE
251: -- l_application_type OKL_LEASEAPP_TEMPLATES_V.APPLICATION_TYPE%TYPE;
252: l_credit_class OKL_LEASEAPP_TMPLS.CUST_CREDIT_CLASSIFICATION%TYPE;
253: l_credit_purpose OKL_LEASEAPP_TMPLS.CREDIT_REVIEW_PURPOSE%TYPE;
254: -- l_sic_code OKL_LEASEAPP_TEMPLATES_V.APPLICATION_TYPE%TYPE;
255: l_sic_code OKL_LEASEAPP_TMPLS.INDUSTRY_CODE%TYPE;
256: l_agrmnt_name OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

Line 253: l_credit_purpose OKL_LEASEAPP_TMPLS.CREDIT_REVIEW_PURPOSE%TYPE;

249: l_dummy VARCHAR2(1);
250: -- Manu 02-Sep-2005 remove references to APPLICATION_TYPE
251: -- l_application_type OKL_LEASEAPP_TEMPLATES_V.APPLICATION_TYPE%TYPE;
252: l_credit_class OKL_LEASEAPP_TMPLS.CUST_CREDIT_CLASSIFICATION%TYPE;
253: l_credit_purpose OKL_LEASEAPP_TMPLS.CREDIT_REVIEW_PURPOSE%TYPE;
254: -- l_sic_code OKL_LEASEAPP_TEMPLATES_V.APPLICATION_TYPE%TYPE;
255: l_sic_code OKL_LEASEAPP_TMPLS.INDUSTRY_CODE%TYPE;
256: l_agrmnt_name OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
257: /* Manu 31-Aug-2005 Remove REFERENCE_NUMBER column */

Line 255: l_sic_code OKL_LEASEAPP_TMPLS.INDUSTRY_CODE%TYPE;

251: -- l_application_type OKL_LEASEAPP_TEMPLATES_V.APPLICATION_TYPE%TYPE;
252: l_credit_class OKL_LEASEAPP_TMPLS.CUST_CREDIT_CLASSIFICATION%TYPE;
253: l_credit_purpose OKL_LEASEAPP_TMPLS.CREDIT_REVIEW_PURPOSE%TYPE;
254: -- l_sic_code OKL_LEASEAPP_TEMPLATES_V.APPLICATION_TYPE%TYPE;
255: l_sic_code OKL_LEASEAPP_TMPLS.INDUSTRY_CODE%TYPE;
256: l_agrmnt_name OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
257: /* Manu 31-Aug-2005 Remove REFERENCE_NUMBER column */
258: -- l_appl_temp_name OKL_LEASEAPP_TEMPLATES_V.REFERENCE_NUMBER%TYPE;
259: l_appl_temp_name OKL_LEASEAPP_TMPLS.NAME%TYPE;

Line 259: l_appl_temp_name OKL_LEASEAPP_TMPLS.NAME%TYPE;

255: l_sic_code OKL_LEASEAPP_TMPLS.INDUSTRY_CODE%TYPE;
256: l_agrmnt_name OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
257: /* Manu 31-Aug-2005 Remove REFERENCE_NUMBER column */
258: -- l_appl_temp_name OKL_LEASEAPP_TEMPLATES_V.REFERENCE_NUMBER%TYPE;
259: l_appl_temp_name OKL_LEASEAPP_TMPLS.NAME%TYPE;
260: lv_change_type_code okl_vp_change_requests.change_type_code%TYPE;
261: -- abindal end --
262:
263: CURSOR check_duplicate_csr (p_chr_id NUMBER, p_assoc_obj_id NUMBER, p_start_date DATE, p_end_date DATE) IS

Line 291: FROM OKL_LEASEAPP_TMPLS

287: industry_code,
288: /* Manu 31-Aug-2005 Remove REFERENCE_NUMBER column */
289: -- reference_number
290: name
291: FROM OKL_LEASEAPP_TMPLS
292: WHERE id = cp_assoc_id;
293:
294: -- Manu 02-Sep-2005 remove references to APPLICATION_TYPE
295: CURSOR get_la_assoc_chr_rec(cp_chr_id IN NUMBER, -- cp_appl_type IN VARCHAR2,

Line 298: FROM OKL_LEASEAPP_TMPLS lat,

294: -- Manu 02-Sep-2005 remove references to APPLICATION_TYPE
295: CURSOR get_la_assoc_chr_rec(cp_chr_id IN NUMBER, -- cp_appl_type IN VARCHAR2,
296: cp_credit_class IN VARCHAR2, cp_credit_review IN VARCHAR2, cp_sic_code IN VARCHAR2)IS
297: SELECT 'X'
298: FROM OKL_LEASEAPP_TMPLS lat,
299: okl_vp_associations_v vpa
300: WHERE lat.id = vpa.assoc_object_id
301: AND vpa.assoc_object_type_code = 'LA_TEMPLATE'
302: AND vpa.chr_id = cp_chr_id

Line 311: FROM OKL_LEASEAPP_TMPLS lat,

307: -- Manu 02-Sep-2005 remove references to APPLICATION_TYPE
308: CURSOR get_la_assoc_crs_rec(cp_crs_id IN NUMBER, -- cp_appl_type IN VARCHAR2,
309: cp_credit_class IN VARCHAR2, cp_credit_review IN VARCHAR2, cp_sic_code IN VARCHAR2)IS
310: SELECT 'X'
311: FROM OKL_LEASEAPP_TMPLS lat,
312: okl_vp_associations_v vpa
313: WHERE lat.id = vpa.assoc_object_id
314: AND vpa.assoc_object_type_code = 'LA_TEMPLATE'
315: AND vpa.crs_id = cp_crs_id