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_LEASE_APPLICATIONS_B

Line 626: l_la_id OKL_LEASE_APPLICATIONS_B.ID%TYPE;

622: l_object_name VARCHAR2(50);
623: l_name VARCHAR2(100);
624: l_rejected_message VARCHAR2(500);
625:
626: l_la_id OKL_LEASE_APPLICATIONS_B.ID%TYPE;
627: l_la_status OKL_LEASE_APPLICATIONS_B.APPLICATION_STATUS%TYPE;
628:
629: CURSOR c_get_la_status(cp_la_id OKL_LEASE_APPLICATIONS_B.ID%TYPE) IS
630: SELECT LAB.APPLICATION_STATUS

Line 627: l_la_status OKL_LEASE_APPLICATIONS_B.APPLICATION_STATUS%TYPE;

623: l_name VARCHAR2(100);
624: l_rejected_message VARCHAR2(500);
625:
626: l_la_id OKL_LEASE_APPLICATIONS_B.ID%TYPE;
627: l_la_status OKL_LEASE_APPLICATIONS_B.APPLICATION_STATUS%TYPE;
628:
629: CURSOR c_get_la_status(cp_la_id OKL_LEASE_APPLICATIONS_B.ID%TYPE) IS
630: SELECT LAB.APPLICATION_STATUS
631: FROM OKL_LEASE_APPLICATIONS_B LAB

Line 629: CURSOR c_get_la_status(cp_la_id OKL_LEASE_APPLICATIONS_B.ID%TYPE) IS

625:
626: l_la_id OKL_LEASE_APPLICATIONS_B.ID%TYPE;
627: l_la_status OKL_LEASE_APPLICATIONS_B.APPLICATION_STATUS%TYPE;
628:
629: CURSOR c_get_la_status(cp_la_id OKL_LEASE_APPLICATIONS_B.ID%TYPE) IS
630: SELECT LAB.APPLICATION_STATUS
631: FROM OKL_LEASE_APPLICATIONS_B LAB
632: WHERE LAB.ID = cp_la_id;
633:

Line 631: FROM OKL_LEASE_APPLICATIONS_B LAB

627: l_la_status OKL_LEASE_APPLICATIONS_B.APPLICATION_STATUS%TYPE;
628:
629: CURSOR c_get_la_status(cp_la_id OKL_LEASE_APPLICATIONS_B.ID%TYPE) IS
630: SELECT LAB.APPLICATION_STATUS
631: FROM OKL_LEASE_APPLICATIONS_B LAB
632: WHERE LAB.ID = cp_la_id;
633:
634: BEGIN
635: