APPS.OKL_LEASE_APP_WF dependencies on OKL_LEASE_APPLICATIONS_V

Line 168: l_lease_app_id OKL_LEASE_APPLICATIONS_V.ID%TYPE;

164: x_return_status VARCHAR2(1);
165: x_msg_count NUMBER;
166: x_msg_data VARCHAR2(32767);
167:
168: l_lease_app_id OKL_LEASE_APPLICATIONS_V.ID%TYPE;
169: l_user_name VARCHAR2(240);
170: l_application_id fnd_application.application_id%TYPE;
171:
172: CURSOR c_get_lease_app_details (cp_la_id OKL_LEASE_APPLICATIONS_V.ID%TYPE) IS

Line 172: CURSOR c_get_lease_app_details (cp_la_id OKL_LEASE_APPLICATIONS_V.ID%TYPE) IS

168: l_lease_app_id OKL_LEASE_APPLICATIONS_V.ID%TYPE;
169: l_user_name VARCHAR2(240);
170: l_application_id fnd_application.application_id%TYPE;
171:
172: CURSOR c_get_lease_app_details (cp_la_id OKL_LEASE_APPLICATIONS_V.ID%TYPE) IS
173: SELECT LAP.REFERENCE_NUMBER LEASE_APP_NAME
174: , LAP.APPLICATION_STATUS LEASE_APP_STATUS
175: , LAP.VALID_FROM EFFECTIVE_FROM
176: , LAP.VALID_TO EFFECTIVE_TO

Line 177: FROM OKL_LEASE_APPLICATIONS_V LAP

173: SELECT LAP.REFERENCE_NUMBER LEASE_APP_NAME
174: , LAP.APPLICATION_STATUS LEASE_APP_STATUS
175: , LAP.VALID_FROM EFFECTIVE_FROM
176: , LAP.VALID_TO EFFECTIVE_TO
177: FROM OKL_LEASE_APPLICATIONS_V LAP
178: WHERE LAP.ID = cp_la_id;
179:
180: l_lease_app_rec c_get_lease_app_details%ROWTYPE;
181: BEGIN

Line 767: l_lease_app_id OKL_LEASE_APPLICATIONS_V.ID%TYPE;

763: funcmode IN VARCHAR2,
764: resultout OUT NOCOPY VARCHAR2) IS
765: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_la_withdraw_details';
766:
767: l_lease_app_id OKL_LEASE_APPLICATIONS_V.ID%TYPE;
768:
769: BEGIN
770: -- RUN mode
771: IF (funcmode = 'RUN') THEN

Line 923: l_lease_app_id OKL_LEASE_APPLICATIONS_V.ID%TYPE;

919: l_msg_data VARCHAR2(2000);
920: l_return_status VARCHAR2(1);
921:
922: lv_approval_status_ame VARCHAR2(30);
923: l_lease_app_id OKL_LEASE_APPLICATIONS_V.ID%TYPE;
924:
925: BEGIN
926: -- RUN mode
927: IF (funcmode = 'RUN') THEN