104: IS
105: l_vendor_id NUMBER;
106: CURSOR l_cur IS
107: SELECT vendor_id
108: FROM pos_supplier_users_v
109: WHERE user_name = p_username;
110: BEGIN
111: OPEN l_cur;
112: FETCH l_cur INTO l_vendor_id;
119: IS
120: l_party_id NUMBER;
121: CURSOR l_cur IS
122: SELECT vendor_party_id
123: FROM pos_supplier_users_v
124: WHERE user_name = p_username;
125: BEGIN
126: OPEN l_cur;
127: FETCH l_cur INTO l_party_id;