889: IS
890: PRAGMA AUTONOMOUS_TRANSACTION;
891: CURSOR c_user( b_user_id NUMBER ) IS
892: SELECT RESOURCE_ID
893: FROM ASG_USER
894: WHERE USER_ID = b_user_id;
895: r_user c_user%ROWTYPE;
896: x_status VARCHAR2(30);
897: BEGIN
920: IS
921: PRAGMA AUTONOMOUS_TRANSACTION;
922: CURSOR c_user( b_user_id NUMBER ) IS
923: SELECT RESOURCE_ID
924: FROM ASG_USER
925: WHERE USER_ID = b_user_id;
926: r_user c_user%ROWTYPE;
927: x_status VARCHAR2(30);
928: BEGIN