106: resultout OUT NOCOPY VARCHAR2) IS
107:
108: l_id NUMBER;
109: l_LAST_UPDATED_BY NUMBER;
110: l_user WF_USERS.NAME%TYPE;
111: l_name WF_USERS.DESCRIPTION%TYPE;
112:
113:
114: -- get last_updated_by
107:
108: l_id NUMBER;
109: l_LAST_UPDATED_BY NUMBER;
110: l_user WF_USERS.NAME%TYPE;
111: l_name WF_USERS.DESCRIPTION%TYPE;
112:
113:
114: -- get last_updated_by
115: CURSOR l_assetreturn_csr(cp_asset_return_id IN NUMBER) IS
223: l_price_list_id NUMBER;
224: l_sysdate DATE;
225: invalid_item_info EXCEPTION;
226:
227: l_user WF_USERS.NAME%TYPE;
228: l_name WF_USERS.DESCRIPTION%TYPE;
229: l_last_updated_by NUMBER;
230: l_item_templ_id NUMBER;
231: BEGIN
224: l_sysdate DATE;
225: invalid_item_info EXCEPTION;
226:
227: l_user WF_USERS.NAME%TYPE;
228: l_name WF_USERS.DESCRIPTION%TYPE;
229: l_last_updated_by NUMBER;
230: l_item_templ_id NUMBER;
231: BEGIN
232: