720: l_approved_message VARCHAR2(500);
721: l_rejected_message VARCHAR2(500);
722: l_reminder_message VARCHAR2(500);
723: l_user_name VARCHAR2(240);
724: l_application_id fnd_application.application_id%TYPE;
725: l_parent_code VARCHAR2(20);
726: l_parent_id NUMBER;
727:
728: CURSOR c_fetch_quote_number(p_quote_id OKL_LEASE_QUOTES_V.ID%TYPE)
739: -- Get the valid application id from FND
740:
741: CURSOR c_get_app_id_csr IS
742: SELECT APPLICATION_ID
743: FROM FND_APPLICATION
744: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
745:
746:
747: CURSOR get_lease_app(lease_app_id IN NUMBER) IS