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_PA_DATA_INTEGRITY dependencies on OKL_LEASEAPP_TMPLS

Line 411: FROM OKL_LEASEAPP_TMPLS temp,

407: -- Manu 01-Sep-2005 Change reference_number to name
408: CURSOR get_application_template_rec(cp_id IN NUMBER, cp_version IN NUMBER)IS
409: SELECT temp.name, --temp.reference_number,
410: vers.version_status
411: FROM OKL_LEASEAPP_TMPLS temp,
412: okl_leaseapp_templ_versions_v vers
413: WHERE temp.id = cp_id
414: AND vers.leaseapp_template_id = temp.id
415: -- Manu 02-Sep-2005 version changed to version_number

Line 510: FROM OKL_LEASEAPP_TMPLS

506: credit_review_purpose,
507: industry_code,
508: name,
509: industry_class
510: FROM OKL_LEASEAPP_TMPLS
511: WHERE id = cp_assoc_id;
512:
513: -- Cursor to find the duplicate record of lease application template with the combination of the parameters
514: -- application_type, cust_credit_classification, credit_review_purpose, sic_code.

Line 528: FROM OKL_LEASEAPP_TMPLS lat,

524: cp_industry_class IN VARCHAR2,
525: cp_start_date IN DATE,
526: cp_end_date IN DATE)IS
527: SELECT lat.name
528: FROM OKL_LEASEAPP_TMPLS lat,
529: okl_vp_associations_v vpa,
530: okc_k_headers_b chr,
531: okc_statuses_b sts
532: WHERE lat.id = vpa.assoc_object_id

Line 550: FROM OKL_LEASEAPP_TMPLS lat,

546: (trunc(NVL(cp_end_date,okl_accounting_util.g_final_date)) BETWEEN trunc(vpa.start_date) AND TRUNC(NVL(vpa.end_date,okl_accounting_util.g_final_date)))
547: )
548: UNION
549: SELECT lat.name
550: FROM OKL_LEASEAPP_TMPLS lat,
551: okl_vp_associations_v vpa,
552: okl_vp_change_requests chreq
553: WHERE lat.id = vpa.assoc_object_id
554: AND vpa.assoc_object_type_code = 'LA_TEMPLATE'

Line 570: FROM OKL_LEASEAPP_TMPLS lat,

566: )
567: AND chreq.status_code in ('PASSED','NEW','INCOMPLETE')
568: UNION
569: SELECT lat.name
570: FROM OKL_LEASEAPP_TMPLS lat,
571: okl_vp_associations_v vpa,
572: okl_vp_change_requests chreq,
573: okl_k_headers okl
574: WHERE lat.id = vpa.assoc_object_id

Line 626: l_credit_class OKL_LEASEAPP_TMPLS.CUST_CREDIT_CLASSIFICATION%TYPE;

622:
623: l_dummy VARCHAR2(1);
624: -- Manu 02-Sep-2005 remove references to APPLICATION_TYPE
625: -- l_application_type OKL_LEASEAPP_TEMPLATES_V.APPLICATION_TYPE%TYPE;
626: l_credit_class OKL_LEASEAPP_TMPLS.CUST_CREDIT_CLASSIFICATION%TYPE;
627: l_credit_purpose OKL_LEASEAPP_TMPLS.CREDIT_REVIEW_PURPOSE%TYPE;
628: l_sic_code OKL_LEASEAPP_TMPLS.INDUSTRY_CODE%TYPE;
629: -- Manu 01-Sep-2005 Change REFERENCE_NUMBER to NAME
630: -- l_appl_temp_name OKL_LEASEAPP_TEMPLATES_V.REFERENCE_NUMBER%TYPE;

Line 627: l_credit_purpose OKL_LEASEAPP_TMPLS.CREDIT_REVIEW_PURPOSE%TYPE;

623: l_dummy VARCHAR2(1);
624: -- Manu 02-Sep-2005 remove references to APPLICATION_TYPE
625: -- l_application_type OKL_LEASEAPP_TEMPLATES_V.APPLICATION_TYPE%TYPE;
626: l_credit_class OKL_LEASEAPP_TMPLS.CUST_CREDIT_CLASSIFICATION%TYPE;
627: l_credit_purpose OKL_LEASEAPP_TMPLS.CREDIT_REVIEW_PURPOSE%TYPE;
628: l_sic_code OKL_LEASEAPP_TMPLS.INDUSTRY_CODE%TYPE;
629: -- Manu 01-Sep-2005 Change REFERENCE_NUMBER to NAME
630: -- l_appl_temp_name OKL_LEASEAPP_TEMPLATES_V.REFERENCE_NUMBER%TYPE;
631: l_appl_temp_name OKL_LEASEAPP_TMPLS.NAME%TYPE;

Line 628: l_sic_code OKL_LEASEAPP_TMPLS.INDUSTRY_CODE%TYPE;

624: -- Manu 02-Sep-2005 remove references to APPLICATION_TYPE
625: -- l_application_type OKL_LEASEAPP_TEMPLATES_V.APPLICATION_TYPE%TYPE;
626: l_credit_class OKL_LEASEAPP_TMPLS.CUST_CREDIT_CLASSIFICATION%TYPE;
627: l_credit_purpose OKL_LEASEAPP_TMPLS.CREDIT_REVIEW_PURPOSE%TYPE;
628: l_sic_code OKL_LEASEAPP_TMPLS.INDUSTRY_CODE%TYPE;
629: -- Manu 01-Sep-2005 Change REFERENCE_NUMBER to NAME
630: -- l_appl_temp_name OKL_LEASEAPP_TEMPLATES_V.REFERENCE_NUMBER%TYPE;
631: l_appl_temp_name OKL_LEASEAPP_TMPLS.NAME%TYPE;
632: lv_industry_class OKL_LEASEAPP_TMPLS.industry_class%TYPE;

Line 631: l_appl_temp_name OKL_LEASEAPP_TMPLS.NAME%TYPE;

627: l_credit_purpose OKL_LEASEAPP_TMPLS.CREDIT_REVIEW_PURPOSE%TYPE;
628: l_sic_code OKL_LEASEAPP_TMPLS.INDUSTRY_CODE%TYPE;
629: -- Manu 01-Sep-2005 Change REFERENCE_NUMBER to NAME
630: -- l_appl_temp_name OKL_LEASEAPP_TEMPLATES_V.REFERENCE_NUMBER%TYPE;
631: l_appl_temp_name OKL_LEASEAPP_TMPLS.NAME%TYPE;
632: lv_industry_class OKL_LEASEAPP_TMPLS.industry_class%TYPE;
633: lv_leaseapp_tmpt_name OKL_LEASEAPP_TMPLS.name%TYPE;
634: BEGIN
635:

Line 632: lv_industry_class OKL_LEASEAPP_TMPLS.industry_class%TYPE;

628: l_sic_code OKL_LEASEAPP_TMPLS.INDUSTRY_CODE%TYPE;
629: -- Manu 01-Sep-2005 Change REFERENCE_NUMBER to NAME
630: -- l_appl_temp_name OKL_LEASEAPP_TEMPLATES_V.REFERENCE_NUMBER%TYPE;
631: l_appl_temp_name OKL_LEASEAPP_TMPLS.NAME%TYPE;
632: lv_industry_class OKL_LEASEAPP_TMPLS.industry_class%TYPE;
633: lv_leaseapp_tmpt_name OKL_LEASEAPP_TMPLS.name%TYPE;
634: BEGIN
635:
636: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 633: lv_leaseapp_tmpt_name OKL_LEASEAPP_TMPLS.name%TYPE;

629: -- Manu 01-Sep-2005 Change REFERENCE_NUMBER to NAME
630: -- l_appl_temp_name OKL_LEASEAPP_TEMPLATES_V.REFERENCE_NUMBER%TYPE;
631: l_appl_temp_name OKL_LEASEAPP_TMPLS.NAME%TYPE;
632: lv_industry_class OKL_LEASEAPP_TMPLS.industry_class%TYPE;
633: lv_leaseapp_tmpt_name OKL_LEASEAPP_TMPLS.name%TYPE;
634: BEGIN
635:
636: l_debug_enabled := okl_debug_pub.check_log_enabled;
637: