831: END LOOP;
832: CLOSE C_GET_LIST_LINES;
833:
834: -- update object version NUMBER for shopping list
835: UPDATE IBE_SH_SHP_LISTS
836: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
837: WHERE SHP_LIST_ID = p_shop_list_ids(i)
838: AND OBJECT_VERSION_NUMBER = p_obj_ver_numbers(i);
839:
1070: END LOOP;
1071:
1072: -- dbms_output.put_line('now updating header');
1073: -- update object version NUMBER for shopping list
1074: UPDATE IBE_SH_SHP_LISTS
1075: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
1076: WHERE SHP_LIST_ID = l_shop_list_id;
1077:
1078: IF (SQL%NOTFOUND) THEN