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_LEASE_APP_WF dependencies on OKL_LEASEAPP_TEMPL_VERSIONS_V

Line 448: l_lat_version_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE;

444: x_msg_data VARCHAR2(32767);
445:
446: l_user_name VARCHAR2(240);
447: l_application_id fnd_application.application_id%TYPE;
448: l_lat_version_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE;
449:
450: CURSOR c_get_lat_details(cp_lat_ver_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE) IS
451: SELECT LATV.NAME LAT_NAME
452: , LAVV.VERSION_NUMBER

Line 450: CURSOR c_get_lat_details(cp_lat_ver_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE) IS

446: l_user_name VARCHAR2(240);
447: l_application_id fnd_application.application_id%TYPE;
448: l_lat_version_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE;
449:
450: CURSOR c_get_lat_details(cp_lat_ver_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE) IS
451: SELECT LATV.NAME LAT_NAME
452: , LAVV.VERSION_NUMBER
453: , LAVV.VALID_FROM EFFECTIVE_FROM
454: , LAVV.VALID_TO EFFECTIVE_TO

Line 457: , OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV

453: , LAVV.VALID_FROM EFFECTIVE_FROM
454: , LAVV.VALID_TO EFFECTIVE_TO
455: , LAVV.VERSION_STATUS
456: FROM OKL_LEASEAPP_TEMPLATES LATV
457: , OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV
458: WHERE LAVV.LEASEAPP_TEMPLATE_ID = LATV.ID
459: AND LAVV.ID = cp_lat_ver_id;
460:
461: lp_lat_dtls_rec c_get_lat_details%ROWTYPE;

Line 821: l_lat_version_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE;

817: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
818: l_msg_data VARCHAR2(2000);
819: l_return_status VARCHAR2(1);
820:
821: l_lat_version_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE;
822:
823: l_result VARCHAR2(30);
824: lv_approval_status_ame VARCHAR2(30);
825:

Line 829: CURSOR c_get_ver_dtls ( cp_version_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE) IS

825:
826: l_lavv_rec lavv_rec_type;
827: lx_lavv_rec lavv_rec_type;
828:
829: CURSOR c_get_ver_dtls ( cp_version_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE) IS
830: SELECT LAVV.OBJECT_VERSION_NUMBER
831: FROM OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV
832: WHERE LAVV.ID = cp_version_id;
833: BEGIN

Line 831: FROM OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV

827: lx_lavv_rec lavv_rec_type;
828:
829: CURSOR c_get_ver_dtls ( cp_version_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE) IS
830: SELECT LAVV.OBJECT_VERSION_NUMBER
831: FROM OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV
832: WHERE LAVV.ID = cp_version_id;
833: BEGIN
834: -- RUN mode
835: IF (funcmode = 'RUN') THEN