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
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
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:
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: