APPS.INV_SERIAL_NUMBER_PUB dependencies on MTL_GEN_OBJECT_ID_S

Line 276: SELECT mtl_gen_object_id_s.NEXTVAL

272:
273: RAISE fnd_api.g_exc_unexpected_error;
274: END;
275:
276: SELECT mtl_gen_object_id_s.NEXTVAL
277: INTO x_object_id
278: FROM DUAL;
279:
280: l_userid := fnd_global.user_id;

Line 525: SELECT mtl_gen_object_id_s.NEXTVAL

521: fnd_msg_pub.ADD;
522: RAISE fnd_api.g_exc_error;
523: END;
524:
525: SELECT mtl_gen_object_id_s.NEXTVAL
526: INTO x_object_id
527: FROM DUAL;
528:
529: -- invtrace('next genealogy object id from the sequence mtl_gen_object_id_s is ' || x_object_id);

Line 529: -- invtrace('next genealogy object id from the sequence mtl_gen_object_id_s is ' || x_object_id);

525: SELECT mtl_gen_object_id_s.NEXTVAL
526: INTO x_object_id
527: FROM DUAL;
528:
529: -- invtrace('next genealogy object id from the sequence mtl_gen_object_id_s is ' || x_object_id);
530: l_wms_installed :=
531: wms_install.check_install(
532: x_return_status => l_return_status
533: , x_msg_count => l_msg_count

Line 1508: SELECT mtl_gen_object_id_s.NEXTVAL

1504: l_userid := fnd_global.user_id;
1505: l_loginid := fnd_global.login_id;
1506: isunique := is_serial_unique(p_organization_id, p_inventory_item_id, l_cur_serial_number, x_msg_data);
1507: IF (isunique = 0) THEN
1508: SELECT mtl_gen_object_id_s.NEXTVAL
1509: INTO x_object_id
1510: FROM DUAL;
1511:
1512: INSERT INTO mtl_serial_numbers